BA CERTIFICATION EXAM QUESTIONS AND ANSWERS LATEST UPDATE 2025/2026
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. - Answers *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. - Answers *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. - Answers *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). - Answers
*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. -
Answers *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. - Answers *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.
*Click the return arrow in the upper-left corner of the Info window to display the document.
Configure Excel to always print cell range A1:F17 on the Q1 Sales worksheet. - Answers *On the
Q1 Sales worksheet, select cell range A1:F17.
*Click the Page Layout tab.
*In the Page Setup group, click Print Area and select Set Print Area.
On the Q1 Sales worksheet, insert a function in cell B19 that calculates all sales from the Total
column. - Answers *On the Q1 Sales worksheet, select cell B19.
*In the formula field, type =SUM(F4:F17).
*Click Enter on the keyboard to display the result.
(Hint: The result displayed should be $251,422.00.)
In cell B4 on the Q1 Sales worksheet, insert a function that joins the Description and Style
located on the Catalog worksheet. Separate the Description and Style with a hyphen and a
space on both sides of the hyphen (e.g., Cross Country - Hardtail). - Answers On the Q1 Sales
worksheet, select cell B4.
Click the Formulas tab and click Insert Function.
In the Search for a function field, type the keyword CONCAT.
In the Select a function field, select CONCAT. Click OK.
In the Function Arguments pop-up window for CONCAT, do the following:
Click in the Text1 field.
Click the Catalog worksheet tab. In the Description column, select cell D4. (Hint: Cross Country
should display to the right of the field.)
Click in the Text2 field.
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. - Answers *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. - Answers *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. - Answers *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). - Answers
*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. -
Answers *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. - Answers *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.
*Click the return arrow in the upper-left corner of the Info window to display the document.
Configure Excel to always print cell range A1:F17 on the Q1 Sales worksheet. - Answers *On the
Q1 Sales worksheet, select cell range A1:F17.
*Click the Page Layout tab.
*In the Page Setup group, click Print Area and select Set Print Area.
On the Q1 Sales worksheet, insert a function in cell B19 that calculates all sales from the Total
column. - Answers *On the Q1 Sales worksheet, select cell B19.
*In the formula field, type =SUM(F4:F17).
*Click Enter on the keyboard to display the result.
(Hint: The result displayed should be $251,422.00.)
In cell B4 on the Q1 Sales worksheet, insert a function that joins the Description and Style
located on the Catalog worksheet. Separate the Description and Style with a hyphen and a
space on both sides of the hyphen (e.g., Cross Country - Hardtail). - Answers On the Q1 Sales
worksheet, select cell B4.
Click the Formulas tab and click Insert Function.
In the Search for a function field, type the keyword CONCAT.
In the Select a function field, select CONCAT. Click OK.
In the Function Arguments pop-up window for CONCAT, do the following:
Click in the Text1 field.
Click the Catalog worksheet tab. In the Description column, select cell D4. (Hint: Cross Country
should display to the right of the field.)
Click in the Text2 field.
