Excel Quiz

What is a worksheet?

• A "page" within an Excel workbook that contains columns rows and cells
• Homework
• Something you get at school
• All wrong

What do you call the blank boxes on a spreadsheet?

• cells
• info
• squares
• spots

Excel allows you to

• read stories
• work with data
• invent ideas

Which tab in Excel has charts and tables?

• review
• home
• file
• insert

The cell in your worksheet that has been selected. It will have bolder gridlines around it.

• TRUE
• FALSE

A formula is a combination of numbers and symbols used for calculations

• TRUE
• FALSE

The ______ feature works behind the scenes, correcting common mistakes when you complete a text entry in a cell.

• Autorepair
• Autocheck
• Grammar
• Autocorrect

How do you select an entire column?

• Select Edit > Select > Column from the menu
• Click the column heading letter
• Hold down the shift key as you click anywhere in the column.
• Hold down the Ctrl key as you click anywhere in the column

To create a formula, you first:

• Select the cell you want to place the formula into
• Type the equals sign (=) to tell Excel that you're about to enter a formula
• Enter the formula using any input values and the appropriate mathematical operators that make up your formula
• Choose the new command from the file menu

What would be a correct formula for sum in excel?

• =SUM(B3:B9)
• =SUMB3+B9
• SUM(B3:B9)
• =ADD(B3:B9)