Excel Basics Quiz

Which of these does spreadsheet software allow you to do with data? (Select ALL correct answers

• Organize It

• Analyze It

• Present It

• Anticipate It

• Embrace It

A complete Excel file is called a ​ (a)   . Each "page" of a workbook is called a ​ (b)   . A group of highlighted cells is called a ​ (c)   . A single block at the intersection of a row and column is called a ​ (d)   .

• workbook
• spreadsheet
• range
• cell

Columns are ​​ (a)   and go ​ (b)   . Rows are ​ (c)   and go ​ (d)   .

• lettered
• up and down
• numbered
• across

Tags

CCSS.5.G.A.1

Google's spreadsheet software is called ​ (a)   .

Microsoft's spreadsheet software is called ​ (b)   .​

• Sheets
• Excel
• Word
• Docs
• PowerPoint
• Slides

Tags

CCSS.RI.9-10.4

CCSS.RI.9-10.4

CCSS.RI.6.4

CCSS.RI.7.4

CCSS.RI.8.4

As seen in the screenshot, complete the following for Social Studies:

Cell Address:​ (a)  

Column:​ (b)  

Row:​ (c)  

• N29
• N
• 29
• N27
• 28
• O
• 27
• O28
• O29
• O30

As seen in the screenshot, complete the following for Art:

Cell Address:​ (a)  

Column:​ (b)  

Row:​ (c)  

• O28
• N
• 29
• N27
• 28
• O
• 27
• N29
• O29
• O30

What is the correct way to write the cell address for Athletics.

• N30

• N:30

• N,30

• 30N

• (N,30)

What is the correct way to write the range of cells that contain text.

• N27...O30

• O30:N27

• N27:O30

• 27O , 30N

• N30 to O27

What is the range of cells used to find the Total Boogers Picked?

• Q28:R32

• R27:R34

• R28:R32

• Q27:R34

What is the range of cells used to find the Average Boogers Picked? (HINT: Do NOT include the Total.)

• Q28:R32

• R28:R33

• R28:R32

• Q27:R34