Question 1

The result of =CONCATENATE("12","34")is ________.
A) 45
B) 1234
C) 22
D) 12,34

Accepted Answer

The CONCATENATE function joins two or more texts into one text string. In this case, it joins the texts "12" and "34" to make the text string "1234".

Question 2

If the value in B4 = 40,what is the result of =IF( B4>65,"Passing","Failing")?
A) TRUE
B) FALSE
C) Passing
D) Failing

Accepted Answer

The formula checks if the value in B4 is greater than 65. Since 40 is not greater than 65, the condition is false, and the formula returns "Failing".

Question 3

The YEAR function returns the year in the range ________.
A) 0-9000
B) 1000-9000
C) 1000-9999
D) 1900-9999

Accepted Answer

The YEAR function in Excel returns the year as a four-digit number from a date, and it supports years in the range 1900 to 9999.

Question 4

The result of =MID("Tallahassee",6,3)is ________.
A) Tall
B) lahass
C) has
D) hassee

Accepted Answer

The MID function takes three arguments: the text string to extract from, the starting position of the extraction, and the number of characters to extract. In this case, the function starts at the sixth character of "Tallahassee" ("h") and extracts three characters, resulting in "has".

Question 5

Which of the following is NOT a comparison operator symbol?
A) ≠
B) =
C) <
D) >=

Accepted Answer

The symbol ≠ (not equal to) is a logical operator, not a comparison operator. The comparison operators are = (equal to), < (less than), > (greater than), <= (less than or equal to), and >= (greater than or equal to).

Question 6

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

Accepted Answer

The function COUNTA counts the number of cells in a range that contain any type of data, including text, numbers, logical values, and error values. This function is designed to count non-empty cells.

Question 7

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

Accepted Answer

The answer of What is the error message when you...

Question 8

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

Accepted Answer

Quotation marks are only necessary when using text values in formulas, not numeric values.

Question 9

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

Accepted Answer

The process of removing unwanted characters, rearranging data in a cell, or correcting erroneous data in text is called data cleansing. This is done to ensure that the data is accurate, consistent and usable. The other options, such as Flash Fill, concatenating and purifying, do not refer specifically to this process.

Question 10

Which of the following is NOT a common error message?
A) #NAME?
B) #NPV?
C) #REF!
D) #VALUE!

Accepted Answer

While #NAME?, #REF!, and #VALUE! are common Excel error messages, #NPV is not a standard error message.

Question 11

The ________ function returns the number of workdays between to dates.
A) NETWORKDAYS
B) WORKINGDAYS
C) DAYS
D) WEEKNUM

Accepted Answer

The NETWORKDAYS function is used to calculate the number of workdays between two dates in Excel. It excludes weekends and any holidays that you specify as arguments.

Question 12

The result of =FIND("is","Mississippi",3)is ________.
A) 5
B) 2
C) 4
D) 6

Accepted Answer

The FIND function in Excel searches for a text string within another text string and returns the position of the first occurrence, starting at a specified position. In this case, searching for "is" in "Mississippi" starting from the 3rd character will find "is" at the 5th position (Mississippi).

Question 13

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

Accepted Answer

VLOOKUP is the best choice as it allows searching for a value in the leftmost column of a table and returns the corresponding value from a specified column in the same row. This makes it ideal for looking up a student's letter grade based on their numerical average and the associated percent required for each grade.

Question 14

________ 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

Accepted Answer

Compound interest is the interest charged on both the principal and the interest that accumulates on a loan over time. It is calculated by adding the interest accrued each period to the principal amount, then calculating interest based on the new total. This leads to a higher total amount paid on the loan compared to simple interest, which only charges interest on the principal amount.

Question 15

If you want to find the time between two dates,you would use the ________ function.
A) TIME
B) DATE
C) DATEDIF
D) WEEKNUM

Accepted Answer

The DATEDIF function is specifically designed to calculate the difference between two dates in years, months, or days. It is the best choice for finding the time between two dates.

The TIME function is used to create a time value from hours, minutes, and seconds, and is not suited for finding the time between two dates.

The DATE function is used to create a date value from year, month, and day values, and is not suited for finding the time between two dates.

The WEEKNUM function is used to determine the week number of a specified date, and is not suited for finding the time between two dates.

Question 16

Which of the following is NOT a Lookup or Reference function?
A) VLOOKUP
B) INDEX
C) FIND
D) MATCH

Accepted Answer

FIND function is a text function used to find the position of a string within another string. It is not a Lookup or Reference function that retrieves data from a table or array.

Question 17

The result of =LEFT("Dallas,Texas",9)is ________.
A) as, Texas
B) Dallas, T
C) Dallas,Te
D) las,Texas

Accepted Answer

The LEFT function in Excel extracts a given number of characters from the start of a string. In this case, =LEFT("Dallas,Texas",9) extracts the first 9 characters from "Dallas,Texas", resulting in "Dallas, T".

Question 18

Which of the following is NOT a financial function?
A) PMT
B) APR
C) PPMT
D) NPV

Accepted Answer

PMT, PPMT, and NPV are all financial functions commonly used in financial analysis and planning. PMT calculates the payment amount for a loan or annuity, PPMT calculates the payment amount that goes towards the principal of a loan, and NPV calculates the present value of future cash flows. APR, on the other hand, is an acronym for Annual Percentage Rate, which is a measure of the cost of borrowing money and not a financial function.

Question 19

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

Accepted Answer

The error message #REF! appears when you attempt to use a cell that has been deleted as a function argument. This error indicates that a reference in a formula is not valid because it refers to cells that do not exist or have been deleted.

Question 20

Which of the following is NOT a unit value option for the DATEDIF function?
A) H
B) M
C) D
D) Y

Accepted Answer

H is not a valid unit value option for the DATEDIF function. The valid unit value options are Y (years), M (months), and D (days).

Quiz 9: Cell References, Named Ranges, and Functions

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

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

The YEAR function returns the year in the range ________.

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

Which of the following is NOT a comparison operator symbol?

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

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

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

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

Which of the following is NOT a common error message?

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

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

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?

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

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

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

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

Which of the following is NOT a financial function?

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

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