Programming with Microsoft Visual Basic 2017
8th Edition
ISBN: 9781337102124
Author: Diane Zak
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Expert Solution & Answer
Chapter 12, Problem 6RQ
Program Description Answer
The statement SELECT State, Capital FROM States WHERE Population > 5000000 retrieves the records whose “Population” exceeds 5,000,000 from the table “States”.
Hence, the correct answer is option “A”.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
The following is a table of applicants to be considered for admission into 07BSAM:
POINTS
MATH
SYMBOL
123
450
NAMES
STUDENT
NUMBER
ENG SYMBOL
To qualify for admission, an applicant should have at least 25 points, minimum of B symbol in
Mathematics and a minimum of E symbol in English. If an applicant has a C symbol in Mathematics,
then the applicant must pass an entrance test to be considered for admission.
Hints:
There are three modes of study: The Full-time mode, the Part-time mode and the Distance mode.
Applicants can choose which mode they want provided there is space in that mode. Each of the Full-
time and the Part-time modes cannot accommodate more 30 admitted students. After these two
modes are full, every other qualified applicant is admitted in the Distance mode. The admission
exercise is first come first served.
Write a pseudocode that identifies the applicants that qualify for admission and outputs their names,
student numbers and modes of study. Use a FOR-LOOP /…
In cell G10, insert a formula using the PMT function using the monthly interest rate (cell G6), the loan period in months (cell G8), and the loan amount (cell G4) to calculate the monthly payment for the 10 Years scenario.
Cell C5 contains a formula that calculates how many days late an assignment was
submitted, based on the dates on C3 and C4. Provide a correct formula for cell C5.
Your formula should work if the dates in C3 and C4 were to change.
Do not include spaces in your answer.
1
2
ольши
3
4
5
6
A
BO
Used Assignment Late Days
Due Date
Date of Submission
Number of Late Days
C
A
2021-02-22
2021-02-25
3
D
Chapter 12 Solutions
Programming with Microsoft Visual Basic 2017
Knowledge Booster
Similar questions
- Cell C5 contains a formula that calculates how many days late an assignment was submitted, based on the dates on C3 and C4. Provide a correct formula for cell C5. Your formula should work if the dates in C3 and C4 were to change. Do not include spaces in your answer. 1 445 WN 3 6 A B Used Assignment Late Days Due Date Date of Submission Number of Late Days C A/ 2021-02-22 2021-02-25 3 Darrow_forwardIn cell F7, create a formula that calculates the salary for Joan Dickinson. Her salary is calculated by adding her base salary (cell B7) to her total bonus (cell E7). (Hint: Do not use the SUM function.) To calculate the salary for all of the employees, copy the formula you created and the formatting in cell F7 into the range F8:F10. Kelly wants to view employees’ bonuses as a percentage of their base salary. In cell G7, enter a formula without using a function that divides Joan’s total bonus (cell E7) by her base salary (cell B7).arrow_forwardr and l values question.arrow_forward
- The Excel function =sin(A1) will calculate the sine of the value in cell A1. The value in cell A1 must be in degrees. True? False?arrow_forwardThe Excel function =sin(A1) will calculate the sine of the value in cell A1. The value in cell A1 must be in degrees. Group of answer choices True Falsearrow_forwardWhich of the following options represent a function that is entered in the highlighted cells to return the total value for a given item (AAA) and size (S)? A B 9 UNIT SOLD Size SOLD Price ($) 10 AAA 45 10 11 BBB M 21 20 12 AAA S 20 65 13 BBB M 41 40 14 15 Item Size TOTAL_Value 16 AAA 1750 a) =SUMPRODUCT((A10:A13=A16),(B10:B13=B16),C10:C13,D10:D13) O b) =SUMPRODUCT((A10:A13=A16)*(B10:B13=B16)+C10:C13,D10:D13) O c) =SUMPRODUCT((A10:A13=A16)*(B10:B13=B16)*C10:C13) d) =SUMPRODUCT((A10:A13=A16)*(B10:B13=B16)*C10:C13,D10:D13)arrow_forward
- 5. Using the Max function, write a formula in cell F7 of Top10_Pivot Sheet to find the maximum "Sum of Percentage" value. Do not select the Grand Total range in the function.6. Using the MATCH function only, write a formula in cell G7 of Top10_Pivot Sheet to find the Row Number of Maximum Sum of percentage.7. Using the INDEX function only, write a formula in cell H7 to find the state name having the maximum "Sum of Percentage". The formula should include the value(row number) that is calculated in G7.arrow_forwardIn cell J2, enter a formula using the COUNTIF function that counts the number of proposed Commercial projects, using ProposedProjects[Project Type] as the range and cell I2 as the criteria. Fill the range J3:J5 with the formula in cell J2. In cell K2, enter a formula using the SUMIF function that totals the funding for proposed Commercial projects, using ProposedProjects[Project Type] as the range, cell I2 as the criteria, and ProposedProjects[Funding] as the sum_range. Fill the range K3:K5 with the formula in cell K2. In cell L2, enter a formula using the AVERAGEIF function that averages the funding for proposed Commercial projects, using ProposedProjects[Project Type] as the range, cell I2 as the criteria, and ProposedProjects[Funding] as the average_range. Fill the range L3:L5 with the formula in cell L2.arrow_forward¥ Question Completion Status: Given a truth table below with the first two columns of truth values provided: b. (p.q) 1 2 T F 4. Which of the answers below contains the truth values for the third column when f(p,q) = p q ? Column 3 Column 3 Column 3 truth values: Column 3 truth Column 3 truth values: truth values: truth values: values: 1 T 1 F 1 F 1 F 1 T None of the other answers O 2 F O 2 T 2 T 2 T provided is correct. 2 F 3 F 3 F 3 T 3 T 3 F 4 T 4 F 4 T 4 F 4 T Save All Answers Save and Su Click Save and Submit to save and subrmit. Click Save All Answers to save all answers. 0 日 la (99+ here to search 3.arrow_forward
- Which of the following is equivalent to WHERE attribute NOT BETWEEN 100 AND 1000? a. WHERE attribute < 100 OR attribute > 1000 b. WHERE attribute >= 100 AND attribute <= 1000 c. WHERE attribute >= 100 OR attribute <= 1000 d. WHERE attribute = 100 OR attribute = 1000arrow_forwardin a shop ,there are 10 employee and 20 kinds of goods,goods id between 1-20 EMPLOYEE id first name last name gender 10001, 'Tom', 'Brown', 'F'10002, 'Elizabeth', 'Tremblay', 'F'10003, 'Gladys', 'Julie', 'F10004, 'John', 'Taylor', 'M10005, 'Amelia', 'Smith'10006, 'Logan', 'Katherine'10007, 'Leo', 'Brown'10007, 'Lem', 'Thompson'10009, 'Tom' 'Smith'10010, 'Emma', 'Campbell' ------------ and I want to add a name library in it ,like this how could i create a HTML file ,with will randomly create customers with these employee . there is a start button on the page . press "start "bottom ,and it will It will randomly match 10 items, customers, and goods, display goods id ,customername and gender ,employer name , id and gender . how to do such a page ?arrow_forwardSample Run 1 Enter the material: metal- Enter the number.of units::700- Cost per metal: 5.00- Shipping cost: 50.00- Total cost::3550.00- Sample Run 2 Enter the material: bricke Enter the number.of units::10- Cost per metal: 1.00- Shipping cost: 20.00- Total cost::30.00- Sample Run 3 Enter the material: paint- Enter the number.of units::100- Error- Sample Run 4 Enter the material: wood- Enter the number.of units:-23- Error- Additional Notes: Regarding your code's standard output, CodeLab will check for case errors and will check whitespace (tabs, spaces, newlines) exactly. O Interactive Session ? O Visible newlines O Visible whitespace O Display stdin O Display stdout wood 278 Cost per wood: 8.00 Shipping cost: 25.00 Total cost: 2249.00arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Programming with Microsoft Visual Basic 2017Computer ScienceISBN:9781337102124Author:Diane ZakPublisher:Cengage LearningCOMPREHENSIVE MICROSOFT OFFICE 365 EXCEComputer ScienceISBN:9780357392676Author:FREUND, StevenPublisher:CENGAGE L
- Np Ms Office 365/Excel 2016 I NtermedComputer ScienceISBN:9781337508841Author:CareyPublisher:Cengage
Programming with Microsoft Visual Basic 2017
Computer Science
ISBN:9781337102124
Author:Diane Zak
Publisher:Cengage Learning
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
Computer Science
ISBN:9780357392676
Author:FREUND, Steven
Publisher:CENGAGE L
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:9781337508841
Author:Carey
Publisher:Cengage