MISC 211 Final Exam (MISC 211) – 350+ Excel & Access Tasks, Formulas, PivotTables & Reports | 2026

MISC 211 Final 2026 Expert
Verified | Ace the Test




Use AutoSum to enter a formula in the selected cell to calculate the sum. -

🧠 ANSWER ✔✔On the Home tab, In editing group, click the AutoSum

button. Press Enter.


Cut cell B7 and paste it to cell E12 - 🧠 ANSWER ✔✔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 - 🧠 ANSWER ✔✔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. -

🧠 ANSWER ✔✔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. - 🧠 ANSWER ✔✔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 - 🧠 ANSWER ✔✔On

the Home tab, in Cells group, click the Insert button arrow, and select Insert

Sheet.


Set row 1 to print on every page - 🧠 ANSWER ✔✔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.

,Without adjusting the column widths, guarantee that all columns will print

on one page. - 🧠 ANSWER ✔✔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 - 🧠 ANSWER ✔✔On the Home tab, in the Clipboard group, click the

Format Painter button, Click cell E1.


Print this worksheet. - 🧠 ANSWER ✔✔Click the File tab to open Backstage

view. Click Print. Click the Print button.


Wrap the text in the selected cell - 🧠 ANSWER ✔✔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. - 🧠 ANSWER ✔✔On the Home tab, in Font group, click the

Boarders button arrow, and select Top and Bottom Border.


Delete the Timesheets worksheet - 🧠 ANSWER ✔✔On the Home tab, in the

Cells group, click the Delete button arrow, select Delete Sheet. Click

Delete.




COPYRIGHT©PROFFKERRYMARTIN 2025/2026. YEAR PUBLISHED 2026. COMPANY REGISTRATION NUMBER: 619652435. TERMS OF USE.
PRIVACY STATEMENT. ALL RIGHTS RESERVED

, Change font size for the selected cells to 18. - 🧠 ANSWER ✔✔On the

Home tab, in the Font group, click the Font Size arrow, and select 18.


Autofit column D to best fit the data - 🧠 ANSWER ✔✔Double-click the right

column boundary for column D.


Change the font for the selected cell to Cambria - 🧠 ANSWER ✔✔On the

Home tab, in the Font group, click the Font arrow, and select Cambria.


Print the entire workbook. - 🧠 ANSWER ✔✔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 - 🧠

ANSWER ✔✔On the Home tab, in the Alignment group, click the Marge &

Center button.


Apply the Accent1 cell style to the selected cell. - 🧠 ANSWER ✔✔On the

Home tab, in the Styles group, click the Cell Styles button. Click the

Accent1 style.