wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

ICT REVISION (WORD & EXCEL)

Total questions: 106

Worksheet time: 1hrs 7mins

Name
Class
Date
1.

a)

Font Color

b)

Bold

c)

Underline

d)

Text Highlight Color

2.

a)

Font Color

b)

Italic

c)

Bold

d)

Underline

3.

a)

Font Color

b)

Italic

c)

Bold

d)

Underline

4.

a)

Font Color

b)

Italic

c)

Bold

d)

Underline

5.

a)

Font Color

b)

Bold

c)

Underline

d)

Text Highlight Color

6.

a)

subscript

b)

superscript

c)

strikethrough

d)

Text Effects and Typography

7.

a)

subscript

b)

superscript

c)

strikethrough

d)

Text Effects and Typography

8.

a)

subscript

b)

superscript

c)

strikethrough

d)

Text Effects and Typography

9.

a)

Font Color

b)

Bold

c)

Underline

d)

Text Effects and Typography

10.

a)

Font Color

b)

Font

c)

Font Size

d)

Text Highlight Color

11.

a)

Font Color

b)

Font

c)

Font Size

d)

Text Highlight Color

12.

What is this a picture of?

a)

Smart Art

b)

Backstage View

c)

GROUP

d)

Contextual Tab

13.

What is circled in Red?

a)

TABS

b)

GROUPS

c)

Backstage View

d)

Word Art

14.

What is circled in Red?

a)

TABS

b)

GROUPS

c)

Backstage View

d)

Contextual Tab

15.

What is this a picture of?

a)

Group

b)

Chart

c)

Table

d)

SmartArt

16.

These graphics range from graphical lists and process diagrams to more complex graphics, such as Venn diagrams and organization charts.

a)

Hyperlink

b)

Table

c)

SmartArt

d)

WordArt

17.

This is the area where files and data about them is managed - creating, saving, printing, sending to others, inspecting for hidden metadata or personal information, and setting options. You can also change a document's subject, status, comments, and author here.

a)

Dialog Box Launcher

b)

View Tab

c)

Insert Tab

d)

Backstage View

18.

What is circled in Red?

a)

GROUPS

b)

TABS

c)

Dialog Box Launcher

d)

SmartArt

19.

What is this a picture of?

a)

SmartArt

b)

Chart

c)

Table

d)

WordArt

20.

What is this a picture of?

a)

Table

b)

Chart

c)

SmartArt

d)

WordArt

21.

This tab allows you to add a picture, shape, table, chart, or hyperlink to the document.

a)

File Tab

b)

Insert Tab

c)

Design Tab

d)

Layout Tab

22.

This allows you to create a link in your document for quick access to webpages and files. They can also take you to places in your document, such as headings and bookmarks.

a)

Hyperlink

b)

Bookmark

c)

Cross-reference

d)

Comment

23.

What is this a picture of?

a)

Group

b)

Contextual Tab

c)

Backstage View

d)

Dialog Box Launcher

24.

This tab allows you to look at the document in Read Mode, Print Layout, or Web Layout.

a)

File Tab

b)

Home Tab

c)

View Tab

d)

Design Tab

25.

When you select File - New, you are able to view

a)

Backstage View

b)

Templates

c)

Read Mode

d)

Layout Mode

26.

Add some artistic flair to your document using this text box.

a)

WordArt

b)

Styles

c)

Table

d)

Chart

27.

This tab allows you to complete spelling & grammar checks, word count, and add comments.

a)

File Tab

b)

Home Tab

c)

Design Tab

d)

Review Tab

28.

This tab allows you to change the document theme, document formatting, and document color. It also allows you to add a watermark and page border.

a)

File Tab

b)

Home Tab

c)

Insert Tab

d)

Design Tab

29.

This tab allows you to change the margins, orientation, and size of the document.

a)

Home Tab

b)

View Tab

c)

Layout Tab

d)

Design Tab

30.

This tab allows you to insert a Table of Contents, Insert Footnote & Endnote, and Insert Citation.

a)

View Tab

b)

References Tab

c)

Home Tab

d)

Insert Tab

31.

These help you to repeat content at the top of every page. They're useful for showcasing information, like title, author, and page number.

a)

Header

b)

Footer

c)

WordArt

d)

Textbox

32.

These help you repeat content at the bottom of every page. They're useful for showcasing information, like title, author, and page number.

a)

Page Break

b)

Footer

c)

Header

d)

Table

33.

Microsoft Word is a

a)

Presentation program

b)

Word Processing program

c)

Spreadsheet program

d)

None of these

34.

Which can be used for quick access to commonly used commands and tools?

a)

Status bar

b)

Tool bar

c)

