Review of Spreadsheets

Columns are identified using _______?

• Numbers
• Letters
• Numbers & Letters
• Cells

Rows are identified using ________?

• Numbers
• Letters
• Numbers & Letters
• Cells

Which formula is the correct for adding a column of values?

• SUM(E4:E10)
• =SUM(E4:E10)
• =AVG(E4:E10)
• =MAX(E4:E10)

What would you format a cell as when working with amounts of money?

• currency
• percent
• number
• scientific

What is the name of this cell?

• B10
• 5B
• B5
• you cannot know the name from this picture

Tags

CCSS.3.MD.B.3

What is displayed in cell A6?

• Monday
• Tuesday
• Wednesday
• Thursday

What is displayed in cell B1?

• 100
• Tickets Sold
• Day
• B1

Which of the following operators (symbols) represent multiplication in EXCEL spreadsheets?

• +

• -

• *

• /

Which of the following operators (symbols) represent division in EXCEL spreadsheets?

• +

• -

• *

• /

A spreadsheet is made up of one "workbook" and can have have many "worksheets".

• True

• False