Shared Flashcard Set

Details

Excel Chapters 3&4
formatting worksheets
27
Business
12th Grade
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 colomns and drag the boundary 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
inset sheet columns
Definition
make a cell active in the column immediatly to the right of where the new column is to be inserted, click insert button arrow; then click Insert Sheet Rows.
Term
clear format
Definition
potion to remove formatting from cells 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
Color Theme
Definition
a set of colors
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 display the worksheet with the teme 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 font 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
Wrap Text
Definition
reamin in a cell and wraps 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
specify more than one print area in a worksheet, select the group of cells, click the Pringt area button in page setup group
Term
headers and footers
Definition
use the headers and footer option in page set up group or click insert tab
Term
sort data
Definition
arrange in alphabetical, chronological, or numerical order; data is osrted 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 adata in worksheet and test the worksheet data
Term
Insert Page Break
Definition
select column or row, click breaks button in page setup group in pate layout tab
Term
default left and right margins
Definition
.7 inch
Term
default top and bottom margins
Definition
.75 inch
Term
Find and Replace
Definition
used to find specific data and or formatting in a worksheet
Supporting users have an ad free experience!