3. When using Excel, entering the formula =SUM(B3:B19)/2 in cell B20 will result in which of the
following actions?
A. The total of cells B3 to B19 will appear in cell B20.
B. The total of cells B3 to B19 divided by 2 will appear in cell B20.
C. Cells B3 and B19 will be added together and then divided by 2 will appear in cell B20.
D. Cells B3, B19, and B20 will

4. Peter needs to copy information in cells C7:C20 into cells E7:E20 in Excel. The easiest way for Peter to
copy cells C7:C20 and place their information into E7:E20 is to
A. highlight cells C7:C20, click on the Home tab, in the edit group, choose Copy, select cells E7:E20, and then click Paste.
B. highlight cells C7:C20, right-click, choose Copy, select cells E7:E20, right-click, and then click Paste.
C. highlight cells C7:C20, click on the Format tab, choose Duplicate, select cells E7:E20, and click Enter.
D. highlight cells C7:C20, right-click, choose Cut, select cells E7:E20, right-click, and then click Past

10. Which of the following is an example of a formatted number using the currency option in Excel?
A. 8889.10%
B. \$8,891.10
C. 888910
D. 888,910

11. Which of the following is an example of a complex formula in Excel?
A. =B6<=B1+3
B. =375*4+200
C. =Revenues – Cost of Goods Sold
D. =SUM(A12:G19

13. On the Navigation Bar, make the following selections to record a cash sale:
A. On the Customers & Sales Navigation Center, click on the Receive Money icon and select View and Edit Payments Receive,
Apply to Revenues tab, record the cash sale
B. On the Customers & Sales Navigation Center, click on the Receive Money icon and select Receive Money from Customer,
Apply to Revenues tab, record the cash sale
C. On the Banking Navigation Center, click on the Receive Money icon and select Receive Money from Customer, Apply to
Revenues tab, record the cash sale
D. On the Customers & Sales Navigation Center, click on the Sales Invoices icon and select New Sales Invoice