Spreadsheet Basics

Numerical data that can be used in calculations entered into a spreadsheet is called what?

• label
• text
• value
• formula

What software program would allow users to determine the average of a student's  grades?

• word processing
• database
• spreadsheet
• desktop publishing

What specific format would change 29.99 to $29.99?

• currency
• scientific
• percent
• number

What is a statement that performs a calculation in a spreadsheet?

• value
• label
• formula
• cell

When keying a formula what must you key to inform the program that you are entering a formula?

• subtraction sign
• addition operator
• equal sign
• division operator

To format a range of cells in a spreadsheet to the nearest cent, how would the number of decimal places be formatted?

• four
• one
• three
• two

Which key do you press to see the results (answer) of a formula you have typed?

• shift
• spacebar
• enter
• CTRL

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

• cell
• column
• function
• row

A math operation that is built into a spreadsheet program to perform shortcut calculations is called what?

• label
• value
• function
• cell

What should you do in order to save revisions that you have made to an existing spreadsheet?

• save the revised spreadsheet
• print the spreadsheet
• create a new spreadsheet
• close the spreadsheet