Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 62 - 2505_CoreGPT(Podar)_Flipbook_C6
P. 62

    The cell F3 will now display the total sum of all the values from January to April for the Pen Drive.
                      You can follow similar steps for other rows (e.g., Wired Mouse, Monitor, Keyboard) by replacing

                      the cell references accordingly.
                      Using a Keyboard to Enter a Formula

                      To enter a formula using a keyboard, follow these steps:
                      Step 1  Select cell F3 using the arrow keys.
                      Step 2  Type = in cell F3 to begin the formula.

                      Step 3  Use the left arrow key to move to cell B3 and type +.
                      Step 4  Use the left arrow key to move to cell C3 and type +.

                      Step 5  Use the right arrow key to move to cell D3 and type +.
                      Step 6  Use the right arrow key to move to cell E3 and type +.
                      Step 7  Press the Enter key.

                      The cell F3 will now display the total sum of all the values.

                            EDITING DATA

                      After creating a spreadsheet, the user may need to edit the contents or data of a cell or a range of
                      cells. Editing refers to making changes to the content of a cell by replacing, adding or deleting it.
                      To Edit the Cell Content

                      To edit the cell content, follow these steps:
                      Step 1  Double-click on the cell whose contents need to be modified.
                      Step 2  Place the cursor where you want to edit, type the new content and press the Enter key.

                      The new data is added to the old one.
                      To Replace the Cell Content

                      To replace the cell content, follow these steps:
                      Step 1  Select the cell whose contents need to be modified.

                      Step 2  Type the new content and press the Enter key.
                      The old data will be replaced with the new one.
                      To Delete the Cell Content

                      Select the cell or range of cells and press the Delete key.
                               Tech Funda

                             To open a selected cell in edit mode: F2

                             To enter data in multiple lines in a cell: Ctrl + Enter

                     60     Premium Edition-VI

| 57 58 59 60 61 62 63 64 65 66 67 |