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 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)? 70 3 . Question 3 Review the step function in the spreadsheet below. Given the conditio...