Processing Data(Y8 Unit3)

Cells that run horizontally on a spreadsheet

• Row

• Column

• Workbook

• Range

Cells that run vertically on a spreadsheet

• Row
• Workbook
• Worksheet
• Column

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?

• =C7*C8
• =(C7\C8)
• =(C7xC8)
• =AVERAGE(C7*C8)

Which of the following is a valid formula?

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

I can find the lowest number in a range with the ... function

• MIN
• MAX
• AVERAGE
• COUNT

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

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

To show the quantities in particular categories use a?

• Column Chart
• Line Graph
• Scatter Graph
• Sort Chart