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?
No comments:
Post a Comment