MISC 211 FINAL EXAM QUESTIONS AND
ANSWERS GRADED A+ 2025/2026
Use AutoSum to enter a formula in the selected cell to calculate the sum. - ANS On the Home
tab, In editing group, click the AutoSum button. Press Enter.
Cut cell B7 and paste it to cell E12 - ANS On the Home tab, in the clipboard group on the
Home tab, click the cut button. Click cell E12, and click the paste button.
Enter a formula in the selected cell using the SUM function to calculate the total of cells B2
through B6 - ANS Type the formulas =SUM(B2:B6) in the cell or the formula bar and press
Enter.
Change the font color of the selected cells to the Blue-Gray, Text 2 color. - ANS On the Home
tab, in the Font group, click the Font Color arrow, and select Blue_Gray Text 2
Set the print area so only the selected cells will print. - ANS Click the Back button. On the
page Layout tab, in the Page Setup group, click the Print Area button. Click Set Print Area.
Add a new worksheet to the left of the Dec. 18 sheet - ANS On the Home tab, in Cells group,
click the Insert button arrow, and select Insert Sheet.
Set row 1 to print on every page - ANS On the Page Layout tab, in the Page Setup group, click
the Print Titles button. In the Page Setup dialog, on the Sheet tab, click the Rows to repeat at
the top box. Click the row selector for row 1. click OK in the dialog.
1 @COPYRIGHT 2025/2026 ALLRIGHTS RESERVED.
,Without adjusting the column widths, guarantee that all columns will print on one page. -
ANS On Page Layout tab, in the scale to fit group, click the width arrow. click 1 page.
Use Format Painter to copy the formatting from cell D1 and apply it to cell E1 - ANS On the
Home tab, in the Clipboard group, click the Format Painter button, Click cell E1.
Print this worksheet. - ANS Click the File tab to open Backstage view. Click Print. Click the
Print button.
Wrap the text in the selected cell - ANS On the Home tab, in the alignment group, click the
Wrap Text button.
Apply the Top and Bottom Border to the selected cells with a single command. - ANS On the
Home tab, in Font group, click the Boarders button arrow, and select Top and Bottom Border.
Delete the Timesheets worksheet - ANS On the Home tab, in the Cells group, click the Delete
button arrow, select Delete Sheet. Click Delete.
Change font size for the selected cells to 18. - ANS On the Home tab, in the Font group, click
the Font Size arrow, and select 18.
Autofit column D to best fit the data - ANS Double-click the right column boundary for
column D.
Change the font for the selected cell to Cambria - ANS On the Home tab, in the Font group,
click the Font arrow, and select Cambria.
Print the entire workbook. - ANS Click the File tab to open Backstage. Click Print. Click the
Print Active Sheets button. Click Print Entire Workbook. Click the Print button.
Merge the cells so the text appears centered across the merged cells - ANS On the Home tab,
in the Alignment group, click the Marge & Center button.
2 @COPYRIGHT 2025/2026 ALLRIGHTS RESERVED.
,Apply the Accent1 cell style to the selected cell. - ANS On the Home tab, in the Styles group,
click the Cell Styles button. Click the Accent1 style.
Use AutoFill to copy the formula and the formatting in cell E2 to cels E3:E6 - ANS Click the Fill
Handle tool in the selected cell and drag across to cell E6. Release the mouse button.
Delete this row. - ANS On the Home tab, in the Cells group, click the Delete button arrow and
select Delete
Add a footer that displays the page number in the center section. - ANS On the Header &
Footer Tools Design tab, in the Header and Footer Elements group, click the Page Number
button.
Apply the Accounting Number Format to the selected cells. - ANS On the Home tab, in the
Number group, click the Accounting Number Format button.
Hide the column showing 2016 data and the bonus rate. - ANS Click the column selector for
Column B. On the Home tab, in the Cells group, click the Format button. Point to Hide & Unhide,
and click Hide Columns.
Modify the worksheet so the first row is always visible when you scroll the worksheet down. -
ANS On the View tab, in the Windows group, click the Freeze Panes button. Click Freeze top
Row.
From Page Break Preview view, insert a page break immediately above the selected cell. -
ANS On the Page Layout tab, in the Page Set up group click the Breaks button. Click Insert
Page Break.
Select Column B - ANS Click the column selector at the top of column B
Select cells A5:D8 - ANS Click cell A5 and drag to cell D8. Release the mouse button.
3 @COPYRIGHT 2025/2026 ALLRIGHTS RESERVED.
, Cell F4 has been copied. Paste the formula only into the selected cell ( cell F5). Do not include
the cell formatting. - ANS Click the Paste button arrow, and then click the Formulas button
Apply bold and italic formatting to the selected cell. - ANS On the Home tab in the Font
group, click the Bold button and the italic button.
Modify the number format do no decimal places are visible after the decimal point. - ANS On
the Home tab, in the Number group, click the Decrease Decimal button twice.
Use the spelling checker to find and change all instances of any misspelled words. - ANS Click
the Review tab and click the Spelling button. click the Change All button. Click OK.
Rename Sheet1: Dec 26 - ANS Right-click the sheet1 worksheet tab, and click Rename. Type
Dec 26 and press enter
Arrange all open workbooks in a single window so the overlap in a staggered, diagonal pattern. -
ANS Click the View tab, In the Window group, click the Arrange All button. Select the Cascade
option. Click OK.
Add a Blue, Accent 5.. bottom border to the selected cells. Use the thickest single line style
available - ANS On the Home tab, in the Font group, click the Boarders button arrow, and
select More Borders... In the Format Cells dialog. Border tab, click the thickest line available in
the style section. Expand the Color palette and select Blue, Accent 5. In the border section, click
the button representing a bottom border.
Insert a column to the left of the selected cell. - ANS On the Home tab, in the Cells group,
click the Insert button arrow and select Insert Sheet Column.
Enter the number 530 in cell C7 - ANS Type 530. Press Enter
4 @COPYRIGHT 2025/2026 ALLRIGHTS RESERVED.
ANSWERS GRADED A+ 2025/2026
Use AutoSum to enter a formula in the selected cell to calculate the sum. - ANS On the Home
tab, In editing group, click the AutoSum button. Press Enter.
Cut cell B7 and paste it to cell E12 - ANS On the Home tab, in the clipboard group on the
Home tab, click the cut button. Click cell E12, and click the paste button.
Enter a formula in the selected cell using the SUM function to calculate the total of cells B2
through B6 - ANS Type the formulas =SUM(B2:B6) in the cell or the formula bar and press
Enter.
Change the font color of the selected cells to the Blue-Gray, Text 2 color. - ANS On the Home
tab, in the Font group, click the Font Color arrow, and select Blue_Gray Text 2
Set the print area so only the selected cells will print. - ANS Click the Back button. On the
page Layout tab, in the Page Setup group, click the Print Area button. Click Set Print Area.
Add a new worksheet to the left of the Dec. 18 sheet - ANS On the Home tab, in Cells group,
click the Insert button arrow, and select Insert Sheet.
Set row 1 to print on every page - ANS On the Page Layout tab, in the Page Setup group, click
the Print Titles button. In the Page Setup dialog, on the Sheet tab, click the Rows to repeat at
the top box. Click the row selector for row 1. click OK in the dialog.
1 @COPYRIGHT 2025/2026 ALLRIGHTS RESERVED.
,Without adjusting the column widths, guarantee that all columns will print on one page. -
ANS On Page Layout tab, in the scale to fit group, click the width arrow. click 1 page.
Use Format Painter to copy the formatting from cell D1 and apply it to cell E1 - ANS On the
Home tab, in the Clipboard group, click the Format Painter button, Click cell E1.
Print this worksheet. - ANS Click the File tab to open Backstage view. Click Print. Click the
Print button.
Wrap the text in the selected cell - ANS On the Home tab, in the alignment group, click the
Wrap Text button.
Apply the Top and Bottom Border to the selected cells with a single command. - ANS On the
Home tab, in Font group, click the Boarders button arrow, and select Top and Bottom Border.
Delete the Timesheets worksheet - ANS On the Home tab, in the Cells group, click the Delete
button arrow, select Delete Sheet. Click Delete.
Change font size for the selected cells to 18. - ANS On the Home tab, in the Font group, click
the Font Size arrow, and select 18.
Autofit column D to best fit the data - ANS Double-click the right column boundary for
column D.
Change the font for the selected cell to Cambria - ANS On the Home tab, in the Font group,
click the Font arrow, and select Cambria.
Print the entire workbook. - ANS Click the File tab to open Backstage. Click Print. Click the
Print Active Sheets button. Click Print Entire Workbook. Click the Print button.
Merge the cells so the text appears centered across the merged cells - ANS On the Home tab,
in the Alignment group, click the Marge & Center button.
2 @COPYRIGHT 2025/2026 ALLRIGHTS RESERVED.
,Apply the Accent1 cell style to the selected cell. - ANS On the Home tab, in the Styles group,
click the Cell Styles button. Click the Accent1 style.
Use AutoFill to copy the formula and the formatting in cell E2 to cels E3:E6 - ANS Click the Fill
Handle tool in the selected cell and drag across to cell E6. Release the mouse button.
Delete this row. - ANS On the Home tab, in the Cells group, click the Delete button arrow and
select Delete
Add a footer that displays the page number in the center section. - ANS On the Header &
Footer Tools Design tab, in the Header and Footer Elements group, click the Page Number
button.
Apply the Accounting Number Format to the selected cells. - ANS On the Home tab, in the
Number group, click the Accounting Number Format button.
Hide the column showing 2016 data and the bonus rate. - ANS Click the column selector for
Column B. On the Home tab, in the Cells group, click the Format button. Point to Hide & Unhide,
and click Hide Columns.
Modify the worksheet so the first row is always visible when you scroll the worksheet down. -
ANS On the View tab, in the Windows group, click the Freeze Panes button. Click Freeze top
Row.
From Page Break Preview view, insert a page break immediately above the selected cell. -
ANS On the Page Layout tab, in the Page Set up group click the Breaks button. Click Insert
Page Break.
Select Column B - ANS Click the column selector at the top of column B
Select cells A5:D8 - ANS Click cell A5 and drag to cell D8. Release the mouse button.
3 @COPYRIGHT 2025/2026 ALLRIGHTS RESERVED.
, Cell F4 has been copied. Paste the formula only into the selected cell ( cell F5). Do not include
the cell formatting. - ANS Click the Paste button arrow, and then click the Formulas button
Apply bold and italic formatting to the selected cell. - ANS On the Home tab in the Font
group, click the Bold button and the italic button.
Modify the number format do no decimal places are visible after the decimal point. - ANS On
the Home tab, in the Number group, click the Decrease Decimal button twice.
Use the spelling checker to find and change all instances of any misspelled words. - ANS Click
the Review tab and click the Spelling button. click the Change All button. Click OK.
Rename Sheet1: Dec 26 - ANS Right-click the sheet1 worksheet tab, and click Rename. Type
Dec 26 and press enter
Arrange all open workbooks in a single window so the overlap in a staggered, diagonal pattern. -
ANS Click the View tab, In the Window group, click the Arrange All button. Select the Cascade
option. Click OK.
Add a Blue, Accent 5.. bottom border to the selected cells. Use the thickest single line style
available - ANS On the Home tab, in the Font group, click the Boarders button arrow, and
select More Borders... In the Format Cells dialog. Border tab, click the thickest line available in
the style section. Expand the Color palette and select Blue, Accent 5. In the border section, click
the button representing a bottom border.
Insert a column to the left of the selected cell. - ANS On the Home tab, in the Cells group,
click the Insert button arrow and select Insert Sheet Column.
Enter the number 530 in cell C7 - ANS Type 530. Press Enter
4 @COPYRIGHT 2025/2026 ALLRIGHTS RESERVED.
