HUMR 2202 Lecture Notes - Dialog Box, Doubleclick, Microsoft Powerpoint

54 views3 pages

tealtrout573

14 Apr 2014

School

Department

Course

Professor

For unlimited access to Class Notes, a Class+ subscription is required.

Document Summary

Also you can drag the right column boundary as in the example. Format cells: every cell can have several formats in excel, the most common type for a cell are: Format cells dialog: right click on a cell then select the format cell option, this dialog box allows you to change the formatting of any selected cell. Cell borders: you might want to eventually print your worksheet, if you don"t put any cell borders, all you will see is the content of the cells (numbers, text, etc). Adding cell borders: you can add many different types of cell borders by clicking the borders button in the. Home tab: simply click on the cell or cells that you wish to add a border to, then apply any border type, if you want more option, use format cell dialog, border tab (as we showed before)

Related Questions

Practice using EXCEL â Part of your Orientation Assignment toprepare for class on the first day.

Step by Step instructions on completing PR1-5B.

BEFORE STARTING TO WORK THE PROBLEM YOU NEED TO WRITEALL BALANCE FORMULAS.

To do so do the following in order.

Click on Cell D39. In D39 you will write a formula to add rowsD37 and D38. To do so do the following:

a) Start in Cell D39and press = sign

b) Highlight cellD37 by using your mouse to click on it or use the arrow keys tomove to that cell. When you do this you should see in D39 =D37

c) Now pressthe + sign then click on D38 or move with the arrows to cell D38.At this time, you should now see in cell D39 the formula=D37+D38

d) Now press theenter key.

e) Now you shouldsee an amount like 60,000 with a red star. DO NOT worry about thatred star right now.

f) Toverify you have written the formula correct press the F2 key. Whenyou do it should display the formula =D37+D38. Press the enter keyto return to display the amount. Note: when you do this the cellsD37 and D38 are highlighted in different colors that match thecolors of the font type for each cell.

g) Now you are readyto copy and paste this formula down column D to the BALANCE rowswhich are the odd numbered rows, in other words the formula goes toEVERY OTHER ROW not to all rows.

h) To copy theformula to memory, hold down the control key and press the C keyand then release the keys. You should now see a flashing black boxaround D39. This indicates to you that the cell D39 is in memoryand can now be pasted into the other odd number cells in columnD.

i) Nowarrow down two rows with the down arrow key. You should see thegreen box around D41 at this point.

j) Nowpaste by holding down the control key and press the letter V asthis will then paste the formula into cell D41.

k) Repeat thisprocess by arrowing down twice and then pressing control and V,release, then arrow down twice more, press control and V, release,arrow down etc until you have pasted the formula to every other rowin column D. Make sure those rows are only the BALANCE rows and arethe odd numbered cells.

l) Whenyou finish doing this you should see an amount like 60,000 with ared star in all the odd numbers rows in column D.

m) You now need to verifythat you did this correct. To do so hold down the control key andpress the ~ symbol then release all keys. The ~ key is on the toprow to the left of the number 1 key. At this point you should seenothing but formulas similar to the formula in D39 EXCEPT the rownumbers should have changed. For example, in D59 you should see theformula = D57+D58 where as in D45 you should see =D43+D44. Then toget back to the amount display press down and hold the control keyand press the ~ key.

n) Now you can copythe entire column D âGRAY BOXES with those formulas from column Dto all the other columns. To do so first highlight the entire grayboxes in row D from D38 to D59. Use your mouse to highlight ORclick on cell D38, hold down the shift key, use the down arrow tohighlight all the way down from D38 to D59.

o) Once highlightedyou will copy this column by pressing control and the letter C. Youshould see the flashing border box all around D38 to D59 and onlythose cells. Make sure you do not have any blue cells highlighted,just gray cell.

p) Now click on G38or use the right arrow key to move to G38 which now has the greensolid box outlined around G38.

q) Now press thecontrol key and letter V at the same time to paste the formulas.When you do you should now see an amount like 80,000 on the balancerows in Column G.

r) Repeat theabove step to columns J, M, P, S, V, Y, AB, AE, AH, HK, AN, AN andAT. DO NOT STOP before you get to column AT. If you lose theflashing box around column D, just highlight again and copy usingcontrol and the letter C.. In several columns you will see noamounts but rather a â instead. This simply means the balance is 0at this time.

s) Now verifythat you did a great job copying and pasting the formulas by againholding down the control key and press the symbol ~ to reveal allthe formulas. Press them again, and the display toggles back to theamounts and dashes.

This copy and pasting of the formulas will save you hours oftimes writing them over and over.

This is the end to the Excel Practice Exercise to get familiarwith Excel. SAVE this work, you will need to use it in Chapter 1homework.

pearfish268

You are an account manager for Inland Jewelers, a regional company that makes custom class rings for graduating seniors. Your supervisor requested a workbook to report on new accounts created on payment plans. The report should provide details on total costs to the student as well as payment information. Each ring financed has a base price that can fluctuate based on ring personalization.

Insert Current Date

You open the starting workbook you previously created, and insert the current date and time.

Open the e02c1ClassRing workbook, and then save it as e02c1ClassRing_LastFirst.

Insert a function in cell B2 to display the current date and format as a Long Date.

Set column Bâs width to Autofit.

Calculate Cost

You are ready to calculate the cost of each class ring ordered. The rings are priced based on their base metal as displayed in the range A15:B19.

Insert a lookup function in cell C5 to display the ring cost for the first student.

Copy the function from cell C5 down through C11 to complete column C.

Apply Accounting Number Format to column C.

Determine the Total Due

You will calculate the total due for each studentâs order. The total is the base price of the ring plus an additional charge for personalization if applicable.

