Question 1

Give two benefits of using spreadsheets in doing financial analysis.

Accepted Answer

Compared to manual calculations, spreadsheets are 1) faster for performing calculations; 2) less likely to have a computational error; 3) recompute changes faster and more accurately.

Question 2

If you typed the following formula into Excel, what number would it generate?
=(15/3)+5*(6/2)

Accepted Answer

Excel would first divide the (15/3) and (6/2), then multiply the (6/2) by 5, and then add this with the (15/3), or
=5 + 5 × 3 = 20

Question 3

Suppose you wanted to add together the numbers in cells A1, A2, and A3. Write three versions of the Excel formula you would type to perform this calculation.

Accepted Answer

=SUM(A1, A2, A3) or =A1+A2+A3 or =SUM(A1:A3)

Exam 2: Introduction to Electronic Spreadsheets

Give two benefits of using spreadsheets in doing financial analysis.

If you typed the following formula into Excel, what number would it generate? =(15/3)+5*(6/2)

Suppose you wanted to add together the numbers in cells A1, A2, and A3. Write three versions of the Excel formula you would type to perform this calculation.