LVP Excel Chapter 5 Review

How many worksheets are in a new workbook? / three
The intersection of a row and column / cell
Example of a cell reference / B7
Displays the worksheets in a workbook / sheet tabs
These are categories of worksheet data / label, date/time and value
The key cancels data entry and restores the original contents of the cell / the Esc key
This key enters data and makes the next cell in the column active / the Enter key
Number format that displays values with a dollar sign aligned at the left edge of the cell and two decimal place / Accounting
Displays values as percentage with two dec. places / Percentage
Number format that displays numbers the way they are typed / General
Number signs(####)displayed in a cell / the cell is not wide enough to display the formatted number
Select the entire worksheet / Press the worksheet button
Variety of cell styles is associated with a / theme
Theme applied to a new workbook / Office
Use this view when preparing a worksheet for printing / Page Layout view
Pressing Ctrl +' / displays the formulas stored in cells
This key removes the dashed border around copied cells / the Esc key
When moving a range of cells, what needs to be selected before Paste is selected? / the upper-left cell of the range where the data is to be pasted
The Fill handle is / used to copy the contents of the selected cell to adjacent cells
Cellreferences that reflect the row or column they have been copied to are called / relative cell references
Data from Word can be copied to an Excel worksheet / if it is organized in a table or aligned with tabs and tab stops
A triangle in the upper-left corner of a cell indicates / the cell has been modified while changes are being tracked
A master worksheet that includes the basic elements for a particular type of worksheet is called / a template