Font size
WorksheetsGrade 5 Revision Quiz-II Term
Total questions: 51
Worksheet time: 51mins
a. You can use Spreadsheets to make ______________________ and _____________________.
a. charts, Graphs
b. Tables, Charts
c. Formulas, Functions
d. Data, Labels
b. A _________________________ is a piece of software made up of grid that allows you to enter text and numbers.
spreadsheet
Document
Presentation
c. Data can be _________________ or __________________ that can be entered in the Spreadsheet.
a. Numberic,text
b. Text, Images
c. Formulas, Functions
d. Values, Labels
d._______________________ is a single box in the grid in a Spreadsheet.
Table
Cell
rectangle
none
e. Spreadsheets have ______________________ that lets you make specific calaculations.
answers
calculations
functions
none
f. The ____________________ gives the cell address.
cell
name box
formula bar
none
g. ______________ data is made up of numbers.
text
numeric
h. ______________________ are the vertical lines of cells in a Spreadsheet.
rows
columns
i. he ___________________ is used to enter and edit data, formulas and function.
name box
cell
formula bar
j. The column and row number for one cell is known as ______________________.
name of cell
cell reference
cell name
reference name
k. To centre align the contents in cell click on ____________________ tab on the toolbar.
file
home
view
formula
a. By default a workbook opens two worksheets.
True
false
b. A Calculation is the way the result is worked out.
True
false
c. SUM function allows you to add together several numbers.
True
false
d. The Columns in a worksheet are identified by numbers.
True
false
e. The active cell in a worksheet is outlined by a bold rectangle.
True
false
f. Spreadsheets can be used to create graphs and charts.
True
false
g. To save a Workbook, Click on Home tab.
True
false
h . The active cell in a worksheet is outlined by a bold rectangle.
True
false
i. Rows are the horizontal lines in a Spreadsheet.
True
false
a. The formula must start with an______________________
i) SUM
ii) Subtraction
iii)Equal sign(=)
iv) Addition
b. A ______________________ is a page containing a grid of cells made up of rows and columns.
i) Workbook
ii) Worksheet
iii) Table
iv) Grid
c. Which of the following is a intersection of row and column?
i) Range
ii) Tab
iii) Bar chart
iv) Cell
d. The __________________contains all the commands you will need to work on your worksheet.
i) Window
ii) Tab
iii) Ribbon
iv) Menu
e. The cell that is highlighted is called an ________________________
i) Row
ii) Highlight cell
iii) Active Cell
iv) None
The Function MAX is used to find the highest value in a range
True
False
We can create only one type of Graph in MS-Excel
True
false
The AUTOSUM feature calculates the lowest value in the list
True
false
The Y-axis is called the vertical axis
True
false
It is not important to type ‘=’ before a formula of a function.
True
False
What is the name of the tab that contains all the commands you will need to work on your worksheet in MS-Excel?
Window
Tab
Ribbon
Menu
Which function in MS-Excel is used to find the lowest value in a range?
MIN
MAX
AVERAGE
SUM
Which feature in MS-Excel is used to automatically add together several numbers?
AUTOSUM
AVERAGE
MAX
MIN
The data cannot be modified after we enter in Excel.
True
False
To see all the formulae in your spreadsheet, click on the _______________Tab.
File
Home
view
formula
_______________ function is used to find the central value of a set of numbers.
SUM
MAX
AVERAGE
MIN
The X-axis is called (a) axis .
The Y-axis is called (a) axis.
_____________ is a way of changing items of data to see what happens.
formula
model
calculate
none
___________ is a question you can ask and answer by changing values in a Spreadsheet.
What-if
what-had
what-else
When you _________ a formula, it changes the cell references that it uses.
copy
cut
paste
none
_______________ is a single number or word that has no meaning on its own.
data
information
text
numeric
_______________ is to make a copy of something.
replicate
cut
paste
. When writing a cell address, we write the row heading and then column heading
True
false
The Formula bar shows the result of a Formula
True
false
We can format the text and colors in the graph
True
false
To insert a Graph, click on Insert tab
True
false
The _____________________ chart is called the Column chart in MS-Excel.
bar chart
pie chart
tally chart
pictogram
The ______________________ helps you to access commands quickly no matter which tab you
are in.
file tab
ribbon
menu
Quick access toolbar
The __________________ tab has options to Open, Save and Print a worksheet.
File
Home
VIEW
insert
The __________________Function is used to find the minimum value in a range of cells.
MIN
MAX
AVERAGE
SUM
