ACCOUNTING HOMEWORK

profilejuicypredatore
2172_excel_assessment.xlsx
Home>Business & Finance homework help>Accounting homework help>ACCOUNTING HOMEWORK

Questions

I. Multiple Choice Questions 1 point each
1 Onscreen text that appears when you position the mouse pointer over certain objects, such as the objects on the taskbar or a toolbar button. ScreenTips tell you the purpose or function of the object to which you are pointing.
 a) Screen Tip
 b) Sort
 c) Point
 d) Cut
2 Say that you want to paste a formula result — but not the underlying formula — to another cell. You would copy the cell with the formula, then place the insertion point in the cell you want to copy to. What next?  
a) Click the Paste button on the Standard toolbar.
b) Click the arrow on the Paste button on the Standard toolbar, then click Formulas.
c) Click the arrow on the Paste button on the Standard toolbar, then click Paste Special and select Values.
d) Click the arrow on the Paste button on the Standard toolbar, then click Values.
3 A color option that uses the Windows default text and background color values.
a) Automatic color
b) Standard color
c) Mini toolbar
d) Total row
4 A fast way to add up this column of numbers is to click in the cell below the numbers and then:
a) Click Subtotals on the Data menu.
b) View the sum in the formula bar.
c) Click the Toolbox and then press SUMIF+D29
d) Click the AutoSum button on the Standard toolbar, then press ENTER.
5 Which of the following is an absolute cell reference?
a) G5
b) #J#9
c) B:2
d) $A$8
6 To remove data from a cell and place it on the Office Clipboard.
a) Copy
b) Cut
c) Link
d) Cell
7 On an Excel sheet the active cell is indicated by ____.
a) A darker dotted border
b) A darker blinking border
c) A darker wide border
d) None of the above
8 How do you change column width to fit the contents?
a) Single-click the boundary to the left of the column heading.
b) Click the boundary to the left of the column heading.
c) Press ALT and single-click anywhere in the column.
d) Double-click the boundary to the right of the column heading.
9  ###### means: 
a) The cell is not wide enough to fit the number.
b) You've entered a number wrong.
c) You've misspelled something.
d) You entered an incorrect formula.
10 Which key do you press to group two or more nonadjacent worksheets? 
a) CTRL
b) SHIFT
c) ALT
d) F5
11 In order to multiply items in Excel you would use which symbol:
a) ^
b) *
c) x
d) #
12 A user wishes to remove a spreadsheet from a workbook. Which is the correct sequence of events that will do this ?
a) Go to FILE - SAVE AS - SAVE AS TYPE - Excel 4.0 Work Sheet
b) Right click on the spreadsheet and select INSERT - ENTIRE COLUMN
c) Right click on the spreadsheet tab and select DELETE
d) Right click on the spreadsheet tab and press the X key.
13 Which formula can add the all the numeric values in a range of cells, ignoring those which are not numeric, and place the result in a different cell ?
a) Count
b) Average
c) Max
d) Sum
14 __________ orientation is a worksheet whereby the page is wider than it is tall.
Answer: Landscape orientation
a) Diagonal
b) Portrait
c) Landscape
d) Vertical
15 The _____________ identifies each row by a different number.
a) Row headings
b) Row totals
c) Row averages
d) Row title
16 To protect a sheet, you must also:
a) Insert gridlines
b) Sort the first column
c) Lock all or some cells
d) Title each column
17 Another name for a formula in Excel is:
a) Arithmetic
b) Function
c) Math
d) Equation
18 Excel spreadsheets be used as the "data source" for:
a) Adding new rows
b) Adding new columns
c) Mail Merge
d) Filtering
19 To hide sub-rows, you would use
a) Auto sum function
b) Group function
c) Conditional formatting
d) Data consolidation
20 To create drop down lists within a cell, you would use:
a) A pivot table
b) Validate function
c) Permissions
d) Page breaks
II. Demonstrate your Excel Skills Points vary by question
21 Write the formula needed in the yellow highlighted cell below to add the number of hours worked by all employees.
Employee #: Hours Worked:
128367 40
153823 45
134879 36
173054 40
156398 42
199843 42
364921 47
Total Hours Worked
Possible points = 2 Points you earned =
22 Write the formula needed in the yellow highlighted cell below to compute the average of number of hours worked by all employees.
Employee #: Hours Worked:
128367 40
153823 45
134879 49
173054 47
156398 37
199843 32
364921 44
Average Hours Worked
Possible points = 2 Points you earned =
23 Assuming 80% is the lowest passing grade, write the formula in the yellow highlighted cells below to indicate whether the student Passed or Failed. Hint: the resulting cell contents should read "Passed" or "Failed."
Student Grades Earned: Passed or Failed?
Alice Jade 80
Dan Rouge 72
Steve Plum 82
Brittany White 68
Possible points = 5 Points you earned =
24 Write the formula used to compute the Total Percentage Weights in the yellow highlighted cell below.
Alice Jade's Grades Percentage Weights Assignment Grades Earned % Grade Letter Grade
Quizzes 20% Quiz 1 80 90-100% A
Midterm Exam 30% Quiz 2 82 80-89% B
Project A 5% Quiz 3 90 70-79% C
Project B 15% Midterm 77 Below 70% F
Final Exam 30% Quiz 4 79
Answer: Project A 82
Quiz 5 76
Quiz 6 84
Final Exam 79
Project B 84
Possible points = 2 Points you earned =
25 Using the information in the previous question, write the formula in the yellow highlighted cell below to compute Alice Jades' final percentage grade. HINT: your answer will be a percentage grade.
Answer:
Possible points = 5 Points you earned =
26 Using the information in the previous question, create a VLookUp table in the blue highlighted cells and a V-Look Up formula in the yellow highlighted cell below to compute Alice Jades' final letter grade. HINT: your answer will be a letter grade that corresponds to the percentage grade in the previous question.
Answer: VLookUp Table
Possible points = 5 Points you earned =
27 Create the formula for 82 minus 32 divided by 8 times 2 plus 5 into the yellow highlighted cell below to derive a value. Then, show the math to derive the same value.
Answer:
Possible points = 2 Points you earned =
III. Tables and Graphs
28 Create a column chart using the data in Table A below. Group similar assignments into 3 groups in this orders: Quizzes, Exams, and Projects. Fill the Quiz bars as follows: Quizzes = Red; Projects = Purple, and Exams = Navy Blue Title the chart: Grades by Assignment Category. Set the Y axis scale from 0 to 100 in 10s and bold the font. The X axis should be grouped by assignment type, and bold the font. Place graph on the next sheet.
Table A
Assignment Due Date Grade
Quiz 1 Jan. 8 82
Quiz 2 Jan. 15 81
Quiz 3 Jan. 23 90
Quiz 4 Jan. 30 75
Quiz 5 Feb. 7 75
Quiz 6 Feb. 10 77
Project A Feb. 14 84
Project B Feb. 21 88
Midterm Feb. 25 72
Final Exam Feb. 28 70
Answer:
Possible points = 5 Points you earned =
29 Table A: Revenue by Department per Month (in Thousands)
Department: January February March April May June July August September October November December
Accessories $18,943.43 $17,223.65 $21,945.78 $25,943.93 $28,520.55 $32,734.33 $29,543.21 $28,441.56 $23,910.52 $20,128.87 $35,912.39 $45,000.31
Clothing 16,302.03 19,443.43 21,884.73 17,990.69 18,396.49 19,449.40 20,471.99 24,110.85 26,551.07 19,337.63 21,023.45 28,945.66
Jewelry 35,944.34 32,680.64 41,640.64 49,226.84 54,116.70 62,112.76 56,057.84 53,966.80 45,369.22 38,192.88 68,143.02 85,387.50
The following two charts were created from the table above. Which Excel function can change Graph I to Graph II with one key stroke?
Answer:
Possible points = 2 Points you earned =
30 How would you describe the areas filled in the screenshot below:
Answer:
Orange fill =
Yellow fill =
Blue fill =
Possible points = 2
Points you earned =
31 Currently, the two tables below are identical. Use the filter function to edit the table on the right to display Accessories and Shoes only.
Complete Inventory List Edit & Rename this Table
Inventory # Type Details Inventory # Type Details
1100 Clothing Women's blouses 1100 Clothing Women's blouses
1200 Jewelry Garnet rings 1200 Jewelry Garnet rings
1300 Accessories Belts 1300 Accessories Belts
1400 Clothing Children's shorts 1400 Clothing Children's shorts
1500 Accessories Hats 1500 Accessories Hats
1600 Accessories Scarves 1600 Accessories Scarves
1700 Jewelry Necklaces 1700 Jewelry Necklaces
1800 Shoes Children's shoes 1800 Shoes Children's shoes
1900 Jewelry Emerald rings 1900 Jewelry Emerald rings
2000 Clothing Men's shorts 2000 Clothing Men's shorts
2100 Jewelry Men's bands 2100 Jewelry Men's bands
2200 Clothing Men's dress shirts 2200 Clothing Men's dress shirts
2300 Jewelry Silver rings 2300 Jewelry Silver rings
2400 Jewelry Women's bands 2400 Jewelry Women's bands
2500 Clothing Women's skirts 2500 Clothing Women's skirts
2600 Jewelry Diamond necklaces 2600 Jewelry Diamond necklaces
2700 Shoes Women's shoes 2700 Shoes Women's shoes
Possible points = 4
Points you earned =
32 Use the Sort function to create two additional tables to the right of the Complete Inventory List Table below. Table 1: Inventory Sorted by Type Table 2: Inventory Sorted by Details Question: Of the three tables, which one provides the least usefulness for inventory control purposes?
Complete Inventory List Inventory Sorted by Type Inventory Sorted by Details
Inventory # Type Details
1100 Clothing Women's blouses
1200 Jewelry Garnet rings
1300 Accessories Belts
1400 Clothing Children's shorts
1500 Accessories Hats
1600 Accessories Scarves
1700 Jewelry Necklaces
1800 Shoes Children's shoes
1900 Jewelry Emerald rings
2000 Clothing Men's shorts
2100 Jewelry Men's bands
2200 Clothing Men's dress shirts
2300 Jewelry Silver rings
2400 Jewelry Women's bands
2500 Clothing Women's skirts
2600 Jewelry Diamond necklaces
2700 Shoes Women's shoes
Answer to Question: Possible points = 4
Points you earned =
33 Describe what would cause Table B to report Inventory #s as #VALUE! for the first 5 items.
Answer:
Possible points = 3
Points you earned =
34 Which Excel function was used to create the formatted table below?
Revenue Reported by Manager per Month
Manager January February March April May June July August September October November December
Apple, Bridget $30,309.49 $27,557.84 $35,113.25 $41,510.29 $45,632.88 $52,374.93 $47,269.14 $45,506.50 $38,256.83 $32,206.19 $57,459.82 $72,000.46
Pear, Derrick 18,943.43 17,223.65 21,945.78 25,943.93 28,520.55 32,734.33 29,543.21 28,441.56 23,910.52 20,128.87 56,034.00 45,000
Banana, Kathy 33,151.00 30,141.39 38,405.12 45,401.88 49,910.96 57,285.08 51,700.62 49,772.73 41,843.41 35,225.52 98,059.50 78,751
Plum, Florence 36,371.39 33,069.41 42,135.90 49,812.35 54,759.46 62,849.91 56,722.96 54,607.80 45,908.20 38,647.43 68,951.79 86,401
Grape, Sharon 85,927.40 78,126.48 99,546.06 117,681.67 129,369.21 148,482.92 134,008.00 129,010.92 108,458.12 91,304.55 162,898.60 204,121
Peach, Ron 137,483.84 125,002.36 159,273.69 188,290.67 206,990.74 237,572.67 214,412.80 206,417.47 173,532.99 146,087.29 260,637.76 326,594
Grapefruit, Anne 35,944.34 32,680.64 41,640.64 49,226.84 54,116.70 62,112.76 56,057.84 53,966.80 45,369.22 38,192.88 68,143.02 85,387
Totals $378,130.88 $343,801.77 $438,060.43 $517,867.62 $569,300.51 $653,412.61 $589,714.57 $567,723.76 $477,279.29 $401,792.74 $772,184.50 $898,255.02
Answer: Possible points = 3
Points you earned =
35 Which Excel feature was used to create the lower table from the top table?
Answer:
Possible points = 2
Points you earned =
36 Which Excel feature was used to create the table below?
Answer: Possible points = 2
Points you earned =
37 Complete the invoice template below, compute the total invoice amount assuming a tax rate of 8% and a discount of 5%. HINT: use formulas to compute cells all blank cells in the invoice.
Catering Invoice Manckowitz Jewish Deli & Catering 1858 Pastrami Lane Baltimore, MD 21209 Invoice #: 671C Date: 10/15/18
MENU ITEM UNIT PRICE QUANTITY LINE TOTAL
Matzo Ball Soup $2.99 17
Corned beef sandwiches $5.99 18
Whitefish salad sandwiches $5.25 21
Potato Latkes $1.99 47
SUB-TOTAL BEFORE DISCOUNT
DISCOUNT
SUB-TOTAL AFTER DISCOUNT
TAX
TOTAL
Answer:
TOTAL INVOICE AMOUNT =
Possible points = 5
Points you earned =
38 Create 4 collapsible groups on this spreadsheet for the Multiple Choice, True/False, Creating Formulas, and Tables and Graphs questions.
Possible points = 5
Points you earned =
39 Create a drop down list of the following items in the highlighted cells below.
FAR = Financial Accounting and Reporting
AUD = Auditing Letter Grade
REG = Taxation and Business Law A
BEC Business and Environmental Concepts B
Possible points = 5
Points you earned =
40 Add 5 additional rows above this question. F
Possible points = 3
Points you earned =
41 Create a table similar to the one in question #24 above for this course. Enter the formula to compute your final course percentage grade. For purposes of this assignment, enter fictitious grades for assignments in the future. Hint: the answer will be a % grade.
Percentage Weights Assignment Grades YOU Earned % Grade Letter Grade
Discussions 14% Discussion 1 81.00 90-100% A
Homework 11% Discussion 2 86.00 80-89% B
Excel 10% Discussion 3 88.00 70-79% C
Case Study 20% Discussion 4 75.00 Below 70% F
Exams 45% Discussion 5 78.00
100% Discussion 6 83.00
Discussion 7 79.00
Homework 1 84.00
Homework 2 77.00
Answer: Homework 3 79.00
Your Final Course Grade = Homework 4 89.00
% Homework 5 90.00
Homework 6 91.00
Homework 7 88.00
Homework 8 84.00
Homework 9 87.00
Homework 10 90.00
Homework 11 83.00
Excel 80.00
Case Study 91.00
Exam I 79.00
Exam II 83.00
Exam III 85.00
Possible points = 5 Points you earned =
42 What did you learn about Excel by completing this assessment?
Possible points = 2
Points you earned =
43 Create a new Excel Assessment question (and the solution) for consideration by your professor in future semesters.
Possible points = 5
Points you earned =
This is the end of the Excel Assessment

&16Excel Assessment