excel test 2 Flashcards
theme
a collection of formatting for text, colors, and effects that give a workbook a specific look/feel
theme font
a font associated with a particular theme and used for headings and body text in the workbook; change automatically when theme is changed
standard font
retains its appearance no matter what theme is used with the workbook
standard color
one of the 10 colors - dark red, red, orange, yellow, light green, light blue, blue, dark blue, purple - that is always available regardless of the workbook’s theme
serif font
have extra strokes at the end of each character. EX: Times New Roman
sans serif font
does not include extra strokes at end of each character. EX: Arial, Calibri
Theme color
one of 12 coordinated colors that belong to workbook’s theme
mini toolbar
contains buttons for common formatting options used for that selection
percent change
(current year - previous year) / previous year
General format
the number format that mostly displays values exactly as they are typed - cells start out formatted in General format
Commas (style)
separates thousands in large numbers adds two decimals, lines up vales within a column by their decimal points
Excel stores dates as ___
numbers, not text
Short Date Format
the abbreviated format mm/dd/yyyy
Long Date format
displays the day of the week and the full month name in addition to date of month and year
Monday, February 5, 2024
In general, a _____ should appear above a subtotal and a ____ should be added below a calculated number
single black border
single bottom border
Format painter
copies and pastes formatting from one cell or range to another, without duplicating data
Print title
row and/or columns that are included on every page of the printout
Manual page break
a page break you set to indicate where a new page of printout should start
Conditional formatting
applies format to a cell when its value meets a specified condition
Cell style
predefined formatting options that can be applied to cells in a workbook
page break preview
shows location of print area all page breaks, last button on right side of status bar
Quick analysis tool
a button that appears whenever you select a range of cells, provides access to the most common tools for data analysis and formatting
Legend
a key that identifies the colors/shapes used in a worksheet/chart.
click Conditional Formatting button, point to Highlight Cells Rules, and click Text that Contains
Print area
the range or ranges in a WS that you specify to be printed.
click Page Layout, Print Area, Set Print Area