Menu bar

d)

Title bar

35.

The best way to create a heading in a document is to:

a)

Apply a larger font size to it than the body text.

b)

Add bold formatting by clicking the Bold button on the Formatting toolbar.

c)

Apply a heading style.

36.

What's a good reason to use a header or footer in your document?

a)

To look impressive.

b)

To add a title to the start of the document.

c)

To include the document title and page numbers.

37.

In order to save an existing document with a different name you need to:

a)

Retype the document and give it a different name.

b)

Use the Save as... command.

c)

Copy and paste the original document to a new document and then save.

d)

Use Windows Explorer to copy the document to a different location and then rename it.

38.

Which tool do you use to make the text flow all the way around a picture?

a)

Crop

b)

Track Changes

c)

Wrap Text

d)

Align

39.

The process of removing unwanted part of an image is called:

a)

Hiding

b)

Bordering

c)

Cropping

d)

Cutting

40.

A number of letter that appears little above the normal text is called:

a)

Superscript

b)

Subscript

c)

Supertext

d)

Toptext

41.

We can insert a page number at

a)

Header

b)

Footer

c)

Both A and B

d)

None

42.

We can remove / hide border of a shape by selecting:

a)

No Line

b)

No Outline

c)

White Line

d)

No Border

43.

How many margins are on a page?

a)

Two (header and footer).

b)

Four (top, bottom, right, left).

c)

Two (landscape and Portrait).

d)

Two (top and bottom)

44.

We can change the thickness of a line from ___

a)

Line Width

b)

Line Height

c)

Line Thick

d)

Line Style

45.

Color and pattern used to fill a closed shape is called:

a)

Fill style

b)

WordArt

c)

Shape

d)

Fill Back

46.

The default alignment for paragraphs is:

a)

Right-aligned

b)

Left-aligned

c)

Centered

d)

Justified

47.

A _____ is a collection of predefined design elements and color schemes.

a)

Feature

b)

Hyperlink

c)

Palette

d)

Theme

48.

The ____ defines the appearance and shape of letters, numbers, and special characters.

a)

Font

b)

Font size

c)

Point

d)

Paragraph formatting

49.

Allows you to sort text from Z to A or largest to smallest

a)

Split Sort

b)

Ascending sort

c)

Merge Sort

d)

Descending Sort

50.

The feature that combines or joins cells together in a table:

a)

Split cells

b)

Merge cells

c)

Distribute rows

d)

Distribute columns

51.

What does a red underline on a word indicate?

a)

Grammar mistake

b)

Synonym

c)

Spelling mistake

d)

Word has been entered multiples times

52.

Which type of list is best suited for items that do not go in any specific order?

a)

Numbered

b)

Connected

c)

Bulleted

d)

Multilevel

53.
What kind of software is Excel?
a)
Word processing software
b)
Spreadsheet Software
c)
Data Base Software
54.
In Excel rows are labeled by
a)
letters
b)
numbers
c)
rows and numbers
55.
In excel, columns are labeled by
a)
Letters
b)
Numbers
c)
Letters and numbers
56.
What button will add up a group of numbers
a)
Equals button
b)
Plus symbol button
c)
Auto-sum button
57.
Excel refers to files as
a)
Documents
b)
Workbooks
c)
data bases
58.
Where rows and columns meet are referred to as
a)
Blocks
b)
Cells
c)
Boxes
59.
When inserting a formula, always start with
a)
equals symbol
b)
plus symbol
c)
minus symbol
60.
What kind of chart should you use to show the pieces (percentages) of a whole
a)
Bar Chart
b)
Column Chart
c)
Pie Chart
61.
To see what math formulas are used in a cell, click on the
a)
Show formulas button
b)
Show the math button
c)
the auto sum button
62.
Excel is part of
a)
Access
b)
Microsoft Office
c)
PowerPoint
63.
What key should you use to take you to the cell to the right
a)
Tab key
b)
Right arrow key
c)
just click in it
64.
To allow you to evenly distribute a title over a table of numbers, use the
a)
Center button
b)
Merge and Center button
c)
Merge cells only button
65.
If you see a series of "######" in a cell, that means the following:
a)
You keyed in an incorrect number
b)
The row height is too high
c)
The text is incorrectly spelled
d)
The column width is not wide enough
66.
You can only work in one cell at a time. The actual cell that you are working in is called what?
a)
Column
b)
Name Box
c)
Active Cell
d)
Row
67.
Cells are identified by the following:
a)
Column Letter followed by their Row Number
b)
Row Number followed by their Column Letter
c)
Row Number Only
d)
Column Letter Only
68.
Microsoft Excel is what type of software?
a)
Word Processing
b)
Spreadsheet
c)
Presentation
d)
Drawing
69.
A(n) Excel ___ allows data to be easily calculated.
a)
worksheet
b)
format
c)
table
d)
display 
70.

