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.
_____________ ______________ _____________ _____________
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
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)
Knowledge Booster
Similar questions
- The problem consists of two parts, depending on the option entered from the keyboard: • If option a or A; It is requested to calculate the factorials of the 3 integers entered on the keyboard and the sum of the factorials. • If option is c or C; The consecutive sum of 5 integers entered on the keyboard and the sum of the 5 integers entered are required to be calculated. The user can repeat as many programs as they want. After the operations, if the number entered on the keyboard is 0, the program will continue, if the number entered is -1, the program will terminate. As soon as the program ends, "Application Finished!" should be written on the screen. (Consecutive Sum: It is the sum of each number entered on the keyboard with the previous number. For example, if the number entered on the keyboard is 2,5,8,3,4 respectively, the sum of 4 consecutive units should be calculated. 1. consecutive total: 2 + 5 = 7, 2. consecutive sum: 5 + 8 = 13, 3rd consecutive sum: 8 + 3 = 11 and 4th…arrow_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_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
- 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_forwardFollowing is a problem statement. Which of the below is the correct trace table for the problem statement? Peter bought 18 cupcakes for his sons birthday, they cost R4,50 each. Write a program that will accept the input from the user and then calculate the amount due by multiplying the number of cupcakes by the price and then adding 14% VAT to the amount. Display the final amount he owes on the screen. Select one: a. Instruction quantity price amount vat finalAmount Output display Provide the quantity bought enter 18 display Provide the price of 1 item enter 4.50 calculate 81 11.34 92.34 display The final amount due is R92.34 b. Instruction quantity price amount vat finalAmount Output enter 18 enter 4.50 calculate 81…arrow_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_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
- INCHES_TO_CM = 2.54POUNDS_TO_KG = 0.453592def inches_to_cm( inches ):'''Function -- inches_to_cmConverts inches to centimeters and returns (answers) the resultingvalueParameters:inches (float) -- the original distance/height in inchesReturns a float value representing the original vaule convertedto centimeters'''return abs(inches * INCHES_TO_CM) # convert negative distance to positivedef cm_to_inches( centimeters ):'''Function -- cm_to_inchesConverts centimeters to inches and returns (answers) the resultingvalueParameters:centimeters (float) -- the original distance/height in centimetersReturns a float value representing the original vaule convertedto inches'''return abs(centimeters * (1 / INCHES_TO_CM))def pounds_to_kg( pounds ):'''Function -- pounds_to_kgConverts pounds to kilograms and returns (answers) the resultingvalueParameters:pounds (float) -- the original weight in poundsReturns a float value representing the original vaule convertedto kilograms'''return abs(pounds *…arrow_forwardconvert the following codes to assembly language: If (var1 < var2) { var3 = 10;} else if (var1 == var2) { var3 = 6; var4 = 7;} else {var3 = 0; } b) switch (x) { case 50: case 52: result = 20; break; case 53: result = 13; break; case 54: result *= 3; break; default: result += 10; } Var = 3; While(var<=3) Var++; Print ("Sorry you have exceeded 3 trials"); if (al > bl) OR (bl > cl) AX = 1; Write an assembly program to display the largest of three variables. The three variables num1, num2 and num3 have values 89,20 and 56, respectively.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
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