Excel Tutorial 2 – Flashcards
Unlock all answers in this set
Unlock answersquestion
is a collection of formatting that specifies the fonts, colors, and graphical effects used throughout the workbook.
answer
Theme
question
As you work Live Preview shows the effects of formatting options on the workbook's appearance before you apply the them. This lets you see and evaluate different formats as you develop your workbook.
answer
Live Preview
question
The appearance of text is determined by its typeface, which is the specific design used for the characters, including letters, numbers, punctuation marks, and symbols. Typefaces are organized into fonts.
answer
typeface
question
A font is a set of characters that employ the same typeface. Commonly used fonts are Arial, Times New Roman, and Courier.
answer
font
question
such as Times New Roman, have extra decorative strokes at the end of each character.
answer
Serif fonts
question
such as Arial, do not include these decorative strokes.
answer
Sans serif fonts
question
associated with a particular theme and used for headings and body text in the workbook.
answer
Theme Font
question
when you don't want to associate a font with a particular design.
answer
Non-theme font
question
Formatting feature that changes the appearance of text, such as bold, italic, and underline
answer
font style
question
specifies the size of the characters and is determined by a measurement system called points--where one point is approximately 1/72 of an inch.
answer
font size
question
12 colors belonging to the workbooks theme. 4 colors are used for text and backgrounds, six colors are used for accents and highlights, and two colors are used for hyperlinks. designed to work well together and to remain readable in all color combos.
answer
Theme Colors
question
dark red, red, orange, yellow, light green, green, light blue, blue, dark blue, and purple. always available regardless of the workbooks theme. you can also open an extended palete of 134 colors.
answer
standard colors
question
A color you specify as a mixture of red, blue, and green color values, which makes available 16.7 million custom colors - more colors than the human eye can distinguish.
answer
custom color
question
options that uses your windows default text and background color values, usually black text on a white background.
answer
automatic color
question
appears when you select text and contains buttons for commonly used text formats.
answer
mini toolbar
question
Default number format that automatically displays number, for the most part, the same way you enter them.
answer
general number format
question
To join two or more cells together to make one cell
answer
MERGE
question
adding a line, or border around a cell or range
answer
BORDER
question
Provides options for formatting the appearance of numbers, including dates and numbers treated as text (for example, telephone or social security numbers)
answer
NUMBER
question
Provides options for how data is aligned within a cell
answer
ALIGNMENT
question
Provides options for selecting font types, sizes, styles, and other formatting attributes such as underlining and font colors
answer
FONT
question
Provides options for creating and applying background colors and patterns to cells
answer
FILL
question
Provides options for locking or hiding cells to prevent other users from modifying their contents
answer
PROTECTION
question
copies the formatting from one cell or range to another cell or range, without duplicating any of the data.
answer
FORMAT PAINTER
question
is a collection of formatting. For example you can create a style to display sheet titles in a bold, white 20 point Calibri font on a blue background
answer
STYLE
question
A range of data you can treat as a distinct object in a worksheet.
answer
EXCEL TABLE
question
formats the entire table as a single unit
answer
TABLE STYLE
question
In an Excel table, rows of alternating colors that make data easier to read.
answer
BANDED ROWS
question
formats the the first row of the table
answer
HEADER ROW
question
inserts a new row at the bottom of the table that adds the column values pg.EX84
answer
TOTAL ROW
question
formats the first column of the table pg EX84
answer
FIRST COLUMN
question
formats the last column of the table
answer
LAST COLUMN
question
formats alternating columns in different colors
answer
BANDED COLUMNS
question
applies formatting only when a cell's value meets a specified condition (EX86)
answer
CONDITIONAL FORMAT
question
a horizontal bar added to the background of a cell to provide a visual indicator of the cell's value. (EX87)
answer
DATA BAR
question
(EX90)
answer
HIGHLIGHTING RULES EX90
question
a key that shows each color used in the worksheet and what it means so others know why certain cells are highlighted (EX93)
answer
LEGEND
question
Consists of the cells and ranges designated for printing (EX 96)
answer
PRINT AREA
question
Performed manually when a new page is needed for a break or change in content (EX 96)
answer
PAGE BREAK
question
specify exactly where the page breaks occur (EX 96)
answer
MANUAL PAGE BREAKS
question
repeat information such as the company name by specifying rows or columns in the worksheet. info that prints on each page. (EX98)
answer
PRINT TITLES
question
text printed in the top margin of each page (EX 98)
answer
HEADER
question
the text printed in the bottom of the margin of each page (EX98)
answer
FOOTER
question
the space between the page content and the edges of the page. (EX98)
answer
MARGIN
