FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 3: Calculating Data With Formulas and Functions

Show Answer

Share

---

All types

Filters

Study Flashcards

Question 1

Short Answer

Review LaterAdd Note

Review Later

A(n)____________________ operator is a symbol that indicates the relationship between two values.

Correct Answer

verified

Show Answer

Question 2

Multiple Choice

Review LaterAdd Note

Review Later

Which function counts how many cells in a range contain numbers,where value1,value2,and so forth are text,numbers,or cell references?

A) SUM
B) COUNT
C) COUNTA
D) AUTOSUM

E) A) and B)
F) B) and D)

Correct Answer

verified

Show Answer

Question 3

Short Answer

Review LaterAdd Note

TODAY is an example of a(n)____________________ function.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Contains both relative and absolute references.

Explain what a logical function is and give an example of when you would use one in Excel 2013.

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

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 2013. She need to keep track of her expenses and income for the year. -Ellen wants to find out what her median monthly spending is.The monthly totals for her spending appear in the range A10:L10.Which of the following is NOT a way to enter the MEDIAN function into her database?

The ____________________ function is a logical function that returns one value if the statement is true and returns a different value if the statement is false.

In the formula =IF(A1=B1,C1,C2) ,the result will be C2 if ____.

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 2013. She need to keep track of her expenses and income for the year. -Ellen's spending varies from month to month.She wants to calculate the total expenses for each month.She wants to see all of the arguments associated with the SUM function so she clicks the ____ then clicks SUM to open the Function Arguments dialog box.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -A function inside another function

The ____________________ organizes all of the functions by category and allows you to search for functions that perform particular calculations.

To display the current date and time,which is updated each time the workbook is reopened, use the TODAY function.

Excel functions are organized into ____ categories.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Function counts the number of nonblank cells in the specified range

An error value indicates that some part of a $\underline { \text { function } }$ is preventing Excel from returning a calculated value.________________

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

Which of the following is a Math & Trig function? ____

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 2013 Analysis tools. -Susan designs a worksheet with the inventory number,description,quantity,unit cost,reorder point and value. To find values in tables of data,and insert them in another location in the worksheet such as cells or in formulas,she will use ________.

Which of the following is not a comparison operator? ____