Worksheets5th Six Weeks Game
Total questions: 25
Worksheet time: 14mins
Which of the following is a function?
=Average
(C4:C10)
=
()
Which function gives the lowest number?
Max
Min
Median
Average
Which function counts the cells containing numbers in a range of cells?
=average
=max
=count
=counta
Which function removes extra spaces in a cell?
Concatenate
Trim
Lower
Right
An identifying label assigned to a group of cells.
Name Box
Range Name
Function
Cell
Sorting is when arrange data in order by column headings.
True
False
A command that displays the formulas in a worksheet so you can check them.
Scale
Show Formulas
Orientation
Filter
To hide non-matching rows in a table or list of data according to criteria you specify.
Sort
Filter
Scale
Show Formulas
Total rows are placed below the table.
True
False
The fill handle is used to select cells not to copy.
True
False
To center a label across several columns, use the Merge & Center command.
True
False
You CANNOT scale a page to print only on one page.
True
False
Select ALL the ones you need to create a sum formula.
=
(A6:A12)
add
sum
+
Which formula subtracts two cells?
=C4=D4
C4-D4
=C4-D4
=C4/D4
Which function capitalizes all the letter in the cell?
Trim
Upper
Concatenate
Lower
Which function finds the middle number?
Max
Min
Mid
Average
What is a document with more than one worksheet called?
Worksheets
Workbook
Spreadsheet
Workbooks
There is only one way to autofit a column.
True
False
What is missing in this formula?
Sum(D4:D10)
(a)
Spaces are allowed in formulas.
True
False
Which is the operator to multiply?
*
/
+
-
What function do you use to merge information from different cells? (John D Joe)
Trim
Concatenate
Lower
Left
How much typing time should you have at the end of a normal school week?
(a)
What type of document are we working on?
Word Processing
Spreadsheet
Database
Presentation
What program are we using to create a spreadsheet?
Excel
Word
PowerPoint
Access
