ACC-575 HOMEWORK Week 1
Questions And Answers. Rated A+.
, 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.
This study source was downloaded by 100000836267798 from CourseHero.com on 10-26-2022 08:16:48 GMT -05:00
https://www.coursehero.com/file/23380030/Week-1-HW/
Questions And Answers. Rated A+.
, 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.
This study source was downloaded by 100000836267798 from CourseHero.com on 10-26-2022 08:16:48 GMT -05:00
https://www.coursehero.com/file/23380030/Week-1-HW/
