wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

ICT Quiz Grade VI and VIII

Total questions: 100

Worksheet time: 57mins

Name
Class
Date
1.

What is the name of this device ?

a)

Floppy Disc

b)

USB

c)

Hard Disk

d)

CD

2.

What is the name of this device ?

a)

Floppy Disc

b)

USB

c)

Hard Disk

d)

CD

3.

What is the name of this device ?

a)

Floppy Disc

b)

PEN DRIVE

c)

Hard Disk

d)

CD

4.

What is the name of this device ?

a)

Floppy Disc

b)

USB

c)

DVD

d)

CD

5.

What is the name of this device ?

a)

Floppy Disc

b)

USB

c)

DVD

d)

CD

6.

What are these ?

(a)  

7.

What is the name of this group ?

(a)  

8.

What is the name of this element ?

(a)  

9.

The following shows ____________icon.

a)

File

b)

Folder

10.

The following shows ____________icon.

a)

File

b)

Folder

11.

What is =COUNTA function?

a)

counts the number of cells that are not empty.

b)

counts the number of cells that contain a number.

c)

counts the number of cells in a range, that meets a given criteria.

d)

counts the number of cells that are empty.

12.

Formulas in Excel must begin with _________________ symbol.

a)

!

b)

@

c)

#

d)

=

13.

How many rows are there in ms excel

a)

16,384

b)

1,456,671

c)

1048577

d)

1,048,576

14.

1) Which cell is selected in this picture?

a)

B2

b)

B3

c)

C3

d)

m3

15.

?

a)

B1

b)

B2

c)

B3

16.

6. What does every formula in MS EXCEL start with?

a)

+

b)

=

c)

-

d)

*

17.

9. Microsoft Excel is categorized as a ________________ software.

a)

Database

b)

Presentation

c)

Spreadsheet

d)

Word Processing

18.

Which is the correct example for formula data

a)

=5+10

b)

A1+B1=

c)

=A1B1

19.

The currently selected cell is also called as an active cell.

a)

False

b)

True

20.

What is the intersection of a column and a row on a worksheet called ?

a)

Column

b)

Row

c)

Cell

d)

Address

21.
ALT + F4
a)
Quick exit
b)
Save
c)
Insert image
d)
Screenshot
22.

Short Cut Key to Underline

a)

Ctrl+L

b)

Ctrl+U

c)

Ctrl+E

23.

Shortcut Key to make Italics

a)

Ctrl+I

b)

Ctrl+L

c)

Ctrl+H

24.

Short Cut to Make Bold

a)

Ctrl+J

b)

Ctrl+B

c)

Ctrl+T

25.

Short Cut Key for Paste

a)

Ctrl+U

b)

Ctrl+V

c)

Ctrl+P

26.

Short Cut Key for Print

a)

Crtl+I

b)

Ctrl+L

c)

Ctlr+P

27.

Short Cut Key to Cut

a)

Ctrl+D

b)

Ctrl+F

c)

Ctrl+X

28.

Short Cut key to Open old document

a)

Ctrl+N

b)

Ctrl+O

c)

Ctrl+P

29.

Short Cut key for Save AS

a)

Ctrl+Shift+S

b)

Ctrl+S

c)

F12

30.

Short Cut key to save a document

a)

Ctrl+S

b)

Ctrl+A

c)

Ctrl+V

31.

56 + 30

a)

String

b)

Integer

c)

Float

d)

Number

32.

"89"

a)

String

b)

Integer

c)

Float

d)

Number

33.

56.867

a)

String

b)

Integer

c)

Float

d)

Decimal

34.

45

a)

String

b)

Integer

c)

Float

d)

Number

35.

"hello"

a)

String

b)

Integer

c)

Float

d)

Word

36.

What is the data type used to represent text in Python?

a)

integer

b)

character

c)

string

d)

boolean

37.

What is the result of '5 + 3' in Python?

a)

10

b)

7

c)

2

d)

8

38.

Which writes a message for the user?

a)

input()

b)

myVar="Hi"

c)

print("Hello!")

d)

max=100

39.

Which value is a Float?

a)

64

b)

"cat"

c)

True

d)

0.5

40.

