wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

ICT Final

Total questions: 100

Worksheet time: 56mins

Name
Class
Date
1.

The cell in the worksheet in which you can type data.

a)

Active Cell

b)

Formula

c)

Landscape

d)

Range

2.

The intersection of a column and a row in a table or worksheet.

a)

Workbook

b)

Column

c)

Sheet Tab

d)

Cell

3.

A unique identifier for a cell, which is formed by coming the cells's column letter and row numbers.

a)

IF Function

b)

Cell Reference

c)

Pivot Table

d)

AutoSum

4.

A vertical stack of cells in a table or worksheet.

a)

Sheet Tab

b)

Row

c)

Column

d)

Range

5.

An equation that calculates a new value from values currently in a worksheet.

a)

Formula

b)

Active Cell

c)

Row

d)

Spreadsheet

6.

The box that displays a formula when the cell of a worksheet contains a calculated value.

a)

Portrait Orientation

b)

Formula Bar

c)

Fill Handle

d)

Cell Reference

7.

A page or worksheet rotated so it is wider than it is long.

a)

Landscape Orientation

b)

Portrait Orientation

c)

Spreadsheet

d)

Workbook

8.

A page or worksheet rotated so it is longer than it is wide. (Default page orientation)

a)

Range

b)

Landscape

c)

Spreadsheet

d)

Portrait

9.

A group of selected cells.

a)

Absolute Cell Reference

b)

Range

c)

Formula Bar

d)

Cells

10.

The horizontal placement of cells in a table or worksheet.

a)

Column

b)

Row

c)

Sheet

d)

Cell Reference

11.

The worksheet identifier that appears at the bottom of the workbook window

a)

Sheet Tab

b)

Workbook

c)

Border

d)

Number Format

12.

A grid of rows and columns in which you enter text, numbers, and the results of calculations.

a)

Absolute Cell Reference

b)

Cell Style

c)

Theme

d)

Spreadsheet

13.

The file used to store worksheets; usually a collection of related worksheets.

a)

Range

b)

AutoSum

c)

Workbook

d)

Chart

14.

A computerized spreadsheet in Excel.

a)

Worksheet

b)

Workbook

c)

Style

d)

Theme

15.

A line around the edges of a cell.

a)

Cell Reference

b)

Fill Handle

c)

Cut

d)

Border

16.

A collection of formatting characteristics you apply to a cell or range of data.

a)

Cell Style

b)

Font

c)

Workbook

d)

AutoSum

17.

The design of text.

a)

Font

b)

Cell

c)

Range

d)

Merge

18.

To combine multiple cells into one cell.

a)

Absolute Cell Reference

b)

Theme

c)

Merge

d)

Pivot Table

19.

Formatting option that changes the way numbers/data look in a cell.

a)

Copy

b)

Merge

c)

Formula

d)

Number Format

20.

To place a copy of selected text on the Clipboard or the Office Clipboard.

a)

Paste

b)

Copy

c)

Cut

d)

Formula

21.

To remove selected text and place it on the Clipboard or the Office Clipboard.

a)

Copy

b)

Paste

c)

Fill

d)

Cut

22.

The small square in the lower-right corner of the active cell or range that you drag over the cells you want to fill.

a)

Fill Handle

b)

Sheet Tab

c)

Cell

d)

Formula

23.

A cell reference that does not change when copied or moved to a new cell. Uses the $ symbol. Between the column letter & row number

a)

Cell Reference

b)

Auto Sum

c)

Absolute Cell Reference

d)

Merge

24.

A button on the Ribbon that inserts the Sum function to add long columns or rows of numbers.

a)

Average

b)

IF Function

c)

Formula Bar

d)

AutoSum

25.

A visual representation of worksheet data

a)

Spreadsheet

b)

Chart

c)

Copy

d)

Fill Handle

26.

A logical function that asks Excel to perform one of two different calculations based on whether your data matches a logical test.

a)

Formula

b)

AutoSum

c)

IF Function

d)

NOW()

