7 With the spreadsheet setup shown and if theuser enters 2 in the input box, what value willresult in the message box when WhatResults isexecuted?ABD1-68-133-49.-14106-7-27-36.-9-67-9-7-8Option ExplicitSub WhatResults()Dim x As Integer, y As Integerx - InputBox ("Please enter an integer")Activecell.offset (ActiveCell.offset (-2, 2), ActiveCell.offset(3, 1)).Seley - ActiveCellMsgBox Cells (y, x)End Sub127SUBMIT.Select seems to be the last part of the VBA codebut I think something is missing but I can't tellwhat because it's cut out.2.

Answered: With the spreadsheet setup shown and if…

With the spreadsheet setup shown and if the user enters 2 in the input box, what value will result in the message box when WhatResults is executed?

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Q: Use several print statements to print out the letter A exactly like the one below.

A: According to the asked question, the solution is given below with a proper explanation.

Q: Analyze the code below: for i in range(1,): for j in range ( i+1): print end= Output: 1 2 2 3 3 3 4…

A: #Program: # Outer loop will print number of rows for i in range(0,6): # Inner loop will print…

Q: 5. What is the difference between an instance variable and a static variable?

A: As per bartleby Guidelines we did 1 Answer only

Q: Given the following list year=[1988, 1995, 1993, 1992] What is the value of the item in index 27 a.…

A: The answer is given below;-

Q: Give a definition of Graph and show examples of a directed and an undirected graphs in roster set…

A: We need to define a directed and undirected graph. Also, need to define the degree of these graphs.…

Q: What is the sum of each pair of binary integers? 00001111 + 00000010 = + 01101011 = 11010101…

Q: 3 Logical Equivalences Prove that the following pairs of compound propositions are equivalent by…

A: a) Given compound propositions are, ¬(p→q)∧¬q and p∧¬q It contains two variables p, q

Q: An algorithm that has time complexity of O(n^2) requires 1 second to process 10 input records.…

A: As per our company policy we can attempted one question at a time if you want the answer of the…

Q: art 1::-

A: I have written the code below for Part 1. as mentioned in the question:

Q: Question 13 Which of the following will you find on an SRS? end user documentation test plans who,…

A: Below are the answers with explanation:

Q: QUESTION 2 Which statement has a similar logic to switch-case? multiple if-else multiple if for O…

A: Which statement has a similar logic to switch-case? > multiple if-else [RIGHT] > multiple if…

Q: (2) Calculate the cosine similarity between B and D. (3) Use collaborative filtering method with…

A: Users/Items a b c d e f A 0 4 0 1 2 5 B 2 0 3 2 5 2 C 0 3 5 0 0 4 D 1 0 3 5 4 0

Q: Question 4. Write a function called word_points that takes a word as a string and outputs the…

A: As per Bartleby's rules, we can only answer one question at a time. I request you to post Question 5…

Q: Use limits to prove the following asymptotic statements. 1. V4n² + 1 = O(n). 2. n" = Q(n!). 3. Vn +…

A: 1. 4n2+1=Θn Limit method We have two functions f(n) ang g(n), then we setup limit quotient between f…

Q: 7. problems do not have defined solutions, since they infrequent basis. Occur on an

A: NOTE: In this question, we are asked to answer the 7th and 8th question. Clearly 7th question comes…

Q: Answer 7, 8, 9

A: Bitmap images are made up of pixels.

Q: Give a definition of Graph Embedding, Planar Embedding. Is the following graph a planar graph?…

Q: 1. Generate dataset Write Python code to generate a regression dataset that contains 250 examples.…

A: The kNN model is built using the following broad set of steps :generate the dataset - train and…

Q: List the first 5 terms of the sequence whose nth term is 3" – 2“. Is it arithmetic progression or…

A: In step 2 and 3, you will get the solution.

Q: . Genetic information in all living things is coded as DNA molecules. A DNA molecule is a linear…

A: The maximum information capacity of an average gene is 200,000 bits. This means that an average gene…

Q: If 5 bits are used to code (count to) only 28 decimal values then the number of unused binary codes…

A: So the answer for Part A) will be 4 and part B) will be 8 Explanation below:

Q: Genetic information in all living things is coded as DNA molecules. A DNA molecule is a linear…

Q: (a) Loads the .mat file and computes the Fourier transform of the phase. (b) Estimates the breathing…

A: Matlab Program for Fourier Transforms: The function in MATLAB uses the Fast Fourier Transform…

Q: Problem 5, Learn by Example. Write one program that correctly solves all of the problem instances.…

A: - We need to solve the problem using 5 variables and print in the order shown. - The order in which…

Q: A sorted list of numbers contains 128 elements, Which of the following is closest to the maximum…

A: A sorted list of numbers contains 128 elements.8 is closest to the maximum number of list elements…

Q: problem didnt even answer D and E

A: In this question we will simplify the expression using Boolean expression Let's solve.

Q: 6. What is the difference between remove and clear in ArrayLists.

A: The clear() method removes all the elements of a single ArrayList. It's a fast operation, as it just…

Q: Which of the following is an example of an attack using a rogue access point? A An unauthorized…

A: Note: There are multiple questions are given in one question. According to the rule, you will get…

Q: The graph is another structure that can be used to solve the maze problem. Every start point, dead…

