WorksheetsExcel
Total questions: 50
Worksheet time: 25mins
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.
In Excel it means Add
a)
Plus sign
b)
sort
c)
Forward slash
d)
asterisk
3.
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
4.
Completes previously typed words when you begin to repeat the typing.
a)
AutoFill
b)
#Name?
c)
Column charts
d)
Pie Charts
5.
Tells excel to include all the cells between the two endpoints. A1:D1
a)
Range
b)
sort
c)
Cell
d)
Colon
6.
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
7.
Adding two cells
a)
=SUM(A1+A13)
b)
=SUM(__)
c)
A1+A13= SUM
d)
Total
8.
Error in your formula
a)
#div/0!
b)
AutoFill
c)
#name?
d)
Columns
9.
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
10.
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
11.
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
12.
Making a change in the default settings
a)
Format
b)
Error
c)
Chart
d)
Average
13.
the sum of all numbers divided by the amount of numbers.
a)
Maximun
b)
Minimum
c)
Median
d)
Average
14.
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
15.
In an excel formula, it means substract
a)
Add sign
b)
Minus sign
c)
Divide sign
d)
Average Sign
16.
In an excel forumula it means divide
a)
Forwardslash
b)
Backwards
c)
Skip
d)
Multiply
17.
Horizontal line of cells
a)
Row
b)
Column
c)
Cell
d)
Spreadsheet
18.
A box that holds data
a)
Spreadsheet
b)
Cell
c)
Row
d)
Data
19.
a vertical line of cells
a)
Maximum
b)
Minimum
c)
Column
d)
Formulas
20.
Not next to each other
a)
non contiguous cells
b)
contiguous cells
c)
close cells
d)
apart cells
21.
What is the Sum formula?
a)
Sum( )
b)
Sum( )=
c)
=Sum( )
d)
=( )Sum
22.
When starting a formula what is the first thing you type in the cell?
a)
+
b)
-
c)
%
d)
=
23.
Excel spreadsheets that are already created and ready for you to edit are known as?
a)
spreadsheets
b)
templates
c)
data inputs
d)
pages
24.
Excel is useful for using ________ as opposed to words or presentations?
a)
Excel is useful in presenting
b)
Excel is useful in documents
c)
Excel is useful in numbers
d)
Excel is useful in publishing
25.
The letters in Excel represent the _______?
a)
columns
b)
rows
c)
data
d)
functions
26.
The numbers in Excel represent the _____?
a)
columns
b)
rows
c)
data
d)
functions
27.
A function in Excel is represented by what to letters?
a)
f( )
b)
xF
c)
xf
d)
fx
28.
How would you write a cell reference formula for cell A1 subtracted by Cell C3?
a)
A1-C3
b)
A1-C3=
c)
=A1-C3
d)
=C3-A1
29.
What version of Excel are we using in class?
a)
Excel 2016
b)
Excel 2017
c)
Excel 2018
d)
Excel 2015
30.
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
31.
Adding two cells
a)
=SUM(A1+A13)
b)
=SUM(__)
c)
A1+A13= SUM
d)
Total
32.
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
33.
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
34.
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
35.
Making a change in the default settings
a)
Format
b)
Error
c)
Chart
d)
Average
36.
the sum of all numbers divided by the amount of numbers.
a)
Maximun
b)
Minimum
c)
Median
d)
Average
37.
Horizontal line of cells
a)
Row
b)
Column
c)
Cell
d)
Spreadsheet
38.
a vertical line of cells
a)
Maximum
b)
Minimum
c)
Column
d)
Formulas
39.
What kind of software is Excel?
a)
Word processing software
b)
Spreadsheet Software
c)
Data Base Software
40.
When inserting a formula, always start with
a)
equals symbol
b)
plus symbol
c)
minus symbol
41.
What kind of software is Excel?
a)
Spreadsheet software
b)
Word Processing
c)
Drawing
42.
Excel is part of?
a)
Power Point
b)
Microsoft Office Suite
c)
Access
d)
Google
43.
What do you call the rectangles on a spreadsheet?
a)
Cell
b)
Button
c)
Sentence
44.
Excel allows you to work with?
a)
Sentences
b)
Paragraphs
c)
data
45.
Blank are vertical
a)
Columns
b)
Rows
46.
Blank are horizontal
a)
Rows
b)
Columns
47.
A combination of numbers and symbols used to express a calculation. Always begins with an = sign.
a)
Cell Address
b)
Worksheet
c)
Formula
48.
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
49.
What is the name of this cell?
a)
B10
b)
5B
c)
B5
d)
A5
50.
Which tab in Excel has charts and tables?
a)
review
b)
home
c)
file
d)
insert
100 %
