Crowdly
Додати до Chrome
L15.2025 - Data Modelling (2025/2026)
Шукаєте відповіді та рішення тестів для L15.2025 - Data Modelling (2025/2026)? Перегляньте нашу велику колекцію перевірених відповідей для L15.2025 - Data Modelling (2025/2026) в moodle.lisboa.ucp.pt.
Отримайте миттєвий доступ до точних відповідей та детальних пояснень для питань вашого курсу. Наша платформа, створена спільнотою, допомагає студентам досягати успіху!
Evaluate each expression and select all options that correctly state its return value. You can use the table below to check some functions' syntax and explanation.
Function Syntax
|
Explanation
|
Int(number)
|
Returns the integer part of a number.
|
Round( expression [,number of decimal places]
|
Rounds a number to a specified number of decimal places.
|
Sqr(number)
|
Returns the square root of a number.
|
Rnd()
|
Generates a random number less than 1 but greater than or equal to zero.
|
Val(String)
|
Extracts the numeric value at the beginning of a string, ignoring any subsequent non-numeric characters.
|
Abs(number)
|
Returns the absolute value of a number.
|
InStr( [,start], string1, string2)
|
Returns the position of the first occurrence of is the starting position of the search. If omitted, search begins at the first character.
|
InStrRev( string1, string2, [,start])
|
Returns the position of the last occurrence of is the starting position of the search. If omitted, search begins at the last character.
|
Format( expression, format
|
Formats a value (like a date or number) into a specified text string.
|
[Expected time to answer: 2 mins]
Which of the following procedures correctly asks the user for two numbers and then displays their sum in a message box? [Expected time to answer: 2 mins]
Which of the following can be used to track the values of the variables when debugging a VBA code? [Expected time to answer: 2 mins]
Write a subroutine named “findMiddleNumber” that takes three numbers and returns the middle (median) number.
(A) Ask the user for three numbers using three input boxes. The first input box should look like this:
and the rest of the input boxes should follow a similar structure. Assume that the user input is an integer but can be very large, e.g., the user may input 40000. (B) Find the middle number by using if – elseif – else statements to compare the numbers.
(C) Display the result in a message box. The message box should look like this if the user enters 1, 2, 3 into input boxes:
Make sure to include “Option Explicit” statement before the sub.
Suppose we have the user-defined function shown in the screenshot below. If we input =discountedProfit(1000;800;0.1) in one of the cells in one of the worksheets in the same workbook that the function is defined, what will be the value in the cell when we hit enter?
Image – 1 shows the raw data. I go to Developer Tab > Code Group and select “Use Relative References” and then start recording a macro, do certain operations and stop recording the macro. The data after I stop recording is shown in Image – 2. I then selected cell C1 and run the macro. Which picture demonstrates the final version of the data?
Image-1
Image-2
Suppose you have declared a variable named “x” of type integer. You want to take an input from the active worksheet. If you select the cells shown below before running a sub, which of the options below indicate the correct ways to input the value of x as 7?
Below you can see a screenshot of a Visual Basic Editor (VBE). Based on what you see in VBE, select the statements that are true.