Spreadsheets

Your teacher has given you all of yourgrades for the grading period. What isthe FASTEST way to calculate yourcurrent average as well as your newaverage when you make up missingassignments?

• Add it in your head
• Add it on a calculator
• Look in the teacher’s grade book
• Set up a spreadsheet

Which is TRUE about applying formattingto spreadsheet cells?

• Formatting can take place before or after data is entered
• Formatting must take place after datais entered
• Formatting must take place before data is entered
• Formatting can take place before but not after being entered

To format a range of cells in aspreadsheet to the nearest cent, howwould the number of decimal places beformatted?

• Four
• One
• Three
• Two

A mathematical operation that is builtinto a spreadsheet program to performshortcut calculations is called what?

• Cell
• Function
• Label
• Value

Mary entered her weekly allowance in cellC10 and entered the total she spent incell D10. Which formula will calculate theamount she has leftover?

• =C10 + D10
• =C10 * D10
• =C10 - D10
• =C10 / D10

When keying a formula in a spreadsheet,what must you key to inform the programthat you are entering a formula instead ofentering text?

• Addition operator
• Division operator
• Equal sign
• Subtraction sign

What function would return the sameanswer as the formula=B2+B3+B4+B5+B6+B7?

• =SUM(B2/B7)
• =SUM(B2+B7)
• =SUM(B2:B7)
• =SUM(B2*B7)

What application software  would  allow users to determine the average of a student's work?

• Database
• Desktop publishing
• Spreadsheet
• Word processing

The intersection of a column and row in aspreadsheet is called what?

• Cell
• Column
• Function
• Row

What is alphanumeric text not intendedfor calculation entered into a spreadsheetcalled?

• Formula
• Label
• Text
• Value