Here are the questions and answers for SharePoint and Excel that will help you to pass the test.
Questions and answers for Sharepoint and Excel will help you to pass.
SharePoint
Question
Puleng does not know the difference between online-only files and locally available files. When she opened the online-only file is automatically downloaded to her devices and becomes a locally available file.
Does she need internet access to open the locally available file?
Answer
False.
Question
Microsoft SharePoint teams site connects you and your colleagues to the content, information and application you need every day.
Answer
True.
Question
Any member can edit and add new sites on the Microsoft SharePoint platform.
Answer
True
Question
SharePoint Online is a cloud-based service.
Answer
True
Question
SharePoint Online allows you to connect with your colleagues in one place with the teams on the communication site.
Answer
True
Question
SharePoint Online is a powerful web-based application used for collaboration and information exchange across an organisation
Answer
True
Question
Online-only files are available only when you are connected to the internet and they take up your space.
Answer
False
Question
Team site you can share news or information and engage with a large audience using modern and visual layouts.
Answer
True
Question
When you create sites there are two options namely a team site and a communication site,.
Answer
True
Question
You can sync your file on
Answer
All of the above
Question
You have to sign in to OneDrive to sync your files.
Answer
True
Question
Microsoft SharePoint allow people from different locations to collaborate
Answer
True
Question
With OneDrive files on-demand, you can save space on your device by making files online only.
Answer
True
Question
You can view the activities in the SharePoint report by choosing the:
Answer
Activity tab
Question
New from sites highlights updates from sites you follow or do not visit often
Answer
False
Question
Building blocks that help you put content on a page
Answer
Web parts
Question
When you open an online-only file it is automatically downloaded to your devices and become a locally available file.
Answer
True
Question
A communication site lets your team collaborate on projects, see related new teams, keep others on track with a shared calendar and manage tasks
Answer
False
Question
How to remove a news post from Microsoft SharePoint.
Answer
Home<Chosethe post you want to remove/ SELECT DELETE
Question
On Windows, OS synced files are stored in ….. under the name of the organisation
Answer File Explora.
Question
To make sure that the file is always available even when you are offline which step you must follow?
Answer
Right click> Select Always keep on this device.
Question
When you create a team site on office 365 a corresponding office 365 group is also created within the office 365 group there is no need to do an email distribution list anyone can contact the entire team with the group email address.
Answer
True
Question
If you have permission to add a site you can add:
Answer
All of the above
Question
Which of the following is part of the web parts:
Answer
All of the above
Question
Where do you find recent activities and sites you would like to go to?
Answer
Frequent sites
Question
Users can use Microsoft SharePoint to:
Answer
All of the above
Question
Web part feature is under discovery
Answer Quick link
Question
A…… provides a secure place to store files where you and your co-workers can find them easily, work on them together, and access them from any device at any time
Answer
Document library
Question
Which of the following is not part of recent on the Microsoft share point home page
Answer
None of the above
Excel
Question
What is the function you would use to combine data in a cell?
Answer
CONCAT Function
Question
How do you create a workbook from a template?
Answer
Double click template.
Question
How to use format painter in Excel
Answer
Insert tab, in the clipboard group, click the format painter button.
Question
When do you connect to OneDrive for Business which means you have a live connection to that file?
Answer
True
Question
You can create a chart from a Pivot Tabel
Answer
True
Question
Excel comes with a build-it watermark button
Answer
False
Question
Existing styles on excel cannot be modified?
Answer
True
Question
If the function runs a logical test and returns one value for a true result and another for false results
Answer
Question
Columns run across the worksheet from left to right
Answer
True
True
Question
Can you use pivot tables in Excel?
Question
Rows are arranged up to down
Answer
True
Answer
True
QUESTION
…….Is a series of data banks put out horizontally in a table or spreadsheet?
Answer
Field
Question
The following Data bars colour coding, sparklines and icons are part of excel for sports trends and partners?
Question
Chart title makes charts difficult to understand?
Answer
False
Answer True
Using a slicer, you can filter your data by clicking on the type of data you want
Answer
True
Question
Filters can be used to narrow down the data in your worksheet and hide parts of it from view
Answer
True
Question
Excel comments are used to add a note or explain a formula in a cell
Answer
True
Question
What is the simplest way to join cell content?
Answer use the ampersand symbol &
Question
Under which tab will you find the Autofit row height?
Answer
Format
Question
The Excel SUM function returns the sum of values supplied
Answer True
Question
Steps to insert a pivot table
Insert<pivot chat
Question
Which of the following is suitable for editing spreadsheets?
Answer
Excel
Question
Turn on files on-demand
- Select the save space and download files as you use them box
- Select the white or blue One Drive
- Select help and settings
Answer
CBA
QUESTION
Which feature in Excel is used to control what a user can enter into a cell.
Answer
Data Validation
Question
Which of the following is not part of the drag field between areas;
Answer
Filter
Question
Dimpho wants to combine more than two rows in Excel. Which feature can she use?
Answer
Combine cells
Question
Name the feature in Excel that enables you to auto-complete a list in a row/ column by simply dragging it using your mouse?
Answer
Filehandle
Question
What are the right steps to delete a row in Excel
Answer
B,A,C