BUS 1350 – Exam 1, Karen Leskoven, Baylor University, 2026 – Study guide and
practice material
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
practice material
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
