Exam 3: Performing Calculations With Formulas and Functions

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 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? 

Functions are organized in the Function Library group on the FORMULAS tab._______________ 

Which of the following is a Statistical function? _____ 

In the formula =INT(AVERAGE(A1:A100)),which would occur first? ____ 

Which of the following is not a comparison operator? ____ 

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

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

____ references are seldom used other than when creating tables of calculated values such as a multiplication table in which the values of the formula or function can be found in the initial rows and columns of the table.

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

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

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

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

In the following formula: =IF(A1="YES","DONE","RESTART"),what happens if A1= "NO"? _____ 

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

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

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 ____.

Which of the following is not an Excel function category? ____ 

____ arguments may provide more control over the returned value.

A constant is a value in a formula that doesn't change._______________ 

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