27.

What does the equal sign (=) signify in Excel formulas?

a)

It is used to multiply values

b)

It is used to add values

c)

It is required as the first symbol for all formulas

d)

It is used to subtract values

28.

What is the purpose of the asterisk (*) in Excel?

a)

To add values

b)

To subtract values

c)

To multiply values

d)

To divide values

29.

What is the function of Autofill in Excel?

a)

To change the color of cells

b)

To copy a formula into multiple cells

c)

To adjust the column width

d)

To create a chart

30.

What type of chart uses vertical bars to display data?

a)

Line Chart

b)

Pie Chart

c)

Column Chart

d)

Scatter Plot

31.

Which chart is best for visualizing trends and shifts in data?

a)

Column Chart

b)

Line Chart

c)

Pie Chart

d)

Bar Chart

32.

What function is used to count cells with numbers, including negative numbers and percentages?

a)

SUM

b)

MAX

c)

COUNT

d)

MIN

33.

Which function is used to find the highest number in a batch of cells?

a)

MIN

b)

SUM

c)

MAX

d)

AVERAGE

34.

What does the 'Sum' function do?

a)

Subtracts numbers

b)

Divides numbers

c)

Multiplies numbers

d)

Sums two or more cells of data

35.

What is a workbook in Excel?

a)

A single page in Excel

b)

A file containing one or more worksheets

c)

A tool for creating charts

d)

A function for calculating data

36.

What symbol is used at the beginning of all formulas and functions in Excel?

a)

+

b)

-

c)

=

d)

*

37.

Which function is used to find the lowest number in a batch of cells?

a)

MAX

b)

SUM

c)

MIN

d)

AVERAGE

38.

What is a worksheet in Excel?

a)

A file containing multiple workbooks

b)

A single page in Excel where you can enter data and perform calculations

c)

A tool for creating charts

d)

A function for calculating data

39.

What is the function of the '+' symbol in Excel formulas?

a)

To subtract numbers

b)

To add numbers

c)

To divide numbers

d)

To multiply numbers

40.

What is the function of the '-' symbol in Excel formulas?

a)

To add numbers

b)

To subtract numbers

c)

To divide numbers

d)

To multiply numbers

41.

What is the function of the '*' symbol in Excel formulas?

a)

To add numbers

b)

To subtract numbers

c)

To divide numbers

d)

To multiply numbers

42.

What type of chart helps organize and show data as a percentage of a whole.

a)

Pie Chart

b)

Column Chart

c)

Line Chart

d)

Bar Chart

43.

What symbol appears when a column is not wide enough?

a)

Hashtag: ####

b)

Forward Slash: ////

c)

At Sign: @@@@

d)

Currency Sign: $$$$

44.

What does Autofill do?

a)

Allows you to copy a formula to other cells

b)

Fills a cell with a desired symbol

c)

Fills the cell with the specified color

45.

What type of chart uses horizontal bars to present the data?

a)

Bar Chart

b)

Line Chart

c)

Column Chart

d)

Pie Chart

46.

A cell reference refers to the location of a specific cell (e.g. A1, C17, D5, etc.)

a)

True

b)

False

47.

The intersection of a row and column

a)

Active Cell

b)

Sort

c)

Cell Range

d)

Cell

48.

A graph that shows parts to a whole

a)

Bar graph

b)

Pie Graph

c)

Line graph

d)

Graph

49.

If you click on a letter at the top of an Excel spreadsheet, what have you done?

a)

selected a cell

b)

selected a range of cells

c)

selected a row of data

d)

selected a column of data

50.

What is the purpose of the following command?

a)

Change the background color of a cell

b)

Change the color of text in a cell

c)

Change the border color around the cell

d)

Answer not listed.

51.

A four-sided arrow does what in Excel?

a)

copies the contents of one cell to others around it

b)

moves the contents of one cell to another location

c)

selects the cell

52.

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

a)

row

b)

column

c)

cell range

d)

cell grouping

53.

Mathematical Calculation

