For this test you can use Excel, or do it in your head.Either way, type the answ

Question

For this test you can use Excel, or do it in your head.Either way, type the answer or paste the result in this document. You can use the internet as a reference. For the code questions, you can paste the code in to a module and step through the code. For questions 1 to 4, you can paste these formulas into the spreadsheet and try them out. Just be very careful to paste them in the correct cell per the instruction in each problem. If the following formula is entered in to cellB1, sum(A1:AS) and the formula is copied to cell C2,what will the formula be in cell C2 If the following formula is entered in to cell B1, average(A$1A$5 and the formula is copied to cell C2,what will the formula be in cell C2. If the following formula is entered in to cell B1, product ($A$15A$5) and the formula is copied to cell C2,what will the formula be in cell C2. If the following formula is entered in to cell B1, sum(A1A5) and the formula is cut and pasted to cell C2,what will the formula be in cell C2.

Explanation / Answer

1. B1 = sum(A1:A5) , C2 = sum(B2:B6) [copy and paste, relative column,relative row]

2. B1 = average(A$1:A$5) , C2 = average(B$1:B$5) [copy and paste , relative column and absolute row]

3. B1 = product($A$1:$A$5) , C2 = product($A$1:$A$5) [copy and paste,absolute column,absolute row]

4. B1 = sum(A1:A5) , C2 = sum(A1:A5) [cut and paste, relative column,relative row]

Related Questions

Navigate

• Browse (All)
• Browse F
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.