NEW
Font size
WorksheetsSpreadsheets
Total questions: 68
Worksheet time: 34mins
Horizontal and vertical lines in a spreadsheet are called _____.
Rows
Labels
Graphs
Gridlines
The cell that is currently selected is called _______
Cell reference
Label
Cell range
Active Cell
A group of cells in a spreadsheet are called ______
Cell Reference
Cell Range
Active Cells
Formulas
A single page in Excel is called a ______
Worksheet
Workbook
Spreadsheet
Multiple pages in Excel are called ______
Worksheet
Workbook
Spreadsheet
Which of the following is a FORMULA that will add cells C9 and C10?
=C9+C10
C9+C10
sum(C9:C10)
=sum(C9:C10)
Which is an example of a cell reference in a spreadsheet?
6C
B9
45
fall
Format cell as _________ when working with amounts of money
Currency
Number
Percent
Scientific
Double-clicking between two columns will _______ the column
delete
resize
copy
fill
A file which contains one or more spreadsheets is called a ______
Workbook
Cells
Spreadsheet
Entry
_________ is an arrangement of cells in columns and rows used to organize, analyze, calculate and report information
Workbook
Cell
Spreadsheet
Entry
______ are individual locations on a spreadsheet
Workbook
Spreadsheet
Cell
Entry
______ are individual pieces of information typed into the spreadsheet.
Workbook
Cell
Spreadsheet
Entry
A4 in an example of ______
Cell reference
Formula
Cell Range
Function
A1:A10 is an example of ________
Cell Reference
Cell Range
Formula
Function
Cells that contain text are a called ______
Label
Formula
Value
Function
Cells that contains data to be used in calculations are called _______
Label
Value
Formula
Function
A _______ instructs the software to perform a calculation
Label
Formula
Value
Function
All formula and functions start with a ________
=
SUM
Labels
Text
The function that adds the range of cells is called a _________
=sum()
=max()
=average()
=min()
The function that determines the average of the range of cells is called _______
=sum()
=average()
=min()
=max()
The functions that finds the highest number in the range of cells is called a __________
=sum()
=average()
=max()
=min()
The functions that finds the lowest number in a range of cells is called a _________
=sum()
=average()
=min()
=max()
What are the individual rectangles on a worksheet called?
Rows
Cells
Columns
Formulae
A vertical line of cells in a spreadsheet is a ________
Row
Column
A horizontal line of cells in a spreadsheet is called a ________
Row
Column
How are columns labelled on a worksheet?
Letters
Numbers
How are rows labelled on a worksheet?
Letters
Numbers
If you wanted to change the colour of the text inside a cell, which tool would you use?
Text Colour
Fill Colour
Borders
Bold
If you wanted one cell or a number of cells to stand out from the rest, which tool would you use?
Bold
Fill Colour
Currency
Borders
If you wanted to change the size of the text inside a cell, which tool would you use?
Cell Width
Text Colour
Cell Height
Font Size
Something that automatically calculates something for you using the data in cells is a _______
Formula
Formatting
Which mathematical operator (symbol) would you use if you are adding the values in cells together?
/
-
+
=
Which mathematical operator (symbol) would you use to divide the value of two cells?
/
-
*
=
Which mathematical operator (Symbol) would you use to subtract a value in a cell from a value in another cell?
/
*
-
=
Which mathematical operator (symbol) would you use to multiply the values in two cells together?
/
-
*
=
Which of the following tells a spreadsheet to subtract the value in cell A4 from the value in cell A3?
A4-A3=
=A4-A3
A3-A4=
=A3-A4
Which of the following tells a spreadsheet to divide the value in cell A3 by 27?
=27/A3
=27^A3
=A3/27
=A3*27
Which of the following formulas will add cells A1 thru A5?
=sum(A2+A5)
=A1:A5
=A1+A2+A3+A4+A5
=A1-A2-A3-A4-A5
Which of the following is a formula that will add cells C9 and C10?
=C9+C10
=C9:C10
C9+C10
=C9*C10
Which of the following is a formula that will multiply cells A1 and A2?
A1*A2
=A1*A2
=A1:A2
=Multiply(A1:A2)
Which of the following is a formula that will divide cell D10 by 2?
=D10/A2
=D10*2
10/2
=D10/2
Which of the following is a formula that will subtract cell B4 from cell B3?
=3-4
=B3*B4
=B3-B4
B3-B4
Which of the following is a formula that will divide cell A10 by cell A1?
=A10/A1
=A10*A1
=A1/A10
=Divide(A10:A1)
Which of the following is a correct example using the AUTOSUM function?
sum(D14:D19)
=sum(D14:D19)
=D14:D19
=D14+D15+D16+D17+D18+D19
Which of the following is a correct example of the AUTOSUM function?
=sum(A1-A10)
=A1+A2+A3+...+A10
=sum(A1:A10)
=sum(A1+A2+A3+...+A10)
Click and drag the _______ tool to apply the same formula to neighbouring cells.
auto-fill
alignment
fill
functions
SUM, AVERAGE, MAX and MIN are preset formulas on the _____ menu.
Filter
Functions
Border
Fill Colour
Your best friend on the computer when you make a mistake is.....
Mr Baines
redo
delete
undo
Which type of chart is best used to represent trend over time?
bar
line
combination
pie
A user wants to show the relationship between the mode of transportation and the percentage of user. Which type of chart will best represent the data?
bar
line
combination
pie
A combination chart is made up of what types of charts?
Line Chart
Bar Chart
Both line and bar chart
Both line and pie chart
Which function will result in the total number of entries in the cell range B5 to B14?
count
max
min
sum
Which chart type will best represent the percentage of examples for office supplies, salaries, and travel for a company's budget?
column
line
pie
scatter
Amanda has created multiple charts for each product sold. How will her manager know the name of each chart?
X-Axis
Y-Axis
Legend
Chart Title
Hal has used four different colours to show the different products that his company sells. What will Hal use to explain the different product colours?
X-Axis
Y-Axis
Legend
Chart Title
Cells that run horizontally on a spreadsheet are called a _____
row
column
range
workbook
Cells that run vertically on a spreadsheet are called a ______
row
workbook
worksheet
column
The location of a cell on a spreadsheet, which is clicked in is called a _____
cell range
cell reference
active cell
row
The letter at the top of the column is called a ______
cell reference
column header
row header
range
The number to the left of the row is called a _______
cell reference
column header
row header
range
All functions and formulas begin with a ________
#
:
/
=
Which one is the title of the chart?
A
B
C
Which one is the axis of the chart
A
B
C
Using the correct symbols and cell references, write out the formula to calculate Costs sales for the Bananas
£0.50 times 4
C5*D5
=C5*D5
=C5*4
Using the correct symbols and cell references write out the formula to calculate the Total
=sum(E3:E8)
=E3+E4+E5+E6+E7+E8
=£0.90+£0.50+£2.00+£0.36+£0.30+£1.50
What is the cell reference of the cell with value WAND inside?
B5
C6
D9
A8
To calculate costs, what would you need to multiple the price by?
Item
Number Sold
Price
Total