a)

Formula

b)

Spreadsheet

c)

Function

d)

Cell Range

54.

Margins are the white space on the spreadsheet where nothing prints.

a)

True

b)

False

55.

Text or words in a spreadsheet

a)

Label

b)

Graph

c)

Sort

d)

Active Cell

56.

The cell that is currently selected for data entry

a)

Cell Address

b)

Active Cell

c)

Cell Range

d)

Values

57.

A preprogrammed formula

a)

Formula

b)

Spreadsheet

c)

Function

d)

Cell Range

58.

When identifying a cell, the column is listed first.

a)

True

b)

False

59.

A graph that shows trends over time

a)

Bar graph

b)

Pie Graph

c)

Line graph

d)

Graph

60.

A graph that compares values

a)

Bar graph

b)

Pie Graph

c)

Line graph

d)

Graph

61.

Every formula starts with what?

a)

=

b)

+

c)

-

d)

( )

62.

To put data in a certain order is to _____________.

a)

Label

b)

Sort

c)

Cell Range

d)

Select data

63.

If you change the value in a cell then the associated graph will NOT change.

a)

True

b)

False

64.
A single location on a spreadsheet is a...
a)
row
b)
cell
c)
range
d)
column
65.
A single highlighted location (contains a dark outlined box on a spreadsheet that is ready to insert data is a/an...
a)
cell
b)
row
c)
active cell
d)
home address
66.
Horizontal portions of the spreadsheet identified by numbers (1, 2, 3..) are…
a)
columns
b)
rows
c)
active cell
d)
name box
67.
A location at the top of the spreadsheet that shows all the contents of the active cell and where you can make error corrections is the
a)
formula bar
b)
menu bar
c)
scroll bar
68.
Excel is a __________ software
a)
word processing
b)
slide show presentation
c)
spreadsheet
69.
The “HOME” position on a spreadsheet is…
a)
A1
b)
F1
c)
F5
d)
A8
70.
The combination keystroke that takes the active cell to “home position” is…
a)
Ctrl + End
b)
Ctrl + Home
c)
Shift +Home
71.
A column letter and a row number (ex:  A3, F15..) are referred to as the 
a)
Status Area
b)
Mode Indicator
c)
Cell Address
d)
Formula Bar
72.
Text that is entered onto a spreadsheet are considered as 
a)
labels
b)
values
c)
numeric labels
d)
irrelevant data
73.
Numbers that WILL NOT be calculated that need to stay to the left of the cell are
a)
labels
b)
values
c)
numeric labels
74.
The special prefix label that needs to be entered before a number as a label and not be calculated – and stay to the left of the cell is a 
a)
apostrophe (')
b)
hyphen (-)
c)
Question Mark (?)
d)
Plus (+)
75.
What does F.I.C.A. represent on a paycheck?
a)
Federal Taxes
b)
Social Security
c)
Gross Pay
d)
Fishing In Canada Always
76.
Which is NOT one of the  3 “Go To” methods of getting to a cell quickly?
a)
Ctrl + G
b)
Name Box
c)
F5
d)
Formula Bar
77.
An itemized list of goods on hand is called a/an...
a)
inventroy
b)
budget
c)
payroll
d)
detailed list
78.
Values are numbers that will be calculated – which side of the cell do they go to automatically?
a)
Right
b)
Left
c)
Center
d)
They automatically wrap.
79.

In the formula   = A$1 * C3   which of the following is the MIXED CELL Reference found in that formula?

a)

*

b)

=

c)

A$1

d)

C3

80.

In the formula   =C4*$C$2   which of the following is the ABSOLUTE CELL REFFERENCE found in that formula?

a)

=

b)

C4

c)

*

d)

$C$2

81.

In the formula    =B5*$C$2     which of the following is the RELATIVE CELL REFERENCE found in that formula?

a)

$C$2

b)

B5

c)

=

d)

*

82.

$C$2 is an example of a _____________ Cell Reference.

a)

Absolute

b)

