Formulas and Functions

 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.

More on MS Excel 2016

 More on MS Excel 2016

Q.1. Which symbol marks the beginning of a formula in MS Excel?

Q.2. What maximum length can a formula have?

Q.3. What can be used for data in a formulae?

Q.4. What is concatenation?

Q.5. How do we create a simple text value? Which symbol is used to join text values to one another?

Q.6. Explain the arithmetic operators in MS Excel?

Q.7. Explain the relational operators in MS Excel?

Q.8. Explain the logical operators in MS Excel?

Q.9. State some common error results and their reasons?

Q.10. What is the order of precedence of the mathematical operations?

Q.11. What is the use of copying a formula?

Q.12. Explain the steps to copy a formula?

Q.13. What is a fill handle?

Q.14. What is the function of SUM() Formulae?

Q.15. What is the function of AVERAGE() formulae?

Q.16. What is the function of Max() formulae?

Q.17. Which function is used to find the minimum value from a given set of values?

Q.18. What is sorting?

Q.19. What is editing? Which operation we can perform while editing?

Q.20. How do you overwrite cell contents?

Q.21. How to sort data in MS Excel?

Q.22. How do you modify cell contents partially?

Q.23. How can you delete the cell contents?

Q.24. How do you copy the contents of a cell?

Q.25. How do you move the cell contents?

Q.26. How do you insert cells?

Q.27. How to insert rows/columns?

Q.28. How to delete cells?

Q.29. How to delete rows/columns?

Q.30. How do you adjust the row height?

Q.31. How do you adjust the column width?

Q.32. What are sparklines?

Q.33. How do you insert sparklines?

Q.34. What is conditional formatting?

Q.35. What is an auto fill feature?

Q.36. How do you create numeric data series?

Q.37. How do you create a predefined series of days?