wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

ICT

Total questions: 100

Worksheet time: 54mins

Name
Class
Date
1.

Cells that run horizontally on a spreadsheet

a)

Row

b)

Column

c)

Workbook

d)

Range

2.
Cells that run vertically on a spreadsheet
a)
Row
b)
Workbook
c)
Worksheet
d)
Column
3.
Data in a spreadsheet table can be sorted by single or multiple columns and alphabetically and numerically
a)
True
b)
False
4.
What is normally used to perform calculations in a spreadsheet?
a)
Variable
b)
Formula
c)
Conditional formating
d)
Macro
5.
SUM, AVERAGE, MAX and VLOOKUP are examples of what?
a)
Functions
b)
Tables
c)
Formulae
d)
Statistical tools
6.
When you key a formula in a spreadsheet what do you key in first?
a)
Subtraction sign
b)
Equal Sign
c)
Addition sign
d)
Division sign
7.
Which of the following is a valid formula?
a)
=C7*C8
b)
=(C7\C8)
c)
=(C7xC8)
d)
=AVERAGE(C7*C8)
8.
You can present your data graphically, using a 
a)
chart
b)
print
c)
font
d)
sort
9.
If B3:J8 is given, what is it referring to?
a)
range of cells B3 through J8
b)
only cell J8
c)
only cells B3 and J8
d)
only cell B3
10.
I can find the lowest number in a range with the ... function
a)
MIN
b)
MAX
c)
AVERAGE
d)
COUNT
11.
To restrict the data that can be entered into a cell e.g. Gender = "M" or "F", is called?
a)
Validation
b)
Verification
c)
Filter
d)
Sort
12.
Changing the appearance of a cell based on a rule is called?
a)
Conditional Formatting
b)
Validation Formatting
c)
Filter Formatting
d)
Sort Formatting
13.
To show the quantities in particular categories use a?
a)
Column Chart
b)
Line Graph
c)
Scatter Graph
d)
Sort Chart
14.
Which chart should you use to show changes over time?
a)
Line
b)
Scatter
c)
Pie
d)
Bar
15.
Which formula would display "Yes" if D13 is greater than 0?
a)
=IF(D13>0,"Yes","No")
b)
=IF(D13<0,"Yes","No")
c)
=IF(D13>0:"Yes","No")
d)
=IF(D13<0:"Yes","No")
16.
Which formula would subtract D12 from D13?
a)
=D13-D12
b)
=D12-D13
c)
=sum(D12-D13)
d)
=sum(D13-D12)
17.
What function can be used to find the largest number in a range of numbers?
a)
=MIN
b)
=MAX
c)
=AVERAGE
d)
=SUM
18.
What does cell B6 contain?
a)
23
b)
0.45
c)
0.50
d)
23
19.
What Excel feature did we use to quickly apply this formatting feature?
a)
Data scenario formatting
b)
What-if analysis
c)
Conditional formatting
d)
PivotTables
20.
What specific format would change 2.5 to £2.50?
a)
Currency
b)
Date
c)
Number
d)
Time
21.
The cell in which you are currently working is known as what?
a)
Active cell
b)
Cell address
c)
Cell reference
d)
Spreadsheet cell
22.

What symbol do you use to add two cells' values in Excel?

a)

+

b)

-

c)

=

d)

*

e)

/

23.

What has happened to Superheros in cells B2:D2?

a)

Merged

b)

Joined

c)

Fused

d)

Nothing

24.

What does the function =SUM() do?

a)

Adds up Cells

b)

Sells Cells

c)

Multiplies Cells

d)

Divides Cells

25.

What does the function =MAX() do?

a)

Finds the smallest number

b)

Finds the biggest number

c)

Finds the right number

d)

Finds the left number

26.

What does the function =MIN() do?

a)

Finds the biggest number

b)

Finds the smallest number

c)

Finds the correct number

d)

Finds the wrong number

27.

What kind of referencing uses $ to keep the cell the same?

