Upgrade to remove ads
Excel Final Exam Review
Terms in this set (20)
Which is an interactive view of worksheet data that gives a user the ability to summarize the data by selecting categories in which to group the data?
How is an exact copy of a worksheet created within the same workbook?
Right-click the sheet tab, then choose Move or Copy from the Shortcut Menu
What is an organized collection of data called?
Table or database
Which term describes the process of creating a formula that refers to a cell in the same location but on seperate sheets in a workbook?
When sorting data in a table, which fields are selected as fields to sort by?
Which technique uses the table column heading arrows to narrow data in a table to show only specific items meeting a desired criterion?
Which ribbon includes the commands to apply a quick table style to a range of cells?
Which command on the Home Ribbon do you use to temporarily hide specific values on a worksheet based on a criterion?
Sort & Filter
How would a user hide a row or column from view without permanently deleting the information?
Choose the Hide command on the Shortcut menu
What are the individual data items that make up a record in a table called?
What do you call it when you reference cells in other sheets in a workbook formula using the sheet name as the reference rather than the cell address?
Which command do you use to remove manual page breaks from a worksheet area?
Select Remove Page Break from the Breaks drop-down area
Which dialog box allows a user to select the first row as the table's header row?
Format as Table
What command do you use to insert information into a worksheet that will display at the top and bottom edges of the printed page?
Header & Footer
Which function do you use to insert today's date in a worksheet so that it automatically updates each time the worksheet is opened?
How do you quickly modify a table style to meet user preferences?
Right-click on a style and choose Duplicate
What is a visual way to show how two variables relate to each other in a table?
What is the name of the technique of entering a number once and copying it so that it is entered in the same cell on all selected worksheets?
Drilling an entry
What is a range that spans two or more sheets in a workbook?
What is the name of the dialog box that contains the commands to center a worksheet on the page both vertically and horizontally?
You might also like...
Excel lesson 7
excel lesson 7
Excel Chapter 5
Other sets by this creator
Environmental Science Test 3
Human Resource Perspectives: Personnel Process PPT
Human Resources Perspectives: Personnel Planning P…
Environmental Science Test 2
Other Quizlet sets
Psychobiology Chapter 2
faulty argument techniques examples
Psych Chapt #1
Anatomy Quiz Questions (Exam 3)