Computer Science Fair Project Ideas

Topics: Spreadsheet, Mathematics, Calculation Pages: 3 (516 words) Published: May 23, 2013


Illustrated Excel 2010
Unit B: independent Challenge 1
Express Oil Change
Save a workbook with a new name
Enter numbers in cells
Enter formulas
Fill adjacent cells with formulas
Copy cell contents
Move cell contents
Create formulas using the SUM function
Enter text in cells
Use absolute cell references
Project overview
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. You’ve started a workbook, but need to complete the entries and add formulas. STUDENT start FILE

IL_Excel2010_UB_IC1a_FirstLastName_1.xlsx (Note: Download your personalized start file from Instructions
Open the file IL_Excel2010_UB_IC1a_FirstLastName_1.xlsx and save the file as IL_Excel2010_UB_IC1a_FirstLastName_2.xlsx before you move to the next step. Verify that your name appears in cell B4 of the Documentation sheet. (Note: Do not edit the Documentation sheet. If your name does not appear in cell B4, please download a new copy of the start file from the SAM Web site.) Switch to the Sheet1 worksheet. In the range B4:B10, enter the data shown in column 2 of Table 1.


| Monthly |
Rent| 2000|
Supplies| 1500|
Oil| 3500|
Fan Belts| 1200|
Oil Filters| 800|
Coffee| 500|
Utilities| 650|

Create a formula in cell C4 that calculates the annual rent. Copy the formula in cell C4 to the range C5:C10 to calculate annual amounts for the remaining categories. Move the label in cell A15 to cell A14.

Create formulas in cells B11 and C11 that total the monthly and annual expenses. Create a formula in cell C13 that calculates annual sales.
Create a...
Continue Reading

Please join StudyMode to read the full document

You May Also Find These Documents Helpful

  • SIWES Project in Computer Science Essay
  • Science Fair Project Idea Essay
  • Science Fair Project Example Essay
  • Science Fair Project Essay
  • Science Investigatory Project Essay
  • Science Fair Essay
  • Science Fair Essay

Become a StudyMode Member

Sign Up - It's Free