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?

More on MS PowerPoint 2016

 More on MS PowerPoint 2016

Q.1. What is a MS PowerPoint?

Q.2. What are slides?

Q.3. What functions can be performed with slides?

Q.4. How do you start MS PowerPoint?

Q.5. What are the components of PowerPoint 2016 Window?

Q.6. Describe the Home Tab?

Q.7. Describe the Inert Tab?

Q.8. Describe the Design Tab?

Q.9. Describe the Transitions Tab?

Q.10. Describe the  Animations Tab?

Q.11. Describe the  Slide Show Tab?

Q.12. Describe the Review Tab?

Q.13. Describe the View Tab?

Q.14. Which shapes are available in Microsoft PowerPoint? What functions can be performed with it?

Q.15. Show the use of shapes with an example?

Q.16. How do you rotate a shape?

Q.17. How do you resize a shape?

Q.18. How do you apply a transition effect?

Q.19. Describe the built-in transition effects?

Q.20. What are the categories of built-in transition effects?

Q.21. How do you adjust the transition speed?

Q.22. How do you add sound to a transition effect?

Q.23. Describe advancing a slide?

Q.24. How do you remove a transition effect?

Q.25. What is an animation?

Q.26. How many types of animation are there?

Q.27. What are the steps to add animation to text or an object?

Q.28. What are the colors of Entrance effect icons, Emphasis effects icons and exit effect icons?

Q.29. How do you combine animation effects?

Q.30. How do you remove the animation effects?

Q.31. How many views are offered by PowerPoint 2016?

Q.32. Describe the Normal View?

Q.33. Describe the Slide Sorter View?

Q.34. Describe the Reading View?

Q.35. Describe the Slide Show View?

Q.36. Describe the notes page?

Q.37. How do you rearrange slides in Slide Sorter View?

Q.38. How do you run a slideshow?

Q.39. Which function key is used to start the presentation from the first slide?

Q.40. Which command is given to start the presentation from the current slide?

Q.41. Which key is used to stop a presentation before reaching the end?

More on MS-Word 2016

 More on MS-Word 2016

Q.1. What is Microsoft Word 2016?

Q.2. When do we need to find and replace text?

Q.3. How do you find a particular text?

Q.4. How do you replace a text?

Q.5. What is a hyperlink?

Q.6. How do you insert a hyperlink?

Q.7. What is called following the link?

Q.8. What are columns in text?

Q.9. What is column formatting?

Q.10. What are the steps to apply column formatting?

Q.11. What is a Drop Cap?

Q.12. How do you apply Drop Cap?

Q.13. How do you apply a watermark?

Q.14. What is a watermark?

Q.15. How do you set a custom watermark?

Q.16. What is line spacing?

Q.17. What are the steps to set line spacing?

Q.18. What is paragraph spacing?

Q.19. How do you set paragraph spacing?

Q.20. Describe Page Margin?

Q.21. How do you set Page Margins?

Q.22. What is the use of mail merge?

Q.23. What are the requirements of the process of mail merge?

Q.24. What is the main document in mail merge?

Q.25. What is the data source in mail merge?

Q.26. What is merging and what is a merged document?

Q.27. How do you perform mail merge?