Excel - Worksheet and Formula

What is the purpose of a spreadsheet? 

• Store large amount of data
• Process and manipulate data
• perform calculation
• All of the above

To allow you to evenly distribute a title over a table of numbers, use the

• Center button
• Merge and Center button
• Merge cells only button

How do you change column width to fit the contents?

• Single-click the boundary to the left of the column heading
• Double-click the boundary to the right of the column heading
• Press ALT and single-click anywhere in the column

The cell address of the highlighted cell is

• C

• 4

• A4

• C4

These are known as

• workbooks

• worksheets

• formula bar

• cell

A formula in the spreadsheet should always start with 

• a plus sign
• an asterisk
• an equals sign
• a capital letter

What are lines that can be applied around worksheet cells or objects?

• Gridlines
• Borders
• Underlines
• Boundaries

What is the name of this cell?

• B10
• 5B
• B5
• A5

_________ allows you to perform calculations on data entered into a spreadsheet?

• Formulas
• Data
• Cell
• Cell reference

You can only work in one cell at a time. The actual cell that you are working on is called what?

• Column
• Name Box
• Active Cell
• Row