Solon Microsoft Excel Flashcard

Front

What is the difference between Workbook and a worksheet?

Back

A workbook is the actual file that contains the worksheets, which turn contain the data.

Front

When you insert a row, where does Excel place it in relation to the cursor position?

Back

Above the current row

Front

Which character automatically indicates the contents of a cell are a formula? Options: $ , = , ‘ , “

Back

=

Front

How can data be aligned within a cell?

Back

Horizontally, vertically, or rotated

Front

Why might you want to apply borders to a cell instead of just using the gridlines on the worksheet?

Back

Borders can help to separate and identify specific cells.

Front

Why might you prefer to apply a background color to a cell instead of applying a pattern?

Back

Patterns can make it harder to read the data than using a solid color.

Front

All formulas begin with a

Back

=

Front

How do you insert a new row? Options: Right-click the row heading where you want to insert the new row and select Insert from the shortcut menu, Select the row heading where you want to insert the new row and select Edit >Row from the menu, Select the row heading where you want to insert the new row and click the Insert Row button on the standard toolbar, All of the above

Back

Right-click the row heading where you want to insert the new row and select Insert from the shortcut menu.

Front

How do you select an entire column? Options: 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.

Back

Click the column heading letter

Front

What would be a correct formula for SUM in excel?

Back

=SUM(B3:B9)