jam

excel-assignmentt.xlsx

Home >Mathematics homework help >Statistics homework help >jam

Format Portrait

Excel Assignment - Part 1 - Formatting									Points	Grade
Ø Sequence numbering rows in a spreadsheet is frequently helpful, especially if the rows are sorted for different purposes and then need to be restored to their original sequence. Below are two different approaches to assigning sequence numbers. Use these two different methods to extend the sequence numbers down to row 56. Explain the difference in the cell of the right of this cell.						Enter your Explanation of the two different approaches to sequence numbering here typing over this instruction.			5
seq
1	1	Ø	Center contents of cell I5 vertically.						1
2	2
3	3				Student Name:	center your name			1
4	4				IS312 Section #	center IS312 Section #_____			1
5	5
6	6	Ø	Format Numbers and Dates:
					Format with commas:	15000100200			2
					Format to 5 decimals points:	12.02			2
					Format as currency:	27341.01			2
					Format as percentage:	0.753			2
					Left justify this number:	137			2
					Enter 00507 in I18:
					Question:	What kind of number is 00507 above? Enter your answer here.			2
					How might this format be used in business?	Explain business use for this format here.			2
					Reformat this Date:	February 15, 2017
					Reformat as mm dd, yyyy:				2
					Reformat as yyyy mm dd:				2
					Reformat as Month dd, yyyy:				2
					Reformat as "Timestamp":				2
		Ø	Explicit Calculation & Date Calculations
				Calculate the number of days between Mar 15, 2010 and Sept 15, 2017:
				Put the dates in I30 and I31. Then use relative addressing to calculate the result in cell I33. Show the actual forumla in cell I32.					1
									1
					Formula:	show formula here			2
					Result:	show result here			2
					How does Excel calculate dates?	Put your answer here.			2
					What is the oldest date in Excel?				2
					How did you determine Excel's oldest date?	Put your answer here.			2
		Ø	Cell Format:
				Wrap and center the text in cell I39. >>>		"We hold these truths to be self-evident, that all men are created equal, that they are endowed by their Creator with certain unalienable Rights, that among these are Life, Liberty and the pursuit of Happiness. "			2
				Explain how to insert multiple lines of text in a single cell as shown in K40.		Put your explanation here.	a) b) c)		3
				Explain how to put lines on top of, at the bottom of and around a cell or group of cells		Put your explanation here.			3
				Explain how to center items in a cell as shown in cell K42.		Put your explanation here.	a)		2
				Note:	Add a comment here merging cells H44 and I44.				2
		Ø	Page Layout:
					Add this header to this page:	Yourname Enterprises, Inc. CSUN IS312 Spring 2017			4
					Add this footer to this page:	File Name Page 1 of 1			4
			NOTE: ALWAYS put these headers and footers in your Excel workproduct.
			Format this Tab to print in Portrait mode, adjust scaling so all columns show.						5
			Copy this Tab.						2
			Name the new Tab "Format Landscape".						2
			Format the new tab to print in Landscape with all columns printing on the same sheet of paper.						3
NOTE: Expand cell height as necessary so your entire answer is visible.									1
						0.000000		Total	75	0