FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 3: Performing Calculations With Formulas and Functions

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 41

True/False

Review LaterAdd Note

Review Later

An error value begins with a pound sign (#)followed by an error name that indicates the type of error._______________ 

A) True
B) False

Correct Answer

verified

Show Answer

Question 42

Multiple Choice

Review LaterAdd Note

Review Later

Case 3-2 Susan is in charge of the inventory reports for her company.She will need to find specific inventory items as well as project increases in inventory costs.To get ready she will create a worksheet and use the Microsoft Excel 2016 Analysis tools -Susan wants to make some changes to the worksheet to explore the impact that changing input values has on the calculated values in the worksheet.She can use  ______.

A)  Lookup Analysis
B)  What-If Analysis 
C)  IF conditions
D)  nested OR conditions

E) C) and D)
F) A) and D)

Correct Answer

verified

Show Answer

Question 43

Multiple Choice

Review LaterAdd Note

The ____ function returns the maximum value in the range.

Absolute references are marked with a ____.

A trial-and-error method lets you explore the impact that changing input values has on the calculated values in the workbook._________________________

Goal Seek automates the trial-and-error process by allowing you to specify a value for a calculated item,which Excel uses to determine the input value needed to reach that goal._________________________

Case 3-2 Susan is in charge of the inventory reports for her company.She will need to find specific inventory items as well as project increases in inventory costs.To get ready she will create a worksheet and use the Microsoft Excel 2016 Analysis tools -Susan needs to use a lookup function to find an exact match of an inventory item,so she will set the range_lookup value to _______ .

When you nest functions,you should have ____.

=ROUND(AVERAGE(A1:A100) ,2) is an example of a(n) ____ function.

A mixed reference "locks" one part of the cell reference while the other part can change._______________ 

The ____ category of Excel functions returns (true-false) values.

A lookup table organizes numbers or text into categories._____________

The statement "A1 >= B1" tests whether the value in cell A1 is lesser than or equal to the value in cell B1._________________________

Optional arguments are always placed first in the argument list._______________ 

Excel functions are organized into ____ categories.