Wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

Year 7 ICT Term 3 Progress Check

Total questions: 40

Worksheet time: 21mins

Name
Class
Date
1.
In Microsoft Word, what do you use to show a spreadsheet of data?
a)
Table
b)
menu
c)
toolbar
d)
copy
2.
a)
Save
b)
Undo
c)
Redo
d)
Underline
3.
Left, Center, Right,and Justify are options for which tool located on the toolbar or ribbon?
a)
Zoom
b)
Line Spacing
c)
Bulleted Lists
d)
Text Alignment
4.
In Microsoft Word, what is a "menu"?
a)
a spreadsheet
b)
a list of options available to a user
c)
row of buttons on a display screen with a variety of functions
5.
"Ctrl + c" is a shortcut that means to...
a)
copy
b)
paste
c)
cut
6.
"Ctrl + v" is a shortcut that means to...
a)
cut
b)
copy
c)
paste
7.

What is this button used for?

a)

Creating a new document

b)

Opening a document

c)

Saving a document

d)

Inserting a picture

8.

Which tab would you need to click if you wanted to add a photograph to your document?

a)

Home

b)

Insert

c)

Format

d)

Page Layout

9.

Which tab would you click to change the page to landscape?

a)

Home

b)

Format

c)

View

d)

Page Layout

10.

Letter A on this Table image is referring to a...

a)

Column

b)

Table

11.

Calibri, Times New Roman, Comic Sans are all examples of...

a)

Header styles

b)

Font sizes

c)

Font Styles

12.
Columns run horizontally in tables, and rows run from left to right.
a)
True
b)
False
13.
Q12. Which tab to you click to save ?
a)
Home
b)
Insert
c)
File
d)
View
14.

Italics, Underline and Bold are _______.

a)

Font Styles

b)

Dialog Boxes

c)

Microsoft Word Views

15.

Which of these methods moves text from one place to another?

a)

Cut and copy

b)

Copy and paste

c)

Delete and paste

d)

Cut and paste

16.

A serif font

a)

is very fancy and hard to read.

b)

has small lines or "tails" at the beginning and end of the letters.

c)

does not have small lines or "tails."

d)

looks like cursive letters.

17.

Sans serif fonts

a)

have little lines or "tails" at the beginning and ends of the letters.

b)

do not have the little lines or "tails."

c)

are very decorative and fancy.

d)

look like cursive letters.

18.

Serif fonts are best used for

a)

professional documents or publications like a resume or article.

b)

anything on a computer screen.

c)

old people.

d)

nothing, they are outdated.

19.

Sans serif fonts are best used for

a)

professional documents like a resume or article.

b)

anything on a computer screen like a website or app.

c)

nothing, they are outdated.

d)

old people.

20.

Microsoft Excel is what kind of software?

a)

Word Processing Software

b)

Spreadsheet Software

c)

Database Software

d)

Presentation Software

21.

The letters in Excel represent the...

a)

Rows

b)

Columns

c)

Cells

d)

Data

22.

The numbers in Excel represent the...

a)

Rows

b)

Columns

c)

Cells

d)

Data

23.
How do you change column width to fit the contents?
a)
Single-click the boundary to the left of the column heading
b)
Double-click the boundary to the right of the column heading
c)
Press ALT and single-click anywhere in the column
24.
What is the name given to the intersection of a row and a column in a spreadsheet? 
a)
cell
b)
block
c)
cube
d)
square
25.

Letters of the alphabet going across the top of the spreadsheet.

a)

Title Bar

b)

Column Labels

c)

Row Labels

d)

Status Bar

26.

Numbers down the left side of the spreadsheet.

a)

Status Bar

b)

Formula Bar

c)

Column Labels

d)

Row Labels

27.

The intersection of a column and a row is called a __________.

a)

Four-way Stop

b)

Formula Bar

c)

Cell

d)

Template

28.

What is this icon?

a)

Zoom

b)

Sort and Filter

c)

Symbol

d)

Merge and Center

29.

The cell address of the highlighted cell is

a)

C

b)

4

c)

A4

d)

C4

30.

What does the indicated icon do in the red box?

a)

Apply underline

b)

Apply italic

c)

Make text bigger

d)

Apply bold

31.

What does the indicated icon in the red box do?

a)

Change number of active cells

b)

Change font colour

c)

Change font size

d)

Change the number of calculations

32.

Every formula starts with what?

a)

=

b)

+

c)

-

d)

( )

33.

Select all of the following that are available under the Autosum button:

a)

sum

b)

minimum

c)

average

d)

maximum

e)

division

34.

If you center or merge and center it does exactly the same thing.

a)

True

b)

False

35.

If you selected (A1:B5) what is this called?

a)

row

b)

column

c)

cell range

d)

cell grouping

36.

The function that lets you add up a range of cells or values

a)

SUM

b)

AVERAGE

c)

MIN

d)

MAX

37.

What function was used to find the lowest grade?

a)

average

b)

sum

c)

min

d)

max

38.

What function was used to find the highest grade?

a)

average

b)

min

c)

sum

d)

max

39.

What symbol means to divide?
a)
equal sign
b)
asterisk
c)
diagonal
d)
minus 
40.
Which is the correct formula to add cells A1 to A5?
a)
=SUM(A2+A5)
b)
=SUM(A1:A5)
c)
=A1+A2+A3
d)
=SUM(A1:A4)