net income for projected sales of 80 , 90 , 100 , 110 , and 120 units at unit prices of $ 4 , $ 5 , $ 6 , $ 7 , and $ 8 . f . Format cells A3 – B8 with a thick box border . g . Format the one-variable data table with themed cell style . Make sure the Initial values , Total Sales , Total Cost and Net Income have an accent color . h . Format the two-variable data table with a themed cell style . Make sure the initial values for the horizontal and vertical have an accent color . i . Add conditional formatting to the one-variable data table . Format the top 10 % with green fill . Format the bottom 10 % with red fill . Save your work ( CTRL + s ) and close . 1 . ============================================== BIS 155 Final Exam Guide ( Music on Demand )
For more course tutorials visit www . uophelp . com
net income for projected sales of 80 , 90 , 100 , 110 , and 120 units at unit prices of $ 4 , $ 5 , $ 6 , $ 7 , and $ 8 . f . Format cells A3 – B8 with a thick box border . g . Format the one-variable data table with themed cell style . Make sure the Initial values , Total Sales , Total Cost and Net Income have an accent color . h . Format the two-variable data table with a themed cell style . Make sure the initial values for the horizontal and vertical have an accent color . i . Add conditional formatting to the one-variable data table . Format the top 10 % with green fill . Format the bottom 10 % with red fill . Save your work ( CTRL + s ) and close . 1 . ============================================== BIS 155 Final Exam Guide ( Music on Demand )
For more course tutorials visit www . uophelp . com
Complete the tasks below using Microsoft Excel . You may refer to your notes , the textbook , or other resources such as the Web You may not get interactive help from any other person , either in person or via email , text messaging , instant messaging , or other communications channels . I strongly recommend that you save your work frequently . You have 4 hours to complete this exam . Note : Be sure to spell check on every worksheet and correct all spelling errors . Getting started Open Excel ( either on your desktop or in Citrix ) If you are using Citrix , you need to upload the spreadsheet to your virtual drive before you can open it in Excel Open the Practical Exam spreadsheet you downloaded from the course Exam page . Save the spreadsheet as LastnameFirstInitial Week8 FinalExam . xlsx . ( i . e ., if your name were Jane Doe , your file name would be : DoeJ Week8 FinalExam . xlsx )