WorksheetsICT YEAR 7 EXCEL
Total questions: 37
Worksheet time: 21mins
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
Sum of all number divided by amount of number
maximum
median
minimum
average
___ are vertical
Row
Column
An Excel file format extension is
doc
xls
txt
mp3
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 this icon?
Sum
AutoSum
Insert Function
Object
The advantage of using a spreadsheet is:
A. calculations can be done automatically.
B. changing data automatically updates calculations
C. more flexibility
D. All of the above
Numbers down the left side of the spreadsheet.
Status Bar
Formula Bar
Column Labels
Row Labels
What is the icon for Microsoft Excel?
What is a range in Excel?
An individual space
A group of cells
A graph
A formula
How are cells named?
By row (number) and column (letter)
By column (letter) and row (number)
By the contents of the cell
Names are randomly assigned
To add the contents of cells C1, C2, C3, C4, and C5, how would the function be written?
=SUM(C1-C5)
=SUM(C1,C5)
=SUM(C1:C5)
=SUM(C1*C5)
The function COUNT is specific for _________________
Counting cells
Counting text
Counting number
Counting tables
What function was used to find the lowest data ?
AVERAGE
MIN
MAX
SUM
Sheet tabs are located ____________
Bottom right and identifies the name of the sheet
Bottom left and identifies the name of the worksheet
Center of the page
Top right corner of the workbook
What is the Active Cell?
The cell that exercises
The cell marked in red
The cell marked with a black X
The cell where you enter data
What are worksheets______________?
The pages in your math workbook
The pages in your student handbook
The pages of a workbook
The handouts I give you to work from
Which is a cell range example?
A1-F5
AA2 through CD1
B5:G10
Z14 until AAA8
Letters of the alphabet going across the top of the spreadsheet.
Title Bar
Column Labels
Row Labels
Status Bar
The cell address of the highlighted cell is
C
4C
A
C4
Looking at the data in the picture, which function can be used to find the youngest and oldest athlete?
MIN & AVERAGE
MAX & AVERAGE
MIN & MAX
COUNTA & MAX
Function used to find the largest number in the cell range B4 through J4.
=MAX(B4:J4)
=LARGEST(B4:J4)
=MAX(B4-J4)
@MAX(B4:J4)
Function used to find the smallest number in the cell range B2 through H4
=MIN(B2:H4)
@MIN(B2:H4)
=SMALLEST(B2:H4)
=MIN(B2-H4)
Write the formula to get the Total of all orders
(a)
Write the formula to get the Average
(a)
Write the formula to get the Highest Order
(a)
Write the formula to get the Lowest Order
(a)
Write the formula to count the number of Cookie Types
(a)
