Spreadsheets Quiz

Spreadsheets are organized by _____________

• cells and rows

• columns and rows

• columns and rolls

• cells and columns

These rectangular areas are called _____.

• cells

• seals

• columns

• rows

• sheets

Every cell has its own, unique address. How does a cell get its name?

• by its row and sheet

• by its column and cell

• by its column and row

• by its row and formula

Which one is NOT a correct formula to total the cells?

• =sum(b2--b5)

• =sum(b2:b5)

• =b2+b3+b4+b5

• =sum(b2+b3+b4+b5)

When we refer to a cell "address" rather than the value IN the cell, it is called ____.

• value referencing

• value naming

• cell recalling

• cell referencing

What is the advantage of using "cell referencing" rather than the value IN the cell?

Evaluate responses using AI:

OFF

What is the correct formula for figuring the PRICE of gas?

• MPG / Total miles * Price of gas

• Price of gas / Total miles * MPG

• Total miles / MPG * Price of gas

• Total miles * MPG / Price of gas

When I want to combine several cells into ONE, larger cell, it is called ____.

• mirroring

• merging

• combining

• connecting

If I wanted to merge cells, I would highlight them and then click ____.

• File

• Edit

• View

• Insert

• Format

What should I tap to "finish" a formula?

• Enter

• Finish

• Done

• Space