Solon Microsoft Excel Quiz

What is the difference between Workbook and a worksheet?

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

• The worksheets contain the data and the workbook contains the tabs for each data type.

• A workbook is a section that contains the worksheet reports; both are contained in a spreadsheet.

• There is no difference other than which term you prefer to use for spreadsheets.

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

• Above the current row

• Below the current row.

• You must select the row before you can insert a new row.

• You must copy and paste any existing data down one row to have a blank row at the cursor position.

Which character automatically indicates the contents of a cell are a formula?

• $

• =

• ‘

• “

How can data be aligned within a cell?

• Horizontally

• Horizontal and Vertical

• Vertically

• Horizontally, vertically, or rotated

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

• Borders can help to separate and identify specific cells.

• You can highlight a row by clicking one button for outside borders.

• To emphasize specific cells in the gridline.

• To mark the print area of the worksheet.

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

• There is a limited number of patterns to choose.

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

• You can choose a lighter color whereas all patterns are dark in design.

• Patterns should only be used with cells that have formulas.

All formulas begin with a

• &

• =

• %

• -

How do you insert a new row?

• 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

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

What would be a correct formula for SUM in excel?

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