AINS 101 SIMULATED CERTIFICATION EVALUATION TEST 2026 FULL SOLUTION QUESTIONS GRADED A+

AINS 101 SIMULATED CERTIFICATION
EVALUATION TEST 2026 FULL SOLUTION
QUESTIONS GRADED A+

●● 2.1 Group the Qtr1 through Qtr4 worksheets. Use AutoSum to
simultaneously total the values of the data in the range B3:E11.
Simultaneously format the ranges B3:E3 and B11:E11 using the
Accounting Number Format.


2.2 Type Monthly Sales in cell A11.


2.3 Apply Bold to cell A11.


2.4 Apply the Top and Double Bottom Border to the range B11:E11.


2.5 Ungroup the worksheets..
Answer: 2.1 Click the Qtr1 sheet tab, hold SHIFT, and then click the
Qtr4 sheet tab. Select the range B3:E11 and on the Home tab, in the
Editing group, click Sum.
Select the range B3:E3, hold CTRL, and then select the range B11:E11.
On the Home tab, in the Number group, click Accounting Number
Format.

, rest is self explanatory


●● 3.1 With the Summary worksheet active, insert a hyperlink in cell B2
to the range E2:E11 in the Qtr1 worksheet. Include the ScreenTip 1st
Quarter.


3.2 With the Summary worksheet active, insert a hyperlink in cell C2 to
the range E2:E11 in the Qtr2 worksheet. Include the ScreenTip 2nd
Quarter.


3.3 With the Summary worksheet active, insert a hyperlink in cell D2 to
the range E2:E11 in the Qtr3 worksheet. Include the ScreenTip 3rd
Quarter.


3.4 With the Summary worksheet active, insert a hyperlink in cell E2 to
the range E2:E11 in the Qtr4 worksheet. Include the ScreenTip 4th
Quarter.


3.5 click on the hyperlink.
Answer: 3.1 With the Summary worksheet displayed, click cell B2, and
then click the Insert tab.
In the Links group, click Link.
In the Insert Hyperlink dialog box, in the Link to box, click Place in This
Document.