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
ribbon group
Contains related features and tools organized within a ribbons tab
group
two or more selected worksheets
header
isplay content at the top of a worksheet prints on every page of the workbook
label
Text entered in a worksheet that identifies a numeric data and is the most common type of text entered in a worksheet
margin
Space between your content and the edge of the page
merge cells
Two or more cells combined into a single cell
Microsoft Excel
Spreadsheet program that allows you to store organize and analyze information
name box
Displays the name or location of the active cell
orientation
The position of the content in a worksheet so that it prints either vertically or horizontally on a page
Page Break Preview
An Excel view in which you can quickly adjust automatic page breaks to achieve a more desirable printed document
page break
A divider that breaks a worksheet into separate pages for printing
page view options
Allow you to select page view options
print area
The specific range of cells to be printed
program window controls
Allows you to move resize and close the application window
Quick Access toolbar
Commonly used commands at the top of the application window
ribbon
Groups of related tools organized within a set of tabs
row height
The top-to-bottom measurement of a row
row
Horizontal cells that are labeled by numbers
series
A list of sequential numbers dates times or text
tab
Contains related groups of different tools and commands to perform the most common tasks
template
A predesigned spreadsheet you can use to create a new workbook quickly
value
A number a cell address a date or text
workbook
A collection of worksheets in a single file
worksheet tabs
Labels that appear at the bottom of the workbook window and display the names of the worksheets can be used to add deleted rename and reorder worksheets
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
wrap
To automatically display data on the next line when its too long to display within the cells width
zoom adjustment
Adjusts zooming in and out of a worksheet
