wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

CXC CSEC IT Grade 10 - End of Term Assessment 2024 December

Total questions: 100

Worksheet time: 2hrs 40mins

Name
Class
Date
1.
The section of a spreadsheet where a single row and a single column intersect is referred to as a (an)
a)
interstate
b)
intersection
c)
cell
d)
point
2.
Spreadsheets consists of ________ and _______.
a)
tables and chairs
b)
rows and tables
c)
rows and columns
d)
columns and tables
3.
The vertical set of cells are known as _______
a)
rows
b)
columns
c)
straight lines
d)
verts
4.
The set of cells that are horizontal in direction on a spreadsheet are referred to as 
a)
rows
b)
columns
c)
cells
d)
spreadsheet
5.
When a cell is made larger it is said to be  ________
a)
enlarged
b)
expanded
c)
bigger
d)
contracted
6.

Google Sheets is what sort of program?

a)

A document program

b)

A spreadsheet program

c)

A presentation program

d)

A television program

7.

What does the =COUNTIF formula do?

a)

Counts things

b)

Counts how often something occurs

c)

Counts how many different things are there

d)

Counts how many things are in a list

8.

How do you add a new column?

a)

Click on the "Edit" menu and choose "Insert Column"

b)

Click on the "Insert" menu and choose "Column Left" or "Column Right".

c)

Right-click on the top label of the column and choose "Insert a new column"

d)

Click on the "Edit" menu and choose "Give me a new column please!"

9.

If I click on this small blue square and drag downwards, what will happen?

a)

The cells below will be filled with 1, 2, 1, 2, 1, 2, etc.

b)

The numbers 3, 4, 5, etc will be added to the cells below.

c)

The cells will get bigger.

d)

The cells below will only be shaded blue.

10.

How do you get something like this in your spreadsheet?

a)

Select the cells containing the data then click the "Insert" menu then choose "Chart"

b)

Select the cells containing the data then click the "Edit" menu then choose "Insert Chart"

c)

Select the cells containing the data then click the "Insert" menu then choose "Pie"

d)

Click the "Help" button, choose "Report a problem" and then type "My teacher didn't teach me how to do this crazy stuff!".

11.

Which type of chart is best used to represent trend over time?

a)

bar

b)

combination

c)

line

d)

pie

12.

A group of cells is called a ________.

a)

cell cluster

b)

cell range

c)

multicell

d)

chart

13.

Where is the fill handle located?

a)

At the beginning of any formula or function

b)

In the bottom-right corner of the selected cell

c)

In Backstage view

d)

On the right side of the Home tab on the Ribbon

14.

You can click the tabs at the bottom of a workbook to switch between ________.

a)

permissions

b)

number formats

c)

formulas

d)

worksheets

15.

You’re trying to find your average grade. What’s wrong with the formula shown in the image?

a)

It should have an equals sign (=) at the beginning

b)

It should use the COUNT function instead

c)

It should use quotation marks instead of parentheses

d)

There is nothing wrong with the formula

16.

True or False:

You can view a formula by double-clicking the cell that contains the formula.

a)

True

b)

False

17.

Which of the following is an absolute cell reference?

a)

$A$2

b)

A2

c)

A:2

d)

#A2

18.

Which of the formulas below are valid? Select all that apply.

a)

A3+100

b)

=F2+F3+F4-53

c)

=5B+6B

d)

=R2*D2

