Which of the following refers to cell A3 in sheet 3 for creating reference?
A. Sheet A3
B. Sheet3 !A3
C. Sheet3A3!
D. !sheet3! A3
plz answer fast and accurate
Answers
Answer:
Relative, Absolute and Mixed
A key element of a formula is the cell reference, and there are three types: Relative. Absolute. Mixed.
(｡◕‿◕｡)
Answer
What do you mean by A3,B13:B20,C7 reference in Excel? A. Range C. Formula B. Union D. General 2) Which view in Excel displays the pages exactly as they appear when printed? A. Custom View C. Full screen View B. Page Layout view D. Page Break View 3) Which tab is used for creating, formatting and editing a spread sheet? A. Data C. Insert B. Home D. Review 4) Which function is used to add the values in a range? A. Count() C. ABS() B. Sum() D. Sumif() 5) Which symbol is used to execute formulas in MS Excel? A. & C. @ B. # D. = 6) What is the purpose 'Tab' key in MS Excel? A. Moves cell pointer to previous column C. Moves cell pointer previous row B. Moves cell pointer to next column D. Moves cell pointer next row