Insert an IF function in cell E5 to calculate the total due. If the student has chosen to personalize the ring, there is an additional charge of 5% located in cell B21 that must be applied; if not, the student pays only the base price. Use appropriate relative and absolute cell references.

Copy the function from cell E5 down through E11 to complete column E.

Apply Accounting Number Format to column E.

Calculate the Monthly Payment

Your next step is to calculate the periodic payment for each studentâs account. The payments are based on the years financed in column F and the annual interest rate in cell B22. All accounts are paid on a monthly basis.

Insert the function in cell G5 to calculate the first studentâs monthly payment, using appropriate relative and absolute cell references.

Copy the formula down the column.

Apply Accounting Number Format to column G.

Finalize the Workbook

You perform some basic statistical calculations and finalize the workbook with formatting and page setup options.

Calculate totals in cells C12, E12, and G12.

Apply Accounting Number Format to the cells C12, E12, and G12.

Set 0.3" left and right margins and ensure that the page prints on only one page.

Insert a footer with your name on the left side, the sheet name in the center, and the file name on the right side.

Save and close the workbook. Based on your instructorâs directions, submit e02c1ClassRing_LastFirst.

MUST BE DONE IN EXCEL

Inland Jewelers
Date

Name	Ring Type	Cost	Personalized	Total	Years	Monthly Payment
Dodson	Silver		Yes		1
Jones	Gold		Yes		1
Clarke	Titanium		No		2
Ranger	Platinum		No		3
McKinley	Platinum		Yes		3
Broadnax	Gold		No		2
Burch	Titanium		Yes		3
Totals


Ring Type	Cost
Silver	$400.00
Gold	$550.00
Titanium	$700.00
Platinum	$750.00

Personalizing Surcharge	5%
Interest Rate	3%

crimsonswan942

EX16_XL_CH05_GRADER_CAP_AS - Travel Expenses 1.3

Project Description:

You are the manager of an information technology (IT) team. Your employees go to training workshops and national conferences to keep up-to-date in the field. You created a list of expenses by category for each employee for the last six months. Now you want to subtotal the data to review total costs by employee and then create a PivotTable to look at the data from different perspectives.

Instructions:

For the purpose of grading the project you are required to perform the following tasks:

Step	Instructions	Points Possible
1	Start Excel. Open the downloaded Excel file named exploring_e05_grader_a1_Expenses.xlsx. Save the workbook as exploring_e05_grader_a1_Expenses_LastFirst, replacing LastFirst with your own name.	0.000
2	On the Subtotals worksheet, sort the data by Employee and further sort by Category, both in alphabetical order.	4.000
3	Use the Subtotals feature to insert subtotal rows by Employee to calculate the total expense by employee.	5.000
4	Collapse the Donaldson and Hart sections to show only their totals. Leave the other employees’ individual rows displayed.	5.000
5	Use the Expenses worksheet to create a blank PivotTable on a new worksheet named Summary. Name the PivotTable Categories.	8.000
6	Use the Category and Expense fields, enabling Excel to determine where the fields go in the PivotTable.	5.000
7	Modify the Values field to determine the average expense by category. Change the custom name to Average Expense.	4.000
8	Format the Values field with Accounting number type.	3.000
9	Type Category in cell A3 and change the Grand Totals layout option to On for Rows Only.	5.000
10	Apply Pivot Style Dark 2 and display banded rows. Note, depending upon the version of Office being used, the style name may be Light Blue, Pivot Style Dark 2.	5.000
11	Insert a slicer for the Employee field, change the slicer height to 2 inches and apply the Slicer Style Dark 5. Move the slicer below the PivotTable. Note, depending upon the version of Office being used, the style name may be Light Blue, Slicer Style Dark 5.	5.000
12	Use the Expenses worksheet to create another blank PivotTable on a sheet named Totals. Add the Employee to the Rows and add the Expense field to the Values area. Sort the PivotTable from largest to smallest expense.	10.000
13	Change the name for the Expenses column to Totals and format the field with Accounting number format.	4.000
14	Insert a calculated field to subtract 2659.72 from the Expense field. Format the field with the custom name Above or Below Average and apply Accounting number format to the field.	10.000
15	Set 12.25 width for column B and column C, change the row height of row 3 to 30, and apply word wrap to cell C3.	4.000
16	Create a clustered column PivotChart from the PivotTable. Move the PivotChart to a new sheet named Chart. Hide all field buttons in the PivotChart, if necessary. Note, Mac users, select the range A3:C8 in the PivotTable. On the Insert tab, click Recommended Charts, and then click Clustered Column to make the chart.	10.000
17	Add a chart title above the chart and type Expenses by Employee. Change the chart style to Style 14.	6.000
18	Apply 11 pt font size to the value axis and display vertical axis as Accounting with zero decimal places.	4.000
19	Create a footer on all worksheets with your name in the left section, the sheet name code in the center section, and the file name code in the right section.	3.000
20	Ensure that the worksheets are correctly named and placed in the following order in the workbook: Subtotals, Summary, Chart, Totals, Expenses. Save the workbook. Close the workbook and then exit Excel. Submit the workbook as directed.	0.000
	Total Points	100.000

https://www.dropbox.com/s/m7falnl85tfazl9/Torres%20DaSilva_exploring_e05_grader_a1_Expenses.xlsx?dl=0

bronzeelk977

HUMR 2202 Lecture Notes - Dialog Box, Doubleclick, Microsoft Powerpoint

Document Summary

Get access

Related Documents

BMGT 301 Study Guide - Midterm Guide: Pivot Table, Net Present Value, Lincoln Near-Earth Asteroid Research

COMPSCI 1BA3 Study Guide - Final Guide: Page Layout, File Allocation Table, Sorting

COMPSCI 1BA3 Chapter Notes -Lookup Table, Pivot Table, Page Layout

Related Questions