![beginner excel power point beginner excel power point](https://kbimages1-a.akamaihd.net/c058abc5-649a-403a-a203-1e7771d80c9a/353/569/90/False/microsoft-office-2019-beginner.jpg)
To replace cell data, select the cell, type new data, and press the Enter button on the Formula Bar or the Enter key or the Tab key. The contents of the active cell always appear in the Formula Bar. You can edit cell data in the Formula Bar or in the cell. You enter data in the active cell.ġ9 Changing Data in a Cell You can edit, replace, or clear data.
![beginner excel power point beginner excel power point](https://i2.wp.com/theexcelclub.com/wp-content/uploads/2019/05/excel-orientation-for-beginners.png)
![beginner excel power point beginner excel power point](https://24slides.com/presentbetter/content/images/wordpress/2018/02/image4.png)
Formulas are equations that calculate a value. Text is any combination of letters and numbers and symbols. To select a nonadjacent range, select the first adjacent range or cell, press the Ctrl key as you select the other cells or ranges you want to include, and then release the Ctrl key and the mouse button.ġ8 Entering Data in a Cell Worksheet cells can contain text, numbers, or formulas. To select an adjacent range, click the cell in a corner of the range, drag the pointer to the cell in the opposite corner of the range, and release the mouse button.ġ7 Selecting a Group of Cells (continued)Ī nonadjacent range includes two or more adjacent ranges and selected cells. In an adjacent range, all cells touch each other and form a rectangle. The range is identified by its range reference, for example, A3:C5. Keys for moving the active cell in a worksheetĪ group of selected cells is called a range. 14 14ġ5 Moving the Active Cell in a Worksheet (continued) You can also move the active cell to different parts of the worksheet using the keyboard or the Go To command. You can display different parts of the worksheet by using the mouse to drag the scroll box in the scroll bar to another position. The easiest way to change the active cell in a worksheet is to move the pointer to the cell you want to make active and click. The Save As command lets you save a workbook with a new name or to a new location. 11 11ġ2 Opening an Existing Workbook (continued)ġ3 Saving a Workbook The Save command saves an existing workbook, using its current name and save location. To open an existing workbook, you click the File tab on the Ribbon to display Backstage view, and then click Open in the navigation bar. Opening a workbook means loading an existing workbook file from a drive into the program window. A formula is an equation that calculates a new value from values currently in a worksheet. The Formula Bar displays a formula when a worksheet cell contains a calculated value. The Name Box, or cell reference area, displays the cell reference of the active cell. The cell in the worksheet in which you can type data is called the active cell. 9 9ġ0 Exploring the Parts of the Workbook (continued) Each cell is identified by a unique cell reference. A cell is the intersection of a row and a column. Rows appear horizontally and are identified by numbers. Columns appear vertically and are identified by letters. The worksheet displayed in the work area is the active worksheet. 7 7Įach workbook contains three worksheets by default. The Excel program window has the same basic parts as all Office programs: the title bar, the Quick Access Toolbar, the Ribbon, Backstage view, and the status bar. Click the Start button, click All Programs, click Microsoft Office, and then click Microsoft Excel 2010. 6 6ħ Starting Excel You start Excel from the Start menu in Windows. The file used to store worksheets is called a workbook. In Excel, a computerized spreadsheet is called a worksheet. A spreadsheet is a grid of rows and columns in which you enter text, numbers, and the results of calculations. Microsoft Excel 2010 is the spreadsheet program in Microsoft Office 2010. Range range reference row sheet tab spreadsheet workbook worksheet 5 5 3 3Ĥ Vocabulary 4 4 active cell active worksheet adjacent range cellĬell reference column formula Formula Bar landscape orientation Microsoft Excel 2010 (Excel) Name Box nonadjacent range portrait orientation 4 4 Select cells and enter data in a worksheet. Start Excel, open an existing workbook, and save a workbook. Microsoft Office 2010 Introductory Pasewark & PasewarkĢ Objectives Define the terms spreadsheet and worksheet.