1 2 3 4 5 6 7 8 A B Paper Type Name Letter Stock 65lb Cover Stock Premium White Copy Paper 2 Hole punch Letter Ultra-White Cardstock C Quantity 100 17 25 66 87 D Discount 25% 5% 10% 15% 20% E F Order Discounts G Minimum Quantity Discount 0 25 50 75 100 5% 10% 15% 20% 25% In the above spreadsheet, create a formula in cell D4 that uses the VLOOKUP function with the table array $F$4:$G$8. The formula will determine the applicable discount for each paper type order. You should be able to autofill this formula down through cells D4:D8.

1 2 3 4 5 6 7 8 A B Paper Type Name Letter Stock 65lb Cover Stock Premium White Copy Paper 2 Hole punch Letter Ultra-White Cardstock C Quantity 100 17 25 66 87 D Discount 25% 5% 10% 15% 20% E F Order Discounts G Minimum Quantity Discount 0 25 50 75 100 5% 10% 15% 20% 25% In the above spreadsheet, create a formula in cell D4 that uses the VLOOKUP function with the table array $F$4:$G$8. The formula will determine the applicable discount for each paper type order. You should be able to autofill this formula down through cells D4:D8.

COMPREHENSIVE MICROSOFT OFFICE 365 EXCE

1st Edition

ISBN:9780357392676

Author:FREUND, Steven

Publisher:FREUND, Steven

Chapter5: Working With Multiple Worksheets And Workbooks

Section: Chapter Questions

Problem 4AYK

See similar textbooks

Similar questions

