NEW
Font size
S
M
L
XL
WorksheetsGrade 5 Excel
Total questions: 26
Worksheet time: 16mins
Name
Class
Date
1.
If you see a series of "######" in a cell, that means the following:
a)
You keyed in an incorrect number
b)
The row height is too high
c)
The text is incorrectly spelled
d)
The column width is not wide enough
2.
You can only work in one cell at a time. The actual cell that you are working in is called what?
a)
Column
b)
Name Box
c)
Active Cell
d)
Row
3.
When entering text in Excel, it is automatically (by default):
a)
Left Justified
b)
Right Justified
c)
Center Justified
d)
Full Justified
4.
Columns in a spreadsheet are:
a)
Vertical
b)
Horizontal
c)
Upside down
d)
right side
5.
Rows in a spreadsheet are:
a)
Vertical
b)
Horizontal
c)
Upside Down
d)
Right Side
6.
When entering numbers in Excel, they are automatically (by default):
a)
Left Justified
b)
Right Justified
c)
Center Justified
d)
Full Justified
7.
What is the term used where a column and row intersect?
a)
Toolbar
b)
Cell
c)
Name Box
d)
Formula Bar
8.
The feature to center text across several cells is called:
a)
Wrap Text
b)
Merge and Center
c)
Shrink to Fit
d)
Number Formatting
9.
Cells are identified 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
10.
Microsoft Excel is what type of software?
a)
Word Processing
b)
Spreadsheet
c)
Presentation
d)
Drawing
11.
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
12.
In Excel it means Add
a)
Plus sign
b)
sort
c)
Forward slash
d)
asterisk
13.
the largest number =MAX(the first cell address:then the second cell address) For Example: =MAX(C1:C33)
a)
Average
b)
Minimum
c)
Filter
d)
Maximum
14.
Completes previously typed words when you begin to repeat the typing.
a)
AutoFill
b)
#Name?
c)
Column charts
d)
Pie Charts
15.
Tells excel to include all the cells between the two endpoints. A1:D1
a)
Range
b)
sort
c)
Cell
d)
Colon
16.
2 or more cells that are selected to create a source to be used in a formula
a)
Range
b)
Max
c)
Filter
d)
Colums
17.
Adding two cells
a)
=SUM(A1+A13)
b)
=SUM(__)
c)
A1+A13= SUM
d)
Total
18.
Error in your formula
a)
#div/0!
b)
AutoFill
c)
#name?
d)
Columns
19.
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
20.
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
21.
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
22.
Making a change in the default settings
a)
Format
b)
Error
c)
Chart
d)
Average
23.
the sum of all numbers divided by the amount of numbers.
a)
Maximun
b)
Minimum
c)
Median
d)
Average
24.
In an excel formula, it means substract
a)
Add sign
b)
Minus sign
c)
Divide sign
d)
Average Sign
25.
In an excel forumula it means divide
a)
Forwardslash
b)
Backwards
c)
Skip
d)
Multiply
26.
A box that holds data
a)
Spreadsheet
b)
Cell
c)
Row
d)
Data
Reset
