BA CERTIFICATION EXAM STUDY GUIDE
In cell H5, enter a formula referencing the named ranges Price_10G, Install_10G, and
Support_10G to display the total sum value of the 10 Gbps Routers. - Answer -*Click
cell H5.
*In the Formula Bar, type *=SUM(Price_10G,Install_10G,Support_10G).
*Press Enter on your keyboard to commit the formula.
Remove all conditional formatting on the worksheet. - Answer -*On the Home tab, in
the Styles group, click Conditional Formatting.
*Select Clear Rules and click Clear Rules from Entire Sheet.
On the Price List worksheet, simultaneously rotate the text Port Size, Band Size, Price,
Install, and Support in both tables to Angle Counterclockwise. - Answer -*On the Price
List worksheet, select cell range C4:F4, and then while holding Ctrl on your keyboard,
select C17:F17.
*On the Home tab, in the Alignment group, click Orientation and select Angle
Counterclockwise.
Perform a multiple column sort on the data in the Wired Equipment table. First sort
alphabetically by Wired Equipment (from A to Z), then sort by Port Size (from A to Z). -
Answer -*On the Wired Equipment table, click on any cell in the table.
*On the Home tab, in the Editing group, click Sort & Filter and select Custom Sort...
*In the Sort pop-up window, configure the fields as shown below:
Column Sort by: Wired Equipment
Sort on: Cell Values
Order: A to Z
Click Add Level.
Configure the second row of fields as shown below:
Then by: Port Size
Sort on: Cell Values
Order: A to Z
*Click OK.
Configure the Catalog worksheet so rows 1 through 3 remain visible as you scroll
vertically. - Answer -*On the Catalog worksheet, select row 4.
(Hint: When freezing frames vertically, select the row below the last row you want to
remain visible.)
*On the View tab, in the Window group, click the Freeze Panes down arrow and select
Freeze Panes.
Add the Status of Draft to the document properties. - Answer -*Click the File tab.
*In the bottom-right corner of the Info page, click the Show All Properties link.
*In the Status field, type Draft.
In cell H5, enter a formula referencing the named ranges Price_10G, Install_10G, and
Support_10G to display the total sum value of the 10 Gbps Routers. - Answer -*Click
cell H5.
*In the Formula Bar, type *=SUM(Price_10G,Install_10G,Support_10G).
*Press Enter on your keyboard to commit the formula.
Remove all conditional formatting on the worksheet. - Answer -*On the Home tab, in
the Styles group, click Conditional Formatting.
*Select Clear Rules and click Clear Rules from Entire Sheet.
On the Price List worksheet, simultaneously rotate the text Port Size, Band Size, Price,
Install, and Support in both tables to Angle Counterclockwise. - Answer -*On the Price
List worksheet, select cell range C4:F4, and then while holding Ctrl on your keyboard,
select C17:F17.
*On the Home tab, in the Alignment group, click Orientation and select Angle
Counterclockwise.
Perform a multiple column sort on the data in the Wired Equipment table. First sort
alphabetically by Wired Equipment (from A to Z), then sort by Port Size (from A to Z). -
Answer -*On the Wired Equipment table, click on any cell in the table.
*On the Home tab, in the Editing group, click Sort & Filter and select Custom Sort...
*In the Sort pop-up window, configure the fields as shown below:
Column Sort by: Wired Equipment
Sort on: Cell Values
Order: A to Z
Click Add Level.
Configure the second row of fields as shown below:
Then by: Port Size
Sort on: Cell Values
Order: A to Z
*Click OK.
Configure the Catalog worksheet so rows 1 through 3 remain visible as you scroll
vertically. - Answer -*On the Catalog worksheet, select row 4.
(Hint: When freezing frames vertically, select the row below the last row you want to
remain visible.)
*On the View tab, in the Window group, click the Freeze Panes down arrow and select
Freeze Panes.
Add the Status of Draft to the document properties. - Answer -*Click the File tab.
*In the bottom-right corner of the Info page, click the Show All Properties link.
*In the Status field, type Draft.
