Deck 9: Cell References, Named Ranges, and Functions

Question 1

When cell A4 containing the formula =$B$5/$C$6 is copied to cell F6,the formula in cell F6 is ________.

A) =G7/H8
B) =$G$7/$H$8
C) =B5/C6
D) =$B$5/$C$6

Answer 1

D

Question 2

Which of the following is an alternative to using a space when naming a range?

A) Use a hyphen
B) Use an equal sign
C) Capitalize the first letter of each word
D) Use an underscore

Answer 2

D

Question 3

An example of a ________ is SUM(A1:A10)

A) function
B) text string
C) named range
D) formula

Answer 3

A

Question 4

To modify a named range,you select its name in the Name Box,then click Name Manager in the ________ tab.

A) Defined Names group on the Home
B) Edit Names group on the Home
C) Defined Names group on the Formulas
D) Edit Names group on the Formulas

Question 5

Optional arguments in a function are enclosed in a pair of ________.

A) braces { }
B) brackets [ ]
C) parentheses ( )
D) quotes " "

Question 6

When cell B2 containing the formula =A4*B6 is copied to cell C1,the formula in cell C1 is ________.

A) =A4*C5
B) =A4*B6
C) =B3*C5
D) =B3*C6

Question 7

Which of the following is NOT an Excel function category?

A) Educational
B) Cube
C) Logical
D) Financial

Question 8

Which of the following functions returns the number in the middle of a set of numbers?

A) COUNT
B) MEAN
C) MEDIAN
D) COUNTA

Question 9

To display the Create Names from Selection dialog box,you click Create From Selection in the ________ tab.

A) Defined Names group on the Formulas
B) Edit Names group on the Formulas
C) Defined Names group on the Home
D) Edit Names group on the Home

Question 10

The ________ command produces multiple named ranges at one time from the headings in rows,columns,or both from the data set.

A) Create New Names
B) Define Names
C) Create from Selection
D) Alt + Shift + F11

Question 11

An absolute cell reference is denoted by a(n)________.

A) dollar sign ($)
B) asterisk (*)
C) number sign (#)
D) at sign (@)

Question 12

Names for ranges CANNOT begin with a(n)________.

A) letter
B) number
C) underscore (_)
D) backslash (\)

Question 13

The inputs used by an Excel function to calculate a result are called ________.

A) parameters
B) arguments
C) dependent variables
D) independent variables

Question 14

________ is the keyboard shortcut to display a list of named ranges.

A) F1
B) F2
C) F3
D) F4

Question 15

An example of a ________ is (C5+D5)/100.

A) function
B) text string
C) named range
D) formula

Question 16

There are how many different types of cell references?

A) Two
B) Three
C) Four
D) Five

Question 17

If you wanted to find which value occurs most often in a cell range,you would use the ________ function.

A) MODE.SNGL
B) MEAN
C) MEDIAN
D) AVERAGE

Question 18

All arguments in a function are enclosed in a pair of ________.

A) braces { }
B) brackets [ ]
C) parentheses ( )
D) quotes " "

Question 19

Instead of typing the $ symbol in a cell reference,you can use the ________ keyboard shortcut.

A) F4
B) F2
C) F7
D) F11

Question 20

When using a text string in an argument,enclose the string in ________ so Excel will recognize it as a text string rather than a named range.

A) asterisks * *
B) brackets [ ]
C) parentheses ( )
D) quotes " "

Question 21

The result of =CONCATENATE("12","34")is ________.

A) 45
B) 1234
C) 22
D) 12,34

Question 22

If the value in B4 = 40,what is the result of =IF( B4>65,"Passing","Failing")?

A) TRUE
B) FALSE
C) Passing
D) Failing

Question 23

The YEAR function returns the year in the range ________.

A) 0-9000
B) 1000-9000
C) 1000-9999
D) 1900-9999

Question 24

The result of =MID("Tallahassee",6,3)is ________.

A) Tall
B) lahass
C) has
D) hassee

Question 25

Which of the following is NOT a comparison operator symbol?

A) ≠
B) =
C) <
D) >=

Question 26

If you wanted to determine how many cells in a range are not empty,you would use the ________ function.

A) HASVALUE
B) NOTEMPTY
C) COUNT
D) COUNTA

Question 27

What is the error message when you calculate the following in cell A1: 2756 ÷ 0?

A) #VALUE!
B) #DIV/0!
C) #REF!
D) #N/A

Question 28

Which of the following is NOT a guideline to follow when building formulas and functions?

A) Do not overuse parentheses..For example, use =SUM(Sales) instead of =(SUM(Sales)).
B) Avoid unneeded spaces in formulas.
C) Always put quotation marks around numeric values.
D) Use the negative sign, as in -333, to indicate negative numbers in formulas, rather than (333).

Question 29

The process of removing unwanted characters,rearranging data in a cell,or correcting erroneous data in text is called ________.

A) Flash Fill
B) concatenating
C) cleansing
D) purifying

