Section 1 of 2
End User Computing Second Continuous Assessment
MZUZU UNIVERSITY
FACULTY OF SCIENCE, TECHNOLOGY, AND INNOVATION
DEPARTMENT OF INFORMATION AND COMMUNICATION TECHNOLOGY
Name (Surname First)
Name (Surname First)
Question Type
Short answer
Paragraph
Multiple choice
Checkboxes
Dropdown
File upload
Linear scale
Rating
Multiple choice grid
Checkbox grid
Date
Time
Answer key
(0 points)
Loading...
Registration Number (Capital letters only)
Registration Number (Capital letters only)
Question Type
Short answer
Paragraph
Multiple choice
Checkboxes
Dropdown
File upload
Linear scale
Rating
Multiple choice grid
Checkbox grid
Date
Time
Answer key
(0 points)
Loading...
Programme of Study
Programme of Study
Question Type
Short answer
Paragraph
Multiple choice
Checkboxes
Dropdown
File upload
Linear scale
Rating
Multiple choice grid
Checkbox grid
Date
Time
1.
BACS
2.
BCHT
3.
BCUL
4.
BEDICT
5.
BICT
6.
BIO
7.
BIRD
8.
BISC
9.
BLMS
10.
BPDVC
11.
BPOL
12.
BSc. CHEM
13.
BSc. PHYSICS
14.
BSDS
15.
BSFS
16.
BSHM
17.
BSNM
18.
BSNMU
19.
BSTO
20.
BVAC
21.
DSS
22.
MATH
23.
OPTOMETRY
24.
TRANSFORMATIVE
25.
BAHHS
26.
BCHD
27.
BDEV
28.
BLET
29.
BSWRMD
30.
BBCM
31.
BSBS
32.
Add option
…
Answer key
(0 points)
Loading...
Section 2 of 2
Questions
Which of the following protocols is used for sending and receiving email?
Which of the following protocols is used for sending and receiving email?
Question Type
Short answer
Paragraph
Multiple choice
Checkboxes
Dropdown
File upload
Linear scale
Rating
Multiple choice grid
Checkbox grid
Date
Time
TCP
HTTP
SMTP
FTP
Add option
or
add "Other"
…
Answer key
(1 point)
Loading...
What does the term "SPAM" refer to in the context of email?
What does the term "SPAM" refer to in the context of email?
Question Type
Short answer
Paragraph
Multiple choice
Checkboxes
Dropdown
File upload
Linear scale
Rating
Multiple choice grid
Checkbox grid
Date
Time
Email encryption protocol
Email backup and recovery process
Email filtering technique
Unsolicited commercial email
Add option
or
add "Other"
…
Answer key
(1 point)
Loading...
Which of the following is not a commonly used web browser?
Which of the following is not a commonly used web browser?
Question Type
Short answer
Paragraph
Multiple choice
Checkboxes
Dropdown
File upload
Linear scale
Rating
Multiple choice grid
Checkbox grid
Date
Time
Java
Safari
Chrome
All of the above
Add option
or
add "Other"
…
Answer key
(1 point)
Loading...
What is the primary purpose of a firewall in the context of computer networks?
What is the primary purpose of a firewall in the context of computer networks?
Question Type
Short answer
Paragraph
Multiple choice
Checkboxes
Dropdown
File upload
Linear scale
Rating
Multiple choice grid
Checkbox grid
Date
Time
To prevent unauthorized access to a network
To enhance network speed and performance
To create virtual private networks (VPNs)
To store and organize network data
Add option
or
add "Other"
…
Answer key
(1 point)
Loading...
Which of the following is an example of a top-level domain?
Which of the following is an example of a top-level domain?
Question Type
Short answer
Paragraph
Multiple choice
Checkboxes
Dropdown
File upload
Linear scale
Rating
Multiple choice grid
Checkbox grid
Date
Time
.com
https
ip address
dns
Add option
or
add "Other"
…
Answer key
(1 point)
Loading...
Which of the following describes a network?
Which of the following describes a network?
Question Type
Short answer
Paragraph
Multiple choice
Checkboxes
Dropdown
File upload
Linear scale
Rating
Multiple choice grid
Checkbox grid
Date
Time
A global system of interconnected computer networks
A localized infrastructure connecting computers, devices, or resources
The physical cables and wires used for internet connectivity
A software application used for browsing the web
Add option
or
add "Other"
…
Answer key
(1 point)
Loading...
What is the main characteristic of a network?
What is the main characteristic of a network?
Question Type
Short answer
Paragraph
Multiple choice
Checkboxes
Dropdown
File upload
Linear scale
Rating
Multiple choice grid
Checkbox grid
Date
Time
It provides access to the internet.
It allows communication and resource sharing among connected devices.
It is limited to a single location or building.
It is managed and controlled by a central authority.
Add option
or
add "Other"
…
Answer key
(1 point)
Loading...
What is the purpose of a URL (Uniform Resource Locator) on the World Wide Web?
What is the purpose of a URL (Uniform Resource Locator) on the World Wide Web?
Question Type
Short answer
Paragraph
Multiple choice
Checkboxes
Dropdown
File upload
Linear scale
Rating
Multiple choice grid
Checkbox grid
Date
Time
To identify the location of a web server
To establish a secure connection between a browser and a server
To format the appearance of a webpage
To specify the address of a webpage or resource on the internet
Add option
or
add "Other"
…
Answer key
(1 point)
Loading...
What protocol is used for communication on the World Wide Web?
What protocol is used for communication on the World Wide Web?
Question Type
Short answer
Paragraph
Multiple choice
Checkboxes
Dropdown
File upload
Linear scale
Rating
Multiple choice grid
Checkbox grid
Date
Time
HTTP
DNS
TCP
IP Address
Add option
or
add "Other"
…
Answer key
(1 point)
Loading...
David wants to connect his smartphone to the internet while on the go. He has a cellular data plan. Which additional resource does David need to establish an internet connection?
David wants to connect his smartphone to the internet while on the go. He has a cellular data plan. Which additional resource does David need to establish an internet connection?
Question Type
Short answer
Paragraph
Multiple choice
Checkboxes
Dropdown
File upload
Linear scale
Rating
Multiple choice grid
Checkbox grid
Date
Time
SIM Card
WiFi
Ethernet Cable
Browser
Add option
or
add "Other"
…
Answer key
(1 point)
Loading...
Tayamika wants to connect his gaming console to the internet to play online multiplayer games. He has a wired broadband connection. Which additional resource does Alex need to establish an internet connection?
Tayamika wants to connect his gaming console to the internet to play online multiplayer games. He has a wired broadband connection. Which additional resource does Alex need to establish an internet connection?
Question Type
Short answer
Paragraph
Multiple choice
Checkboxes
Dropdown
File upload
Linear scale
Rating
Multiple choice grid
Checkbox grid
Date
Time
WiFi Adapter
Network Switch
HDMI CaBLE
Ethernet Cable
Add option
or
add "Other"
…
Answer key
(1 point)
Loading...
What is the purpose of hyperlinks on the World Wide Web?
What is the purpose of hyperlinks on the World Wide Web?
Question Type
Short answer
Paragraph
Multiple choice
Checkboxes
Dropdown
File upload
Linear scale
Rating
Multiple choice grid
Checkbox grid
Date
Time
To display images on a webpage
To play audio or video content
To navigate between webpages or resources
To encrypt sensitive data during transmission
Add option
or
add "Other"
…
Answer key
(1 point)
Loading...
Which of the following best describes a search engine?
Which of the following best describes a search engine?
Question Type
Short answer
Paragraph
Multiple choice
Checkboxes
Dropdown
File upload
Linear scale
Rating
Multiple choice grid
Checkbox grid
Date
Time
A software application for browsing the web.
A tool for organizing and managing bookmarks.
An online service for searching and discovering information on the web.
A protocol for transferring data between web servers and clients.
Add option
or
add "Other"
…
Answer key
(1 point)
Loading...
Which the following is NOT a disadvantage of sending unsolicited email attachments
Which the following is NOT a disadvantage of sending unsolicited email attachments
Question Type
Short answer
Paragraph
Multiple choice
Checkboxes
Dropdown
File upload
Linear scale
Rating
Multiple choice grid
Checkbox grid
Date
Time
Potential for triggering spam filters and being marked as spam.
Negative impact on the sender's reputation and credibility.
Enhanced efficiency in sharing large files.
Storage
Add option
or
add "Other"
…
Answer key
(1 point)
Loading...
Which of the following is an effective way to refine search results?
Which of the following is an effective way to refine search results?
Question Type
Short answer
Paragraph
Multiple choice
Checkboxes
Dropdown
File upload
Linear scale
Rating
Multiple choice grid
Checkbox grid
Date
Time
Including as many keywords as possible in the search query.
Limiting the search to a specific website or domain.
Ignoring spelling and grammar errors in the search query.
Conducting a broad search without any specific terms.
Add option
or
add "Other"
…
Answer key
(1 point)
Loading...
What is the role of Boolean operators in a web search?
What is the role of Boolean operators in a web search?
Question Type
Short answer
Paragraph
Multiple choice
Checkboxes
Dropdown
File upload
Linear scale
Rating
Multiple choice grid
Checkbox grid
Date
Time
They help perform boolean operations in web search
They allow for advanced mathematical calculations in the search.
They help refine the search
They redirect the search to other search engines.
Add option
or
add "Other"
…
Answer key
(1 point)
Loading...
The diagram below shows a high-level architecture of the University of Kwazulu-Natal's network.
Identify the type of network
Identify the type of network
The diagram below shows a high-level architecture of the University of Kwazulu-Natal's network.
Identify the type of network
Identify the type of network
Question Type
Short answer
Paragraph
Multiple choice
Checkboxes
Dropdown
File upload
Linear scale
Rating
Multiple choice grid
Checkbox grid
Date
Time
Loading image…
Local Area Network
Campus Area Nework
Ethernet Network
Wide Area Network
Add option
or
add "Other"
…
Answer key
(1 point)
Loading...
The diagram below shows an excel worksheet which calculates the ages of students based on their year of birth.
What will be the value if the formula in D2 is copied to E2
What will be the value if the formula in D2 is copied to E2
The diagram below shows an excel worksheet which calculates the ages of students based on their year of birth.
What will be the value if the formula in D2 is copied to E2
What will be the value if the formula in D2 is copied to E2
Question Type
Short answer
Paragraph
Multiple choice
Checkboxes
Dropdown
File upload
Linear scale
Rating
Multiple choice grid
Checkbox grid
Date
Time
Loading image…
20
-2003
24
-1983
Add option
or
add "Other"
…
Answer key
(1 point)
Loading...
The diagram below shows an excel worksheet with numerical data.
What will be the value if the formula in C1 is copied to D2
The diagram below shows an excel worksheet with numerical data.
What will be the value if the formula in C1 is copied to D2
Question Type
Short answer
Paragraph
Multiple choice
Checkboxes
Dropdown
File upload
Linear scale
Rating
Multiple choice grid
Checkbox grid
Date
Time
Loading image…
113
2
135
83
Add option
or
add "Other"
…
Answer key
(1 point)
Loading...
Which Excel function is used to find the position of a value within a range of cells?
Which Excel function is used to find the position of a value within a range of cells?
Question Type
Short answer
Paragraph
Multiple choice
Checkboxes
Dropdown
File upload
Linear scale
Rating
Multiple choice grid
Checkbox grid
Date
Time
MATCH
SEARCH
INDEX
LOOKUP
Add option
or
add "Other"
…
Answer key
(1 point)
Loading...
Which Excel feature allows you to create a dynamic chart that updates automatically based on the data range?
Which Excel feature allows you to create a dynamic chart that updates automatically based on the data range?
Question Type
Short answer
Paragraph
Multiple choice
Checkboxes
Dropdown
File upload
Linear scale
Rating
Multiple choice grid
Checkbox grid
Date
Time
Chart wizard
Chart styles
Chart filters
PivotChart
Add option
or
add "Other"
…
Answer key
(1 point)
Loading...
Which of the following is not a valid error type in Excel?
Which of the following is not a valid error type in Excel?
Question Type
Short answer
Paragraph
Multiple choice
Checkboxes
Dropdown
File upload
Linear scale
Rating
Multiple choice grid
Checkbox grid
Date
Time
#VALUE!
#REF!
#ERROR!
#DIV/0!
Add option
or
add "Other"
…
Answer key
(1 point)
Loading...
Which Excel feature allows you to create visually appealing representations of data?
Which Excel feature allows you to create visually appealing representations of data?
Question Type
Short answer
Paragraph
Multiple choice
Checkboxes
Dropdown
File upload
Linear scale
Rating
Multiple choice grid
Checkbox grid
Date
Time
Conditional formatting
Sparklines
Data Validation
Goal seek
Add option
or
add "Other"
…
Answer key
(1 point)
Loading...
What type of chart is used for comparing values over categories?
What type of chart is used for comparing values over categories?
Question Type
Short answer
Paragraph
Multiple choice
Checkboxes
Dropdown
File upload
Linear scale
Rating
Multiple choice grid
Checkbox grid
Date
Time
Pie Chart
Bar Chart
Line Chart
Column charts
Add option
or
add "Other"
…
Answer key
(1 point)
Loading...
Which Excel function is used to find the highest value in a range and return its corresponding cell address?
Which Excel function is used to find the highest value in a range and return its corresponding cell address?
Question Type
Short answer
Paragraph
Multiple choice
Checkboxes
Dropdown
File upload
Linear scale
Rating
Multiple choice grid
Checkbox grid
Date
Time
VLOOKUP
HLOOKUP
MAX
INDEX
Add option
or
add "Other"
…
Answer key
(1 point)
Loading...
If the formula =$D3 is in B3 and is copied to G3. What will be the new formula in G3?
If the formula =$D3 is in B3 and is copied to G3. What will be the new formula in G3?
Question Type
Short answer
Paragraph
Multiple choice
Checkboxes
Dropdown
File upload
Linear scale
Rating
Multiple choice grid
Checkbox grid
Date
Time
=$D3
=$G3
=$I3
=$B3
Add option
or
add "Other"
…
Answer key
(1 point)
Loading...
From the table below, what formula must be entered in D2 to find the total price apple?
From the table below, what formula must be entered in D2 to find the total price apple?
Question Type
Short answer
Paragraph
Multiple choice
Checkboxes
Dropdown
File upload
Linear scale
Rating
Multiple choice grid
Checkbox grid
Date
Time
Loading image…
B2C2
B1*C1
B2*C2
None
Add option
or
add "Other"
…
Answer key
(1 point)
Loading...
What is the shortcut key to create a new worksheet in Excel?
What is the shortcut key to create a new worksheet in Excel?
Question Type
Short answer
Paragraph
Multiple choice
Checkboxes
Dropdown
File upload
Linear scale
Rating
Multiple choice grid
Checkbox grid
Date
Time
Ctrl+F11
Ctrl+N
Ctrl+Shift+N
Shift + F11
Add option
or
add "Other"
…
Answer key
(1 point)
Loading...
Which type of chart is most suitable for visualizing trends over time?
Which type of chart is most suitable for visualizing trends over time?
Question Type
Short answer
Paragraph
Multiple choice
Checkboxes
Dropdown
File upload
Linear scale
Rating
Multiple choice grid
Checkbox grid
Date
Time
Bar chart
Line chart
Pie chart
Scatter plot
Add option
or
add "Other"
…
Answer key
(1 point)
Loading...
What chart element displays the overall title or description of a chart?
What chart element displays the overall title or description of a chart?
Question Type
Short answer
Paragraph
Multiple choice
Checkboxes
Dropdown
File upload
Linear scale
Rating
Multiple choice grid
Checkbox grid
Date
Time
Axis
Legend
Data labels
Title
Add option
or
add "Other"
…
Answer key
(1 point)
Loading...
How do you specify a relative cell reference in a formula?
How do you specify a relative cell reference in a formula?
Question Type
Short answer
Paragraph
Multiple choice
Checkboxes
Dropdown
File upload
Linear scale
Rating
Multiple choice grid
Checkbox grid
Date
Time
By using the $ symbol before the column letter
By using the $ symbol before the row number
By using the $ symbol before both the column letter and the row number
By not using the $ symbol
Add option
or
add "Other"
…
Answer key
(1 point)
Loading...
What does the VLOOKUP function do in Excel
What does the VLOOKUP function do in Excel
Question Type
Short answer
Paragraph
Multiple choice
Checkboxes
Dropdown
File upload
Linear scale
Rating
Multiple choice grid
Checkbox grid
Date
Time
Calculates the square root of a number
Retrieves a corresponding value from a table based on a lookup value
Divides a number by another number
Adds up the values in a range of cells
Add option
or
add "Other"
…
Answer key
(1 point)
Loading...
How can you sort data in an Excel table based on multiple columns?
How can you sort data in an Excel table based on multiple columns?
Question Type
Short answer
Paragraph
Multiple choice
Checkboxes
Dropdown
File upload
Linear scale
Rating
Multiple choice grid
Checkbox grid
Date
Time
Select the columns you want to sort, go to the "Data" tab, and click on "Sort."
Use the "Sort" function in the formula bar and specify the columns and sorting order.
Right-click on the table, choose "Sort," and specify the sorting criteria for each column.
Select the table, go to the "Home" tab, and use the "Sort & Filter" button to specify the sorting criteria.
Add option
or
add "Other"
…
Answer key
(1 point)
Loading...
Which of the following functions is used to count the number of cells in a range that contain a numeric value?
Which of the following functions is used to count the number of cells in a range that contain a numeric value?
Question Type
Short answer
Paragraph
Multiple choice
Checkboxes
Dropdown
File upload
Linear scale
Rating
Multiple choice grid
Checkbox grid
Date
Time
=COUNT()
=COUNTA()
=COUNTBLANK()
COUNTIF()
Add option
or
add "Other"
…
Answer key
(1 point)
Loading...
Which of the following methods cannot be used to enter data in excel?
Which of the following methods cannot be used to enter data in excel?
Question Type
Short answer
Paragraph
Multiple choice
Checkboxes
Dropdown
File upload
Linear scale
Rating
Multiple choice grid
Checkbox grid
Date
Time
Presing an arrow key
Pressing the tab key
Pressing the Esc key
None of the above
Add option
or
add "Other"
…
Answer key
(1 point)
Loading...
From the formula given below, what will be shown in C1?
From the formula given below, what will be shown in C1?
Question Type
Short answer
Paragraph
Multiple choice
Checkboxes
Dropdown
File upload
Linear scale
Rating
Multiple choice grid
Checkbox grid
Date
Time
Loading image…
Yes
No
Female
None
Add option
or
add "Other"
…
Answer key
(1 point)
Loading...
What types of formatting can be applied using conditional formatting in Excel?
What types of formatting can be applied using conditional formatting in Excel?
Question Type
Short answer
Paragraph
Multiple choice
Checkboxes
Dropdown
File upload
Linear scale
Rating
Multiple choice grid
Checkbox grid
Date
Time
Font style, column width, and row height
Borders, cell alignment, and text orientation
Font color, fill color, and number format
Cell protection, sheet tab color, and workbook password
Add option
or
add "Other"
…
Answer key
(1 point)
Loading...
Which type of conditional formatting is shown in this picture?
Which type of conditional formatting is shown in this picture?
Question Type
Short answer
Paragraph
Multiple choice
Checkboxes
Dropdown
File upload
Linear scale
Rating
Multiple choice grid
Checkbox grid
Date
Time
Loading image…
Highlight cell rules
Color Scale
Data bars
Jamaican Scale
Add option
or
add "Other"
…
Answer key
(1 point)
Loading...
Which conditional formatting is applied on the data ?
Which conditional formatting is applied on the data ?
Question Type
Short answer
Paragraph
Multiple choice
Checkboxes
Dropdown
File upload
Linear scale
Rating
Multiple choice grid
Checkbox grid
Date
Time
Loading image…
A Box Format
Data Bars
Color Scale
Icon Sets
Add option
or
add "Other"
…
Answer key
(1 point)
Loading...
In which type of Conditional formatting options you will find in this dialog box ?
In which type of Conditional formatting options you will find in this dialog box ?
Question Type
Short answer
Paragraph
Multiple choice
Checkboxes
Dropdown
File upload
Linear scale
Rating
Multiple choice grid
Checkbox grid
Date
Time
Loading image…
Manage Rules
Highlight Cell Rules
Top/Bottom Rules
Greater Than Rules
Add option
or
add "Other"
…
Answer key
(1 point)
Loading...
Link to Sheets
Summary
Question
Individual
Insights
Total points distribution
Loading...
Settings
Release grades
Respondent settings
Global quiz defaults
Default question point value
Point values for every new question
Responses
Manage how responses are collected and protected
Presentation
Manage how the form and responses are presented
Defaults
Form defaults
Settings applied to this form and new forms
Question defaults
Settings applied to all new questions