on sAVERAGE(A3 D3). What will be the contents of cell E4 if the entry in cell E3
ID: 3589958 • Letter: O
Question
on sAVERAGE(A3 D3). What will be the contents of cell E4 if the entry in cell E3 is copied to cell E4? (a) =AVERAGE(A3:D3) (b)AVERAGELA4:D4) (c) =AVERAGE(8A83:8DS3) (d) =AVERAGE(SAS 4:8D84) 17.Cell E3 contains the function -AVERAGEISAS3.SDS3). What wll be the cell E4 if the entry in cell E3 is copied to cell E4? (a) AVERAGEIA3:D3) (b) AVERAGElA4:D4) (c) AVERAGEISAS3:SDS3) (d) AVERAGEISAS4:SDS4) 18. Which cell reference would change if the formula Al SBS1 is copled to a new location? (a) Al (b) SB$1 (c) Both Al and $BS1 (d) Neither Al nor SBS1 19. Which cell reference would not change if the formula "Al-SBS1 is copled to a new location? a) Al (b) SB$1 (c) Both A1l and SBS1 (d) Neither Al nor SBS1 20. How would the number .05 be displayed if Percent format with 2 decimal places is specified? (a) .05% (b) 5.096 (c) 5.00% (d) 50.00% 21. What will be the contents of cell B7 given that cell B6 ts copied to cell B7 and that cell B6 contains the function -PMTIA6/12.SCS2, SC$1)? (a) -PMTIA6/12,SC$2,-SC$1) (c) =PMTtA7/12.SCS2.-SCS1) (d) None of the above 22.If the active cell is B1 and you insert a new row, where will it be inserted? (a) Above B (b) Below B (c) You will be prompted where you want to insert it (d) You cannot insert new rows after you have begun editing your worksheetExplanation / Answer
16. cell E3 contains the function= AVERAGE(A3:D3). Wat will be the contents of cell E4 if the entry in cell E3 is copied to cell E4?
Ans: b)=AVERAGE(A4:D4)
17. Cell E3 contains the function =AVERAGE($A$3:$D$3). If the contents of cell E3 are copied to cell E4, what will be the contents of cell E4?
Ans:c) =AVERAGE($A$3:$D$3)
18.Which cell reference would change if the formula =A1*$B$1 is copied to a new location?
Ans: a) A1
19.b)$B$1
20. How would the number .05 be displayed if Percent format with 2 decimal places is specified?
aNS:(c) 5.00%
21 What will be the contents of cell B7 given that cell B6 is copied to cell B7 and that cell B6 contains the function =PMT(A6/1
2,$C$2,-$C$1)?
Ans: (c)=PMT(A7/12,$C$2,-$C$1)
22.If the active cell is B1 and you insert a new row, where will it be inserted?
Ans: Abive B1.
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.