Question 30

Which of the following is NOT a common error message?

A) #NAME?
B) #NPV?
C) #REF!
D) #VALUE!

Question 31

The ________ function returns the number of workdays between to dates.

A) NETWORKDAYS
B) WORKINGDAYS
C) DAYS
D) WEEKNUM

Question 32

The result of =FIND("is","Mississippi",3)is ________.

A) 5
B) 2
C) 4
D) 6

Question 33

Given a student's numerical average and a table that lists the grades and percent needed to obtain the grades in column format,which Excel function would be used to determine the student's letter grade?

A) MATCH
B) INDEX
C) HLOOKUP
D) VLOOKUP

Question 34

________ is the interest charged on both the principal and the interest that accumulates on a loan.

A) Simple interest
B) APR
C) The interest payment
D) Compound interest

Question 35

If you want to find the time between two dates,you would use the ________ function.

A) TIME
B) DATE
C) DATEDIF
D) WEEKNUM

Question 36

Which of the following is NOT a Lookup or Reference function?

A) VLOOKUP
B) INDEX
C) FIND
D) MATCH

Question 37

The result of =LEFT("Dallas,Texas",9)is ________.

A) as, Texas
B) Dallas, T
C) Dallas,Te
D) las,Texas

Question 38

Which of the following is NOT a financial function?

A) PMT
B) APR
C) PPMT
D) NPV

Question 39

What is the error message when you attempt to use a cell that has been deleted as a function argument?

A) #NPV?
B) #NAME?
C) #REF!
D) #N/A

Question 40

Which of the following is NOT a unit value option for the DATEDIF function?

A) H
B) M
C) D
D) Y

Question 41

A named range is a group of cells that have been given a name,which you can use when writing a formula or function.

Question 42

When constructing a formula,Excel's default reference type is relative cell referencing.

Question 43

A name of a range CANNOT contain any spaces.

Question 44

Excel's WEEKDAY function returns a number from 1-7 or 0-6.

Question 45

Excel's Text function category provides data about cell content within a worksheet.

Question 46

A name of a range can begin with the / symbol.

Question 47

When cell D3 containing the formula =C4*B4 is copied to cell F2,the formula in cell F2 is =C4*B4.

Question 48

Absolute cell referencing uses the # symbol.

Question 49

If you type =C,a list of functions and named ranges beginning with the letter "C" appears.

Question 50

The result of =ROUNDDOWN(98.765,0)is 98.

Question 51

When cell A3 containing the formula =$A$5+$B$6 is copied to cell G7,the formula in cell G7 is =$G$9+$H$10.

Question 52

Excel's RANDBETWEEN function returns a random number from 0 to less than 1.

Question 53

Functions can be created by using the Function Arguments dialog box or by typing the function in the cell.

Question 54

Excel's DAY function returns the day of the month.

Question 55

If you incorrectly name a range,you can rename it by selecting the data and naming the range again.

Question 56

Semantics is the structure and order of the function and the arguments used by Excel to perform a calculation.

Question 57

Excel's MAXIMUM function returns the largest number from a set of numbers.

Question 58

=$B$2 - C5 is an example of mixed cell referencing.

Question 59

When cell B3 containing the formula =$B4-C$5 is copied to cell D6,the formula in cell D6 is =$B7-E$5.

Question 60

Excel's AVERAGE function returns the mean of a set of numbers.

Question 61

To return the number of cells in a range of cells that are not empty,use the ________ function.

Question 62

A(n)________ range is an extension of a cell reference and provides a way to identify commonly used cell references or ranges.

Question 63

If more than one number occurs multiple times in a range of data,the ________ function can be used to return a vertical array,or list,of the most frequently occurring values in a range of data.

Question 64

The result of =LEN("54")is 9.

Question 65

To return the number of cells in a range of cells that contain numeric data,use the ________ function.

Question 66

The ________ function rounds down any decimal values associated with a number to the nearest
whole integer.

Question 67

Excel's TIME function returns the number of minutes in the range 1 to 60.

Question 68

The result of =LEFT("Washington",4)is Wash.

Question 69

The TODAY and NOW functions return the same result.

Question 70

In the number set 1 to 5,3 would be the middle of the data or the ________.

Question 71

$C$8 is an example of a(n)________ cell reference.

Question 72

B7 is an example of a(n)________ cell reference.

Question 73

The TRIM function returns text from which any leading,trailing,or extra spaces between words have been removed.

Question 74

Excel's ________ function returns the current date and time.

Question 75

________ refers to the structure and order of the function and the arguments used by Excel to perform a calculation.

Question 76

A(n)________ is a variable or value the function requires to calculate a solution.

Question 77

The result of =ROUND(123.456,2)is ________.

Question 78

The result of =DATEDIF("12/21/2014","11/02/2016","Y")is 2.

Question 79

A(n)________ is a named calculation which Excel uses to calculate the output based on the provided input.

Question 80

The result of ==ABS(6*-2)is ________.