Practical - 69 :- Creating Simple Spreadsheet for An Apllication - Formatting Cells, Using Formula In Cells

1. The Setup (Data Entry)

Open your spreadsheet software and enter the following raw data starting at cell A3. Do not worry about the "Total" column yet; we will calculate that later.

Item	Quantity	Unit Price	Total
Laptop	5	800
Graphing Calculator	15	110
Textbooks	30	65
Lab Coats	20	25
Notebooks	50	5

---

2. Formatting the Worksheet

A professional sheet should be readable. Follow these steps:

• Main Title: Click and drag to select cells A1 to D1. Click Merge & Center and type "SCIENCE DEPARTMENT INVENTORY 2026". Increase the font size to 14pt and make it Bold.

• Headers: Select cells A3 to D3. Apply a Fill Color (e.g., Dark Blue) and change the Font Color to White.

• Currency: Select the range C4:D9. Right-click and choose Format Cells > Currency. This adds the $ symbol and two decimal places automatically.

• Borders: Highlight the entire table (A1:D9) and select All Borders from the font toolbar.

---

3. Using Formulas

Now, we make the spreadsheet "smart" by automating the math.

• Multiplication: In cell D4, type the formula: =B4*C4. Press Enter.

• The Fill Handle: Click on cell D4. Notice the small green/blue square in the bottom right corner. Click and drag that square down to D8 to copy the formula for all items.

• The Grand Total: In cell D9, we want the sum of everything. Type: =SUM(D4:D8).

• Tax Calculation (Optional/Advanced): In cell D10, calculate a 10% tax on the grand total by typing: =D9*0.10.

---

4. Simple Data Visualization

Data is often easier to understand as a picture.

1. Highlight the Items in column A (A4:A8).

2. Hold the Ctrl key (or Cmd on Mac) and highlight the Totals in column D (D4:D8).

3. Go to the Insert tab and select Chart (or Recommended Charts).

4. Choose a Clustered Column Chart.

5. Click the chart title and rename it to "Inventory Cost Distribution."

---

Summary Checklist for Students

• [ ] Is the main title Merged and Centered?

• [ ] Do the prices have a Currency ($) format?

• [ ] Did you use =SUM() for the final total instead of adding manually?

• [ ] Does the chart clearly show which item is the most expensive?