Which tab contains the Zoom button in Excel?
Correct answer:
A) VIEW tab
Explanation: The Zoom button is found under the VIEW tab in the Zoom group.
Which tab contains the Zoom button in Excel?
Correct answer:
A) VIEW tab
Explanation: The Zoom button is found under the VIEW tab in the Zoom group.
Where can you find the Goal Seek button in Excel?
Correct answer:
B) DATA tab
Explanation: The Goal Seek button is located in the DATA tab under the Data Tools group.
What is an interactive view of worksheet data in Excel called?
Correct answer:
A) PivotTable report
Explanation: A PivotTable report is an interactive way of summarizing large datasets.
What type of report is a visual representation of PivotTables?
Correct answer:
B) PivotChart report
Explanation: PivotChart reports visually represent the summarized data from PivotTables.
What describes how a value changes over time or the relationship between two variables?
Correct answer:
C) Trend
Explanation: A trend describes how values change over time or the relationship between two variables.
Which chart cannot have a trendline added to it?
Correct answer:
B) Pie chart
Explanation: Pie charts do not have axes or numerical relationships, so a trendline cannot be added.
What is the value that measures the strength of a trend and ranges from 0 to 1?
Correct answer:
A) R-squared value
Explanation: The R-squared value measures how closely data points fit a trendline, indicating the strength of the trend.
Where can you find the Move Chart button in Excel?
Correct answer:
A) CHART TOOLS DESIGN tab
Explanation: The Move Chart button is located in the CHART TOOLS DESIGN tab under the Location group.
In a PivotTable, what do data fields correspond to?
Correct answer:
B) Summary values
Explanation: Data fields in a PivotTable represent the summary values derived from the data being analyzed.
Which tab contains the PivotTable button in Excel?
Correct answer:
A) INSERT tab
Explanation: The PivotTable button is located in the INSERT tab under the Tables group.
What does the Report Layout button allow you to modify?
Correct answer:
D) PivotTable structure
Explanation: The Report Layout button in PivotTables allows you to change the layout and structure of your report.
What summary function estimates the standard deviation of all data in a PivotTable?
Correct answer:
C) StdDev
Explanation: The StdDev summary function calculates the estimated standard deviation of all data in a PivotTable.
Which summary function finds the smallest data value in a PivotTable?
Correct answer:
B) Min
Explanation: The Min function calculates the smallest data value in a given dataset.
Where can you find the Field List button in a PivotTable?
Correct answer:
A) PIVOTTABLE TOOLS ANALYZE tab
Explanation: The Field List button is located in the PIVOTTABLE TOOLS ANALYZE tab under the Show group.
What are visual filters that make PivotCharts and PivotTables easier to interpret called?
Correct answer:
C) Slicers
Explanation: Slicers are used to filter data in PivotCharts and PivotTables, making the data easier to interpret.
How do you connect Slicers to multiple PivotTables?
Correct 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.
Which tab allows you to change the height of a Slicer?
Correct 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.
What type of PivotTable is constantly updated as data changes?
Correct answer:
B) Dynamic
Explanation: PivotTables are dynamic, meaning they update automatically as the underlying data changes.
Which function allows you to examine which cells are referenced by formulas?
Correct answer:
B) Formula auditing
Explanation: Formula auditing tools allow you to examine formulas and determine which cells are referenced by them.
What Excel tool allows you to specify up to 200 cells to adjust to solve a problem?
Correct 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.
What report shows the answer that Solver found, including the constraints used?
Correct answer:
C) Answer Report
Explanation: The Answer Report shows the solution Solver found, the constraints used, and any changes made to the worksheet.
What tool in Excel displays arrows to indicate relationships between formulas and cells?
Correct answer:
B) Tracer Arrows
Explanation: Tracer Arrows are part of formula auditing, showing which cells are referenced by a formula.
A cell containing a formula that references other cells is called what?
Correct answer:
B) Precedent
Explanation: A precedent cell is one that is referenced by a formula in another cell.
Where can you find the Trace Precedents button?
Correct answer:
B) FORMULAS tab
Explanation: The Trace Precedents button is located in the FORMULAS tab under the Formula Auditing group.
Which error code indicates that a cell reference in a formula is not valid?
Correct answer:
C) #REF!
Explanation: The #REF! error indicates an invalid cell reference in a formula.
What Excel tool opens a window to monitor specific cells for changes?
Correct answer:
B) Watch Window
Explanation: The Watch Window allows users to track changes in specific cells without scrolling through the worksheet.
Which tool allows you to evaluate a formula step by step?
Correct answer:
C) Evaluate Formula
Explanation: The Evaluate Formula tool lets you step through each part of a formula to examine how its calculated.
What is NOT a type of data validation criteria in Excel?
Correct answer:
C) Bold Style Formatting
Explanation: Bold Style Formatting is not a type of data validation criterion. Data validation criteria are related to the type of input, such as whole numbers or dates.
Where can you find the 'What-If Analysis' button?
Correct answer:
B) DATA tab
Explanation: The What-If Analysis button is located under the DATA tab in the Data Tools group.
What Excel tool can help identify invalid data entered via formulas or automated tools like Goal Seek?
Correct answer:
B) Circle Invalid Data
Explanation: The Circle Invalid Data tool highlights cells containing invalid data based on your validation rules.
What Solver parameter sets the number of possible answer value combinations to be tried?
Correct answer:
B) Iterations
Explanation: Iterations define how many times Solver will try different combinations to find a solution.
What are named combinations of values assigned to variables in an Excel model called?
Correct answer:
C) Scenarios
Explanation: Scenarios are named sets of input values that represent different situations or models.
Which scenario is helpful to define in any Excel model to represent initial assumptions?
Correct answer:
C) Baseline scenario
Explanation: A baseline scenario represents the starting assumptions in a model, acting as a reference point.
What worksheet generated by the Scenario Manager provides an outline format of scenarios?
Correct answer:
B) Scenario Summary
Explanation: The Scenario Summary provides a report in outline format that details each scenario.
Where can you restrict access to workbooks using Information Rights Management (IRM)?
Correct answer:
C) Backstage (Info)
Explanation: In Backstage view (under the Info section), you can use Information Rights Management (IRM) to restrict access to workbooks.
What Excel feature ensures that critical cells are not accidentally changed?
Correct answer:
C) Cell Protection
Explanation: Cell protection locks cells to prevent accidental changes.
What is created from column or row titles in a workbook?
Correct answer:
A) Named range
Explanation: Named ranges are created using column or row titles to identify specific cells or ranges.
Where can you find the Financial button and PMT function?
Correct answer:
C) FORMULAS tab
Explanation: The Financial button, which contains the PMT function, is found under the FORMULAS tab in the Function Library group.
What is the function of data tables in Excel?
Correct answer:
D) To analyze and model different values
Explanation: Data tables allow users to input different values and analyze outcomes based on these inputs.
What function returns the present value of an annuity?
Correct answer:
B) PV
Explanation: The PV function calculates the present value of an annuity based on future payments and interest rates.
What is the path to the 'Protect Sheet' button in Excel?
Correct answer:
A) REVIEW tab
Explanation: The Protect Sheet button is located in the REVIEW tab under the Changes group.
How do you hide a worksheet in Excel?
Correct answer:
A) Click Hide in the shortcut menu
Explanation: You can hide a worksheet by right-clicking its tab and selecting Hide.
What is a reference to a cell or range of cells in another workbook called?
Correct answer:
A) External reference
Explanation: An external reference refers to a cell or range of cells in another workbook.
Which function is used when a table is organized horizontally in Excel?
Correct answer:
B) HLOOKUP
Explanation: HLOOKUP is used to search for values in tables organized horizontally.
Which function is most commonly used in vertical tables?
Correct answer:
D) VLOOKUP
Explanation: VLOOKUP is most commonly used to search for values in tables organized vertically.
What type of formatting allows you to apply rules based on cell values?
Correct answer:
B) Conditional formatting
Explanation: Conditional formatting applies rules to cells based on their values, changing the cells appearance if conditions are met.
What do you call the left column values in a table array used for VLOOKUP?
Correct answer:
D) Lookup values
Explanation: The left column values used in a table array for VLOOKUP are called lookup values.
What is the path to the 'Total Row' check box for tables?
Correct answer:
A) TABLE TOOLS DESIGN tab
Explanation: The Total Row check box is found in the TABLE TOOLS DESIGN tab under the Table Style Options group.
How is data arranged when it is in ascending sequence?
Correct answer:
B) A-Z
Explanation: Data is in ascending order when arranged alphabetically from A to Z or numerically from smallest to largest.
What is the path to the Format Painter button in Excel?
Correct answer:
A) HOME tab
Explanation: The Format Painter button is located in the HOME tab under the Clipboard group.
If this exam is giving you a hard time, let us be your helping hand. Contact us, and we'll provide the assistance you need to pass and move forward.