WorksheetsExcel 2013
Total questions: 38
Worksheet time: 38mins
Name
Class
Date
1.
The horizontal placement of cells in a table or worksheet.
a)
range
b)
row
c)
column
d)
cell
2.
Putting cells in order based on their contents is called..
a)
Sorting
b)
Filtering
c)
Numbering
d)
Identifying
3.
What function adds all of the numbers in a range of cells?
a)
Difference
b)
Sum
c)
Average
4.
All formulas in Microsoft Excel begin with the following symbol:
a)
+
b)
-
c)
=
d)
%
5.
The part of a spreadsheet identified by letters of the alphabet (vertical across the top):
a)
cell
b)
column
c)
row
6.
An example of a cell address is:
a)
4A
b)
A4
c)
A16:A29
7.
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
8.
What is the file extension for an Excel file?
a)
.jpg
b)
.excl
c)
.doc
d)
.xlsx
9.
What is the name of this cell?
a)
B10
b)
5B
c)
B5
d)
you cannot know the name from this picture
10.
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
11.
Can be used to move from cell to cell in a spreadsheet:
a)
tab
b)
enter
c)
arrow keys
d)
all of the above
12.
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
13.
Format cells as ______________ when working with amounts of money.
a)
currency
b)
percent
c)
number
d)
scientific
14.
Aligns the text to the right, left, or center.
a)
Orientation
b)
Indenting
c)
Alignment
d)
Wrapping
15.
=A1+5
a)
Formula
b)
Function
16.
Displays cell contents on multiple lines.
a)
Wrapping
b)
Orientation
c)
Indenting
d)
Alignment
17.
The active cell reference appears in the name box.
a)
True
b)
False
18.
The AVERAGE function sums the numbers in the specified range and then divides the sum by the number cells with numeric values in the range.
a)
True
b)
False
19.
Use the ___ function to display the highest value in a range.
a)
MAX
b)
MIN
c)
both choices
d)
none of the choices
20.
When making a chart, you always highlight the entire spreadsheet.
a)
True
b)
False
21.
#### means you entered a formula incorrectly.
a)
True
b)
False
22.
To change a value a value from 70.2 to 70, you should decrease the decimal once.
a)
True
b)
False
23.
What formula function will determine the smallest value in a range?
a)
=min(range),
b)
=max(range),
c)
=average(range),
d)
=smallest(range)
24.
Which of the following is a type of chart?
a)
Pie
b)
Column
c)
Line
d)
All are charts
25.
What do these buttons do?
a)
Grow and Shrink the font size
b)
Change the font color
c)
change the font style
d)
make the text on the paper into the shape of a tree
26.
The bold button...
a)
makes the highlighted text lighter
b)
makes the unhighlighted text lighter
c)
makes the unhighlighted text darker
d)
makes the highlighted text darker
27.
The two page orientations are...
a)
up and sideways
b)
portrait and sideways
c)
up and landsacape
d)
portrait and landscape
28.
A quick way to indent is to use the _______ key.
a)
caps lock
b)
shift
c)
enter
d)
tab
29.
Charts are updated automatically in Excel whenever data changes.
a)
True
b)
False
30.
The word "SUM" in the function =SUM(A1:A100) is called:
a)
the argument
b)
the function name
c)
the operator
d)
the range
31.
A selection of adjacent cells is called a
a)
handle
b)
range
c)
chart
d)
name box
32.
What chart uses a point on a grid connected by lines to represent the spreadsheet values:
a)
column
b)
line
c)
pie
d)
scattered
33.
When you double click a sheet tab, the sheet name is selected and you can type a new name.
a)
True
b)
False
34.
The CountIf function is used to count the number of cells that meet a certain criteria.
a)
True
b)
False
35.
The #REF error indicates that the numeric values are invalid.
a)
True
b)
False
36.
The #NUM! error indicates that a function contains a numeric value that is invalid.
a)
True
b)
False
37.
What chart has vertical bars representing spreadsheet values.
a)
column
b)
line
c)
pie
d)
scattered
38.
By default, on which page is header or the footer printed
a)
on the first page
b)
on every page
on every page
on every page
c)
on an alternate page
d)
none of the above
100 %
