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
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. MIcrosoft
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.
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:
b. A program that continuously accepts data about text messages until a sentinel value is entered, and displays all the details.
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
- 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: 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_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: 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_forward
- 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)arrow_forwardSuppose a python program mycode.py contains the following main guard. if __name__ == "__main__": # main function executes only if run as a script main() Select all correct answers that apply. Question 9 options: None of these applies This if statement will call the main() function when mycode.py is run directly in VS Code or from the terminal This if statement will not call the main() function when mycode.py is run directly in VS Code or from the terminal This if statement will always call the main() function either mycode.py is imported as a module or run as a single program This if statement will not call the main() function when mycode.py is imported as a module by another program This if statement will call the main() function when mycode.py is imported as a module by another programarrow_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
- (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_forwardWhich of the options is the purpose of the following function: (define (double input-number) (* 2 input-num)) A) consumes a number and produces 2 times the number B) consumes a number and produces 2 times input-number C) consumes 2 and multiplies it by input-number D) consumes and then multiplies by 2 E) consumes input-number and produces it in duplicatearrow_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
- The 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$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_forward(l) Using the COUNTIF function, write a formula in cell E53 to calculate the total number of Small servers rented. Copy the formula across to cells F53 and G53 to compute for Medium & Large servers, respectively. (m) Using the SUMIF function, write a formula in cell E54 to calculate the total number of Small servers rented. Copy the formula across to cells F54 and G54 to compute for Medium & Large servers, respectively. Screenshots are attached I just need to find the formula for cell E53 and E54 thanksarrow_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