27 terms

Excel Chapter 4

STUDY
PLAY

Terms in this set (...)

A conditional format that displays a horizontal gradient or solid fill indicating the cell's relative value compared to other selected cells
Data Bar
The process of listing records or text in a specific sequence, such as alphabetically by last name
Sorting
The process of specifying conditions to display only those records that meet those conditions
Filtering
A group of related fields representing one entity, such as data for one person, place, event or concept
Record
A set of rules that applies specific formatting to highlight or emphasize cells that meet specifications
Conditional Formatting
The rules that control the fill color of the header row, columns, and records in a table
Table style
An indication of where data will start on another page
Page break
A table row that appears below the last row of records in an Excel table and displays summary or aggregate statistics, such as a sum or an average
Total row
A conditional format that displays a particular color based on the relative value of the cell contents to the other selected cells
Color Scale
The sequence in which the pages are printed
Print Order
A tag or use of a table element, such as a field label, as a reference in a formula
Structured reference
Symbols or signs that classify data into three, four, or five categories, based on the values in a range
Icon set
The range of cells within a worksheet that will print
Print area
A predefined formula that calculates an aggregate value, such as totals, for values in a range, a table, or a database
SUBTOTAL function
The smallest data element contained in a table, such as first name, last name, address, and phone number
Field
A structure that organizes data in a series of records (rows), with each record made up of a number of fields (columns)
Table
The process of keeping rows and/or columns visible onscreen at all times even when you scroll through a large dataset
Freezing
You have a large data set that will print on several pages.You want to ensure that related records print on the same page with coloumn and row labels visible and that confidential information is not printed. You should apply all of the following page setup options except which one to accomplish the task?
(a. Set Print Area)
(b. Print titles)
(c. Adjust page breaks)
(d. Change the print page order)
d. Change the print page order
You are working with a large worksheet. Your row headings are in column A. Which command(s) should be used to see the row headings and the distant information in columns X,Y and Z?
Freeze panes command
Which statement is not a recommended guideline for designing and creating an Excel table?
Leave one blank row between records in the table
Which of the following characters are wildcards in Excel? (Check all that apply)
(a. *)
(b. #)
(c. ?)
(d. $)
(a. * )(c. ?)
What should you do to ensure that records in a table are unique?
Use the Remove duplicates command
Which conditional Formatting rule is best suited to apply formatting to the top five values in a range of values?
Top 10 Items
Which date filter option enables you to restrict the view to only dates that occur in March of 2016?
Between
Which of the following is an unqualified structured reference?
(a. =Purchase_Price]-[Down_Payment])
(b. =Sales[Purchase_Price]-Sales[Down_Payment])
(c. =Purchase_Price-Down_Payement)
(d. =[Sales]Purchase_Price-[Sales]Down_Payment)
a. =[Purchase_Price]-[Down_Payment]
Which of the following is not an aggregate function that can applied in a total row?
VLOOKUP
If you would like to set a conditional formatting rule based on the function = AND(G6="Finance", H7<7000) which formatting rule type is needed?
Use a formula to determine which cells to format
YOU MIGHT ALSO LIKE...
STUDY GUIDE