wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

ICT Semester Test Review

Total questions: 77

Worksheet time: 46mins

Name
Class
Date
1.

What is Microsoft Excel?

a)

A graphical word processing program that users can type with. It is made by the computer company Microsoft. Its purpose is to allow users to type and save documents. Similar to other word processors, it has helpful tools to make documents.

b)

An information management tool, or relational database, that helps you store information for reference, reporting and analysis.

c)

A software program produced by Microsoft that allows users to organize, format and calculate data with formulas using a spreadsheet system.

d)

A powerful slide show presentation program.

2.

Which of the following is not a reason to use Microsoft Excel?

a)

To analyze and store data

b)

Utilize mathematical formulas to make the process easier.

c)

Managing expenses

d)

To create a power point presentation containing a lot of pictures for my Religion class.

3.

What is a work book ?

a)

A collection of one or more spreadsheets, also called worksheets, in a single file.

b)

A collection of cells organized in rows and columns. It is the working surface you interact with to enter data.

c)

An intersection of a column and row.

d)

Shows the address of the current selection or active cell.

4.

What is the Title Bar in Microsoft Excel?

a)

Shows the address of the current selection or active cell.

b)

Displays information entered—or being entered as you type—in the current or active cell.

c)

Displays both the name of the application and the name of the spreadsheet.

d)

A collection of icons that provides a shortcut to using a drop-down menu.

5.

Toolbars offer quick shortcuts to commonly used commands and can be moved and repositioned.

a)

True

b)

False

6.

The columns in an Excel sheet are named through the use of letters or combination of letters

a)

True

b)

False

7.

Each row is named by a number.

a)

True

b)

False

8.

Which of the following shows the address of the current selection or active cell.

a)

Formula Bar

b)

Tool Bar

c)

Name Box

d)

Cell

9.

Which of the following displays information entered—or being entered as you type—in the current or active cell. The contents of a cell can also be edited in the formula bar.

a)

Formula Bar

b)

Tool Bar

c)

Name Box

d)

Cell

10.

The __________ cell is the cell that receives data and commands you give it.

a)

Passive

b)

Active

c)

Intersected

d)

Pointed

11.

To scroll through the worksheet you can only use your Keyboard arrows.

a)

True

b)

False

12.

Each Excel worksheet is made up of more Excel Worksheets.

a)

True

b)

False

13.

What is the shortcut for copying data in Excel?

a)


Ctrl + X

b)


Ctrl + C

c)


Ctrl + V

d)


Ctrl + Z

14.

How can you correct a misspelled name in Excel without deleting other content?

a)


Click on the cell once

b)


Double-click the cell

c)


Use the delete key

d)


Use the backspace key

15.

What happens when you press Enter after typing in a cell?

a)


The active cell moves down

b)

The active cell moves up

c)


The cell content is deleted

d)


The cell color changes

16.

What is the first step before entering data into a cell in Excel?

a)


Press Enter

b)

Double-click the cell

c)

Select the cell

d)


Type the data immediately

17.
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
18.

What does the autofill handle in Excel help with?

a)


Changing cell color

b)


Extending patterns

c)


Creating charts

d)


Deleting data

19.

How can you insert a new column to the left of column A?

a)


Use the insert function in the Home tab

b)


Drag column A to the left

c)


Right-click column A and select insert

d)


Double-click the column header

20.

How can you extend the same number down multiple cells quickly?

a)


Type the number in each cell

b)

Use the fill handle

c)


Copy and paste manually

d)


Use the formula bar

21.

How can you quickly adjust a column's width to fit its content?

a)


Right-click and select 'Fit'

b)


Drag the column border

c)


Use the format menu

d)

Double-click the column border

22.

The first part is the sender's address - true or false?

a)

True

b)

False

23.

The second part of the business letter is the date. Which date is written correctly?

a)

Jan. 1 2021

b)

Jan, 1 2021

c)

Jan. 1, 2021

d)

Jan12021

24.

We use a business letter format to look professional.

a)

True

b)

False

25.

Which of these should you NOT use for a business letter?

a)

Contractions

b)

12 point font

c)

Creative fonts

d)

Informal language

e)

Formal language

26.

In most word-processing programs, what should you select in order to add a table to a document?

a)

File/print

b)

insert /table

c)

format/lists

d)

view/ print layout

27.

Which keyboard key will allow you to increase or decrease the indentation levels of the text?

