Basic Excel Review

Every worksheet is made up of boxes called?

• spaces

• cells

• shapes

• boxes

Columns are labeled with _____.

• letters

• numbers

If you wanted to add a chart or picture to your spreadsheet, what tab do you select on the ribbon?

• Home

• Insert

• Formulas

• Data

All formulas must start with what?

• Function

• Minus symbol (-)

• Equals Sign (=)

• Parentheses ( )

What function do you use to add values in cells together?

• TOTAL

• SUM

• ADD

• CONCAT

What is the name of a cursor that looks like this?

• Select Handle

• Pointer

• Fill Handle

When an object (table, picture, chart) is selected, what happens?

• A contextual tab appears.

• It lights up.

• The cursor turns red.

• All of the above

How do you adjust the column width in Excel?

• Right-click on the column and select Column Width

• Use the contextual tab.

• Select the column and press the Enter key

What is this icon called and what does it do?

• Font Brush - changes the color of the selected font

• Autosum - totals the selection.

• Format Painter - formats the cell based on a selection.

• All of the above

How do you view formulas in a worksheet?

• Press CTRL + \

• Press CTRL + `

• Press ALT + ENTER

• Press CTRL + F