Font size
WorksheetsICT Quiz Grade VI and VIII
Total questions: 100
Worksheet time: 57mins
What is the name of this device ?
Floppy Disc
USB
Hard Disk
CD
What is the name of this device ?
Floppy Disc
USB
Hard Disk
CD
What is the name of this device ?
Floppy Disc
PEN DRIVE
Hard Disk
CD
What is the name of this device ?
Floppy Disc
USB
DVD
CD
What is the name of this device ?
Floppy Disc
USB
DVD
CD
What are these ?
(a)
What is the name of this group ?
(a)
What is the name of this element ?
(a)
The following shows ____________icon.
File
Folder
The following shows ____________icon.
File
Folder
What is =COUNTA function?
counts the number of cells that are not empty.
counts the number of cells that contain a number.
counts the number of cells in a range, that meets a given criteria.
counts the number of cells that are empty.
Formulas in Excel must begin with _________________ symbol.
!
@
#
=
How many rows are there in ms excel
16,384
1,456,671
1048577
1,048,576
1) Which cell is selected in this picture?
B2
B3
C3
m3
?
B1
B2
B3
6. What does every formula in MS EXCEL start with?
+
=
-
*
9. Microsoft Excel is categorized as a ________________ software.
Database
Presentation
Spreadsheet
Word Processing
Which is the correct example for formula data
=5+10
A1+B1=
=A1B1
The currently selected cell is also called as an active cell.
False
True
What is the intersection of a column and a row on a worksheet called ?
Column
Row
Cell
Address
Short Cut Key to Underline
Ctrl+L
Ctrl+U
Ctrl+E
Shortcut Key to make Italics
Ctrl+I
Ctrl+L
Ctrl+H
Short Cut to Make Bold
Ctrl+J
Ctrl+B
Ctrl+T
Short Cut Key for Paste
Ctrl+U
Ctrl+V
Ctrl+P
Short Cut Key for Print
Crtl+I
Ctrl+L
Ctlr+P
Short Cut Key to Cut
Ctrl+D
Ctrl+F
Ctrl+X
Short Cut key to Open old document
Ctrl+N
Ctrl+O
Ctrl+P
Short Cut key for Save AS
Ctrl+Shift+S
Ctrl+S
F12
Short Cut key to save a document
Ctrl+S
Ctrl+A
Ctrl+V
56 + 30
String
Integer
Float
Number
"89"
String
Integer
Float
Number
56.867
String
Integer
Float
Decimal
45
String
Integer
Float
Number
"hello"
String
Integer
Float
Word
What is the data type used to represent text in Python?
integer
character
string
boolean
What is the result of '5 + 3' in Python?
10
7
2
8
Which writes a message for the user?
input()
myVar="Hi"
print("Hello!")
max=100
Which value is a Float?
64
"cat"
True
0.5
What is a Float?
A data type that contains whole numbers. eg: 3, 45, 124
Numbers with decimal point. eg: 0.5, 2.45, 56.04
Group of characters between quotation marks. eg: "dog"
Data type that can only be True or False.
Which value is an Integer?
64
"cat"
True
0.5
What is an Integer?
A data type that contains whole numbers. eg: 3, 45, 124
Numbers with decimal point. eg: 0.5, 2.45, 56.04
Group of characters between quotation marks. eg: "dog"
Data type that can only be True or False.
Which value is a String?
64
"cat"
True
0.5
print(9/3)
print("3+4")
print(3+4)
Look at the following code:
age = input ("What is your age? ")
age = age + 1
print (age)
If the user inputs 23, what is the result of the code?
23
24
age
an error message
Look at the following code:
age = "23"
age = age + 1
print (age)
What is the result of this code?
23
24
23 + 1
an error message
Look at the following code:
age = 23
age = age * 2
print (age)
What is printed?
23
23 * 2
25
46
What are Strings?
a type of data that represents text. In both Python and JavaScript, strings are represented by text inside quotes.
A character or thing that can perform actions.
the rules for correct spelling, grammar, and punctuation in a programming language.
An action performed by an object.
What is Basic syntax?
a step-by-step set of instructions for completing a task.
a type of data that represents text. In both Python and JavaScript, strings are represented by text inside quotes.
Repeat a block of code a certain number of times.
the rules for correct spelling, grammar, and punctuation in a programming language.
Spot the mistake, and pick the correct answer.
What will this code output if we call divide(10,5) ?
The output of the program
x = 4
x = "Sally"
print(x)
four
Saly
Sally
Python language use
upper case letters
lower case letters
upper and lower case letters
Code for Hello, World!
print Hello, World!
print("Hello, World!)
print("Hello, World!")
# is used to :
enter text to a program
enter a number to a program
enter comments to a program
# is used to :
enter text to a program
enter a number to a program
enter comments to a program
Code for Hello, World!
print Hello, World!
print("Hello, World!)
print("Hello, World!")
It displays an output
What will be the output?
name = "Dave"
print (name)
Dave
'Dave'
name
(name)
What is the shortcut to undo an action?
CTRL + Z
CTRL + S
CTRL + C
CTRL + P
What does email stand for?
Electric machine
Electro mail
Electro message
Electronic mail
What is ICT?
Integrating Communication Technology
Information Connecting Technology
Information Communication Technology
Information Communication Technique
How are ROWS in MS EXCEL spreadsheet named?
numbers
letters
cells
columns
Dawn is creating a formula to multiply the values in cells D4 and F4. Which formula should she use?
=D4+F4
=D4*F4
=D4 x F4
=D4-F4
Sandra is creating a formula to subtract the values in cells B4 and C4. Which formula should she use?
=B4+C4
=B4-C4
=B4*C4
=B4/C4
Text formulas:
a. Replace cell references
b. Return ASCII values of characters
c. Concatenate and manipulate text
d. Show formula error value
A worksheet range is a
a. A command used for data modeling
b. A range of values such as from 23 to 234
c. A group of cells
d. A group of worksheets
What function Is used to find the highest data ?
SUM
MIN
MAX
AVERAGE
What function is used to find the lowest data ?
MIN
MAX
SUM
AVERAGE
What do you mean by Active Cell in Ms-Excel?
A cell which is currently selected
A sheet which is currently selected
A workbook which is currently selected
A ___________________ is a collection of worksheets.
page
workbook
slide
Excel file is saved as a ____________
Document
workbook
worksheets
Presentation
In Ms Excel you can change the colour of the cell using Fill colour tool.
false
true
What is the solution:
=(24-16)÷8
Which operation is performed FIRST?
=(13 - 1) + 4
addition
subtraction
multiplication
In Excel, Rows are labeled as …..
1,2,3,....
A,B,C,....
In Excel, Cells are labeled as …..
A1,A2,A3,.....
1,2,3,4,....
A.B,C,....
Which area in an Excel window allows entering values and formulas?
Formula Bar
Menu Bar
Title Bar
Which function in Excel checks whether a condition is true or not?
IF
SUM
AVERAGE
How many sheets are there, by default, when we create a new Excel file?
3
10
5
What is the intersection of a column and a row on Excel sheet?
Value
Cell
Address
Microsoft Excel Program is used to :
Analyzing Data
Make Calculations
Both A & B
What does every formula in MS EXCEL start with?
+
-
=
*
What is a rectangular box in a MS EXCEL Spreadsheet called?
row
column
cell
The first cell in a worksheet is what?
A1
1A
FX
Cell Name
Which is NOT a term used in Excel?
Workbook
Worksheet
Cell
Document
A program using a table comprising of rows, columns and cells.
MS Word
MS PowerPoint
MS Outlook
MS Excel
Which leading computer software business create programs like Spreadsheet, word and PowerPoint?
Apple
DELL
Microsoft
Who crates Microsoft?
Bill Gates
Tom Bills
Mark Zuckerberg
Albert Einstein
