42. Which code below can replace the missing code to select data that is less than the targetValue and even? Assume all variables have been properly initialized. IF < missing code > { DISPLAY ("Found it!") } (A) (num MOD 2=0) OR (targetValue num) AND (targetValue MOD 2=0) (C) (num MOD 2 = 0) AND (targetValue> num) (D) (targetValue> num) OR (NOT(num MOD 2 > 0)) 43. Which type(s) of statement is needed to find all records in a list that are positive? (A) Sequential and iterative (B) Selection and sequential (C) Selection (D) Iterative and selection 44. Grace and Ada write algorithms and test them with increasingly large datasets. Algorithm 1 is still run- ning while algorithm 2 completed before midnight. What can you determine about the algorithms? (A) One has an exponential efficiency and two has a polynomial efficiency. (B) One has a polynomial efficiency and two has an exponential efficiency. Q(C) +ne is unsolvable and two is decidable. (D) One is decidable and two is unsolvable.

42. Which code below can replace the missing code to select data that is less than the targetValue and even? Assume all variables have been properly initialized. IF < missing code > { DISPLAY ("Found it!") } (A) (num MOD 2=0) OR (targetValue num) AND (targetValue MOD 2=0) (C) (num MOD 2 = 0) AND (targetValue> num) (D) (targetValue> num) OR (NOT(num MOD 2 > 0)) 43. Which type(s) of statement is needed to find all records in a list that are positive? (A) Sequential and iterative (B) Selection and sequential (C) Selection (D) Iterative and selection 44. Grace and Ada write algorithms and test them with increasingly large datasets. Algorithm 1 is still run- ning while algorithm 2 completed before midnight. What can you determine about the algorithms? (A) One has an exponential efficiency and two has a polynomial efficiency. (B) One has a polynomial efficiency and two has an exponential efficiency. Q(C) +ne is unsolvable and two is decidable. (D) One is decidable and two is unsolvable.

COMPREHENSIVE MICROSOFT OFFICE 365 EXCE

1st Edition

ISBN:9780357392676

Author:FREUND, Steven

Publisher:FREUND, Steven

Chapter5: Working With Multiple Worksheets And Workbooks

Section: Chapter Questions

Problem 4AYK

See similar textbooks

Similar questions

