Lesson 10: Microsoft Excel Review

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.

Which new workbook option displays the title, Book1, when it is created?

• A blank workbook

• A workbook created from a template

Why would you enter labels into the worksheet?

• Labels should be used when you need to enter text only.

• Labels are entered for report titles or column headings only.

• Labels identify the values and help outline the mathematical relationships.

• Labels identify where and how the values should appear.

Which key can you press to activate the Go To command?

• F1

• CTRL+H

• Ctrl+G

• F6

To select an entire row, where would you click

• The cell in column A for that row.

• Click the row header for the row you want to select.

• Click the column header where your cell is in the row you want to select.

• Click the row number in the Name Box and press ENTER.

What displays when you activate the Cut or Copy command?

• A dialog box appears prompting you to proceed with the command.

• A new worksheet appears for you to paste the cut or copied item.

• The selected cells for the Cut or Copy command appear in a different color.

• A marquee appears around the selected cells for the Cut or Copy command.

Which is the best way to set a column to a specific width?

• On the Home tab, in the Cells group, click Format, click Column Width and enter the measurement.

• Press CTRL+W to specify the width for the column.

• Double-click the heading for the column to be adjusted.

• Press F5 and then enter the column width.

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