Free MS Office MCQs with Answers

71. What is a shortcut key of "Change the font' in MS Word?

• A. Ctrl + Shift + F
• B. Alt + shift + F
• C. Alt + F
• D. None of These

Explanation: Ctrl+Shift+F opens the font-selection control in Word, allowing the font type to be changed. Ctrl+F alone is used for finding text, so it is not the shortcut described.

72. What is the function of the VLOOKUP function in Excel?

• A. To perform a vertical lookup and return a value based on a specified criteria
• B. To perform a horizontal lookup and return a value based on a specified criteria
• C. To add up a range of cells
• D. To find the average of a range of cells

Explanation: VLOOKUP searches vertically down the first column of a table and returns a related value from a specified column in the same row. HLOOKUP performs the corresponding horizontal search.

73. What is the function of the IF function in Excel?

• A. To perform a logical test and return a value based on the result
• B. To add up a range of cells
• C. To find the average of a range of cells
• D. To count the number of cells in a range

Explanation: IF evaluates a logical condition and returns one result when the condition is true and another when it is false. SUM, AVERAGE, and COUNT perform the other listed calculation types.

74. What is the function of the SUM function in Excel?

• A. To add up a range of cells
• B. To find the average of a range of cells
• C. To count the number of cells in a range
• D. To find the maximum value in a range of cells

Explanation: SUM adds the numeric values in a selected range of cells. AVERAGE, COUNT, and MAX respectively calculate the mean, number of entries, and largest value.

75. What is the intersection of a column and row called in Excel?

• A. A cell
• B. A range
• C. A column header
• D. A row header

Explanation: The point where a row and a column meet is called a cell, identified by a reference such as B4. A range is a group of cells, while headers label rows or columns.

76. Title bar in MS-Excel displays name of the __________ ?

• A. Worksheet
• B. Workbook
• C. Formula
• D. Location

Explanation: The Excel title bar displays the name of the active workbook, such as Book1 or Budget.xlsx. A worksheet is an individual sheet inside that workbook.

77. in MS-Excel__________ short cut key is used for hiding rows.

• A. Ctrl+H
• B. Ctrl+7
• C. Ctrl+9
• D. None of the above

Explanation: Ctrl+9 hides the selected rows in Excel, while Ctrl+0 hides columns. Ctrl+H opens Find and Replace rather than hiding rows.

78. Which of following is not an element of computer spreadsheet interface?

• A. Pencil work
• B. Active cell
• C. Menu bar
• D. Workbook

Explanation: Pencil work is not a standard element of a spreadsheet interface. The active cell, menu bar, and workbook are all valid spreadsheet concepts or interface components.

79. Computer spreadsheet capability to allow a pie chart to be generated from data in spreadsheet cells is termed as __________ ?

• A. Decoration
• B. Data appearance
• C. Functions
• D. Charting

Explanation: Charting is the spreadsheet capability of representing cell data graphically, including through pie charts. Decoration and data appearance do not name this specific spreadsheet function.

80. What is a cell in Excel?

• A. A row
• B. A column
• C. A unit of data
• D. A unit of formatting

Explanation: A cell is the basic unit at which a spreadsheet stores data, formed by the intersection of a row and a column. It is not itself an entire row, column, or merely a formatting unit.