Chapter 5 Flashcards
Spreadsheets Creating and Editing Workbooks
Microsoft Excel
Spreadsheet program that allows you to store organize and analyze information
workbook
A collection of worksheets in a single file
worksheet
A page in a workbook that consists of a grid of rows and columns in which you can enter text values and formulas and perform calculations
active cell
A cell that is highlighted or outlined by a bold black rectangle
alignment
Arrangement of cell contents in relation to left and right sides of a cell and the top and bottom of a cell
Backstage view
A view that shows you behind-the-scenes options for managing files such as opening saving printing and documenting files
border
An outline applied to the sides of a cell
cell range
A group of adjacent cells you select to perform operations on all of the selected cells
cell
The intersection of a row and column which is identified by a letter and number
column width
The left-to-right measurement of a column
column
Vertical cells that are labeled by letters
dialog box launcher
Opens a small window with information and options about a particular tool or group
Drag and Drop
The action of using a mouse to drag a selection from its original location and drop it in a new location
fill handle
A small square in the lower right corner of a selected cell or range of cells
Flash Fill
Excel recognizes a pattern based on other information in your workbook it uses the pattern to enter data into several cells at once
footer
Display content at the bottom of the page prints on every page of the workbook
formula bar
Where data and formulas are entered and edited which then appears in the active cell