Workplace Software and Skills

# Review Questions

### 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