Term 1 Spreadsheets Flashcards
What is a spreadsheet used for?
To store information
What is the name for a unit of data (box) in a spreadsheet?
A cell
What is the name for a vertical collection of cells in a spreadsheet?
A column
What is the name for a horizontal collection of cells in a spreadsheet?
A row
What does the operator + mean in a spreadsheet formula?
Add the two operands (values) together
Which operator is used in a spreadsheet formula to show division?
/
Which operator is used in a spreadsheet formula to show multiplication?
*
Which operator is used in a spreadsheet formula to show subtraction
-
In a spreadsheet which function allows you to find the largest value in a range of cells?
=max( ) where the range of cells goes in the brackets e.g. =max(A1:A12)
In a spreadsheet which function allows you to find the smallest value in a range of cells?
=min( ) where the range of cells goes in the brackets e.g. =min(A1:A12)
In a spreadsheet which function allows you to find the average of a set of values in a range of cells?
= average( ) where the range of cells goes in the brackets e.g. =average(A1:A12)
What type of chart is shown as a circle split into multiple sections (like slices of a pizza)?
A pie chart
What type of chart is shown as vertical columns?
A bar chart
What does the VLOOKUP( ) function allow you to do?
select specific data from a large table of data
What does the COUNTIF( ) function allow you to do?
count the number of cells that contain certain data
What does the COUNT( ) function allow you to do?
count the number of cells that contain any data (not just those with specific data)
How would you use the COUNT( ) function to count how many cells in rows A to E and in column 3 contain data?
=count(A3:E3)
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?
=countif(A3:E3, “X”)
In the formula ‘ = VLOOKUP(A3, D2:G10, 2) what does each value in the brackets mean?
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
