Spreadsheet Review

What command on the menu bar is used to ceate a header/footer.

• format

• help

• insert

• file

How is a line style or outline added to a cell?

• cell border

• cell color

• cell attribute

• cell reference

what software would be used to enter, calculate, manipulate, and analyze numbers?

• desktop publishing

• database

• word processing

• spreadsheet

Paul has to enter the zip code for a client. How will this data be classified?

• label

• value

• formula

• function

What specific format would change 29.99 to $29.99?

• scientific

• currency

• percentage

• number

A spreadsheet formula always begins with = sign

• true

• false

After entering the number of sales for the first quarter, where will they align in a spreadsheet?

• right

• left

• centered

• justified

Samantha needs to total the cell range A1 to A10. What is the most efficient method to find the answer?

• label

• value

• formula

• function

__________________is used to combine two or more cells

• file

• wrap

• font

• merge

What is the BEST way to resolve repeated pound signs or hashtags in a formula's result?

• Delet the formula and rekey it

• Widen to column to accommodate it

• shorten the form so it fits

• delete the formula and key the answer