BUS 110 Exam 2 2026 Questions and
Answers
If you delete a worksheet, you can undo the action. - Correct answer-FALSE
To group worksheets that are not next to each other, select the first worksheet and
press the ____________ key, and then click the other sheet tabs you want included
in the group. - Correct answer-CTRL
A __________________ is a unified color, font, and effects scheme you apply to a
workbook. - Correct answer-theme
To keep column headings as you scroll through a large spreadsheet you should use
the ___________________ command. - Correct answer-Freeze First Column
When you hide a row or column, the data remain in your workbook. They are no
longer displayed on-screen but will be part of the printed workbook. - Correct
answer-false
To display a worksheet in two or four panes, you should use the
________________ worksheet. - Correct answer-split
©COPYRIGHT 2025, ALL RIGHTS RESERVED 1
, A _______________ is text that appears at the bottom of every page just above the
margin. - Correct answer-Footer
__________________ are the numbers at the left of rows and the letters at the top
of columns. - Correct answer-Headings
If your worksheet is wide, you may want to use portrait orientation where the
height of the page is greater than the width. - Correct answer-True
If you want more or less white space around your worksheet area when printing,
you should adjust the: - Correct answer-Margins
Data markers are graphic representations of the values of data points in a chart. -
Correct answer-true
___________________ charts represent data as parts of a whole. - Correct answer-
Pie
___________________ apply combinations of fonts, line styles, fills, and shape
effects to charts. - Correct answer-Quick Styles
_________________ represent each data series as an individual graphic within a
single cell. - Correct answer-Sparklines
©COPYRIGHT 2025, ALL RIGHTS RESERVED 2
Answers
If you delete a worksheet, you can undo the action. - Correct answer-FALSE
To group worksheets that are not next to each other, select the first worksheet and
press the ____________ key, and then click the other sheet tabs you want included
in the group. - Correct answer-CTRL
A __________________ is a unified color, font, and effects scheme you apply to a
workbook. - Correct answer-theme
To keep column headings as you scroll through a large spreadsheet you should use
the ___________________ command. - Correct answer-Freeze First Column
When you hide a row or column, the data remain in your workbook. They are no
longer displayed on-screen but will be part of the printed workbook. - Correct
answer-false
To display a worksheet in two or four panes, you should use the
________________ worksheet. - Correct answer-split
©COPYRIGHT 2025, ALL RIGHTS RESERVED 1
, A _______________ is text that appears at the bottom of every page just above the
margin. - Correct answer-Footer
__________________ are the numbers at the left of rows and the letters at the top
of columns. - Correct answer-Headings
If your worksheet is wide, you may want to use portrait orientation where the
height of the page is greater than the width. - Correct answer-True
If you want more or less white space around your worksheet area when printing,
you should adjust the: - Correct answer-Margins
Data markers are graphic representations of the values of data points in a chart. -
Correct answer-true
___________________ charts represent data as parts of a whole. - Correct answer-
Pie
___________________ apply combinations of fonts, line styles, fills, and shape
effects to charts. - Correct answer-Quick Styles
_________________ represent each data series as an individual graphic within a
single cell. - Correct answer-Sparklines
©COPYRIGHT 2025, ALL RIGHTS RESERVED 2
