Advanced Formatting Techniques
Advanced Functions and Formulas
Working with Tables and Data Features
Summarizing and Consolidating Data
Using Data Analysis Features
100
This Excel tool applies formatting changes to cells that meet certain conditions.
What is Conditional Formatting?
100
These two functions, discussed in Chapter 2, can look up values in a range.
What are the HLOOKUP and VLOOKUP functions?
100
The Data tools group is located on this tab of the Excel Ribbon.
What is the Data Tab?
100
If this is added to a chart, it illustrates the direction or trend that the data is presenting within a chart.
What is a trendline?
100
This dialog box includes several options for pasting copied data.
What is the Paste Special dialog box?
200
You can edit or delete a conditional formatting rule using this dialog box.
What is the Conditional Formatting Rules dialog box?
200
This function is used to count cells that meet multiple criteria.
What is the COUNTIFS?
200
This Excel feature allows you to control the type of data that is accepted for entry into a cell.
What is Data Validation?
200
This interactive table organizes and summarized data based on category labes you designated from row headings and column headings.
What is a PivotTable
200
These cells are cells that provide data to a formula cell.
What are Precedent cells?
300
Excel provides special number formats such as Zip Code and Phone Numbers in this Category on the Number tab.
What is the Special Category?
300
This dialog box will create new range names, edit existing range names, or delete a range names.
What is the Name Manager dialog box?
300
The three Data Validation Error Alert Message styles are...
What is the Stop, the Warning, and the Information style?
300
References between workbooks can be updated, changed, and broken using this dialog box.
What is the Edit Links dialog box?
300
This error code indicates the formula contains an unrecognized entry.
What is the NAME error code?
400
This feature displays a filter arrow at the top of each column.
What is AutoFilter?
400
This function will return TRUE if any ALL logical conditions tested are true.
What is the AND function.
400
Options such as Header Row, Total Row, and Banded Columns, can be found in this group on the Table Tools Design Tab.
What is the Table Style Options group?
400
This Trendline option is best used for values that increase or decrease at a steady rate and displayed in a best-fit straight line.
What is a Linear Trendline?
400
This tool allows you to store multiple sets of assumptions about data.
What is the Scenario Manager?
500
Scientific formatting displays numbers in this formatting.
What is exponential notation?
500
There are this number of function categories in Excel.
What is 11?
500
This function is used to summarize data in a table or range.
What is the SUBTOTAL function?
500
This feature can also be used to summarize data from other worksheets or other workboks into a master worksheet.
What is the Consolidate feature?
500
These type of formulas test the accuracy of key figures in a worksheet.
What is a Proof formula?
M
e
n
u