Spreadsheets

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?

• =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)

You can present your data graphically, using a 

• chart
• print
• font
• sort

If B3:J8 is given, what is it referring to?

• range of cells B3 through J8
• only cell J8
• only cells B3 and J8
• only cell B3