Font size
WorksheetsGeneral Review Grade 7
Total questions: 50
Worksheet time: 42mins
Which of these symbols is used for divide on a computer?
\
*
/
|
Returns the number of cells in a range that contains numbers
AVERAGE
MAX
COUNT
MIN
A chart that shows the relationship of a part to a whole
line chart
bar chart
pie chart
bubble chart
A chart that uses bars of varying height to illustrate values in a worksheet
pie chart
column chart
circle chart
line chart
A graphic representation of values and their relationships: pie, line, column, bar
chart/graph
presentation
graphic image
clip art
All formulas begin with
+
=
-
*
You can name your workbook but NOT your worksheets.
true
false
Is this device Input or Output?
Printer
Input
Output
Keyboard
Monitor
Mouse
Projector
Speaker
Which type of cell reference is in the image?
Relative
Absolute
Cell
Money
Which function is found in the image?
What If Analysis
Payment
Look Up
Count
This function is used to look up information from a different section of the document:
SUMIF
PMT
AVERAGE
VLOOKUP
Which is a function?
=SUBTOTAL(A1:A9)
=A1+A9
=SUM(A1:A9)
=(A1+A9)*3
What type of field is the Agreement length allowed? field?
Lookup
Boolean logical
Numeric
Text
In database , we can
Add the record
Delete the record
Amend the record
All the above
The school wants to sort the data by alphabetical order in Surname. How will they sort it?
Ascending order
Descending order
How many records are in this database?
5
8
9
10
