excel

profilegloo1989
XL-Module03.zip
Home>Business & Finance homework help>Accounting homework help>excel

Apply 3-1 Absolute Cell References.xlsx

Sheet1

Writing Formulas with Absolute and Relative Cell References
5 4 3 2
3 9 7 4 2
4 6 5 6 3
6 5 4 5 7

Expand 3-1 Education Indicators.xlsx

Sheet1

Female to Male School Enrollment Figures
Mali 2012 - 2018
2012 2013 2014 2015 2016 2017 2018
Ratio of female to male primary enrollment (%) 62.45 62.291 66.616 65.24 66.35 70.807 70.998
Ratio of girls to boys in primary and secondary education (%) 79.815 81.819 83.164 84.716 85.777 86.189 87.177
Ratio of female to male secondary enrollment (%) 75.563 77.269 78.92 79.361 80.206 81.893 83.018

Extend 3-1 Fill and IF.xlsx

Fill

Using the Fill Handle
7:00 AM Monday Tuesday Tue January Jan 1 Year 1 3 1.60% 0.25 2017 Column A
Thu 2 Year 2 6 4.50% 0.8 2018 Column B
Column C
Column D
Column E
Column F
Column G
Column H
Column I
Column J
Column K
Column L
0 Move Delete

IF

Student Number Grade Pass/Fail ABC/F
200 25
206 64
234 70
240 35
278 26
295 91
300 100
326 35
333 86
374 48
386 79
416 80
430 95
439 99
443 75
444 55
463 89

Lab 3-2 PHM Reliable Catering Weekly Payroll Report.xlsx

Sheet1

PHM Reliable Catering
Weekly Payroll Report
Employee Hire Date Withholding Allowances Rate per Hour Hours Worked Gross Pay Federal Tax State Tax Net Pay
Amico, Kristin Saturday, January 03, 2015 1 18.5 45 878.75
Evans, Timothy Friday, February 06, 2015 2 14.25 28 399
Fernandez, Marissa Thursday, November 05, 2015 0 16 32.5 520
Hall, Richard Saturday, November 12, 2016 2 18.5 40 740
Mi, Emily Tuesday, August 09, 2016 2 14.25 30 427.5
Reed, Linda Saturday, April 15, 2017 3 19 52 1102
Smith, Caroline Friday, June 02, 2017 1 13 27.25 354.25
Totals 254.75 4421.5 0 0 0
Average 1.5714285714 16.2142857143 36.3928571429 631.6428571429 ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0!
Highest 3 19 52 1102 0 0 0
Lowest 0 13 27.25 354.25 0 0 0