116940 Use a Graphical User Interface (GUI)-based spreadsheet application to solve a given problem

---

---

1. Viewing the spreadsheet (Zoom)

How:

• Excel: Go to the bottom right corner > Use the Zoom slider.

• Google Sheets: Click View > Zoom > Choose a percentage.

Why: To make the spreadsheet easier to read or fit more data on screen.

---

❄️ 2. Freeze Panes (Row & Column)

How:

• Excel: Go to View > Freeze Panes:

  • Freeze Top Row

  • Freeze First Column

  • Or choose a specific cell and select Freeze Panes

• Google Sheets: View > Freeze > Up to row/column

Why: Keeps headers or labels visible while scrolling.

---

3. Change the Default File Location (Excel only)

How:

• File > Options > Save

• Change the Default local file location.

Why: To save files in a specific folder automatically.

---

4. Add a User Name to the File (Excel)

How:

• File > Options > General > User Name

• This name is used for comments and document properties.

Why: Helps track who edited the file.

---

5. Work with Multiple Worksheets

 Explain the purpose:

• Organize data (e.g., monthly budgets on different sheets)

• Separate tasks or categories (e.g., Sales, Expenses, Reports)

➕ Create/Add New Worksheet:

• Excel: Click the "+" tab at the bottom.

• Google Sheets: Click the "+" at the bottom left.

Rename Worksheet:

• Double-click the sheet tab name and type the new name.

❌ Delete Worksheet:

• Right-click the sheet tab > Delete

---

6. Cells are Manipulated

Move/Copy:

• Move: Select cell/range > Drag it with your mouse.

• Copy: Ctrl + C > Go to new location > Ctrl + V.

Entire Column/Row:

• Click the column letter or row number to select.

• Right-click > Move or Copy.

---

7. Apply Formulae to Worksheets

• Start with =

Example:

• Addition: =A1 + B1

• Subtraction: =A1 - B1

• Multiplication: =A1 * B1

• Division: =A1 / B1

• Percentage: =A1 * 10% or =A1 * 0.10

---

❌ 8. Enter Incorrect Formula & Fix It

Example:

• Enter =A1 + B (missing cell reference) → Excel shows #NAME?

• Fix it to =A1 + B1

---

9. Apply Absolute Cell Reference

Use $ sign:

• =$A$1 (absolute) vs A1 (relative)

• Keeps reference fixed when copying formulas.

---

10. Change Data in a Spreadsheet

• Click the cell > Type new data > Press Enter

---

➕ 11. Apply Simple Built-in Functions

Sum a Range:

• =SUM(A1:A5)

Round:

• =ROUND(A1, 2) (round to 2 decimals)

---

12. Statistical Functions

• Average: =AVERAGE(A1:A5)

• Count numbers: =COUNT(A1:A5)

• Maximum: =MAX(A1:A5)

• Minimum: =MIN(A1:A5)

---

13. Formatting a Spreadsheet

Create a Template:

• Format your spreadsheet > Save as Template.

  • Excel: File > Save As > Save as type: Excel Template (.xltx)

Use Format Painter:

• Select formatted cell > Click Format Painter > Apply to another cell.

✨ Use Special Effects (Word Art):

• Excel: Insert > WordArt

• Google Sheets: Use Drawing tool to add Word Art.

↔️ Center Text Across Cell Range:

• Select range > Home > Merge & Center

↕️ Change Orientation of Text:

• Select cell > Format > Text Rotation

Apply/Remove Border:

• Select cells > Home > Borders tool > Choose border type or No Border

Apply/Remove Fill (Shading):

• Select cells > Home > Fill Color > Choose color or No Fill

---

Click to Go Back