Question

21.The copy results to option are

a) the cell references where the result is going to be displayed

b) the absolute cell references

c) the relative cell references

d) the cell references to be used for formula

22. Which of the following function is set as by default in data consolidation?

a) count

b) sum

c) max

d) min

23. Shaan is working on a spreadsheet and he performed the operation data

consolidation. But he wanted to generate the results in the target instead of the

actual results. Select the appropriate option he can choose?

a) Copy to

b) Consolidation Ranges

c) Link to source data

d) Function
​

Answer 1

Answer:

22. sun that is (b)

rest of it idk