Term 1 Spreadsheets

Question 1

What is a spreadsheet used for?

Answer 1

To store information

Question 2

What is the name for a unit of data (box) in a spreadsheet?

Answer 2

A cell

Question 3

What is the name for a vertical collection of cells in a spreadsheet?

Answer 3

A column

Question 4

What is the name for a horizontal collection of cells in a spreadsheet?

Answer 4

A row

Question 5

What does the operator + mean in a spreadsheet formula?

Answer 5

Add the two operands (values) together

Question 6

Which operator is used in a spreadsheet formula to show division?

Answer 6

/

Question 7

Which operator is used in a spreadsheet formula to show multiplication?

Answer 7

*

Question 8

Which operator is used in a spreadsheet formula to show subtraction

Answer 8

-

Question 9

In a spreadsheet which function allows you to find the largest value in a range of cells?

Answer 9

=max( ) where the range of cells goes in the brackets e.g. =max(A1:A12)

Question 10

In a spreadsheet which function allows you to find the smallest value in a range of cells?

Answer 10

=min( ) where the range of cells goes in the brackets e.g. =min(A1:A12)

Question 11

In a spreadsheet which function allows you to find the average of a set of values in a range of cells?

Answer 11

= average( ) where the range of cells goes in the brackets e.g. =average(A1:A12)

Question 12

What type of chart is shown as a circle split into multiple sections (like slices of a pizza)?

Answer 12

A pie chart

Question 13

What type of chart is shown as vertical columns?

Answer 13

A bar chart

Question 14

What does the VLOOKUP( ) function allow you to do?

Answer 14

select specific data from a large table of data

Question 15

What does the COUNTIF( ) function allow you to do?

Answer 15

count the number of cells that contain certain data

Question 16

What does the COUNT( ) function allow you to do?

Answer 16

count the number of cells that contain any data (not just those with specific data)

Question 17

How would you use the COUNT( ) function to count how many cells in rows A to E and in column 3 contain data?

Answer 17

=count(A3:E3)

Question 18

How would you use the COUNTIF( ) function to count how many cells in rows A to E and in column 3 which contain an X?

Answer 18

=countif(A3:E3, “X”)

Question 19

In the formula ‘ = VLOOKUP(A3, D2:G10, 2) what does each value in the brackets mean?

Answer 19

A3 is the cell containing the data to be found
D2:G10 is the range of cells to be searched for the value in A3
2 shows that the second column of data will be returned when a values is found