NEW
Font size
WorksheetsExcel Domain 4 Exam Review
Total questions: 20
Worksheet time: 10mins
Which of the following features in spreadsheet software is specifically designed to automate repetitive tasks?
PivotTables
Macros
Formulas
Filters
Which location allows you to rename an existing macro in your document?
In the Insert tab
In the Backstage view
From the Macro dialog box
From the context menu
In Microsoft Excel, what visual indicator appears in a cell to signal that a potential error has been detected?
A green triangle in the corner
A blue border
A red border
A blue square in the corner
Which command allows you to step through each part of a formula to understand how it is calculated?
Error checking
Trace dependents
Goal Seek
Trace precedent
Which of the following Excel commands is most useful for troubleshooting and resolving formula errors in a worksheet?
What-If Analysis
Watch Window
Remove Arrows
Evaluate Formula
On which tab of the PivotChart Tools can you access and customize Chart Styles to enhance the appearance of your chart?
Analyze
Format
Design
Insert
Which of the following can be used within a PivotChart to filter the displayed data?
a filter
field drop-down boxes
a timetable
a slicer
Which of the following best explains the main function of Goal Seek in spreadsheet software?
Display the results of multiple inputs at the same time.
Choose from a list of rules to limit the type of data that people can enter.
Determine the necessary input value to achieve a specific desired result.
Create different groups of values or scenarios.
Which of the following statements accurately describes a feature of Goal Seek in spreadsheet applications?
Goal Seek can adjust one input value at a time to achieve a desired result.
Goal Seek can simultaneously change multiple input values to reach a target.
Goal Seek is used to restrict the type of data users can enter into cells.
Goal Seek can organize values into different groups automatically.
Which of the following commands is NOT found in the Scenario Manager dialog box in Excel?
Show All
Merge
Add
Summary
In the PivotTable Styles group, which of the following attributes can you customize to change the appearance of your PivotTable?
Category
Total
Layout
Color
Which of the following is NOT an available area for placing fields in the PivotTable Fields pane?
Value
Column
Row
Header
Which of the following options is NOT available as a way to summarize data in a PivotTable?
Count
Dividend
Average
Sum
In a PivotTable, what is the main function of applying filters to your data?
Categorize data
Expand data
Drill down into data
Group data
Which of the following tabs is NOT found under the PivotChart Tools in Excel?
Format
Design
Insert
Analyze
Which feature found on the Insert tab in Excel helps users quickly create PivotTables by offering preconfigured layouts and suggestions?
Table
PivotTable Options
Recommended PivotTables
Preset PivotTables
What is the term for a chart that displays data using two or more different chart types within the same visualization?
Surface
3-D Bar
Combo
Doughnut
In the context of dual-axis charts, what is the term commonly used for the additional axis that is introduced alongside the primary axis?
Secondary axis
Category axis
Horizontal axis
Vertical axis
On which tab in Microsoft Excel can you access the Record Macro command to automate tasks?
On the Home tab
On the Formulas tab
On the Developer tab
On the Data tab
In spreadsheet software, what is the term for a cell whose value directly influences the value of other cells?
A circular reference
A source
A precedent
A dependent
