Mrs. Ashley Hanks



Introduction to Spreadsheets –page EX 4Microsoft Excel 2010 is the ______________________ program in Microsoft Office 2010. A __________________ is a grid of rows and columns in which you enter text, numbers, and the results of calculations. The primary advantage of computer spreadsheets is their ability to complete complex and repetitious calculations _____________________________________________________.In Excel, a computerized spreadsheet is called a ______________. The file used to store worksheets is called a ___________.Starting ExcelYou click start, select student’s menu, go to Microsoft Office and then select ______________ from the menu. The Excel program window has the same basic parts as all Office programs: ____________________________________________________________________________________________Excel program window4305304572000Exploring the Parts of the WorkbookEach workbook contains ________________ worksheets by default. The name of each worksheet appears in the _____________________ at the bottom of the worksheet window.The worksheet displayed in the work area is the ______________________________________________. ________________________ appear vertically and are identified by letters. __________________ appear horizontally and are identified by numbers. A _____________________ is the intersection of a row and a column. Each cell is identified by a unique _______________. It combines the cell’s column letter and row number. Example: C11The pointer in a worksheet changes to a __________________________________ when it is in the worksheet. When the pointer is moved to a button on the Ribbon, the pointer changes to a __________________________.The cell in the worksheet in which you can type data is called the _____________________________.The ____________________________, or cell reference area, displays the cell reference of the active cell. The ________________________________ displays a formula when a worksheet cell contains a calculated value.The contents of the active cell always appear in the _________________________________.It appears to the right of the _____________________________ and displays a formula when the cell of a worksheet contains a calculated value.A ____________________ is an equation that calculates a new value from values currently in a worksheet.If a cell is not wide enough to display all the cell’s contents, extra text _____________________ into the next cells if there is room.2915285-571500Opening an Existing WorkbookOpening a workbook means ______________________________ file from a drive into the program window. To open an existing workbook, you click the File tab on the Ribbon to display Backstage view, and then click __________ in the navigation bar. The Open dialog box appears. Frogs workbook open in Excel—see diagram at rightSaving a WorkbookTwo ways to save:The _________________________ saves an existing workbook, using its current name and save location. The ______________________ lets you save a workbook with a new name or to a new location.You can create a new folder in which to save a file by clicking the New folder button in the Save As __________________________. Type a name for the new folder, and then press the Enter key.As you have saved the workbook, you can use the save command in the _______________ view or the Save button on the Quick Access toolbar to periodically save the latest version of the workbook with the same name in the same location.Save frequently (at least every ____________) to ensure that you always have a current version of the file available in case of an unexpected power outage or computer shutdown. You can press the _____________ to quickly save your workbook.Step-by-Step 1.1 page EX5: Step-by-Step 1.2 page EX6-7; Step-by-Step 1.3 page EX8-9Moving the Active Cell in a Worksheet page EX 9The easiest way to change the active cell in a worksheet is to ____________________________ to the cell you want to make active and click.The column letter and row number of the active cell are shaded in _____________________ for easy identification.You can display different parts of the worksheet by using the mouse to drag the ______________________ in the scroll bar to another position. When you press and hold down an _______________ key, the active cell shifts in that direction repeatedly and quickly.You can also move the active cell to different parts of the worksheet using the ____________________________________.You can also change the active worksheet to the next worksheet by pressing the __________________________________.Keys for moving the active cell in a worksheet84686947580036034041937698008475041270003604039193421000184785099695Page EX 900Page EX 984772512700036045911242940036042608754700360426037465003604260158115003604260108502003604260584200036045919784500360299013271500360299011203600Selecting a Group of CellsA group of selected cells is called a __________________________. In an ________________________________, all cells touch each other and form a rectangle.To select an adjacent range, click the cell in a corner of the range, ___________________________________ to the cell in the opposite corner of the range, and release the mouse button.The range is identified by its _____________________________, which lists both the cell in its upper-left corner and the cell in its lower right corner, separated by a ________________________.Example: _____________________.A __________________________________________ includes two or more adjacent ranges and selected cells. 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.Step-By-Step 1.4 page EX 10; Step-by-Step 1.5 page Ex 11Entering Data in a Cell –page EX 12Entering Data in a CellWorksheet cells can contain text, numbers, or formulas._______________ is any combination of letters and numbers and symbols, such as headings, labels, or explanatory.__________________________ are values, dates, or times.Numbers that extend beyond a cell’s width appears as ____________________ in the cell.___________________________ are equations that calculate a value. You enter data in the ________________________________. Step-by-Step 1.6 page EX 12-13Changing Data in a CellYou can ____________________________________________________ data. You can edit cell data in the ____________________ or in the _______________. The contents of the active cell always appear in the ________________________. To edit the data directly in a cell, make the cell active and then press the F2 key or _________________________ the cell.To replace cell data, select the cell, _________________________________, and press the Enter button on the Formula Bar or the Enter key or the Tab key. To ______________________ the active cell, you can use the Ribbon, the keyboard, or the mouse.Step-by-Step 1.7 page EX 14-15Searching for DataThe Find command ____________________________________, which is particularly helpful when a worksheet contains a large amount of data. You can use the Find command to locate ____________________________ of words. If you enter an incorrect value in one of the cells and want to find it, you would choose “cell contents” as your place to search in the _____________________ option box.You can use wildcard characters in the Find What box to search for data that matches a particular pattern. Use an ______________________ for two or more characters.152971521717000The Replace command is an ________________________________ of the Find command. 30997944895853094383695353015307086223000309534817272000Replacing data _______________ new data for the data that the Find command locates.309499013423900309435595186503094355561837030943831651830To use the Replace command, in the ______________ group o the Home tab of the Ribbon, click the Find and Select button and then click Replace.30949903378200Find and Replace options table at right:30988002855390Step-by-Step 1.8 page EX 16-17Zooming a Worksheet page EX 17You can change the magnification of a worksheet using the __________________________________ on the status bar. The default magnification for a workbook is ________________%. 27692352095500For a closer view of a worksheet, click the Zoom In button or drag the Zoom slider to the right to _________________ the zoom percentage. If you want to see more cells in the work area, click the Zoom button or drag the zoom slider to the left to _____________________ the zoom percentage.In the Zoom dialog box, click the ________________________ option button to zoom the worksheet so the selected range fills the worksheet window.Zoom dialog box and controls at right:Previewing and Printing a WorksheetYou can print a worksheet by clicking the _________________ tab on the Ribbon, and then clicking Print in the navigation bar to display the Print tab.The Print tab enables you to ____________________________________ such as selecting the number of copies you want to print, the printer, the parts of the worksheet to print, and the way the printed worksheet will look.The Print tab also allows you to _____________________ your pages before printing.Closing a Workbook and Exiting ExcelYou can close a workbook by clicking the _______________ tab on the Ribbon, and then clicking Close in the navigation bar. Excel remains open. You can also close the workbook and leave Excel open by clicking the Close Window button located below the sizing buttons in the ____________________________.If you try to close a workbook that contains changes you haven’t saved, __________________________________ whether or not you want to save the file.To exit the workbook, click the __________________________ command in the navigation bar.Step-by-Step 1.9 page EX 18Step-by-Step 1.10 page EX 20Step-by-Step 1.11 page EX 20 ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download