COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
1st Edition
ISBN: 9780357392676
Author: FREUND, Steven
Publisher: CENGAGE L
expand_more
expand_more
format_list_bulleted
Concept explainers
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
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
- $1:Many processing controls are the same as output controls, particularly for online real time processing. $2:Control totals are generally processing controls A. Both Statements are trueB. Only the first statement is trueC. Only the second statement is trueD. None of the statements are truearrow_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_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
- 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_forwardAsk the user for the name? Ask the user to input five test scores and calculate the total of the test scores and Average of the test Scores. Using the following 10-point grading scale for the average tests score, display the grade and reward the gift certificate using the formula. Average testscore Grade Gift Certificate formula 90 and above A 120% of average testscore 80–89 B 60% of average testscore 70–79 C 20% of average testscore 60–69 D 0% of average testscore Please display Name of the user, five test scores, total, Average test score, Grade and the Gift Certificate amount based on above user input and calculations. programming language - Pythonarrow_forwardThe client wants pseudocode for calculating students GPA that he believes has bugs in it. Find all logicalerrors in the provided pseudocode and provide the following information in your report:i) The number of logic errors in the provided code.ii) Your client is not a software developer, to help them understand the problem, describe what alogic error is.iii) Which line of code does the logic error occur in.iv) Fix the logic error and provide the fixed code.v) Describe why the code was changed to resolve the logic errorarrow_forward
- The Dash Cell Phone Company charges customers a basic rate of $5 per month to send text messages. Additional rates are as follows: The first 100 messages per month, regardless of message length, are included in the basic bill. An additional three cents are charged for each text message after the 100th message, up to and including 300 messages. An additional two cents are charged for each text message after the 300th message. Federal, state, and local taxes add a total of 14 percent to each bill. Design a flowchart and pseudocode for the following: A program that continuously accepts data about text messages until a sentinel value is entered, and displays details only about customers whose total bill with taxes is over $10.arrow_forwardThe Dash Cell Phone Company charges customers a basic rate of $5 per month to send text messages. Additional rates are as follows: The first 100 messages per month, regardless of message length, are included in the basic bill. An additional three cents are charged for each text message after the 100th message, up to and including 300 messages. An additional two cents are charged for each text message after the 300th message. Federal, state, and local taxes add a total of 14 percent to each bill. Design a flowchart or pseudocode for the following: e. A program that prompts the user for a three-digit area code from which to select bills. Then the program continuously accepts text message data until a sentinel value is entered, and displays data only for messages sent from the specified area code.arrow_forwardThe Dash Cell Phone Company charges customers a basic rate of $5 per month to send text messages. Additional rates are as follows: The first 100 messages per month, regardless of message length, are included in the basic bill. An additional three cents are charged for each text message after the 100th message, up to and including 300 messages. An additional two cents are charged for each text message after the 300th message. Federal, state, and local taxes add a total of 14 percent to each bill. Design a flowchart or pseudocode for the following:a. A program that accepts the following data about one customer's messages: area code (three digits), phone number (seven digits), and number of text messages sent. Display all the data, including the month-end bill both before and after taxes are added.b. A program that continuously accepts data about text messages until a sentinel value is entered, and displays all the details.c. A program that continuously accepts data about text messages…arrow_forward
- The Dash Cell Phone Company charges customers a basic rate of $5 per month to send text messages. Additional rates are as follows: The first 100 messages per month, regardless of message length, are included in the basic bill. An additional three cents are charged for each text message after the 100th message, up to and including 300 messages. An additional two cents are charged for each text message after the 300th message. Federal, state, and local taxes add a total of 14 percent to each bill. Design a flowchart or pseudocode for the following: d. A program that continuously accepts data about text messages until a sentinel value is entered, and displays details only about customers whose total bill with taxes is over $10.e. A program that prompts the user for a three-digit area code from which to select bills. Then the program continuously accepts text message data until a sentinel value is entered, and displays data only for messages sent from the specified area code.arrow_forwardint 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_forward27. Select all options that print:hello-how-are-you a. print(‘hello’, ‘how’, ‘are’, ‘you’) b. print(‘hello’, ‘how’, ‘are’, ‘you’ + ‘-‘ * 4) c. print(‘hello-‘ + ‘how-are-you’) d. print(‘hello’ + ‘-‘ + ‘how’ + ‘-‘ + ‘are’ + ‘you’)arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
COMPREHENSIVE MICROSOFT OFFICE 365 EXCEComputer ScienceISBN:9780357392676Author:FREUND, StevenPublisher:CENGAGE LProgramming Logic & Design ComprehensiveComputer ScienceISBN:9781337669405Author:FARRELLPublisher:Cengage
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
Computer Science
ISBN:9780357392676
Author:FREUND, Steven
Publisher:CENGAGE L
Programming Logic & Design Comprehensive
Computer Science
ISBN:9781337669405
Author:FARRELL
Publisher:Cengage