BUS 1350-09 – Exam Reviews, 2026 – Comprehensive study and practice
material
T or F: When you print in portrait orientation, the page is wider than it is tall. - correct answer
✔✔ False
T or F: A good practice is to move the documentation and overview worksheets to the end of
the workbook. - correct answer ✔✔ False
T or F: You can set a scaling option to resize a worksheet to fit within a single page. - correct
answer ✔✔ True
T or F: You can edit a cell's contents in the formula bar or in the cell itself. - correct answer ✔✔
True
T or F: To enter a typed number into a cell, you can press TAB or BACKSPACE. - correct answer
✔✔ False
T or F: To increase the magnification of a worksheet from 100% to 120%, you use the
Magnification slider. - correct answer ✔✔ False
Which word or phrase best describes A6:A9 in the formula =SUM(A6:A9)? - correct answer ✔✔
Argument
Which of the following actions allows you to edit the contents of a cell? - correct answer ✔✔
Double-click the cell
Which of the following views shows how a worksheet will appear when printed? - correct
answer ✔✔ Page Layout
,Which of the following formulas most efficiently adds the values from cells B6, B7, B8, B9, and
B10?
=TOTAL(B6-B10)
=COUNT(B6+B7+B8+B9+B10)
=SUM(B6:B10)
=SUM(B6+B10) - correct answer ✔✔ =SUM(B6:B10)
When you click the File tab and then click Print, which of the following elements appears in the
preview of the printout of the worksheet in Backstage view?
Worksheet data
Row Headings
Gridlines
Column Headings - correct answer ✔✔ Worksheet Data
If you discover an error immediately after you have confirmed a cell entry, which of the
following could you do to reverse the error? Select all the options that apply.
Click the Undo button on the Home tab of the ribbon.
Click the Cancel button on the Formula bar.
Press CTRL+Y.
Press CTRL+Z. - correct answer ✔✔ Click the Undo button on the Home tab of the ribbon.
Press CTRL+Z.
T or F: Currency is an example of a number format. - correct answer ✔✔ True
A theme is a predefined, coordinated set of colors, fonts, and graphical effects. - correct answer
✔✔ True
, T or F: To change the background color of a cell, you use the Background color button. - correct
answer ✔✔ False
To format the cell value 44.54 as 44.540, you can use the Increase Decimal button. - correct
answer ✔✔ True
T or F: You use conditional formatting to format a cell based on its value. - correct answer ✔✔
True
By default, the Percent style formats numbers as percentages with _____ decimal places. -
correct answer ✔✔ Zero
To help you easily identify sheets in a workbook, you can add _____ to the sheet tabs. - correct
answer ✔✔ Color
What Excel feature can you use to format a range so that all values greater than $500
automatically appear in red? - correct answer ✔✔ Conditional Formatting
How can you change conditional formatting that applies a red fill color so that it applies a green
fill color instead? - correct answer ✔✔ Edit the conditional formatting rule
Which of the following choices are options for aligning cell contents in relation to cell edges?
Select all the options that apply.
Outside
Left
Inside
Center - correct answer ✔✔ Left and Center
material
T or F: When you print in portrait orientation, the page is wider than it is tall. - correct answer
✔✔ False
T or F: A good practice is to move the documentation and overview worksheets to the end of
the workbook. - correct answer ✔✔ False
T or F: You can set a scaling option to resize a worksheet to fit within a single page. - correct
answer ✔✔ True
T or F: You can edit a cell's contents in the formula bar or in the cell itself. - correct answer ✔✔
True
T or F: To enter a typed number into a cell, you can press TAB or BACKSPACE. - correct answer
✔✔ False
T or F: To increase the magnification of a worksheet from 100% to 120%, you use the
Magnification slider. - correct answer ✔✔ False
Which word or phrase best describes A6:A9 in the formula =SUM(A6:A9)? - correct answer ✔✔
Argument
Which of the following actions allows you to edit the contents of a cell? - correct answer ✔✔
Double-click the cell
Which of the following views shows how a worksheet will appear when printed? - correct
answer ✔✔ Page Layout
,Which of the following formulas most efficiently adds the values from cells B6, B7, B8, B9, and
B10?
=TOTAL(B6-B10)
=COUNT(B6+B7+B8+B9+B10)
=SUM(B6:B10)
=SUM(B6+B10) - correct answer ✔✔ =SUM(B6:B10)
When you click the File tab and then click Print, which of the following elements appears in the
preview of the printout of the worksheet in Backstage view?
Worksheet data
Row Headings
Gridlines
Column Headings - correct answer ✔✔ Worksheet Data
If you discover an error immediately after you have confirmed a cell entry, which of the
following could you do to reverse the error? Select all the options that apply.
Click the Undo button on the Home tab of the ribbon.
Click the Cancel button on the Formula bar.
Press CTRL+Y.
Press CTRL+Z. - correct answer ✔✔ Click the Undo button on the Home tab of the ribbon.
Press CTRL+Z.
T or F: Currency is an example of a number format. - correct answer ✔✔ True
A theme is a predefined, coordinated set of colors, fonts, and graphical effects. - correct answer
✔✔ True
, T or F: To change the background color of a cell, you use the Background color button. - correct
answer ✔✔ False
To format the cell value 44.54 as 44.540, you can use the Increase Decimal button. - correct
answer ✔✔ True
T or F: You use conditional formatting to format a cell based on its value. - correct answer ✔✔
True
By default, the Percent style formats numbers as percentages with _____ decimal places. -
correct answer ✔✔ Zero
To help you easily identify sheets in a workbook, you can add _____ to the sheet tabs. - correct
answer ✔✔ Color
What Excel feature can you use to format a range so that all values greater than $500
automatically appear in red? - correct answer ✔✔ Conditional Formatting
How can you change conditional formatting that applies a red fill color so that it applies a green
fill color instead? - correct answer ✔✔ Edit the conditional formatting rule
Which of the following choices are options for aligning cell contents in relation to cell edges?
Select all the options that apply.
Outside
Left
Inside
Center - correct answer ✔✔ Left and Center
