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)
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
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 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: b. A program that continuously accepts data about text messages until a sentinel value is entered, and displays all the details.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_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: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_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
- Question P find the regular expression for L={vwv:v,w∈{a,b}*,|v|<=4}? .Full explain this question and text typing work only We should answer our question within 2 hours takes more time then we will reduce Rating Dont ignore this line .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_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
- (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_forwardBelow 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_forwardExcel Formula Question - Multiple Choice 1. Which of the following is an example of a properly constructed Excel formula that adds cell B1 to B2 and then multiplies the result by B3. a) =B1+B2*B3 b) =(B1+B2)*B3 c) =(B1+B2*B3) d) =B1+(B2*B3) Explain Please.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
What Are Data Types?; Author: Jabrils;https://www.youtube.com/watch?v=A37-3lflh8I;License: Standard YouTube License, CC-BY
Data Types; Author: CS50;https://www.youtube.com/watch?v=Fc9htmvVZ9U;License: Standard Youtube License