NEW
Font size
WorksheetsExcel
Total questions: 30
Worksheet time: 15mins
What is this called?
cell
workbook
column
Look at where the green arrow is pointing. What is it called?
cell
workbook
column
What is this called?
columns
sheets
row
What is this called?
columns
sheets
row
What is this called?
columns
sheets
row
B2:B6 is called?
cell address
sum formula
cell range
This is an example of a ?
formula
sum formula
cell address
What is the sum formula?
=sum(f8:h8)
=sum(d8:h8)
=sum(e8:h8)
What is the sum formula?
=sum(I13:I20)
=sum(J13:J19)
=sum(J19:J20)
The program that we use to create spreadsheets
MS Word
MS Paint
MS Excel
Spreadsheet
Cell
Column
Row
What is the cell address of the black cell?
A1
1A
D3
3D
What is the cell address of the pink cell?
A1
1A
D3
3D
What is the cell address of the red cell?
D7
7D
E7
D8
What is the intersection of a column and a row on a worksheet called
Column
Value
Address
Cell
In Excel, Columns are labelled as ___
A, B, C, etc
1,2,3 etc
A1, A2, etc.
$A$1, $A$2, etc.
In Excel, Rows are labelled as ______
A, B, C, etc
1,2,3 etc
A1, A2, etc.
$A$1, $A$2, etc.
What tab is pictured here?
File
Home
Data
Formula
What tab is pictured here?
Home
File
Insert
Data
What tab is pictured here?
Home
Data
Insert
Formulas
Data is also known as
numbers
letters
information
colors
A spreadsheet helps you make
Tables
Graphs
Charts
All of the above.
a combination of a column letter and a row number that identifies a cell on a worksheet.
CELL RELAVTIVE
CELL ADDRESS
CELL REFERENCE
CELL LOCATION
Microsoft Excel is what kind of software?
Word Processing Software
Spreadsheet Software
Database Software
Presentation Software
An Excel file format extension is
doc
xls
txt
mp3
To alert Excel that you are entering a formula and not text, type a(n) ____________ preceding the formula.
&
=
#
*
What function adds all of the numbers in a range of cells?
Calculate
Compute
Sum
Max
If I want to find an average of cells A1 through A25, which formula would I use?
=average(A1:A25)
=avg(A1:A25)
=average(A1-A25)
=avg(A1-A25)
What is this icon?
Sum
AutoSum
Insert Function
Object
What is the icon for Microsoft Excel?
