Prepared Exam-Chap Scorecard. They will learn to create worksheets, work with formulas, apply styles, and print a worksheet. The major sections in this chapter microsoft excel 2016 comprehensive answer key free download 1.
Introduction to Spreadsheets. In this section, students will learn how to design spreadsheets. They will explore the Excel window and learn the name of each window element. Then, they will enter text, values, and dates in a spreadsheet, and navigate in and among worksheets.
Mathematical Operations and Formulas. In this section, students will learn how to use cell microsoft excel 2016 comprehensive answer key free download in a formula, apply the order of operations, use semi-selection to create a formula, copy a formula down a row or across a column, and display cell formulas. Worksheet Structure and Clipboard Tasks. In this section, students will learn how to manage the columns and rows in a worksheet.
They will insert, delete, hide, and unhide cells, columns, or rows, as well as adjust the column width and row height. Although worksheets are generally planned before entering data, at times there is a need to move data to a different location in the same worksheet or even to a different worksheet.
Therefore, students will also manage the worksheet by moving, copying, and microsoft excel 2016 comprehensive answer key free download the Paste Options and Paste Special features.
Worksheet Formatting. In this section, students will learn how to create a professionally formatted worksheet by applying a cell style, merging and centering data, changing cell alignments, and using borders, fonts, and colors to make data stand out so that it is easier to find and analyze.
They will also learn how to apply number formats and increase or decrease decimal places. Worksheets, Page Setup, and Printing. In this section, students will learn how to insert, delete, copy, move, rename, and group worksheets. They will also learn how to prepare worksheets for printing in case they need to print or email the worksheets to others in a readable format. Have students turn in homework assignments. Talk about the chapter using the discussion questions listed below.
Use a PowerPoint Presentation to help students understand the chapter content. Demonstrate Excel basics and capabilities. Run through the Scripted Lectures for the chapter. Give special attention to areas in which students might be challenged. Have students complete the Capstone Exercise for Excel Chapter 1. Use MyITLab for in-class work or to go over homework. Give students the homework handout for the next class period.
Active cell—The current cell in a worksheet. It is indicated by a dark green border, and the Name Box microsoft excel 2016 comprehensive answer key free download the location of the active cell.
Alignment—The placement of data within the boundaries of a cell. By default, text aligns on the left side, and values align on the right side of a cell. Auto Fill—A feature that helps you complete a sequence of months, abbreviated months, quarters, weekdays, weekday abbreviations, or values.
Auto Fill also can be used to fill or copy a formula down a column or across a row. AutoComplete—A feature that searches for and automatically displays any other label in that column that matches the letters you type. Border—A line that surrounds a cell or a range of cells to offset particular data from the rest of the data in a worksheet. When you enter or edit data, click Cancel to cancel the data entry or edit, and revert back to the previous data in the cell, if any.
Cancel changes from gray to red when you position the pointer over it. Cell—The intersection of a column and row, such as the intersection of column B and row 5. Cell address—The unique identifier of a cell, starting with the column letter and then the row number, such as C6. Cell style—A set of formatting applied to a cell to produce a consistent appearance for similar cells within a worksheet. Column heading—The alphabetical letter above a column in a worksheet.
For example, B is the column heading for the second column. Column width—The horizontal measurement of a column in a table or a worksheet. In Excel, it is measured by the number of characters or pixels. Comma Style—A number format that formats a value with a comma for every three digits on the left side of the decimal point and displays two digits to the right of the decimal point.
When you enter or edit data, click Enter to accept data typed in the active cell and keep the current cell active. Enter changes from gray to blue when you position the pointer over it. Fill color—The background color that displays behind the data in a cell so that the data stands out. Fill handle—A small green square at the bottom-right corner of the active cell.
You can position the microsoft excel 2016 comprehensive answer key free download on the fill handle microsoft excel 2016 comprehensive answer key free download drag it to repeat the contents of the cell to other cells or to copy a formula in the active cell to adjacent cells down the column or across the row.
Flash Fill—A feature that fills in data or values automatically based on one or two examples you enter using another part of data entered in a previous column in the dataset. It shows the contents of the active cell. You enter or edit cell contents in the Formula Bar for the active cell. Horizontal alignment—The placement of cell data between the left and right cell margins.
By default, text is left-aligned, and values are right-aligned. Indent—A format that offsets data from its default alignment. For example, if text is left-aligned, the text may be indented or offset from the left side to stand out. If a value is right-aligned, it can be indented or offset from the right side of the cell. Input area—A range of cells in a worksheet used to store and change the variables used in calculations.
Click Insert Function to open the Insert Function dialog box to search for and insert a particular function. Name Box—An element located below the Ribbon, which displays the address of the active cell. New sheet—An icon that, when clicked, inserts a new worksheet in the workbook. Nonadjacent range—A collection of multiple ranges such as D5:D10 and F5:F10 that are not positioned in a contiguous cluster in an Excel worksheet.
Normal view—The default view of a worksheet that shows worksheet data but not margins, headers, footers, or page breaks. Number format—A setting that controls how a value appears in a cell. Order of operations—A rule that controls the sequence in which arithmetic operations are performed.
Also called the order of precedence. Output area—The range of cells in an Excel worksheet that contains formulas dependent on the values in the input area. Page Break Preview—A view setting that displays the worksheet data and page breaks within the worksheet. Page Layout view—A view setting that displays the worksheet data, microsoft excel 2016 comprehensive answer key free download, headers, and footers. Paste Options button—An icon that displays in the bottom-right corner immediately after microsoft excel 2016 comprehensive answer key free download the Paste command.
It enables the user to apply different paste options. The default number of decimal places is zero if you click Percent Style in the Number group or two decimal places if you use the Format Cells dialog box. Pointing—The process of using the pointer to select cells while building a formula.
Also known as semi-selection. Range—A group of adjacent or contiguous cells in a worksheet. A range can be adjacent cells in a column such as C5:C10in a row such as A6:H6or a rectangular group of cells such as G5:H Row heading—A number to the left side of a row in a worksheet.
For example, 3 is the row heading for the third row. Row height—The vertical measurement of the row in a worksheet. Select All—The triangle at the intersection of the row and column headings in the top-left corner of the worksheet. Click it to select everything contained in the active worksheet. Semi-selection—The process of using the pointer to select cells while building a formula.
Also known as pointing. Sheet tab—A visual label that looks like a file folder tab. In Excel, a sheet tab shows the name of a worksheet contained in the workbook.
Sheet tab navigation—Visual elements that help you navigate to the first, previous, next, or last sheet within microsoft excel 2016 comprehensive answer key free download workbook.
Spreadsheet—An electronic file that contains a grid of columns and rows used to organize related data and to display results of calculations, enabling interpretation of quantitative data for decision making.
Status bar—The row at the bottom of the Excel window that displays instructions and other details about the status of a worksheet. Text—Any combination of letters, numbers, symbols, and spaces not used in Excel calculations. Value—A number that represents a quantity or a measurable amount. Vertical alignment—The placement of cell data between the top and bottom cell margins. View controls—Icons on the right side of the status bar that enable you to change to Normal, Page Layout, or Page Break view to display the worksheet.
Workbook—A collection of one or more related worksheets contained within a single file. Worksheet—A single spreadsheet that typically contains descriptive labels, numeric values, formulas, functions, and graphical representations of data. Wrap text—An Excel feature that makes data appear on multiple lines by adjusting the row height to fit the cell contents within the column width.
Zoom control—A control that enables you to increase or decrease the size of the worksheet data onscreen.
