Computers and Technology, 30.11.2021 23:20 Tracic1972
1. Open a new workbook in Excel. 2. Save the file in the C:/Computer Literacy/Student/Unit_4 folder. Save it as Unit_4_Assignment_1_YourName where YourName is your full name. For example, if your name is Ben Smith, the file name would be Unit_4_Assignment_1_BenSmith. 3. Enter the following data in row 1 to create the top headers for your budget: a. Enter January in cell B1. b. Enter February in cell C1. c. Select cells B1 and C1, select the fill handle in the lower-right corner of cell C1, and then extend the selection to cell M1 to fill the range with month names. d. Enter Total in cell N1. 4. Enter the following data in column A to create the left-side headers for your budget. a. Enter Lunch money in cell A2. b. Enter Transportation in cell A3. c. Enter Movie tickets in cell A4. d. Enter Clothes in cell A5. e. Enter Haircut in cell A6. f. Enter Restaurants in cell A7. g. Enter Total in cell A8. 5. Adjust the column widths as necessary so that all text is visible and not overlapping other cells 6. Select the range A1:N1, and apply a border format to the bottom border of the range. 7. Select cell N1, and apply the bold format. 8. Select the range N1:N7, and apply a light green color to the range. 9. Enter an estimate of the cost of each item in your budget for each month of the year. 10. Select the range B2:M7, and apply the Accounting Number format to the selected range. 11. Insert two rows above the current row 1. 12. In cell A1, enter the current date and format it with the 14-Mar-2012 date format. 13. Select cell N4 and enter the following formula: =SUM(B4:M4) 14. Copy the formula in cell N4 to the range N5:N9. 15. Select cell B10 and enter the following formula: =SUM(B4:B9) 16. Select cell B10, then select the fill handle and extend the selection right to M10. 17. Select the range A10:M10, and apply the Total cell style. 18. In cell A12, enter the text Annual Average, and apply bold format. 19. In cell B12, enter the following formula: =AVERAGE(B10:M10) 20. Select the range A4:M9, and sort the data alphabetically a to z
Answers: 1
Another question on Computers and Technology
Computers and Technology, 22.06.2019 09:50
17. implement the jvm dload instruction for the mic-2. it has a 1-byte index and pushes the local variable at this position onto the stack. then it pushes the next higher word onto the stack as well
Answers: 2
Computers and Technology, 23.06.2019 01:20
Write a function balancechemical to balance chemical reactions by solving a linear set of equations. the inputs arguments are: reagents: symbols of reagents in string row array products: symbols of products in string row array elements: elements in the reaction in string row array elcmpreag: elemental composition of reactants in two dimensional numeric array elcmpprdcts: elemental composition of prducts in two dimensional numeric array hint: the first part of the problem is setting up the set of linear equations that should be solve. the second part of the problem is to find the integers from the solution. one way to do this is to mulitiply the rational basis for the nullspace by increasing larger integers until both the left-and right-side integers exist. for example, for the reaction that involves reacting with to produce and : reagents=["ch4", "o2"]; products =["co2", "h2o"]; elements =["c","h", "o"] elcmpreag=[1,4,0;
Answers: 3
Computers and Technology, 23.06.2019 02:00
Arecipients list has been loaded into a document. which commands should be clicked in order to filter the list so that letters will not be printed for recipients who live in a certain state? mailings tab, start mail merge, select recipients, type new list, then insert only contacts from the desired states mailings tab, rules, select recipients, use existing list, then choose a recipients list that includes only contacts in certain states mailings tab, select recipients, use existing list, rules, fill in, then type in certain states mailings tab, rules, skip record select “state” under field name, then type in the state name under “equal to”
Answers: 2
Computers and Technology, 23.06.2019 11:00
How should you specify box sizes on a web page if you want the boxes to vary according to the font size of the text they contain? a. in pixels b. in inches c. as percentages d. in em units
Answers: 2
You know the right answer?
1. Open a new workbook in Excel. 2. Save the file in the C:/Computer Literacy/Student/Unit_4 folder....
Questions
French, 31.03.2021 17:10
Mathematics, 31.03.2021 17:10
Chemistry, 31.03.2021 17:10
Mathematics, 31.03.2021 17:10
Mathematics, 31.03.2021 17:10
Mathematics, 31.03.2021 17:10
Mathematics, 31.03.2021 17:10
World Languages, 31.03.2021 17:10
Mathematics, 31.03.2021 17:10
