SITEMAP ABOUT
MiC Quality

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
Online Course Instructor
Glen Netherwood
MiC Quality
Online Learning
:: Home :: FREE TRIAL :: CURRENT STUDENTS LOGIN
:: Exercises Syllabus    PreviousNext


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.


 
Copyright 1998-2014 MiC Quality Legal Notices and Privacy Policy