MS Excel MCQs – PITS Module

What is the primary purpose of a spreadsheet?

• Storing images and graphics

• Organizing, analyzing, and calculating data

• Sending emails

• Designing presentations

In Excel, a workbook can contain:

• Only one worksheet

• Only charts

• Multiple worksheets

• Only formulas

Which tab contains the Font group where you can change text color, size, and style?

• Insert

• View

• Data

• Home

What is the intersection of a row and a column called?

• Cell

• Range

• Tab

• Sheet

Which of the following is NOT a valid method of entering data in Excel?

• In an active cell

• In the title bar

• In the formula bar

• Double-clicking the cell

What key do you press to move to the next cell on the right when entering data?

• Enter

• Ctrl

• Tab

• Esc

To create a new workbook, which menu option should you click first?

• Insert

• Data

• File

• View

Which of the following actions is performed by the “Undo” button?

• Saves the document

• Repeats last action

• Reverts the most recent change

• Exits Excel

To select an entire row in Excel, what should you click?

• The column header

• The row number

• The status bar

• The formula bar

Where do you click to insert new rows or columns?

• Editing group

• Formula tab

• Cells group on the Home tab

• Review tab