Introduction Spreadsheets Models - COURSERA

 

Week 1: Module 1 Quiz: History, Formulas, Functions and Errors

1.

Question 1

The story of Bricklin and Frankston and the emergence of personal computers provides evidence suggesting that ______________

1 / 1 point

Software sells hardware

All of these are true

The personal computer existed before Apple

Hardware sells software

Spreadsheets were not originally used for accounting applications

2.

Question 2

If the range A1:A4 consists of the values 1,2,3,4 and the range B1:B4 consists of the values 9,8,7,6, what is the value of the sumproduct(B1:B4, A1:A4)?

Ques
tion If the range A1:A4 consists of the values 1,2,3,4 and the range B1:B4 consists of the values 9,8,7,6, what is the value of the sumproduct(B1:B4, A1:A4)?

Question 2If the range A1:A4 consists of the values 1,2,3,4 and the range B1:B4 consists of the values 9,8,7,6, what is the value of the sumproduct(B1:B4, A1:A4)?

70

3.

Question 3

Review the step function in the spreadsheet below. Given the conditional pricing formula shown in C3, what’s the value of the order total in C5?

7650

4.

Question 4

Evaluate the formula 3^(1+2)*4-5/7 using the order of calculation followed by Excel or Sheets. Round to 2 decimals, and use a decimal point (".") in your answer.

107,28

5.

Below is a spreadsheet showing product sales for the past 6 months. Assume we want to write a formula in cell C10 that we can copy later across 6 columns representing the past 6 months of sales. The formula needs to apply the unit cost of goods sold found in cell C2. Enter the formula for cell C10 using spreadsheet syntax and the appropriate absolute and relative addresses to calculate total cost of goods sold for that period.

=$C$2*C8

6.

Question 6

Which of the following formulas from the spreadsheet shown below will result in a circular reference error? Select all that apply.

Formula in cell C10=sumproduct(C5:H7, C2)

All of these will result in a circular reference error

Formula in cell H10=sum(H5:H10)

Formula in cell C10=sum(C7:C10)*$C$2

Formula in cell C14=C10*C4-C10*C2

7.

Question 7

In the cashflow spreadsheet below, which of the following cell addresses contains a potentially important output function for the cashflow model? Select all that apply.

1 / 1 point

B6

Correct

B8

Correct

B12

B7

Correct

B13

8.

Question 8

In this analysis of historical sales, which cell formula tells you the level of variation in the spread of sales numbers from low performing months to high performing months?

1 / 1 point

C9

C8

C10

None of these show the spread of sales numbers

C11

10.

Question 10

The term array is closest in meaning in Excel to:

1 / 1 point

Sumproduct

Standard Deviation

Spreadsheet

Range

Cell