19.
What is the name of a computer program used for organising information in rows and columns?
a)
Spreadsheet
b)
Presentation
c)
Publisher
d)
Browser
20.
Rows are identified using ________?
a)
Numbers
b)
Letters
c)
Numbers & Letters
d)
Cells
21.
In Excel, what do all formula begin with?
a)
!
b)
-
c)
+
d)
=
22.
The location of a cell on a spreadsheet. It is a column letter followed by a row number.
a)
Cell range
b)
Cell reference
c)
Active cell
d)
Row
23.
Data in a spreadsheet table can be sorted by single or multiple columns and alphabetically and numerically
a)
True
b)
False
24.
Which career(s) or places of employment involve the use of a spreadsheet at work?
a)
Accountant
b)
Hospital
c)
All Choices
d)
Shop Keeper
25.
What would you format a cell as when working with amounts of money?
a)
currency
b)
percent
c)
number
d)
scientific
26.
If I want to make a cell a particular color, which button would I click on?
a)
orange arrow
b)
red arrow
c)
blue arrow
d)
green arrow
27.
What type of graph is this?
a)
Bar Graph
b)
Line Plot
c)
Pictograph
d)
Tally Chart
28.
How many students have blue for a favorite color?
a)
11
b)
12
c)
14
d)
17
29.

Which circle graph has the same data as the bar graph?

a)
b)
c)
d)
30.
How many mountain bikes were sold?
a)
22
b)
28
c)
16
d)
6
31.

A spreadsheet is made up of one "workbook" and can have have many "worksheets".

a)

True

b)

False

32.

Worksheets appear as tabs at the bottom of the spreadsheet.

a)

True

b)

False

33.
A graph is a visual representation of data within a spreadsheet.
a)
True
b)
False
34.

What is the purpose of spreadsheet?

a)

To present information on different engaging slides

b)

To deliver a speech to a crowd

c)

To perform basic and complex mathematical calculation

d)

To excel your research papers and citations

35.

Each box on a spreadsheet is called a ________________.

a)

Box

b)

Cell

c)

Row

d)

Column

36.

The letter at the top of each column is called a:

a)

Cell reference

b)

Column header

c)

Row header

d)

Range

37.

The cell that is currently selected

a)

Cell reference

b)

Cell range

c)

Label

d)

Active cell

38.

A single page in Excel is called a:

a)

Worksheet

b)

Workbook

39.

Multiple pages in Excel is called a:

a)

Worksheet

b)

Workbook

40.

Which is an example of a cell reference in a spreadsheet?

a)

6C

b)

45

c)

fall

d)

B9

41.

Double-clicking between two columns will _______________ the column.

a)

Delete

b)

Resize

c)

Copy

d)

Fill

42.

If you want to change the colour of the text inside a cell, which tool would you use?

a)

Text colour

b)

Borders

c)

Fill colour

d)

Bold

43.

Place where you can rename each worksheet is called _______________. It is located at the bottom of the worksheet window.

a)

Name Box

b)

Formula

c)

Chart

d)

Sheet Tab

44.

SUM, AVERAGE, MAX and IF are examples of what?

a)

Formulae

b)

Function

c)

Tables

d)

Statistical Tools

45.

When you key in a formulae or function in a spreadsheet, what do you key in first?

a)

Addition symbol

b)

Hashtag symbol

c)

Equal symbol

d)

Asterisk symbol

46.

In Excel, what is this button used for?

a)

To change the border colour

b)

To change the colour of an image

c)

To change the font colour

d)

To fill the cell with a colour

47.

Which tab in Excel has charts and tables?

a)

Home tab

b)

Insert tab

c)

File tab

d)

View tab

48.

Businesses use spreadsheets for all of the following EXCEPT:

a)

Produce financial documents such as estimates and invoices

b)

Represent data in graphical format

c)

Produce statistical reports e.g. to compare quantities of goods

d)

Make presentations to an audience

49.

In a spreadsheet document each page is called a:

a)

worksheet

b)

label

c)

cell

d)

address

50.

The files that are created with Spreadsheet software are called

a)

Package

b)

Program

c)

Workbook

d)

Word

51.

The bar below will allow you to insert a ......

a)

spreadsheet

b)

answer

c)

formula

d)

quizz

52.

This section of the worksheet shows the .....

a)

formula

b)

value

c)

cell function

d)

cell address

53.

The cells are identified by their:

a)

Row and column position

b)

row position

c)

column

d)

row

54.

C4, F5, B7 are all examples of:

a)

cell reference

