ACC-575Questions And Answers.

1. The story of Bricklin and Frankston and the emergence of personal computers provides evidence suggesting that - Spreadsheets were not originally used for accounting applications - Hardware sells software - All of these are true - The personal computer existed before Apple - Software sells hardware 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. 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. Evaluate the formula 3^(1+1)*4-5/7 using the order of calculation followed by Excel or Sheets. Round to 2 decimals. 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.