Font size
WorksheetsTest you knowledge in Excel
Total questions: 10
Worksheet time: 9mins
In an Excel spreadsheet. Looking at the Sum in the picture above.
What formula is used to add the two numbers togeather.
=SUM(4896+9075)
=ADD(E4:E5)
=SUM(E4+E5)
=ADD(4896+9075)
In an Excel spreadsheet. Looking at the Sum in the picture above.
What formula is used to take away the two numbers together.
=MINUS(76032:32098)
=SUM(C3-C4)
=SUM(76032:32098)
=MINUS(C3-C4)
In an Excel spreadsheet. Looking at the Sum in the picture above.
What formula is used to multiply the two numbers together.
(a)
In an Excel spreadsheet. Looking at the Sum in the picture above.
What formula is used to divide the two numbers together.
(a)
Looking at the spreadsheet above. How much is the profit for selling the movie "The Legend of Tarzan" using the profit per item and number of sold cells.
(a)
Looking at the spreadsheet above. What formula do you use to work out the Total Profit for the movie "BFG" that's been sold?
=SUM(7.01*5)
=MULTIPLY(E4:F4)
=SUM(E4*F4)
=MULTIPLY(7.01:5)
If I wanted my profit cell on my spreadsheet to stand out to me. Which formatting would I use ?
Tick all the relevant answers:
What formatting can we do to our spreadsheet to make it look better
Change font styles and size if needed
(f) Add some shading within heading cells
Add a border
Put key headings in bold
Highlight important data such as the Income and Total Income into a more stand out colour
looking at the spreadsheet above. What formula can I use to work out and display "profit" or "loss"
=IF(1622>1000,"profit","loss")
=IF(K3>J3,"profit","loss")
=loss(1622>1000,"profit","loss")
=profit(K3>J3,"profit","loss")
what Icon do we click on to format the "profit" into green and "loss" into red.
