OL 211 FINAL PROJECT FULL SOLUTION 2026
QUESTIONS WITH ANSWERS GRADED A+
◉ Convert the cell range to a table using style... Answer: On the
Home tab, in the Styles group, click the Format as a Table button.
Click Table Style Light 8. Verify that the My table has headers
checkbox checked. Click OK.
◉ Insert a PivotChart using the first pie chart type. Answer: on the
PivotTable Tools Analyze tab, in the Tools group, click the PivoChart
button. Click Pie in the list of chart types at the left side of the Insert
chart dialog. Click OK.
◉ Add the Profit-Sharing field to the PivotTable. Answer: In the
PivotTable Fields pane, click the Profit-Sharing check box to add the
field to the Pivot Table.
◉ Refresh the PivotTable data Answer: On the PivotTable Tools
Analyze tab, in the Data group, click the Refresh button.
◉ Use the Flash Fill command to autofill the remaining cells..
Answer: On the Data tab, in the Data Tools group, click the Flash Fill
button.
,◉ Apply the light orange Pivot Style Medium 3 Quick Style... Answer:
On the PivotTable Tools Design tab, in the PivotTable Styles group,
click the More button to expand the Quick Styles gallery, and select
Pivot Style Medium 3. it is the third option in the first row under the
Medium styles.
◉ Use a custom text filter to show only rows where the expense
category... Answer: On the Data tab, in the Sort & Filter group, click
the Filter button to display the AutoFilter arrow at the top of the
Category column, and the point to Text Filters. Click Contains... Type
Server in the box next to contains. Click OK.
◉ Sort the data so cells with the red down arrow icon in the Cost
level... Answer: On the Data tab, in the Sort & Filter group, click the
Filter button to display the AutoFilter arrows at the top of each
column. Click the AutoFilter arrow at the top of the column. Point to
Sort by Color and click the red down arrow icon.
◉ Apply conditional formatting to the selected cells so cells with a
value greater... Answer: On the Home tab, in the Styles group, click
the Conditional Formatting button. Point to Highlight Cell Rules, and
click Greater than... Type 400 in the Format cells that are GREATER
THAN box. Expand the format selector box and select Light Red Fill.
Click OK.
,◉ Remove duplicate rows where data in all the columns are identical
Answer: Click the Table Tools Design tab. In the Tools group, click
the Remove Duplicates button. Click OK. Click OK.
◉ Create automatic subtotals to sum the cost for each change in the
Category... Answer: On the Data tab, in the Outline group, click the
Subtotal button. Expand the At each change in list and select
Category. Click OK.
◉ Apply conditional formatting to the selected cells using the red
gradient... Answer: On the Home tab, in the Styles group, click the
Conditional Formatting button. From the Menu, point to Data Bars,
in the Gradient Fill section, click Red Data Bar.
◉ Apply the Table Style Light 14 Quick Style... Answer: On the Table
Tools Design tab, in the Table Styles group, click the Quick Styles
button or click the More button to expand the Table Styles gallery.
Click Table Style Light 14.
◉ Add a total row to this table Answer: On the Table Tools Design
tab, in the table Style Options group, click the Total Row check box.
◉ Filter the Category column so only rows with Coffee are shown.
Answer: On the Home tab, In the Editing group, click the Sort and
Filter button and select Filter. Click the arrow at the top of the
, Category column. Click the (Select All) check box to remove all the
checkmarks. Click the check box in front of Coffee. Click OK.
◉ Convert the table to a normal range Answer: On the Table Tools
Design tab, Tools group, click the Convert to Range button. Click Yes.
◉ Apply conditional Formatting to the selected cells so cells with the
10 items... Answer: On the Home tab, in the Styles group , click the
Conditional Formatting button. Point to Top/Bottom Rules, and click
Bottom 10 Items. Expand the format selector box and select Green
FIll wth Dark green Text. Click OK.
◉ This worksheet is linked to an Access database. Update the
worksheet.. Answer: On the Table Tools Design tab, in the External
Table Data group, click the Refresh button.
◉ Rename Sheet1: Dec 26 Answer:
◉ Create a filter using the Custom Filter dialog to show only records
where the value in the CourseDescription field contains the word
Foundation. Answer: In the Access Table, you clicked the arrow at
the top of the CourseDescription column. In the Table Column Filter
Right-Click menu in the Text Filters menu, you clicked the Contains...
menu item. Inside the Custom Filter dialog, you typed Foundation in
the CourseDescription contains input, clicked the OK button.
QUESTIONS WITH ANSWERS GRADED A+
◉ Convert the cell range to a table using style... Answer: On the
Home tab, in the Styles group, click the Format as a Table button.
Click Table Style Light 8. Verify that the My table has headers
checkbox checked. Click OK.
◉ Insert a PivotChart using the first pie chart type. Answer: on the
PivotTable Tools Analyze tab, in the Tools group, click the PivoChart
button. Click Pie in the list of chart types at the left side of the Insert
chart dialog. Click OK.
◉ Add the Profit-Sharing field to the PivotTable. Answer: In the
PivotTable Fields pane, click the Profit-Sharing check box to add the
field to the Pivot Table.
◉ Refresh the PivotTable data Answer: On the PivotTable Tools
Analyze tab, in the Data group, click the Refresh button.
◉ Use the Flash Fill command to autofill the remaining cells..
Answer: On the Data tab, in the Data Tools group, click the Flash Fill
button.
,◉ Apply the light orange Pivot Style Medium 3 Quick Style... Answer:
On the PivotTable Tools Design tab, in the PivotTable Styles group,
click the More button to expand the Quick Styles gallery, and select
Pivot Style Medium 3. it is the third option in the first row under the
Medium styles.
◉ Use a custom text filter to show only rows where the expense
category... Answer: On the Data tab, in the Sort & Filter group, click
the Filter button to display the AutoFilter arrow at the top of the
Category column, and the point to Text Filters. Click Contains... Type
Server in the box next to contains. Click OK.
◉ Sort the data so cells with the red down arrow icon in the Cost
level... Answer: On the Data tab, in the Sort & Filter group, click the
Filter button to display the AutoFilter arrows at the top of each
column. Click the AutoFilter arrow at the top of the column. Point to
Sort by Color and click the red down arrow icon.
◉ Apply conditional formatting to the selected cells so cells with a
value greater... Answer: On the Home tab, in the Styles group, click
the Conditional Formatting button. Point to Highlight Cell Rules, and
click Greater than... Type 400 in the Format cells that are GREATER
THAN box. Expand the format selector box and select Light Red Fill.
Click OK.
,◉ Remove duplicate rows where data in all the columns are identical
Answer: Click the Table Tools Design tab. In the Tools group, click
the Remove Duplicates button. Click OK. Click OK.
◉ Create automatic subtotals to sum the cost for each change in the
Category... Answer: On the Data tab, in the Outline group, click the
Subtotal button. Expand the At each change in list and select
Category. Click OK.
◉ Apply conditional formatting to the selected cells using the red
gradient... Answer: On the Home tab, in the Styles group, click the
Conditional Formatting button. From the Menu, point to Data Bars,
in the Gradient Fill section, click Red Data Bar.
◉ Apply the Table Style Light 14 Quick Style... Answer: On the Table
Tools Design tab, in the Table Styles group, click the Quick Styles
button or click the More button to expand the Table Styles gallery.
Click Table Style Light 14.
◉ Add a total row to this table Answer: On the Table Tools Design
tab, in the table Style Options group, click the Total Row check box.
◉ Filter the Category column so only rows with Coffee are shown.
Answer: On the Home tab, In the Editing group, click the Sort and
Filter button and select Filter. Click the arrow at the top of the
, Category column. Click the (Select All) check box to remove all the
checkmarks. Click the check box in front of Coffee. Click OK.
◉ Convert the table to a normal range Answer: On the Table Tools
Design tab, Tools group, click the Convert to Range button. Click Yes.
◉ Apply conditional Formatting to the selected cells so cells with the
10 items... Answer: On the Home tab, in the Styles group , click the
Conditional Formatting button. Point to Top/Bottom Rules, and click
Bottom 10 Items. Expand the format selector box and select Green
FIll wth Dark green Text. Click OK.
◉ This worksheet is linked to an Access database. Update the
worksheet.. Answer: On the Table Tools Design tab, in the External
Table Data group, click the Refresh button.
◉ Rename Sheet1: Dec 26 Answer:
◉ Create a filter using the Custom Filter dialog to show only records
where the value in the CourseDescription field contains the word
Foundation. Answer: In the Access Table, you clicked the arrow at
the top of the CourseDescription column. In the Table Column Filter
Right-Click menu in the Text Filters menu, you clicked the Contains...
menu item. Inside the Custom Filter dialog, you typed Foundation in
the CourseDescription contains input, clicked the OK button.
