Skip to ContentGo to accessibility pageKeyboard shortcuts menu
OpenStax Logo

Review Questions

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

This book may not be used in the training of large language models or otherwise be ingested into large language models or generative AI offerings without OpenStax's permission.

Want to cite, share, or modify this book? This book uses the Creative Commons Attribution License and you must attribute OpenStax.

Attribution information
  • If you are redistributing all or part of this book in a print format, then you must include on every physical page the following attribution:
    Access for free at
  • If you are redistributing all or part of this book in a digital format, then you must include on every digital page view the following attribution:
    Access for free at
Citation information

© Jan 3, 2024 OpenStax. Textbook content produced by OpenStax is licensed under a Creative Commons Attribution License . The OpenStax name, OpenStax logo, OpenStax book covers, OpenStax CNX name, and OpenStax CNX logo are not subject to the Creative Commons license and may not be reproduced without the prior and express written consent of Rice University.