NEW
Font size
S
M
L
XL
WorksheetsExcel Skills Review
Total questions: 31
Worksheet time: 31mins
Name
Class
Date
1.
The horizontal placement of cells in a table or worksheet.
a)
range
b)
row
c)
column
d)
cell
2.
An equation that calculates a new value from values currently in a worksheet.
a)
Formula Bar
b)
column
c)
cell
d)
formula
3.
Putting cells in order based on their contents is called..
a)
Sorting
b)
Filtering
c)
Numbering
d)
Identifying
4.
Correct or incorrect formula?
=sum(C4:C9)
=sum(C4:C9)
a)
Correct
b)
Incorrect
5.
What is the horizontal section of a spreadsheet?
a)
function
b)
formula
c)
column
d)
row
6.
What is a vertical section of a spreadsheet
a)
row
b)
addition
c)
column
d)
format
7.
What function adds all of the numbers in a range of cells?
a)
Difference
b)
Sum
c)
Average
8.
All formulas in Microsoft Excel begin with the following symbol:
a)
+
b)
-
c)
=
d)
%
9.
The correct formula to add cell B1 and B2 is
a)
AddB1+C1
b)
=sum(B1+C1)
c)
=B1+B2
10.
The part of a spreadsheet identified by letters of the alphabet (vertical across the top):
a)
cell
b)
column
c)
row
11.
The part of a spreadsheet identified by numbers (horizontal)
a)
cell
b)
column
c)
row
12.
An example of a cell address is:
a)
4A
b)
A4
c)
A16:A29
13.
If you want to display a date in a certain way (such as Wednesday, March 25, 2015), you can adjust the ________.
a)
Number Format
b)
autofill
c)
font
d)
cell color
14.
What is the file extension for an Excel file?
a)
.jpg
b)
.excl
c)
.doc
d)
.xlsx
15.
What is the name of this cell?
a)
B10
b)
5B
c)
B5
d)
you cannot know the name from this picture
16.
If you want to put your data into alphabetical order by last name, you could use the __________ command.
a)
Shift
b)
Font
c)
autofill
d)
Sort
17.
The Quick Access Toolbar is:
a)
customizable
b)
found at the bottom of the screen
c)
found on the right side of the screen
d)
none of the above
18.
Provides easy access to frequently used commands:
a)
group
b)
Quick Access Toolbar
c)
cell
d)
none of the above
19.
Can be used to move from cell to cell in a spreadsheet:
a)
tab
b)
enter
c)
arrow keys
d)
all of the above
20.
Double-clicking between two columns will ____________ the column.
a)
delete
b)
copy
c)
resize
d)
fill
21.
Which is the correct formula to add cells A1 to A5?
a)
=SUM(A2+A5)
b)
=SUM(A1:A5)
c)
=A1+A2+A3
d)
=SUM(A1:A4)
22.
Which is an example of a cell reference (cell address)?
a)
A1
b)
CD
c)
7D
d)
77
23.
Which letter on the image is a Column?
a)
A
b)
B
c)
C
d)
D
24.
Which letter on the image is a Row?
a)
A
b)
B
c)
C
d)
D
25.
Where do I select every cell on the entire worksheet?
a)
orange arrow
b)
red arrow
c)
blue arrow
d)
green arrow
26.
You have decided to center the text within a cell. What have you done?
a)
Changed alignment
b)
Wrapped text
c)
Merged cells
d)
Autofit content
27.
If I want to make a cell a particular color, which button would I click on?
a)
orange arrow
b)
red arrow
c)
blue arrow
d)
green arrow
28.
Format cells as ______________ when working with amounts of money.
a)
currency
b)
percent
c)
number
d)
scientific
29.
Aligns the text to the right, left, or center.
a)
Orientation
b)
Indenting
c)
Alignment
d)
Wrapping
30.
To resize columns, double click between column letters
a)
true
b)
false
31.
A3 is an example of a cell's address
a)
true
b)
false
Reset
