Excel Quiz

What is the keyboard shortcut for opening a new Excel workbook?

• Ctrl + N

• Ctrl + O

• Ctrl + S

• Ctrl + P

What does the term 'cell reference' in Excel mean?

• The phone number associated with a cell

• The address or location of a cell in a worksheet

• A reference to another workbook

• The content of a cell

Which file extension is associated with Excel workbooks?

• .docx

• .xlsx*

• .pptx

• .pdf

How do you insert a new worksheet in Excel?

• Right-click in an active cell and choose Insert Worksheet

• Press Ctrl+W

• Go to the Home tab, click on Insert, and choose Worksheet*

• Right-click on an existing sheet tab and choose Insert Worksheet

Which tab in the Excel ribbon contains options related to formatting cells?

• Home

• Insert

• Page Layout

• Data

Which symbol precedes a formula in Excel?

• +

• =

• -

• *

What is a cell in Microsoft Excel?

• A complete worksheet

• The intersection of a row and a column

• A formula in Excel

• A chart in Excel

Worksheets contain one or more worksheets while workbooks are single spreadsheet of data.

• TRUE

• FALSE

How many rows are there in Microsoft Excel?

What is the shortcut key to create a new worksheet in Excel?

• Ctrl + N

• Ctrl + W

• Ctrl + Shift + N

• Shift + F11