-
web.groovymark@gmail.com
- December 8, 2024
Question 01
Which tab contains the Zoom button in Excel?
A. VIEW tab
B. HOME tab
C. INSERT tab
D. DATA tab
Answer: A. VIEW tab
Explanation: The Zoom button is found under the VIEW tab in the Zoom group.
Question 02
Where can you find the Goal Seek button in Excel?
A. FORMULAS tab
B. DATA tab
C. VIEW tab
D. HOME tab
Answer: B. DATA tab
Explanation: The Goal Seek button is located in the DATA tab under the Data Tools group.
Question 03
What is an interactive view of worksheet data in Excel called?
A. PivotTable report
B. Chart
C. Data table
D. Trendline
Answer: A. PivotTable report
Explanation: A PivotTable report is an interactive way of summarizing large datasets.
Question 04
What type of report is a visual representation of PivotTables?
A. Trendline report
B. PivotChart report
C. Scatterplot report
D. Data Chart report
Answer: B. PivotChart report
Explanation: PivotChart reports visually represent the summarized data from PivotTables.
Question 05
What describes how a value changes over time or the relationship between two variables?
A. Chart
B. Formula
C. Trend
D. Filter
Answer: C. Trend
Explanation: A trend describes how values change over time or the relationship between two variables.
Question 06
Which chart cannot have a trendline added to it?
A. Line chart
B. Pie chart
C. Bar chart
D. Column chart
Answer: B. Pie chart
Explanation: Pie charts do not have axes or numerical relationships, so a trendline cannot be added.
Question 07
What is the value that measures the strength of a trend and ranges from 0 to 1?
A. R-squared value
B. Trendline value
C. Pivot value
D. Chart value
Answer: A. R-squared value
Explanation: The R-squared value measures how closely data points fit a trendline, indicating the strength of the trend.
Question 08
Where can you find the Move Chart button in Excel?
A. CHART TOOLS DESIGN tab
B. VIEW tab
C. HOME tab
D. PAGE LAYOUT tab
Answer: A. CHART TOOLS DESIGN tab
Explanation: The Move Chart button is located in the CHART TOOLS DESIGN tab under the Location group.
Question 09
In a PivotTable, what do data fields correspond to?
A. Headers
B. Summary values
C. Charts
D. Filters
Answer: B. Summary values
Explanation: Data fields in a PivotTable represent the summary values derived from the data being analyzed.
Question 10
Which tab contains the PivotTable button in Excel?
A. INSERT tab
B. HOME tab
C. DATA tab
D. VIEW tab
Answer: A. INSERT tab
Explanation: The PivotTable button is located in the INSERT tab under the Tables group.
Question 11
What does the Report Layout button allow you to modify?
A. Chart titles
B. PivotTable fields
C. Data styles
D. PivotTable structure
Answer: D. PivotTable structure
Explanation: The Report Layout button in PivotTables allows you to change the layout and structure of your report.
Question 12
What summary function estimates the standard deviation of all data in a PivotTable?
A. Min
B. Max
C. StdDev
D. Average
Answer: C. StdDev
Explanation: The StdDev summary function calculates the estimated standard deviation of all data in a PivotTable.
Question 13
Which summary function finds the smallest data value in a PivotTable?
A. Max
B. Min
C. StdDev
D. Sum
Answer: B. Min
Explanation: The Min function calculates the smallest data value in a given dataset.
Question 14
Where can you find the Field List button in a PivotTable?
A. PIVOTTABLE TOOLS ANALYZE tab
B. PIVOTTABLE TOOLS DESIGN tab
C. DATA tab
D. HOME tab
Answer: A. PIVOTTABLE TOOLS ANALYZE tab
Explanation: The Field List button is located in the PIVOTTABLE TOOLS ANALYZE tab under the Show group.
Question 15
What are visual filters that make PivotCharts and PivotTables easier to interpret called?
A. Data Filters
B. Chart Filters
C. Slicers
D. Fields
Answer: C. Slicers
Explanation: Slicers are used to filter data in PivotCharts and PivotTables, making the data easier to interpret.
Question 16
How do you connect Slicers to multiple PivotTables?
A. By using a PivotChart
B. By creating multiple Slicers
C. By selecting multiple PivotTables in the Slicer options
D. By creating a data link
Answer: C. By selecting multiple PivotTables in the Slicer options
Explanation: Slicers can be connected to multiple PivotTables by selecting the relevant PivotTables in the Slicer options.
Question 17
Which tab allows you to change the height of a Slicer?
A. SLICER TOOLS OPTIONS tab
B. INSERT tab
C. DATA tab
D. HOME tab
Answer: A. SLICER TOOLS OPTIONS tab
Explanation: The height of a Slicer can be adjusted in the SLICER TOOLS OPTIONS tab under the Buttons group.
Question 18
What type of PivotTable is constantly updated as data changes?
A. Static
B. Dynamic
C. Constant
D. Automatic
Answer: B. Dynamic
Explanation: PivotTables are dynamic, meaning they update automatically as the underlying data changes.
Question 19
Which function allows you to examine which cells are referenced by formulas?
A. Formula checker
B. Formula auditing
C. Trace precedents
D. Data checker
Answer: B. Formula auditing
Explanation: Formula auditing tools allow you to examine formulas and determine which cells are referenced by them.
Question 20
What Excel tool allows you to specify up to 200 cells to adjust to solve a problem?
A. Solver
B. What-If Analysis
C. PivotTable
D. Formula checker
Answer: A. Solver
Explanation: Solver is an advanced Excel tool that allows you to specify multiple cells to adjust in order to solve a problem.
