Spreadsheet Formulas Quiz

What function in spreadsheets is used to calculate the sum of a range of cells?

• PRODUCT()

• SUM()

• AVERAGE()

• COUNT()

Which function would you use to find the average value in a range of cells?

• MEDIAN()

• MODE()

• AVERAGE()

• SUM()

To count the number of cells in a range that are not empty, which function should you use?

• COUNT()

• COUNTA()

• COUNTBLANK()

• SUM()

If you want to find the largest number in a range of cells, which function would you use?

• MIN()

• MAX()

• AVERAGE()

• SUM()

Which function can be used to conditionally sum cells that meet a certain criterion?

• SUM()

• AVERAGEIF()

• SUMIF()

• COUNTIF()

How would you write a formula to multiply two numbers in cell A1 and B1?

• =A1+B1

• =A1*B1

• =PRODUCT(A1, B1)

• Both B and C are correct.

Which function is used to round a number to a specified number of digits?

• ROUND()

• ROUNDDOWN()

• ROUNDUP()

• AVERAGE()

To join two or more text strings into one string, which function is used?

• CONCATENATE()

• JOIN()

• MERGE()

• TEXTJOIN()

Which function would you use to convert a text date into a serial number that Excel recognizes as a date?

• TEXTTODATE()

• DATEVALUE()

• DATETOTEXT()

• PARSEDATE()

What function returns the current date and time?

• TODAY()

• NOW()

• CURRENT()

• TIME()