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
:: Using Ranges Syllabus    PreviousNext


A rectangular group of cells is called a Range. A Range must be rectangular, you can't have odd shapes; the smallest possible range is just one cell.

A ‘Range’ is defined by the top left and bottom right corner cells:


Notice the way the function is used to 'SUM' the range and the method of addressing the range:

‘C3:D7’.

 

Load the spreadsheet and write a formula to find the minimum value in the range

 
Copyright 1998-2014 MiC Quality Legal Notices and Privacy Policy