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.

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.

Np Ms Office 365/Excel 2016 I Ntermed

1st Edition

ISBN:9781337508841

Author:Carey

Publisher:Carey

Chapter5: Working With Excel Tables, Pivottables, And Pivotcharts

Section5.3: Pivottable And Pivotchart

Problem 5QC

See similar textbooks

Similar questions

You were hired to create a registration system for the athletes of Oman Sports Association. The program will start by asking the team name, the game name, and the number of players. The number of players will indicate the number of times registration fee is to be entered by the user. Store the registration fee in a list called Registration. The uniform allowance has a fixed value of 12 OMR. Compute for the accident insurance. If the registration fee is more than 175 OMR, the accident insurance is computed as 85% of the registration fee, otherwise it is 50% of the registration fee. Store the computed accident insurance in a list called Insurance. Finally, compute for the team allowance which is computed as registration fee plus accident insurance plus uniform allowance. Store the team allowance in a list called Allowance. Display the following: a. Value of the three lists. b. Highest allowance c. Lowest accident insurance d. Sum of all registration fee
Q2. A. write a code to find the number of students who pass CS course, when their marks>=40 . As the list has 85 students. ( list must show how many students passed/failed) use htmp or py B. wite a code to print this shape: * * * * * * * * * * C. Write a code to find the area and parameter of a Tringle; Area =1/2 * High * Base Parameter= S1+S2+ Base
c++ You have a list with student ratings. Into the hit list from two different universities University A evaluates students on a 5-point scale (0-failed ... 5-excellent) University B evaluates students on a 100 point scale (below 50 - failed. 50..59 = 2, 60..74 = 3, 75..89 = 4, 90..100 = 5) As a result of an error, the scores were mixed into the general list, without equalization It is necessary to sort all the marks in the list from the highest to the lowest, not forgetting that for example, a score of 5 on a 5-point scale is higher than 89 on a 100-point scale (Note 1: there are no grades below 50 at the university) (Note 2: Personality A is considered higher than B. That is, a score of 5 is better than 100)
A teacher stores the most recent quiz scores for her class in the list scores. The first element in the list holds the maximum possible number of points that can be awarded on the quiz, and each remaining element holds one student’s quiz score. Assume that scores contains at least two elements. Which of the following code segments will set the variable found to true if at least one student scored the maximum possible number of points on the quiz and will set found to false otherwise?
This is the questions and answers for the first parts Questions: Using Python Create a list with building names 'Richard Weeks Hall’, ’Busch Student Center’, ‘Environmental & Natural Resource Sciences Building’ Replace the list to 'Richard Weeks’, ’Busch Student Center’, ‘Environmental & Natural Resource Sciences Bldg’ Code for the total points of each name by setting• The base points as the length of the building name.• The bonus points: as ‘Bldg’ being equal to 10 points Meaning, 'Academic Building' which would be 'Academic Bldg' would have a base point of 13 and a bonus point of 10 for a total of 23. #1 Create a list of buildings Buildings=[ 'Richard Weeks Hall', 'Busch Student Center', 'Environmental & Natural Resource Sciences Building' ] print("The Building names in the list are: ") print(Buildings) #2 Process the name of each building res = [sub.replace(' Hall', '').replace('Building', 'Bldg') for sub in Buildings] print("The names have been replaced to :…
Find the Valedictorian Assume that you are the teacher and you need to identify which student is the valedictorian in the given list of grades. The list of grades returns 10 scores of the students.The name of students is returned using a list. The grades are given in a list using the order of the name list. The grade list contains the scores of each student.name = [['Christine', 'Maria', 'Noel', 'Alwyn', 'Katie', 'Dave', 'Austin', 'Chris']]grades = [[70, 85, 55, 25, 15, 100, 40, 60, 80, 100], \ [30, 60, 109, 10, 50, 100, 70, 90, 96, 100], \ [50, 50, 50, 50, 50, 50, 50, 50, 50, 50], \ [100, 20, 65, 67, 28, 100, 100, 99, 89, 79], \ [25, 44, 45, 75, 89, 100,60, 66, 100, 100], \ [100, 70, 50, 100, 30, 100, 100, 100, 30, 80], \ [25, 41, 43, 22, 65, 90, 100, 10, 60, 90], \ [69, 75, 74, 90, 91, 100, 80, 75, 96, 100]]A valedictorian has a score of 95 and up.Create a python program that will print the valedictorians in the given data.
Find the Valedictorian Assume that you are the teacher and you need to identify which student is the valedictorian in the given list of grades. The list of grades returns 10 scores of the students.The name of students is returned using a list. The grades are given in a list using the order of the name list. The grade list contains the scores of each student.name = [['Christine', 'Maria', 'Noel', 'Alwyn', 'Katie', 'Dave', 'Austin', 'Chris']]grades = [[70, 85, 55, 25, 15, 100, 40, 60, 80, 100], \ [30, 60, 109, 10, 50, 100, 70, 90, 96, 100], \ [50, 50, 50, 50, 50, 50, 50, 50, 50, 50], \ [100, 20, 65, 67, 28, 100, 100, 99, 89, 79], \ [25, 44, 45, 75, 89, 100,60, 66, 100, 100], \ [100, 70, 50, 100, 30, 100, 100, 100, 30, 80], \ [25, 41, 43, 22, 65, 90, 100, 10, 60, 90], \ [69, 75, 74, 90, 91, 100, 80, 75, 96, 100]]A valedictorian has a score of 95 and up.Create a python program that will print the valedictorians in the given data.…
The attached file USPopulation,txt contains the US population in thousands, during the years 1950 through 1990. The first line in the file contains the population for 1950, the second line contains the population for 1951, and so forth. Write a program that reads the file's contents into a list. The program should display the following data: the average annual growth in population during the time period the year with the greatest increase in population during the time period (highest growth rate) the year with the smallest increase in population during the time period (smallest growth rate) 151868 153982 156393 158956 161884 165069 168088 171187 174149 177135 179979 182992 185771 188483 191141 193526 195576 197457 199399 201385 203984 206827 209284 211357 213342 215465 217563 219760 222095 224567 227225 229466 231664 233792 235825 237924 240133 242289 244499 246819 249623
Le Chef Heureux Restaurant has 20 tables that can be reserved at 5 p.m., 7 p.m., or 9 p.m.Design a program that accepts reservations for specific tables at specific times; the user entersthe number of customers, the table number, and the time. Do not allow more than four guests pertable or invalid table numbers or times. If an attempt is made to reserve a table already taken,reprompt the user. Continue to accept reservations until the user enters a sentinel value or allslots are filled. Then display all empty tables in each time slot. Pseudocode and flowchart (RAPTOR please) if possible. Do not write it in any particular language, that is not required.
The code below prompts the user to enter their full name, and then converts the name to a list. Complete the code to output the person's initials. For example, if the user enters 'Adam Jones', then your code will output 'AJ'. If the user enters 'Adam Daniel Jones', then your code will output 'ADJ'. name = input('Enter your full name: ')nameList = name.split()nameList
Inserting Nodes into the List: In the following code (This is Code By C) : there are 3 functions : display, insert_begin, and delete. The request is add two functions : First Function (insert_last) : to insert values from last. Second Function (insert_mid): to insert values from Middle. Please Run the code before send it... thanks... The code: #include<stdio.h>#include<string.h>#include<stdlib.h>#include<math.h> struct node{int info;struct node* next;}; struct node* start; void display();void insert_begin(); void delete(); int main(){ int choice;start = NULL; while (1){printf("\n\t\t MENU \t\t\n");printf("\n1.Display\n");printf("\n2.Insert at the beginning\n");printf("\n3.Insert at the end\n");printf("\n4.Delete\n");printf("\n5.Exit\n"); printf("Enter your choice:\t");scanf_s("%d", &choice); switch (choice){case 1:display();break;case 2:insert_begin();break;case 3:delete();break;case 4:exit(0);break;default:printf("\nWrong Choice.\n");break;} }return…
Le Chef Heureux Restaurant has 20 tables that can be reserved at 5 p.m., 7 p.m., or 9 p.m. Design a program that accepts reservations for specific tables at specific times; the user enters the number of customers, the table number, and the time. Do not allow more than four guests per table or invalid table numbers or times. If an attempt is made to reserve a table already taken, reprompt the user. Continue to accept reservations until the user enters a sentinel value or all slots are filled. Then display all empty tables in each time slot. For this homework assignment you need to: create a flowchart using RAPTOR