WorksheetsPre-Test 7th Grade Office Productivity - SPREADSHEET
Total questions: 61
Worksheet time: 34mins
Name
Class
Date
1.
Which is is an arrangement of cells in columns and rows used to organize, analyze, calculate, and report information, usually in numerical form?
a)
spreadsheet
b)
workbook
c)
google doc
d)
cell address
2.
Which is the file which contains one or more spreadsheets?
a)
worksheets
b)
spreadsheets
c)
workbook
d)
work order
3.
What is an individual locations on a spreadsheet?
a)
cells
b)
cell reference
c)
cell range
d)
rows
4.
What are columns?
a)
The vertical groups of cells
b)
The horizontal group of cells
c)
The group of cells identified as numbers.
d)
Chicken
5.
What are columns identified by?
a)
numbers
b)
letters
c)
symbols
d)
all
6.
What are rows identified by?
a)
letters
b)
numbers
c)
symbols
d)
Arigatos
7.
Which of the following terms is where the column meets the row?
a)
cell address
b)
cell range
c)
spreadsheet
d)
ribbon
8.
Which of the following is a group of adjacent cells
a)
cell address
b)
cell range
c)
workbook
d)
workout
9.
Which of the following is the cell ready to receive information?
a)
The cell address
b)
cell range
c)
active cell
d)
Beyonce
10.
Which is the box that shows the formula or data of a selected cell?
a)
Formula Box
b)
Formula Bar
c)
Formula Milk
d)
Formulas in science
11.
Insert - Home - Page Layout - Formula - and Review are all tabs on what?
a)
The menu bar
b)
The formula bar
c)
The bar exam
d)
Alvin and the Chipmunks
12.
Under each tab on the menu bar are commands known as what?
a)
The tool bar
b)
The menu bar
c)
salad bar
d)
ACC
13.
The menu bar and its tool bars are known as what?
a)
The ribbon
b)
The rabbit
c)
The hobbit
d)
Red Robin..... Yummmmm
14.
After entering the number of sales for the first quarter, where will they align?
a)
Right
b)
Left
c)
Centered
d)
Justified
15.
A sales manager has requested the highest sale for the first quarter. Which function will be used?
a)
SUM
b)
MIN
c)
MAX
d)
AVG
16.
A sales manager has requested the lowest sale for the first quarter. Which function will be used?
a)
SUM
b)
MIN
c)
MAX
d)
AVG
17.
Samantha needs to total the cell range A1 to A10 (A1:A10).
What is the MOST efficient method to find the answer?
What is the MOST efficient method to find the answer?
a)
Label
b)
Value
c)
Formula
d)
Function
18.
Paul has to enter a unit price for a product. How will this data be classified?
a)
Label
b)
Value
c)
Formula
d)
Function
19.
ABC Corporation has listed all of its products in the cell range A1 to A45. Where are the products displayed?
a)
A. Row
b)
B. Column
c)
C. Entry
d)
D. Cell address
20.
Paul has to enter the zip code for a client. How will this data be classified?
a)
A. Label
b)
B. Value
c)
C. Formula
d)
D. Function
21.
A sales manager has requested the total sale for the first quarter. Which function will be used?
a)
SUM
b)
MIN
c)
MAX
d)
AVG
22.
ABC Corporation has listed all of its products in the cell range A1 to K1. Where is this sales information displayed?
a)
Row
b)
Column
c)
Entry
d)
Cell address
23.
When keying a formula in a spreadsheet, what must you key to inform the program that you are entering a formula instead of entering text?
a)
Addition Operator
b)
Division Operator
c)
Equal Sign
d)
Subtraction Sign
24.
The column letter and row number make up what?
a)
Cell address
b)
Cell content
c)
Formula bar title
d)
Chart
25.
When entering the client’s names, what is the default alignment?
a)
Right
b)
Left
c)
Centered
d)
Justified
26.
John needs to total the cell range A1 to A3. What is the MOST efficient method to find the answer?
a)
A. Labels
b)
B. Values
c)
C. Formula
d)
D. MAX
27.
The contents in cells A1 through A6 are 6, 3, 4, 7, 9, and 7. What function would return the answer 6?
a)
=MAX(A1:A6) )
b)
=MIN(A1:A6
c)
. =AVG(A1:A6) )
d)
=SUM(A1:A6
28.
What is the following?
=A2+B2+C2+D2+E2+F2
=A2+B2+C2+D2+E2+F2
a)
formula
b)
function
c)
cell range
d)
cell address
29.
What is the following?
=SUM(A2:F2)
=SUM(A2:F2)
a)
formula
b)
function
c)
math problem
30.
Which symbol is used in spreadsheet to do multiplication?
a)
*
b)
/
c)
+
d)
-
31.
Which symbol is used in spreadsheet to do addition?
a)
*
b)
+
c)
/
d)
-
32.
Which symbol is used in spreadsheet to do division?
a)
/
b)
*
c)
-
d)
+
33.
Which symbol is used in spreadsheet to do subtraction?
a)
-
b)
+
c)
*
d)
/
34.
What must each formula or function begin with?
a)
=
b)
*
c)
!
d)
%
35.
Vertical cells that are labeled by letters
a)
Row
b)
Column
c)
Group
d)
Tab
36.
Horizontal cells that are labeled by numbers
a)
Group
b)
Tab
c)
Row
d)
Column
37.
The intersection of a row and column which is identified by a letter and number
a)
Tab
b)
Icon
c)
Group
d)
Cells
38.
What does it mean when one of your cells is filled up with this error message?
#########
#########
a)
your number is too large to fit
b)
you need to enter a number
c)
you can't use a number in that cell
d)
you can't use a word in that cell
39.
What do we call the this?
a)
cell
b)
filter
c)
formula bar
d)
autosum
40.
What is the active cell in this picture?
a)
A1
b)
D3
c)
B4
d)
C4
41.
Columns are labeled with _________. Rows are labeled with _______.
a)
Letters / Numbers
b)
Numbers / Letters
c)
Colors / Numbers
d)
Letters / Colors
42.
What needs to be done to a information in the column if the entire word cannot be seen (look at column B)?
a)
adjust the column width
b)
delete the word
c)
abbreviate the word
d)
nothing
43.
Look at column B. What do the #### signs mean?
a)
number signs represents the data
b)
the column in too small
c)
fill in the missing information
44.
Which is is an arrangement of cells in columns and rows used to organize, analyze, calculate, and report information, usually in numerical form?
a)
spreadsheet
b)
workbook
c)
word processing
d)
multimedia
45.
What is an individual locations on a spreadsheet?
a)
cells
b)
cell reference
c)
cell range
d)
rows
46.
Words and letters in a spreadsheet are called ____________.
a)
spreadsheet
b)
name box
c)
rainbow
d)
Labels
47.
What cell is the active cell box?
a)
I2
b)
F7
c)
A1
d)
C5
48.
What is the cell location of the nose?
a)
F8
b)
E6
c)
F11
d)
I2
49.
Words and letters in a spreadsheet are located to the ____________ of a cell.
a)
right
b)
middle
c)
across the top
d)
left
50.
Which value is formatted as currency?
a)
$123.45
b)
123.45
c)
123
d)
12/3/18
51.
All formulas must begin with
a)
equal sign
b)
plus sign
c)
minus sign
d)
asterisk
52.
What symbol means to multiply?
a)
equal sign
b)
asterisk
c)
diagonal
d)
minus
53.
What symbol means to divide?
a)
equal sign
b)
asterisk
c)
diagonal
d)
minus
54.
an excel file with one or more worksheets
a)
workbook
b)
worksheet
c)
formula
d)
row
55.
Place where you can rename each worksheet. Located at the bottom of the worksheet window.
a)
sheet tab
b)
formula
c)
Name Box
d)
Chart
56.
A single sheet contained in an excel workbook.
a)
worksheet
b)
workbook
c)
Chart
d)
sheet tab
57.
A grid of rows and columns in which you enter text, numbers, and the results of calculations.
a)
worksheet
b)
range
c)
spreadsheet
d)
Chart
58.
a graphical representation of data.
a)
Chart
b)
column
c)
cell
d)
X-axis
59.
A sales manager has requested the highest sale for the first quarter. Which function will be used?
a)
SUM
b)
MIN
c)
MAX
d)
AVG
60.
A sales manager has requested the lowest sale for the first quarter. Which function will be used?
a)
SUM
b)
MIN
c)
MAX
d)
AVG
61.
Samantha needs to total the cell range A1 to A10. What is the MOST efficient method to find the answer?
a)
Label
b)
Value
c)
Formula
d)
Function
100 %