Query Board Python or Java(Preferred Python please) Thank you! Programming challenge description: There is a board (matrix). Every cell of the board contains one integer, which is 0 initially.The following operations can be applied to the Query Board:SetRow i x: change all values in the cells on row "i" to value "x".SetCol j x: change all values in the cells on column "j" to value "x".QueryRow i: output the sum of values on row "i".QueryCol j: output the sum of values on column "j".The board's dimensions are 256x256."i" and "j" are integers from 0 to 255."x" is an integer from 0 to 31. Input: Your program should read lines from standard input. Each line contains one of the above operations. Output: For each query, output the result of the query. Test 1 Test InputDownload Test 1 Input SetCol 32 20 SetRow 15 7 SetRow 16 31 QueryCol 32 SetCol 2 14 QueryRow 10 Expected OutputDownload Test 1 Input 5118 34
Here you are required to draw a bar chart of batchwise strength of Avionics Department with following features through python: Add suitable label in the x axis, y axis and a title. Display a horizontal bar chart. Display a vertical bar chart. Use different color for each bar. Attach a text label above each bar displaying its strength (number of students). You are given two lists/arrays: Batch = [Ave-01, Ave-02, Ave-03, Ave-04, Ave-05, Ave-06] Num_Students = [29,50,35,45,50,40]
Only Typing answer In this task you are asked to construct a table showing the sequence of numbersfrom 0 to a maximum value as specified by the user. Within the table, if the number in the cell is a highlighted (e.g., blue in thescreenshot below) when it is divisible by a number that is also specifiedbytheuser, known as the divisor. For example, the user could input for the maximumavalue of 100 and for the divisor a value of 23; this should result in the cellscontaining the values: 0, 23, 46, 69 and 92; being highlighted.
Simple Student Management System Build the following app using Python Tkinter library. Using this app, user can • add student information • view all students • search student(s) by name • remove student by id Add • First name, last name, date of birth cannot be blank while adding a specific student information. • However major can be blank, which gets set to "Undefined" if left out blank. • Student Id is automatically generated by the program (ex: 1001, 1002, 1003, 1004 ….) If the user keeps a mandatory field blank (ex: First name) and presses "Add Student" button, it displays the following message box: first name is required If the user successfully enters all the necessary information and presses the "Add Student" button, it displays the following confirmation message box: student added View All When the user presses the "View All" button, it displays all the student’s information (Id, First name, Last name, Date of birth, and Major) in a nice formatted way. Example below: • Must…
A businessman flight landed in Duncwich, England. He has a meeting in some city.Write a program and ask him at which city he want to reach and show him paththrough following searches1. Depth first search2. Depth limited search3. iterative deepening searchNote: Implement Depth first search using recursive method in python languageFor depth limited search, you can limit the level by your own choiceimplement graphical user interface as well
(java programming language) Write a program to read and store four student’s 21SP registered course and their grade point, sortthem into an order their 21SP registered course, based on grade point from the smallest to the largest,then print them out. The student’s 21SP registered course and their grade point values should be typedin by the user in response to a prompt message. Save the file as SortCourse_yourID.java
An array may contain multiple duplicate values, as shown below. In order to design an algorithm with the best average performance to remove all duplicate values, which of the following data structures should be used? 110, 1100, s, 10, s6, s, 96, 34, s, 34, 20, 110, 30 Question 16 options: hash table stack list priority queue
(ms excel In Moray, employees have Wednesdays and Thursdays off, and the following holidays: January 1, February 12, April 5, May 4, July 21, October 10-12, December 24-26. Design a spreadsheet in which the user can enter start and end dates, and the worksheet returns the total number of working days? Your spreadsheet should work for end dates entered up to and including December 31, 2030. Use formulas to generate the dates of the holidays. The result should be blank if no dates are entered.
The accompanying Homeownership spreadsheet contains a partially completed spreadsheet model for computing the monthly costs of home ownership. Complete the spreadsheet model by inserting the formulas for monthly mortgage payment, monthly property tax, monthly homeowner insurance premium, monthly maintenance costs , and total in the appropriate cells. Variables: House value: $ 450,000.00 Interest rate: 4.25% Down payment (% of house value): 20% Number of years: 30 Property tax rate: 1.25% Annual homeowner insurance premium: $ 1,400.00 Maintenance cost rate (% of house value): 1% Monthly Cost of Home Ownership Monthly mortgage payment: Monthly property tax: Monthly homeower insurance premium: Monthly maintenance costs: Total: 1. Is this a deterministic or stochastic model? 2. Which of the following is NOT an input of the spreadsheet model? A. Interest rate B. Monthly mortgage payment C. Number of years of…
The PHP instruction: $name = $ REQUEST ["name"]; $surname = $_REQUEST ["sumame"]; echo "Welcome $name $surname, please visit the website!" (a) each parameter of the form becomes a field of the associative array $_REQUEST (b) it is correct only if the parameters are passed from the HTML form to the PHP program through POST (c) none of the answers are correct (d) it is correct only if the parameters are passed from the HTML form to the PHP program through GET
This is a PHP code that generates a random number. It's supposed to check if my database already has that number generated. If it does, it generates another number. Else it stops. I am having difficulty figuring the errors out. <?php $CRN = rand(1000000, 9999999); $result = $pdo->query('SELECT * FROM class'); while($row = $result->fetch(PDO::FETCH_ASSOC)) { if($row["CRN"] == $CRN) { generate($pdo); } else echo $row["CRN"]; function generate($pdo) { $CRN = rand(1000000, 9999999); determine($pdo, $CRN); } function determine($pdo, $CRN) { $result = $pdo->query('SELECT *, count(CRN) FROM class WHERE CRN = '.$CRN); while($row = $result->fetch(PDO::FETCH_ASSOC)) {…
In java Write a simple program that will generate a well-formatted addition table. Prompt the user to enter a lower bound and an upper bound for the table. Then print the table with row headers, column headers, and a “+” in the upper left corner. Allow 6 spaces for printing the numeric value For example: Enter the lower bound: -2 Enter the upper bound: 3 +| -2| -1| 0| 1| 2| 3| ------|------|------|------|------|------|------| -2| -4| -3| -2| -1| 0| 1| ------|------|------|------|------|------|------| -1| -3| -2| -1| 0| 1| 2| ------|------|------|------|------|------|------| 0| -2| -1| 0| 1| 2| 3| ------|------|------|------|------|------|------| 1| -1| 0| 1| 2| 3| 4| ------|------|------|------|------|------|------| 2| 0| 1| 2| 3| 4| 5| ------|------|------|------|------|------|------| 3| 1| 2| 3| 4| 5|…