JavaScript must be enabled in order for you to see "WP Copy Data Protect" effect. However, it seems JavaScript is either disabled or not supported by your browser. To see full result of "WP Copy Data Protector", enable JavaScript by changing your browser options, then try again.

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

  1. Select the save space and download files as you use them box
  2. Select the white or blue One Drive
  3. 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

Leave a Reply

Your email address will not be published. Required fields are marked *

CLICK HERE TO TAKE A SURVEY TO EARN R50 A DAY!