MISC 211 Final || Solved Correctly.
Use AutoSum to enter a formula in the selected cell to calculate the sum. correct answers On the
Home tab, In editing group, click the AutoSum button. Press Enter.
Cut cell B7 and paste it to cell E12 correct answers 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 correct answers 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. correct answers 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. correct answers 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 correct answers On the Home tab, in Cells
group, click the Insert button arrow, and select Insert Sheet.
Set row 1 to print on every page correct answers 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. correct
answers 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 correct answers
On the Home tab, in the Clipboard group, click the Format Painter button, Click cell E1.
,Print this worksheet. correct answers Click the File tab to open Backstage view. Click Print.
Click the Print button.
Wrap the text in the selected cell correct answers 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. correct answers
On the Home tab, in Font group, click the Boarders button arrow, and select Top and Bottom
Border.
Delete the Timesheets worksheet correct answers 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. correct answers On the Home tab, in the Font group,
click the Font Size arrow, and select 18.
Autofit column D to best fit the data correct answers Double-click the right column boundary for
column D.
Change the font for the selected cell to Cambria correct answers On the Home tab, in the Font
group, click the Font arrow, and select Cambria.
Print the entire workbook. correct answers 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 correct answers On the
Home tab, in the Alignment group, click the Marge & Center button.
Apply the Accent1 cell style to the selected cell. correct answers 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 correct answers
Click the Fill Handle tool in the selected cell and drag across to cell E6. Release the mouse
button.
Delete this row. correct answers 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. correct answers 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. correct answers On the Home tab, in
the Number group, click the Accounting Number Format button.
Hide the column showing 2016 data and the bonus rate. correct answers 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.
correct answers 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. correct
answers On the Page Layout tab, in the Page Set up group click the Breaks button. Click Insert
Page Break.
Select Column B correct answers Click the column selector at the top of column B
Select cells A5:D8 correct answers Click cell A5 and drag to cell D8. Release the mouse button.
, Cell F4 has been copied. Paste the formula only into the selected cell ( cell F5). Do not include
the cell formatting. correct answers Click the Paste button arrow, and then click the Formulas
button
Apply bold and italic formatting to the selected cell. correct answers 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. correct
answers 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. correct
answers Click the Review tab and click the Spelling button. click the Change All button. Click
OK.
Rename Sheet1: Dec 26 correct answers 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.
correct answers 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 correct answers 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. correct answers 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 correct answers Type 530. Press Enter
Use AutoSum to enter a formula in the selected cell to calculate the sum. correct answers On the
Home tab, In editing group, click the AutoSum button. Press Enter.
Cut cell B7 and paste it to cell E12 correct answers 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 correct answers 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. correct answers 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. correct answers 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 correct answers On the Home tab, in Cells
group, click the Insert button arrow, and select Insert Sheet.
Set row 1 to print on every page correct answers 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. correct
answers 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 correct answers
On the Home tab, in the Clipboard group, click the Format Painter button, Click cell E1.
,Print this worksheet. correct answers Click the File tab to open Backstage view. Click Print.
Click the Print button.
Wrap the text in the selected cell correct answers 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. correct answers
On the Home tab, in Font group, click the Boarders button arrow, and select Top and Bottom
Border.
Delete the Timesheets worksheet correct answers 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. correct answers On the Home tab, in the Font group,
click the Font Size arrow, and select 18.
Autofit column D to best fit the data correct answers Double-click the right column boundary for
column D.
Change the font for the selected cell to Cambria correct answers On the Home tab, in the Font
group, click the Font arrow, and select Cambria.
Print the entire workbook. correct answers 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 correct answers On the
Home tab, in the Alignment group, click the Marge & Center button.
Apply the Accent1 cell style to the selected cell. correct answers 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 correct answers
Click the Fill Handle tool in the selected cell and drag across to cell E6. Release the mouse
button.
Delete this row. correct answers 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. correct answers 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. correct answers On the Home tab, in
the Number group, click the Accounting Number Format button.
Hide the column showing 2016 data and the bonus rate. correct answers 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.
correct answers 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. correct
answers On the Page Layout tab, in the Page Set up group click the Breaks button. Click Insert
Page Break.
Select Column B correct answers Click the column selector at the top of column B
Select cells A5:D8 correct answers Click cell A5 and drag to cell D8. Release the mouse button.
, Cell F4 has been copied. Paste the formula only into the selected cell ( cell F5). Do not include
the cell formatting. correct answers Click the Paste button arrow, and then click the Formulas
button
Apply bold and italic formatting to the selected cell. correct answers 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. correct
answers 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. correct
answers Click the Review tab and click the Spelling button. click the Change All button. Click
OK.
Rename Sheet1: Dec 26 correct answers 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.
correct answers 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 correct answers 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. correct answers 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 correct answers Type 530. Press Enter
