
Yr10 Spreadsheets post-topic quiz
Quiz by Mr Graham
Tag the questions with any skills you have. Your dashboard will track each student's mastery of each skill.
What symbol do formulae have to begin with
D4 contains the price of an item: £2.30 and cell D5 contains how many have been sold: 7. What should the cell displaying the revenue contain?
Why should formulae contain cell references instead of values e.g. =B2-B3 instead of =£40.00-£3.95
To add up several cells which function should we use?
Cell B10 contains the value '7%' and cell B11 contains the value £5.00. We want to find what 7% of £5.00 is. Which formula should we use?
Copying from one cell to another is very useful and there is a feature in Excel to make this easily done with the mouse. It involves clicking on a small square in the bottom right corner of the cell you wish to copy from. What is the name of this feature?
Which of the following is true about absolute cell references?
Which of the following is true about profit