What is a Float?

a)

A data type that contains whole numbers. eg: 3, 45, 124

b)

Numbers with decimal point. eg: 0.5, 2.45, 56.04

c)

Group of characters between quotation marks. eg: "dog"

d)

Data type that can only be True or False.

41.

Which value is an Integer?

a)

64

b)

"cat"

c)

True

d)

0.5

42.

What is an Integer?

a)

A data type that contains whole numbers. eg: 3, 45, 124

b)

Numbers with decimal point. eg: 0.5, 2.45, 56.04

c)

Group of characters between quotation marks. eg: "dog"

d)

Data type that can only be True or False.

43.

Which value is a String?

a)

64

b)

"cat"

c)

True

d)

0.5

44.
A data type consisting of numbers, letters and symbols.
a)
String
b)
Integer
c)
Float
d)
Boolean
45.
What will the output be from the following code?
print(9/3)
a)
3
b)
3.0
c)
9/3
d)
SyntaxError
46.
What will the output be from the following code?
print("3+4")
a)
7
b)
3+4
c)
34
d)
SyntaxError
47.
What will the output be from the following code?
print(3+4)
a)
3+4
b)
7
c)
SyntaxError
d)
print(3+4)
48.

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?

a)

23

b)

24

c)

age

d)

an error message

49.

Look at the following code:

age = "23"

age = age + 1

print (age)


What is the result of this code?

a)

23

b)

24

c)

23 + 1

d)

an error message

50.

Look at the following code:

age = 23

age = age * 2

print (age)


What is printed?

a)

23

b)

23 * 2

c)

25

d)

46

51.

What are Strings?

a)

a type of data that represents text. In both Python and JavaScript, strings are represented by text inside quotes.

b)

A character or thing that can perform actions.

c)

the rules for correct spelling, grammar, and punctuation in a programming language.

d)

An action performed by an object.

52.

What is Basic syntax?

a)

a step-by-step set of instructions for completing a task.

b)

a type of data that represents text. In both Python and JavaScript, strings are represented by text inside quotes.

c)

Repeat a block of code a certain number of times.

d)

the rules for correct spelling, grammar, and punctuation in a programming language.

53.

Spot the mistake, and pick the correct answer.

a)

b)

c)

d)

54.

What will this code output if we call divide(10,5) ?

a)
2.0
b)
5.0
c)
10.0
d)
0.5
55.

The output of the program

x = 4

x = "Sally"

print(x)

a)

four

b)

Saly

c)

Sally

56.

Python language use

a)

upper case letters

b)

lower case letters

c)

upper and lower case letters

57.

Code for Hello, World!

a)

print Hello, World!

b)

print("Hello, World!)

c)

print("Hello, World!")

58.

# is used to :

a)

enter text to a program

b)

enter a number to a program

c)

enter comments to a program

59.

# is used to :

a)

enter text to a program

b)

enter a number to a program

c)

enter comments to a program

60.

Code for Hello, World!

a)

print Hello, World!

b)

print("Hello, World!)

c)

print("Hello, World!")

61.
The number or word we give to a variable
a)
Value
b)
Bug
c)
Information
d)
Text
62.
The correct way to write a variable in Python?
a)
my_variable = 10
b)
my variable = 10
c)
my_variable is 10
d)
my_variable: 10
63.
In the following code, "city" is an example of a what?
a)
List
b)
Loop
c)
Variable
d)
Array
64.
What does the print function do in python?
a)
It's a variable.
b)
It can input data.
c)

It displays an output

d)
It loops the code.
65.
Which statement correctly assigns the string "Tanner" to the variable name?
a)
name  = print( "Tanner")
b)
input("Tanner")
c)
name = "Tanner"
d)
name = input("Tanner")
66.
What is Python?
a)
text based programming language
b)
word processor 
c)
spreadsheet
d)
block based programming language
67.
A syntax error means your code has a 'grammar' mistake or you used symbols/operations incorrectly
a)
True
b)
False
68.

What will be the output?

name = "Dave"

print (name)

a)

Dave

b)

'Dave'

c)

name

d)

(name)

