There are 7 questions in total, and you need 6 correct answers to pass. When you pass, we will send you a certificate.
Click the button below to start.
Question 1 of 7
To quickly copy a formula, you can drag the bottom right corner of an active cell. What is this feature called?
Auto Copy
Auto Fill
Auto Drag
Auto Complete
A and B is correct
Question 2 of 7
Which formula would you use to summarize this column?
=SUM(B7)
=SUMMARIZE(B2:B6)
=SUM(B2:B6)
=SUMIFY(B2:B6)
=SUM(B2:B7)
Question 3 of 7
Which formula find the average of B2:B9?
=AVG(B10)
=AVG(B2:B9)
=AVERAGE(B2:B9)
=AVERAGE(A1:B10)
=AVERAGE(B10)
Question 4 of 7
Which formula is NOT represented in this exercise?
=MAX
=MIN
=SUM
=AVERAGE
=MEDIAN
Question 5 of 7
Which formula find the number that occurs most often?
=AVG
=MODE
Question 6 of 7
Which function would you use to adjust an input value? In this case the yearly return.
Goal Number
Number Seek
Auto Seek
Goal Seek
Auto Number
Question 7 of 7
Which of these are considered a logical test (used in IF-functions to get either "true" or "false").
C20 / D5
5 > 8
5 < 8
10 += 12
B32 <= B20