Font size
WorksheetsMicrosoft 365 Test
Total questions: 42
Worksheet time: 59mins
Which of the following is a cloud-based feature of Microsoft 365?
Saving files only on your local device
Real-time collaboration across devices
Manual software updates
Offline-only access
List two reasons why linking a mobile number to your Microsoft account is recommended.
The (a) in Microsoft 365 allows users to switch between apps like Word, Excel, and Teams.
You’ve just logged into the Microsoft 365 portal. Describe how you would locate and open Excel from the dashboard.
Which tool is used to compose emails and manage calendars in Microsoft 365?
OneDrive
Word
Outlook
Forms
Explain the difference between the “To,” “CC,” and “BCC” fields in an email.
In Microsoft Teams, what is the main difference between a chat and a channel?
Chats are public, channels are private
Chats are for informal messages, channels are for meetings
Chats are one-on-one or small group, channels are tied to teams and topics
Chats support video calls, channels do not
You need to schedule a meeting with your team and include a video call. Which tool would you use, and what steps would you follow?
To notify someone in a Teams message, use the (a) symbol followed by their name.
Which of the following is considered good email etiquette?
Using all caps for emphasis
Leaving the subject line blank
Including a clear and concise subject
Forwarding without context
What are two advantages of storing files in OneDrive instead of on a local device?
Which feature allows you to restore a previous version of a file in OneDrive?
File Lock
Version History
Archive Mode
Sync Settings
To allow someone to edit a shared file in OneDrive, you must grant them (a) permissions.
You’ve uploaded a Word document to OneDrive and want to collaborate with a peer in real time. Describe the steps to share and co-author the document.
What does “syncing” in OneDrive enable?
Encrypts files for security
Deletes files from all devices
Updates files across all connected devices
Prevents file sharing
Which of the following is a valid question type in Microsoft Forms?
Signature
Rating
Checkbox Grid
File Upload
Name two ways you can share a Microsoft Form with respondents.
To limit responses to one per person, you can require (a) before submitting the form.
You want to collect feedback from training participants and analyze it in Excel. Describe the steps from creating the form to exporting the data.
What does Microsoft Forms allow you to do with response data?
Encrypt it
View it in real time
Automatically delete it
Convert it to PowerPoint
What is the purpose of setting a deadline on a Microsoft Form?
To automate follow-up emails based on form responses, you can use (a) .
You’ve created a survey and want to send a thank-you email to anyone who selects “Very Satisfied.” How would you set this up using Microsoft Forms and Power Automate?
Which of the following is a valid Excel function for conditional logic?
SUM
IF
COUNT
VLOOKUP
What does the COUNTIF function do?
To find a value in a table based on a lookup key, you would use the (a) function.
You’re managing inventory data in Excel. How would you use conditional formatting to highlight items with stock below 10?
Use the “Data Validation” feature and set the minimum value to 10
Use Conditional Formatting with a rule: "Format only cells that contain" and set the rule to "Cell Value less than 10"
Use a formula: =IF(A1<10,TRUE,FALSE) in a new column
Use the “Sort & Filter” feature to filter values less than 10
Which chart type is best for showing parts of a whole?
Line chart
Bar chart
Pie chart
Scatter plot
To customize the appearance of a chart, you can modify elements like the title, (a) , and legend.
Which type of flow are triggered manually as needed?
Automated flows
Manually updated flows
Instant flows
Desktop flows
All flows require a trigger to start.
True
False
Power Automate do not enable their users to test the flow.
True
False
____ provides a low-code platform for building workflow and process automation.
Power BI
Power Automate
Power App
Power Pages
Which icon is the Teams icon?
Can you invite an external user to a Teams video meeting?
True
False
One of the benefits of OneDrive is that ...
It lets you access your files anywhere.
It lets you share files with other users.
It gives you more space than your C drive (the drive on your laptop).
All of the above
Describe the steps taken when creating a new Microsoft Registration form
You are doing a repetitive task at work. What Microsoft tool can help simplify your task?
Microsoft needs to comply with the (a) to help safeguard user data
What is to collaborate?
To share a file on the internet
To share and work on a file with someone on a computer
to share, work and communicate on a file with someone on the same computer
to share, work, and communicate on a file with someone over the internet on separate computers
What is Microsoft 365?
