Peachtree business questions

Dec 3rd, 2014
Anonymous
Category:
Accounting
Price: $10 USD

Question description

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

Tutor Answer

(Top Tutor) Studypool Tutor
School: Boston College
PREMIUM TUTOR

Studypool has helped 1,244,100 students
Ask your homework questions. Receive quality answers!

Type your question here (or upload an image)

1831 tutors are online

Brown University





1271 Tutors

California Institute of Technology




2131 Tutors

Carnegie Mellon University




982 Tutors

Columbia University





1256 Tutors

Dartmouth University





2113 Tutors

Emory University





2279 Tutors

Harvard University





599 Tutors

Massachusetts Institute of Technology



2319 Tutors

New York University





1645 Tutors

Notre Dam University





1911 Tutors

Oklahoma University





2122 Tutors

Pennsylvania State University





932 Tutors

Princeton University





1211 Tutors

Stanford University





983 Tutors

University of California





1282 Tutors

Oxford University





123 Tutors

Yale University





2325 Tutors