Mixed

c)

Relative

d)

locked

83.

What symbol is used in order to make a cell reference an ABSOLUTE CELL REFERENCE?

a)

$

b)

%

c)

?

d)

=

84.

_________________do not change when copied or filled. You can use an absolute reference to keep a row and/or column constant.

a)

Relative Cell Reference

b)

Absolute Cell Reference

c)

Mixed Cell References

d)

Abnormal Cell References

85.

Basic cell references that adjust and change when copied especially when using AutoFill.

a)

Absolute Cell Referencing

b)

Relative Cell Referencing

c)

Mixed Cell Referencing

d)

Dynamic Cell Referencing

86.

Which of the following would represent a RANGE of cells?

a)

C1: C9

b)

C1, C2, C3

c)

C1, C8

d)

D1

87.

Which of the following symbols is used to divide in Microsoft Excel?

a)

=

b)

*

c)

/

d)

+

88.
The ________ function is used to find the total of a group of numbers.
a)
=average
b)
=total
c)
=max
d)
0=sum
89.
On an Excel sheet the active cell is indicated by
a)
a thick wide border
b)
a dotted border
c)
a blinking border
d)
none of these
90.
An example of a cell range is 
a)
A1;B3
b)
Al:B3
c)
Al-B3
d)
Al+b3
91.
Which program is a component of the office suite that is best suited for working with numbers and formulas It is similar to a calculator.
a)
Microsoft PowerPoint
b)
Microsoft Word
c)
Microsoft Excel
d)
MicroType
92.
In Microsoft Excel, which symbol goes in front of all formulas
a)
= (equal sign)
b)
+ (plus sign)
c)
# (pound symbol)
d)
! (Exclamation Mark)
93.
The ______ function is used to find the average of a group of numbers.
a)
=min
b)
=average
c)
=total
d)
=max
94.
In a spreadsheet, rows are identified by_____
a)
numbers
b)
Letters
c)
spaces
d)
cells
95.
The formula =sum(A2;I2) is valid
a)
True
b)
False
96.
The Save As command allows you to save a workbook with a new filename or to a new location.
a)
False
b)
True
97.
In a spreadsheet columns are identified by_______.
a)
Numbers
b)
Letters
c)
Cells
d)
Spaces
98.
######## means.
a)
You've entered a wrong number
b)
The answer is incorrect
c)
The cell is not wide enough
d)
You misspelled something
99.
The button used to combine several cells to make one one.
a)
Comb
b)
Combine and Center
c)
Merge and Combine
d)
Merge and Center
100.
To add a header and footer to a spreadsheet, you should.
a)
Click on File, Page Setup, click on the header/footer tab.
b)
Click on the Insert Tab, and press the Header/Footer button
c)
None of the above
d)
Press Enter H for header of Control F for footer

Similar Resources on Wayground

Quiz sobre Fundamentos de TI

100 questions

Quiz sobre Fundamentos de TI

quiz

Worksheet

•

KG - University

Bilgi Otomasyonu / Hastane Otomasyonu

95 questions

Bilgi Otomasyonu / Hastane Otomasyonu

quiz

Worksheet

•

1st Grade

Informatica

100 questions

Informatica

quiz

Worksheet

•

12th Grade

uk hóa lý thuyết trăm trứng

100 questions

uk hóa lý thuyết trăm trứng

quiz

Worksheet

•

11th Grade

Ôn tập KTGK2 11A5

100 questions

Ôn tập KTGK2 11A5

quiz

Worksheet

•

11th Grade

ENSA MIDTERM 7,8,9

100 questions

ENSA MIDTERM 7,8,9

quiz

Worksheet

•

12th Grade - Professi...

Kon Banega..... Jisko Jo karna hai karo

101 questions

Kon Banega..... Jisko Jo karna hai karo

quiz

Worksheet

•

Professional Development

QuizziCom FACULTY OF COMMERCE

100 questions

QuizziCom FACULTY OF COMMERCE

quiz

Worksheet

•

University