Worksheetsms Excel Grade 5
Total questions: 57
Worksheet time: 31mins
Name
Class
Date
1.
What kind of software is Excel?
a)
Spreadsheet software
b)
Word Processing
c)
Drawing
2.
Excel is part of?
a)
Power Point
b)
Microsoft Office Suite
c)
Access
d)
Google
3.
What do you call the rectangles on a spreadsheet?
a)
Cell
b)
Button
c)
Sentence
4.
Excel allows you to work with?
a)
Sentences
b)
Paragraphs
c)
data
5.
Blank are vertical
a)
Columns
b)
Rows
6.
Blank are horizontal
a)
Rows
b)
Columns
7.
A combination of numbers and symbols used to express a calculation. Always begins with an = sign.
a)
Cell Address
b)
Worksheet
c)
Formula
8.
What is the Formula sign for multiply?
a)
\
b)
*
9.
True or False: Spreadsheets can be used in everyday life by analyzing sports stats, grades, and creating a budget for expenses?
a)
false
b)
true
10.
In Excel rows are labeled by
a)
Letters
b)
Numbers
11.
In Excel, columns are labeled by?
a)
Numbers
b)
Letters
12.
What button will add up a group of numbers?
a)
Equals button
b)
Auto sum button
c)
Plus symbol button
13.
Excel would be the ideal program to type a book report?
a)
False
b)
True
14.
You can use the auto-sum key to subtract numbers.
a)
True
b)
False
15.
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
16.
What is the name of this cell?
a)
B10
b)
5B
c)
B5
d)
A5
17.
Which tab in Excel has charts and tables?
a)
review
b)
home
c)
file
d)
insert
18.
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
19.
In Excel it means Add
a)
Plus sign
b)
sort
c)
Forward slash
d)
asterisk
20.
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
21.
Completes previously typed words when you begin to repeat the typing.
a)
AutoFill
b)
#Name?
c)
Column charts
d)
Pie Charts
22.
Tells excel to include all the cells between the two endpoints. A1:D1
a)
Range
b)
sort
c)
Cell
d)
Colon
23.
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
24.
Adding two cells
a)
=SUM(A1+A13)
b)
=SUM(__)
c)
A1+A13= SUM
d)
Total
25.
Error in your formula
a)
#div/0!
b)
AutoFill
c)
#name?
d)
Columns
26.
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
27.
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
28.
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
29.
Making a change in the default settings
a)
Format
b)
Error
c)
Chart
d)
Average
30.
the sum of all numbers divided by the amount of numbers.
a)
Maximun
b)
Minimum
c)
Median
d)
Average
31.
What does this mean "######'?
a)
column is not wide enough
b)
column is missing numbers
c)
column is showing an error
d)
column is too narrow
32.
In an excel formula, it means substract
a)
Add sign
b)
Minus sign
c)
Divide sign
d)
Average Sign
33.
In an excel forumula it means divide
a)
Forwardslash
b)
Backwards
c)
Skip
d)
Multiply
34.
Horizontal line of cells
a)
Row
b)
Column
c)
Cell
d)
Spreadsheet
35.
A box that holds data
a)
Spreadsheet
b)
Cell
c)
Row
d)
Data
36.
a vertical line of cells
a)
Maximum
b)
Minimum
c)
Column
d)
Formulas
37.
Not next to each other
a)
non contiguous cells
b)
contiguous cells
c)
close cells
d)
apart cells
38.
Identify the Excel Icon.
a)
b)
c)
d)
39.
What is the intersection of a column and a row on a worksheet called
a)
Column
b)
Value
c)
Address
d)
Cell
40.
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.
41.
An Excel file is generally called a / an :
a)
E-Spreadsheet
b)
Woorksheet
c)
Workbook
d)
Sheet
42.
Excel is part of
a)
Access
b)
Microsoft Office
c)
PowerPoint
43.
What key should you use to take you to the cell to the right
a)
Tab key
b)
Right arrow key
c)
just click in it
44.
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
45.
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
46.
What is the name of this cell?
a)
B10
b)
5B
c)
B5
d)
A5
47.
Completes previously typed words when you begin to repeat the typing.
a)
AutoFill
b)
#Name?
c)
Column charts
d)
Pie Charts
48.
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
49.
This icon is called the what?
a)
Arrow
b)
Fill handle
c)
Pointer
50.
The name of the cell located at the intersection of column F and row 223 is:
a)
223F
b)
F223
c)
F222
d)
22F3
51.
When entering text in Excel, it is automatically (by default):
a)
Left Justified
b)
Right Justified
c)
Center Justified
d)
Full Justified
52.
When entering numbers in Excel, they are automatically (by default):
a)
Left Justified
b)
Right Justified
c)
Center Justified
d)
Full Justified
53.
Press Ctrl + Home to go to cell A1.
a)
true
b)
false
54.
Identify the MS Excel Window...
a)
b)
c)
d)
55.
A computer application that displays and organizes data is called __________.
a)
PowerPoint Presentation
b)
Publisher
c)
Electronic Spreadsheet
d)
Word
56.
Displays the name or location of the active cell
a)
Formula bar
b)
Name box
c)
Column
d)
Row
57.
What button will add up a group of numbers
a)
Equals button
b)
Plus symbol button
c)
Auto-sum button
100 %
