# a1 ),” weekend “,” weekday “,” weekday “, weekday “,” weekday “,” weekday “,” weekend “) b B u s i n e s s F i n a n c e

a1 ),” weekend “,” weekday “,” weekday “, weekday “,” weekday “,” weekday “,” weekend “) b B u s i n e s s F i n a n c e

29 Questions. How cheap of a price can they be?

1) A _____ list is preferred by most people because they think it is easier to read.
A) Horizontal B) Vertical C) Bulleted D) Numbered

2) To select all blank cells in a list, use the Special menu. Which shortcut opens the Go To menu that contains the Special button?
A) Esc B) F1 C) F5 D) Ctrl + Esc

3) Write a formula to return the first three characters and the last three characters in cell J1.
A) Left(3)&Right(3) B) Left(3,J1)&Right(3,J!) C) Left(J1,3)+Right(J1,3) D) Left(J1,3)&Right(J1,3)

4) Write a CHOOSE function that will determine whether a date in cell A1 occurs on a weekday or weekend.
A) WEEKDAY(CHOOSE(A1),”Weekend”,”Weekday”,”Weekday”,Weekday”,”Weekday”,”Weekday”,”weekend”)

B) CHOOSE(A1,”Weekend”,”Weekday”)
C) CHOOSE(WEEKDAY(A1),Weekend,Weekday,Weekday,Weekday,Weekday, Weekday,Weekend)
D) CHOOSE(WEEKDAY(A1),”Weekend”,”Weekday”,”Weekday”,”Weekday”,”Weekday”,”Weekday”,”Weekend”)

5) An IF statement nested within another IF statement will produce how many possible results?
A) two B) three C) four D) one

6) Cell E1 contains the date 8/22, and cell E2 contains the date 10/21. What is the result of DATEDIF(E1,E2″m”)?
A) 2 B) 1 C) 12 D) 0

7) The EDATE function requires two arguments. Which type is the second argument?
A) hours B) years C) days D) months

8) Use the IFS function to return 5 if cell A5 contains the value 3, and return a 6 if it contains any other number.
A) IFS(A5=3, 5, 1, 6 B) IFS(A5=3, ELSE 6) C) IFS(A5=3, 5, 0, 6) D) IFS(A5=3, 5, 6)

9) Create a formula that will return the data in the last cell in column A that is not blank.
A) OFFSET(A1,COUNTA(A:A)-1.0) B) OFFSET(A1,COUNTA(A:A)-1) C) OFFSET(A1,COUNTA(A:A)) D) OFFSET(A1,COUNTA(-1),0)

10) Which two-digit year will Excel identify as in the twenty-first century and not the twentieth?
A) 88 B) 25 C) 31 D) 45

11) An employee worksheet lists employee names in column A and their
salaries in column B. Which formula shows the total payroll, and will
not need to be changed if the list gets larger or smaller?
A) SUM(B:B) B) SUM(B:END) C) SUM(B) D) SUM(B1:B)

12) What will be displayed with the formula DATE(2020,13,15)?
A) 44150 B) 44211 C) 44180 D) #VALUE

13) All range names are _____ addresses.
A) absolute B) initial C) relative D) reference

14) Which MOD formula will return 2?
A) MOD(28,5) B) MOD (25,5) C) MOD(12,5) D) MOD(10,5)

15) Your boss asks you to generate a random number between 0 and 100. Which formula will provide this result?
A) RANDM(0,100) B) RANDOM(0,100) C) RANDBETWEEN(00, 100) D) RANDARRAY(0,100)

16) To aggregate using the average, the first argument in the AGGREGATE formula should be _____.
A) 1 B) 9 C) AVERAGE D) AVG

17) What is the keyboard shortcut for the Show Formulas button?
A) Ctrl+S B) Ctrl_Tilde C) Ctrl+F D) Ctrl_Esc

18) Which formula returns an error if the argument passed to it is greater than 3999?
A) LATIN B) ROMAN C) GREEK D) ARABIC

19) Which formula will return the number of blank cells in cells A1:A100?
A) COUNTBLANK(A:A) B) COUNTBLANK(A) C) COUNTBLANK(A, 1:100) D) COUNTBLANK(A1:A100)

20) Cell C1 contains an employee salary. Write an Excel formula to round the salary to the nearest \$100.
A) ROUNDUP(C1, -2) B) ROUND(C1,2) C) ROUND(C1,100) D) ROUND(C1,-2)

21) Which function will return TRUE if cell G7 is blank?
A) ISTEXT(G7) B) ISNA(G7) C) ISNONTEXT(G7) D) ISNUMBER(G7)

22) Which function returns TRUE if cell A1 contains a #N/A error?
A)ISERR(A1) B) ISLOGICAL(A1) C) ISERROR(A1) D) ISFORMULA(A1)

23) An employee list shows salaries in column B and the number of years
worked in column C. Write a formula to find the lowest salary for
employees who have worked longer than five years.
A) MINIFS(B:B,C:C,5) B) MINIFS(B:B,5,C:C) C) MINIFS(C:C,5,B:B) D) MINIF(B:B,C:C,5)

24) The ISFORMULA function can be used with _____ to highlight all cells in a worksheet that contain a formula.
A) Formal Painter B) Fill C) Conditional Formatting D) Styles

25) When using SUMIFS, why is it a good idea to use entire column references?
A) Excel can scan an entire column faster B) The function will not need to be changed as the criteria list grows or shrinks.C) Using an entire column reduces the potential for error. D) The function only works with entire columns or rows.

26) What is the TRIM function used for?
A)To shrink text B) to remove all spaces between words C) to remove characters from the end of a string D) to remove leading and trailing spaces

27) With the TEXTJOIN function, use a _____ delimiter to combine text from multiple cells.
A) comma B) tab C) space D) period

28) Which Excel function capitalizes only the first letter in someone’s name?
A) UPPER B) TRIM C) LOWER D) PROPER

29) Cell D4 contains a ten-digit phone number with hyphens after the third
and sixth digits. Which function will remove the hyphen after the sixth
digit?
A) SUBSTITUTE(D4,”-“,2) B) REPLACE(D4,”-“,””) C) SUBSTITUTE(D4,”-“,””,2) D) REPLACE(D4,”-“,””2) 