New Perspectives on Microsoft Excel 2010
Tutorial Project: 3 Working with Formulas and Functions
Tutorial Project
How are sales going?
Files Needed: lasala.xlsx
Eva Lorraine is looking at the monthly costs for the chain of LaSala restaurants that she manages. She has created an initial spreadsheet in Excel but is unsure as to how to create formulas. She has done most of the formatting work on the spreadsheet but needs your help in figuring out the numbers.
Calculating the Costs
1) Open up the lasala.xlsx file.
2) Complete the following tasks:
a. Change the formatting of cells C5:L11 to currency. Make sure that two decimal places are showing
b. Change the formatting of cells C15:C18 to currency. Make sure that two decimal places are showing.
3) Use the SUM Function to create a formula that calculates the total for January through June’s costs for Chicago.
4) Copy this formula to the cells for the other restaurant locations in the Totals column.
5) Find the correct function to use in order to create a formula that calculates the average for January through June’s costs for Chicago.
6) Copy this formula to the cells for the other restaurant locations in the Average column.
7) Find the correct function to use in order to create a formula that calculates the minimum amount listed for January through June’s costs for Chicago.
8) Copy this formula to the cells for the other restaurant locations in the Minimum column.
9) Find the correct function to use in order to create a formula that calculates the maximum amount listed for January through June’s costs for Chicago.
10) Copy this formula to the cells for the other restaurant locations in the Maximum column.
11) In cells C15:C18, calculate and create formulas to appropriately derive to the requested totals.
12) Save your file.
When complete, submit the results to your instructor.