Excel Basics Quiz

How can you create a new workbook in Microsoft Excel?

• Right-click on an existing sheet and choose "New Workbook"

• Press Ctrl + S

• Go to File > New

• Close an existing workbook

What is the shortcut key combination to save a workbook in Excel?

• Ctrl + S

• Ctrl + C

• Ctrl + X

• Ctrl + P

To change the name of a sheet in Excel, you should:

• Right-click on the sheet and choose "Rename"

• Press Ctrl + R

• Delete the sheet and create a new one with the desired name

• Use the Format Painter

How can you add a new sheet to an existing Excel workbook?

• Click the "Delete" button on the Ribbon

• Go to File > New

• Right-click on an existing sheet and select "Add New Sheet"

• Click the " + " button at the bottom of the sheet tabs

Which feature in Excel automatically saves your workbook at regular intervals?

• AutoFormat

• AutoSum

• AutoFill

• Autosave

Which data type is appropriate to enter a phone number in Excel?

• Date

• Formula

• Numeric

• Text

To enter a numeric value "250" into a cell, you would:

• Type "=250"

• Type "250"

• Type "two fifty"

• Type "2e2"

How can you navigate to the last cell in a worksheet containing data?

• Press Ctrl + Home

• Use the arrow keys

• Press Ctrl + End

• Click on the cell

How can you edit the content of a cell in Excel?

• Right-click the cell and choose "Edit"

• Press Enter

• Press Ctrl + E

• Double-click the cell or press F2

What is the correct cell address for the cell located at the intersection of column B and row 5?

• B4

• A5

• C5

• B5