MS Excel MCQs with Answers

What is the default page orientation when creating a new worksheet in MS Excel?

• A.Legal
• B.Landscape
• C.Portrait
• D.A3

In MS Excel, what is the term used to refer to the cell that is currently selected for data entry?

• A.Focused cell
• B.Current cell
• C.Active cell
• D.Highlighted cell

Which of the following actions will activate a cell in MS Excel?

• A.Clicking on the cell
• B.Pressing arrow keys to move to the cell
• C.Typing the cell reference in the Name Box
• D.All of these

In MS Excel, what are the individual sheets within a workbook commonly called?

• A.Documents
• B.Spreadsheets
• C.Worksheets
• D.Slides

In which tab of MS Excel can you find the AutoSum button?

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

How can you split a column into multiple columns in MS Excel?

• A.Select the cell, go to Formulas Tab, then choose Divide Column
• B.Select the cell, go to Home Tab, then choose Split Cells
• C.Select the cell, go to Insert Tab, then choose Column Break
• D.Select the cell, go to Data Tab, then choose Text to Column

What does the SUM function in Excel do when used as =SUM(A1:A5)?

• A.Finds the maximum value from A1 to A5
• B.Calculates the average from A1 to A5
• C.Counts the number of cells from A1 to A5
• D.Calculates the sum from A1 to A5

Past Paper MCQ

What should be added before a fraction in Excel to prevent it from being interpreted as a date?

• A.Zero space
• B.Apostrophe (')
• C.Equal sign (=)
• D.Hash symbol (#)

How can you activate a cell in MS Excel?

• A.By pressing the Tab key
• B.By pressing the Enter key
• C.By typing in the formula bar
• D.By clicking the cell

In MS Excel 2016, where can you find the Print Title option?

• A.Page Layout menu
• B.Home tab
• C.Insert tab
• D.Data tab