CA1-Excel 2007 Lesson 1-Review

1. CA1-Excel 2007 Lesson 1-Review

2. Starting Excel 2007 from the Windows Taskbar • Go to: Start-Programs-Microsoft Office Excel 2007 Click Microsoft Office Excel 2007 to start Excel and display a new blank workbook titled Book1 in the Excel window.

3. Excel 2007 Worksheet/Workbook A workbook is what Excel creates to store data. They are named Book1, Book2, etc. until you rename them. A worksheet is an individual sheet or tab in a workbook. A workbook opens with 3 blank worksheets. The name appears on the tab as Sheet1, Sheet2, etc. until you give it a unique name.

4. Excel 2007screen Microsoft Office button A maximized window fills the entire screen. When you maximize a window, the Maximize button changes to a RestoreDown button.

5. Excel 2007 Workbook The number of worksheets available in any workbook is limited only by the amount of memory on your computer.

6. The Excel Ribbon The Ribbon, located near the top of the Excel window, is the control center in Excel. Each tab surrounds a collection of groups, and each group contains related commands. The Home tab is the primary tab, containing the more frequently used commands.

7. Office Button Menu The Office Button, when clicked, displays a menu of central commands such as Print, Save and Open.

8. Office Button Submenus If you point to a button in the Menu that has an arrow, a submenu appears. This gives you a list of additional commands associated with the selected command.

9. Mini Toolbar The Minitoolbar, which appears automatically based on tasks you perform, contains commands related to changing the appearance of text in a worksheet. When you move the mouse toward the Mini toolbar, it brightens in appearance.

10. Shortcut Menus A shortcutmenu, which appears when you right-click an object, is a list of frequently used commands that relate to the right-clicked object.

11. The Quick Access Toolbar The Quick Access Toolbar is located above the Ribbon, providing easy access to frequently used commands.

12. The Quick Access Toolbar If you click the Customize Quick Access Toolbar button, you can see a list of commands you can quickly add to and remove from your toolbar.

13. TheWorksheet The intersection of each column and row is a cell. A cell, shown by the thickborder, is the basic unit of a worksheet into which you enter data. A cell is referred to by its unique address, or cell reference, which is the coordinates of the intersection of a column and a row (shown in yellow highlights), in this case D11, shown in the NameBox.

14. How to identify the active cell One cell on the worksheet, designated the Active Cell, is the one into which you can enter data. It can be identified by the thick border, the name shown in the name box and by the highlighting of the column and row headings. Name Box—shows the address of the active cell

15. A column begins with letters. They run up and down or vertically. There are 16,384 of them that go A-Z, then AA to AZ, and so on, until they reach XFD. Rows and Columns A worksheet appears as a grid of rows and columns. There are a total of 17,179,869,180 available cells. However, only a fraction of the active worksheet appears on the screen at on time. A row begins with numbers. They run side to side or horizontally. There are 1,048,576 rows.

16. Cell contents and the formula bar Notice that the contents in the active cell is displayed in the formula bar.

17. Selecting a Range of cells A range is a group of cells that form a rectangle on the screen. This range is B3:G3. Ranges are listed with a colon between the beginning and ending cell.

18. Selecting two ranges Use the Ctrl key to highlight noncontiguous cells.

19. Navigating a large worksheet The fastest way to go to a cell in a large worksheet is to open the name box by clicking on the arrow, then typing the name of the cell in the box, then hit Enter.

20. Changing the Zoom Magnification Zoom dialog box The Zoom controls the amount of the screen you see. Click on the View Tab, then select Zoom. The Zoom dialog box opens.

21. 2. When you choose Open, the Open dialog box appears. Open dialog box 1. Click the MS Office button.

22. To start the Edit Mode: • Double click the cell, or • Click on the cell and hit F2, or • Click the cell and then click anywhere in the formula bar Using Edit mode To delete the contents of a cell, click on it and hit the Deletekey on your keyboard.

23. Undoing multiple edits The Undo and Redo both have history arrows You can highlight multiple items in the list to Undo several at a time.

24. To open the Save As dialog box Click the MS Office button Click the Save As arrow Save As dialog box Choose the Excel Workbook—the first choice in the list—to open the Save As dialog box.

25. Save As dialog box In the File Name box, give your Excel file an appropriate name, then click Save.

26. To open the Print dialog box Click the MS Office button Click the Print arrow Print dialog box Choose Print—the first choice in the list—to open the Print dialog box.

27. Print dialog box In the Print dialog box, make your choices, then click OK.

28. Worksheet in Print Preview PrintPreview is found in the MS Office button after clicking Print.

29. Worksheet in Print Preview Click here to Close Print Preview Or Print to print the worksheet.

30. Click here to close Excel Close Window button Click here to close the current worksheet

31. Getting Help while you work Access to MS Online Help MS Online Help dialog box