Question Completion Status:
QUESTION 1
Please indicate if the following statement is true or false:
If you use the Designer function in PowerPoint to select a design, as seen in the image below, it only changes the current slide you are working on.
True
False
1 points
QUESTION 2
How can you unlock cells in Excel after applying the Lock Cells feature?
By removing worksheet protection for the entire workbook
By removing the password from the cells.
By changing the formatting of the cells to unlock them.
By selecting the cells and clicking the Unlock Cells button.
1 points
QUESTION 3
Where would you click to add a video to a PowerPoint presentation?
Markerimage related to this question
Selected Coordinates 44, 4Clear
1 points
QUESTION 4
How can you modify the appearance of a chart in Excel?
By changing the font size of the chart title
By resizing the worksheet cells
By adjusting the chart's data range
By applying a chart style or template
1 points
QUESTION 5
Which view can you use to move around large sections of text?
Outline view
Web Layout view
Print Layout view
Draft view
1 points
QUESTION 6
Where would you click to select a Theme for your PowerPoint presentation?
Markerimage related to this question
Selected Coordinates 77, 7Clear
1 points
QUESTION 7
ow can you apply filters to a table in Excel?
Filters can be applied to a table in Excel by creating a separate filter range and linking it to the table using a formula or data connection.
Applying filters to a table in Excel requires the use of specialised filter functions in the formula bar, specifying the filtering criteria and range.
Filters can be applied to a table in Excel by converting the table into a PivotTable and using the filtering options provided by the PivotTable.
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 colour or text criteria.
1 points
QUESTION 8
Which option in Excel allows you to remove a filter and display all rows in the data range?
To confirm the sorting order before applying the sort.
To display an error message if the data range is too large
To suggest alternative sorting options based on the data.
To provide a progress bar for the sorting process.
1 points
QUESTION 9
Which option in Excel allows you to specify the data source and import settings when importing data from an external file?
Data Analysis
Data Validation
Power Query
Data Connection
1 points
QUESTION 10
Where would you click to add a table to a PowerPoint presentation?
Markerimage related to this question
Selected Coordinates 45, 6Clear
1 points
QUESTION 11
What are Quick Parts in Microsoft Word?
Templates used for creating professional resumes.
An advanced feature for creating complex formulas in Word documents.
Keyboard shortcuts for commonly used commands in Word.
Predefined text and graphics that can be inserted into a document.
1 points
QUESTION 12
What is the purpose of the "Display as Icon" option in the Insert Object dialogue box?
It enables you to rotate the object.
It allows you to change the shape of the object.
It makes the object visible only as a small icon in the worksheet.
It converts the object into a hyperlink.
1 points
QUESTION 13
What happens to the inserted object when you resize rows or columns in Excel?
The object remains unaffected.
The object is deleted.
The object adjusts its size proportionally.
The object becomes distorted.
1 points
QUESTION 14
What is a template in Microsoft Word?
A pre-formatted document that can be used as starting point of a new document
A tool used to fix formatting issues in existing documents.
A feature that enables collaboration with others in real-time.
A function that allows you to track changes made to a document.
1 points
QUESTION 15
Where would you click to add a shadow to a picture you have inserted in your Word document?
Markerimage related to this question
Selected Coordinates 109, 39Clear
1 points
QUESTION 16
Which Excel function is used to count the number of cells in a range that meet specific criteria?
COUNT
AVERAGE
SUM
COUNTIF
1 points
QUESTION 17
Which option would you select when you want to send your PowerPoint presentation to someone via email?
Info
Save a Copy
Share
Export
1 points
QUESTION 18
What is the benefit of using array formulas in Excel?
They allow for complex calculations involving multiple criteria
They provide direct access to external data sources
They automatically adjust to changes in data ranges
They enable the use of advanced conditional formatting
1 points
QUESTION 19
You can rename your tabs by quickly double-clicking on the name or by right-clicking and selecting “Rename”. You can also change the colour of each tab by right-clicking and selecting “Tab Colour”. Why would you? (Select all the right answers)
Quick identification.
Enhances collaboration and communication between users.
Ensure that the tabs are not renamed or moved
Improved organisation.
1. True
2. By removing worksheet protection for the entire workbook
3. Insert tab > Video
4. By applying a chart style or template
5. Outline view
6. Design tab > Themes group > Themes button
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 colour or text criteria.
8. To confirm the sorting order before applying the sort.
9. Data Connection
10. Insert tab > Table
11. 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.
13. The object adjusts its size proportionally.
14. A pre-formatted document that can be used as a starting point of a new document.
15. Picture Tools Format tab > Picture Style group > Picture Effects button > Shadow
16. COUNTIF
17. Share
18. They allow for complex calculations involving multiple criteria.
19. Quick identification, enhances collaboration and communication between users, improved organization.
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.