An Image/Link below is provided (as is) to download presentationDownload Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.Content is provided to you AS IS for your information and personal use only. Download presentation by click this link.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.During download, if you can't get a presentation, the file might be deleted by the publisher.
E N D
Presentation Transcript
Chapter 8 EXCEL VOCABULARY
Active cell:The cell displayed with a bold border. Also called the selected cell.Adjacent cells:Cells that are next to each other.Boundary:The bar separating the column letters at the top of the worksheet.Cell reference:The column letter and row number that identify a cell, such as B3.
Cell:The intersection of a row and column.Circular reference:An error that occurs when a formula references the cell it is stored in.Clip art:A general-purpose graphic created by an artist using illustration software.Columns:Vertical part of the worksheet grid identified by the letters A to Z and AA to XFD.Conditional formatting:Formatting that is applied to a cell when a specified condition is met.
Cell styles:Used to apply several formats in one step.Data:Information stored in a worksheet. Categorized as either label, value, or date/time.Date:Data displayed as a calendar date.Destination:The upper-left cell of the range where data is to be pasted.
Duplicate data:To make a copy of data and then place that copy at a different location in the worksheet or into a completely different document.Fill handle:The solid square in the lower-right corner of a selected cell that is dragged to copy the contents of a cell to adjacent cells.Formula bar:Displays the active cell's contents. Located above the cells.Formula:Mathematical statement used to calculate a value. A formula must always begin with an equal sign
Gridlines:Solid lines that mark off the rows and columns in a worksheet.Headings:Row numbers and column letters.HTML:The file format for documents viewed using a browser.Insertion point:A blinking vertical line that indicates where the next character typed will be placed.
Keyword:A descriptive word used to search for clip art.Label:Text stored in a cell that cannot be used in calculations.Move data:Delete data from a worksheet and then place that data at a different location in the workbook or into another file.Name box:Displays the cell reference of the active cell. Located at the top of the worksheet.
Order of operations:The precedence Excel follows to evaluate a mathematical expression.Page Layout view:View that displays the worksheet as a printed page.Pointing:Clicking a cell to place its reference in a formula.Range:Selection of two or more cells.Relative cell reference:A cell reference that reflects the row or column it has been copied to.Row:Horizontal part of the worksheet grid identified by the numbers 1 to 1,048,576.
Sheet tab:Used to display a worksheet.Source:Selected cells to be copied or moved.Spreadsheet:An application used to store and analyze data.Template:A master workbook that includes the basic elements for a particular type of workbook.
Time:Data displayed as a time (i.e., 12:30 PM).Title:In an HTML document, the text that is displayed in the title bar.Value:Numeric data that can be used in calculations.Workbook:An Excel file.Worksheet:Sheets in an Excel workbook
