wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

Grade 5 Revision Quiz-II Term

Total questions: 51

Worksheet time: 51mins

Name
Class
Date
1.

a. You can use Spreadsheets to make ______________________ and _____________________.

a)

a. charts, Graphs

b)

b. Tables, Charts

c)

c. Formulas, Functions

d)

d. Data, Labels

2.

b. A _________________________ is a piece of software made up of grid that allows you to enter text and numbers.

a)

spreadsheet

b)

Document

c)

Presentation

3.

c. Data can be _________________ or __________________ that can be entered in the Spreadsheet.

a)

a. Numberic,text

b)

b. Text, Images

c)

c. Formulas, Functions

d)

d. Values, Labels

4.

d._______________________ is a single box in the grid in a Spreadsheet.

a)

Table

b)

Cell

c)

rectangle

d)

none

5.

e. Spreadsheets have ______________________ that lets you make specific calaculations.

a)

answers

b)

calculations

c)

functions

d)

none

6.

f. The ____________________ gives the cell address.

a)

cell

b)

name box

c)

formula bar

d)

none

7.

g. ______________ data is made up of numbers.

a)

text

b)

numeric

8.

h. ______________________ are the vertical lines of cells in a Spreadsheet.

a)

rows

b)

columns

9.

i. he ___________________ is used to enter and edit data, formulas and function.

a)

name box

b)

cell

c)

formula bar

10.

j. The column and row number for one cell is known as ______________________.

a)

name of cell

b)

cell reference

c)

cell name

d)

reference name

11.

k. To centre align the contents in cell click on ____________________ tab on the toolbar.

a)

file

b)

home

c)

view

d)

formula

12.

a. By default a workbook opens two worksheets.

a)

True

b)

false

13.

b. A Calculation is the way the result is worked out.

a)

True

b)

false

14.

c. SUM function allows you to add together several numbers.

a)

True

b)

false

15.

d. The Columns in a worksheet are identified by numbers.

a)

True

b)

false

16.

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

a)

True

b)

false

17.

f. Spreadsheets can be used to create graphs and charts.

a)

True

b)

false

18.

g. To save a Workbook, Click on Home tab.

a)

True

b)

false

19.

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

a)

True

b)

false

20.

i. Rows are the horizontal lines in a Spreadsheet.

a)

True

b)

false

21.

a. The formula must start with an______________________

a)

i) SUM

b)

ii) Subtraction

c)

iii)Equal sign(=)

d)

iv) Addition

22.

b. A ______________________ is a page containing a grid of cells made up of rows and columns.

a)

i) Workbook

b)

ii) Worksheet

c)

iii) Table

d)

iv) Grid

23.

c. Which of the following is a intersection of row and column?

a)

i) Range

b)

ii) Tab

c)

iii) Bar chart

d)

iv) Cell

24.

d. The __________________contains all the commands you will need to work on your worksheet.

a)

i) Window

b)

ii) Tab

c)

iii) Ribbon

d)

iv) Menu

25.

e. The cell that is highlighted is called an ________________________

a)

i) Row

b)

ii) Highlight cell

c)

iii) Active Cell

d)

iv) None

26.

The Function MAX is used to find the highest value in a range

a)

True

b)

False

27.

We can create only one type of Graph in MS-Excel

a)

True

b)

false

28.

The AUTOSUM feature calculates the lowest value in the list

a)

True

b)

false

29.

The Y-axis is called the vertical axis

a)

True

b)

false

30.

It is not important to type ‘=’ before a formula of a function.

a)

True

b)

False

31.

What is the name of the tab that contains all the commands you will need to work on your worksheet in MS-Excel?

a)

Window

b)

Tab

c)

Ribbon

d)

Menu

32.

Which function in MS-Excel is used to find the lowest value in a range?

a)

MIN

b)

MAX

c)

AVERAGE

d)

SUM

33.

Which feature in MS-Excel is used to automatically add together several numbers?

a)

AUTOSUM

b)

AVERAGE

c)

MAX

d)

MIN

34.

The data cannot be modified after we enter in Excel.

a)

True

b)

False

35.

To see all the formulae in your spreadsheet, click on the _______________Tab.

a)

File

b)

Home

c)

view

d)

formula

36.

_______________ function is used to find the central value of a set of numbers.

a)

SUM

b)

MAX

c)

AVERAGE

d)

MIN

37.

The X-axis is called (a)   axis .

38.

The Y-axis is called (a)   axis.

39.

_____________ is a way of changing items of data to see what happens.

a)

formula

b)

model

c)

calculate

d)

none

40.

___________ is a question you can ask and answer by changing values in a Spreadsheet.

a)

What-if

b)

what-had

c)

what-else

41.

When you _________ a formula, it changes the cell references that it uses.

a)

copy

b)

cut

c)

paste

d)

none

42.

_______________ is a single number or word that has no meaning on its own.

a)

data

b)

information

c)

text

d)

numeric

43.

_______________ is to make a copy of something.

a)

replicate

b)

cut

c)

paste

44.

. When writing a cell address, we write the row heading and then column heading

a)

True

b)

false

45.

The Formula bar shows the result of a Formula

a)

True

b)

false

46.

We can format the text and colors in the graph

a)

True

b)

false

47.

To insert a Graph, click on Insert tab

a)

True

b)

false

48.

The _____________________ chart is called the Column chart in MS-Excel.

a)

bar chart

b)

pie chart

c)

tally chart

d)

pictogram

49.

The  ______________________  helps you to access commands quickly no matter which tab you   

         are in.

a)

file tab

b)

ribbon

c)

menu

d)

Quick access toolbar

50.

The __________________ tab has options to Open, Save and Print a worksheet.

a)

File

b)

Home

c)

VIEW

d)

insert

51.

The __________________Function is used to find the minimum value in a range of cells.

a)

MIN

b)

MAX

c)

AVERAGE

d)

SUM