BUS 1350 – MindTap Final, 2026 – Study guide and practice material
Enter a formula using arithmetic operators and parentheses in cell B14 that adds the monthly
expenses in cells B9, B10, and B11, and then multiplies that result by 12. - correct answer ✔✔ in
cell B14 enter: =(B9+B10+B11)*12
In cell E5, create a formula using the VLOOKUP function to determine the bonus percentage for
employee _ based on the performance rating in cell C5. Use range G4:H10 as the lookup table,
and the bonus percentage listed in column 2 of the lookup table. Do not enter a value for the
optional range_lookup argument. - correct answer ✔✔ In cell E5, type: =VLOOKUP
(C5,G4:H10,2)
Wrap the text in cell A6 so that all the text is visible in the cell. - correct answer ✔✔ Select cell
A6, Home tab, Alignment Group, Select Wrap Text.
Split the Worksheet into four panes at cell B12. - correct answer ✔✔ Click Cell B12
Click View at Top
Click Split
Freeze Column A and rows 1 through 3 in the worksheet - correct answer ✔✔ Click B4
View tab
Freeze Panes --> Freeze panes
Apply the 03/14/12 Date number format to cell D4 - correct answer ✔✔ Select D4.
In the number group of the ribbon click the drop down arrow on number format.
More Number formats.
Select 03/14/12.
, Save the current workbook to the Financials folder (Documents> Financials); do not change the
workbook name. - correct answer ✔✔ File tab
Save as
Browse
Double click Financials folder
Save
Insert a 3-D Pie chart into the worksheet, based on range A5:B16. - correct answer ✔✔ Select
Range A5:B16
Insert
Pie chart drop down
3-D Pie
Find and Replace all instances of the word Mgr with the word Manager in the cuurent
worksheet. - correct answer ✔✔ Editing Group
Find & Select
Replace
Insert find and replace arguments
Replace all.
close
Add the sheet name header element the center header section and add the text "Last Viewed_"
followed by the current date header element to the right header section. Click cell A4 to
deselect the header when you are finished. - correct answer ✔✔ On status bar (bottom right)
Click the page layout button.
Select center section of header.
Click the Header & Footer tab.
In element group, click sheet name button.
Enter a formula using arithmetic operators and parentheses in cell B14 that adds the monthly
expenses in cells B9, B10, and B11, and then multiplies that result by 12. - correct answer ✔✔ in
cell B14 enter: =(B9+B10+B11)*12
In cell E5, create a formula using the VLOOKUP function to determine the bonus percentage for
employee _ based on the performance rating in cell C5. Use range G4:H10 as the lookup table,
and the bonus percentage listed in column 2 of the lookup table. Do not enter a value for the
optional range_lookup argument. - correct answer ✔✔ In cell E5, type: =VLOOKUP
(C5,G4:H10,2)
Wrap the text in cell A6 so that all the text is visible in the cell. - correct answer ✔✔ Select cell
A6, Home tab, Alignment Group, Select Wrap Text.
Split the Worksheet into four panes at cell B12. - correct answer ✔✔ Click Cell B12
Click View at Top
Click Split
Freeze Column A and rows 1 through 3 in the worksheet - correct answer ✔✔ Click B4
View tab
Freeze Panes --> Freeze panes
Apply the 03/14/12 Date number format to cell D4 - correct answer ✔✔ Select D4.
In the number group of the ribbon click the drop down arrow on number format.
More Number formats.
Select 03/14/12.
, Save the current workbook to the Financials folder (Documents> Financials); do not change the
workbook name. - correct answer ✔✔ File tab
Save as
Browse
Double click Financials folder
Save
Insert a 3-D Pie chart into the worksheet, based on range A5:B16. - correct answer ✔✔ Select
Range A5:B16
Insert
Pie chart drop down
3-D Pie
Find and Replace all instances of the word Mgr with the word Manager in the cuurent
worksheet. - correct answer ✔✔ Editing Group
Find & Select
Replace
Insert find and replace arguments
Replace all.
close
Add the sheet name header element the center header section and add the text "Last Viewed_"
followed by the current date header element to the right header section. Click cell A4 to
deselect the header when you are finished. - correct answer ✔✔ On status bar (bottom right)
Click the page layout button.
Select center section of header.
Click the Header & Footer tab.
In element group, click sheet name button.
