NEW
Font size
WorksheetsExcel Vocabulary and Screen Parts
Total questions: 20
Worksheet time: 10mins
Lines on a spreadsheet to make it easier to view, organize and enter data.
Table
Road map
Gridlines
Chart
Merging cells is
selecting a group of cells
filling a cell with color
combining group of cells.
selecting a column and a row
The cell displayed with a bold border. Also called the selected cell. Usually has a blue border around it.
active cell
highligted cell
column
row
Contiguous cells (adjacent cells)
Cells that are not next to each other.
Cells next to each other and not next to each other.
Cells that are next to each other.
Worksheets that are in the same workbook
This mouse pointer is used to do the following:
insert or edit labels/values in cells
autofill
select row/colums
move cells
This mouse pointer is used to do the following:
Copy/Paste Move
Resizing
Autofill
Editing
This mouse pointer is used to do the following:
Autofill
Editing
Resizing
Copy/Paste Move
This mouse pointer is used to do the following:
Editing
Autofill
Copy/Paste Move
Resizing
This mouse pointer is used to do the following:
Row and Column Selection
Resizing
Editing
Autofill
The settings that are original or preset
your fault
default
faluted
same
expression which calculates the value of a cell.
equation only
formula and equation
formula only
function
The intersection of a row and a column is called a ________.
chart
worksheet
sum
cell
A group of cells is called a ________.
cell cluster
chart
cell range
multicell
Where is the fill handle located? Hint: small blue square
In the bottom-right corner of the selected cell
On the right side of the Home tab on the Ribbon
In Backstage view
At the beginning of any formula or function
In this image, why does the value in cell G1 look slightly different from the value in the formula bar?
It’s using an absolute cell reference
It’s using the Currency number format
It’s using conditional formatting
It’s using a formula
You can click the tabs at the bottom of a workbook to switch between ________.
number formats
permissions
worksheets
formulas
Let’s say you’re trying to find your average grade. What’s wrong with the function shown in the image?
It should use the COUNT function instead
It should use quotation marks instead of parentheses
It should have an equals sign (=) at the beginning
There is nothing wrong with the formula
True or False: You can view a formula by double-clicking the cell that contains the formula.
True
False
Which of the following is an absolute cell reference?
A:2
$A$2
A2
#A2
What value would Excel return for this formula?
=(82-32)/5+8*2
7.63
36
26
91.6
