MS Excel MCQs with Answers

In MS Excel, which methods can be used to copy data or formulas?

• A.Using the Fill Handle
• B.Using Copy and Paste commands
• C.Using the Ctrl+D (Fill Down) shortcut
• D.All of these

In MS Excel, which symbol is used to indicate a range of cells between two endpoints?

• A.Semicolon (;)
• B.Single colon (:)
• C.Comma (,)
• D.Hyphen (-)

What does MS Excel stand for?

• A.Microsoft Excel
• B.Micro Software Excel
• C.Multi System Excel
• D.Master Spreadsheet Excel

Which of the following best describes functions in MS Excel?

• A.Data validation rules
• B.Custom macros
• C.Cell references
• D.Built-in formulas

Which command in MS Excel can be used to immediately restore a record that was accidentally erased?

• A.Replace
• B.Redo
• C.Repeat
• D.Undo

In MS Excel, how can cells be uniquely identified?

• A.By row numbers only
• B.By column letters and row numbers
• C.By cell color and font style
• D.By sheet name only

In which menu is the conditional formatting option available in MS Excel 2016?

• A.Formulas
• B.Insert
• C.Data
• D.Home

How can you move a sheet from one workbook to a new workbook in MS Excel?

• A.Drag the sheet tab and drop it onto the desktop to create a new workbook
• B.Right-click the sheet tab, select Delete, then open a new workbook and paste
• C.Use the File menu, select Export, choose Sheet, and save as a new workbook
• D.Use the Edit menu, select Move or Copy, choose (new book) from To Book list, and click OK

Which version of MS Excel is the most recent as of 2021?

• A.Excel 2019
• B.Excel 2021
• C.Excel 365
• D.Excel 2016

In Microsoft Excel, can you set a page border?

• A.Yes, via Page Layout → Page Borders
• B.Yes, via Insert → Borders
• C.No, Excel does not support page borders
• D.Yes, via Format → Page Border