a)

Relative

b)

Absolute

c)

Magic

d)

Heart

28.

What feature of a spreadsheet allows text to fill a cell up?

a)

Wrapped Text

b)

Format Text

c)

Merged Text

d)

Trapped Text

29.

What type of graph is this?

a)

Bar

b)

Line

c)

Pie

d)

Scatter

30.
Which term best describes software programs and services that you access over the Internet?
a)
Network connections
b)
Cloud computing
c)
Applications
d)
Documents
31.
Microsoft Word and Google Docs are examples of what?
a)
Word processors
b)
Spreadsheets
c)
Presentations
d)
Databases
32.
Google Docs or Microsoft Word allows you to:
a)
create, edit, share and store forms for user input.
b)
create, edit, share and store webpages and sites.
c)
create, edit, share and store spreadsheet documents.
d)
create, edit, share and store word-processing documents.
33.
A keyboard shortcut is:
a)
a mouse-click used to generate a keystroke.
b)
a single or combination of keystrokes used to access a menu command.
c)
a quick tapping of a key on the keyboard.
d)
a keystroke that generates a number.
34.
Which is the correct keyboard shortcut to open a document?
a)
SHIFT+O
b)
ALT+P
c)
CTRL+O
d)
CTRL+N
35.
You can find the Print command in which menu?
a)
File
b)
View
c)
Insert
d)
Format
36.
A template in a word processor provides access to:
a)
the program coding used to operate your word processor.
b)
a page design layout into which you can place your content.
c)
a presentation of pre-defined slides.
d)
the complete list of shortcuts used by your word processor.
37.
What functionality does the ruler in a word processor provide?
a)
Defines the size of the page.
b)
Measures the width of a table.
c)
Shows the position of your cursor in the document.
d)
Creates boundaries or margins inside which you add the contents (words, images, etc.) of your document.
38.
Which command allows you to change the document file type?
a)
print
b)
copy
c)
save as
d)
open
39.
When you save a document to your personal cloud storage space, how can others access the document?
a)
You grant permission when you share the document.
b)
You provide others with your login information.
c)
You create accounts for each person who wants access to the document.
d)
You provide others with a phone number.
40.
Which menu or tab contains the command to show or hide the ruler?
a)
File
b)
View
c)
Insert
d)
Format
41.

What is the shortcut for selecting the whole page?

a)

Ctrl + N

b)

Ctrl + B

c)

Ctrl + A

d)

Ctrl + D

42.

To save a document for the first time you would-

a)

File - save as

b)

File - save

c)

File - print

d)

File - open

