Acc 217 Unit 3 HW

Anonymous
timer Asked: Sep 3rd, 2018
account_balance_wallet $15

Question Description

Acc 217 Unit 3 HW

See attachment...Complete Excel homework assignments nine through twelve.

Unformatted Attachment Preview

Computerized Accounting Homework 9 - Formulas for Accountants: VLookup Practice: 1) 2) 3) 4) 5) Sort the Lookup Data by Product Name the Lookup data range "Prices" Lookup the Price of each product in the Results Table Copy the formula to the end of data in column D Check your results Results Product Coke Pepsi Nehi Dr. Pepper Sprite Coke Sprite Pepsi RC Cola Dr. Pepper Nehi Lookup Location Madison Brandon Jackson Flowood Byrum Yazoo City Flora Benton Clinton Bentonia Canton Price Lookup Product Coke Pepsi Nehi Dr. Pepper Sprite Price 3.99 3.75 3.50 4.25 3.99 Computerized Accounting Homework 10 - Formulas for Accountants: If Statements Practice: 1) Based on the scores below, create an If Statement to assign Bonus #1 as follows: Greater than 75 80% 75 or less 10% 2) Based on the scores below, create an If Statement to assign Bonus #2 as follows: 60 or less 25% 61 to 75 50% 76 to 89 75% 90 to 100 100% 3) Using both the Score and Discipline below, create an If Statement to assign "Accept" as Bonus #3 if the score is equal to 60 and the Discipline is equal to Accounting, and "Reject" as Bonus #3 for all others. Score Goldsmith Roark Moyers Riddering Wallace James Jinkiri Penn Martin Garrett Bartee 50 60 70 80 90 100 55 65 70 75 80 Discipline Accounting Accounting Law Business Marketing Finance Economics Statistics Management Sports Administration Sports Administration Bonus #1 and "Reject" as Bonus #2 Bonus #3 Computerized Accounting Homework 11 - Formulas for Accountants: Find & Replace; Concatenate Practice: 1) Using the shortcut keys, Change all the Scores of 50 to 5, 60 to 6, 70 to 7, 80 to 8, 90 to 9, 100 to 10, 55 to 5, 65 to 2) Using the shortcut keys, Change all the Accounting Disciplines to Theater, Finance to Dance, Economics to Music, L 3) At the bottom of the table, Create the following phrase which concatenates the text with the cells below. "Professor XXXXXXX teaches XXXXXXX at Belhaven University and is located in office number XXXXX" 4) Copy this statement down a few rows and observe the changes Name Bartee Garrett Goldsmith James Jinkiri Martin Moyers Penn Riddering Roark Wallace Score Office No. 50 60 70 80 90 100 55 65 70 75 80 RC-207 RC-208 I-215 n/a I-217 I-203B P-308 I-219 I-203A P-318 F-302 Discipline Sports Administration Sports Administration Accounting Finance Economics Management Law Statistics Business Accounting Marketing Computerized Accounting Homework #12 - Formulas for Accountants: Tables & Filtering Practice: 1) 2) 3) 4) 5) 6) 7) 8) 9) 10) 11) 12) 13) 14) Convert the data below into a Table (insert ribbon) Add a row for Belhaven; add numbers for the sports listed Add a total row at the bottom of the table (right mouse on any cell in the table, Select "Table" and "Total Row" Copy the total formula to each sport and check the results Name your table (Table Tools, Design, Table Name-upper left corner) Change the style of your table to one you like (Table Tools, Design, Table Styles) Enter a formula to add the two schools that start with "M" in the row provided below the table. Filter the School Name to show totals for Mississippi State & Missouri; compare to manual calculation in row 40 Clear the filter on school Sort the table by School name. Note that the manual calculation below the table for "M" schools is no longer corre Filter the School Name to show all schools that start with the letter 'T'; Type the Total for Tennis in the cell provide Clear the filter on school name Filter Baseball data as greater than 60. Note the different options for numbers' columns vs. text columns. Type the Total in the cell provided below the table School Football Basketball Baseball Tennis Alabama LSU Auburn Texas Tech Tennessee Ole Miss Florida South Carolina 150 143 136 135 123 120 118 115 75 68 61 60 48 45 43 40 90 83 76 75 63 60 58 55 53 46 39 38 26 23 21 18 Georgia Mississippi State Vanderbilt Missouri 112 98 96 95 37 23 21 20 52 38 36 35 15 1 -1 -2 Enter Formula for "M" Schools-all sports Type the "T" Schools' total for Tennis Type the total for Baseball > 60 elect "Table" and "Total Row" low the table. o manual calculation in row 40 or "M" schools is no longer correct otal for Tennis in the cell provided below the table. olumns vs. text columns. Soccer Track 97 90 83 82 70 67 65 62 71 64 57 56 44 41 39 36 59 45 43 42 33 19 17 16 ...
Purchase answer to see full attachment

Tutor Answer

mickeygabz
School: Boston College

See attached

Computerized Accounting
Homework 9 - Formulas for Accountants: VLookup
Practice:
1)
2)
3)
4)
5)

Sort the Lookup Data by Product
Name the Lookup data range "Prices"
Lookup the Price of each product in the Results Table
Copy the formula to the end of data in column D
Check your results

Results
Product
Coke
Pepsi
Nehi
Dr. Pepper
Sprite
Coke
Sprite
Pepsi
RC Cola
Dr. Pepper
Nehi

Lookup
Location

Madison
Brandon
Jackson
Flowood
Byrum
Yazoo City
Flora
Benton
Clinton
Bentonia
Canton

Price
3.99
3.75
3.50
4.25
3.99
3.99
3.99
3.75
3.75
4.25
3.50

Lookup
Product
Coke
Dr. Pepper
Nehi
Pepsi
Sprite

Price
3.99
4.25
3.50
3.75
3.99

Computerized Accounting
Homework 10 - Formulas for Accountants: If Statements
Practice:
1) Based on the scores below, create an If Statement to assign Bonus #1 as follows:
Greater than 75
80%
75 or less
10%
2) Based on the scores below, create an If Statement to assign Bonus #2 as follows:
60 or less
25%
61 to 75
50%
76 to 89
75%
90 to 100
100%
3) Using both the Score and Discipline below, create an If Statement to assign "Accept"
as Bonus #3 if the score is equal to 6...

flag Report DMCA
Review

Anonymous
Good stuff. Would use again.

Similar Questions
Related Tags

Brown University





1271 Tutors

California Institute of Technology




2131 Tutors

Carnegie Mellon University




982 Tutors

Columbia University





1256 Tutors

Dartmouth University





2113 Tutors

Emory University





2279 Tutors

Harvard University





599 Tutors

Massachusetts Institute of Technology



2319 Tutors

New York University





1645 Tutors

Notre Dam University





1911 Tutors

Oklahoma University





2122 Tutors

Pennsylvania State University





932 Tutors

Princeton University





1211 Tutors

Stanford University





983 Tutors

University of California





1282 Tutors

Oxford University





123 Tutors

Yale University





2325 Tutors