1.
Entering and Editing Worksheet Data
Steps:
1. Open Excel:
o Launch Microsoft Excel. You'll be presented with a blank worksheet (or
workbook).
2. Entering Data:
o Select a cell (e.g., cell A1).
o Type the data you want to enter (e.g., text or numbers) and press Enter.
o Continue typing data into adjacent cells (e.g., A2, A3, etc.).
3. Editing Data:
o To edit a cell, click on the cell you want to edit.
o You can either start typing directly to overwrite the data or click inside the
formula bar (above the worksheet) to make changes.
o Press Enter to confirm the edit.
2. Performing Basic Worksheet Operations
Steps:
1. Insert/Delete Rows/Columns:
o To insert a row, right-click the row number on the left (e.g., row 2) and choose
Insert. This will insert a new row above it.
o To delete a row, right-click the row number and choose Delete.
o Similarly, right-click the column letter (e.g., B) to insert or delete columns.
2. Resize Rows and Columns:
o Hover your mouse between two column letters (e.g., between A and B) until it
changes to a double-headed arrow. Drag to resize.
o Similarly, you can resize rows by dragging the boundary between row
numbers.
3. Move Data:
o Select a cell or range of cells.
o Right-click and select Cut or use Ctrl + X.
o Click on the destination cell and right-click to choose Paste or use Ctrl + V.
3. Illustration of Autofill and Formatting Data in the Cells
Steps:
1. Autofill:
o Enter a value (e.g., 1) in a cell (e.g., A1).
o Hover over the bottom-right corner of the cell (a small square dot will appear,
called the fill handle).
o Click and drag this handle down or across the cells to automatically fill
consecutive values (e.g., 1, 2, 3,...).
You can also autofill a pattern like dates or text series.
2. Formatting Data:
o Change Font: Select a cell, go to the Home tab, and use the font options to
change the font type, size, or style (bold, italics, etc.).
o Cell Color: Select the cell or range, then click on the Fill Color button in the
Home tab to change the background color.
o Text Color: Select the cell, then use the Font Color option in the Home tab.
o Number Formatting: To format numbers, select the cells, and use options in
the Number section on the Home tab (e.g., currency, percentage, or date
format).
4. Use of Simple Arithmetic Operations
Steps:
1. Basic Arithmetic in Excel:
o Addition: In a cell, type =A1 + B1 to add the values in cells A1 and B1.
o Subtraction: Type =A1 - B1 to subtract the value in B1 from A1.
o Multiplication: Type =A1 * B1 to multiply the values in A1 and B1.
o Division: Type =A1 / B1 to divide the value in A1 by B1.
2. Using Functions:
o SUM: To sum a range of cells (e.g., A1 to A5), use =SUM(A1:A5).
o AVERAGE: To calculate the average of a range, use =AVERAGE(A1:A5).
o MAX and MIN: To find the maximum or minimum value in a range, use
=MAX(A1:A5) or =MIN(A1:A5).
5. Working with Excel Ranges and Tables
Steps:
1. Selecting a Range:
o Click and drag to select a group of cells, or click the first cell and use Shift +
Arrow Keys to select multiple cells.
2. Creating a Table:
o Select a range of data that includes headers.
o Go to the Insert tab and click Table. This will automatically detect the range
and header. Confirm that "My table has headers" is checked and click OK.
o Excel will now treat this range as a table with filters and sorting functionality.
3. Sorting Data:
o Click on a cell within the column you want to sort.
o Go to the Data tab and click either Sort A to Z (ascending) or Sort Z to A
(descending).
o If you want more advanced sorting, click Sort, and you can add multiple
levels of sorting based on different columns.
4. Applying Filters:
o When you create a table, filters are automatically added to each header.
o Click on the drop-down arrow in the column header to filter data by specific
criteria (e.g., filter out specific text, numbers, or dates).
Additional Notes:
Cell Reference: In formulas, you can use relative (e.g., A1), absolute (e.g., $A$1),
and mixed (e.g., $A1 or A$1) cell references.
Copying Data: Use Ctrl + C to copy selected data, and Ctrl + V to paste it
elsewhere.
Undo: Press Ctrl + Z to undo an action, and Ctrl + Y to redo.
