# Peachtree business questions

Dec 3rd, 2014
FratBro23
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) Daniel C.
(997)
School: UIUC
PREMIUM TUTOR

Studypool has helped 1,244,100 students

## Review from our student for this Answer

SoccerBoss
Dec 5th, 2014
"Excellent job"
Ask your homework questions. Receive quality answers!

Type your question here (or upload an image)

1829 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