FREE COURSE Excel Primer
Have a go at these exercises:
Set up a spreadsheet to calculate the area of a rectangle from its length and width
Set up a spreadsheet to calculate the weight of a drum of liquid from its Diameter (D), Height (H) and Specific Density (S).
The formula for the weight is:
The Excel function for the value of π is:
=PI()
Compare the cost per kilogram of two types of cheese. Calculate the cost of 5 kilograms of the cheapest cheese using the Excel 'MIN' function.
You can shortcut to the Excel help index by pressing key 'F1'. You can then look up the 'MIN' function in the index.
Modify the previous question to give the name of the cheapest type of cheese using an 'IF' statement.
You can look up how to use the 'IF' function in the Excel index.