b)

column number

c)

row number

d)

cell address

55.

The correct formula to find average is:

a)

average(cells)

b)

=avg(range of cells)

c)

=average(range of cells)

d)

average(range of cell)=

56.

Which of these formulae will calculate the sum of a range of cells A4 to D4:

a)

=sum(A4 to D4)

b)

sum of A4 - D4 =

c)

Add A4 to D4 =

d)

=sum(A4:D4)

57.

Which of the following data can be typed into a Spreadsheet cell?

a)

Formulae

b)

Text

c)

Numbers

d)

All of these

58.

The intersection of rows and columns creates

a)

cell

b)

value

c)

cell address

d)

spreadsheet

59.

The icon that allows a user to calculate the sum of a range of adjacent cells is:

a)
b)
c)
d)
60.

To sort a range of selected cells in descending order this icon can be selected:

a)
b)
c)
d)
61.

The type of chart displayed is a ………. chart?

a)

pie

b)

line

c)

bar

d)

column

62.

Observe the chart shown, the formula to calculate the total for March (Mar) would be:

a)

=sum(D2:D4)

b)

=sum(B5:D5)

c)

=sum(D2:D4)

d)

=sum(D2..D4)

63.

The formula to determine the Average number of pies sold would be:

a)

=AVE(B2:D5)

b)

=AVERAGE(B2:D4)

c)

=(B2:D4):AVERAGE

d)

=AVERAGE(B2:D5)

64.

To determine the maximum number of pies sold this formula was used:

a)

=min(B2:D5)

b)

=(B2:D4):max

c)

=max(B2:D5)

d)

=max(B2:D4)

65.

Identify the formatting feature that has been applied to the worksheet heading.

a)

Wrap text

b)

Currency style

c)

Merge and center

d)

Center text alignment

66.

Which of the following formatting features was applied to the label for column A?

a)

wrap text

b)

ascending order

c)

left text alignment

d)

middle alignment

67.

In which tab will you be able to find the chart creating feature?

a)

home

b)

data

c)

page layout

d)

insert

68.

To sort data in a list, you can use the sorting features which are found in the ______ tab.

a)

page layout

b)

data

c)

formula

d)

insert

69.
All functions and formulas begin with which symbol?
a)
#
b)
/
c)
:
d)
=
70.
Which of the following is a FORMULA that will add cells c9 and c10?
a)
=c9+c10
b)
c9+c10
c)
sum(c9:c10)
d)
=sum(c9:c10)
71.
A formula that automatically adds up a column of numbers is called __________.
a)
cell
b)
auto sum
c)
graph
d)
value
72.
A mathematical operation is called a _____.
a)
formula
b)
range
c)
label
d)
graph
73.
A graph is a visual representation of data within a spreadsheet.
a)
True
b)
False
74.

What key is used to select multiple ranges of cells?

a)

Shift

b)

CTRL

c)

ALT

d)

Shift+ALT

75.

Which of the following cursor allows you to select a range of cells

a)
b)
c)
d)
76.

What is the formula to work out the MIN of the highlighted cells?

a)

=MIN(C1:Q1)

b)

=MIN(C15:Q15)

c)

=C15:Q15

d)

+MIN(E15:15)

77.

What is the formula to work out the AVERAGE of the highlighted cells?

a)

=AVERAGE(C1:Q1)

b)

=AVERAGE(C2:C8)

c)

=AVERAGE(C15:Q15)

d)

=C15:Q15

78.

What value would you get if you put in the formula: =A1*B1

a)

2

b)

3

c)

4

d)

Error

e)

rumus

79.

If you wanted to add the values in four consecutive cells together which function would you use?

a)

SUM

b)

MIN

c)

MAX

d)

AVERAGE

80.

What is the cell reference of the cell with value Sprite Lite inside?

a)

8A

b)

C5

c)

A8

d)

B8

81.

In Excel a Workbook contains how many worksheets?

a)

1

b)

2

c)

3

