Write in VBA, please. Will upvote! 1. Write a sub procedure that enters ten random values between 1 and 100 in cells A1 to A10 inspreadsheet2. Write a sub procedure that accepts an array as a parameter and loops through the cells A1 to A10 andreads data into the array.3. Write a function that accepts an array as a parameter. It then finds and returns the array index of themaximum value. Also draw a flowchart for this function.4. Write a function that accepts an array as a parameter. It then finds and returns the array index of theminimum value5. Write a sub procedure that declares a one-dimensional array of 10 elements. It calls the subprocedures of steps 1 & 2. Then it calls functions of steps 3 & 4 and stores the returned indices inlocal variables. Finally, using these indices it changes the maximum value cell color to Red andminimum value color to Green.Hint: Declare the array with lower bound of 1 to match the row numbers in spreadsheet!

1) Excel RANDBETWEEN function generates a set of integer random numbers between the two specified…

Answered: 1. Write a sub procedure that enters…

Engineering

Computer Science

1. Write a sub procedure that enters ten random values between 1 and 100 in cells A1 to A10 in spreadsheet

EBK JAVA PROGRAMMING

9th Edition

ISBN:9781337671385

Author:FARRELL

Publisher:FARRELL

Chapter8: Arrays

Section: Chapter Questions

Problem 9PE

See similar textbooks

Related questions

Q: - The step function u (t) is integral of with respect to time t.* OSinusoidal function O Ramp…

A: ANSWER:

Q: What are the Internet protocol stack's five layers? What are each of these tiers' primary…

A: Internet protocol: Data delivered across a local network or the internet is formatted according to a…

Q: What property governs how text in a Label control is aligned?

A: The Label control shows text on the form in Windows Forms and does not participate in user input or…

Q: which consists of one row .1 ..... .. and several columns or (1×n) .elements size index O array O…

A: According to the information given:- We have to choose the correct option with explanation to…

Q: What exactly is a Wire-Map Tester?

A: Introduction: The telephone map inspector sends signals to each wire using a twisted pair of pairs…

Q: You can dereference a smart pointer with the * operator. O True False

A: - We need to verify if we can dereference a smart pointer with a * operator.

Q: Describe why adaptors are frequently required when systems are built by combining application…

A: Requirement of adaptors in an integrated system When more than two application programs are merged…

Q: The instruction format for the SHL instruction is: SHL destination, count Working with a 32-bit…

A: SHL destination, count working with 32 bit operand, what are the bounds for the count value

Q: Information technology Discuss in your own words with an example the difference between Un-informed…

A: Introduction: There is a distinction between uninformed search and informed search.

Q: What is the advantage of utilizing stack when backtracking to solve N-Queen's problem?

A: Intro Problem with the N-Queens. The goal of the N - Queens problem is to arrange n - queens on an…

Q: 1-Write a C++ program to print all even numbers from 1 to n using while loop. C++ program to…

A: First we declare a variable to 1 which can be used in while loop by incrementing up to inputted…

Q: Consider the relational database below, where the primary keys are underlined. employee…

A: According to answering policy we can answer only first 3 parts . For remaining parts please resubmit…

Q: polygon side must be positive; otherwise, the program outputs invalid. • For any other wrong input,…

A: The question is to find C++ code for the given problem.

Q: What properties does the Logical Link Control (LLC) sublayer have?

A: Introduction: The Logical Link Control (LLC) defines the software processes that provide network…

Q: A manager object keeps up with the managed object's reference count and has a reference to the…

A: Answer is false

Q: C program to get 10 array elements from user and print average of it

Q: What are the advantages of biometric authentication?

A: Introduction Biometric authentication is a method of security that relies on a person's unique…

Q: Inquire into the relationship that exists between a company's information system and the system as a…

A: Introduction: Flynn's taxonomy categorizes numerous parallel computer systems. Parallel computers…

Q: xplain the idea of a system model. What concerns should be taken into account while designing basic…

A: Introduction: The impact or flow of information between modules is represented as an influence or…

Q: hen anything goes wrong or doesn't work as expected, it's called an error. What exactly is a test…

A: The answer is given below: Of course, an error occurs when something goes wrong or unanticipated…

Q: An attacker must perform the necessary actions to make a sniffer attack work. If an attacker has…

A: What exactly is a sniffer attack? A sniffer attack can retrieve the sender and receiver's…

Q: Will RIMM working memory function on a DIMM storage chipset if the motherboard supports DIMM memory?

A: Introduction: If a motherboard does not accept memory modules of a given type, speed, or size, they…

Q: Write a python program to make an iterator that drops elements from the iterable as soon as a…

A: Here in the given sample output, it is clear to drop the elements till the positive number is…

Q: Explain the following functions in a few words: -Disk Cleanup -Disk Defragmenter -Remove hardware…

A: Disk Cleanup The Windows Disk Cleanup tool will scan your hard drive for files that may be erased…

