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
Header
information that appears at the top of each printed page
Footer
the information that appears on the bottom of every page
Margin
The space between the page content and the edges of the page
Cost of sales
the cost of running the stores including the employment and insurance costs
Net Profit/Loss
the difference between the income form the gross sales and the total cost of sales/operating expenses
Gross sales
the total amount of sales at all the stores
operating expenses
the cost of creating the products
Currency format
number format - places a currency symbol directly to left of first digit, adds a thousands separator to the value, shows two decimal places, lines up number in a column, displays negative numbers with a negative sign
font
a set of characters that employ the same typeface, such as Arial, Times New Roman, Courier
font style
formats that can be applied to a font such as italic, bold, BI, underline, strikethrough, color
Accounting format
number format - places a currency symbol at left EDGE of column, adds a thousands separator to value, shows two decimal places lines up numbers in column, displays negatives with negative sign
Nontheme font
a font not associated with a particular theme so it retains its appearance no matter what theme is used with the workbook
Percent style
the number format for percentages that adds the % symbol after the number and no decimal places
Style
a collection of formatting options that include a specfifed font, fotn size, font styles, font color, fill color, and border