MS Excel Creating Formulas PDF
Document Details
Uploaded by Deleted User
Tags
Summary
This document explains various aspects of using MS Excel, including its parts, functions, and formulas. It covers topics like the quick access toolbar, title bar, formula bar, worksheet, ribbon, vertical and horizontal scroll bars, zoom control, view shortcuts, sheet tabs, sheet tabs scrolling buttons, select all buttons, active cell, active cell box, formula bar, and the status bar.
Full Transcript
MS - EXCEL SPREADSH EET EMPOWERMENT TECHNOLOGIES A type of application program which manipulates numerical and string data in rows and SPREADSHEET USES: SCHOOL: Students Grades and Payroll SPORTS: Individual and Team Statistics PERSONAL: Checkbook a...
MS - EXCEL SPREADSH EET EMPOWERMENT TECHNOLOGIES A type of application program which manipulates numerical and string data in rows and SPREADSHEET USES: SCHOOL: Students Grades and Payroll SPORTS: Individual and Team Statistics PERSONAL: Checkbook and Household Expenses Payroll and BUSINESS: Investments MS – EXCEL PARTS AND FUNCTIONS QUICK ACCESS TOOLBAR TITLE BAR FILE TAB FORMULA BAR NAME BOX COLUMN HEADINGS SELECT ALL WORKSHEET RIBBON BUTTON VIRTICAL ACTIVE CELL SCROLL BAR ROW HEADINGS HORIZONTAL SCROLL BAR SHEET TABS ZOOM CONTROL VIEW SHEET TAB SHORTCUTS SCROLLING BUTTON STATUS BAR MICROSOFT EXCEL PARTS 8 4 5 18 14 12 11 15 17 1 13 9 2 3 16 7 6 10 MICROSOFT EXCEL PARTS MS – EXCEL PARTS AND FUNCTIONS A button that provides access to workbook – level features and program OFFICE BUTTON MS – EXCEL PARTS AND FUNCTIONS A collection of QUICK ACCESS buttons that TOOLBAR provide one – click access to commonly used commands, such as Save, MS – EXCEL PARTS AND FUNCTIONS A bar that TITLE BAR displays the name of the active workbook and the Excel MS – EXCEL PARTS AND FUNCTIONS The main set RIBBON of commands organized by task into tabs and MS – EXCEL PARTS AND FUNCTIONS The letters that appear along the top of the COLUMN worksheet HEADINGS MS – EXCEL PARTS AND FUNCTIONS The number that appears along the left of the worksheet ROW HEADINGS window. MS – EXCEL PARTS AND FUNCTIONS A window that displays an Excel WORK SHEET Workbook WINDOW MS – EXCEL PARTS AND FUNCTIONS A scroll bar used to scroll vertically through the workbook VERTICAL SCROLL BAR window. MS – EXCEL PARTS AND FUNCTIONS A scroll bar used to scroll horizontally through the workbook window. HORIZONTAL SCROLL BAR MS – EXCEL PARTS AND FUNCTIONS Controls for magnifying and shrinking the content displayed in ZOON SLIDER/ the active CONTROL MS – EXCEL PARTS AND FUNCTIONS Buttons used to change how the worksheet content is displayed – Normal, Page VIEW Layout, or Page SHORTCUTS MS – EXCEL PARTS AND FUNCTIONS Tabs that display the name of the worksheets in the SHEET TABS MS – EXCEL PARTS AND FUNCTIONS SHEET TABS SCROLLING Buttons to BUTTONS scroll the list of sheet tabs in the workbook. MS – EXCEL PARTS AND FUNCTIONS A button used to select all the cells in SELECT ALL the active BUTTONS MS – EXCEL PARTS AND FUNCTIONS The cell currently selected in the active workbook. ACTIVE CELL MS – EXCEL PARTS AND FUNCTIONS A box that displays the cell reference of the ACTIVE CELL MS – EXCEL PARTS AND FUNCTIONS A bar that displays the value or formula entered in FORMULA BAR the active MS – EXCEL PARTS AND FUNCTIONS To display informatio n about the current state of its STATUS BAR MS – EXCEL CREATING FORMULA 1 3 4 2 5 MS – EXCEL CREATING FORMULA Identify the operator EXAMPLE 6. A1>=B5 7. A1>B5 8. A1B5 < (Less than Sign) Less than A1= (Greater than or Equal to Sign) Greater than or A1>=B5 Equal to