Free MS Office MCQs with Answers

51. In which MS Office version Screenshot is given?

• A. MS Office 2003
• B. MS Office 2007
• C. MS Office 2010
• D. None of these

Explanation: The Screenshot command was added to Microsoft Office 2010 and appears on the Insert tab. Office 2003 and 2007 do not provide this built-in command.

52. What is the maximum font size you can apply for any character in Ms Word?

• A. 160 pt
• B. 163 pt
• C. 1638 pt
• D. 16038 pt

Explanation: Word accepts font sizes from 1 through 1638 points, making 1638 pt the maximum value for a character. The larger numbers listed are not valid Word font-size limits.

53. Shift+Alt+D is used to __________?

• A. Insert the database
• B. Insert the previous data
• C. Insert the D drive
• D. Insert the current date

Explanation: In Microsoft Word, Shift+Alt+D inserts the current date at the cursor position. It does not insert a drive, database, or previously entered data.

54. Which shortcut key will shutdown your computer?

• A. Alt+F4
• B. Ctrl+F5
• C. Ctrl+F4
• D. Alt+F5

Explanation: Alt+F4 closes the active window, and when the desktop is active it opens the Windows shutdown option, which is why it is commonly taught as the shutdown shortcut. Ctrl+F4 generally closes the current document or child window within an application.

55. In MS Excel, which of the following functions can be used to remove all spaces from a text string except for single spaces between words?

• A. TRIM
• B. SUBSTITUTE
• C. CLEAN
• D. REPT

Explanation: TRIM removes leading and trailing spaces and reduces multiple spaces between words to single spaces. CLEAN removes non-printing characters, while SUBSTITUTE replaces specified text rather than automatically normalizing whitespace.

56. Which Excel feature allows you to freeze rows and columns so they remain visible while scrolling?

• A. Lock Cells
• B. Freeze Panes
• C. Hide Rows/Columns
• D. Split Window

Explanation: Freeze Panes keeps selected rows or columns visible while the rest of the worksheet is scrolled. Lock Cells protects cells from editing, whereas Split Window only divides the worksheet view.

57. In Excel, Conditional formatting is in: ______________?

• A. Insert Tab
• B. Page layout
• C. View Tab
• D. Home Tab

Explanation: In Excel, Conditional Formatting is found on the Home tab, where it applies visual rules to cell values. Insert is used for items such as charts and tables.

58. The purpose of Thesaurus tool is used in MS word?

• A. Grammar options
• B. Spelling Checking
• C. Synonyms and Antonyms
• D. Replace

Explanation: Word's Thesaurus suggests words with similar or opposite meanings, including synonyms and antonyms. Grammar and spelling are handled by separate proofing tools.

59. In a computer spreadsheet, function which is used to count numbers of entries in given range is called __________ ?

• A. Length
• B. Counter
• C. Count
• D. None of These

Explanation: The COUNT function counts cells containing numbers in a specified range, whereas COUNTA counts non-empty cells of various types. Length and Counter are not the standard Excel function for this task.

60. What does the term "filter" refer to in Excel?

• A. To permanently delete rows or columns
• B. To format the appearance of cells
• C. To temporarily hide certain data based on specific criteria
• D. To create a chart

Explanation: Excel's Filter displays only rows that meet selected criteria while temporarily hiding the others. It does not delete the hidden data permanently or create charts.