Free MS Office MCQs with Answers

81. In excel columns are labelled as____________?

• A. A, B, C, etc.
• B. 1, 2, 3, etc.
• C. A1, A2, A3, etc.
• D. $A$1, $A$2, etc.

Explanation: Excel labels columns with letters such as A, B, and C, while rows are labelled with numbers such as 1, 2, and 3. A1 is a cell reference combining a column letter with a row number.

82. which of the following is not a valid Zoom percentage in Excel?

• A. 10
• B. 100
• C. 300
• D. 500Spreadsheet Software

Explanation: Excel allows zoom levels from 10% to 400%, so 500% is outside the valid range. The other listed percentages fall within that range.

83. User developed instruction for excel are called__________?

• A. Progrms
• B. Macros
• C. Procedured
• D. All of these

Explanation: Macros are user-created instructions or small programs that automate repeated Excel tasks. “Programs” is too general, while the other spellings do not identify the Excel feature.

84. Which function calculates the largest value in a set of numbers in Excel?

• A. Average
• B. Count
• C. Minimum
• D. Maximum

Explanation: The MAX function returns the largest number in a selected set. MIN returns the smallest value, while AVERAGE calculates the mean and COUNT counts numeric entries.

85. What displays the content of active cell?

• A. Name box
• B. Row headings
• C. Formula bar
• D. None of these

Explanation: The formula bar shows the value or formula contained in the active cell and allows it to be edited. The Name Box identifies the cell address, such as A1.

86. In a computer spreadsheet, block of cells is called __________ ?

• A. Workbook
• B. Function
• C. Column
• D. Range

Explanation: A range is a group or block of cells, such as A1:C5. A workbook is the complete Excel file, not merely a selection of cells.

87. Microsoft Excel 2019 files have a default extension of___________?

• A. .Xlsx
• B. .Xls
• C. .excel
• D. .123Spreadsheet Software

Explanation: Excel 2019 uses the Office Open XML workbook format, whose default extension is .xlsx. The older .xls extension was mainly used by earlier Excel versions.

88. In a computer spreadsheet, SUM, AVERAGE, MIN and MAX are examples of __________ ?

• A. Calculations
• B. Formulas
• C. Functions
• D. Relative addressing

Explanation: SUM, AVERAGE, MIN and MAX are built-in Excel functions that perform standard calculations. A formula may use these functions, but the functions themselves are the named operations.

89. Ctrl+Shift+1 shortcut Keys in excel are used to __________?

• A. Format number in comma format
• B. Format number in currency format
• C. Format number in date format
• D. Format number in time format

Explanation: Ctrl+Shift+1 applies Excel's comma-style number format, normally showing thousands separators and two decimal places. Currency, date and time formats use different shortcuts.

90. Which Shortcut keys are used to strikethrough highlighted selection in Excel?

• A. Ctrl+4
• B. Ctrl+5
• C. Ctrl+6
• D. None of the above.

Explanation: Ctrl+5 applies or removes strikethrough formatting on the selected Excel cells. Ctrl+4 is associated with underline formatting, not strikethrough.