-
web.groovymark@gmail.com
- December 8, 2024
Question 21
What report shows the answer that Solver found, including the constraints used?
A. Solver Report
B. Formula Report
C. Answer Report
D. Data Report
Answer: C. Answer Report
Explanation: The Answer Report shows the solution Solver found, the constraints used, and any changes made to the worksheet.
Question 22
What tool in Excel displays arrows to indicate relationships between formulas and cells?
A. Formula Checker
B. Tracer Arrows
C. Data Auditing
D. Solver Arrows
Answer: B. Tracer Arrows
Explanation: Tracer Arrows are part of formula auditing, showing which cells are referenced by a formula.
Question 23
A cell containing a formula that references other cells is called what?
A. Dependent
B. Precedent
C. Referenced
D. Calculated
Answer: B. Precedent
Explanation: A precedent cell is one that is referenced by a formula in another cell.
Question 24
Where can you find the Trace Precedents button?
A. HOME tab
B. FORMULAS tab
C. DATA tab
D. INSERT tab
Answer: B. FORMULAS tab
Explanation: The Trace Precedents button is located in the FORMULAS tab under the Formula Auditing group.
Question 25
Which error code indicates that a cell reference in a formula is not valid?
A. #DIV/0!
B. #NAME?
C. #REF!
D. #VALUE!
Answer: C. #REF!
Explanation: The #REF! error indicates an invalid cell reference in a formula.
Question 26
What Excel tool opens a window to monitor specific cells for changes?
A. Data Checker
B. Watch Window
C. Formula Monitor
D. Data View
Answer: B. Watch Window
Explanation: The Watch Window allows users to track changes in specific cells without scrolling through the worksheet.
Question 27
Which tool allows you to evaluate a formula step by step?
A. Formula Auditing
B. Trace Precedents
C. Evaluate Formula
D. Solver
Answer: C. Evaluate Formula
Explanation: The Evaluate Formula tool lets you step through each part of a formula to examine how it’s calculated.
Question 28
What is NOT a type of data validation criteria in Excel?
A. Whole Number
B. Date
C. Bold Style Formatting
D. Decimal
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.
Question 29
Where can you find the ‘What-If Analysis’ button?
A. HOME tab
B. DATA tab
C. FORMULAS tab
D. VIEW tab
Answer: B. DATA tab
Explanation: The What-If Analysis button is located under the DATA tab in the Data Tools group.
Question 30
What Excel tool can help identify invalid data entered via formulas or automated tools like Goal Seek?
A. Formula Checker
B. Circle Invalid Data
C. Trace Dependents
D. Error Checker
Answer: B. Circle Invalid Data
Explanation: The Circle Invalid Data tool highlights cells containing invalid data based on your validation rules.
Question 31
What Solver parameter sets the number of possible answer value combinations to be tried?
A. Constraints
B. Iterations
C. Precision
D. Bounds
Answer: B. Iterations
Explanation: Iterations define how many times Solver will try different combinations to find a solution.
Question 32
What are named combinations of values assigned to variables in an Excel model called?
A. Constraints
B. Variables
C. Scenarios
D. Fields
Answer: C. Scenarios
Explanation: Scenarios are named sets of input values that represent different situations or models.
Question 33
Which scenario is helpful to define in any Excel model to represent initial assumptions?
A. Final scenario
B. Changing scenario
C. Baseline scenario
D. Calculation scenario
Answer: B. Scenario Summary
Explanation: The Scenario Summary provides a report in outline format that details each scenario.
Question 34
What worksheet generated by the Scenario Manager provides an outline format of scenarios?
A. Scenario Report
B. Scenario Summary
C. Outline Scenario
D. Scenario View
Answer: b) A model that categorizes people according to personality traits and how they interact with others
Explanation: The Social Style Matrix classifies individuals into categories (Analytical, Driver, Amiable, and Expressive) based on their assertiveness and responsiveness.
Question 35
Where can you restrict access to workbooks using Information Rights Management (IRM)?
A. HOME tab
B. VIEW tab
C. Backstage (Info)
D. DATA tab
Answer: C. Backstage (Info)
Explanation: In Backstage view (under the Info section), you can use Information Rights Management (IRM) to restrict access to workbooks.
Question 36
What Excel feature ensures that critical cells are not accidentally changed?
Data Validation
B. Conditional Formatting
C. Cell Protection
D. Formula Checker
Answer: C. Cell Protection
Explanation: Cell protection locks cells to prevent accidental changes.
Question 37
What is created from column or row titles in a workbook?
A. Named range
B. Formula reference
C. Data range
D. Field name
Answer: A. Named range
Explanation: Named ranges are created using column or row titles to identify specific cells or ranges.
Question 38
Where can you find the Financial button and PMT function?
A. DATA tab
B. HOME tab
C. FORMULAS tab
D. INSERT tab
Answer: C. FORMULAS tab
Explanation: The Financial button, which contains the PMT function, is found under the FORMULAS tab in the Function Library group.
Question 39
What is the function of data tables in Excel?
A. To display charts
B. To compare datasets
C. To store PivotTable data
D. To analyze and model different values
Answer: D. To analyze and model different values
Explanation: Data tables allow users to input different values and analyze outcomes based on these inputs.
Question 40
What function returns the present value of an annuity?
A. FV
B. PV
C. PMT
D. RATE
Answer: B. PV
Explanation: The PV function calculates the present value of an annuity based on future payments and interest rates.
