Benchmark Series © Paradigm Publishing, LLCExcel 365, 2019 Edition: Level 1, Chapter 1, Activity 1a Watch and Learn LessonBenchmark Series © Paradigm Publishing, LLCExcel 365, 2019 Edition: Level 1, Chapter 1, Activity 1a Watch and Learn LessonCreating a WorksheetOpen Excel by clicking the Excel tile at the Windows Start menu, or by following other steps as needed depending on the operating system. At the Excel opening screen, click the Blank workbook template. This displays a workbook with a blank worksheet, as shown in Figure 1.1. The elements of a blank Excel worksheet are described in Table 1.1. A file created in Excel is referred to as a workbook. An Excel workbook consists of an individual worksheet (or sheet) by default but it can contain multiple work sheets, like the sheets of paper in a notebook. Notice the tab named Sheet1, at the bottom of the Excel window. The area containing the gridlines in the Excel window is called the worksheet area. Figure 1.2 identifies the elements of the worksheet area. Create a worksheet in the worksheet area that will be saved as part of a workbook. Columns in a worksheet are labeled with letters of the alphabet and rows are labeled with numbers. The intersection of a column and a row creates a box, which is referred to as a cell. A cell is where data and formulas are entered.Opening a Blank WorkbookTutorialActivity 1 Prepare a Worksheet with Employee Information 3 PartsYou will create a worksheet containing employee information, edit the contents, and then print, save and close the workbook.Figure 1.1 Blank Excel WorksheetFile tabQuick Access ToolbarTitle barribbonvertical scroll bartabsworksheet areaactive cellName boxFormula bardialog box launchercell pointerStatus barsheet tabNew sheet buttonhorizontal scroll barCollapse the Ribbon buttonTell Me text boxBenchmark Series © Paradigm Publishing, LLCExcel 365, 2019 Edition: Level 1, Chapter 1, Activity 1a Watch and Learn LessonBenchmark Series © Paradigm Publishing, LLCExcel 365, 2019 Edition: Level 1, Chapter 1, Activity 1a Watch and Learn LessonFeatureDescriptionactive cellthe currently selected cell, surrounded by a thick green bordercell pointerwhen this icon appears, select cells by clicking or dragging the mouseCollapse the Ribbon buttonwhen clicked, removes the ribbon from the screen (Redisplay the ribbon by double-clicking a tab, except the File tab.)dialog box launcher click to open a dialog box with more options for that groupFile tabdisplays the backstage area that contains options for working with and managing filesFormula bardisplays the contents stored in the active cellhorizontal and vertical scroll barsused to scroll left and right or up and down to view various parts of the worksheetName boxdisplays the active cell address or name assigned to the active cellNew sheet buttonclick to insert a new worksheet in the workbookQuick Access Toolbarcontains buttons for commonly used commands that can be executed with a single mouse clickribboncontains the tabs with commands and buttonssheet tabidentifies the current worksheet in the workbookStatus bardisplays the current mode, action messages, view buttons, and Zoom slider bartabcontains commands and buttons organized into groupsTell Me text boxprovides information and guidance on how to perform an actionTitle bardisplays the workbook name followed by the application nameworksheet areacontains the cells used to create a worksheetTable 1.1 Elements of an Excel WorksheetFigure 1.2 Elements of the Worksheet Areacolumn headerfill handlerow headerSelect All buttoncell pointeractive cellsheet tabNew Sheet buttonBenchmark Series © Paradigm Publishing, LLCExcel 365, 2019 Edition: Level 1, Chapter 1, Activity 1a Watch and Learn LessonBenchmark Series © Paradigm Publishing, LLCExcel 365, 2019 Edition: Level 1, Chapter 1, Activity 1a Watch and Learn Lesson The horizontal and vertical lines that define the cells in the worksheet area are called gridlines. When a cell is clicked, it becomes active and a thick green border appears around it. The cell address, also called the cell reference, appears in the Name box. The cell reference includes the column letter and row number. For example, if the first cell of the worksheet is active, the cell reference A1 is shown in the Name box. Any number of adjacent cells can be made active and form a range. A range is typically identified by the first cell reference and last cell reference separated by a colon. For example, the range A1:C1 contains the cells A1, B1, and C1.Entering Data in a WorksheetEnter data such as text, a number, or a value in a cell. To enter data in a cell, make the cell active and then type the data. To make the next cell active, press the Tab key. Table 1.2 shows additional commands for making a specific cell active. Another method for making a cell active is to use the Go To feature. To use this feature, click the Find & Select button in the Editing group on the Home tab and then click Go To. At the Go To dialog box, type the cell reference in the Reference text box and then click OK. Before typing data into the active cell, check the Status bar. The word Ready should display at the left. As data is typed in a cell, the word Ready changes to Enter. Data typed in a cell is shown in the cell and in the Formula bar. If the data entered in a cell is longer than the cell can accommodate, the data overlaps the next cell to the right. (It does not become a part of the next cell—it simply overlaps it. How to change column widths to accommodate data is explained later in this chapter.)Ctrl + G is the keyboard shortcut to display the Go To dialog box.HintTo make a cell active, position the cell pointer in the cell and then click the left mouse button.HintFind & SelectEntering DataTutorialNavigating and ScrollingTutorialTable 1.2 Commands for Making a Specific Cell ActiveTo make this cell activePresscell below current cellEntercell above current cellShift + Enternext cellTabprevious cellShift + Tabcell at beginning of rowHomenext cell in direction of arrowUp, Down, Left, or Right Arrow keylast cell in worksheetCtrl + Endfirst cell in worksheetCtrl + Homecell in next windowPage Downcell in previous windowPage Upcell in window to rightAlt + Page Downcell in window to leftAlt + Page UpBenchmark Series © Paradigm Publishing, LLCExcel 365, 2019 Edition: Level 1, Chapter 1, Activity 1a Watch and Learn LessonBenchmark Series © Paradigm Publishing, LLCExcel 365, 2019 Edition: Level 1, Chapter 1, Activity 1a Watch and Learn Lesson If data entered in a cell consists of text and the text does not fit in the cell, it overlaps the next cell to the right. If, however, a number is entered in a cell and the number is too long to fit in the cell, Excel changes the display of the number to number symbols (###). This change is made because Excel does not want to mislead users by showing only part of a number in a cell. Along with the keyboard, the mouse can be used to make a specific cell active. To make a specific cell active with the mouse, position the mouse pointer, which appears as a white plus symbol ( ) (called the cell pointer), in the cell and then click the left mouse button. The pointer appears as a white plus sign when positioned in a cell in the worksheet and as an arrow when positioned on other elements of the Excel window, such as options and buttons on tabs and scroll bars. Scroll through a worksheet using the horizontal and/or vertical scroll bars. Scrolling shifts the display of cells in the worksheet area but does not change the active cell. Scroll through a worksheet until the desired cell is visible and then click in the cell to make it active.Saving a WorkbookSave an Excel workbook, including all sheets within it, by clicking the Save button on the Quick Access Toolbar or by clicking the File tab and then clicking the Save As option at the backstage area. At the Save As backstage area, click the Browse option and the Save As dialog box displays. At the Save As dialog box, click the desired location in the Navigation pane, type a name for the workbook in the File name text box, and then press the Enter key or click the Save button. Bypass the Save As backstage area and go directly to the Save As dialog box by using the keyboard shortcut F12. To save an Excel workbook in the EL1C1 folder, display the Save As dialog box, navigate to the correct drive in the Navigation pane, and then double-click EL1C1 in the Content pane. A workbook file name can contain up to 255 characters, including the drive letter and any folder names, and it can include spaces. Each file should have a distinct name. Excel will not allow two workbooks to be saved with the same file name in the same folder, even if one is in uppercase and one is lowercase. (For example, one file cannot be named EXPENSES and another expenses.) Also, some symbols cannot be used in a file name, such as the following:forward slash (/) question mark (?)backslash (\) quotation mark (")greater-than symbol (>) colon (:)less-than symbol (<) asterisk (*)pipe symbol (|) If changes are made to a workbook, save the file again before closing it. It is a good practice to save periodically while working with a file to be sure no changes are lost if the application crashes or freezes or if power is interrupted. Note: If an Excel workbook is stored in a cloud location such as Microsoft OneDrive, OneDrive for Business, or SharePoint Online, any changes to it will be saved automatically with the AutoSave feature. Multiple users can edit a file and AutoSave will save the workbook every few seconds so that changes can be seen by everyone. AutoSave can be turned on or off by clicking the toggle switch in the upper left corner of the Excel screen.Saving with the Same NameTutorialSaving with a New NameTutorialSaveSave Workbook1. Click Save button on Quick Access Toolbar.2. At Save As backstage area, click Browse option.3. At Save As dialog box, navigate to folder.4. Type workbook name.5. Press Enter key.uick StepsCtrl + S is the keyboard shortcut to save a workbook.HintBenchmark Series © Paradigm Publishing, LLCExcel 365, 2019 Edition: Level 1, Chapter 1, Activity 1a Watch and Learn LessonBenchmark Series © Paradigm Publishing, LLCExcel 365, 2019 Edition: Level 1, Chapter 1, Activity 1a Watch and Learn Lesson 1. Open Excel by clicking the Excel tile at the Windows Start menu. (Depending on your operating system, the steps to open Excel may vary.) 2. At the Excel opening screen, click the Blank workbook template. (This opens a workbook with a blank worksheet.) 3. At the blank Excel worksheet, create the worksheet shown in Figure 1.3 by completing the following steps: a. Press the Enter key to make cell A2 the active cell. b. Type Employee in cell A2. c. Press the Tab key. (This makes cell B2 active.) d. Type Location and then press the Tab key. (This makes cell C2 active.) e. Type Benefits and then press the Enter key to move the insertion point to cell A3. f. Type Avery in cell A3. g. Continue typing the data shown in Figure 1.3. (For commands that make specific cells active, refer to Table 1.2.) 4. After typing the data shown in the cells in Figure 1.3, save the workbook by completing the following steps: a. Click the Save button on the Quick Access Toolbar. b. At the Save As backstage area, click the Browse option. c. At the Save As dialog box, navigate to your EL1C1 folder in the Navigation pane and then double-click the EL1C1 folder in the Content pane. d. Select the text in the File name text box and then type 1-EmpBene. e. Press the Enter key or click the Save button.Activity 1a Creating and Saving a Workbook Part 1 of 3 3b4d4aFigure 1.3 Activity 1aCheck Your WorkEmployee LocationBenefitsAveryConnorsEstradaJuergensMikulichTalbotNext >