Mastering Spreadsheets Quiz

What is the purpose of the SUM function in a spreadsheet?

• To divide a series of numbers

• To multiply a series of numbers

• To add up a series of numbers

• To subtract a series of numbers

Which formula can be used to find the average value of the numbers in cells A1 through A10?

• =AVERAGE(A1:A10)

• =SUM(A1:A10)/10

• Both A and B

• =AVG(A1:A10)

What does the cell address A1 indicate?

• Column A and Row 1

• Column 1 and Row A

• The first cell in Column A

• Both A and C

How do you insert a pie chart in a spreadsheet?

• Select the data and press the pie chart button

• Write a formula to generate a pie chart

• Copy and paste from another document

• Use the SUM function

What function would you use to find the maximum value in a range of cells from B1 to B10?

• =MAX(B1:B10)

• =HIGHEST(B1:B10)

• =LARGEST(B1:B10)

• =TOP(B1:B10)

To find the minimum value in the cells C1 through C10, which function is correct?

• =SMALLEST(C1:C10)

• =MIN(C1:C10)

• =LOWEST(C1:C10)

• =BOTTOM(C1:C10)

What is the result of the formula =AVERAGE(2, 4, 6, 8)?

• 4

• 5

• 6

• 20

Which feature automatically adds up numbers in a column or row?

• AutoFill

• AutoSum

• AutoCalculate

• AutoAdd

What is the primary purpose of using charts and graphs in spreadsheets?

• To make it easier to perform calculations

• To visually represent data for better understanding

• To increase the file size of the spreadsheet

• To replace the need for formulas

What function would you use to count the number of cells in a range from D1 to D10?

• =COUNT(D1:D10)

• =SUM(D1:D10)

• =TOTAL(D1:D10)

• =NUMBER(D1:D10)