Mastering Spreadsheet Basics

What is the correct formula to add cells A1 and A2?

• =A1 * A2

• =SUM(A1, A2)

• =A1 + A2

• =A1 - A2

How do you create a formula that multiplies B1 by C1?

• =B1*C1

• =B1+C1

• =B1-C1

• =B1/C1

What symbol is used to start a formula in a spreadsheet?

• -

• +

• =

• *

What function would you use to find the average of a range of cells?

• SUM

• MAX

• COUNT

• AVERAGE

How do you create a formula that subtracts D1 from D2?

• =D2+D1

• =D1+D2

• =D2-D1

• =D1-D2

What is the purpose of the SUM function in spreadsheets?

• The purpose of the SUM function is to calculate the total of a set of numbers.

• To count the number of entries in a dataset.

• To display the maximum value in a range of cells.

• To find the average of a set of numbers.

What does the COUNT function do in a spreadsheet?

• The COUNT function sums all entries in a range.

• The COUNT function counts all entries, including text.

• The COUNT function averages numeric entries in a range.

• The COUNT function counts numeric entries in a range.

How do you create a formula that divides E1 by F1?

• =E1/F1

• E1/F

• E1 divided by F1

• =F1/E1

What function would you use to find the maximum value in a range?

• MAX

• SUM

• AVERAGE

• MIN