 FREE COURSE Excel Primer PROCESS IMPROVEMENT AND SIX SIGMA
 ONLINE COURSES FREE TRIAL SIX SIGMA FAQ BROCHURES LICENSES ENROLL
 FREE TRIAL
 :: Online Courses :: Free Trial >> Statistics Module >> Excel Primer :: Six Sigma :: FAQ :: Brochures :: Licenses :: Discounts
 Welcome to MiC Quality MiC Quality Online Learning
 :: Home :: FREE TRIAL :: CURRENT STUDENTS LOGIN
:: Exercises   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. Functions  Circular References