Timedora
Free Practice Quiz Question List

2 Formulas and Functions Online Quiz Questions

Use this free practice quiz with 20 questions to review 2 Formulas and Functions, test your knowledge, and prepare for your next test or exam.

20 questions
01
True or false
1 point

A spreadsheet range contains a mix of numbers and text entries. Is it true that COUNT counts numeric entries, while COUNTA counts all populated cells?

  1. A

    True

  2. B

    False

02
True or false
1 point

Is it true that subtracting one valid spreadsheet date from another returns the number of months between them?

  1. A

    True

  2. B

    False

03
Fill in the blank
1 point

In SUMIFS, the comes first, followed by pairs of criteria ranges and criteria.

04
Fill in the blank
1 point

Formatting a number with the TEXT function converts the result to .

05
Written response
1 point

Which single operator symbol joins text values in a spreadsheet formula?

06
Written response
1 point

In =XLOOKUP(F2,A2:A100,C2:C100,"Not found",0), what number specifies an exact match?

07
Choose one
1 point

Which formula constructs a spreadsheet date from the year 2026, month 10, and day 12?

  1. A

    =DAY(2026,10,12)

  2. B

    =DATE(2026,10,12)

  3. C

    =YEAR(2026,10,12)

  4. D

    =MONTH(2026,10,12)

08
Choose one
1 point

A tax rate is stored in F1, and =B2*$F$1 is copied down one row. How do the two references behave in the copied formula?

  1. A

    Both B2 and $F$1 stay fixed when copied down.

  2. B

    B2 stays fixed, while $F$1 changes by row.

  3. C

    B2 changes by row, while $F$1 stays fixed.

  4. D

    Both references change by row when copied down.

09
Choose one
1 point

What does =XLOOKUP(F2,A2:A100,C2:C100,"Not found",0) do?

  1. A

    Search C2:C100 for F2 and return the corresponding value from A2:A100.

  2. B

    Search A2:A100 for F2 and return the corresponding value from C2:C100, or “Not found” if there is no match.

  3. C

    Search A2:A100 for “Not found” and return the value in F2.

  4. D

    Return the first value in C2:C100 regardless of whether F2 is found.

10
Choose all
1 point

Select all operators that compare values and produce TRUE or FALSE.

  1. A

    =

  2. B

    &

  3. C

    <=

  4. D

    <>

  5. E

    *

11
Choose all
1 point

A table has prices and region data. Select all functions that can add prices conditionally based on region criteria.

  1. A

    SUMIF

  2. B

    COUNTIFS

  3. C

    SUMIFS

  4. D

    AVERAGE

12
True or false
1 point

Is it true that =IF(AND(B2>=100,D2="West"),"Review","") returns “Review” only when the quantity is at least 100 and the region is West?

  1. A

    True

  2. B

    False

13
Open ended
1 point

A spreadsheet formula returns an unexpected result. Describe a reliable process for checking the data and formula, and name at least two specific things to inspect.

14
Choose one
1 point

Which formula adds the values in B2 and C2 first, then multiplies their sum by D2?

  1. A

    =B2+C2*D2

  2. B

    =(B2+C2)*D2

  3. C

    =B2+(C2*D2)

  4. D

    =B2*C2+D2

15
Choose one
1 point

Which formula constructs the date October 12, 2026, using the function's year, month, and day argument order?

  1. A

    =DATE(10,12,2026)

  2. B

    =DATE(2026,10,12)

  3. C

    =DATE(2026,12,10)

  4. D

    =DATE(12,10,2026)

16
Choose one
1 point

A spreadsheet uses =TEXT(C2,"$0.00") to display a value as currency. What should you keep in mind if you need that value in later arithmetic?

  1. A

    It makes the number an absolute cell reference.

  2. B

    It converts the formatted result into a date value.

  3. C

    It converts the number to text, so the original numeric value is better for later arithmetic.

  4. D

    It rounds the original number and preserves it as a number.

17
Choose one
1 point

A lookup formula returns #N/A. Which problem does this error indicate in the spreadsheet examples?

  1. A

    The lookup found no match.

  2. B

    The formula divided by zero.

  3. C

    The formula has converted a number to text.

  4. D

    The formula is missing an absolute reference.

18
Choose one
1 point

Which formula multiplies the values in cells B2 and C2?

  1. A

    =B2*C2

  2. B

    =B2+C2

  3. C

    =B2/C2

  4. D

    =B2^C2

19
Written response
1 point

Write a formula that returns the first three characters from the text in cell A2. Use either a comma or a semicolon between function arguments, depending on your spreadsheet settings.

20
Written response
1 point

Write a mixed cell reference that fixes column B but allows the row to adjust when the formula is copied.