43.
What feature should be used before a document is printed?
a)
Alignment
b)
Spell Check
c)
Type Size
d)
Changing the Font
44.
What is a shortcut to copy highlighted text?
a)
CTRL+Z
b)
CTRL+P
c)
CTRL+C
d)
CTRL+Y
45.
What is a shortcut to paste text?
a)
CTRL+V
b)
CTRL+P
c)
CTRL+X
d)
CTRL+S
46.
Which of the following would change the appearance of a character?
a)
Alignment
b)
File Name
c)
Font Style
d)
Margins
47.
What is the standard font size in word processing documents?
a)
12
b)
15
c)
14
d)
18
48.
Changing the existing document is known as what?
a)
Entering
b)
Editing
c)
Re-typing
d)
Selecting
49.
What is a shortcut to find words in a document?
a)
CTRL+V
b)
CTRL+X
c)
CTRL+C
d)
CTRL+F
50.
A pointing device that sends control signals into the computer. 
a)
Mouse
b)
Keyboard
c)
Video Card
d)
Flash Drive
51.
It is used to display data in visual form. The images it displays are where the user gets information
a)
Visual graphics array
b)
HDMI
c)
Monitor
d)
LED
52.
It contains set of keys that are used to input characters (letters, numbers) and control signals into the computer. 
a)
Mouse
b)
Mouse Pad
c)
Num Pad
d)
Keyboard
53.
Which is true about AVR's?
a)
It protects the computer from changes in the electricity.
b)
It is used as a back up source in case of power interruption
c)
It produces alternating current to supply the computer.
d)
It uses potentiometer.
54.
Which is true about casing?
a)
It has built - in processor
b)
It serves as the container of the computer's internal parts.
c)
It has 20 drive bays.
d)
It carries the computer's external parts
55.
Which is true about power supply?
a)
A single PSU can supply 5 computer units
b)
It converts the main alternating current into low-voltage direct current.
c)
It has its own processor
d)
PSU's are all true rated
56.
Which of the following is true about a hard drive?
a)
PATA and SATA has the same disk rpm.
b)
It can only be used internally
c)
It cannot be partitioned
d)
It is the main storage device of the computer.
57.
It reads or writes data into optical discs.
a)
External hard drive
b)
Optical disc drive
c)
Flash drive
d)
External DVD - R
58.
It is the temporary storage device of the computer. 
a)
Central Processing Unit (CPU)
b)
Random Access Memory (RAM)
c)
Read Only Memory (ROM)
d)
Basic Input and Output System (BIOS)
59.
a)
It is referred to as the computer's brain
b)
It is the core of the computer
c)
It is the body of the computer
d)
it is the 
60.
a)
It is the core of the computer
b)
It is the brain of the computer
c)
It is the CPU of the computer
d)
It has North, South, West, East brdige.
61.
These are where the cards such as modem card and graphics cared are installed.
a)
PCIe slot
b)
Expansion Slots
c)
AGP slot
d)
SATA slot
62.
It coordinates the flow of data between the CPU, graphics card and RAM
a)
Southbridge
b)
Westbridge
c)
Northbridge
d)
Eastbridge
63.
It hadles all the computer's input/output functions.
a)
Northbridge
b)
Southbridge
c)
Westbridge
d)
Eastbridge
64.
Which is true about BIOS?
a)
It stands for Basic Input/Outcome Standard
b)
It stands for Basic Input/Output System.
c)
It can produce graphics capacity
d)
It is the brain of the computer.
65.

What is this computer software called?

a)

Google Docs

b)

Google Classroom

c)

Google Meet

d)

Google Slide

66.

What is this computer software called?

a)

Google Docs

b)

Google Classroom

c)

Google Meet

d)

Google Slide

67.

What is this computer software called?

a)

Google Docs

b)

Google Classroom

c)

Google Meet

d)

Google Slide

68.

What is this computer software called?

a)

Google Docs

b)

Google Classroom

c)

Google Meet

d)

Google Slide

69.

What is this computer software called?

a)

Google Chrome

b)

Google Classroom

c)

Google Meet

d)

Google Slide

70.

The software you use to see your lesson is ..

a)
b)
c)
d)
71.

The software you use to do video conference is ..

a)
b)
c)
d)
72.

The software you use to browse the internet is ..

a)
b)
c)
d)
73.

The software you use to write assignment is ..

a)
b)
c)
d)
74.

The software you use to do presentation is ..

a)
b)
c)
d)
75.

What is this computer software called?

a)

Google Chrome

b)

Google Classroom

c)

Youtube

d)

Google Slide

76.

What is this computer software called?

a)

Google Chrome

b)

Google Classroom

c)

Jamboard

d)

Google Slide

77.

What is this computer software called?

a)

Google Chrome

b)

Google Classroom

c)

Google Hangout

d)

Google Slide

78.

What is this computer software for?

a)

Video conference

b)

See lesson

c)

Chat

d)

Presdentation

79.

What is this computer software for?

a)

Presentation

b)

See lesson

c)

Drawing

d)

Chatting

80.

a person who buy goods and sevices is called a.

a)

sever

b)

consumer

c)

producer

81.

expand WWW

a)

world wide web

b)

world watch web

c)

world watch wheel

82.

E-commerce is the best tech related technology related with.

