WorksheetsExcel Terminology
Total questions: 35
Worksheet time: 27mins
Name
Class
Date
1.
Which of the following is the highlighted cell identified by a bold black rectangle?
a)
default option
b)
default cell
c)
active cell
d)
current command
2.
Which is the intersection of a row and column?
a)
bar chart
b)
tab
c)
range
d)
cell
3.
To get to the last cell on the worksheet, which of the following should you press?
a)
Crtl + End
b)
Crtl + Home
c)
Crtl + Right Arrow
d)
Crtl + Left Arrow
4.
Which command is used to insert a cut or copied selection to a cell or range of cells?
a)
Paste
b)
Copy
c)
Range
d)
Quick Access Toolbar
5.
What is the name of the small square in the lower-right corner of a selected cell or range?
a)
Cell
b)
Cell pointer
c)
Fill handle
d)
Formula bar
6.
Which of the following is near the top of the Excel window, under the ribbon, where you can enter or edit cell entries or formulas?
a)
Formula bar
b)
Column marker
c)
Cell pointer
d)
Fill handle
7.
What is the name of this box?
a)
Formula box
b)
Cell box
c)
Quick Access Toolbar
d)
Name box
8.
What is the name of a group of selected cells?
a)
Default cell
b)
Active cell
c)
Range
d)
Column
9.
When you open an Excel file, a collection of worksheets, you have opened a _____ .
a)
Backstage
b)
Workbook
c)
Active cell
d)
Worksheet
10.
How would you name this cell?
a)
3B
b)
3 B
c)
B3
d)
B 3
11.
The rectangular shaped area on a worksheet that is created by the intersection of columns and rows is known as a(n) ___________.
a)
active cell
b)
autofill
c)
cell
d)
column
12.
The cell in your worksheet that has been selected. It will have bolder grid lines around it.
a)
Formula
b)
Formula Bar
c)
Active Cell
d)
Cell
13.
Microsoft Excel is what type of software?
a)
Word Processing
b)
Spreadsheet
c)
Presentation
d)
Drawing
14.
The active cell is the same thing as the ____
a)
Cell box
b)
Sheet 1
c)
Name box
d)
Selected cell
15.
What is another term for an Excel spreadsheet?
a)
Worksheet
b)
Workbook
c)
File
d)
Magazine
16.
The cell reference and the cell name are the same things.
a)
True
b)
False
17.
The cell reference can be found in the
a)
Formula Bar
b)
Status Bar
c)
Title Bar
d)
Name Box
18.
The formula bar contains the ______
a)
Cell reference
b)
contents of the active cell
c)
cell name
d)
status of the document
19.
Which of the following is a type of data that can ALWAYS be used in formulas?
a)
Values
b)
Dates
c)
Times
d)
All of the above
20.
Which of the following is a type of data that can NOT be used in calculations?
a)
Labels
b)
Values
c)
Times
d)
None of the above can be used
21.
Columns are labeled by numbers.
a)
True
b)
False
22.
Rows are labeled by numbers.
a)
True
b)
False
23.
When stating a cell name or cell reference, which comes first, the letter or the number?
a)
Letter
b)
Number
24.
What will appear in the top right corner of a cell when there has been an error made in the formula?
a)
Yellow Triangle
b)
Green Triangle
c)
Red Triangle
d)
Fill Handle
25.
What is required to store a formula in a cell?
a)
equal sign
b)
plus sign
c)
command
d)
a slash
26.
An equation that calculates a new value from values currently in a worksheet.
a)
Formula Bar
b)
column
c)
cell
d)
formula
27.
The box to the right of the Name Box that displays a formula when the cell of a worksheet contains a calculated value (or the results of a formula).
a)
Formula Bar
b)
worksheet
c)
Name Box
d)
formula
28.
a graphical representation of data.
a)
Chart
b)
column
c)
cell
d)
X-axis
29.
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
30.
A small black square in the lower-right corner of a selected cell.
a)
Auto Fill
b)
Fill Handle
c)
Copy Pointer
d)
Pull Button
31.
Which of the following formulas is not entered correctly?
a)
=10+50
b)
=B7+B8
c)
=B7+14
d)
10+50
32.
Columns go...
a)
Across
b)
Down
33.
Rows go...
a)
Across
b)
Down
34.
In a cell reference, for example A1, what does the letter refer to?
a)
The column
b)
The cell
c)
The row
35.
Which of these symbols is used for divide on a computer?
a)
-
b)
*
c)
/
d)
|
100 %