69.
What symbol is used in python to assign values to a variable?
a)
equals =
b)
plus + 
c)
forward slash /
d)
asterisk *
70.
What is a variable?
a)
A box(memory location) where you store values
b)
a type of graphics
c)
Data type
d)
a type of memory
71.

What is the shortcut to undo an action?

a)

CTRL + Z

b)

CTRL + S

c)

CTRL + C

d)

CTRL + P

72.

What does email stand for?

a)

Electric machine

b)

Electro mail

c)

Electro message

d)

Electronic mail

73.

What is ICT?

a)

Integrating Communication Technology

b)

Information Connecting Technology

c)

Information Communication Technology

d)

Information Communication Technique

74.

How are ROWS in MS EXCEL spreadsheet named?

a)

numbers

b)

letters

c)

cells

d)

columns

75.

Dawn is creating a formula to multiply the values in cells D4 and F4. Which formula should she use?

a)

=D4+F4

b)

=D4*F4

c)

=D4 x F4

d)

=D4-F4

76.

Sandra is creating a formula to subtract the values in cells B4 and C4. Which formula should she use?

a)

=B4+C4

b)

=B4-C4

c)

=B4*C4

d)

=B4/C4

77.

Text formulas:

a)

a. Replace cell references

b)

b. Return ASCII values of characters

c)

c. Concatenate and manipulate text

d)

d. Show formula error value

78.

A worksheet range is a

a)

a. A command used for data modeling

b)

b. A range of values such as from 23 to 234

c)

c. A group of cells

d)

d. A group of worksheets

79.

What function Is used to find the highest data ?

a)

SUM

b)

MIN

c)

MAX

d)

AVERAGE

80.

What function is used to find the lowest data ?

a)

MIN

b)

MAX

c)

SUM

d)

AVERAGE

81.

What do you mean by Active Cell in Ms-Excel?

a)

A cell which is currently selected

b)

A sheet which is currently selected

c)

A workbook which is currently selected

82.

A ___________________ is a collection of worksheets.

a)

page

b)

workbook

c)

slide

83.

Excel file is saved as a ____________

a)

Document

b)

workbook

c)

worksheets

d)

Presentation

84.

In Ms Excel you can change the colour of the cell using Fill colour tool.

a)

false

b)

true

85.

What is the solution:

=(24-16)÷8

a)
8
b)
1
c)
2
d)
7
86.

Which operation is performed FIRST?

=(13 - 1) + 4

a)

addition

b)

subtraction

c)

multiplication

87.

In Excel, Rows are labeled as …..

a)

1,2,3,....

b)

A,B,C,....

88.

In Excel, Cells are labeled as …..

a)

A1,A2,A3,.....

b)

1,2,3,4,....

c)

A.B,C,....

89.

Which area in an Excel window allows entering values and formulas?

a)

Formula Bar

b)

Menu Bar

c)

Title Bar

90.

   Which function in Excel checks whether a condition is true or not?

a)

IF

b)

SUM

c)

AVERAGE

91.

    How many sheets are there, by default, when we create a new Excel file?

a)

3

b)

10

c)

5

92.

What is the intersection of a column and a row on Excel sheet?

a)

Value

b)

Cell

c)

Address

93.

  Microsoft Excel Program is used to :

a)

Analyzing Data

b)

Make Calculations

c)

Both A & B

94.

What does every formula in MS EXCEL start with?

a)

+

b)

-

c)

=

d)

*

95.

What is a rectangular box in a MS EXCEL Spreadsheet called?

a)

row

b)

column

c)

cell

96.

The first cell in a worksheet is what?

a)

A1

b)

1A

c)

FX

d)

Cell Name

97.

Which is NOT a term used in Excel?

a)

Workbook

b)

Worksheet

c)

Cell

d)

Document

98.

A program using a table comprising of rows, columns and cells.

a)

MS Word

b)

MS PowerPoint

c)

MS Outlook

d)

MS Excel

99.

Which leading computer software business create programs like Spreadsheet, word and PowerPoint?

a)

Google

b)

Apple

c)

DELL

d)

Microsoft

100.

Who crates Microsoft?

a)

Bill Gates

b)

Tom Bills

c)

Mark Zuckerberg

d)

Albert Einstein