Y 8 Excel_Access Test

Cells that run horizontally on a spreadsheet

• Row

• Column

• Workbook

• Range

Cells that run vertically on a spreadsheet

• Row
• Workbook
• Worksheet
• Column

Data in a spreadsheet table can be sorted by single or multiple columns and alphabetically and numerically

• True
• False

What is normally used to perform calculations in a spreadsheet?

• Variable
• Formula
• Conditional formating
• Macro

SUM, AVERAGE, MAX and VLOOKUP are examples of what?

• Functions
• Tables
• Formulae
• Statistical tools

When you key a formula in a spreadsheet what do you key in first?

• Subtraction sign
• Equal Sign
• Addition sign
• Division sign

Which of the following is a valid formula?

• =sum(A1:A6)
• sum=(A1:A6)
• =sum[A1:A6]
• =sum(A1,A6)

Changing the appearance of a cell based on a rule is called?

• Conditional Formatting
• Validation Formatting
• Filter Formatting
• Sort Formatting

Which formula would subtract D12 from D13?

• =D13-D12
• =D12-D13
• =sum(D12-D13)
• =sum(D13-D12)

What does cell B6 contain?

• 23
• 0.45
• 0.50
• 23