WorksheetsICT QUIZ
Total questions: 196
Worksheet time: 2hrs 46mins
Which of the following is an example of intellectual property?
Inventions
Ideas
Artwork
All of the above
Identify this trademark slogan with its appropriate company:
"I'm Lovin' It"
Burger King
Wendy's
McDonalds
Hardee's
Computing ethics is a set of
Technologies
Legal issues
Moral Principles
URL, that's a secure connection
https://
https
htps//
Anything created in original by an individual is called
Owner's property
Internet Property
Intellectual Property
If someone encroaches your private domain in the digital world the falls under
cyber crime
Ethics
Internet issues
People those commits crime in the digital world is known as
criminals
thieves
cyber criminals
Netiqutte For New Users are known as:
Professional
Newbies
Starters
What is Phishing?
It is a type of fraud that involves using someone else's identity to steal money or gain other benefits
This type of fraud involves three parties the fraudster, the unsuspecting legitimate shopper and the ecommerce store.
It is a method of tricking you into sharing passwords, credit card numbers, and other sensitive information by posing as a trusted institution in an email
Ethics is a set of (a) Principles that govern the behaviour of a group or Individual.
Which of the Following is NOT rules that users must Follow while in Online:
Do NOT shout
Do not consult FAQ'S
Be Careful With jokes
Avoid Flaming
Encrypt the Code:"EADGT GVJKEU"
Rules
All the Correct letters are 2 letter Backwards
Eg: C it will Be A
Cyber Ethers
Cyber Fraud
Cyber Control
Cyber Ethics
What Is Algorithm
The conversion of encrypted data into its original form
It is the method by which information is converted into secret code that hides the information's true meaning
a process or set of rules to be followed in calculations or other problem-solving operations, especially by a computer.
A _________________ is a mathematical technique used to validate the authenticity and integrity of a message, software or digital document.
Digital Signature
Encryption
Digital certificate
Decryption
which distinguishes products
or services of a particular trader from the similar products or services of other traders
An Excel spreadsheet is primarily used for calculating which of the following options
A. Data
B. Finances
C. Numbers
D. All of the above
Which of the following option is a formula?
A. =SUM(A1:A5)
B. Add A1 - A5
C. Subtract the numbers
D. A1 = A5
All formulas in Excel begin with the following symbol
A. +
B. =
C. %
D. #
1. Which of the following is an absolute cell reference?
a. !A!1
b. $A$1
c. #a#1
d. A1
Which button do you click to add up a series of numbers?
a. The autosum button
b. The Formula button
c. The quicktotal button
d. The total button
In the order of operations, which of the following comes first?
a.Multiplication
b.Operations involving large numbers
c.Exponential calculations
d.Operations enclosed in parentheses
Suppose you want to copy a formula while keeping one of the cell references locked on the same cell. Which of the following would you use?
a. Absolute reference
b. ReferenceLock
c. PivotTable
d. Relative reference
Which function can find the highest value in a cell range?
a. MAXVALUE
b. HIGHEST
c. TOP
d. MAX
When you copy a formula
a. Excel erases the original copy of the formula
b.Excel edits cell references in the newly copied formula
c.Excel adjusts absolute cell references
d. Excel doesn’t adjust relative cell references
In MS-Excel value used in a formula that does not change is called a
A.Cell address
B.Constant
C.Function
D.None of these
If you copy the formula =$B38 into another cell, the result will be:
a. The column part will remain the same
b. The row part will remain the same
c. Both the column and row will remain the same
d. Both will change
Which of the following is not a function of MS - Excel?
a. AVERAGE
b. ADD
C.MIN
d. MAX
What are predefined formulae in MS - Excel called?
a.Range
b.Parentheses
c.Operators
d.Function
Which error is obtained when a formatted number does not fit within a cell?
a.#####
b.#DIV/0
c.#DIV@
d.#VALUE!
Formula palette is used to ?
a.format cells containing numbers
b.create and edit formulas containing functions
c.entered assumptions data
d.copy all cells
What are the two common functions in Math & Trig category?
a. LCM & HCF
b.LCM & GCD
c..HCF & GCD
d. Insert function
An Excel spreadsheet is primarily used for calculating which of the following options
A. Data
B. Finances
C. Numbers
D. All of the above
What is the Sum formula?
Sum( )
Sum( )=
=Sum( )
=( )Sum
When starting a formula what is the first thing you type in the cell?
;
?
%
=
Which formula gets the biggest value of a range of cells?
MAX
MIN
SHORT
SUM
Which formula gets the smallest value of a range of cells?
MAX
MIN
SMALL
SUM
Formulas can be copied to adjacent cells with the ____________.
Fill handle
PgDn Key
Function key F4
None of the above
The predefined commands that perform some particular operations quickly are known as __________
Sorting
Function
Filtering
Formatting
Every functions have two parts: function name and ___________
operators
equal sign
cell address
arguments
Every cell has a name called its ______
address
range
value
function
Which one is a statistical function?
POWER
PRODUCT
QUOTIENT
SUM
_________ function displays the current date.
=DATE( )
=DAY( )
=TODAY( )
=TODATE( )
What will be the output of =LEN("COMPUTER SCIENCE") ?
15
16
17
18
If the value of A1 is 17, then what will be the output of the given statement.
=IF(A1>18, "PASS" , "FAIL" )
"PASS"
"TRUE"
"FAIL"
"FALSE"
All function must always begin with a/an _________ sign.
$
&
=
:
AVERAGE,MAX and MIN are the _______ functions.
Logical
Statistical
Text
Math
In ___________ referencing both column part and row part are not fixed.
Relative
Absolute
Mixed
None of these
Which one is not a Function in MS Excel ?
SUM
AVG
MAX
MIN
What is the intersection of a column and a row on a worksheet called ?
Cell
Column
Address
Which function in Excel tells how many numeric entries are there ?
NUM
COUNT
SUM
CHKNUM
In Excel, which one denoted a range from B1 through E5
B1 - E5
B1:E5
B1 to E5
B1$E5
WHAT TYPE OF FUNCTION IS USED IN THIS IMAGE?
AVERAGE
SUM
PRODUCT
MAX
Which of the following option is a formula?
A. =SUM(A1:A5)
B. Add A1 - A5
C. Subtract the numbers
D. A1 = A5
Concatenation of text can be done using
a. Apostrophe
b. Exclamation (!)
c. Hash (#)
d. Ampersand (&)
A circular reference is
a. Geometric modeling tool
b. A cell that points to a drawing object
c. A formula that either directly or indirectly depends on itself
d. Always erroneous
Which button do you click to add up a series of numbers?
a. The autosum button
b. The Formula button
c. The quicktotal button
d. The total button
Suppose you want to copy a formula while keeping one of the cell references locked on the same cell. Which of the following would you use?
a. Absolute reference
b. ReferenceLock
c. PivotTable
d. Relative reference
Which function can find the highest value in a cell range?
a. MAXVALUE
b. HIGHEST
c. TOP
d. MAX
If you copy the formula =$B38 into another cell, the result will be:
a. The column part will remain the same
b. The row part will remain the same
c. Both the column and row will remain the same
d. Both will change
Which of the following is not a function of MS - Excel?
a. AVERAGE
b. ADD
C.MIN
d. MAX
What are predefined formulae in MS - Excel called?
a.Range
b.Parentheses
c.Operators
d.Function
Which error is obtained when a formatted number does not fit within a cell?
a.#####
b.#DIV/0
c.#DIV@
d.#VALUE!
To obtain the value of the Range in a set of numeric data, I need to obtain the data of the greater and lesser number and I can obtain them with the functions ...
MAX and COUNT
COUNTA and MIN
MAX and MIN
COUNT and COUNTA
Allows you to evaluate a condition to determine if it is false or true. This function is a great help to take decisions based on the result.
AND
NOT
OR
IF
print("Hello world!")
print(3+4)
What would this print?
print("3+4")
Print("Hello world!")
print("Hello" + "world" + "today")
print(Hello world!)
print(9/3)
print(3+4)
print("3+4")
print(3*4+5)
Which of these is a string?
42
True
"This one!"
No, this one
What will this program do?
print("Hello world")
Output Hello world
Error
Output "Hello world
Output print
Which operator can be used to compare two values?
=
<>
><
==
What is the correct file extension for Python files?
.py
.pt
.pyt
.pyth
Which one is NOT a legal variable name?
my_var
myvar
_myvar
my-var
How do you insert COMMENTS in Python code?
/*this is a comment
//this is a comment
#this is a comment
What is a correct syntax to output "Hello World" in Python?
echo("Hello World")
echo "Hello World"
print("Hello World")
PRINT("Hello World")
How do you create a variable with the numeric value 5?
Both are correct
x=5
x=int(5)
If num1 = 5
num2 = 6
then what will be the output of num1*num2
11
6
30
-1
What symbol do you use to make a comment in Python?
@
:
;
#
Which operator checks if a value is equal to another value?
+
-
==
!=
If p=25 , what is p**2?
50
125
600
625
Arithmetic Operator
What is a * ?
Addition
Subtraction
Multiplication
Division
The result of 10%2 will be :
1
5
2
0
What will be the result of
print(5*4)
20
5
4
16
What will be the result of:
print(12/5)
2.1
4.2
0
2.4
What will the output be from the following code?
print(3+4)
3+4
7
print(3+4)
Syntax error
Symbol used for finding the remainder after dividing
+
-
/
%
What is the first thing we have to write in the code
(a)
how to create a table
<td>
</tc>
<table>
<tr>
What does HTML stand for ?
Hiper text markup language
Hiperlink and text markup language
home tool markup language
Choose the correct HTML element for the largest heading:
<head>
<h6>
<h1>
<heading>
What is the correct HTML element for inserting a line break?
<br>
<break>
<lb>
What is the correct HTML for creating a hyperlink?
<a href="https://www.google.com/">Google</a>
<a> href="https://www.google.com/"Google</a>
<a href="https://www.google.com/"></a>
Which character is used to indicate an end tag?
/
^
*
<
Which of these elements are all <table> elements?
<table><tr><td>
<table><head><tfoot>
<table><tr><tt>
<thead><body><tr>
What is the correct HTML for inserting an image?
<img href="image.gif" alt="MyImage">
<image src="image.gif" alt="MyImage">
<img alt="MyImage">image.gif</img>
<img src="image.gif" alt="MyImage">
Which HTML element defines the title of a document?
<meta>
<title>
<head>
HTML stands for...
Hyper Time Multiple Language
Hyper Text Mark-up Language
Hippo T-Rex Mascot Lemur
Hipper Text Make Language
Which is the proper way to write an h1 tag
<h1>Hello</h1>
<h1>"Hello
{h1}Hello{/h1}
<h1>Hello<h1>
<p> tag is for...
Page of Text
Picture
Paragraph of text
Pineapples
What does a opening tag look like?
< >
</ >
<< >>
<
What does a closing tag look like?
< >
<\ >
</ >
<< >>
What should a HTML web page start with?
<b>
<li>
<html>
<start>
What should a HTML web page end with?
</html>
<head>
</end>
</body>
What does this tag stand for? <b>
bright
big
beautiful
bold
HTML stand for
Hyperlinks and Text Markup Language
Hyper Text Markup Language
Home Tool Markup Language
Hyper Text Markup Link
Who is making the Web standards?
Mozilla
Microsoft
World Wide Web Consortium
HTML tag for the largest heading
<h1>
<h6>
<head>h1<head>
<heading>h6<heading>
HTML tag for inserting a line break
<break />
<lb />
<br />
<linebreak />
HTML tag to make a text bold
<b>
<bold>
<textbold>
<boldtext>
HTML tag for creating a hyperlink
<a>http://www.sample.com</a>
<a name=http://www.sample.com> Sample.com </a>
<a url=http://www.sample.com> Sample.com </a>
<a herf=http://www.sample.com> Sample </a>
Which of these tags are all <table> tags?
<table><tr><td>
<table><tr><tt>
<thead><body><tr>
<table><head><tfoot>
How can you make a list that lists the items with numbers? (1,2,... i,ii,.... I,II,...)
<ul>
<list>
<li>
<ol>
What is the correct HTML for making a checkbox?
<checkbox>
<input type="check" />
<input type="checkbox" />
<check>
HTML tag for inserting an image
<img src="image.gif" alt="MyImage" />
<img href="image.gif" alt="MyImage" />
<image src="image.gif" alt="MyImage" />
<img alt="MyImage">image.gif</img>
What is the primary purpose of Data Science?
To manage social media accounts
To extract knowledge and insights from data
To create artistic designs
To develop video games
Point out the correct statement:
Raw data is original source of data
Preprocessed data is original source of data
Raw data is the data obtained after processing steps
None of the Mentioned
(a) is a domain of AI related to data systems and processes, in which the system collects numerous data, maintains data sets and derives meaning/sense out of
them.
Domain of the game Rock Paper Scissors is
NLP
Data Science
Computer Vision
Which of the following is not an AI application?
Google Maps
Writing suggestion in gmail
Face Recognition
Kahoot
Alexa is an example of _____________________ domain
Natural Language Processing
Machine Learning
Computer Vision
The ability of a computer to understand human language is called
NLP
Computer Vision
Medical Science
Voice to text is considered as
NLP
Computer Vision
Which of these is NOT an AI technology
Facial recognition
Image recognition
Robotics
Animation
NLP stands for Natural Language Processing.
True
False
2. NLP is concerned with the interactions between computers and human (natural) languages.
TRUE
FALSE
NOT SURE
Which one of the following is keyword Normalization techniques in NLP
Stemming
Part of Speech
Named entity recognition
Lemmatization
In NLP, The process of removing words like “and”, “is”, “a”, “an”, “the” from a sentence is called as
Stemming
Lemmatization
Stop word
All of the above
In NLP, The process of converting a sentence or paragraph into tokens is referred to as Stemming
True
False
In NLP, The process of identifying people, an organization from a given sentence, paragraph is called
Stemming
Lemmatization
Stop word removal
Named entity recognition
Which one of the following is not a pre-processing technique in NLP
Stemming and Lemmatization
converting to lowercase
removing punctuations
removal of stop words
Sentiment analysis
What is full form of NLG?
(a)
How many Components of NLP are there?
(a)
What is full form of NLU?
(a)
Choose the option(s) that best explains the following task: Given a sound clip of a person or people speaking, determine the textual representation of the speech.
Speech-to-text
Speech Synthesis
Speech Recognition
Text-to-speech
All of the above
Which are common words usually removed in an NLP analysis?
Tokenization
Corpus
Ngrams
Stopwords
Which of the following techniques can be used for keyword normalization in NLP, the process of converting a keyword into its base form?
N-grams
Cosine Similarity
Soundex
Lemmatization
Which of the following is a branch of computer science, particularly Artificial Intelligence (AI), concerned with teaching computers to interpret and process human language?
Machine Learning
Expert System
Human Computer Interaction
Natural Language Processing
What is the purpose of sentiment analysis in natural language processing?
To translate a text from one language to another
To determine the tone or emotion expressed in a text
To identify the author of a text
To summarize the main points of a text
Which of the following is not a primary task of NLP?
Named Entity Recognition
Text Classification
Image Recognition
Sentiment Analysis
am i goated?
yea
ofc
nah ur cooked
yes
