Using VBA Code create a list of 5 expenses amounts and notes. Find the smallest expense. Instead of creating a "footing" of the smallest expense, in the list highlight the expense and note and put a note in the cell to the right of it that it is the smallest expense. Find the highest expense. Instead of creating a "footing" of the highest expense, in the list highlight the expense and note and put a note in the cell to the right of it that it is the highest expense. Show code and outputs of Code in Excel and VBA.
Q: float named MN. The function returns an integer. Write the definition of a function named Ave that ...
A: As per guidelines, we can only solve one question at a time. Hence resubmit the question for further...
Q: Using C Language, trace the following: (c) #include #include void kar1(char *c, char b, char *a) {...
A:
Q: java programming Create a class called Citizen with the following attributes/variables: a. String c...
A: As per our guidelines we are suppose to answer first three sub question. Kindly repost other questio...
Q: n Python programming, which of the following operators is the correct optic A a^*b B) a^^b a**b
A: Explanation:In Python programming, ** denotes that this operator is used to raise a number to a cert...
Q: When the target string includes a digit, what occurs in the Str ucase method from Section 9.3?
A: Solution !! Str_ucase procedure The Str_ucase procedure is used to convert a string to all upperca...
Q: Using Common Lisp, complete the following programming exercises: Write a function that computes the ...
A: Here is the detailed explanation of the program
Q: What happens next once you click on the A thread:
A:
Q: Explain any five assembler directives of 8086 microprocessor
A: 8085 microprocessor or the eighty eighty five microprocessor are the 8 bit microprocessor which are ...
Q: q4 please
A: Answer 4 is given below- If you have any query comment below.
Q: I have text called para , How I can extract first two character from each word (not the number) with...
A: Here I am attaching code and screenshot of the output:- import re txt = "para" x = re.findall("^...
Q: Because even though we may not understand them, algorithms can help us solve problems.
A: INTRODUCTION: Computations are carried out by following a set of rules, known as an algorithm. When...
Q: that contains the distance that Mr. Monkey can jump if he eats a banana from t;. Write an algorithm ...
A: We have two choices at every tree either to jump or walk. If we jump as x and jump value of k we can...
Q: 7.a. How many wavelengths are usually leased in a lit fiber lease agreement over two fibers? A. Four...
A: The solution to the given problem is below.
Q: Using C#, create an application that will ask the user to enter password set in the program for only...
A: Password print('Enter username and password to continue with exam')count=0while count < 3: us...
Q: What is the virtual key symbol for the Right Ctrl function key?
A: Answer:
Q: Why is the JNE instruction used in the Str trim operation in Section 9.3?
A: Your question is about JNE is given below :
Q: At least three FPU special-purpose registers should be mentioned
A: Answer: In order to configure the FPU, detect its state, and help in exception processing the FPU us...
Q: Which of the follow describes the fixed partition technique? Group of answer choices: a) Main memor...
A: Which of the follow describes the fixed partition technique? Group of answer choices: a) Main mem...
Q: A number 428 in duodenary (base 12) is to be added to C10 in tredenary (base 13), what is their diff...
A: Here in this question we have given two number in base 12 and 13 i.e (428)base12 (C10)base13 and we ...
Q: How bandwidth impacts on the performance of a network. Discuss how bandwidth impacts on the perform...
A: Given The answer is given below.
Q: Four criteria were defined for comparing search strategies: completeness, optimality, time complexit...
A: ANSWER:-
Q: 5. Find the molar flow rates of all species out of an equilibrium reactor when the inlet values of n...
A: The given reaction is: Inlet molar flowrates: N2 = 1.1 H2 = 3 NH3 = 0.2 Let the extent of reaction ...
Q: Use the power series method to construct a polynomial interpolating (0,10),(1,18),(2,8),(3,−1) ...
A: Note: Code run successfully as above problem describe. I have attached a screenshot and output below...
Q: What is the database transaction? Could you describe how it is usually used and why? Could you pleas...
A: SUMMARY: - Hence, we discussed all the points.
Q: Using C language, trace this:
A: The major difference between the pass by value and pass by reference is that in case of pass by valu...
Q: Q1. Eight LEDS are connected to P3. Write an 8051 C program that shows the count from FF down to 0 o...
A: Calculation for delay : assuming 8051 clock frequency = 12MHZ thus 1 machine cycle time is = (1/12MH...
Q: Write a java program to perform the following operations using method overloading i)Get two strings ...
A: Method overloading is a form of polymorphism in OOP.
Q: Let A = {P, Q, R} be the set of nodes in a computer network. Show a communication link relation on s...
A: Given set of of nodes in set A= {P, Q, R} The communication link must contain 8 links and each commu...
Q: linked list is an object that creates, references and manipulates node objects. In this assignment,...
A: The answer is given below:-
Q: 3. Given the following three dimensional array int a[3][3][2]={ 1,2,3,.... 18}; Write assembly progr...
A: static: i:int32; j:int32; TwoD:int32[ 4, 8 ];
Q: Write a program that prompts the user to enter the weight of a person in kilograms and outputs the e...
A: Given The answer is given below.
Q: Sterile Reports Research Example ERD Problem
A: Answer is given below.
Q: achine Problem: Create a C-program using one dimensional array that will display the output below. T...
A: In this question, we are asked to write a C program where user enter a element and position for the ...
Q: In LISP, the function (copy-list )
A: the function (copy-list <list>) returns a new list that is equal to <list> by copying t...
Q: Which of the following commands inserts an integer operand into ST(0)?
A: Introduction: The FIELD (Load Integer) instruction converts an integer operand in memory to extended...
Q: Q3 (6%). Let x = [æ1, x2, x3] and y =+ log, 22 – . Calculate the fo * at x = [9,1, ): Hint: the answ...
A: 1.
Q: A subtype is a sub-grouping of the entities in an entity type that is meaningful to the organization...
A:
Q: (e) (5% - 3 minutes) Without using the variable b, write code that will set Mary's height to be 6.2....
A: for this solution we have to just place b variable to the a.p value . whole code is written below.
Q: rocedure to return to a memory address that was 3 bytes higher than the one on the stack right now. ...
A: Let's say you needed a procedure to return to a memory address that was 3 bytes higher than the on...
Q: Cloud computing is now widely used in many enterprises' information systems. Discuss cloud computing...
A: Find the answer given as below :
Q: Create a Java program in codiva.io to print the "smallest" and "largest" character in your name. For...
A: public class chegg { // function that return the largest alphabet. static char larg...
Q: What is data mining and how does it benefit you? What are some data mining tasks that you might writ...
A: Step 1) Data mining : Data mining refers to extracting knowledge from large amount of data The pro...
Q: You are to write a simple ANSI C program to input a set of vehicle values from a text file and print...
A: CODE-- Vehicle.java: class Vehicle { private int vin; private String make; private String m...
Q: The student wishes to make the code work and display as follows: List List 1: · BB218 · Internet in ...
A: python code for the following above list displaying
Q: Network Address Translation, or NAT, was used very often before IPv6 was fully implemented as a mean...
A: Defined the utility of Network Address Translation(NAT)
Q: Code three tests: 1) for a student who has courses 2) for student who does not have courses 3) a ...
A:
Q: Question 3: Complete a Simulation table for checkout counter using the Event Scheduling/ Time Advanc...
A: To advance the clock time, a simulation table is being used and with that, a new snapshot of systems...
Q: This is to be programed in java You will create a driver file called personalInfo.java perso...
A: Here I have created the class Person with attributes and constructor. Then, I have created a method ...
Q: simplicity, we will focus on estimating the image intensity at a single location. Interpolation is u...
A:
Q: se you want to deposit a certain amount of money into a savings account with a fixed annual interest...
A: Lets see the solution.
Trending now
This is a popular solution!
Step by step
Solved in 4 steps with 3 images
- Transcribed Image Text A summer camp offers a morning session and an afternoon session. The list morningList contains the names of all children attending the morning session, and the list afternoonList contains the names of all children attending the afternoon session. Only children who attend both sessions eat lunch at the camp. The camp director wants to create lunchList, which will contain the names of children attending both sessions. The following code segment is intended to create lunchList, which is initially empty. It uses the procedure IsFound (list, name), which returns true if name is found in list and returns false otherwise. FOR EACH child IN morningList { <MISSING CODE> Which of the following could replace <MISSING CODE> so that the code segment works as intended? IF (IsFound (afternoonList, child)) { A APPEND (lunchList, child)b. ID: A Name: 0. A summer camp offers a morning session and an afternoon session. The list morningList contains the names of all children attending the morning session, and the list afternoonList contains the names of all children attending the afternoon session. Only children who attend both sessions eat lunch at the camp. The camp director wants to create lunchList, which will contain the names of children attending both sessions. The following code segment is intended to create lunchList, which is initially empty. It uses the procedure IsFound (list, name), which returns true if name is found in list and returns false otherwise. FOR EACH child IN morningList 11 Which of the following could replace so that the code segment works as intended? IF ((IsFound (morningList, child)) OR (IsFound (afternoonList, child))) IF (ISFound (afternoonList, child)) APPEND (lunchList, child) APPEND (lunchList, child) a. { C. IF (IsFound (lunchList, child) ) IF (IsFound (morningList, child)) APPEND…P1 - Loan Payment Schedule Main Street Bank is offering an annual interest rate discount based on the client’s credit score. The discount for each credit score level is provided in the table below. The lowest credit score is 300 while the highest credit score is 850. For example, the new interest rate for a client with a credit score of 755 and a current interest rate of 4.25% would be 4.25 – 0.75 = 3.50% interest rate Credit Score Rating Interest Rate Discount 300 - 579 Very Poor 0.00 580 – 669 Fair 0.25 670 - 739 Good 0.50 740 - 799 Very Good 0.75 800 - 850 Exceptional 1.00 Use modular programming concepts Create a program that includes a WHILE loop to generate a payment schedule for loans that are paid in equal monthly payments Input the loan number and retrieve required loan account from MS_LOANS table Output is shown below Monthly interest is calculated by dividing the yearly interest rate by 12 to get a monthly interest…
- Fill in the loop table with the correct values, Each row should represent the values of the variables at the line with the comment LOCATION. You don't necessarily need to fill out all of the rows on the provided fable. If you don't fill up the whole table, that isn't necessarily wrong! 1 - 2 a - 10 name - 'AL' while i < 9: if name 'AL': 1: 2 nam AL intinl else: if name < 'NAPOLEON': name - 'NASH elif name < 'NATE': name - 'SAM' else: name- 'AL ' # LOCATIONHospital :ER Case Study A General Hospital consists of a number of specialized wards (such as Radiology, Oncology, etc) .Information about ward includes unique name, total numbers of current patients. Each ward hosts a number of patients, who were admitted by a consultant (doctors) employed by the Hospital. On admission, the date and time are kept. The personal details of every patient includes name, Medical Recode Number (MRN), set of phone and one address (city, street, code). A separate register is to be held to store the information of the tests undertaken. Each test has unique episode No. , category and the final result of test. Number of tests may be conducted for each patient. Doctors are specialists in a specific ward and may be leading consultants for a number of patients. Each patient is assigned to one leading consultant but may be examined by other doctors, if required. uHospital :ER Case Study A General Hospital consists of a number of specialized wards (such as Radiology, Oncology, etc).Information about ward includes unique name, total numbers of current patients. Each ward hosts a number of patients, who were admitted by a consultant (doctors) employed by the Hospital. On admission, the date and time are kept. The personal details of every patient includes name, Medical Recode Number (MRN), set of phone and one address (city, street, code). A separate register is to be held to store the information of the tests undertaken. Each test has unique episode No., category and the final result of test. Number of tests may be conducted for each patient. Doctors are specialists in a specific ward and may be leading consultants for a number of patients. Each patient is assigned to one leading consultant but may be examined by other doctors, if required.
- Use Python Programming - restaurant reservation program. The application offers different reservation rate for adults and children. (see sample below) RESTAURANT RESERVATION SYSTEMSystem Menua. View all Reservationsb. Make Reservationc. Delete Reservationd. Generate Reporte. Exit 2. When the VIEW RESERVATIONS is clicked, this will display all the reservations made: # Date Time Name Adults Children 1 Nov 10, 2020 10:00 am John Doe 1 1 2 Nov 25, 202011:00 am Michelle Franks 2 1 3 Dec 10, 2020 9:00 am Ella Flich 1 1 4 Dec 21, 2020 12:00 pmDylan Cloze 2 1 3. If the user selects MAKE RESERVATION, the user needs to input the following: a. Name (String)b. Date (String)c. Time (String)d. No of Adults (Integer)e. No of Children (Integer) Note: Adult is 500 per head and Kids is 300 per head reservation, save the data in a text file. 4. If DELETE RESERVATION is selected, the user needs to input the reservation number to remove the existing reservation. 5. If the GENERATE REPORT is clicked,…Use Python Programming - restaurant reservation program. The application offers different reservation rate for adults and children. (see sample below) RESTAURANT RESERVATION SYSTEMSystem Menua. View all Reservationsb. Make Reservationc. Delete Reservationd. Generate Reporte. Exit 2. When the VIEW RESERVATIONS is clicked, this will display all the reservations made: # Date Time Name Adults Children 1 Nov 10, 2020 10:00 am John Doe 1 1 2 Nov 25, 202011:00 am Michelle Franks 2 1 3 Dec 10, 2020 9:00 am Ella Flich 1 1 4 Dec 21, 2020 12:00 pmDylan Cloze 2 1 3. If the user selects MAKE RESERVATION, the user needs to input the following: a. Name (String)b. Date (String)c. Time (String)d. No of Adults (Integer)e. No of Children (Integer) Note: Adult is 500 per head and Kids is 300 per head reservation, save the data in a text file. 4. If DELETE RESERVATION is selected, the user needs to input the reservation number to remove the existing reservation. 5. If the GENERATE REPORT is clicked,…LOGICAL EXPRESSIONS #15 SURGERY_DATE is a datetime column that stores the dates on which surgeries were performed. The time stored is midnight. Which of the following will return TRUE for surgeries performed in 2016 and FALSE for all other surgeries? SELECT ONE OF THE FOLLOWING A. SURGERY_DATE BETWEEN '31 DEC 2015' AND '31 DEC 2016' B. SURGERY_DATE BETWEEN '31 DEC 2015' AND '1 JAN 2017' C. SURGERY_DATE BETWEEN '1 JAN 2016' AND '31 DEC 2016' D. SURGERY_DATE BETWEEN '1 JAN 2016' AND '1 JAN 2017'
- An ISBN (International Standard Book Number) is a 10 digit number that is used to identify a book. The first nine digits of the ISBN number are used to represent the Title, Publisher and Group of the book and the last digit is used for checking whether ISBN is correct or not. To uniquely identify a book a 10-digit ISBN number is used. The rightmost digit is checksum digit. This digit is determined from the other 9 digits using condition that 10d, + 9dz + 8dg + + d4o must be a multiple of 11 (where d, denotes the i" digit from the right). The checksum digit d; can be any value from 0 to 10: the ISBN convention is to use the value X to denote 10. Write a C program using pointers that receives a 10- digit ISBN, and computes the checksum, and reports whether the ISBN number is correct or not. Example: 007462542X = 10°0 + 9*0 + 8*7 + 74 + 6*6 + 5*2 + 4*5 + 3"4 + 2*2 + 110 = 176 Since 176 leaves no remainder when divided by 11, hence it is a valid ISBN. Note: When the check digit turns out…PYTHON CODE Using Artists.csv (link below), write a query that returns all lines that are female artists only, with begin date greater than 1950 but no greater than 2000 Write a query that will return all lines of British Male artists, who's first names starts with the letter ‘A’ and has an end date earlier than 1990 Write a query that will write to a file all lines that have Japanese Artists who’s difference of end date and begin date exceeds 100 years. I.e. if artist begins in 1900 and ends in 2005, then they would be included in the output (2005-1900 = 105 years) Write a query that will write and find to a file the artist who’s been at the Museum the longest (the widest gap between Begin Date and End Date) Artists.csv: https://media.githubusercontent.com/media/MuseumofModernArt/collection/master/Artists.csvcalculate_new_balance Given a starting balance (a number), and a list of transaction tuples, calculate the final balance for an account. Transaction tuples are of the shape ("description", amount, "withdrawal") , or ("description", amount, "deposit"). The last entry in the tuple will be either "withdrawal" or "deposit". Every withdrawal decreases the balance of the account by the specified amount, and every deposit increases the balance. The return value is the new account balance, as a number. (which could be negative) Sample calls should look like: >>> calculate_new_balance(100, [("payday", 20, "deposit"), ("new shoes", 50, "withdrawal"), ("illicit winnings", 200, "deposit")])270>>> calculate_new_balance(100, [])100