Deck 3: Cell References, named Ranges, and Functions

Question 1

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

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

Answer 1

A

Question 2

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

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

Answer 2

C

Question 3

There are how many different cell references?

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

Answer 3

B

Question 4

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

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

Question 5

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

A)Defined Names group on the HOME tab
B)Edit Names group on the HOME tab
C)Defined Names group on the FORMULAS tab
D)Edit group on the FORMULAS tab

Question 6

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

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

Question 7

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

A)Defined Names group on the FORMULAS tab
B)Edit group on the FORMULAS tab
C)Defined Names group on the HOME tab
D)Edit group on the HOME tab

Question 8

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

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

Question 9

The YEAR function returns the year in the range ________.

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

Question 10

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

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

Question 11

The inputs used by an Excel function are called ________.

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

Question 12

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

Question 13

When cell D4 containing the formula =$A4-B$5 is copied to cell E2,the formula in cell E2 is ________.

A)=$A4-B$5
B)=B4-C5
C)=$A2-C$5
D)=$A2-B$3

Question 14

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

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

Question 15

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

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

Question 16

A named range CANNOT begin with a(n)________.

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

Question 17

Which of the following is an alternative to using a space in a named range?

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

Question 18

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

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

Question 19

Function arguments are enclosed in a pair of ________.

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

Question 20

Which of the following is NOT an Excel function category?

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

Question 21

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 22

Which of the following is NOT a comparison operator symbol?

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

Question 23

Which of the following is NOT a financial function?

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

Question 24

Given the following information:

What is the result of =IF( B4>65,"Passing","Failing")?

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

Question 25

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

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

Question 26

Absolute cell referencing uses the # symbol.

Question 27

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

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

Question 28

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

Question 29

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

Question 30

A named range can begin with the / symbol.

Question 31

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 32

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

Question 33

Using the information in the format shown below and given a student's numerical average,which Excel function would be used to determine the student's letter grade?

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

Question 34

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

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

Question 35

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

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

Question 36

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

Question 37

Which of the following is NOT a common error message?

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

Question 38

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 39

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

A)45
B)22
C)1234
D)#NUM!

Question 40

Given the following information:

What is the result of =C1/A7?

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

Question 41

A named range CANNOT contain any spaces.

Question 42

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

Question 43

The logical comparison operator for not equal is ≠.

Question 44

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

Question 45

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

Question 46

In financial applications,the word "term" refers to the total time of a loan,usually in months or years.

Question 47

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

Question 48

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

Question 49

The TODAY and NOW functions return the same result.

Question 50

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

Question 51

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

Question 52

The logical comparison operator for greater than or equal to is ≥.

Question 53

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

Question 54

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

Question 55

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

Question 56

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

Question 57

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

Question 58

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

Question 59

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

Question 60

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

Question 61

=B$4 + $D5 is an example of ________ cell referencing.

Question 62

When cell C3 containing the formula =B4*C6 is copied to cell D1,the formula in cell D1 is ________.

Question 63

When cell C3 containing the formula =$C4-B$4 is copied to cell D8,the formula in cell D8 is ________.

Question 64

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

Question 65

A(n)________ cell reference changes when a formula or function is copied from one location to another location.

Question 66

You are likely to see the #NAME? error message if you typed =SIM(B4:D8)instead of =SUM(B4:D8).

Question 67

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

Question 68

Excel's ________ function rounds a number down to the nearest integer.

Question 69

The ________ Excel function category works with URL and XML connections.

Question 70

When cell D3 containing the formula =$B$5^$C$6 is copied to cell G7,the formula in cell G7 is ________.

Question 71

The result of =ROUNDUP(123.456,0)is ________.

Question 72

You create a named range by using the ________.

Question 73

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

Question 74

The AND function returns FALSE if any one of its arguments is FALSE.

Question 75

The OR function returns TRUE if any one of its arguments is true.

Question 76

Excel's ________ function returns the smallest number from a set of numbers.

Question 77

Excel's ________ function rounds a number down to the specified number of digits.

Question 78

The IFERROR function returns either a specified value if a function or formula returns an error; or it returns the value of the function or formula.

Question 79

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

Question 80

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