Spreadsheet and Cell
ACTIVITY: INSERTING FUNCTIONS
You are thinking of starting a small express oil change service center. Before you begin, you need to evaluate what you think your monthly expenses will be.
a. Enter the data shown on the figure above on a blank workbook, then save it as EX M3-Express Oil Change Expenses.
b. Create a formula in cell C4 that calculates the annual rent.
c. Copy the formula in cell C4 to the range C5:C10.
d. Move the label in cell A15 to cell A14.
e. Create formulas in cells B11 and C11 that total the monthly and annual expenses.
f. Create a formula in cell C13 that calculates annual sales.
g. Create a formula in cell B14 that determines whether you will make a profit or loss, then copy the formula into cell C14.
h. Copy the labels in cells B3:C3 to cells E3:F3.
i. Type Projected Increase in cell G1, then type .2 in cell H2.
j. Create a formula in cell E4 that calculates an increase in the monthly rent by 15%..
k. Create a formula in cell F4 that calculates the increased annual rent expense based on the calculation in cell E4.
l. Copy the formulas in cells E4:F4 into cells E5:F10 to calculate the remaining monthly and annual expenses.
m. Use a function cell E11 that calculates the total monthly expenses, then copy that formula to cell F11.
n. Copy the contents of cells B13:C13 into cells E13:F13.
o. Create formulas in cells E14 and F14 that calculate profit/loss based on the projected increase in monthly and annual expenses.
p. Change the projected increase to .20, then compare your work to the sample workbook shown above.
q. Enter your name in a cell in the worksheet.
r. Make your workbook presentable by applying text color, cell shadings, borders, etc.
s. Save your work, preview the worksheet in Backstage view, submit your work to your instructor as directed, close the workbook, and exit Excel.
You are thinking of starting a small express oil change service center. Before you begin, you need to evaluate what you think your monthly expenses will be.
a. Enter the data shown on the figure above on a blank workbook, then save it as EX M3-Express Oil Change Expenses.
b. Create a formula in cell C4 that calculates the annual rent.
c. Copy the formula in cell C4 to the range C5:C10.
d. Move the label in cell A15 to cell A14.
e. Create formulas in cells B11 and C11 that total the monthly and annual expenses.
f. Create a formula in cell C13 that calculates annual sales.
g. Create a formula in cell B14 that determines whether you will make a profit or loss, then copy the formula into cell C14.
h. Copy the labels in cells B3:C3 to cells E3:F3.
i. Type Projected Increase in cell G1, then type .2 in cell H2.
j. Create a formula in cell E4 that calculates an increase in the monthly rent by 15%..
k. Create a formula in cell F4 that calculates the increased annual rent expense based on the calculation in cell E4.
l. Copy the formulas in cells E4:F4 into cells E5:F10 to calculate the remaining monthly and annual expenses.
m. Use a function cell E11 that calculates the total monthly expenses, then copy that formula to cell F11.
n. Copy the contents of cells B13:C13 into cells E13:F13.
o. Create formulas in cells E14 and F14 that calculate profit/loss based on the projected increase in monthly and annual expenses.
p. Change the projected increase to .20, then compare your work to the sample workbook shown above.
q. Enter your name in a cell in the worksheet.
r. Make your workbook presentable by applying text color, cell shadings, borders, etc.
s. Save your work, preview the worksheet in Backstage view, submit your work to your instructor as directed, close the workbook, and exit Excel.