Font size
WorksheetsPractice Quiz QBASIC and Excel Functions
Total questions: 20
Worksheet time: 15mins
The function that lets you add up a range of cells or values
AVERAGE
SUM
MIN
MAX
What function was used to find the highest data ?
AVERAGE
MIN
SUM
MAX
What function was used to find the lowest data ?
AVERAGE
MIN
MAX
SUM
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
How would you write a cell reference formula for cell A1 subtracted from Cell C3?
A1-C3
A1-C3=
=A1-C3
=C3-A1
Which operator is used to multiply in Excel?
+
x
/
*
A data value that does not change during the execution of a program is _____.
Variable
Constant
Character
The statement used to display the output on the screen is _______.
INPUT
LET
In PRINT command, the message is closed in ______.
Double Quotes
Semicolons
Single Quotes
What is the Output:
PRINT "how are you?"
(a)
The QBASIC Statement for accepting the values from the user:-
LET
REM
INPUT
Which out of the following is a valid variable to hold the text in QBASIC.
LET
$S
S$
SS
Statement in QBASIC to clear the output screen
CLS
CLEAR
CLEAR SCREEN
CLRSCR
x=5
is numeric constant
is alphabet constant
is algebraic constant
is string constant
an example of a string constant is
"123"
-7
4rs
5/6
What is the correct output of the following statement:
PRINT "9-9"
0
NINE
9-9
None of the Above