d)

4

82.

What is the name of this Toolbar?

a)

Menu bar

b)

Tittle bar

c)

Formula bar

d)

None of the above

83.

What is this called in Excel?

a)

Column

b)

Row

c)

Numbers

d)

Cell

84.

What's the name of the Cell that is highlighted?

a)

3B

b)

B2

c)

C3

d)

B3

85.

The _______________________ is located along the right side/edge of the screen and is used to move up or down the spreadsheet.

a)

Mouse

b)

Vertical Scroll Bar

c)

Horizontal Scroll bar

d)

Menu Bar

86.

The cell that is highlighted that receives the data or command you give it or type in is called ________________.

a)

Spreadsheet

b)

Column

c)

Active Cell

d)

worksheet

87.

Spreadsheet is mainly used for _________________.

a)

Written Text

b)

Add Images

c)

Calculations

d)

Presentation

88.

C5 is known as the ________________.

a)

Cell

b)

Row Name

c)

Cell Address

d)

Column Name

89.

Name the image.

a)

Cell Reference

b)

Name Box

c)

Formula Bar

d)

Standard Toolbar

90.

What is the name of the image?

a)

Name Box

b)

Formula Bar

c)

Cell

d)

Menu bar

91.

A darkened border around a cell that identifies it is called ______________________.

a)

Cell

b)

Column

c)

Cell Pointer

d)

Row

92.

You are on column Z in your worksheet, What would be the name of the next column if you need to add another column?

a)

ZA

b)

A

c)

AA

d)

Z1

93.

Spreadsheet is used for all of the following except_________________.

a)

Loan Calculation

b)

Prepare Payroll

c)

Prepare a Memo

d)

Prepare Grades

94.
Which of the following is a formula that will multiply cells A1 and A2?
a)
A1*A2
b)
=A1:A2
c)
=A1*A2
d)
=Multiply(A1:A2)
95.
Which of the following is a formula that will divide cell D10 by 2?
a)
=D10/A2
b)
10/2
c)
=D10*2
d)
=D10/2
96.
Which of the following is a correct example using the AUTOSUM function?
a)
sum(D14:D19)
b)
=D14:d19
c)
=sum(D14:D19)
d)
=D14+D15+D16+D17+D18+D19
97.
Which formula gets the biggest value of a range of cells?
a)
MAX
b)
MIN
c)
LARGE
d)
SUM
98.
Which formula gets the smallest value of a range of cells?
a)
MAX
b)
MIN
c)
SMALL
d)
SUM
99.

to find out how many persons are there in a certain field, the following function is applied

a)

average(--:--)

b)

count(--:--)

c)

counta(--;--)

d)

counta(--:--)

100.
Which of the following would NOT be stored in a cell?
a)
Formula
b)
Text
c)
Number
d)
Chart

Similar Resources on Wayground

X TKJ 1 ( 23-11-2023 )

100 questions

X TKJ 1 ( 23-11-2023 )

quiz

Worksheet

•

10th Grade

QUIZ 1

101 questions

QUIZ 1

quiz

Worksheet

•

6th Grade - University

Information Technology

96 questions

Information Technology

quiz

Worksheet

•

7th - 12th Grade

PTS INFORMATIKA 2023 - GENAP

100 questions

PTS INFORMATIKA 2023 - GENAP

quiz

Worksheet

•

10th Grade

PRETEST EXCEL & SCRATCH

100 questions

PRETEST EXCEL & SCRATCH

quiz

Worksheet

•

9th - 12th Grade

Ulangan Informatika Kelas 7 Sem 1

100 questions

Ulangan Informatika Kelas 7 Sem 1

quiz

Worksheet

•

7th Grade - University

AWS Cloud Practitioner

103 questions

AWS Cloud Practitioner

quiz

Worksheet

•

9th - 12th Grade

Financial Literacy LIFE TEST

100 questions

Financial Literacy LIFE TEST

quiz

Worksheet

•

8th - 12th Grade