COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
1st Edition
ISBN: 9780357392676
Author: FREUND, Steven
Publisher: CENGAGE L
expand_more
expand_more
format_list_bulleted
Question
error_outline
This textbook solution is under construction.
Students have asked these similar questions
Instructions Part 1: For each of the following logical tests, indicate whether an IF function in Excelwould return a value of True or False; given the following cell values: C2 = 41; H12 = 13; L3 = 32;M14 = 125; and G4 = 2.1. C2 , H12 Returned value: _______________________2. L3 5 G4 Returned value: _______________________3. M14 1 15 * H12 / 10 ,5 L3 Returned value: _______________________4. M14 1 G4 < H12 / C2 Returned value: _______________________5. (C2 1 H12) * 2 .5 L3 – (L3 / 4) * 2 Returned value: _______________________6. L3 1 300 . H12 * G4 1 10 Returned value: _______________________7. G4 * M14 .5 2 * (M14 2 25) Returned value: _______________________8. H12 5 10 * (C2 1 8) Returned value: _______________________
Instructions Part 2: Write cell L23 as a relative reference, absolute reference, mixed reference withthe column varying, and mixed reference with the row varying.
_____________ ______________ _____________ _____________
Construct an excel expression that determines the average of the values in cell A5, C16 and cell range B3 to B20
A: =average(A5,C16,B3:B20)
B: =average(A5:C16:B3:B20)
C: =average(A5,C16,B3,B20)
D: =average(A5:C16,B3:B20)
I needed help writing the code using visual basic not jave thank you.
An Internet service provider has three different subscription packages for its customers: Package A: For $9.95 per month 10 hours of access are provided. Additional hours are $2.00 per hour. Package B: For $13.95 per month 20 hours of access are provided. Additional hours are $1.00 per hour. Package C: For $19.95 per month unlimited access is provided. Write a program that calculates a customer’s monthly bill. It should ask the user to enter the letter of the package the customer has purchased (A, B, or C) and the number of hours that were used. It should then display the total charges.
Knowledge Booster
Similar questions
- How to use a flowgorithm program to solve the practice problem? Calculate a person’s mobile phone bill based on plan chosen and the data used. The program should perform the following: Ask for customer’s mobile plan Ask for the number of gigabytes of data used Display an error message if the plan choice is invalid or the gigabytes used is less than zero (0) Here are the plans: Plan 1: 19.99/month, with 4 gigabytes data, additional data $10/gigabyte Plan 2: 29.99/month, with 8 gigabytes data, additional data $5/gigabyte Plan 3: 39.99/month, unlimited dataarrow_forwardThe University has to shortlist the students for M.Tech programme with scholarship. The candidates will be shortlisted those have done ‘B.Tech’ prior to this, job experience of 2+ years in academics and who have qualified ‘GATE’ exam. Those satisfy all the conditions they will get message Congratulations’, those lack in experience the message they will get ‘apply next time’, others will get message ‘rejected’. Write function call to pass the three above mentioned inputs as arguments with values and functionwill display the applicable message using suitable conditional statements and execute the above code for at-least 10 candidates. This question should be done using PYTHON Programming language.arrow_forwardYou are given a C++ program (Test2Q1.cpp) with 10 errors (syntax errors and/ or logicalerrors, if any). The program is developed to determine the optimization level of apartmentdesign built-up area. It has five (5) user-defined functions as listed below: Study how all of the above functions were used/called inside the main function of the program.You are required to debug the errors, compile, and run the program. You are NOT ALLOWEDto remove any statements in the program. You are only allowed to update the statementsprovided in the program and add a new statement(s) if absolutely necessary.Figure 1 is the source code of the program and Table 1 is the 3 (three) test cases that you canuse to test the program to know if you have completely and correctly solved all the bugs. 123456789101112131415161718192021222324252627282930313233343536373839404142 #include <iostream>#include <string>#include <cctype>// Max and min of built-up area (square feet)#define MAX_AREA…arrow_forward
- int xy=3;if (xy==2) xy=0;else if (xy==3); xy++;else xy=xy+2;What is the value of xy? Select one: a. invalid b. 2 c. 4 d. 0 It is the first company where the drag and drop programming interface was developed. Select one: a. Oracle Corporaion b. Tripod c. IBM d. MIcrosoftarrow_forwardPlease explain the codes below in details: % request the user to input the desired option with regard the unit % if the user input is ‘MKS’, then the units will be in meters and seconds % If the user input is ‘FPS’, then the units will be in feet and seconds unit = input("Please choose a unit: MKS (meters and seconds) or FPS (feet and seconds): ", "s"); % conditional statements enable you to select at run time which block of code to execute % in the situation where the user has input “MKS” if (unit == "MKS" || unit == "mks") % gravity is equivalent to -9.81 gravity = -9.81; % in the situation where the user has input “FPS” elseif (unit == "FPS" || unit == "fps") % gravity is equivalent to -32.174 gravity = -32.174; else % in the situation where the user has input none of the provided options error = " Please enter an input only within the provided options "; % disp( ) displays the value of variable without printing the variable name % display error disp(error) % return control to the…arrow_forwardLook at the code below and provide testcases for 100% statement, branch and condition coverage- Give 10 test cases ref to Facebook functionality by solving above problems. def compute(x,y,z): if (x>2 or y >0) and z=1): x+y-z else: x-y+zarrow_forward
- THIS PROGRAM MUST BE WRITTEN IN C++! Your customer needs an automated system to patrol the highways. The job of the system is to collect the following information on vehicles traveling down a certain stretch of highway: license plate number, current speed, and speed limit. A program is required to determine if a speeding ticket is needed for each set of data. Ticket will only be issued when number of miles per hours (mph) over the speed limit is at least 5 mph. Ticket prices are calculated as follow: base + fee * <number of mph over the speed limit>. The base is always $150 and the fee per mph over the speed limit is varied according to number of mph over the speed limit. The fee per mph over the speed limit is $5 when number of mph over the speed limit is no more than 20 mph. However, the fee per mph over the speed limit is $10 when number of mph over the speed limit is between 20 mph and 50 mph. In addition, a ticket of $1000 is automatically given to vehicle when number of mph…arrow_forward(c) Compute the percent decline or increase in the mobile website visitors, write a formula in cell E26 and copy to cell E27. (d) In cell F26, Use the IF Function to create a formula to print "Yes" if there is cannibalization; else, the formula should print "No". Copy the formula to cell F27.Hint: If the percent increase is negative then there is cannibalization, else there is no cannibalization. Screenshot is attached below thx!!arrow_forward(d) Using the IF function, write a formula in J6 to display "Yes" if the activity is critical and display "No" if the activity is not critical. Copy the formula to cells J7:J14. Screen shot attached thanksarrow_forward
- Below are two basic blocks of code. Variables used include w, x, y, and z. For each block, determine which variables local to the block are live and which are dead as the statements execute (this is not global liveness analysis). 1. x = 3; y = 4; z = 5; 2. x = y + z; y = x * z;arrow_forwardIf you reject H0 when H0 is correct, what type of error is this? Question 15 options: a Type I b Type II c No Errorarrow_forwardA statement in VB that provides an alternative to IF THEN ELSE for selective block statement. Select one: a. all of the choices b. Select Case Statement c. Case Statement d. Switch Statement What is the standard prefix used for radio button? Select one: a. all of the choices b. opt c. rdb d. rdoarrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- COMPREHENSIVE MICROSOFT OFFICE 365 EXCEComputer ScienceISBN:9780357392676Author:FREUND, StevenPublisher:CENGAGE L
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
Computer Science
ISBN:9780357392676
Author:FREUND, Steven
Publisher:CENGAGE L