Spreadsheets Exam

What is a Spreadsheet?

• Information stored in a spreadsheet program.
• A vertical or horizontal bar commonly located on the far right or bottom of a window that allows you to move the window viewing area, up, down, left, or right.
• a single "sheet" or "tab" inside a spreadsheet.
• A computer program that is used for storing, organizing and manipulating data.

What is a worksheet?

• Information stored in a spreadsheet program.
• A vertical or horizontal bar commonly located on the far right or bottom of a window that allows you to move the window viewing area, up, down, left, or right.
• a single "sheet" or "tab" inside a spreadsheet.
• A computer program that is used for storing, organizing and manipulating data.

An individual box within a worksheet is known as?

• square
• range
• refernce
• cell

What do all calculations start with?

• =

• (

• -

• \

What symbol should be used to perform a multiplying calculation?

• +

• -

• *

• /

What is the name for a line of cells that go across the spreadsheet?

• Row

• Column

• Field

• Record

What is the difference between a formula and a function?

• A function deals with a whole range of cells in one go and has a function name at the beginning, whereas a formula lists each cell individually and puts the correct mathematical operator between them

• A formula deals with a whole range of cells in one go and has a function name at the beginning, whereas a function lists each cell individually and puts the correct mathematical operator between them

• There is no difference between a formula and a function, they are the same

• A formula is something we use in maths, whereas a function is something we use in ICT

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)