Take Test: ICT proficiency Level 2 Quiz

Digital Skills and Competencies for Students
WELCOME
LEVEL 1
ICT Proficiency
Digital Citizenship
Information, Data and Media literacy
Digital creation: Problem solving, Creativity and Innovation in a digital space
LEVEL 2 COMING SOON
ICT Proficiency Level 2
Digital Citizenship Level 2
Information, Data and Media literacy Level 2
Digital Creation: Problem solving, Creativity and Innovation in a Digital space Level 2
LEVEL 3 - COMING SOON
CERTIFICATES
Quizzes
Track your results here
Badges
Contact us
Take Test: ICT proficiency Level 2 Quiz

Test Information
Description
Instructions
Quiz Instructions:

Check your internet connection and ensure that you have a reliable and stable connection before beginning the test.
Ensure that your Google Chrome is updated to the latest version.
Carefully read the questions before answering.
Some questions will acquire to require you to open and practise the different options before you select the correct one.
Make sure you answer the question before moving on to the next question.
Once you have completed the test, submit your answers and wait for confirmation that the submission was successful.
Good luck!

Multiple AttemptsThis test allows 3 attempts. This is attempt number 2.
Force CompletionThis test can be saved and resumed later.
Your answers are saved automatically.
Expand Question Completion Status:
QUESTION 1

Where would you click to add a hyperlink to another slide in the PowerPoint presentation you are working on?

Markerimage related to this question
Selected Coordinates 734, 436Clear
1 points

QUESTION 2

There are two ways to unhide columns, what are they?  (select two answers)

Select the columns adjacent to the hidden columns and right-click the selected columns, and then select "Unhide”

Select columns adjacent to the hidden columns and hover your mouse over the edge line of the column until a line with two arrows on either side appears, then click and drag the edge of one column.

Hover your mouse over the thicker line between the two columns where the hidden columns are and wait for a pop-up window to appear, then select “Unhide”.

Double-click the thicker line between the two columns where the hidden columns are.

1 points

QUESTION 3

Which option would you select if you wanted to protect your PowerPoint presentation from someone else making changes to your presentation?



Export

Share

Info

Save a Copy

1 points

QUESTION 4

Which is NOT a way to edit a formula in a cell in Excel ?

Select the cell and then click in the formula bar

Right-click the cell and select Edit.

Press F2

Double-click the cell 

1 points

QUESTION 5

Where on the ribbon would you click to add a graph in a Microsoft Word document?

Markerimage related to this question
Selected Coordinates 76, 14Clear
1 points

QUESTION 6

Where on the ribbon would you click to access a automatically generated slide designs for the slide you are working on?

Markerimage related to this question
Selected Coordinates 77, 1Clear
1 points

QUESTION 7

Where would you click if you wanted to find a template that is not on the list you are seeing on the screen?

Markerimage related to this question
Selected Coordinates 714, 11Clear
1 points

QUESTION 8

Where on the ribbon would you click to add a new citation to a Microsoft Word document?

Markerimage related to this question
Selected Coordinates 298, 7Clear
1 points

QUESTION 9

Which of the following describes the purpose of exit animations in PowerPoint?

To transition between different slide layouts.

To remove objects from the slides.

To emphasize important text or graphics.

To create interactive hyperlinks.

1 points

QUESTION 10

Explain how to use the table function to perform calculations in Excel?

The table function in Excel includes a special row called the "Total Row," which allows you to easily apply common calculations like sum, average, count, etc., to the columns in the table.

The table function in Excel provides pre-built formulas for common calculations, which can be accessed from a drop-down menu within the table.

You can also use functions like SUMIFS, AVERAGEIFS, COUNTIFS, etc., along with structured references, to perform calculations based on multiple criteria within the table.

To use the table function for calculations in Excel, you can simply create a formula in a cell within the table, referencing the appropriate column names in the formula. The table will automatically adjust the formula for all rows in the column.

1 points

QUESTION 11

Where on the ribbon would you click to change the background style of a Theme in a PowerPoint presentation?

Markerimage related to this question
Selected Coordinates 442, 8Clear
1 points

QUESTION 12

The image below shows the navigation pane of a document with different levels of headings. Which of the options provided is a second-level heading?



1. Recipe 1: Potato and onion

1.3 Method

2.3.2 Mash

3. Additional resources

1 points

QUESTION 13

When sorting data in Excel, which option arranges the data from largest to smallest?

Random

Ascending

Descending

Unique

1 points

QUESTION 14

Which of the following is a feature of the Function Builder in Excel?

It provides a real-time preview of the formula result as it is being constructed

It can only be used with built-in functions and not with user-defined functions

It is only available in older versions of Excel and not in newer versions

It replaces the need for using formulas and functions altogether

1 points

QUESTION 15

Read the following statement and indicate whether it is true or false:

When you insert a Watermark, it appears on all the pages in your document.

True

False

1 points

QUESTION 16

What is the purpose of the Quick Parts Gallery in Microsoft Word?

It provides a library of visual effects and animations for document elements.

It provides a gallery of pre-built document templates for various purposes.

It allows you to insert frequently used text or graphics into your documents.

It offers a collection of commonly used commands and shortcuts in Word

1 points

QUESTION 17

Which of the following chart types is best suited for showing the proportion or percentage distribution of different categories in Excel?

Scatter Plot

Bar Char

Radar Chart

Pie Chart

1 points

QUESTION 18

Where on the ribbon would you click to remove portions of an image change the size of an image you have inserted to PowerPoint?

Markerimage related to this question
Selected Coordinates 881, 35Clear
1 points

QUESTION 19

When using the Insert Object function, which option allows you to link an external file instead of embedding it into the worksheet?

Link to File

Create New

Display as Icon

Create from File

1 points

QUESTION 20

How can you delete an inserted object in Excel?

Select the object and press the Delete key

Resize the object to a very small size.

Use the "Delete" tab in the Excel ribbon.

Right-click the object and select "Delete."

1 points

QUESTION 21

Which option in Excel allows you to specify the data source and import settings when importing data from an external file?

Data Analysis

Power Query

Data Validation

Data Connection

1 points

QUESTION 22

Where would you click to customise and control slide transitions in PowerPoint?

Markerimage related to this question
Selected Coordinates 77, 0Clear
1 points

QUESTION 23

After creating a graph in PowerPoint, where on the ribbon would you click to change the values in the graph?

Markerimage related to this question
Selected Coordinates 23, 33Clear
1 points

QUESTION 24

Where on the ribbon would you find the Navigation Pane.

Markerimage related to this question
Selected Coordinates 493, 9Clear
1 points

QUESTION 25

How can you identify locked cells in Excel?

Locked cells are formatted with a different font style.

Locked cells are displayed in a separate worksheet tab.

Locked cells are highlighted with a specific colour.

Locked cells have a lock icon displayed next to them.

1 answer

1 points