wayground logo

Free Printable Worksheets

NEW

Font size

S
M
L
XL
Worksheets

ICT Review

Total questions: 20

Worksheet time: 10mins

Name
Class
Date
1.

1.    What is a spreadsheet?

a)

A computer program used for creating and managing spreadsheets

b)

A piece of paper used for recording numerical data

c)

A database management system

d)

A graphical user interface

2.

What is the default file format for Microsoft Excel?

a)

.docx 

b)

.pptx

c)

.xlsx

d)

.pdf

3.

1.    Which of the following is NOT a way to reference a cell in a formula?

a)

A1

b)

B2

c)

C3

d)

1A

4.

Which of the following is not a valid way to enter data into a cell in a spreadsheet?

a)

Typing in the data

b)

Copying and pasting the data

c)

Dragging and dropping the data

d)

Using the voice input feature

5.

  What is the name of the area in the Excel window that displays the current zoom level and allows you to adjust it?

a)

Formula Bar

b)

Status Bar

c)

Name Box

d)

Zoom slider

6.

Which symbol is used to begin a formula in a spreadsheet program?

a)

%

b)

&

c)

@

d)

=

7.

Which of the following is a tool used to format numbers, currency, and dates in Excel?

a)

Sort

b)

Filter

c)

Conditional Formatting

d)

Formal Cells

8.

Which of the following is a tool used to add borders, shading, and colors to cells in Excel?

a)

Sort

b)

Filter

c)

Conditional Formatting

d)

Format cells

9.

Which of the following is a tool used to display data in a chart or graph in Excel?

a)

Sort

b)

Filter

c)

Conditional Formatting

d)

Charts

10.

You have a table with multiple columns and rows, and you want to highlight the entire row when the value in column A is greater than 50. Which of the following formatting options would you use?

a)

Conditional Formatting

b)

Number Format

c)

Fill Color

d)

Font

11.

    You want to add a picture as a background to a worksheet. Which of the following formatting options would you use?

a)

Themes

b)

Styles

c)

Effects

d)

Backgrounds

12.

  You want to merge two cells together in Excel. Which of the following formatting options would you use?

a)

Merge and Center

b)

Center Across Selection

c)

Merge Cells

d)

Wrap Text

13.

You have a large worksheet with multiple cells containing text. You want to check the spelling in all of the cells at once. Which of the following options would you use?

a)

Spell Check

b)

Find and Replace

c)

Data Validation

d)

Conditional Formatting

14.

  You have a cell that is marked as a misspelled word by the spell check, but you want to keep the word as it is. Which of the following options would you use?

a)

Ignore

b)

Ignore All

c)

Add to dictionary

d)

Change

15.

    You want to print the worksheet on a single page, but the chart and some of the cells spill over to the next page. Which print option would you use to fix this?

a)

Scale to fit

b)

Page Orientation

c)

Margins

d)

Paper size

16.

  What is the keyboard shortcut for pasting data in a spreadsheet?

a)

Ctrl+C

b)

Ctrl+V

c)

Ctrl+X

d)

Ctrl+M

17.

    Which function is used to calculate the average value of a range of cells in a spreadsheet program?

a)

MAX

b)

AVERAGE

c)

MIN

d)

SUM

18.

Which of the following formula examples is correctly formatted to subtract the value in cell B1 from the value in cell A1?

a)

A1-B1

b)

B1-A1

c)

A1/B1 

d)

B1/A1

19.

Which of the following is an example of an absolute cell reference in a formula?

a)

$A$1   

b)

A$1

c)

$A1     

d)

A1

20.

Which of the following is not a common spreadsheet program?

a)

Microsoft Excel

b)

Adobe Photoshop

c)

Google Sheets

d)

Apple Numbers