a)

TAB

b)

CTRL

c)

SHIFT

d)

ENTER

28.

 Which table element runs vertically (up and down)? 

a)

Property

b)

Column

c)

Row

d)

Cell

29.

Which table element runs horizontally (left to right)? 

a)

Cell

b)

Row

c)

Column

d)

Property

30.

Each rectangular box in a table is called:

a)

a spreadsheet.

b)

a column. 

c)

a row

d)

a cell

31.

What should you select in order to access additional options for formatting a table?

a)

Table

b)

preferences

c)

Table properties

d)

paragraph styles

32.

When you resize the width of a column using your mouse, your pointer changes. How does your  pointer’s appearance change? 

a)

The pointer changes to a four-sided arrow. 

b)

The pointer changes to a large plus symbol.

c)

The pointer changes to a parallel lines with a double-sided arrow.

d)

 The pointer changes to a large white arrow.

33.

 What keys are used to decrease an indent in a list?

a)

 CTRL+TAB

b)

SHIFT+TAB

c)

 ALT+TAB

d)

 TAB+Left Arrow

34.

What keystroke will insert a new row at the end of a table?

a)

Backspace

b)

Enter

c)

Tab

d)

insert

35.

What is “cell padding”? 

a)

 The border between cells in a table.

b)

The space between each row of the table.

c)

 The space between the borders of the cell and the inside text.

d)

The space around the outside of the cell

36.

How do you remove a table from your document?

a)

Select the table and press the Delete key.

b)

Select the table and press the Enter key. 

c)

 Select a cell, right-click and choose Delete Row. 

d)

Select the table, right-click and choose Delete Table.

37.

What is another name for a numbered list? 

a)

Bulleted list

b)

Ordered list

c)

Lettered list

d)

Multi-level list

38.

The line that surrounds every cell in your table is called

a)

A border

b)

Divider

c)

marker

d)

grid

39.

 You can align the text in a cell to the left, center or right. You can also align it:

a)

top

b)

justified

c)

vertically

d)

horizontal

40.

A table can only be aligned: 

a)

Vertically

b)

left

c)

horizontally

d)

center

41.

How do lists and tables improve a document? 

a)

They list information in a specific order to outline all of the document’s content.

b)

 They break up the design and layout of the document to make it more visually appealing.

c)

They present your text in ways that make it easier for your audience to read and understand  quickly. 

d)

 They divide your document into smaller sections for easy formatting.

42.

In most word-processing programs, what should you select in order to add a table to a document?

a)

File/print

b)

insert /table

c)

format/lists

d)

view/ print layout

43.

Which keyboard key will allow you to increase or decrease the indentation levels of the text?

a)

TAB

b)

CTRL

c)

SHIFT

d)

ENTER

44.

 Which table element runs vertically (up and down)? 

a)

Property

b)

Column

c)

Row

d)

Cell

45.

Which table element runs horizontally (left to right)? 

a)

Cell

b)

Row

c)

Column

d)

Property

46.

Each rectangular box in a table is called:

a)

a spreadsheet.

b)

a column. 

c)

a row

d)

a cell

47.

What should you select in order to access additional options for formatting a table?

a)

Table

b)

preferences

c)

Table properties

d)

paragraph styles

48.

When you resize the width of a column using your mouse, your pointer changes. How does your  pointer’s appearance change? 

a)

The pointer changes to a four-sided arrow. 

b)

The pointer changes to a large plus symbol.

c)

The pointer changes to a parallel lines with a double-sided arrow.

d)

 The pointer changes to a large white arrow.

49.

 What keys are used to decrease an indent in a list?

a)

 CTRL+TAB

b)

SHIFT+TAB

c)

 ALT+TAB

d)

 TAB+Left Arrow

50.

What keystroke will insert a new row at the end of a table?

a)

Backspace

b)

Enter

c)

Tab

d)

insert

51.

What is “cell padding”? 

a)

 The border between cells in a table.

b)

The space between each row of the table.

c)

 The space between the borders of the cell and the inside text.

d)

The space around the outside of the cell

52.

How do you remove a table from your document?

a)

Select the table and press the Delete key.

b)

Select the table and press the Enter key. 

c)

 Select a cell, right-click and choose Delete Row. 

d)

Select the table, right-click and choose Delete Table.

53.

What is another name for a numbered list? 

a)

