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.
_____________ ______________ _____________ _____________
Look 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+z
(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
thanks
Knowledge Booster
Similar questions
- The 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_forwardConstruct 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_forward/* * * [a,b] - represents a problem state with a gallons in the 4-gallon jug * and b gallons in the 3-gallon jug */ %% You can fill the 4 gallon jug from the faucet, taking you from a%% problem state [X,Y] to a problem state [4,Y],%% provided X < 4.move([X,Y],'Top off 4-gallon jug from faucet',[4,Y]) :- X<4.%%%%2. Rule corresponding to the move 'Top off 3-gallon jug from faucet'move([X,Y],'Top off 3-gallon jug from faucet',[X,3]) :- Y<3.%%%3. Rule corresponding to the move 'Empty 4-gallon jug onto the ground' %%%4. Rule corresponding to the move 'Empty 3-gallon jug onto the ground'%% 5. Rule corresponding to the move 'Top off 4-gallon jug from 3-gallon% jug'%% 6. Rule corresponding to the move 'Top off 3-gallon jug from 4-gallon% jug'%%7. Rule corresponding to the move 'Empty 3-gallon jug into 4-gallon jug'%%8. Rule corresponding to the move 'Empty 4-gallon jug into 3-gallon jug' %%%%solution predicates% To solve the problem try this: length(X, Y), Y < 10, solution([0,0],…arrow_forward
- The singaporean bus has 7 rows (lettered from A to G) with 8 seats each row(numbered 1 through 8) Write a C++ program that allows users to enter a row and seat request until a sentinel value (both 0 values) is entered. If the row or seat number is invalid, issue an error message. Otherwise, determine whether the seat has already been reserved. If so, display an error message; if not, charge the user Php450.00 for a ticket and display a total of the user’s purchase. Accept continuous seat numbers until the user enters the sentinel value. When the user enters a sentinel, display the number of seats taken and the number of available seats in the bus. Use file streaming so that when the program terminates, the information is saved.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_forwardv2 Question 6 What situation calls for a switch statement? Group of answer choices Use a switch statement when the switch statement is inside the main program. Use a switch statement when a for statement can not be used. Use a switch statement when a selection is in a repitition statement. Use a switch statement when a single control value determines which of several possible actions is to be taken. Use a switch statement when a selection is outside of repitition statement.arrow_forward
- A 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_forwardOrders for a stock trading system are coded as follows from left to right:1. The first character is 'B' for a "buy" order, 'S' for a "sell" order2. The number of shares to buy or sell3. The stock ticker symbol in all uppercase letters for a "buy" order or all lowercase letters for a "sell" order4. If the order is a "limit" order with a specific buy/sell price, the requested price is in pennies, otherwise the price should be omitted and the order will be a market order at the current asking price for the stock5. If the order is a "limit" order with an expiration time, the character 'T' followed by the number of minutes until the order expires should no longer be executedNote that the order code may only contain letters and numbers. (No comma, hyphen, etc)What would the code be to sell 8000 shares of Veteran Technology Solutions stock (ticker symbol: VTS) at the current market price?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
- Upon reaching 30 degrees Celsius, a cooling fan is connected to a relay module (pin # 2), and it must be turned on manually until the temperature (pin A0) reading reaches 25 degrees Celsius, at which point it must be automatically turned off. Complete the code in the following section to ensure that the program is correct. Assume you are able to obtain a temperature reading using the analogRead function (pin number).Complete the code: int highCelsius = 30;int lowCelsius = 25;int relaySwitch = 2;int reading = //will be get from A0if( ){}else if( ){}arrow_forwardTHIS 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
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- COMPREHENSIVE MICROSOFT OFFICE 365 EXCEComputer ScienceISBN:9780357392676Author:FREUND, StevenPublisher:CENGAGE LEBK JAVA PROGRAMMINGComputer ScienceISBN:9781337671385Author:FARRELLPublisher:CENGAGE LEARNING - CONSIGNMENTProgramming Logic & Design ComprehensiveComputer ScienceISBN:9781337669405Author:FARRELLPublisher:Cengage
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
Computer Science
ISBN:9780357392676
Author:FREUND, Steven
Publisher:CENGAGE L
EBK JAVA PROGRAMMING
Computer Science
ISBN:9781337671385
Author:FARRELL
Publisher:CENGAGE LEARNING - CONSIGNMENT
Programming Logic & Design Comprehensive
Computer Science
ISBN:9781337669405
Author:FARRELL
Publisher:Cengage