WorksheetsExcel revision
Total questions: 20
Worksheet time: 11mins
What will clicking on the icon in the image do?
Make the text size bigger
Make the text colour red
Make the cell background colour red
Underline the text
What will clicking on the icon in the image do?
Make the text size bigger
Make the text colour red
Make the cell background colour red
Underline the text
What will clicking on the icon in the image do?
Make the text size bigger
Make the text colour red
Make the cell background colour red
Underline the text
What will clicking on the icon in the image do?
Make the text size bigger
Make the text colour red
Make the cell background colour red
Underline the text
Which format is best suited to display the price of an item?
Percentage
Number
General
Currency
Which format is best suited to display visually the mark you received on a test that is out of 100?
Percentage
Number
General
Currency
Which format is best suited to display a whole number including the thousands (comma) separator?
Percentage
Number
General
Currency
In Excel, the cell C3 contains the formula =A3/B3. If I copy this and paste it into the cell D5, what will the formula for cell D5 be?
=A3/B3
=C3
=A5/B5
=B5/C5
In Excel, the cell C3 contains the formula =$A3/$B3. If I copy this and paste it into the cell D5, what will the formula for cell D5 be?
=$A3/$B3
=$C3
=$A5/$B5
=$B5/$C5
In Excel, the cell C3 contains the formula =$A$3/$B$3. If I copy this and paste it into the cell D5, what will the formula for cell D5 be?
=$A$3/$B$3
=$C$3
=$A$5/$B$5
=$B$5/$C$5
Looking at the image, using a formula, what would the contents of E4 be?
(a)
Looking at the image, which formula would E6 have?
B6+C6+D6
=ADD(B6:D6)
=SUM(B6:D6)
=TOTAL(B6:D6)
Looking at the image, using a formula, how would you calculate the average of the cell range B5 to D5?
(a)
What will clicking on Filter do?
It will sort the data in alphabetical order
It will hide the rows that meet a certain criteria
It will find the first row that contains the data
It will only show the rows that meet a certain criteria
What will clicking on Sort A to Z do?
It will sort the data in alphabetical order
It will hide the rows that meet a certain criteria
It will find the first row that contains the data
It will only show the rows that meet a certain criteria
Looking at the image, what part is circled in red?
Chart
Chart Title
Data Labels
Legend
Looking at the image, what part is circled in red?
Chart
Chart Title
Data Labels
Legend
Looking at the image, what part is circled in red?
Chart
Chart Title
Data Labels
Legend
In the image, what type of chart is it?
(a)
What type of chart would be best suited to show the lowest and highest temperatures throughout the week on the same graph?
Pie
Line
Bar
Area
