10.9: Chapter Review - Review Questions
-
- Last updated
- Save as PDF
Review Questions
1 .
What is one method to name data ranges?
-
On the Page Layout tab, use options in the Sheet Options command group.
-
Use the Formula Bar.
-
Press Ctrl+Shift+Enter.
-
On the Formulas tab, select Define Name in the Defined Names command group.
2 .
What is one example of a benefit of using Data Tables in your worksheet?
-
renaming a cell reference
-
reorganizing the values from large to small
-
adding an extra column on your table with results
-
autofilling and calculating multiple scenarios
3 .
Where is the Data Table tool?
-
on the Home tab in the Sort & Filter command group
-
on the Data tab under the What-If Analysis menu
-
on the Insert tab in the Charts command group
-
on the Formulas tab under Financial functions
4 .
What are the benefits of using data ranges in your worksheets?
-
You can autofill and compute scenarios.
-
You can simultaneously calculate different operations in different worksheets.
-
You can save time by not going back to search for named cells.
-
You can reorganize the data following different criteria.
5 .
Which comparison operator represents “not equal”?
-
<>
-
=/
-
>=
-
><
6 .
What is a mixed cell reference?
-
when you combine cells together
-
when either the row or the column is fixed
-
an absolute cell reference
-
a relative cell reference
7 .
Which function is used to total a range based on a certain criteria?
-
COUNT
-
SUM
-
NPER
-
SUMIF
8 .
Identify the correct order for the PV function.
-
=pv(rate,nper,pmt,fv)
-
=pv(rate,nper,pmt,pv)
-
=pv(rate,nper,pv,fv)
-
=pv(rate,pmt,pv,fv)
9 .
What is a PivotTable?
-
a tool that derives information from raw data, which it processes in different arrangements depending on the variables the user chooses
-
a tool that autoformats your workbook by automatically changing the background canvas, fonts, and data types
-
a tool that defines the names of given ranges, so that you can use them for building formulas with certain cell references
-
a tool that automatically makes simultaneous calculations in one cell, yet needs you to design and write the formulas
10 .
What does the Recommended PivotTable tool provide?
-
The tool recommends and constructs a PivotTable with several variables based on your data.
-
The tool creates both a PivotTable and a PivotChart from the selected data.
-
The tool recommends PivotTable variables (i.e., headings) to be the leading data presented in one-dimensional tables.
-
The tool recommends appropriate formulas to analyze the data in the PivotTable.
11 .
Where do you select the headers you want to use in a PivotTable?
-
on the Insert tab in the Text command group
-
on the Data tab under What-If Analysis
-
in the PivotTable Field List after creating a PivotTable
-
on the Insert tab using the Insert PivotTable command
12 .
What is one reason you might audit a formula?
-
You would audit a formula if you get a negative number.
-
You would audit a formula to copy it to another cell.
-
You would audit a formula if your PivotTable is not formatting correctly.
-
You would audit a formula if you have an error such as #NUM! on the spreadsheet.
13 .
How does a user inspect if the current cell has input and/or output problems?
-
The user would use the Step In tool.
-
The user would use the Inquire add-in.
-
The user would use the Watch Window.
-
The user can run the Trace Precedents and Dependents tools.
14 .
How would you create a custom color in a theme?
-
A custom theme color is created using the Format Painter.
-
Choose cell styles from the Home tab.
-
On the Page Layout tab, choose Colors.
-
The custom color can be created using the Effects menu.
15 .
Where would you go to reformat a phone number?
-
the Format Cells tool in the Number command group on the Home tab
-
in the Page Layout menu in the Themes command group
-
using the Format Painter
-
using Cell Styles from the Home tab