Chapter 4 - Spreadsheet Applications

Question 1

What is a spreadsheet workbook?

Answer 1

A workbook contains sheets

Question 2

What is a worksheet?

Answer 2

A page in a spreadsheet that looks like a grid

Question 3

What is a spreadsheet?

Answer 3

Software designed to perform calculations and recalculations automatically

Question 4

What is a cell?

Answer 4

a rectangle in a worksheet grid

Question 5

What is a range of cells?

Answer 5

When a group of cells on a spreadsheet are selected together

Question 6

What is a cell reference?

Answer 6

The address of a cell on a worksheet, given as a letter and number, e.g. A4
The letter represents the column and the number represents the row

Question 7

What data types can be applied to cells?

Answer 7

Number
Currency
Date/time
Text

Question 8

What is validation?

Answer 8

Rules applied to ensure an entered value is reasonable

Question 9

What is a template?

Answer 9

A document that has a preformatted layout and can be copied to make new documents

Question 10

What is a wizard?

Answer 10

A software tool that helps a user complete a complex process by guiding them through the process step-by-step

Question 11

What does a formula always start with?

Answer 11

=

Question 12

What are the 4 parts of a function?

Answer 12

=function_name(?)

1. =
2. function name
3. brackets
4. something inside the brackets (changes depending on the function)

e.g.
=if(condition, value if true, value if false)

Question 13

What is the =sum() function used for?

Answer 13

Adding a range of cells

Question 14

What is the =average() function used for?

Answer 14

Finding the average of a range of cells

Question 15

What is the =min() function used for?

Answer 15

Finding the smallest value in a range of cells

Question 16

What is the =max() function used for?

Answer 16

Finding the largest value in a range of cells

Question 17

What is the =if() function used for?

Answer 17

Deciding on a value based on a condition

Question 18

What is the =vlookup() function used for?

Answer 18

The vertical lookup function looks up a value in a table and returns information based on that value.

Question 19

What is a relative cell reference?

Answer 19

When a formula is replicated (copied) down or across, the values will change to be relative to the cell it has been copied into

Question 20

What is an absolute cell reference?

Answer 20

When a formula is replicated (copied) down or across, any cell reference in the formula that has a $ in front of it will not change relative to the new cell, but will remain the same.

Question 21

What is a macro?

Answer 21

A small program written to carry out a repetitive task

Question 22

What types of chart are available in a spreadsheet?

Answer 22

Bar/column chart
Pie chart

Question 23

What is data modelling?

Answer 23

A model that is controlled by a set of rules defined by formulas
Allows ‘what if?’ questions to be answered