ch 2 excel

Question 1

Which of the following functions should be used to insert the current date and time in a​ cell?

A. ​=CURRENT()
B. ​=TODAY()
C. ​=DATE
D. =NOW()

Answer 1

D. =NOW()

Question 2

When using the 1900 date​ system, the date​ 1/1/1900 is equivalent to what​ number?

A. 0
B. .1
C. ​-1
D. 1

Answer 2

D. 1

Question 3

If the function​ =XLOOKUP(H13,C4:C10,B4:B10,”Item Not​ Found”,1,1) is​ used, what will happen if an exact match is not​ found?

A. The function will return the value​ #NA.
B. The function will return the next larger item.
C. The function will perform a wildcard match.
D. The function will return the next smaller item.

Answer 3

B. The function will return the next larger item.

Question 4

The function​ =PMT(C5,C7,-C3) is stored in cell C15. What must be stored in cell​ C5?

A. APR
B. Periodic interest rate
C. Loan amount
D. Number of payment periods

Answer 4

B. Periodic interest rate

Question 5

What value will the MAXA function return if given the values​ -.02, -.07,​ -.09, and​ NA?

A. #Name
B. -.09
C. NA
D. 0

Answer 5

D. 0

Question 5

What is the keyboard shortcut to create an absolute​ reference?

A. F4
B. F2
C. F3
D. Alt

Answer 5

A. F4

Question 6

Which function is best utilized to perform a lookup when the lookup array and return array are in different tables within the​ workbook?

A. VLOOKUP
B. XLOOKUP
C. LOOKUP
D. HLOOKUP

Answer 6

B. XLOOKUP

Question 7

What function would most efficiently accomplish the same thing as​ =(B5+C5+D5+E5+F5)/5?

A. ​=MEDIAN(B5:F5)
B. =SUM(B5:F5)
C. =AVERAGE(B5:F5)
D. ​=COUNT(B5:F5)

Answer 7

C. =AVERAGE(B5:F5)

Question 8

When you start to type​ =AV, what feature displays a list of functions and defined​ names?

A. Function Arguments dialog box
B. Function ScreenTip
C. Formula AutoComplete
D. Insert Function dialog box

Answer 8

C. Formula AutoComplete

Question 9

Which of the following is not a comparison​ operator?

A. &            
B. ​>            
C. <            
D. <>      

Answer 9

A. &