a)

computer

b)

both commerce and computer

c)

commerce

83.

E-commerce is the transaction

a)

paper transaction

b)

only credit transaction

c)

online transaction

84.

the process of starting and running a business is called.

a)

independent skill

b)

technical skill

c)

entrepreneurship

85.

An individual who undertakes the risk associated with creating,organizing and owning a business.

a)

venture

b)

entrepreneurship

c)

entrepreneur

86.

innovation events celebrated in the month of.

a)

february

b)

january

c)

december

87.

Which is NOT a negative impact of e-Commerce

a)

Availability of products 24/7/365

b)

You never have to pay shipping charges

c)

Receive product immediately

d)

Potential for scamming

88.

Which of the following is NOT required to use e-Commerce?

a)

Internet Access

b)

Digital Cash

c)

Cash

d)

Computer/Smart device

89.

Which of the following is NOT a benefit of e-Commerce

a)

Faster to buy/sell

b)

Easier to find products

c)

Geographic limitations

d)

Can purchase goods from any location

90.

E-mail is short for ...

a)

Everyday mail

b)

Exciting mail

c)

Electronic mail

d)

Electric mail

91.

Cc means ...

a)

Copy Cat - The email is copied and sent to everybody in your address book.

b)

Can't Copy - Your email cannot be sent.

c)

Circular Copy - The email goes around in circles until it is opened.

d)

Carbon Copy - a copy of the email is sent to another person.

92.

Two benefits of e-mail are:

a)

Can be accessed without an internet connection.

b)

Delivered instantly to anywhere in the world.

c)

Secure. No risk of hackers.

d)

Can send to multiple people in one go.

93.

Two drawbacks of e-mail are:

a)

Phishing scams.

b)

Spam

c)

Very slow.

d)

Expensive to send multiple emails.

94.

Sending an email to somebody with the intention of finding out personal details like a password is called ...

a)

Scamming

b)

Spamming

c)

Phishing

d)

Fishing

95.

What does this icon do?

a)

Holds your place

b)

Spell Check your e-mail

c)

Send a message

d)

Attach a file

96.

Good Morning Mr Nicholls is an example of......

a)

Salutation

b)

Closing statement

97.

A file sent by of e-mail.

a)

Recipient

b)

Attachment

c)

Reply

d)

Sender

98.

The person to whom the e-mail is sent.

a)

Theme

b)

Sender

c)

Recipient

d)

Inbox

99.

The place we receive all our e-mails.

a)

Starred

b)

Inbox

c)

Drafts

d)

Important

100.

All the saved Emails sent from the email account is called.

a)

Sent mail

b)

Drafts

c)

Important

d)

starred

Similar Resources on Wayground

Excel/Access EOC Review

100 questions

Excel/Access EOC Review

quiz

Worksheet

•

9th Grade - University

End of Semester Final: Info Tech

105 questions

End of Semester Final: Info Tech

quiz

Worksheet

•

9th - 12th Grade

Proses Produksi Desain (SKALISKA)

104 questions

Proses Produksi Desain (SKALISKA)

quiz

Worksheet

•

11th Grade

COMPUTER STUDIES

100 questions

COMPUTER STUDIES

quiz

Worksheet

•

9th - 12th Grade

HULING BANAT CSS4

101 questions

HULING BANAT CSS4

quiz

Worksheet

•

11th Grade

SOAL ULANGAN HARIAN 1 KODING DAN KECERDASAN ARTIFISIAL

100 questions

SOAL ULANGAN HARIAN 1 KODING DAN KECERDASAN ARTIFISIAL

quiz

Worksheet

•

10th Grade - University

Review for Python 3 Test - Loops and Strings (CodeCademy)

100 questions

Review for Python 3 Test - Loops and Strings (CodeCademy)

quiz

Worksheet

•

7th - 12th Grade

Remidial topologi jaringan

100 questions

Remidial topologi jaringan

quiz

Worksheet

•

11th Grade