NEW
Font size
WorksheetsSpreadsheet
Total questions: 21
Worksheet time: 11mins
horizontal group of cells, identified by numbers.
row
column
cell name box
formula bar
Vertical group of cells, identified by letters.
row
column
name box
formula
intersection of row and column
row
column
cell
formula
column and row position of cell.
cell
formula
name box
cell address
data entry area directly below the Ribbon and above the worksheet grid
formula bar
row
column
name box
Appears at left side of formula bar and displays address of selected cell
status bar
formula bar
name box
row
Appears at bottom of worksheet grid and can display information about the selected data
formula
name box
Answer option 3
status bar
Which of the above terms do you type into to find a specific cell?
Name box
formula bar
right
equals
Which side of a cell do numbers get moved to after you enter them?
right
name box
left
southwest
Why do you need to use text in Excel?
text
headings and titles
for labels and headings
labels and cats
How can you edit within a cell?
single click in the cell
double click in the cell
triple click in the cell
quadruple click in the cell
What is the difference between a workbook and worksheet?
😿A workbook is the file; a worksheet is individual sheets
one is on excel the other is on docs
one is answer option 3
equals
What character do formulas begin with?
= equals
: colon
* Astride
+ plus
What punctuation do you put between cell names if you want Excel to calculate a range of cells?
: colon
= equals
* Astride
+ plus
What symbol do you use to show multiplication?
* astride
: colon
= equals
+ plus
What symbol do you use to show division?
: colon
/ forward slash
( ) parenthesis
= equals
Total height of all four buildings:
=SUM(b2:d7)enter
SUM(b2:d2)enter
SUM(b2;d2)enter
SUM(b2-d2)enter
Average height of all four buildings:
=average(b1-b3)
=average(b2:d7)enter
average(b1+b3)
average(b1;b3)
Count of all data cells:
=count(b2:d7)enter
count(b2:d7)enter
count(b2;d7)enter
count(b2-d7)enter
Minimum of all four buildings:
min(b2;d7)enter
min(b2-d7)enter
min(b2:d7)enter
=min(b2:d7)enter
Maximum of all four buildings:
=max(b2:d7)enter
max(b2-d7)
max(b2+d7)
max(b2;d7)
