1 / 8

Microsoft Excel

Microsoft Excel. Spreadsheet: An applications program, used in financial forecasting, that can quickly handle calculations and perform evaluations. Rows & Columns.

ycarter
Download Presentation

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. Microsoft Excel Spreadsheet: An applications program, used in financial forecasting, that can quickly handle calculations and perform evaluations.

  2. Rows & Columns Column: The vertical divisions of a spreadsheet that intersect the horizontal divisions (rows) to form cells in which data can be entered. Columns are labeled alphabetically (A,B,C,...AB,AC,AD...). Row: The horizontal divisions of a spreadsheet that intersect the vertical divisions (columns) to form cells in which data can be entered. Rows are labeled numerically (1,2,3,4,...).

  3. Cells • Cell: This is the basic unit of the spreadsheet. It is the intersection of a row and a column on a spreadsheet in which data can be entered. Cells are designated by their column letter and row number B2 is correct but 2B is incorrect. You may use either lower or upper case letters when referencing a column.

  4. Active Cell/Selected Cell • Active Cell or Selected Cell • The cell which has the dark border around it is the active cell. This is the cell that can be acted upon and indicates where the insertion point is located. You can select a new active cell by using the keyboard's arrow keys or clicking on a new cell with the mouse. You can also use keys like [PageDown] and [PageUp] and [Home] to change the active cell location.

  5. Values, Labels, Formulas Value: One type of data that can be entered into a spreadsheet cell. It consists of numbers that can be added, subtracted, etc. Label: A type of data that can be entered into a spreadsheet cell. It consists of words that usually label a column or row of numbers. Formula: A type of information that can be entered into a spreadsheet cell. It is a mathematical equation consisting of numbers, other cell designators, and symbols for mathematical operations.

  6. Formulas ENTERING FORMULAS • Although the numbers are small and we could easily do the calculations in our head, another spreadsheet might have 500 numbers to add. A formula can be a combination of values (numbers or cell references) and math operators into an algebraic expression. Math operators include the following symbols: • + for addition • - for subtraction • * for multiplication • / for division • % for percentage • ^ for exponentiation • In addition you can use parentheses and decimal points, where needed. • Excel requires that EVERY formula begin with an equal sign (=). If you just type without this symbol, Excel treats the entry as text.

  7. Workbook Workbook This is Excel's name for a file. The workbook can have multiple sheets with different information on each sheet. This permits you to keep related data in one file rather than break it up into several different files.

  8. Quick Questions/Answers • Where is the word Bread? • Where is the price of milk? • What column holds the prices? • Where is the formula of this spreadsheet? • What is the formula?

More Related