Formulas and Functions
Q.1. What are formulas?
Q.2. What are functions?
Q.3. What formula can include?
Q.4. What is a range?
Q.5. What is a marquee?
Q.6. What is pointing?
Q.7. Give an example of using a basic formula?
Q.8. Give an example of using a compound formula?
Q.9. What is a compound formula?
Q.10. Give an example of using a range in the formula?
Q.11. What is concatenation?
Q.12. Give an example of concatenation?
Q.13. What is cell reference?
Q.14. Explain relative references.
Q.15. Give an example of relative reference?
Q.16. How do you define names for cells?
Q.17. Explain absolute references.
Q.18. Give an example of absolute references.
Q.19. Explain mixed reference?
Q.20. Give an example of mixed reference?
Q.21. Which rule is used to evaluate the mathematical expressions?
Q.22. What are circular references?
Q.23. Which are the two methods to pull data from another worksheet?
Q.24. How do you use the copy-paste option on different worksheets?
Q.25. How do you use sheet references? Explain with an example.
Q.26. How do you rename a worksheet?
Q.27. How do you change the color of the sheet tab?
Q.28. What are arguments?
Q.29. What are the rules to enter a function?
Q.30. Describe the autosum function.
Q.31. Explain autosum function with the help of an example?
Q.32. Describe the average function?
Q.33. Explain Average() function with the help of an example.
Q.34. Explain Max() function with the help of an example.
Q.35. How do you use a quick analysis tool?
Q.36. Which function is used to show the current date?
Q.37. Explain the Today() function.
Q.38. Name some functions and their purpose?
Q.39. How do you use the LCM function?
Q.40. How do you use the GCD function?
Q.41. Explain the Insert function.
No comments:
Post a Comment