Free Printable MS EXCEL (Formative 1) Grade 5

Free Printable Worksheets

Worksheets

MS EXCEL (Formative 1) Grade 5

Total questions: 61

Worksheet time: 46mins

Name

Class

Date

1.

A spreadsheet is a document that stores data in a grid of horizontal rows and vertical columns.

a)

Row

b)

Spreadsheet

c)

Minus

d)

Plus

2.

Tells excel to include all the cells between the two endpoints. A1:D1

a)

Range

b)

sort

c)

Cell

d)

Colon

3.

Horizontal line of cells

a)

Row

b)

Column

c)

Cell

d)

Spreadsheet

4.

A box that holds data

a)

Spreadsheet

b)

Cell

c)

Row

d)

Data

5.

Columns in a spreadsheet are:

a)

Vertical

b)

Horizontal

c)

Upside down

d)

right side

6.

Rows in a spreadsheet are:

a)

Vertical

b)

Horizontal

c)

Upside Down

d)

Right Side

7.

What is the term used where a column and row intersect?

a)

Toolbar

b)

Cell

c)

Name Box

d)

Formula Bar

8.

Microsoft Excel is what type of software?

a)

Word Processing

b)

Spreadsheet

c)

Presentation

d)

Drawing

9.

Which of the following is a selected cell?

a)

current command

b)

default option

c)

active Cell

d)

default cell

10.

What is an intersection of a row and a column?

a)

range

b)

tab

c)

bar chart

d)

cell

11.

The columns in a worksheet are identified by numbers.

a)

true

b)

false

12.

The active cell in a worksheet is outlined by a bold rectangle.

a)

true

b)

false

13.

What kind of software is Excel?

a)

Word processing software

b)

Spreadsheet Software

c)

Data Base Software

14.

In Excel rows are labeled by

a)

letters

b)

numbers

c)

rows and numbers

15.

In excel, columns are labeled by

a)

Letters

b)

Numbers

c)

Letters and numbers

16.

Excel refers to files as

a)

Documents

b)

Workbooks

c)

data bases

17.

Excel is part of

a)

Access

b)

Microsoft Office

c)

PowerPoint

18.

The program that we use to create spreadsheets

a)

MS Word

b)

MS Paint

c)

MS Excel

19.

MS Excel?

a)

b)

c)

d)

20.

What is this?

a)

A document

b)

A spreadsheet

c)

I don't know :D

21.

a)

Spreadsheet

b)

Cell

c)

Column headings

d)

Row headings

22.

What is "A1"?

a)

Cell address

b)

Cell letter

c)

Cell number

23.

Which one is a correct cell address?

a)

A1

b)

1A

c)

A

d)

1

24.

What is the cell address of the black cell?

a)

A1

b)

1A

c)

D3

d)

3D

25.

What is the cell address of the pink cell?

a)

A1

b)

1A

c)

D3

d)

3D

26.

What is the cell address of the red cell?

a)

A1

b)

1A

c)

C3

d)

3C

27.

What is the cell address of the red cell?

a)

F6

b)

6F

c)

E6

d)

F7

28.

What is the cell address of the red cell?

a)

D7

b)

7D

c)

E7

d)

D8

29.

What is the cell address of the red cell?

a)

G3

b)

3G

c)

H3

d)

G4

30.

What is the cell address of the red cell?

a)

B9

b)

9B

c)

C9

d)

B10

31.

Excel allows you to work with?

a)

Sentences

b)

Paragraphs

c)

data

32.

In Excel rows are labeled by

a)

Letters

b)

Numbers

33.

In Excel, columns are labeled by?

a)

Numbers

b)

Letters

34.

Excel would be the ideal program to type a book report?

a)

False

b)

True

35.

How do you make a cell the active cell?

a)

Click the ACTIVE button

b)

Click INSERT CELL

c)

Click on the cell

d)

Cells are always active

36.

What is the name of this cell?

a)

B10

b)

5B

c)

B5

d)

A5

37.

how many tabs having in ribbon of ms excel

a)

6

b)

3

c)

7

d)

4

38.

What do you call the blank boxes on a spreadsheet?

a)

cells

b)

info

c)

squares

d)

spots

39.

Excel allows you to

a)

read stories

b)

work with data

c)

invent ideas

40.

Numbers in Excel is automatically aligned ____.

a)

Right

b)

Left

c)

Center

d)

Justify

41.

Cells that run horizontally on a spreadsheet

a)

Row

b)

Column

c)

Workbook

d)

Range

42.

This is a

a)

Column

b)

Row

c)

Cell

d)

Range

43.

This is a

a)

Column

b)

Row

c)

Cell

d)

Range

44.

What is this?

a)

A document

b)

A spreadsheet

c)

I don't know :D

45.

What is an example of a RANGE in MS Excel.

a)

B2-F5

b)

F5:B2

c)

B2:5F

d)

(B2:F5)

46.

When is a MS Excel Spreadsheet used?

a)

Making a Drawing

b)

When Reading

c)

For Collecting Information

d)

For Baking a Cake

47.

Located on the left side or the entry bar, displays the active cell reference:

a)

entry bar

b)

cell reference

c)

name box

d)

none of the above

48.

What is this:

a)

tab

b)

ribbon

c)

view choices

d)

none of the above

49.

This is a:

a)

cell

b)

row

c)

column

d)

none of the above

50.

This is a:

a)

Windows Task Bar

b)

Quick Access Toolbar

c)

worksheet tab

d)

none of the above

51.

In Excel, Columns are labelled as ___

a)

A, B, C, etc

b)

1,2,3 etc

c)

A1, A2, etc

d)

$A$1, $A$2, etc.

52.

Workbook is made up of -----------------------

(a)

53.

What is the name of this icon?

a)

Sort

b)

AutoSum

c)

Borders

d)

Merge & Center

54.

What does this icon do?

a)

Change the font color

b)

Center the text

c)

Change the font size

d)

Fill the cell with color

55.

What does this icon do?

a)

Change the font color

b)

Center the text

c)

Change the font size

d)

Fill the cell with color

56.

1) Which cell is selected in this picture?

a)

B2

b)

B3

c)

C3

d)

m3

57.

?

a)

minimize

b)

maximize

c)

exit/close

58.

Which is NOT a term used in Excel?

a)

Workbook

b)

Worksheet

c)

Cell

d)

Document

59.

This is a:

a)

ribbon

b)

group

c)

tab

d)

none of the above

60.

What color is the Microsoft Excel icon?

a)

Green

b)

Blue

c)

Red

d)

Purple

61.

What part of Excel is this?

a)

Formula bar

b)

Progress bar

c)

Function bar

Reset

Similar Resources on Wayground

59 questions

CF1+2

Worksheet

•

1st - 5th Grade

56 questions

TIn học 5 Bài 1 Em có thể làm gì với máy tính T2

Worksheet

•

5th Grade

59 questions

Final Exam Practice Computer 6

Worksheet

•

5th - 7th Grade

60 questions

Preparing for MTA Certification

Worksheet

•

KG - University

60 questions

Ôn tập KSTA4

Worksheet

•

4th - 5th Grade

56 questions

ICT P5- October Revision Lessons 2,3,4

Worksheet

•

5th Grade

63 questions

Internet Safety

Worksheet

•

1st - 5th Grade

60 questions

Analisis Data

Worksheet

•

5th Grade - University