BYSEX21C10SA
The VLOOKUP and HLOOKUP functions require three arguments; including a fourth argument is optional.
Correct!
Review the section "VLOOKUP and HLOOKUP."
The formula =VLOOKUP(2,A2:B6,2,TRUE) will return the value 7% from this table.
A two-column table with the headings Years and Rates in cells A1 and B1, respectively. Rows 2-6 in the Years columns are numbered 1 through 5, and the corresponding Rate column shows 5%, 7%, 10%, 12%, and 13%.
Correct!
Review the section "VLOOKUP and HLOOKUP."
To create an Auto Outline, you must have already inserted formulas that sum or subtotal information from groups of rows or columns.
Correct!
Review the section "The Outline Feature."
To manually create groups of rows, you must have either a row with a subtotal formula or at least a blank row separating each group.
Correct!
Review the section "The Outline Feature."
To use the Subtotal command, your list must be sorted by the row you will use to group the subtotals.
Correct!
Review the section "Subtotals."
Creating a subtotal takes three steps: choosing which column to create groups by, choosing the function to use, and choosing which columns to create subtotals for.
Correct!
Review the section "The Subtotal Dialog Box."
The Quick Analysis tool offers quick and easy access to several popular analysis options not available from the Ribbon.
Correct!
Review the section "The Quick Analysis Tool."
Use the image. If the value in cell A3 is $27,000, what is the result of the formula =VLOOKUP(A3,$D$3:$E$7,2)?
The Formula Bar shows =VLOOKUP(A3,$D$3:$E$7,2). Below that is a two-column table with the column headings Annual Spending in column D and Discount Rate in column E. The spending rates are $0, 20,000, 30,000, 40,000, and $50,000, and the corresponding discounts are 0%, 2%, 3%, 4.5%, and 6.5%.
Correct!
Review the section "VLOOKUP and HLOOKUP."
In the formula =VLOOKUP(A2,A3:H56,5,TRUE), the number 5 represents the:
Correct!
Review the section "VLOOKUP and HLOOKUP."
Which button shows less detail in an outline by hiding the detail in that group of rows or columns?
Correct!
Review the section "The Outline Feature."
Where would you add subtotals to this data?
Data shown is four columns: First Name, Last Name, Team, and Total. There are various first and last names in the first two columns. In the Team column, the first three are Red and the last three are Blue. The fourth column shows totals for each individual.
Correct!
Review the section "The Subtotal Dialog Box."
The Quick Analysis tool offers five categories of analysis options, such as conditional formatting and charts, but does NOT include:
Correct!
Review the section "The Quick Analysis Tool."