What do you call the blank boxes on a spreadsheet?

a)

places

b)

cells

c)

squares

d)

info

71.
What is the name of this cell?
a)
B10
b)
5B
c)
B5
d)
A5
72.
By default, how many worksheet is displayed when you open Excel?
a)
1
b)
2
c)
3
d)
4
73.
What is the symbol to add in Excel?
a)
-
b)
*
c)
/
d)
+
74.
Spreadsheets consists of ________ and _______.
a)
tables and chairs
b)
rows and tables
c)
rows and columns
d)
columns and tables
75.
The vertical set of cells are known as _______
a)
rows
b)
columns
c)
straight lines
d)
verts
76.
The set of cells that are horizontal in direction on a spreadsheet are referred to as 
a)
rows
b)
columns
c)
cells
d)
spreadsheet
77.
The columns on a spreadsheet run vertical and begin with what?  
a)
numbers
b)
letters
c)
colors
d)
pictures
78.
The rows on a spreadsheet run horizontal and begin with ________
a)
letters
b)
pictures
c)
numbers
d)
dates
79.
The horizontal placement of cells in a table or worksheet.
a)
range
b)
row
c)
column
d)
cell
80.
What is a vertical section of a spreadsheet
a)
row
b)
addition
c)
column
d)
format
81.

How can you use Excel to help in your everyday life?

a)

Address List

b)

Create a schedule

c)

Create a budget

d)

Create a gradebook

e)

All of the above

82.

A _____________ is known as an Excel file.

a)

workbook

b)

worksheets

c)

spreadsheets

83.

Spreadsheets are made up boxes called_____________

a)

box

b)

cells

84.
A3 is an example of a cell's address
a)
true
b)
false
85.

When you enter something into excel that WILL be used in calculation, it is considered a............

a)

value

b)

label

c)

word

d)

equal sign

86.

Which symbol must all formulas begin with?

a)

=

b)

+

c)

(

d)

@

87.
Which of these symbols is used for divide on a computer?
a)
\
b)
*
c)
/
d)
|
88.
Which symbol means to multiply?
a)
/
b)
*
c)
SUM
d)
(  )
89.

What is the green bar at the top of Excel referred to as?

a)

the data bar

b)

the function bar

c)

the ribbon

d)

the row

90.

What is a range in Excel?

a)

An individual space

b)

A group of cells

c)

A graph

d)

A formula

91.

What is the file extension for Excel worksheets?

a)

.png

b)

.pptx

c)

.xlsx

d)

.docx

92.

Which of the following is not an arithmetic operator?

a)

=

b)

+

c)

s

d)

^

93.

Why do you start a formula with an = sign?

a)

to tell Excel you are entering a formula

b)

just because

c)

you are entering text

94.

Where does Excel return the result of a formula

a)

the same cell where the formula is entered

b)

A1

c)

in your head

95.

What is the answer to the following formula: =2^4 + 7

a)

13

b)

71

c)

23

d)

123

96.

What is the answer to the following formula: =25% * 40

a)

140

b)

25

c)

75

d)

10

97.

In the following formula, what gets done first: =6+2*(6-2)

a)

6+2

b)

2*6

c)

2*(6+2)

d)

(6+2)

98.

Which arithmetic operator is being used in the following formula: =T75- AA45

a)

addition

b)

multiplication

c)

subtraction

d)

format

99.

What is the answer if the value in cell A5 is 75; C10 is 20; B23 is 15; E15 is 100; G20 is 5 and the formula is: =C10 + (A5 * G20)/ B23

a)

43

b)

55

c)

49.6

d)

45

100.

What is the answer to the following formula: -(P45/Q14) where the value in cell P45 is 25, and in cell Q14 is 5?

a)

5

b)

15

c)

-30

d)

-5

101.

Does Excel allow the use of numbers in formulas?

a)

yes

b)

no

102.

What order does the order of operations follow?

a)

right to left

b)

left to right

c)

up to dow

d)

middle outwards

103.

List the following in order of operations: addition (+), division (/), multiplication (*), subtraction (-).

a)

/,+,-,*

b)

*,/,+,-

c)

^,s,r,t

104.

Using exponentiation, what does = 3^4 do?

a)

raises 3 to the fourth power

b)

3 times 4

c)

nothing

105.

Do you need an = sign to start a formula?

a)

no

b)

yes

c)

never

106.

What is the next school break?

a)

Easter break

b)

summer break

c)

spring break

d)

labor day