Spreadsheets In a spreadsheet, the formula SA$4 B$2 B2 is entered into cell C3.

Question

Spreadsheets In a spreadsheet, the formula SA$4 B$2 B2 is entered into cell C3. The contents of cell C3 are copied/pasted to cell D5 The formula in cell D5 is: (A) $A$4 + C$2 +C4 (B) $B$6C$2+C4 (C) $A$4 C$4 +C4 (D) SA$4 B$2 +B2 If cells A1, A2, A3, B1 have the values 1, 2, 3, 10 evaluate the expression =sum(A1:A3,B1) in cell A4. Given x values in cells A1,A2,A3 are 1,2,3 write the formula to calculate y with the equation y-2x in cell B1 The value in A1 on sheet 1 is 5 and the value in A1 on sheet 2 is 5. Write the formula to add these two values in A1 on sheet 3 What is goal seek used for? Give an example of lettering by lettering your name. How many significant figures in the number 6.140 x 104

Explanation / Answer

1) ans: D

2) Ans:16, it just adds the values in the cells a1 to a3 an in b1

3) Ans: =2*A1

Related Questions

Navigate

• Browse (All)
• Browse S
• Subjects

---

---

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