1. True. The Designer function in PowerPoint only changes the current slide you are working on.
2. By removing worksheet protection for the entire workbook. After applying the Lock Cells feature, you can unlock cells in Excel by removing worksheet protection for the entire workbook.
3. To add a video to a PowerPoint presentation, you would click on the "Insert" tab and then click on the "Video" button in the "Media" group.
4. By applying a chart style or template. You can modify the appearance of a chart in Excel by applying a chart style or template.
5. Draft view. Draft view is the view you can use to move around large sections of text.
6. To select a Theme for your PowerPoint presentation, you would click on the "Design" tab and then click on the "Themes" button in the "Themes" group.
7. In Excel, you can apply filters by clicking on the "Sort & Filter" button in the "Home" tab and selecting the desired filtering option, such as filtering by color or text criteria.
8. To remove a filter and display all rows in the data range in Excel, you would click on the "Filter" button in the "Data" tab and then select the "Clear" option.
9. Data Connection. In Excel, you can specify the data source and import settings when importing data from an external file by using the "Data Connection" option.
10. To add a table to a PowerPoint presentation, you would click on the "Insert" tab and then click on the "Table" button in the "Tables" group.
11. Predefined text and graphics that can be inserted into a document. Quick Parts in Microsoft Word are predefined text and graphics that can be inserted into a document.
12. It makes the object visible only as a small icon in the worksheet. The "Display as Icon" option in the Insert Object dialogue box makes the object visible only as a small icon in the worksheet.
13. The object remains unaffected. When you resize rows or columns in Excel, the inserted object remains unaffected.
14. A pre-formatted document that can be used as a starting point of a new document. A template in Microsoft Word is a pre-formatted document that can be used as a starting point of a new document.
15. To add a shadow to a picture that you have inserted in your Word document, you would click on the picture, then click on the "Format" tab, and then click on the "Shadow" button in the "Picture Styles" group.
16. COUNTIF. The COUNTIF function is used to count the number of cells in a range that meet specific criteria in Excel.
17. Share. When you want to send your PowerPoint presentation to someone via email, you would select the "Share" option.
18. They allow for complex calculations involving multiple criteria. The benefit of using array formulas in Excel is that they allow for complex calculations involving multiple criteria.
19. Quick identification, enhances collaboration and communication between users, and improved organization. These are all valid reasons for renaming tabs and changing the color of each tab in Excel.