Spreadsheet Basics

An individual box within a worksheet is known as?

• square
• range
• reference
• cell

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 write a formula in a spreadsheet what do you key in first?

• Subtraction sign
• Equals Sign
• Addition sign
• Division sign

A spreadsheet is made of cells organised into horizontal rows and vertical?

• Columns
• Fields
• Records
• Blocks

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

• MIN
• MAX
• AVERAGE
• COUNT

Which of the following is a valid formula?

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

What function would return the sameanswer as the formula=B2+B3+B4+B5+B6+B7?

• =SUM(B2/B7)
• =SUM(B2+B7)
• =SUM(B2:B7)
• =SUM(B2*B7)

The set of cells that are horizontal in direction on a spreadsheet are referred to as 

• rows
• columns
• cells
• spreadsheet

What symbol do we use for multiplication in EXCEL? 

• /
• =
• ^
• *