Shared Flashcard Set

Details

Excel Chapter 3 and 4
your mother
25
Business
04/08/2010

Additional Business Flashcards

 


 

Cards

Term
format
Definition
appearance of a worksheet on the screen and how it looks when printed
Term
change column width of adjacent columns
Definition
select the columns and drag the boundarty to the right to increase the size or to left to decrease the size
Term
insert sheet rows
Definition
make a cell active in the row below row to be inserted then click the insert button arrow; then insert sheet rows
Term
insert sheet columns
Definition
make a cell active in the column immediately to the right of where the new column is to be inserted, click insert button arrow; then click insert sheet cloumns
Term
clear format
Definition
ooption to remove formatting fro cell or selected cells while leaving the data
Term
clear contents
Definition
clears the contents of a cell but leaves the format
Term
clear all
Definition
clears the contents of the cell as well as the formatting
Term
show margins
Definition
when selected, margin boundary lines display around the worksheet
Term
theme
Definition
a set of formatting choices that include a color theme, font theme, and effects theme
Term
font theme
Definition
a set of heading and body text fonts
Term
effects theme
Definition
a set of lines and fill effects
Term
live preview
Definition
feature will dispaly the worksheet with the theme formatting applied
Term
merge cells
Definition
combines two or more selected cells into a single cell
Term
shrink to fit
Definition
reduces the size of the text fronts so all selected data fits within the column
Term
Alt+Enter
Definition
moves the insertion point to the next line within the same cell
Term
outline border option
Definition
adds outside borders of selected cells
Term
none border option
Definition
removes borders of selected cells
Term
set print area
Definition
specific more than one print area in a worksheet; select the group of cells, click the print area button in page setup group
Term
headers and footers
Definition
use the header and footer option in page setup group or click insert tab
Term
sort data
Definition
arrange in alphabetical, chronological, or numerical order; data is sorted by columns in excel; sort and filter button in editing group in home tab
Term
plan a worksheet
Definition
identify the purpose of worksheet, design the worksheet, create a sketch of worksheet, enter data in worksheet, and test the worksheet data
Term
insert page break
Definition
select column or row, click breaks button in page setup group in page layout
Term
default left and right margins
Definition
.7inches
Term
default top and bottom margins
Definition
.75 inches
Term
find and replace
Definition
used to find specific data and/or formatting in a worksheet