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: The Florida Company was flooded by a Hurricane and somehow lost part of their forecasting data. The…

A: α, smoothing constant = 0.20 given Error = Actual - Forecast Cumulative Error = Previous Cumulative…

Q: provide the correct answer and show all steps to the last question C

A: Solution of the given question is like asBy using the fermet theorem we have the result direct as we…

Q: How many eight-bit binary strings contain exactly 3 1s? How many eight-bit binary strings contain…

A: The question has been answered in step2

Q: Please help me match the first image A-F with the second image a-d

Q: XY Gate A OA is OR, B is AND O A is NOT, B is AND OA is AND, B is OR O Both A and B are NOT Circuit…

A: We are given a digital circuit and we are asking the Gate A and Gate B. We will try to find out the…

Q: (14)5 equal (10)10 O True O False

Q: Which of the following is a generator(or primitive element) of the group Z*11

A: Primitive element of a finite field GF is a generator of the multiplicative group of the field.

Q: 98) F(X,Y,\Wiz)=TT M(0, 2 ,3 00 01 11 10 00 3 2. 6 4 12 13 I5 14 10 10

A: Minimize the given function to sum of products and product of sum

Q: Please do not give solution in image format thanku 2. What is the assembly language equivalent of…

A: Assembly language is a low-level programming language that is a human-readable representation of…

Q: Describe the condition for the jump to occur in the following code segment: Cmp eax, 3 jnb loc…

A: The answer for the above code segment is given below:

Q: The floating point decimal numbers below are stored in the form of SEEMMMMM where the exponent is…

A: ANSWER: (i) Deduction: 65420433-55555154 sign piece is unique so it ought to be changed first.…

Q: For the source coding: (a) What is/are the benefit(s) of calculating entropy? (b) What is/are the…

A: Note: As per Q and A guidelines, will be solving only 1st question with a) and b) part.

Q: p.92, icon at Example 13#1. Prove that this statement is true for all integers 푛: 푛 is odd if and…

A: To prove the statement "An integer ( n ) is odd if and only if ( 5n + 3 ) is even," we can approach…

Q: 4. The bfloat 16 "brain floating point" format is a 16 bit format used in Google's machine learning…

A: As per our guidelines, only 3 sub parts will be answered. So, please repost the remaining questions…

Q: 2. Formulate the following arguments symbolically and determine whether each is valid. (a) If the…

A: we are examining three distinct arguments and determining whether they adhere to the principles of…

Q: Computer Science 33)) Recalling roman numerals, I=1, V=5, X=10, L=50, C=100, D=500, M=1000, and make…

A: DFA (Deterministic Finite Automaton):Deterministic: In a DFA, for each state and input symbol, there…

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

2.17 Compute and plot the convolutions x(n)*h(n) and h(n)*x(n) for the pairs of signa shown in Fig.
Q5 Python code to Produce and print the first 10 sentences of the Fibonacci series. Fibonacci series: 1, 1, 2, 3, 5, 8, 13, 21, ...
Encrypt Encrypt the animal name pangolin using the letter to number correspondence abcdet ghijk 1 m nopqrstuvM x y z e 1 2 3 4 5 6 7 8 9 18 11 12 13 14 15 16 17 18 19 28 21 22 23 24 25 and the encrypton function f (n) = (n + 20) mod 26 The answer will be a nonsense word (no numbers). Decrypt An animal name was encrypted with the scheme described above. The encrypted animal name is urifinf . What is the animal name?
] In the following problems, check suitable rule (Sum, Subtraction or Product) and compute the total number of possible ways in the entire procedure: The password for a computer account can be 6, 7 or 8 characters in length; the characters can be letters or digits. What is the number of ways a password can be formed? How many bit strings of length sixteen start with a 11 or end with 00?
We are drowning in information, while starving for wisdom. The world henceforth will be run by synthesizers, people able to put together the right information at the right time, think critically about it, and make important choices wisely. -E. O. WilsonWhat is the meaning of the sentence above?
a) Digital communication has made technology more pleasant in today's environment. Discuss the proposed techniques for compressing still pictures.b) Among the coding schemes available in communication systems, discuss the one that tries to minimize data size via compression.
I need to solve the following: "ii) Suppose a book has the ISBN number 0444x50090, where the digit represented by x has been lost in transmission. What is x?" I know that for encoding there's a formula one can use but I'm confused about how to use it with the x?
a) A computer has a clock rate of 2GHz. It takes a program 10s to complete on this computer. The number of clock cycles of the program is b) A program has 1x106 instructions. The computer's clock cycle time is 250x10-12 seconds and the CPI is 2.0. Therefore, the CPU time of the program is seconds. c) We use a certain compression program as a benchmark of a certain computer system. The program has 2x10° instructions. The system has a CPI of 0.85, and a clock cycle time of 0.4x109 seconds. When we run the program, it takes 100 seconds to complete on the computer system, whereas it takes 900 seconds to complete on a reference computer. From what you know about the SPEC benchmarks, the SPECratio is
Using MATLAB or Octave (a) Create an evenly spaced vector from 0 to 128 (spacing of 2)(b)Create an evenly spaced vector from 0 to 256 (spacing of 4) Must use linspace (c) Create an evenly spaced vector from 1 to 100,000 with 5 values. MUST use logspace