Day 7 - Microsoft Excel-EmpowermentTech.pptx

A powerpoint presentation for understanding microsoft excel

1. EMPOWERMENT TECHNOLOGIES Productivity Tools ( Microsoft Excel) Prepared by: REINA DIANE B. DE MESA

2. REVIEW What is Mail Merge? What are the Three (3) Components of the Mail Merge

3. Directions: Based on the provided image, try to identify what is common between the two (2) tables and make a list of your observations. NOTICE ME!

4. NOTICE ME!

5. #OOTD 1. Learn the Parts of the Microsoft Excel 2. Understand the importance of the usage of Spreadsheets and Excel 3. Label the parts of the Microsoft Excel

6. It is the most widely used spreadsheet program and is part of Microsoft Office Suite. It can handle various types of data and is very good for the purpose of calculations. Excel has been rightly called a word processor for numbers . MICROSOFT EXCEL

7. The calculated results are accurate and reliable. 2. All kind of complicated calculations can be performed very easily 3. The worksheet can be quite big in size and any part of it can be viewed or edited. 4. It provides graphics facility 5. The entire worksheet or any part of it can be printed in the desired format. Advantages of Electronic Spreadsheet

8. 6. The worksheet can be saved in an electronic file that can be modified later. 7. An existing worksheet or any part of it can be merged with a new worksheet. 8. Electronic Spreadsheet programs have several mathematical, financial and statistical functions which are built-in and are very user-friendly Advantages of Electronic Spreadsheet

9. An excel document is referred to as workbook. A workbook holds one or more worksheets (Spreadsheets). In other words, a workbook is a collection of worksheets stored in a single file. A work book is useful for grouping the worksheets of a project together. WORK BOOK

10. WORK BOOK

11. A worksheet is a table like document containing rows and columns that holds data and formula. There are 16,384 columns and 1,048,576 rows in each worksheet. The columns are named A, B, C…. Up to Z then AA, AB, AC…. Up to ZZ and then AAA, AAB, AAC… up to XFD. WORKSHEET

12. Rows are numbered from 1 to 1,048,576. A box (column-row intersection) in a worksheet is called a cell . There are 17,179,869,184 cells in each work sheet. Each cell has a cell address or cell reference. A cell address/reference formed by column letter and row number . Ex. B12 is the cell address for the cell located in the Column B and row 12. WORKSHEET

13. COMPONENTS OF EXCEL

14. FEATURE DESCRIPTION File Button A button that can be used to open a menu which contains many options to work with the Excel file Quick Access Toolbar A collection of buttons that provide one-click access to commonly used commands, such as Save and Repeat Title Bar A bar that displays the name of the active workbook and the Excel program name Ribbon The main set of commands organized by task into tabs and groups Column headings The letters that appears doing the top of the worksheet windows to identify the different columns in the worksheet. EXPLORING EXCEL

15. FEATURE DESCRIPTION Workbook window A window that displays an Excel Workbook Vertical Scroll Bar A scroll bar used for to scroll vertically through the work book window Horizontal Scroll Bar A scroll bar used for to scroll vertically through the work book window horizontally Zoom controls Controls for magnifying words and shrinking the content displayed in the active work book window View shortcuts Buttons used to change how the worksheet content is displayed- Normal, Page Lay-out or Page Break Preview View EXPLORING EXCEL

16. FEATURE DESCRIPTION Sheet tabs Tabs that display the names of the worksheets in the Workbook Sheet tab scrolling buttons Buttons to scroll the list of sheet tabs in the work book Row headings The number that appear along the left of the worksheet window to identify the different rows in the worksheet Select All button A button used to select all of the cells in the active worksheet Active cell The cell currently selected in the active worksheet EXPLORING EXCEL

17. FEATURE DESCRIPTION Name Box A box that displays the cell reference of the active cell Formula Bar A bar that displays the value o r formula entered in the active cell Status Bar A name for the lower edge of the worksheet window, which displays various information about an Excel worksheet EXPLORING EXCEL

18. Click Windows Key and search for Microsoft Excel HOW TO START MS EXCEL

19. EXCEL WILL AUTOMATICALLY POP-UP

20. Directions: Name the parts of Microsoft Excel by filling in the gaps in the box below. You may use the hint on the right corner to help you decode the terms. LABEL IT!

21. 11. What productivity tool is used when handling various types of data and is very good for the purpose of calculations. A. Microsoft Word C. Microsoft Excel B. Microsoft PowerPoint D. Microsoft Publisher EVALUATION

22. 12. Which of the following choices is useful for grouping the worksheets of a project together? A. Worksheet C. Work Load B. Work Book D. Work out EVALUATION

23. 13. A Work Sheet contains how many columns? A. 17,890 C. 16,384 B. 16,345 D. 18,098 EVALUATION

24. 14. What do you call the box or column row intersection in a work sheet? A. Work book C. Row B. Cell D. Column EVALUATION

25. 15. What is a box that displays the cell reference of the active cell? A. Name Box C. Work Box B. Cue Box D. Spreadsheet Box EVALUATION