wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

MS EXCEL BASICS-GRADE 5

Total questions: 60

Worksheet time: 33mins

Name
Class
Date
1.

Which of these is Microsoft Excel?

a)
b)
c)
d)
2.

What is basic file of MS Excel?

a)

Presentation

b)

Spreadsheet

c)

Worksheet

d)

Workbook

3.

To select all the cells in a worksheet, press _________.

a)

Ctrl + A

b)

Ctrl + B

c)

Ctrl + Z

d)

Ctrl + Z

4.
In this diagram what does the selected area represent?
a)
a Row
b)
a Cell
c)
a Column
d)
a Chart
5.
In this diagram the highlighted area represents:
a)
Columns
b)
a Graph
c)
Rows
d)
a Chart
6.
What kind of software is Excel?
a)
Spreadsheet software
b)
Word Processing
c)
Drawing
7.
Excel is part of?
a)
Power Point
b)
Microsoft Office Suite
c)
Access
d)
Google
8.
What is the name of this cell?
a)
B10
b)
5B
c)
B5
d)
A5
9.
A Graphic representation of data. A circle is divided into sectors which shows a percentage of a whole.
a)
Line Chart
b)
Pie Chart
c)
Bar Chart
d)
Graphs
10.
A Graphic representation of data. The bar can be VERTICAL or Horizontal, but a vertical graph is also known as a column chart.
a)
Bar Chart
b)
Pie Chart
c)
Graphs
d)
Line Chart
11.
A type of chart which displays information as a series of data points called 'markers' connected by straight line segments. 
a)
Pie chart
b)
Line Chart
c)
Bar Graphs
d)
Graphs
12.

Identify the Excel Icon.

a)
b)
c)
d)
13.

What is the name of this cell?

a)

B10

b)

5B

c)

B5

d)

A5

14.

This icon is called the what?

a)

Arrow

b)

Fill handle

c)

Pointer

15.

Identify the MS Excel Window...

a)
b)
c)
d)
16.

in which tab you could see save, save as, print, etc.

a)

File

b)

home

c)

Design

d)

Insert

17.

True or False:

You can use Microsoft Excel to listen to Music.

a)

True

b)

False

18.
What is the name given to the intersection of a row and a column in a spreadsheet? 
a)
cell
b)
block
c)
cube
d)
square
19.

What is a Cell?

a)

Where a column and row intersect or meet

b)

A block

c)

The column

d)

Plant Cell

20.

What is the cell reference for the active cell?

a)

C5

b)

B7

c)

E10

d)

D4

21.

What is the cell reference for the active cell?

a)

A2

b)

E2

c)

B9

d)

D5

22.

What is the cell reference for the active cell?

a)

A1

b)

B8

c)

C8

d)

B10

23.

What is the cell reference for the active cell?

a)

E9

b)

C8

c)

A7

d)

B13

24.

What is the cell reference for the active cell?

a)

D7

b)

C3

c)

A9

d)

B3

25.

Division symbol in spreadsheet.

a)

/

b)

+

c)

=

26.

Multiplication symbol in Microsoft Excel

a)

&

b)

*

c)

^

27.

Which formula is written correctly?

a)

A5+C5

b)

=A5+C5

c)

A5+C5

d)

=+A5C5

28.

How would you write the formula for D4 divided by E4?

a)

=D4-E4

b)

=D4+E4

c)

=D4/E4

d)

D4/E4

29.

Which of the following program allows us to make documents?

a)

Microsoft Word

b)

Microsoft Excel

c)

Microsoft Paint

d)

Microsoft PowerPoint

30.

Which of the following font style is used to make your letters and characters becomes thicker?

a)

Italic

b)

Bold

c)

Underline

d)

All of the above

31.

Which of the following commands is used if you want to start a new document?

a)

Save

b)

New

c)

Save As

d)

Open

32.

Which of the following commands is used if you want to save your document with a different file name in a different location?

a)

Save

b)

Save As

c)

New

d)

Open

33.

What key are you going to use to change small letter to capital letter?

a)

Enter Key

b)

Delete Key

c)

Shift Key

d)

Backspace Key

34.

Which one is UNDO icon?

a)
b)
c)
d)
35.

Which one is MS WORD icon?

a)
b)
c)
d)
36.

To make a NEW LINE, we press...

a)
b)
c)
d)
37.

To TYPE the FULL STOP, we press...

a)
b)
c)
d)
38.

what did i change here

a)

color

b)

size

