NEW
Font size
Worksheetscomputer 8 class
Total questions: 37
Worksheet time: 19mins
What enables us to spot trends
Line chart
Pie chart
Which function is used to multiply numbers
Product
Power
What is used to highlight unusual data
Conditional formatting
Formatting
We need to specify a base number and exponent when using the
POWER
PRODUCT
The cells on which a function is to be applied are called the
Formula
Data range
Which of these is the correct syntax for the sum function
=SUM(A1:A10)
SUM(A1:A10)
The IF section of the IF function contains a
Logical test
Value
The conditional formatting feature is located on the
Review tab
Home tab
Which type of chart is used to compare items in different categories
Bar
Line
Which of these charts shows data as sections of a whole
Pie
Column
A good problem definition should be
Precise
Lengthy
Information about converting input into output is called
Method requirements
Process requirement
The output requirements tell us what the
Result of a good solution should be
Speed of a good solution should be
In a REPEAT... UNTIL statement the computer stops repeating an action when the condition becomes
True
False
The DO... WHILE loop tests a condition
After carrying out the instructions
Before carrying out the instructions
Solving a problem in
Steps helps to avoid confusions
Seconds helps to avoid confusions
A good problem definition is essential for developing a good
Statement
Solution
Which of these is an import requirement
Decision
Data about the environment
Which is not a processing requirement for preparing a meal
Cutting
Eating
Which of these involves repetition problem
Reading a book
Polishing a diamond
The equal (=) sign is a/an
Relational
Assignment
Removing an error is called
Debugging
Detecting
The computer detects and reports a
Logical error
Syntax error
What is the process of removing an error from a program
Correction
Debugging
Which of these is not an automatical operator
+
<
According to the order of precedence for arithmetical, calculations which of these is performed before the others
Addition
Exponent
Which of these is a command used in BASIC
Go
RUN
Which of these is a variable
4
x
Which of these reflects the order of precedence
Multiplication before brackets
Brackets before division
Entering the date 30/2/2015 is an example of
Logical error
Syntax error
Who played an important role in developing GW-BASIC
Charles Babbage
John G.Kemeny
BASIC stands for
Beginner all purpose symbolic instruction code
Before all purpose symbolic instruction code
The simplest assignment operator is the
Equal sign (=)
Less than equal sign (<=)
A constant is a term that has a
Fixed value
Doesn't have a fixed value
A statement is an instruction to a computer
To perform a unique task
To perform a simple task
A computer does not detect a
Logical error
Syntax error
The first step in problem solving is to define the
Problem
Solution
