Use java networking sub progrMMNING LAMHUIAGE NTO SOLVE ALL THE QUESTION, Note solve all the question or
Question:
Use java networking sub progrMMNING LAMHUIAGE NTO SOLVE ALL THE QUESTION, Note solve all the question or i rate unhelkpful
Calculate the average MPG for each vehicle.
a. Enter a formula in cell C10 using the AVERAGE function to calculate the average value of C8:C9.
Use only one argument. b. Copy the formula to the appropriate cells for the other vehicles.
c. Excel will detect a possible error with these formulas. Use the SmartTag to ignore the error. Hint: Use
the SmartTag while cells C10:F10 are selected and the error will be ignored for all the selected cells.
6. Calculate the registration fee for each vehicle. a. Enter a formula in cell C13 to look up the registration fee for the first vehicle. Use the vehicle type in cell C4 as the Lookup_value argument. Use the RegistrationFees named range as the Table_array argument. The registration fees are located in column 2 of the data table. Require an exact match. b. Copy the formula to the appropriate cells for the other vehicles.
Step 1 Download start file
A Skills Approach: Excel 2016 Chapter 3: Using Formulas and Functions
2 | Page Challenge Yourself 3.3 Last Updated 3/19/18
7. Determine whether or not you will need a loan for each potential purchase.
a. In cell C15, enter a formula using an IF function to determine if you need a loan. Your available cash is
located on the Data sheet in cell A3. If the price of the car is less than or equal to your available cash,
display "no". If the price of the car is more than your available, cash, display "yes". Use absolute
references where appropriate—you will be copying this formula across the row.
b. Copy the formula to the appropriate cells for the other vehicles.
Complete the following:
1. Using your editor, open the sp_home_txt.html and sp_layout_txt.css files from the html03 > case1 folder. Enter your name and the date in the comment section of each file, and save them as sp_home.html and sp_layout.css respectively.
2. Go to the sp_home.html file in your editor. Within the document head, create links to the sp_base.css, sp_styles.css, and sp_layout.css style sheet files. Study the content and structure of the file and then save your changes to the document.
3. Go to the sp_layout.css file in your editor. Go to the Window and Body Styles section. style rule for the html element that sets the height of the browser window at 100%.
4.style rule for the page body that sets the width to 95% of the browser window ranging
from 640 pixels up to 960 pixels. Horizontally center the page body within the browser window.
Finally, Karen wants to ensure that the height of the page body is always at least as high as the
browser window itself. Set the minimum height of the browser window to 100%. Draw the following directed graph
G = (V, E)
V = { u, v, w, x, y ,z }
E = { (u,v), (v,w), (w,z), (z,v), (v,y), (x,v), (x,x) }
· 2) Visually show each step of the DFS algorithm's execution as done on textbook page 605
· 3) nd visually show a (max) heap using the following numbers as shown on textbook page 152.
Numbers: 3, 2, 8, 23, 10, 14, 7, 20, 1, 5, 13, 6, 1
. style rule to apply the Border Box model to all header, ul, nav, li, and a elements in
the document.
6. Go to the Row Styles section. Karen has placed all elements that should be treated as grid rows
in the row class. For every element of the row class, style rule that expands the element
to cover any floating content within the element. (Hint: Use the technique shown in the tutorial
that employs the after pseudo-element.)
7. Go to the Page Header Styles section. In this section, you will create styles for the content of
the body header. style rule for the logo image within the body header that displays the
image as a block with a width of 70% of the header, floated on the left margin.
8. The header also contains a navigation list that Karen wants to display vertically. style
rule for the nav element within the body header that: a) floats the navigation list on the left,
b) sets the size of the left and right padding to 2%, and c) sets the width of the navigation list
to 30% of the width of the header.
9. The hypertext links in the navigation list should be displayed as blocks. style rule for every a
element in the header navigation list that displays the element as a block with a width of 100%.
10. Go to the Horizontal Navigation List Styles section. Karen has added a second navigation list that
she wants to display horizontally. For all list items within the horizontal navigation list,
style rule that displays the items as blocks with a width of 12.5% floated on the left margin.
11. Go to the Topics Styles section. This section sets the styles for a list of four topics describing what
the company is offering. Karen wants this list to also be displayed horizontally on the page. For
list items within the ul element with the id topics, style rule to: a) display the items as
blocks with a width of 20%, b) float the items on the left margin, and c) set the size of the left
margin space to 0% and the right margin space to 1.5%.
12. Karen wants the topics list to be well away from the left and right edges of the page body. In the
same section, rule that sets the size of the left margin of the first item in the topics list to
7.75% and sets the right margin of the last item to 7.75%.
13. In the same section, rule that displays the image within each list item in the topics list as
a block with a width of 50% and centered within the list item block. (Hint: Set the left and right
margins to auto.)
14. Go to the HR Styles section. The hr element is used to display a horizontal divider between
sections of the page. Add a style rule that sets the width of the hr element to 50%.
15. Go to the Customer Comment Styles section. In this section, you will create style rules for the
customer comments displayed near the bottom of the page. For the ul element with the id
comments, style rule that sets the width to 75% and centers the element by setting the
top/bottom margin to 40 pixels and the left/right margin to auto.
16. Karen wants the list items to appear in two columns on the page. In the same section,
style rule for every list item in the comments list that: a) displays the item as a block with a width
of 50% floated on the left and b) sets the size of the bottom margin to 30 pixels.
17. Every customer comment is accompanied by an image of the student. Karen wants these
images displayed to the left of the comment. style rule to display the image within
each comment list item as a block with a width of 20%, floated on the left, and with a left/right
margin of 5%.
18. style rule for every paragraph nested within a customer list item that floats the
paragraph on the left margin with a width of 70%.
19. Go to the Footer Styles section and style rule that displays the footer only when both
margins are clear of floating objects.
20. Save your changes to the file and then open the sp_home.html file in your browser. Verify that
the layout and appearance of the page elements resemble that shown in Figure 3-66.
Zuul project.Make a copy of your Lab 1 Zuul project folder (e.g., the folder named LastName-zuul1) and save it as LastName-zuul, using your last name, e.g., Smith-zuul.
· Set up a Git repository for your Zuul project by following the instructions Set Up a Repository for a Project. (Start following along at 0:25 in the video since you already have an existing project.)
· In Git, branch called 'zuul2-refactoring' and move onto the branch. You will your work for this lab on this branch, committing after each exercise.git branch zuul2-refactoring git checkout zuul2-refactoring
· Complete Exercises 6e: 8.5, 8.6, 8.7, 8.8, 8.11 .
· After each exercise:
- Test your program. The changes you make in these exercises are refactorings and should not change the behavior of the game. After each step make sure everything still works as it did before.
- Don't forget to document your changes.
- For any changed classes, be sure your name is in the @author list and update the version.
- As you add and update methods make sure each method has a comment header that correctly describes its behavior using javadoc, including @param and @return tags.
- When an exercise is complete, commit your changes in Git with a commit message indicating the exercise you just completed as well as a brief description of the changes you made. For example:git add . git commit -m"Completed exercise 8.5 - extracted method printLocationInfo"
It is critical that you commit after each exercise so that all exercises can be graded. Later exercises change the code from earlier exercises, and the instructor will be able to grade the early exercises by looking back in your commit history.
· When you have completed all the exercises, make sure your branch is clean. (When you do 'git status' it should say "On branch zuul2-refactoring. nothing to commit, working tree clean")Use java networking sub progrMMNING LAMHUIAGE NTO SOLVE ALL THE QUESTION, Note solve all the question or i rate unhelkpful
Calculate the average MPG for each vehicle.
a. Enter a formula in cell C10 using the AVERAGE function to calculate the average value of C8:C9.
Use only one argument. b. Copy the formula to the appropriate cells for the other vehicles.
c. Excel will detect a possible error with these formulas. Use the SmartTag to ignore the error. Hint: Use
the SmartTag while cells C10:F10 are selected and the error will be ignored for all the selected cells.
6. Calculate the registration fee for each vehicle. a. Enter a formula in cell C13 to look up the registration fee for the first vehicle. Use the vehicle type in cell C4 as the Lookup_value argument. Use the RegistrationFees named range as the Table_array argument. The registration fees are located in column 2 of the data table. Require an exact match. b. Copy the formula to the appropriate cells for the other vehicles.
Step 1 Download start file
A Skills Approach: Excel 2016 Chapter 3: Using Formulas and Functions
2 | Page Challenge Yourself 3.3 Last Updated 3/19/18
7. Determine whether or not you will need a loan for each potential purchase.
a. In cell C15, enter a formula using an IF function to determine if you need a loan. Your available cash is
located on the Data sheet in cell A3. If the price of the car is less than or equal to your available cash,
display "no". If the price of the car is more than your available, cash, display "yes". Use absolute
references where appropriate—you will be copying this formula across the row.
b. Copy the formula to the appropriate cells for the other vehicles.
Complete the following:
1. Using your editor, open the sp_home_txt.html and sp_layout_txt.css files from the html03 > case1 folder. Enter your name and the date in the comment section of each file, and save them as sp_home.html and sp_layout.css respectively.
2. Go to the sp_home.html file in your editor. Within the document head, create links to the sp_base.css, sp_styles.css, and sp_layout.css style sheet files. Study the content and structure of the file and then save your changes to the document.
3. Go to the sp_layout.css file in your editor. Go to the Window and Body Styles section. style rule for the html element that sets the height of the browser window at 100%.
4. style rule for the page body that sets the width to 95% of the browser window ranging
from 640 pixels up to 960 pixels. Horizontally center the page body within the browser window.
Finally, Karen wants to ensure that the height of the page body is always at least as high as the
browser window itself. Set the minimum height of the browser window to 100%. Draw the following directed graph
G = (V, E)
V = { u, v, w, x, y ,z }
E = { (u,v), (v,w), (w,z), (z,v), (v,y), (x,v), (x,x) }
· 2) Visually show each step of the DFS algorithm's execution as done on textbook page 605
· 3) nd visually show a (max) heap using the following numbers as shown on textbook page 152.
Numbers: 3, 2, 8, 23, 10, 14, 7, 20, 1, 5, 13, 6, 1
. style rule to apply the Border Box model to all header, ul, nav, li, and a elements in
the document.
6. Go to the Row Styles section. Karen has placed all elements that should be treated as grid rows
in the row class. For every element of the row class, style rule that expands the element
to cover any floating content within the element. (Hint: Use the technique shown in the tutorial
that employs the after pseudo-element.)
7. Go to the Page Header Styles section. In this section, you will create styles for the content of
the body header. style rule for the logo image within the body header that displays the
image as a block with a width of 70% of the header, floated on the left margin.
8. The header also contains a navigation list that Karen wants to display vertically. style
rule for the nav element within the body header that: a) floats the navigation list on the left,
b) sets the size of the left and right padding to 2%, and c) sets the width of the navigation list
to 30% of the width of the header.
9. The hypertext links in the navigation list should be displayed as blocks. style rule for every a
element in the header navigation list that displays the element as a block with a width of 100%.
10. Go to the Horizontal Navigation List Styles section. Karen has added a second navigation list that
she wants to display horizontally. For all list items within the horizontal navigation list,
style rule that displays the items as blocks with a width of 12.5% floated on the left margin.
11. Go to the Topics Styles section. This section sets the styles for a list of four topics describing what
the company is offering. Karen wants this list to also be displayed horizontally on the page. For
list items within the ul element with the id topics, style rule to: a) display the items as
blocks with a width of 20%, b) float the items on the left margin, and c) set the size of the left
margin space to 0% and the right margin space to 1.5%.
12. Karen wants the topics list to be well away from the left and right edges of the page body. In the
same section, rule that sets the size of the left margin of the first item in the topics list to
7.75% and sets the right margin of the last item to 7.75%.
13. In the same section, rule that displays the image within each list item in the topics list as
a block with a width of 50% and centered within the list item block. (Hint: Set the left and right
margins to auto.)
14. Go to the HR Styles section. The hr element is used to display a horizontal divider between
sections of the page. Add a style rule that sets the width of the hr element to 50%.
15. Go to the Customer Comment Styles section. In this section, you will create style rules for the
customer comments displayed near the bottom of the page. For the ul element with the id
comments, style rule that sets the width to 75% and centers the element by setting the
top/bottom margin to 40 pixels and the left/right margin to auto.
16. Karen wants the list items to appear in two columns on the page. In the same section,
style rule for every list item in the comments list that: a) displays the item as a block with a width
of 50% floated on the left and b) sets the size of the bottom margin to 30 pixels.
17. Every customer comment is accompanied by an image of the student. Karen wants these
images displayed to the left of the comment. style rule to display the image within
each comment list item as a block with a width of 20%, floated on the left, and with a left/right
margin of 5%.
18. style rule for every paragraph nested within a customer list item that floats the
paragraph on the left margin with a width of 70%.
19. Go to the Footer Styles section and style rule that displays the footer only when both
margins are clear of floating objects.
20. Save your changes to the file and then open the sp_home.html file in your browser. Verify that
the layout and appearance of the page elements resemble that shown in Figure 3-66.
Zuul project.Make a copy of your Lab 1 Zuul project folder (e.g., the folder named LastName-zuul1) and save it as LastName-zuul, using your last name, e.g., Smith-zuul.
· Set up a Git repository for your Zuul project by following the instructions Set Up a Repository for a Project. (Start following along at 0:25 in the video since you already have an existing project.)
· In Git, branch called 'zuul2-refactoring' and move onto the branch. You will your work for this lab on this branch, committing after each exercise.git branch zuul2-refactoring git checkout zuul2-refactoring
· Complete Exercises 6e: 8.5, 8.6, 8.7, 8.8, 8.11 .
· After each exercise:
- Test your program. The changes you make in these exercises are refactorings and should not change the behavior of the game. After each step make sure everything still works as it did before.
- Don't forget to document your changes.
- For any changed classes, be sure your name is in the @author list and update the version.
- As you add and update methods make sure each method has a comment header that correctly describes its behavior using javadoc, including @param and @return tags.
- When an exercise is complete, commit your changes in Git with a commit message indicating the exercise you just completed as well as a brief description of the changes you made. For example:git add . git commit -m"Completed exercise 8.5 - extracted method printLocationInfo"
It is critical that you commit after each exercise so that all exercises can be graded. Later exercises change the code from earlier exercises, and the instructor will be able to grade the early exercises by looking back in your commit history.
· When you have completed all the exercises, make sure your branch is clean. (When you do 'git status' it should say "On branch zuul2-refactoring. nothing to commit, working tree clean")
An Introduction to Management Science Quantitative Approach to Decision Making
ISBN: 978-1337406529
15th edition
Authors: David R. Anderson, Dennis J. Sweeney, Thomas A. Williams, Jeffrey D. Camm, James J. Cochran