A doughnut chart displays
Give this one a try later!
values as percentages of the whole but may contain more than one data
series.
A spreadsheet PROGRAM is defined as
,Give this one a try later!
a software application used to create and modify spreadsheets.
What function looks up a value in a lookup table where the first row contains the
values to compare with the lookup value?
Give this one a try later!
The HLOOKUP function
After creating a chart you can change the chart type by using
Give this one a try later!
Design tab / Change Chart Type button.
Which tools have the ability to change values in the original dataset?
Give this one a try later!
Goal Seek & Solver
If you change any of the Solver parameters:
Give this one a try later!
, you will need to create another Solver report
"After entering the substitution values and the reference to a formula, the next step to
complete a two-variable data table and view the results is to:"
Give this one a try later!
drag to select the data table boundaries.
"To add a record (row) to a table,"
Give this one a try later!
"click in a cell and on the Home tab, click the Insert arrow in the Cells
group."
Which of the following is FALSE about PivotTables?
Give this one a try later!
Each row in the source data becomes a PivotTable field.
One benefit of using range names in formulas is
Give this one a try later!
Give this one a try later!
values as percentages of the whole but may contain more than one data
series.
A spreadsheet PROGRAM is defined as
,Give this one a try later!
a software application used to create and modify spreadsheets.
What function looks up a value in a lookup table where the first row contains the
values to compare with the lookup value?
Give this one a try later!
The HLOOKUP function
After creating a chart you can change the chart type by using
Give this one a try later!
Design tab / Change Chart Type button.
Which tools have the ability to change values in the original dataset?
Give this one a try later!
Goal Seek & Solver
If you change any of the Solver parameters:
Give this one a try later!
, you will need to create another Solver report
"After entering the substitution values and the reference to a formula, the next step to
complete a two-variable data table and view the results is to:"
Give this one a try later!
drag to select the data table boundaries.
"To add a record (row) to a table,"
Give this one a try later!
"click in a cell and on the Home tab, click the Insert arrow in the Cells
group."
Which of the following is FALSE about PivotTables?
Give this one a try later!
Each row in the source data becomes a PivotTable field.
One benefit of using range names in formulas is
Give this one a try later!
