1 / 22

THE MICROSOFT EXCEL

THE MICROSOFT EXCEL. Prepared by: Cecilia B. Cajandab (MSIT). The Microsoft Excel Screen.

colin-schwartz
Download Presentation

THE MICROSOFT EXCEL

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. THE MICROSOFT EXCEL Prepared by: Cecilia B. Cajandab (MSIT)

  2. The Microsoft Excel Screen Microsoft Excel – is a spreadsheet program designed to create, organize, and analyzed data. It is very powerful tool for day to day business activities such as preparing a simple invoice, making an office form or managing a complex accounting ledger. • OPENING MICROSOFT EXCEL XP • Click Start • Restore • Point/Click Programs. • Click Microsoft Excel.

  3. PARTS OF THE MICROSOFT EXCEL WINDOW

  4. WORKBOOK – the file in which you work and store your data. It contains one or more worksheets. WORKSHEET CELLS - the intersections of rows and columns. They are referenced individually by their cell names or cell addresses. • Entering data • To enter data in Microsoft Excel simply type the data in the active cell. Be sure to position first the active cell in the cell address desired.

  5. Edit cell contents You will notice that as you type the word it is also displayed on the Formula Bar. You can also click at the formula bar then make the necessary changes using the delete key or backspace to delete the data. To enter your changes, press ENTER. To cancel your changes, press ESC. • CLEARING CELLS • Right-click the cell you want to clear then click Clear Contents. or • Click the cell you want to clear. • Press the Delete key on your keyboard. • CLEARING CONTENTS, FORMATS, OR COMMENTS • Click the cell you want to clear the contents. • Click Edit on the menu bar, point to Clear then click either All, Format, Comments or Contents. • If you click a cell and then press DELETE or BACKSPACE Excel removes the cell contents but does not remove any comments or cell formats. • If you clear a cell, Excel removes the contents, formats, comments, or all three from a cell. The value of a cleared cell is 0 (zero), and a formula that refers to that cell will receive a value of 0.

  6. DELETING CELLS In Excel, deleting cells was different from clearing cells. When you delete a cell, it is like cutting the cell, so the neighboring cells can either shift up, or shift left. When you clear a cell, only it’s contents is erased. • To delete a cell, Right-click the cell then click Delete. • Choose from the options you want then click OK. • DELETING ROWS OR COLUMNS • Select the Row or Column Headings you want to delete. • Click Edit on the menu bar then, click Delete. Or • 1. Right-click the row or column then click Delete. • UNDO COMMAND • If you made a mistake you can undo your mistake by clicking the UNDO button. To undo several actions at once, click the arrow next to Undo then select from the list. If you change your mind click REDO. • REPEAT THE LAST ACTION • To repeat the last action click Edit on the menu bar then, Click repeat.

  7. INSERTING BLANK CELLS • Select a range of existing cells where you want to insert the new blank cells. The insert dialog box will appear. • Click Insert from the menu bar then click Cells. • Click any of the available options you want. • Click OK. Or • Right-click the selected cell then click Insert. • INSERTING A ROW • Right-click the selected row then click Insert. • INSERTING MULTIPLE ROWS • Select rows immediately below where you want the new rows to appear. Select the same number of rows as you want to insert. • Click Insert in the menu bar then click Rows. • INSERTING A COLUMN • Right-click the selected column then click Insert. • INSERTING MULTIPLE COLUMNS • Select the columns immediately at the right or the column where you want the new column to be inserted. Select the same number of column as you want to insert. • Click Insert on the menu bar then click Columns.

  8. Using Formulas • A formula is an equation that performs operations on worksheet data. It can perform mathematical operations, such as addition, subtraction, multiplication, and division. Formulas can refer to other cells on the same worksheet, cells on other sheets in the same workbook, or cells on sheets in other workbooks. • A formula in Excel always begins with an equal sign (=). The equal sign tells Excel that the succeeding characters constitute a formula. Following the equal sign are the elements to be calculated (the operands), which are separated by calculation operators. Excel calculates the formula from left to right, according to a specific order for each operator in the formula. You can change the order of operations by using parenthesis.

  9. Precedence of Operators How does Excel evaluate a formula? • ORDER OF EVALUATION • EXPONENTIATION • MULTIPLICATION AND DIVISION • ADDITION AND SUBTRACTION • If a formula contains both a multiplication and division operator, Excel evaluates the operators from left to right. • With the above order of evaluation the mathematical equation below will result to 4. = 28 – 3 * 8 Excel multiplies 3 by 8 then the result is subtracted from 28. To change the order of evaluation use a parenthesis as shown below. = (28 – 3) * 8 The result will be 200.

  10. ENTERING A FORMULA • Click the cell you want a formula to be entered. • Type = (equal sign) • Enter (type) a Formula. • Press Enter on your keyboard. • EDITING A FORMULA • To edit the formula simply press F2, and do the necessary changes you want.

More Related