empowerment technologies: advance microsoft office e

empowerment technologies

1. MS - EXCEL SPREADSHEET EMPOWERMENT TECHNOLOGIES

2. A type of application program which manipulates numerical and string data in rows and columns of cells .

3. SPREADSHEET USES: SCHOOL: Students Grades and Payroll SPORTS: Individual and Team Statatistics PERSONAL: Checkbook and Household Expenses BUSINESS: Payroll and Investments

4. MS – EXCEL PARTS AND FUNCTIONS

5. MICROSOFT EXCEL PARTS RIBBON WORKSHEET COLUMN HEADINGS ACTIVE CELL ROW HEADINGS SHEET TABS QUICK ACCESS TOOLBAR TITLE BAR FILE TAB NAME BOX SELECT ALL BUTTON SHEET TAB SCROLLING BUTTON STATUS BAR FORMULA BAR VIRTICAL SCROLL BAR HORIZONTAL SCROLL BAR ZOOM CONTROL VIEW SHORTCUTS

6. MICROSOFT EXCEL PARTS 17 15 12 1 9 3 8 4 5 14 11 6 10 18 13 2 16 7

7. MS – EXCEL PARTS AND FUNCTIONS OFFICE BUTTON A button that provides access to workbook – level features and program settings.

8. MS – EXCEL PARTS AND FUNCTIONS QUICK ACCESS TOOLBAR Accollection of buttons that provide one – click access to commonly used commands, such as Save, Undo, and Redo.

9. MS – EXCEL PARTS AND FUNCTIONS TITLE BAR A bar that displays tha name of the active workbook and the Excel program name.

10. MS – EXCEL PARTS AND FUNCTIONS RIBBON The main set of commands organized by task into tabs and groups .

11. MS – EXCEL PARTS AND FUNCTIONS COLUMN HEADINGS The letters that appear along the top of the worksheet window.

12. MS – EXCEL PARTS AND FUNCTIONS ROW HEADINGS The number that appears along the left of the worksheet window.

13. MS – EXCEL PARTS AND FUNCTIONS WORK SHEET WINDOW A window that displays an Excel Workbook (Spreadsheets).

14. MS – EXCEL PARTS AND FUNCTIONS VERTICAL SCROLL BAR A scroll bar used to scroll vertically through the workbook window.

15. MS – EXCEL PARTS AND FUNCTIONS HORIZONTAL SCROLL BAR A scroll bar used to scroll horizontally through the workbook window.

16. MS – EXCEL PARTS AND FUNCTIONS ZOON SLIDER/ CONTROL Controls for magnifying and shrinking the content displayed in the active workbook window.

17. MS – EXCEL PARTS AND FUNCTIONS VIEW SHORTCUTS Buttons used to change how the worksheet content is dospalyed – Normal, Page Layout , or Page Break Preview View.

18. MS – EXCEL PARTS AND FUNCTIONS SHEET TABS Tabs that display the name of the worksheets in the workbook.

19. MS – EXCEL PARTS AND FUNCTIONS SHEET TABS SCROLLING BUTTONS Buttons to scroll the list of sheet tabs in the workbook.

20. MS – EXCEL PARTS AND FUNCTIONS SELECT ALL BUTTONS A button used to select all the cells in the active workbook.

21. MS – EXCEL PARTS AND FUNCTIONS ACTIVE CELL The cell currently selected in the active workbook.

22. MS – EXCEL PARTS AND FUNCTIONS ACTIVE CELL A box that displays the cell reference of the active cell .

23. MS – EXCEL PARTS AND FUNCTIONS FORMULA BAR A bar that dispalys the value or formula entered in the active cell .

24. MS – EXCEL PARTS AND FUNCTIONS STATUS BAR To display information about the current state of its window,

25. MS – EXCEL CREATING FORMULA

26. 1 2 3 4 5

27. MS – EXCEL CREATING FORMULA Identify the operator EXAMPLE 6. A1 >= B5 7. A1 > B5 8. A1 <= B5 9. A1 < B5 10. A1 <> B5 11. A1=B5

28. MS – EXCEL CREATING FORMULA Give the meanig ARITHMETIC OPERATOR 12. + (Plus Sign) 13. - (Minus Sign) 14. * (Asterisk) 15. / (Forward Slash) 16. % (Percent) 17. ^ (Caret0

29. MS – EXCEL CREATING FORMULA EQUAL SIGN A sign that tells Excel that the succeeding characters constitute a formula .

30. MS – EXCEL CREATING FORMULA FUNCTION A pre – written formula that takes a value and perform an operations and return a value.

31. MS – EXCEL CREATING FORMULA CELL REFERENCE/ ARGUMENT The address of a cell based on the relative position of the cell that contains formula.

32. MS – EXCEL CREATING FORMULA OPERATOR A sign or symbol that specifies the type of calculations to perform with an expression.

33. MS – EXCEL CREATING FORMULA CONSTANT VALUE A value is not calculated and therefore does not changes .

34. MS – EXCEL CREATING FORMULA ARITHMETIC OPERATOR MEANING EXAMPLE + (Plus Sign) Addition A1+C7 - (Minus Sign) Subraction or Negation A1–C7 * (Asterisk) Multiplacation A1*C7 / (Forward Slash) Division A1/C7 % (Percent) Percent 20% ^ (Caret0 Exponentiation A1^C7

35. MS – EXCEL CREATING FORMULA COMPARISON OPERATOR MEANING EXAMPLE = (Equal Sign) Equal to A1=B5 > (Greater than Sign) Greater than A1 > B5 < ( Less than Sign) Less than A1 < B5 >= (Greater than or Equal to Sign) Greater than or Equal to A1 >= B5 <= ( Less than or Equal to Sign) Less than or Equal to A1 <= B5 <> (Not Equal to) Not Equal to A1 <> B5

36. MS – EXCEL CREATING FORMULA REFERENCE OPERATOR MEANING EXAMPLE : (Colon) Range oprator , which produces one reference to all the cells between two references, including the two references. B5:B15 , (Comma) Union operator , which combines multiple references into one reference. =SUM(B5:B15, D5:D15) Space Intersection operator , which produces one reference to cells common to the two references. B7:D7 C6:C8

37. SAMPLE DATA

38. CASE 1 – FIND THE TOTAL VALUE

39. CASE 2 – FIND THE TOTAL VALUE

40. DRAG DOWN OR COPY THE SAME

41. FINAL RESULT VALUE

42. CASE 1 – FIND THE AVERAGE VALUE

43. CASE 2 – FIND THE AVERAGE VALUE

44. DRAG DOWN OR COPY THE SAME

45. FINAL RESULT VALUE

46. MS - EXCEL SPREADSHEET EMPOWERMENT TECHNOLOGIES