1. Which is used to make formulas easier to use and understand?
2. Which of the following is a formula auditing option?
3. What shows the arrows that indicate which cells affect the values of the currently selected cell?
4. What shows the arrows that indicate which cells are affected by the values of the currently selected cell?
5. How can you update the values of a formula cell if Excel’s auto-calculation mode is disabled?
6. What is known as a 2D reference formula?
7. What is also called a 2D formula?
8. What is known as a 3D reference formula?
9. Which formula is also known as a cube formula?
10. What is an external reference formula?
11. What is cell reference?
12. From the following, which one is a relative reference?
13. From the following, which one is a mixed reference?
14. How can you change a reference to absolute using the F4 key?
15. Absolute (mixed) references are marked with…
16. In the formula, which symbol specifies the fixed column or row?
17. Multiple calculations can be made in a single formula using…
18. Array formula is denoted by…
19. A formula that has more than one mathematical operator is called…
20. If one formula has another formula (formula inside formula), it is called…