ELEVATE SKILLS!
Q: 1 Which of the following is open command in MS Office?
Tab+O
Ctrl+O
Alt+O
Shift+O
[ Option B ]
Pressing Ctrl+O opens the “Open” dialog box in all major MS Office programs, enabling you to browse and select a file to open.
Q: 2 Which of the following is not a type of spreadsheet program?
Google Sheets
Rose Symphony
Zoho Sheet
Microsoft Excel
[ Option B ]
A spreadsheet program is a software application used to organize, analyse, and store data in tabular form.
Google Sheets, Zoho Sheet, and Microsoft Excel are well-known spreadsheet programs, but Rose Symphony is an office suite that does not include a standard spreadsheet application.
Q: 3 Which of the following function display current system date in spreadsheet?
Today [ ]
Today ( )
Today { }
Today @
[ Option B ]
The "Today()" function is used in Excel, Google Sheets, and most spreadsheet applications to display the current date based on the system clock. The date will automatically update each time the spreadsheet is opened or recalculated.
| FUNCTION | PURPOSE | SYNTAX | EXAMPLE | OUTPUT |
|---|---|---|---|---|
| TODAY() | Returns the current system date (updates automatically each day). Does not show time. | =TODAY() | =TODAY() | 05-Sep-2025 |
| NOW() | Returns the current system date and time. Updates whenever the sheet recalculates. | =NOW() | =NOW() | 05-Sep-2025 08:30 |
| DATE() | Used to create a specific date by providing year, month, and day as inputs. | =DATE(year, month, day) | =DATE(1998, 4, 11) | 11-Apr-1998 |
| TIME() | Used to create a specific time by providing hours, minutes, and seconds as inputs. | =TIME(hour, minute, second) | =TIME(8, 30, 0) | 08:30 AM |
| DAY() | Extracts the day of the month (1–31) from a date. | =DAY(date) | =DAY("25-May-2025") | 25 |
| MONTH() | Extracts the month number (1–12) from a date. | =MONTH(date) | =MONTH("21-Sep-2025") | 9 |
| YEAR() | Extracts the year from a date. | =YEAR(date) | =YEAR("15-Sep-2024") | 2024 |
| WEEKDAY() | Returns the day of the week as a number. By default 1 = Sunday and 7 = Saturday. | =WEEKDAY(date) | =WEEKDAY("21-Sep-2025") | 1 (Sunday) |
Q: 4 In MS Office, which of the following shortcut key is used to open the font preference window?
Ctrl + K
Ctrl + L
Ctrl + D
Ctrl + C
[ Option C ]
In MS Office applications like Word, Excel, and PowerPoint, the shortcut Ctrl + D opens the Font preference window. This window allows users to customize font settings such as font type, size, style (bold, italic), color, and other text effects quickly without navigating through menus.
The shortcut key Ctrl + K inserts hyperlinks, Ctrl + L aligns text left, and Ctrl + C is used for copying text.
Q: 5 Which software is used for designing presentation on any project?
MS-Word
MS-Excel
MS-PowerPoint
MS-Access
[ Option C ]
MS-PowerPoint is a presentation software developed by Microsoft. It is specifically used to create slideshows for projects, reports, or any presentation.
Q: 6 Which one is a spreadsheet program in MS Office?
MS Outlook
MS Powerpoint
MS Word
MS Excel
[ Option D ]
A spreadsheet program is software that organizes data into rows and columns, allowing users to perform calculations, create charts, and analyze data. The spreadsheet program in MS Office is MS Excel.
| APPLICATION | PURPOSE |
|---|---|
| MS Word | Word Processing (Document), create and edit documents, letters, reports. |
| MS Excel | Spreadsheet Program, manage data, perform calculations, create charts. |
| MS PowerPoint | Presentation Tool, design and present slides with text, images, and animations. |
| MS Outlook | Email Client, manage emails, calendar, contacts, scheduling. |
| MS Access | Database Management, store, query, and manage structured data. |
| MS OneNote | Digital Notebook, organize notes, drawings, and ideas. |
| MS Publisher | Desktop Publishing, design brochures, flyers, newsletters. |
Q: 7 What is the shortcut key for the central alignment of a line or text in MS office software?
Ctrl + X
Ctrl + Alt + S
Ctrl + W
Ctrl + E
[ Option D ]
Text alignment determines how text is positioned within a paragraph or document.
| SHORTCUT | ACTION |
|---|---|
| Ctrl + L | Left-align text. |
| Ctrl + R | Right-align text. |
| Ctrl + E | Center-align text. |
| Ctrl + J | Justify text. |
| Ctrl + X | Cut selected text or object. |
| Ctrl + Alt + S | Split window in Word. |
| Ctrl + W | Close document. |
Q: 8 Which of the following is used to reduce the font size?
Ctrl + ]
Ctrl + [
Ctrl + Shift + <
Both (b) and (c)
[ Option D ]
In MS Word, font size can be increased or decreased using keyboard shortcuts:
| SHORTCUT KEY | ACTION |
|---|---|
| Ctrl + ] | Increase Font Size by 1 point. |
| Ctrl + [ | Decrease Font Size by 1 point. |
| Ctrl + Shift + > | Increase Font Size to the next smaller predefined value. |
| Ctrl + Shift + < | Decrease Font Size to the next larger predefined value. |
Q: 9 The oldest spreadsheet package is-
VisiCalc
Lotus 1-2-3
MS Excel
StarCalc
[ Option A ]
VisiCalc, released in 1979 for the Apple II computer, is recognized as the first spreadsheet software package.
Q: 10 What is the maximum font size which can be applied for any character?
163
168
1638
16038
[ Option C ]
In Microsoft Office applications like Word, Excel, and PowerPoint, you can manually enter font sizes beyond the preset dropdown list. The maximum font size that can be applied to any character is 1638 points.
| FONT SIZE TYPE | VALUE | DESCRIPTION |
|---|---|---|
| Minimum Font Size | 1 pt | Smallest size allowed for any character. |
| Default Font Size | 11 pt | Default in Word, Excel, PowerPoint. |
| Maximum Font Size | 1638 pt | Largest size allowed for any character. |
Q: 11 Which of the following is shortcut command for print in MS Office?
Alt+P
Shift+P
Ctrl+P
Alt+Ctrl+P
[ Option C ]
| Action | Shortcut Key |
|---|---|
| New Document | Ctrl + N |
| Open Existing File | Ctrl + O |
| Save File | Ctrl + S |
| Save As | F12 or Alt + F, A |
| Ctrl + P | |
| Close File but keep application open | Ctrl + W |
| Exit application | Alt + F4 |
| Undo | Ctrl + Z |
| Redo / Repeat | Ctrl + Y |
| Cut | Ctrl + X |
| Copy | Ctrl + C |
| Paste | Ctrl + V |
| Select All | Ctrl + A |
| Find | Ctrl + F |
| Replace | Ctrl + H |
| Bold | Ctrl + B |
| Italic | Ctrl + I |
| Underline | Ctrl + U |
| Increase Font Size | Ctrl + Shift + > |
| Decrease Font Size | Ctrl + Shift + < |
| Open Spell Check | F7 |
| Go to Beginning | Ctrl + Home |
| Go to End | Ctrl + End |
| Switch Between Open Documents | Ctrl + F6 (Next) Ctrl + Shift + F6 (Previous) |
| Switch Between Open Applications | Alt + Tab |
| Insert Hyperlink | Ctrl + K |
| Open Help | F1 |
Q: 12 Which of the following shortcut keys insert a hyperlink in MS Office?
Ctrl + K
Ctrl + M
Ctrl + J
Ctrl + D
[ Option A ]
In this section, you will find detailed explanations for similar types of questions. Thank you.
Q: 13 Which among the following key is used for checking grammar and spelling in MS Office?
F1
F2
F9
F7
[ Option D ]
| Key | Common Use |
|---|---|
| F1 | Opens Help menu in most programs. |
| F2 | Renames files or edits active cell in Excel. |
| F7 | Checks spelling and grammar in MS Office programs. |
| F9 | Updates fields in Word or recalculates formulas in Excel. |
Q: 14 Concatenation of text can be done using-
Apostrophe (‘)
Hash (#)
Exclamation (!)
Ampersand (&)
[ Option D ]
In Microsoft Office applications like Excel and Word, the ampersand (&) symbol is used to concatenate or join the strings. For example, if cell A1 contains "Suraku" and cell B1 contains "Academy", then the formula =A1 & B1 will return "SurakuAcademy".
| SYMBOL | USAGE |
|---|---|
| & (Ampersand) | Concatenation two or more text strings. |
| ‘ (Apostrophe) | Indicates that the entry is text, even if it looks like a number or formula. |
| # (Hash) | Error indicator in cells. |
| ! (Exclamation) | Used in sheet references. |
| $ (Dollar) | Absolute cell reference. |
| : (Colon) | Range operator. |
Thank you so much for taking the time to read my Computer Science MCQs section carefully. Your support and interest mean a lot, and I truly appreciate you being part of this journey. Stay connected for more insights and updates! If you'd like to explore more tutorials and insights, check out my YouTube channel.
Don’t forget to subscribe and stay connected for future updates.
| Student Name | |
|---|---|
| College |
| What's Say |
|---|