OL 211 FINAL PROJECT EXAM SCRIPT 2026
QUESTIONS WITH SOLUTIONS GRADED A+
◉ Rename Sheet1: Dec 26 Answer: 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. Answer: 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 Answer: 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. Answer: 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 Answer: Type 530. Press Enter
,◉ Move Salaries worksheet so it is positioned before the working
data worksheet Answer: Click the Salaries worksheet tab and hold
down the left mouse button. Drag the mouse pointer to a point just
in front of the Working Data worksheet tab, and release the mouse
button.
◉ Use a single command to clear everything from the selected cell.
Answer: On the Home tab, in the Editing group, click the Clear
button. Select Clear All.
◉ Center the content in the selected cells horizontally. Answer: You
answered the question correctly. Click "OK" to continue.
◉ This workbook will be used by people with Excel 2003 only. Save
it in the best format for those users. Allow the compatibility issues.
Answer: Click the File tab. Click Save As. On the Save As page, click
the Save as type arrow and select Excel 97-2003 Workbook (*.xls).
Click Save. Click continue.
◉ Change the color of the sheet tab for the Dec 18 worksheet to
Green, Accent 6, Lighter 80% Answer: Right-click the worksheet tab
and point to Tab Color. Click Green, Accent 6, Lighter 80%
,◉ Copy cell F3 , and paste to cell F2 Answer: On the Home tab, in the
clipboard group, click the Copy button. Click cell F2, and click the
Paste button.
◉ Apply the Ion theme to the worksheet. Answer: On the Page
Layout tab, in the Themes group, click the Themes button. Click the
Ion theme.
◉ Clear the print area Answer: On the Page Layout tab, in the Page
Setup group, click the Print Area button. Click Clear Print Area.
◉ Modify the Dec 18 worksheet so gridlines will print Answer: On
the Page Layout tab, in the Sheet Options group, click the Print check
box under Gridlines
◉ Modify this worksheet so you see four different areas of the
worksheet at the same time and scroll each area independently of
the others. Answer: On the View tab, in the Window group, click the
Split button.
◉ Switch the view that shows all the worksheet elements as they
will print, including headers and footers. Answer: Click the Page
Layout button at the lower right corner of the status bar, to the left of
the zoom slider.
, ◉ Change the zoom level for the worksheet to be 110% Answer:
Click the Zoom In bottom on the zoom slider
◉ Add an element to the center section of the header to display the
current date. Answer: Click the Page Layout button on the status bar.
Click in the center section of the header area above the worksheet
grid. On the Header and Footer Tools Design tab, In the Header &
Footer Elements group, click the Current Date button.
◉ Apply the present margin option that will add the least amount of
white space around the edges of the printed page Answer: On the
Page Layout tab, in the Page Setup group, click the Margins button.
Click Narrow.
◉ Change the width of the selected columns to 14 Answer: On the
Home tab, in the Cells group, click the Format button. select Column
width... Type 14, and click OK.
◉ There is an error in cell D6. Accept Excel's suggestion for fixing
the error. Answer: Click cell D6. Click the Smart Tag. Click Copy
Formula from Above.
◉ Show the tracer arrows from the precedent cells to cell B5
Answer: On the Formulas tab, in the Formula Auditing group, click
the Trace Precedents button.
QUESTIONS WITH SOLUTIONS GRADED A+
◉ Rename Sheet1: Dec 26 Answer: 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. Answer: 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 Answer: 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. Answer: 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 Answer: Type 530. Press Enter
,◉ Move Salaries worksheet so it is positioned before the working
data worksheet Answer: Click the Salaries worksheet tab and hold
down the left mouse button. Drag the mouse pointer to a point just
in front of the Working Data worksheet tab, and release the mouse
button.
◉ Use a single command to clear everything from the selected cell.
Answer: On the Home tab, in the Editing group, click the Clear
button. Select Clear All.
◉ Center the content in the selected cells horizontally. Answer: You
answered the question correctly. Click "OK" to continue.
◉ This workbook will be used by people with Excel 2003 only. Save
it in the best format for those users. Allow the compatibility issues.
Answer: Click the File tab. Click Save As. On the Save As page, click
the Save as type arrow and select Excel 97-2003 Workbook (*.xls).
Click Save. Click continue.
◉ Change the color of the sheet tab for the Dec 18 worksheet to
Green, Accent 6, Lighter 80% Answer: Right-click the worksheet tab
and point to Tab Color. Click Green, Accent 6, Lighter 80%
,◉ Copy cell F3 , and paste to cell F2 Answer: On the Home tab, in the
clipboard group, click the Copy button. Click cell F2, and click the
Paste button.
◉ Apply the Ion theme to the worksheet. Answer: On the Page
Layout tab, in the Themes group, click the Themes button. Click the
Ion theme.
◉ Clear the print area Answer: On the Page Layout tab, in the Page
Setup group, click the Print Area button. Click Clear Print Area.
◉ Modify the Dec 18 worksheet so gridlines will print Answer: On
the Page Layout tab, in the Sheet Options group, click the Print check
box under Gridlines
◉ Modify this worksheet so you see four different areas of the
worksheet at the same time and scroll each area independently of
the others. Answer: On the View tab, in the Window group, click the
Split button.
◉ Switch the view that shows all the worksheet elements as they
will print, including headers and footers. Answer: Click the Page
Layout button at the lower right corner of the status bar, to the left of
the zoom slider.
, ◉ Change the zoom level for the worksheet to be 110% Answer:
Click the Zoom In bottom on the zoom slider
◉ Add an element to the center section of the header to display the
current date. Answer: Click the Page Layout button on the status bar.
Click in the center section of the header area above the worksheet
grid. On the Header and Footer Tools Design tab, In the Header &
Footer Elements group, click the Current Date button.
◉ Apply the present margin option that will add the least amount of
white space around the edges of the printed page Answer: On the
Page Layout tab, in the Page Setup group, click the Margins button.
Click Narrow.
◉ Change the width of the selected columns to 14 Answer: On the
Home tab, in the Cells group, click the Format button. select Column
width... Type 14, and click OK.
◉ There is an error in cell D6. Accept Excel's suggestion for fixing
the error. Answer: Click cell D6. Click the Smart Tag. Click Copy
Formula from Above.
◉ Show the tracer arrows from the precedent cells to cell B5
Answer: On the Formulas tab, in the Formula Auditing group, click
the Trace Precedents button.
