NEW
Font size
WorksheetsLesson 10: Microsoft Excel Review
Total questions: 12
Worksheet time: 6mins
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
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.
