NEW
Font size
WorksheetsExcel Basics Review
Total questions: 24
Worksheet time: 13mins
What kind of software is Excel?
Spreadsheet Software
Database Software
Word processing Software
In Excel, rows are labeled by
Letters
Numbers
Letters and numbers
In Excel, columns are labeled by
Letters
Numbers
Letters and numbers
Excel refers to files as
Databases
Workbook
Document
Where rows and columns meet are referred to as
Cells
Blocks
Boxes
When inserting a formula, always start with
-
*
+
=
Adding two cells,
A1+A3=SUM
SUM(_)
=SUM(A1+A3)
Total
Excel spreadsheets that are already created and ready for you to edit are known as?
spreadsheets
data inputs
templates
pages
This area tells you the name of the project and the name of the program you have open.
Status Bar
Formula Bar
Title Bar
Quick Access Toolbar
A cell that has a dark border around it.
Jail Cell
Sleepy Cell
Active Cell
Stem Cell
Every cell has its own unique address or _____ _____, which is identified by the specific coordinates of the intersecting column and row.
PO Box
Cell Reference
Status Bar
Formula Bar
The area is located at the bottom of the Excel window and provides information and options for your worksheet project.
Scroll Bars
Status Bar
Salad Bar
Formula Bar
A selection of two or more cells is known as a ____.
Cluster
Range
Conglomorate
Big mess
Any data (text or numerical) entered into a cell will appear in the active cell as well as in the ____ ____.
Status Bar
Scroll Bar
Outside Window
Formula Bar
The small dot in the lower-right corner of an active cell. It allows you to copy or duplicate information to other cells.
Scroll Box
Fill Handle
Cell Reference
Ribbon Tab
Which of the following will give you a total?
MIN
MAX
AVERAGE
SUM
Which of the following symbols is used for multiplication?
Back slash
Plus
Asterisk
Forward slash
Which of the following will produce a number that is calculated by adding quantities together and then dividing the total by the number of quantities?
SUM
AVERAGE
MAX
MIN
Which of the following is a function?
John Jones
$5.00
=sum(A1:A5)
=A1+A5
What part of a spreadsheet is vertical?
Formula Bar
Row
Column
Cell
Which part of a spreadsheet is horizontal?
formulas bar
column
row
cell
Which of the following does a spreadsheet NOT do for a user?
calculate a loan payment schedule
balance a checkbook
write a business letter
create household budget
To arrange data in alphabetical or numerical order is what?
coding
sorting
graphing
grouping
