Font size
WorksheetsExcel
Total questions: 21
Worksheet time: 13mins
Division symbol in spreadsheet.
/
+
=
If you click on a letter at the top of an Excel spreadsheet, what have you done?
selected a cell
selected a range of cells
selected a row of data
selected a column of data
A four-sided arrow does what in Excel?
copies the contents of one cell to others around it
moves the contents of one cell to another location
selects the cell
Every formula starts with what?
=
+
-
( )
If you click a number at the left of an Excel spreadsheet, what have you done?
selected a cell
selected a range of cells
selected a row of data
selected a column of data
Microsoft Excel is what kind of software?
Word Processing Software
Spreadsheet Software
Database Software
Presentation Software
The numbers in Excel represent the...
Rows
Columns
Cells
Data
The letters in Excel represent the...
Rows
Columns
Cells
Data
When inserting a formula, always start with
-
*
+
=
What do you call the blank boxes on a excel sheet
cell
info
Squares
Spots
What is the name of this Cell ?
6B
A5
6A
B6
What is the formula sign for multiply?
/
*
=
-
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 the icon for Microsoft Excel?
Choose the correct syntax
=(MIN)
=MIN()
(MIN
How do you properly specify a range of cells?
B1;B16 (semicolon)
B1-B16(dash)
B1:B16(colon)
B1,B16(comma)
Which of the formula's would output the price of the MOST EXPENSIVE item in the bakery?
=MAX(B2:B7)
=HIGH(B2:B7)
=LRG(B2:B7)
=TOP(B2:B7)
Which of the formula's would output the price of the CHEAPEST item in the bakery?
=MIN(B2:B7)
=LOW(B2:B7)
=SML(B2:B7)
=BOTTOM(B2:B7)
What formula CANNOT calculate the total stock level in the bakery for all of its products combined.
=SUM(C2:C7)
=SUM(C2,C3,C4,C5,C6,C7)
=C2+C3+C4+C5+C6+C7
=SUMC2+C3+C4+C5+C6+C7