Bulleted list

b)

Ordered list

c)

Lettered list

d)

Multi-level list

54.

The line that surrounds every cell in your table is called

a)

A border

b)

Divider

c)

marker

d)

grid

55.

 You can align the text in a cell to the left, center or right. You can also align it:

a)

top

b)

justified

c)

vertically

d)

horizontal

56.

A table can only be aligned: 

a)

Vertically

b)

left

c)

horizontally

d)

center

57.

How do lists and tables improve a document? 

a)

They list information in a specific order to outline all of the document’s content.

b)

 They break up the design and layout of the document to make it more visually appealing.

c)

They present your text in ways that make it easier for your audience to read and understand  quickly. 

d)

 They divide your document into smaller sections for easy formatting.

58.

 In online collaboration, how do users differentiate each document? 

a)

By a unique file name

b)

By a unique web address 

c)

By a unique folder

d)

By a unique document ID number 

59.

Which term means that multiple users can work on the same document at the same time?

a)

saving

b)

Editing

c)

Formatting

d)

Collaboration

60.

Which term means that you allow access to your document only by the people or groups you choose,  and that you can allow either editing or read-only access?

a)

Editing documents

b)

granting permission

c)

Formatting tools

d)

saving files

61.

When working in Google Drive or One Drive, what feature is available to preserve all changes to the  document without using the Save command?

a)

print

b)

view

c)

translate

d)

Autosave

62.

Which type of sharing option allows you to revise another user’s document?

a)

can comment

b)

can view

c)

can save

d)

can edit

63.

Which type of sharing option allows you to read another user’s document but not modify it in any  way? 

a)

can edit

b)

can save

c)

can view

d)

can comment

64.

When working in Google Drive or One Drive, what command allows you to make a copy of document  and store it locally on your computer? 

a)

Download

b)

publish on website

c)

email collaborators

d)

E-mail as attachment

65.

 What command will display a list of changes made to the document, including the date the changes  were made and the identity of the person who made the changes?

a)

share

b)

download

c)

details

d)

Revision/Version History

66.

 What does the term "real-time collaboration" mean? 

a)

 Working on a document with multiple users at the same time

b)

Sending a document as an attachment to an e-mail message

c)

 Publishing a document to the Web 

d)

printing a document

67.

 What command can recreate your document in another language? 

a)

Language

b)

Translate document

c)

save as

d)

research

68.

 What tool enables you to include feedback regarding the document content without changing any  content? 

a)

Footnote

b)

track changes

c)

comments

d)

Suggesting mode

69.

When in Google Docs Suggesting Mode or if Track Changes is turned on in your Microsoft Word  document, deleted text displays as: 

a)

blue text

b)

red text

c)

strike-through

d)

italics

70.

 When in Google Docs Suggesting Mode or if Track Changes is turned on in your Microsoft Word  document, if a change was made to your document by another collaborator and you do not want the  revision incorporated, what do you do? 

a)

reject it

b)

accept it

c)

Delete it

d)

Comment on it

71.

 When working in Google Drive or One Drive, what command allows you to bring back a prior version  of your document? 

a)

save as

b)

Revision or Version History

c)

Redo

d)

Restore

72.

When collaborating with others in a single document, what formatting feature is used to uniquely  identify each collaborator’s revisions?

a)

Font size

b)

Font color

c)

Highlight

d)

 Strike-through

73.

 How many collaborators can be working simultaneously in an online document?

a)

200

b)

50

c)

100

d)

75

74.

 When working in Google Drive or One Drive, what command allows you generate and share a copy of  the document with someone outside of your collaboration circle? 

a)

Download

b)

Publish on the web

c)

E-mail collaborators

d)

E-mail as attachment

75.

Where are the shared Google Drive and One Drive storage spaces located?

a)

My computer

b)

The internet cloud

c)

My schools network

d)

An external hard drive

76.

 Working in Suggesting Mode or with Track Changes enabled, a collaborator has added a paragraph  of text to your document. It is a good revision and you want to make it a permanent part of your  document. What do you do?

a)

Accepted the change

b)

Reject the change

c)

Comment on the change

d)

Delete the change

77.

Using Google Drive and One Drive, real-time collaboration can occur:

a)

using only your computer and an internet connection.

b)

using only your computer and your phone with an internet connection.

c)

using only your phone.

d)

 using your phone, tablet and computer with an internet connection.