Q: This is the scenario since computers are so strong nowadays. Why have computers become so crucial in…

A: INTRODUCTION: The power of computers has been with us since their inception, but now they're…

Q: So, what exactly is software-defined networking (SDN)?

A: Introduction: SDN (software-defined networking):

Q: Why are protocols so crucial when it comes to standards?

A: Introduction: By providing standardized norms that can be widely understood and implemented,…

Q: What kind of firewall software is installed on a computer running Windows Server?

A: Firewalls are network security devices that keep an eye on and filter incoming and outgoing network…

Q: Describe virtualization in COMPTIA Security?

A: Introduction: Here we are required to explain what is virtualization in COMPTIA Security.

Q: Why is it necessary to run the server application before the client program? Why is it possible for…

A: Introduction: Connectionless UDP datagrams are sent and received using the UdpClient class, which…

Q: What are some of the most typical things that host software firewalls are utilized to safeguard?…

A: Software firewall: Host-based firewalls can catch viruses, spyware, and other hazardous programmes…

Q: Write down the benefits and drawbacks of bus topology.

A: Bus topology: Bus topology could even be a specific quite topology during which each computer and…

Q: What are the possible values for the TextAlign property?

A: INTRODUCTION: Here we need to tell the possible values for the TextAlign property.

Q: What can go wrong if a message is sent via an unreliable TCP connection, and how are these problems…

A: TCP: TCP is an acronym for transmission control protocol; it is a connection-oriented communication…

Q: Why are protocols so crucial when it comes to standards?

A: Introduction: Networks function together because of protocols and standards. Protocols enable…

Q: Explain the data label in a few words.

A: I have provided the answer in step 2.

Q: When the Categorized button is chosen in the Properties panel, what does it do?

A: Button that has been classified When the Categorized button is pressed, the Categorized object's…

Q: What are some examples of issues with traditional file processing?

A: Traditional file processing systems include manual systems and also computer based file systems that…

Q: explain what is Machine Language? Also elaborate why Electronic devices don’t understand to English…

A: Introduction: Machine language is the language that a gadget understands.All applications and…

Q: Please give two examples of computer applications that might benefit from a connection-oriented…

A: Introduction: Connection-oriented services for computer applications include file transfer and music…

