BUS 1350 EXAM #1 KAREN
LESKOVEN-BAYLOR QUESTIONS &
VALID COMPLETE SOLUTIONS
change the chart type - Correct Answer ✔✔ design tab->type group->change chart type
switch data from rows to columns - Correct Answer ✔✔ design tab->switch row/column
move a chart to a different location - Correct Answer ✔✔ click on the design tab for the
chart-> move chart->select where you want to move it
add labels and titles to charts - Correct Answer ✔✔ click the + to the right of the chart
OR double click on a label to edit
formatting charts - Correct Answer ✔✔ use design tab for chart->quick layouts->change
colors->pick a new chart style
embedded charts - Correct Answer ✔✔ chart goes on top of the worksheet you put it in
a blank cell is considered a ___________ - Correct Answer ✔✔ text entry
built-in cell styles - Correct Answer ✔✔ predefined and named combinations of a cell
and content formatting properties
can you apply multiple cell styles in one cell - Correct Answer ✔✔ YES
determined by order of application
format painter - Correct Answer ✔✔ lets you copy the format of objects (text/pictures) to
other objects
4 conditional formats - Correct Answer ✔✔ data bars, highlights, color scales, icon sets
how many conditions can you format at one time? - Correct Answer ✔✔ 3 conditions
print preview - Correct Answer ✔✔ view of a document as it will appear when printed
page break preview - Correct Answer ✔✔ shades areas of worksheet that aren't
included in print area
print titles - Correct Answer ✔✔ titles included on each printed page
dotted line border - Correct Answer ✔✔ indicates page break
, insert page break - Correct Answer ✔✔ -click cell BELOW row you want to insert a
break
-page layout->setup group->breaks->insert page breaks
remove page break - Correct Answer ✔✔ page layout->page setup->breaks->remove
page break
dynamically linked charts - Correct Answer ✔✔ select chart title->type "=" in formula
bar-> select the cell you want to link with chart title
theme - Correct Answer ✔✔ -collection of fonts, styles, colors, and effects associated
with theme name
-enables you to create professional color coordinated documents quickly
default theme - Correct Answer ✔✔ -office theme
-theme that is automatically applied unless you specify otherwise
office theme - Correct Answer ✔✔ default theme
theme font - Correct Answer ✔✔ -font associated with particular theme
-automatically adjusts when changing theme
Do background images print by default? - Correct Answer ✔✔ NO
Do fill colors cover background images? - Correct Answer ✔✔ YES
background image - Correct Answer ✔✔ -does not have to match size of worksheet
-do not affect cell's format/content
bright fill colors - Correct Answer ✔✔ -used to highlight a value that requires attention
fill color - Correct Answer ✔✔ -background color of a cell
-muted or pastel
-used to band rows or columns & categorize information
theme colors - Correct Answer ✔✔ -12 colors of workbook theme
-each color has 5 variations
standard colors - Correct Answer ✔✔ 10 colors
sans serif font - Correct Answer ✔✔ no strokes at end of character
serif font - Correct Answer ✔✔ have extra strokes at the end of each character
LESKOVEN-BAYLOR QUESTIONS &
VALID COMPLETE SOLUTIONS
change the chart type - Correct Answer ✔✔ design tab->type group->change chart type
switch data from rows to columns - Correct Answer ✔✔ design tab->switch row/column
move a chart to a different location - Correct Answer ✔✔ click on the design tab for the
chart-> move chart->select where you want to move it
add labels and titles to charts - Correct Answer ✔✔ click the + to the right of the chart
OR double click on a label to edit
formatting charts - Correct Answer ✔✔ use design tab for chart->quick layouts->change
colors->pick a new chart style
embedded charts - Correct Answer ✔✔ chart goes on top of the worksheet you put it in
a blank cell is considered a ___________ - Correct Answer ✔✔ text entry
built-in cell styles - Correct Answer ✔✔ predefined and named combinations of a cell
and content formatting properties
can you apply multiple cell styles in one cell - Correct Answer ✔✔ YES
determined by order of application
format painter - Correct Answer ✔✔ lets you copy the format of objects (text/pictures) to
other objects
4 conditional formats - Correct Answer ✔✔ data bars, highlights, color scales, icon sets
how many conditions can you format at one time? - Correct Answer ✔✔ 3 conditions
print preview - Correct Answer ✔✔ view of a document as it will appear when printed
page break preview - Correct Answer ✔✔ shades areas of worksheet that aren't
included in print area
print titles - Correct Answer ✔✔ titles included on each printed page
dotted line border - Correct Answer ✔✔ indicates page break
, insert page break - Correct Answer ✔✔ -click cell BELOW row you want to insert a
break
-page layout->setup group->breaks->insert page breaks
remove page break - Correct Answer ✔✔ page layout->page setup->breaks->remove
page break
dynamically linked charts - Correct Answer ✔✔ select chart title->type "=" in formula
bar-> select the cell you want to link with chart title
theme - Correct Answer ✔✔ -collection of fonts, styles, colors, and effects associated
with theme name
-enables you to create professional color coordinated documents quickly
default theme - Correct Answer ✔✔ -office theme
-theme that is automatically applied unless you specify otherwise
office theme - Correct Answer ✔✔ default theme
theme font - Correct Answer ✔✔ -font associated with particular theme
-automatically adjusts when changing theme
Do background images print by default? - Correct Answer ✔✔ NO
Do fill colors cover background images? - Correct Answer ✔✔ YES
background image - Correct Answer ✔✔ -does not have to match size of worksheet
-do not affect cell's format/content
bright fill colors - Correct Answer ✔✔ -used to highlight a value that requires attention
fill color - Correct Answer ✔✔ -background color of a cell
-muted or pastel
-used to band rows or columns & categorize information
theme colors - Correct Answer ✔✔ -12 colors of workbook theme
-each color has 5 variations
standard colors - Correct Answer ✔✔ 10 colors
sans serif font - Correct Answer ✔✔ no strokes at end of character
serif font - Correct Answer ✔✔ have extra strokes at the end of each character