c)

font

d)

style

39.
This is the:
a)
Quick Access Toolbar
b)
Office Button
c)
Status Bar
d)
None of the Above
40.
This is the:
a)
Horizontal Ruler
b)
Vertical Ruler
c)
Group
d)
None of the above
41.
What does the box with the red arrow pointing at means? 
a)
Text Style
b)
Text Color
c)
Bold
d)
Size
42.

The symbol of greater than use in inserting text and numeric data.

a)

*

b)

>

c)

&

43.

The main file that contains one or more worksheets where you can enter data is called:

a)

Range

b)

Cell

c)

Worksheet

d)

Workbook

44.

A rectangular box in a worksheet where you can enter data, formulas, and function is called:

a)

Cell

b)

Workbook

c)

Range

d)

Worksheet

45.

A single spreadsheet within a workbook that consists of rows, columns, and cells are called:

a)

Range

b)

Worksheet

c)

Cell

d)

Workbook

46.

A group of adjacent cells, which can be selected and formatted together is called:

a)

Worksheet

b)

Workbook

c)

Cell

d)

Range

47.

A visual representation of data in a worksheet that can help you identify patterns and trends is called:

a)

Ribbon

b)

Chart

c)

Quick Access Toolbar

d)

Name box

48.

The box located to left of formula bar, which displays the reference of the selected cell or range is called:

a)

Ribbon

b)

Quick Access Toolbar

c)

Chart

d)

Name Box

49.

A graphical user interface that contains all the tools and commands you need to work with Excel:

a)

Quick Access Toolbar

b)

Name box

c)

Ribbon

d)

Chart

50.

A customizable toolbar that provides quick access to frequently used commands is called:

a)

Name box

b)

Ribbon

c)

Quick Access Toolbar

d)

Chart

51.

Pre-designed spreadsheets that you can use to quickly create different types of documents:

a)

Resume

b)

Templates

c)

Cover Letter

d)

Spreadsheet

52.

An equation that performs a calculation in a cell based on the values in other cells:

a)

Formula

b)

Function

c)

Spreadsheet

d)

Sort

53.

If I want to find an average of cells A1 through A25, which formula would I use?

a)

=average(A1:A25)

b)

=avg(A1:A25)

c)

=average(A1-A25)

d)

=avg(A1-A25)

54.

An Excel file format extension is

a)

doc

b)

xls

c)

txt

d)

mp3

55.

The set of data that runs left to right in a spreadsheet

a)

column

b)

row

c)

cell

d)

active cell

56.

What does the mouse look like in a spreadsheet?

a)

Arrow

b)

Pointer

c)

Two headed arrow

d)

Selection cross

57.

What function adds all of the numbers in a range of cells?

a)

Calculate

b)

Compute

c)

Sum

d)

Max

58.

To alert Excel that you are entering a formula and not text, type a(n) ____________ preceding the formula.

a)

&

b)

=

c)

#

d)

*

59.

The numbers in Excel represent the...

a)

Rows

b)

Columns

c)

Cells

d)

Data

60.

The letters in Excel represent the...

a)

Rows

b)

Columns

c)

Cells

d)

Data

Similar Resources on Wayground

E-BOOK

60 questions

E-BOOK

quiz

Worksheet

•

KG - University

Soal Komputer Kelas 4, 5 dan 6 SD

60 questions

Soal Komputer Kelas 4, 5 dan 6 SD

quiz

Worksheet

•

4th - 6th Grade

6/7 Keyboarding 12/8

60 questions

6/7 Keyboarding 12/8

quiz

Worksheet

•

4th - 8th Grade

bản quyền, định dạng kí tự, sao chép văn bản

60 questions

bản quyền, định dạng kí tự, sao chép văn bản

quiz

Worksheet

•

5th Grade

CHINH PHỤC MÔN TIN LỚP 5 GIỮA HKII

62 questions

CHINH PHỤC MÔN TIN LỚP 5 GIỮA HKII

quiz

Worksheet

•

5th Grade

Computer System Part 1

60 questions

Computer System Part 1

quiz

Worksheet

•

4th - 7th Grade

ÔN THI HỌC KÌ II MÔN TIN LỚP 3

62 questions

ÔN THI HỌC KÌ II MÔN TIN LỚP 3

quiz

Worksheet

•

1st - 5th Grade

Ôn tập KSTA test 5

60 questions

Ôn tập KSTA test 5

quiz

Worksheet

•

4th - 5th Grade