NEW
Font size
WorksheetsComputer 10: Date and Time, String Manipulation Functions
Total questions: 15
Worksheet time: 5mins
Which of the following concepts refers to a programmed routine that accepts argument/s and returns an output or a value?
Function
String Interval
Parameter
Procedure
What do you call the functions used to manipulate date and time values?
Date Argument
Date and Time String Interval
Date and Time Function
Data Conversin Function
What do you call the values used to help Functions to perform programming tasks?
Instances
Numeric and Non-numeric Values
Data Types
Parameters
Which of the following is NOT a valid Date and Time String Interval?
yyyy
ms
h
d
Which of the following is NOT TRUE about the String Manipulation Functions?
String Manipulation Functions are built-in Functions.
All String Manipulation Functions use parameters.
String Manipulation Functions can generate string and/or numeric output.
String Manipulation Functions work with string parameters only.
What is the value stored in a variable given below?
num = Chr(112) & Chr(85) & Chr(103)
pUf
pUg
pug
puF
Pug
What is the value that will be stored in a variable given below?
code = Len(“Integrated School”) & Mid(“Batangas”, 4, 5)
16atanga
16angas
17angas
17Batan
17ngas
What is the value stored in the variable given below?
x = DatePart(“q”, “7/15/1988”)
2
3
7
15
1988
What is the value that will be stored in the variable given below?
y = DateAdd(“q”, 4, "01/31/2019")
01/31/2020
02/01/2019
01/31/2019
01/31/2023
02/04/2019
Which of the the following Date and Time Functions returns the number of date/time intervals between two dates/times?
DateAdd
DateDiff
DatePart
DateSerial
DateInterval
The correct Date and Time String Interval for 'day of year' is:
y
yy
d
w
The correct Date and Time String Interval for 'week' is:
w
ww
d
y
How many numeric parameters are employed in Mid Function?
2
3
4
5
In the parameters of the DateDiff Function, which one is considered as the minuend?
1st parameter
2nd parameter
3rd parameter
4th parameter
What is the output of the Visual Basic Expression below?
StrReverse(LCase(“785643”))
346587
785643
364587
385647
