OL 211 FINAL PROJECT FINAL PAPER 2026
QUESTIONS WITH ANSWERS GRADED A+
◉ 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.
◉ 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.
, ◉ Use AutoFill to copy the formula and the formatting in cell E2 to
cels E3:E6 Answer: Click the Fill Handle tool in the selected cell and
drag across to cell E6. Release the mouse button.
◉ Delete this row. Answer: 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.
Answer: 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.
Answer: On the Home tab, in the Number group, click the
Accounting Number Format button.
◉ Hide the column showing 2016 data and the bonus rate. Answer:
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. Answer: On the View tab, in the
Windows group, click the Freeze Panes button. Click Freeze top Row.
QUESTIONS WITH ANSWERS GRADED A+
◉ 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.
◉ 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.
, ◉ Use AutoFill to copy the formula and the formatting in cell E2 to
cels E3:E6 Answer: Click the Fill Handle tool in the selected cell and
drag across to cell E6. Release the mouse button.
◉ Delete this row. Answer: 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.
Answer: 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.
Answer: On the Home tab, in the Number group, click the
Accounting Number Format button.
◉ Hide the column showing 2016 data and the bonus rate. Answer:
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. Answer: On the View tab, in the
Windows group, click the Freeze Panes button. Click Freeze top Row.
