D100 Introduction to Spreadsheets - Set 1 - Part 2

Test your knowledge of technical writing concepts with these practice questions. Each question includes detailed explanations to help you understand the correct answers.

Question 21: What report shows the answer that Solver found, including the constraints used?

Solver Report

Formula Report

Answer Report

Data Report

Question 22: What tool in Excel displays arrows to indicate relationships between formulas and cells?

Formula Checker

Tracer Arrows

Data Auditing

Solver Arrows

Question 23: A cell containing a formula that references other cells is called what?

Dependent

Precedent

Referenced

Calculated

Question 24: Where can you find the Trace Precedents button?

HOME tab

FORMULAS tab

DATA tab

INSERT tab

Question 25: Which error code indicates that a cell reference in a formula is not valid?

#DIV/0!

#NAME?

#REF!

#VALUE!

Question 26: What Excel tool opens a window to monitor specific cells for changes?

Data Checker

Watch Window

Formula Monitor

Data View

Question 27: Which tool allows you to evaluate a formula step by step?

Formula Auditing

Trace Precedents

Evaluate Formula

Solver

Question 28: What is NOT a type of data validation criteria in Excel?

Whole Number

Date

Bold Style Formatting

Decimal

Question 29: Where can you find the 'What-If Analysis' button?

HOME tab

DATA tab

FORMULAS tab

VIEW tab

Question 30: What Excel tool can help identify invalid data entered via formulas or automated tools like Goal Seek?

Formula Checker

Circle Invalid Data

Trace Dependents

Error Checker

Question 31: What Solver parameter sets the number of possible answer value combinations to be tried?

Constraints

Iterations

Precision

Bounds

Question 32: What are named combinations of values assigned to variables in an Excel model called?

Constraints

Variables

Scenarios

Fields

Question 33: Which scenario is helpful to define in any Excel model to represent initial assumptions?

Final scenario

Changing scenario

Baseline scenario

Calculation scenario

Question 34: What worksheet generated by the Scenario Manager provides an outline format of scenarios?

Scenario Report

Scenario Summary

Outline Scenario

Scenario View

Question 35: Where can you restrict access to workbooks using Information Rights Management (IRM)?

HOME tab

VIEW tab

Backstage (Info)

DATA tab

Question 36: What Excel feature ensures that critical cells are not accidentally changed?

Data Validation

Conditional Formatting

Cell Protection

Formula Checker

Question 37: What is created from column or row titles in a workbook?

Named range

Formula reference

Data range

Field name

Question 38: Where can you find the Financial button and PMT function?

DATA tab

HOME tab

FORMULAS tab

INSERT tab

Question 39: What is the function of data tables in Excel?

To display charts

To compare datasets

To store PivotTable data

To analyze and model different values

Question 40: What function returns the present value of an annuity?

PMT

RATE

Don't Want to Study?

Save Time on Studies, Spend More with Family & Friends! Pay-After-you-Pass!

Get Exam Support