WorksheetsExcel Test Review
Total questions: 50
Worksheet time: 34mins
What type of program is Excel?
word processing
spreadsheet
presentation
database
What company makes Excel?
Internet Explorer
Dell
Microsoft
What is a cell?
A range of boxes
A subtitle
intersection of a column and row
a title and subtitle
Excel can complete calculations like:
addition and subtraction
division
multiplication
all of the above
Rows are labeled this way:
letters of alphabet
numbers
combination of letters and numbers
Roman numerals
Columns are labeled this way:
Roman numberal
combination of numbers and letters
numbers
letters of alphabet
Which is a correct example of a cell address?
10-d
10-D
10D
D10
Ways to move to a new cell include:
arrows
mouse
tab
all of these
Which are the horizontal and vertical lines on a spreadsheet?
Excel lines
pencil lines
grid lines
pen lines
What size are Excel spreadsheets?
very small
very large
only 50 columns and 50 rows
only 100 columns and 100 rows
Why would you insert commas into large numbers?
it makes them easier to read
it is required in a spreadsheet
it makes them valid
it is required for formulas
What group of people would find spreadsheets useful?
business owners
college students
professionals
all of the above
Which can be added to a spreadsheet?
pictures and backgrounds
formulas
numbers and text
all of the above
Spreadsheets are used for budgets and other financial documentns.
True
False
Row and columns can be inserted or deleted in a spreadsheet.
True
False
Numbers can be formatted in this way.
with decimal points
as dollar amounts
as percentages
all of the above
What does the Center button do?
merges and centers data
centers data within a cell
right aligns data within a cell
left aligns data within a cell
The currency button ($) will insert percent signs to the left of the numbers.
True
False
The comma button will insert commas and decimal points into numbers.
True
False
What does Merge & Center do?
Right aligns data
Left aligns data
Centers data within one cell
Merges cells together and centers data
The insert/Charts command is used to create various charts and grtaphs.
True
False
Rows run vertically in a spreadsheet
True
False
The cursor showing as a fat plus sign means to select
True
False
Different mouse pointers in Excel (fat plus sign, skinny cross hair) all serve different functions
True
False
The Sort command is used when you want to arrange data alphabetically
True
False
Descending sort order is A to Z
True
False
Ascending sort order is
A to Z
Z to A
B to X
C to Z
(######) appear when a number is too large to fit in a cell
True
False
A spreadsheet formula is
a scientific experiment
a timeline
a mathematical equation
a geometric shape
Formulas begin with this symbol.
Asterisk *
Percent sign %
Equal sign =
Dollar sign $
Formulas can be sued to:
Add
Subtract
Multiply and Divide
All of these
Excel is a Microsoft Office program
True
False
The active cell is the one that is selected
True
False
Functions are shortcut formulas
True
False
Spreadsheets are useful for typing documents like letters and reports
True
False
Examples of functions are:
sum, Count Numbers
Max, Min
Average
all of these
Each Microsoft Office program has a unique color, what is Excel's?
blue
green
red
yellow
To average grades in a class, which function would you use?
Sum
Average
Max
Min
Pictures can be added to a spreadsheet either on top of cells or as a background.
true
false
Can sheets be renamed on a spreadsheet?
yes
no
Which example is a valid function for average?
Average (D1:D10)
=Average (D1 through D10)
=AVERAGE(D1:D10)
*AVERAGE (D1-D10)
Which example is a valid formula?
D2+E2
d 2 + e 2
*D2+E2
=D2+E2
The Zoom feature:
makes the text colorful
makes numbers bold
magnifies or reduces the page
makes the font color black
Spreadsheets can be viewed in portrait or landscape orientation
true
false
Best fit is where:
the numbers overflow to the next cell
the column width increases or decreases so widest entry fits
the text overflows to the next cell
the title and subtitle merge together asa one
What does the fill handle do?
selects text
bolds text
copies formulas
italicizes words
Min is short for:
Mini
Minimum
Minimize
Minister
Max is short for
Maxillary
Maxed out
Maxi
Maximum
The Count Numbers function counts the numbers of selected cells
True
False
Spreadsheets are rarely used in business
True
False