Q: WREG contains the value 0x86. What will be the content of the WREG (in hex notation) and the states…

A: ANSWER:-

Q: 1. A(n). is a device with a keypad that is used to write and enter a user-developed control program…

A: According to the Bartleby guideline, we are supposed to answer only 3 fill in the blank question at…

Q: • Given the interface (header file) of a parametroc Deque below, write its implementation. Listing…

A: Solution: The Deque class provides a constructor and a destructor, as well as methods to…

Q: The domain for this problem is some unspecified collection of numbers. Consider the predicate P(x,…

A: Answer: Given P(x, y)="x is greater than y"; we need to write the translated predicated

Q: Using the figure in previous problem, list each entity and state what foreign key, if any, would be…

A: In the previous answer, we have identified the business rules. Now we will identify the foreign key…

Q: LAB ACTIVITY 23.21.1: LAB: The ___str__() method 1 class Number: 2 3 4 5 6 7 8 9 10 11 12 13 if…

A: Code in PY: class Number: def __init_(self): self.num=0 self.name="jon"…

Q: Q5. According to legend, the monks in a remote mountain monastery knew how to predict when the world…

A: To move 5(n) disks from the first needle to the last needle using a intermediate needle: If there…

Q: What problems do businesses often encounter when attempting to switch to a cloud-based system? When…

A: Introduction What challenges do businesses have when attempting to switch to a cloud-based…

Q: The graph is another structure that can be used to solve the maze problem. Every start point, dead…

A: Graph data structure A Graph is a non-linear data structure that consists of nodes and edges. Nodes…

Q: 1. Tyrone Shoelaces has invested a huge amount of money into the stock market and doesn't trust just…

A: Given three variables p, m and z where p=Pain Webster, m=Meg A. Cash and z=LaZora.As per the…

Q: 3. Consider the following algorithm Algorithm Mystery(A[0..n - 1, 0..n - 1]) //Input: A matrix…

A: Answer: We have explain given algorithm and also we have shown how many takes time and run the loop…

Q: How many 6-character license plates are possible if the first character must be a letter that is not…

A: solution: it required 6 character license plates first characters must be a letter (26) except…

Q: Which of the following is a true statement about the use of public key encryption in transmitting…

A: Correct option:D

Q: Which code segment results in "true" being returned if a number is even? Replace "MISSING CONDITION"…

A: A number is even if when divided by zero it leaves zero as a reminder. In the condition A. num%2 ==…

Q: 2: 5 -> aSbs | bsas | e (read e as "epsilon") ich grammar(s) produces the set of strings with equal…

A: Consider the given grammar

Q: How many times will the following loop run? int i = 10; do { cout << i; i=i++; } while (i < 10); .…

A: C++ programming language is an object-oriented programming language, that's used to develop web…

Q: } } 18. Which traversal method does this algorithm describe? 19. Apply this algorithm to the tree…

A: Q18 The traversal depicted is inorder traversal as it is first going to root left child…

Q: Consider the following algorithm segment. Assume that n is a positive integer such that n 2 4. for k…

A: Here we don't have any conditional statements like if written inside the loops. So all the…

Q: Starting with the priority queue represented by the heap shown below (start over again with this…

A: Part D) Level order traversal of required heap is 50 46,37 19,2,35,11 12,8,1 Part e) Level order…

Concept explainers

Fundamentals of Big Data Analytics

Big data analytics is the process of using advanced analyzing techniques against huge variant data sets to uncover hidden pattern or knowledge. It helps in organization's decision making process. Big data can be organized in any of the following formats.

Question

100%

With the spreadsheet setup shown and if the
user enters 2 in the input box, what value will
result in the message box when WhatResults is
executed?
A
B
D
1
-6
8
-1
3
3
-4
9.
-1
4
10
6
-7
-2
7
-3
6.
-9
-6
7
-9
-7
-8
Option Explicit
Sub WhatResults()
Dim x As Integer, y As Integer
x - InputBox ("Please enter an integer")
Activecell.offset (ActiveCell.offset (-2, 2), ActiveCell.offset(3, 1)).Sele
y - ActiveCell
MsgBox Cells (y, x)
End Sub
12
7
SUBMIT
.Select seems to be the last part of the VBA code
but I think something is missing but I can't tell
what because it's cut out.
2.

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

This is a popular solution!

SEE SOLUTION Check out a sample Q&A here

Step 1

VIEW

Step 2

VIEW

Trending now

This is a popular solution!

Step by step

Solved in 2 steps with 3 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions

Is that correct?
This is question 5 on the same chapter 9
Q5. According to legend, the monks in a remote mountain monastery knew how to predict when the world would end. They had a set of three diamond needles. Stacked on the first diamond needle were 5 gold disks of decreasing size. The monks moved one disk to another needle each hour subject to the following rules. (CO01) • Only one disk could be moved at a time. • A Larger disk must never be stacked above a smaller one. • One and One auxiliary needle could be used for the intermediate storage of disks. The legend said that when all 5 disks had been transferred to the destination needle, the stars would be extinguished and the world would end.Solve the above problem using recursion and draw a step by step procedure till the disks are transferred from source to destination.
3 please help me with this Data structure and algorithm
please help me to answer
please answer the second partb
This question can be found in Anany Levitin Edition 2
Only 17
Q7 and 9 Please explain your answer
question 40/41
Only Part b
Help, please.