Q: Construct a nondeterministic pushdown automata to recognize the language A = {a n b n+mc m : n, m ≥…

A: We need to construct nondeterministic pushdown automata to recognize the language A.

Q: Computer Science In a binary tree, what is the maximum number of nodes possible at level 3?

A: A binary tree is a non-linear data structure where each node has at most two children i.e each node…

Q: Explain why design conflicts may arise when developing an architecture with availability and…

A: Intro Explain why design conflicts may develop when creating an architecture for which the most…

Q: Describe how electronic communication between different development teams might aid software…

A: Explanation: Electronic connectivity is very important, for an organization to keep track of their…

Q: escribe some examples of data that would be acceptable for three-dimensional presentation?

A: Dimensional presentation: a measurement of something's size in a certain direction, such as length,…

Q: Is DDS an abbreviation for DDS in Computer Science?

A: DDS stands for Digital Data Storage.

Q: Write c program Get 5 numbers from user and print minimum of all

A: HI THEREI AM ADDING ANSWER BELOWPLEASE GO THROUGH ITTHANK YOU

Q: Information technology Discuss and explain new features of cloud computing that support…

A: Introduction: Cloud computing Cloud computing allows users to access the same programs through the…

Q: In Visual C#, how do you display a message box?

A: Here I written Basic C# code for display message box. I hope you like it. main part:…

Q: Computer networking what are some common CLI troubleshooting commands to diagnose and rectify a…

A: Introduction: Timeouts, high buffering periods, poor online call quality, and other issues can occur…

Concept explainers

SQL

SQL stands for Structured Query Language, is a form of communication that uses queries structured in a specific format to store, manage & retrieve data from a relational database.

Queries

A query is a type of computer programming language that is used to retrieve data from a database. Databases are useful in a variety of ways. They enable the retrieval of records or parts of records, as well as the performance of various calculations prior to displaying the results. A search query is one type of query that many people perform several times per day. A search query is executed every time you use a search engine to find something. When you press the Enter key, the keywords are sent to the search engine, where they are processed by an algorithm that retrieves related results from the search index. Your query's results are displayed on a search engine results page, or SER.

Question

Write in VBA, please. Will upvote!

1. Write a sub procedure that enters ten random values between 1 and 100 in cells A1 to A10 in
spreadsheet
2. Write a sub procedure that accepts an array as a parameter and loops through the cells A1 to A10 and
reads data into the array.
3. Write a function that accepts an array as a parameter. It then finds and returns the array index of the
maximum value. Also draw a flowchart for this function.
4. Write a function that accepts an array as a parameter. It then finds and returns the array index of the
minimum value
5. Write a sub procedure that declares a one-dimensional array of 10 elements. It calls the sub
procedures of steps 1 & 2. Then it calls functions of steps 3 & 4 and stores the returned indices in
local variables. Finally, using these indices it changes the maximum value cell color to Red and
minimum value color to Green.
Hint: Declare the array with lower bound of 1 to match the row numbers in spreadsheet!

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

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

a C++ program that creates a two-dimensional integer array (4x3) initialized with user given data. The program should have the following functions: • Print the sum of all values in the array. • Print the average of all the values in the array. • Take row number from user and print the sum of the values in that specified row.(use loop and no if statement) • Take column number from user and print the sum of the values in that specified column.(use loop and no if statement)
Create a flowchart that uses an array that contains valid names for 10 cities in Michigan namely: Acme, Albion, Detroit, Watervliet, Coloma, Saginaw, Richland, Glenn, Midland and Brooklyn. You ask the user to enter a city name; your program then searches the array for that city name. If it is not found, the program should print a message that informs the user the city name is not found in the list of valid cities in Michigan.
2. Write a program that includes two functions named calc_avg() and variance(). The calc_avg function should calculate and return the average of the values stored in an array named testvals. The array should be declared in main() and include the values 89, 95, 72, 83, 99, 54, 86, 75, 92, 73, 79, 75, 82, 73. The variance function is obtained by subtracting the average from each value in testvals, squaring the values obtained, adding them, and dividing by the number of elements in testvals. The values returned from calc_avg() and variance should be displayed using cout statements in main().
Each function deals with null terminated C-strings. You can assume that any char array passed into the functions will contain valid, null-terminated data. Your functions must have the signatures listed below. This function returns the index in string s where the substring can first be found. For example if s is “Skyscraper” and substring is “ysc” the function would return 2. It should return -1 if the substring does not appear in the string. int findSubstring(char *s, char substring[])
Using c++ write a program Program : Date Printer Write a program that reads a char array from the user containing a date in the form mm/dd/yyyy. It should print the date in the form March 12, 2014. For example Enter Date 5/14/2019 May 14, 2019 Validation Required: Month should be less than 13, day should be less than 31.
Declare a variable named num with an initial value of 0. Create a while loop that will print "Keep going" as long as the value of num is less than 5. Use window.alert() for displaying the output. Create a function named showProd that returns the product of n1 and n2. Using the new keyword, create an array named info with three (3) values: your first name, your nickname, and your last name.
In C Programming Write a main function that declares an array of 100 ints. Fill the array with random values between 1 and 100. Calculate the average of the values in the array. Output the average.
Calculate average test score: Write a program that reads 10 test scores in an array named testScores. Then pass this array to a function to calculate the average test scores, return the average to main function and display it. Input Validation: The test scores should be between 0 and 100 (inclusive). Add comments and version control.
3. Write a C# application that asks the user to search for an item in the array. Input an array of 10 elements and the search item. If the item is found in the array, display the location of the item in the array. Otherwise, display appropriate error messages.
Write a function named 'dynamicRotate (num)'. When invoked, the `dynamicRotate' function will accept a number to be used as the rotation amount and return a function. Positive numbers rotate the array to the right and negative numbers rotate to the left. The function returned by 'dynamicRotate' will accept an array to be rotated by the amount provided when 'dynamicRotate' was first invoked. It will return the original array mutated by the given rotation. Examples: ' ' ' js let arr - ['a', 'b', 'c', 'd', 'e']; rotateRightTwo = dynamicRotate (2); rotateRightTwo (arr); console.log(arr); // [ 'd', 'e', 'b', 'e' ]; let animals = ['wombat', 'koala', 'opossum', "kangaroo']; rotateLeftone = dynamicRotate(-1);rotateLeftOne (animals) console.log(animals); // [ 'koala', 'opossum, "kangaroo', 'wombat"]' ' '***************? function dynamicRotate(num) { // Your code here } /*****DO NOT MODIFY ANYTHING UNDER THIS LINE*****/ try { module.exports = dynamicRotate; } catch {…
Create Array of Random Dates In this task you are required to write a function that will generate a column array (a variable called dates) containing N random dates. N is an integer (whole number) entered by the user and will indicate to the function how many random dates the user requires. The dates array will be structured as follows: • The array shall have two columns; column 1 will contain numbers indicating the day of each month (1-31) and column 2 will contain numbers indicating the month (Jan 1, Feb=2, Mar = 3.... Dec = 12). . Each day must be randomly generated (using the randi() function) taking into account the maximum number of days in each month (i.e. Jan, Mar, May, Jul, Aug. Oct and Dec have 31 days, Apr. Jun, Sep and Nov have 30 days and Feb will have 28 days). You must use an if-elseif-else statement to decide this. • We are assuming no leap years (e. February can only have days between 1-28). For example, the output from calling the function: output = dategen (3) could…
despite that the array parameter is preceded by the const qualifier, the array elements can be modified in the function body. Select one: True False