FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 8: Excel Module Performing Calculations With Formulas and Functions

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 1

True/False

Review LaterAdd Note

Review Later

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.

A) True
B) False

Correct Answer

verified

Show Answer

Question 2

True/False

Review LaterAdd Note

Review Later

Optional arguments are always placed first in the argument list.

A) True
B) False

Correct Answer

verified

Show Answer

Question 3

Multiple Choice

Review LaterAdd Note

Absolute references are marked with a ____.

An error value indicates that some part of a function is preventing Excel from returning a calculated value.

Use ____ references when you want different formulas to refer to the same cell.

____________________ is a set of rules which specifies how a function should be written.

The following mixed reference in the formula, $A5, has an absolute column reference and a relative row reference.

When you copy a formula that contains an absolute reference to a new location, the reference ____.

The Insert Function dialog box has a(n) ____ option.

______ functions find values in tables of data and insert them in another location in the worksheet such as cells or in formulas.

One challenge of nesting functions is to make sure that you include all of the parentheses. 

A(n) ____________________ function is a function that works with statements that are either true or false.

Case 3-1 Ellen is a recent college graduate. She has decided to open a T-Shirt business and would like to create budget worksheet using Microsoft Excel 2016. She need to keep track of her expenses and income for the year. -Ellen opens Excel 2016 and enters her monthly income for one year beginning with January. To create a series of months, she can ____.

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

By default, AutoFill copies only the content not the formatting of the original range to the selected range. 

Lookup tables can be constructed for exact match or approximate match lookups. 

Case 3-1 Ellen is a recent college graduate. She has decided to open a T-Shirt business and would like to create budget worksheet using Microsoft Excel 2016. She need to keep track of her expenses and income for the year. -Ellen has entered all of her monthly expenses. She needs to create a formula that will deduct her monthly expenses from her monthly income. Since her monthly income is the same amount each month, she uses a(n) ____ to identify the cell containing the income value.

The IF function is a logical function that returns one value if a condition is true, and returns a different value if that condition is false. 

When you nest functions, you should have ____.

Using the AutoFill Options button, the Fill Without Formatting option copies the ____ but not the formatting.