Business Computer Apps Final Exam

Tables are created in Excel from which tab?

• Page Layout
• Review
• Insert
• Home

What is the most efficient formula for finding the total value for cells B2 through B5?

• =SUM(B2:B5)
• =B2+B3+B4+B5
• =13.5+6.08+7.53+45.1
• =B1++B5

How can you force a certain order of operations in a formula?

• By using parentheses
• They cannot be forced
• By positioning the operations from left to right
• By using simple formulas

What tab group would you use to change the format of cell A2 to match cell A3?

• Font
• Alignment
• Number
• Styles
• Cells

What number would the formula "=COUNT(A2:A7)" return?

• 4
• 3
• 5
• 6

Which Clear command would you use to make cell A2 look like cell B3?

• Clear All
• Clear Contents
• Clear Formats

How are a cell's content and format related?

• Changing the format affects the content.
• They are independent and not related.
• The content and the format are the same.

Which formula would you enter to return to number 45.1?

• =MAX(A2:B5)
• =MIN(A2:B5)
• =AVERAGE(A2:B5)
• =SUM(A2:b5)

What are the pieces of information that describe the appearance of a cell's content?

• Paste attributes
• Active attributes
• Edit attributes
• Format attributes

Which letter on the image is a Cell?

• A
• B
• C
• D