WorksheetsICT Paper A - Grade 5
Total questions: 20
Worksheet time: 13mins
AutoSum feature calculates the lowest value in the list.
True
False
Partially Correct
Using the given spreadsheet the correct formula to find the average of values from A4 through D4 will be:
AVERAGE(B4:D4)
AVG(A4:D4)
AVG(N/A,B4:D4)
AVERAGE(A4:D4)
Using the spreadsheet given the correct answer to the formula =Count(A1:D4) will be:
4
16
14
None of the Above
Using the spreadsheet given the correct answer to the formula =CountA(A1:D4) will be:
4
16
14
None of the Above
Using the spreadsheet given the correct answer to the formula =MIN(A1:D4) will be:
N/A
N/A, N/A
3
18
Using the given spreadsheet the correct answer to the formula MAX(A1:D4) will be:
203
900
750
400
Using the given spreadsheet choose the correct Excel formula to find all the values greater than 100.
COUNTIF(A1:D4, "><100")
COUNTIF(A1:D4, ">=100")
COUNTIF(A1:D4, ">100")
COUNTIF(A1:D1, "=>100")
It is not important to type '=' before a formula or a function in Excel.
True
False
In Excel, the name of the bar where information appears as you input data in called ?
File Bar
Help Bar
Formula Bar
Window Bar
The function COUNT is specific for _________________
Counting cells
Counting text
Counting number
Counting tables
The function COUNTA is specific for _________________
Counting text
Counting cells
Counting number
Counting tables
The two types of variables in QBASIC are:
Named and unnamed memory location
Numeric and String variables
Special characters
None of the Above
A variable name in QBASIC must always begin with a
number
letter
decimal point
space
String variable NAME is:
Valid
Invalid
Numeric Variable 5GS5 is
Valid
Invalid
Numeric Variable Ch4 is
Valid
Invalid
To skip a line in QBASIC we use the following command:
SKIP
LINESKIP
LINEPRINT
_____________ are non excecutable statements in a QBASIC program.
INPUT
CLS
Comments
_________ and ________ are the two separators used with PRINT statement.
Double quotes and Single quote
Comma and Semicolon
Comma and Forward Slash
Dollar Sign and Comma
_________ is a sign used with string variables.
%
#
$
&
