spreadsheets

Question 1

A spreadsheet consists of a…

Answer 1

grid of cells.

Question 2

what is a cell

Answer 2

a box on the spreadsheet into which you can place numbers, text or calculations.

Question 3

what are spreadsheets often used for?

Answer 3

used to perform calculations

Question 4

Formulae must always start with..

Answer 4

an equals sign

Question 5

what sign is used for multiplication?

Answer 5

*

Question 6

what sign is used for division?

Answer 6

/

Question 7

what is replication

Answer 7

where you copy information from one cell to another using the fill handle.

Question 8

what does the fill handle do?

Answer 8

to extend and complete a series of numbers, dates or formulae.

Question 9

how is an absolute cell reference created by?

Answer 9

adding a dollar sign ($) in front of the column reference, the row reference, or both.

Question 10

what are functions?

Answer 10

pre-programmed into spreadsheets, that allow us to perform longer or more complex calculations easily

Question 11

examples of functions

Answer 11

SUM, AVERAGE, MAX, and MIN.

Question 12

all functions start with…

Answer 12

an equals sign

Question 13

what is the IF function used for?

Answer 13

to make choices

Question 14

what does the COUNTIF function do

Answer 14

counts the number of cells in a selected range that meet a specific criterion.

Question 15

what is the structure for the IF function

Answer 15

=IF( Question, Do this if True, Do this if False ).

Question 16

what is the structure for the COUNTIF function

Answer 16

=COUNTIF( Range, Criterion ).

Question 17

what does the COUNT function do?

Answer 17

counts the number of cells in a selected range that contain a number.

Question 18

what does the COUNTA function do?

Answer 18

counts the number of cells in a selected range that contain a value (text or a number).

Question 19

what formatting can be used

Answer 19

-font, text size and text colour
-fill colour
-number format
-text alignment
-border.

Question 20

what does modelling let us do

Answer 20

to predict what is likely to happen when something changes, for example, working out how much profit will be made if prices change.

Question 21

what is a dropdown list?

Answer 21

a type of validation, it limits the values that can be entered into a cell.

Question 22

what does the VLOOKUP function do

Answer 22

takes the value in a cell, searches for it in a table of data elsewhere on the spreadsheet and returns the value in an adjacent cell.

Question 23

what is the structure for the VLOOKUP function

Answer 23

=VLOOKUP( lookup value, range, column number )