AKUEB PRACTICALS MS Office

 

13.1.1   Prepare a spreadsheet by naming cells and sheets.

13.1.1   Use different options of paste special (value, format, formula).

13.1.1   Print a spreadsheet.

13.1.2   Apply cell formatting tools (number, alignment, font, border, fill).

13.1.3   Apply functions (sum, average, count, minimum, maximum).

13.1.4   Insert a pie chart and bar graph in the data sheet.

13.1.5   Apply filter and data validation on spreadsheet data.

13.1.5   Protect a worksheet.

13.1.5   Lock/unlock cells of spreadsheet.

___________________________________________________________________________________

You can include steps from here👇

1. Naming Cells and Sheets

• Rename Sheet: Double-click the tab at the bottom (e.g., "Sheet1") and type a new name, then press Enter.

• Name a Cell: Click a cell (e.g., A1). In the Name Box (top left, next to the formula bar), type a name like Total_Sales and press Enter.

2. Paste Special Options

Copy a cell (Ctrl+C), then right-click the destination cell:

• Values: Pastes only the result of a formula, not the formula itself.

• Formulas: Pastes the formula but keeps the destination formatting.

• Formats: Pastes only the styling (colors, borders) without the content.

3. Printing

• Go to File > Print (or Ctrl+P).

• Tip: Use "Set Print Area" under the Page Layout tab to print only a specific selection.

4. Cell Formatting

• Right-click a cell and select Format Cells to access:

  • Number: Set decimals or currency.

  • Alignment: Wrap text or merge cells.

  • Font/Border/Fill: Change text style, add grids, or background colors.

5. Basic Functions

Use these formulas in the formula bar:

• SUM: =SUM(A1:A10)

• AVERAGE: =AVERAGE(A1:A10)

• COUNT: =COUNT(A1:A10) (counts cells with numbers)

• MIN/MAX: =MIN(A1:A10) or =MAX(A1:A10)

6. Charts & Graphs

1. Highlight your data.

2. Go to the Insert tab.

3. Select Pie Chart for proportional data or Bar Graph for comparisons.

7. Filter and Data Validation

• Filter: Select headers > Data tab > Filter. Click the arrow on the header to sort or hide data.

• Data Validation: Data tab > Data Validation. Use this to restrict cell input (e.g., only allow whole numbers between 1 and 100).

8. Protect & Lock Cells

• Protect Worksheet: Go to Review > Protect Sheet. Set a password to prevent others from editing.

• Lock/Unlock: By default, all cells are locked when a sheet is protected. To unlock specific cells, right-click them > Format Cells > Protection > uncheck Locked before protecting the sheet.