wayground logo

Free Printable Worksheets

NEW

Font size

S
M
L
XL
Worksheets

G3 Final 2 MS Excel Review

Total questions: 47

Worksheet time: 22mins

Name
Class
Date
1.
What is the name of a computer program used for organising information in rows and columns?
a)
Spreadsheet
b)
Presentation
c)
Publisher
d)
Browser
2.

Columns are named using _______?

a)

Numbers

b)

Letters

c)

Numbers & Letters

d)

Cells

3.

Rows are named using ________?

a)

Numbers

b)

Letters

c)

Numbers & Letters

d)

Cells

4.
In Excel, what do all formula begin with?
a)
!
b)
-
c)
+
d)
=
5.
Which formula is the correct for adding a column of values?
a)
SUM(E4:E10)
b)
=SUM(E4:E10)
c)
=AVG(E4:E10)
d)
=MAX(E4:E10)
6.

What do you call the box where a row and column cross?

a)

Jail

b)

Gaol

c)

Cell

d)

Box

7.

If I want to change color for a cell, which button would I click on?

a)

orange arrow

b)

red arrow

c)

blue arrow

d)

green arrow

8.
What is the name of this cell?
a)
B10
b)
5B
c)
B5
d)
you cannot know the name from this picture
9.

Spreadsheet rows are easily named by:

a)

a. numbers.

b)

b. letters.

c)

c. Roman numerals.

d)

d. colors.

10.

Spreadsheet columns are easily named by:

a)

a. Roman numerals.

b)

b. numbers.

c)

c. letters.

d)

d. colors.

11.

An single box in Ms Excel is known as?

a)

square

b)

range

c)

reference

d)

cell

12.

What is used to do calculations in a spreadsheet?

a)

Variable

b)

Formula

c)

Conditional formating

d)

Macro

13.

When we write formulas, which sign do we start with?

a)

Subtraction sign

b)

Equal Sign

c)

Addition sign

d)

Division sign

14.
What is displayed in cell A6?
a)
Monday
b)
Tuesday
c)
Wednesday
d)
Thursday
15.
What is displayed in cell B1?
a)
100
b)
Tickets Sold
c)
Day
d)
B1
16.

Which of the following operators (symbols) represent adding in EXCEL spreadsheets?

a)

+

b)

-

c)

*

d)

/

17.

Which of the following operators (symbols) represent subtracting in EXCEL spreadsheets?

a)

+

b)

-

c)

*

d)

/

18.

Which of the following operators (symbols) represent multiplication in EXCEL spreadsheets?

a)

+

b)

-

c)

*

d)

/

19.

Which of the following operators (symbols) represent division in EXCEL spreadsheets?

a)

+

b)

-

c)

*

d)

/

20.
What kind of software is Excel?
a)
Word processing software
b)
Spreadsheet Software
c)
Data Base Software
21.

In Excel rows are named by

a)

letters

b)

numbers

c)

rows and numbers

22.

In Excel, columns are named by

a)

Letters

b)

Numbers

c)

Letters and numbers

23.
What button will add up a group of numbers
a)
Equals button
b)
Plus symbol button
c)
Auto-sum button
24.

Where rows and columns meet are

a)

Blocks

b)

Cells

c)

Boxes

25.

When inserting a formula, always start with

a)

equal symbol

b)

plus symbol

c)

minus symbol

26.

Cells are named by the following:

a)

Column Letter followed by their Row Number

b)

Row Number followed by their Column Letter

c)

Row Number Only

d)

Column Letter Only

27.
Which one of the following is a spreadsheet application? 
a)
Microsoft Word
b)
Microsoft Powerpoint
c)
Microsoft Excel
d)
Microsoft Outlook
28.

How do you use Autofit?

a)

Single-click between the headings of 2 columns

b)

Double-click between the headings of 2 columns

c)

Single-click anywhere in the column

29.

A formula in the spreadsheet should always start with

a)

a plus sign

b)

an asterisk

c)

an equal sign

d)

a capital letter

30.

In a spreadsheet formula, which symbol is used to multiply?

a)

+

b)

-

c)

*

d)

x

31.

What is the name given to the crossing of a row and a column in a spreadsheet?

a)

cell

b)

block

c)

cube

d)

square

32.
Which direction do rows run in a spreadsheet? 
a)
vertical
b)
clockwise
c)
horizontal
d)
diagonal
33.

How are columns named?

a)

Circles

b)

Letters

c)

Numbers

d)

Stars

34.

How are rows named?

a)

Circles

b)

Letters

c)

Numbers

d)

Stars

35.
Which of these would add up the numbers from A3 to A6 
a)
+(A3:A6)
b)
=(A3:A6)
c)
=(Ave(a3:a6))
d)
=Sum(A3:A6)
36.
Which direction do columns run in a spreadsheet? 
a)
Vertical
b)
Counter-Clockwise
c)
Diagonal
d)
Horizontal
37.
It is possible to type numbers and letters (words) into a cell.
a)
True
b)
False
38.
What would be a correct formula for SUM in excel?
a)
=SUM(B3:B9)
b)
=SUMB3+B9
c)
SUM(B3:B9)
d)
=ADD(B3:B9)
39.

Which button can you click to add up a series of numbers?

a)

The Autosum button

b)

The Formula button

c)

The quicktotal button

d)

The total button

40.
Which symbol must all formula begin with?
a)
=
b)
+
c)
(
d)
@
41.
_____ are vertical. 
a)
Rows
b)
Columns
42.
________ are horizontal
a)
Rows
b)
Columns
43.
A combination of numbers and symbols used to express a calculation. Always begins with an = sign.
a)
Cell address
b)
Worksheet
c)
Formula
44.
How do you select an entire column?
a)
Select Edit > Select > Column from the menu
b)
Click the column heading letter
c)
Hold down the shift key as you click anywhere in the column.
d)
Hold down the Ctrl key as you click anywhere in the column
45.

What type of chart is it?

a)

Pie chart

b)

Line chart

c)

Column chart

d)

Bar chart

46.

Which one is 3D Pie Chart?

a)
b)
c)
d)
47.

What is this called?

a)

Chart title

b)

Banner

c)

Column chart

d)

Data label

Similar Resources on Wayground

photo story 3

50 questions

photo story 3

quiz

Worksheet

•

1st - 5th Grade

Soal Pilihan Ganda (satu jawaban benar)

50 questions

Soal Pilihan Ganda (satu jawaban benar)

quiz

Worksheet

•

3rd Grade - University

SOAL INFORMATIKA KLS X.1.2.3: 2025

42 questions

SOAL INFORMATIKA KLS X.1.2.3: 2025

quiz

Worksheet

•

1st Grade - University

X TKJ-INSTALASI SISTEM OPERASI

45 questions

X TKJ-INSTALASI SISTEM OPERASI

quiz

Worksheet

•

1st Grade - University

ÔN TẬP LỚP 7

44 questions

ÔN TẬP LỚP 7

quiz

Worksheet

•

1st - 12th Grade

ÔN TẬP HK1 - K2 2019

43 questions

ÔN TẬP HK1 - K2 2019

quiz

Worksheet

•

2nd - 3rd Grade

Tin học cơ bản 1 (T3)

42 questions

Tin học cơ bản 1 (T3)

quiz

Worksheet

•

KG - 10th Grade

25.4.2024

49 questions

25.4.2024

quiz

Worksheet

•

1st - 5th Grade