Timedora
Free Practice Quiz Question List

3 Essential Spreadsheet Functions Online Quiz Questions

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

20 questions
01
True or false
1 point

True or false: Applying number formatting to a cell usually preserves its value as a number, while the TEXT function converts a number into text.

  1. A

    True

  2. B

    False

02
Written response
1 point

Which spreadsheet function removes leading and trailing spaces from text and reduces repeated spaces between words? Enter the function name.

03
Choose one
1 point

Column G contains sale totals, but some cells in G2:G100 contain text instead of numbers. Which formula counts only the numeric cells in that range?

  1. A

    Use =COUNTA(G2:G100) because it counts only numeric cells.

  2. B

    Use =COUNT(G2:G100) because it counts numeric cells and excludes text.

  3. C

    Use =COUNT(A2:A100) because it counts all nonempty cells, including text.

  4. D

    Use =SUM(G2:G100) because it counts the cells that contain numbers.

04
Fill in the blank
1 point

Complete the formula so it counts rows where the region in column D is West: =COUNTIF(D2:D100,)

05
Choose one
1 point

Cell E2 contains a spreadsheet date. Which formula calculates the date exactly one week later?

  1. A

    =E2*7

  2. B

    =E2+7/24

  3. C

    =E2+7

  4. D

    =DATE(E2,7,0)

06
True or false
1 point

True or false: Replacing every formula error with zero using IFERROR can hide an underlying data or formula problem.

  1. A

    True

  2. B

    False

07
Written response
1 point

Which spreadsheet function extracts the month component from the date in cell E2? Enter the function name.

08
Fill in the blank
1 point

Complete the formula to total sales in column G for rows where the region is West and the status is Paid: =(G2:G100,D2:D100,"West",F2:F100,"Paid")

09
Choose one
1 point

Column A contains a product name and column D its region. Which formula joins them with - between them, such as Widget - West?

  1. A

    =A2+D2

  2. B

    =A2&" - "&D2

  3. C

    =CONCAT(A2,D2)

  4. D

    =TEXT(A2," - ")&D2

10
Choose all
1 point

Select all functions that can apply multiple conditions to records in a conditional calculation.

  1. A

    COUNTIF

  2. B

    COUNTIFS

  3. C

    SUMIF

  4. D

    SUMIFS

11
Choose one
1 point

Which formula totals the sales in G2:G100 for dates in column E that fall during calendar year 2026?

  1. A

    =SUMIFS(E2:E100,G2:G100,">="&DATE(2026,1,1),G2:G100,"<"&DATE(2027,1,1))

  2. B

    =SUMIF(E2:E100,">="&DATE(2026,1,1),G2:G100)

  3. C

    =SUMIFS(G2:G100,E2:E100,">="&DATE(2026,1,1),E2:E100,"<"&DATE(2027,1,1))

  4. D

    =COUNTIFS(G2:G100,E2:E100,">="&DATE(2026,1,1),E2:E100,"<"&DATE(2027,1,1))

12
Choose all
1 point

When building a SUMIFS formula, select all statements that correctly describe its argument order or range setup.

  1. A

    Put the range to add first in the SUMIFS arguments.

  2. B

    Follow the range to add with condition-range and criterion pairs.

  3. C

    Keep the criteria ranges aligned in size with the range being summed.

  4. D

    Put each criterion range before the range to add.

13
Written response
1 point

Which spreadsheet function returns the current date, with a result that can change when the sheet recalculates? Enter the function name.

14
Open ended
1 point

A sales row has quantity in B2 and region in D2. Explain how =IF(AND(B2>=10,D2="West"),"Review","OK") classifies the row, including what happens when one or both conditions are false.

15
Choose one
1 point

Cells A2:A10 contain six numeric entries and two text entries, with no empty cells. Which function counts all eight nonempty cells?

  1. A

    =COUNT(A2:A10)

  2. B

    =COUNTA(A2:A10)

  3. C

    =SUM(A2:A10)

  4. D

    =COUNTIF(A2:A10,"*")

16
Choose one
1 point

A cell contains a product name with extra spaces at the beginning and end, plus repeated spaces between some words. Which function cleans up those spaces?

  1. A

    =TRIM(A2)

  2. B

    =LEN(A2)

  3. C

    =LEFT(A2,3)

  4. D

    =CONCAT(A2)

17
Written response
1 point

Which spreadsheet function returns the first three characters of the text in A2? Enter the function name.

18
Choose one
1 point

If E2 contains a valid date, what does =E2+7 calculate?

  1. A

    It returns the date seven weeks after the date in E2.

  2. B

    It adds seven months to the date in E2.

  3. C

    It returns the date seven days after the date in E2.

  4. D

    It extracts the day number from the date in E2.

19
Choose one
1 point

A spreadsheet formula uses =TEXT(C2,"$0.00") to display a price. What should you keep in mind if the value will also be used in later calculations?

  1. A

    It changes the cell's display format but keeps the result numeric.

  2. B

    It turns the number into formatted text, so the original numeric value should be kept for later calculations.

  3. C

    It rounds the number to two decimal places while preserving its numeric type.

  4. D

    It converts the number into a date.

20
True or false
1 point

True or false: =SUMIFS(G2:G100,D2:D100,"West",F2:F100,"Paid") adds values from G for rows where the region is West and the status is Paid.

  1. A

    True

  2. B

    False