Analyze the following code:int matrix[5][5];for (int column = 0; column < 5; column++);matrix[4][column] = 10; Select the correct option: After the loop, the last row of matrix 10, 10, 10, 10, 10. After the loop, the last row of matrix 0, 0, 0, 0, 0. A syntax error, because column is not defined. After the loop, the last column of matrix 10, 10, 10, 10, 10. After the loop, the last row of matrix 0, 0, 0, 0, 10.
Each of the following files in the Chapter.05 folder of your downloadable student files has syntax and/or logical errors. In each case, determine the problem, and fix the program. After you correct the errors, save each file using the same filename preceded with Fixed. For example, save DebugFive1.cs as FixedDebugFive1 .cs. a. DebugFive1.cs b. DebugFive2.cs c. DebugFive3.cs d. DebugFive4.cs
Each of the following files in the Chapter.06 folder of your downloadable student files has syntax and/or logical errors. In each case, determine the problem, and fix the program. After you correct the errors, save each file using the same filename preceded with Fixed. For example, DebugSix01.cs will become FixedDebugSix01.cs. a. DebugSix01.cs b. DebugSix02.cs c. DebugSix03.cs d. DebugSix04.cs
Which of the following statement(s) are true for the above code? Group of answer choices the code allocates space for a local variable and a global array the code allocates space for a local variable and a local array The code utilizes the index register the code utilizes the stack pointer the code uses 5 different addressing modes
I need help with the last part of this code : print("Davy's auto shop services")print("Oil change -- $35")print("Tire rotation -- $19")print("Car wash -- $7")print("Car wax -- $12")print()service1=input("Select first service:")print()service2=input("Select second service:")print() dic={"Oil change":"35","Tire rotation":"19","Car wash":"7","Car wax":"12"}total = 0print() print("Davy's auto shop invoice")print()for key,value in dic.items(): if(service1 == key): print("Service 1:",key+str(", $")+dic[key]) total = total + int(dic[key]) if(service2 == key): print("Service 2:",key+str(", $")+dic[key]) total = total + int(dic[key])if(service1 == "-"): print("Service 1:", "No service")if(service2 == "-"): print("Service 2:", "No service")print()print("Total: $"+str(total)) Error : Davy's auto shop services Oil change -- $35 Tire rotation -- $19 Car wash -- $7 Car wax -- $12 Select first service: Select second service: Davy's auto shop invoice Service…
Compare userNumber with compareNumber and display 'Numbers are not equal' if the numbers are different. Then, display 'Variables are not identical' if the variables are not identical (not strictly equal). let compareNumber = 3; // Code will be tested with: 3, 8, 42let userNumber = '3'; // Code will be tested with: '3', 8, 'Hi'
In Dist.txt it will add vaccine in storage like how many vaccines are needed and from where is coming and Add search function in which from user it will check how many vaccines are available in storage this will be done in Vaccine.txt somewhat like in image given #include <stdio.h>#include <stdlib.h>#include <string.h> struct vacc{ char vaccName[15]; char vaccCode[2]; char country[15]; int qty; float population; }v[10]; // Function Declarations void create_inventory(); void update_vacc_qty(); int search_vaccine(); void display_vaccine(); // Main Function starts here int main() { //create_inventory(); //display_vaccine(); //search_vaccine(); update_vacc_qty(); return 0; } //Function to Create Vaccine.txt as per the given table void create_inventory() { int option = 1; // variables to collect data as per table given char vaccName[15]; char vaccCode[2]; char country[15]; int qty; float populaion; //File definition FILE *infile; infile = fopen("Vaccine.txt","w");…
Fix the following m file: Submit fixed m file and histogram jpg created % Compute the average of some temperature data % Then plot the data in a MATLAB plot window % clc;clear n = 50; % number measurements temps = floor(50*rand(1,n))+50; time = 0:1:50; average = sum(temp)/length(temps); plot(time,temps) title('Temperature Measurements','fontsize',18,) xlabel('Time in minutes') ylabel('Temperature in degrees F') disp(averag)
new code can only be entered betwen grey blocks (ie, 17 - 19).
Which of the following is true? String data can be stored in a field defined as numeric Numeric data can be stored in a string data type String data and numeric data can be stored in any of the string or numeric data types without limitation An advantage of storing numeric data as a string is that it makes it easier to sort and calculate means and other statistics The format for date date types in Alteryx is MM-DD-YYYY True False
A. You have retrieved the query string "phone=%28802%29%20555-4781" and saved it in the variable phoneField. Which statement can you use to convert the string value of this variable to "phone=(802) 555-4781"? a. phoneField = phoneField.split(/&/g); b. phoneField = location.search(phoneField); c. phoneField = phoneField.replace(/\+/g, " "); d. phoneField = decodeURIComponent(phoneField); B. Suppose you need to save a string that contains spaces and punctuation marks to a cookie as a data value. If you have assigned the string to the variable tagLine, what statement should you include in your code before the one creating the cookie? a. document.cookie = "tag line=" + tagLine; b. let tagLine2 = setItem("tag line", tagLine); c. let tagLine2 = encodeURIComponent(tagLine); d. let tagLine2 = decodeURIComponent(tagLine);
Load “Lock5Data” into your R console. Load “OlympicMarathon” data set in“Lock5Data”. This data set contains population of all times to finish the 2008Olympic Men’s Marathon.a. What is the population size?b. Now using “Minutes” column generate a random sample of size 5.c. Calculate the sample mean and record it (create a excel sheet or write adirect R program to record this)d. Continue steps (b) and (c) 10,000 time (that mean you have recorded 10,000sample means)What you have in step (d) is closely resemble to distribution of sample meanswith sample size 5. e. Calculate the mean of 10,000 sample means.f. Calculate the population mean (that mean using all data in “Minutes” column)g. According to the central limit theorem, if conditions satisfied, then the mean ofdistribution of sample mean should be close to the population mean. Nowcompare your results for part (e) and (f). Are they same or at least close toeach other?h. Calculate the standard deviation for 10,000 data points you have…