Spreadsheets

6. How can you use the SUM function to add a range of cells in a spreadsheet?

• =SUM(A1*A10)

• =SUM(A1+A10)

• =SUM(A1:A10)

• =SUM(A1-A10)

8. What are some advanced features in a spreadsheet that can be used for data analysis?

• Animation, slide transitions, and speaker notes

• Pivot tables, data validation, conditional formatting, and advanced formulas

• Word count, line spacing, and font style

• Pie charts, VLOOKUP, and spell check

What does cell A1 contain?

• Sweet
• Mars
• A1
• Cost

What does cell B6 contain?

• 23
• 0.45
• 0.50
• 23

What does cell C3 contain?

• 23
• 67
• Amount
• 11.50

What formula is used in cell D3?

• B3*C3
• B3+C3
• =B3*C3
• 11.50

What formula is used in cell D8?

• =D3*D4*D5*D6
• SUM(D3:D6)
• =69.10
• =SUM(D3:D6)

What symbol do you use to add two cells' values in Excel?

• +

• -

• =

• *

• /

What symbol do all formula start with in Excel?

• +

• -

• =

• *

• /

Columns are identified using _______?

• Numbers
• Letters
• Numbers & Letters
• Cells