Spreadsheet Basics Quiz

What is the correct formula to add the values in cells A1 and B1 in a spreadsheet?

• `=A1+B1`

• `=SUM(A1, B1)`

• `=ADD(A1, B1)`

• `=A1*B1`

How do you insert a new row between rows 3 and 4 in a spreadsheet?

• Right-click on row 3 and select "Insert Row"

• Right-click on row 4 and select "Insert Row"

• Right-click on row 3 and select "Delete Row"

• Right-click on row 4 and select "Delete Row"

Which function would you use to find the average of the values in cells A1 through A10?

• `=SUM(A1:A10)`

• `=AVERAGE(A1:A10)`

• `=MEAN(A1:A10)`

• `=MEDIAN(A1:A10)`

How do you delete column B in a spreadsheet?

• Right-click on column B and select "Delete Column"

• Right-click on column B and select "Insert Column"

• Right-click on column B and select "Hide Column"

• Right-click on column B and select "Clear Column"

What is the correct formula to calculate the sum of the values in cells C1 through C5?

• `=SUM(C1:C5)`

• `=ADD(C1:C5)`

• `=TOTAL(C1:C5)`

• `=C1+C2+C3+C4+C5`

Which option allows you to sort data in ascending order in a spreadsheet?

• Data > Sort Z to A

• Data > Sort A to Z

• Data > Filter

• Data > Group

How do you apply a filter to a range of data in a spreadsheet?

• Select the range and click on "Data > Sort"

• Select the range and click on "Data > Filter"

• Select the range and click on "Data > Group"

• Select the range and click on "Data > Subtotal"

What is the result of the formula `=SUM(A1:A3)` if A1=2, A2=3, and A3=5?

• 8

• 10

• 15

• 5

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

• `=MAX(A1:A10)`

• `=MIN(A1:A10)`

• `=LARGE(A1:A10)`

• `=HIGHEST(A1:A10)`

How do you delete multiple rows at once in a spreadsheet?

• Select the rows, right-click, and choose "Delete Rows"

• Select the rows, right-click, and choose "Insert Rows"

• Select the rows, right-click, and choose "Hide Rows"

• Select the rows, right-click, and choose "Clear Rows"