I. Multiple Choice: 20 Questions worth 1 point each.

poprac

Main

Home >Homework Answsers >Business & Finance homework help >Accounting homework help

Multiple Choice: 20 Questions worth 1 point each.

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) Point

b) Sort

c) ScreenTip

d) Cut

If 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 and then:

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 Formatting.

d) Click the arrow on the Paste button on the Standard toolbar, then click Paste Special and select Values.

A color option that uses the Windows default text and background color values.

a) Automatic color

b) Total row

c) Mini toolbar

d) Standard color

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 AutoSum button on the Standard toolbar, then press ENTER.

d) Click the Toolbox and then press SUMIF+D29

Which of the following is an absolute cell reference?

a) G5

b) $A$8

c) B:2

d) #J#9

To remove data from a cell and place it on the Office Clipboard.

a) Chart

b) Cut

c) Link

d) Cell

On an Excel sheet the active cell is indicated by _____________.

a) A dark wide border

b) A dotted border

c) A blinking border

d) None of the above

How do you change column width to fit the contents?

a) Single-click the boundary to the left of the column heading.

b) Double-click the boundary to the right of the column heading.

c) Press ALT and single-click anywhere in the column.

d) Press SHIFT W

###### means:

a) You've entered a number wrong.

b) You've misspelled something.

c) The cell is not wide enough.

d) You entered an incorrect formula.

Which key do you press to group two or more adjacent rows, columns, or cells?

a) CTRL.

b) SHIFT

c) ALT

d) F5

In order to multiply items in Excel you would use which symbol:

a) ^

b) @

c) *

d) #

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 tab and select DELETE

c) Right click on the spreadsheet and select INSERT - ENTIRE COLUMN

d) Right click on the spreadsheet tab and press the X key.

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) Sum

d) MAX

__________ orientation is a worksheet whereby the page is wider than it is tall.

Answer: Landscape orientation

a) Diagonal

b) Portrait

c) Landscape

d) Vertical

The _____________ identifies each row by a different number.

a) Row titles

b) Row totals

c) Row averages

d) Row heading

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

Another name for a formula in Excel is:

a) Arithmetic

b) Equation

c) Math

d) Function

Excel spreadsheets be used as the "data source" for:

a) Adding new rows

b) Adding new columns

c) Mail Merge

d) Filtering

To hide sub-rows, you would use:

a) The group function

b) The autoSum function

c) Conditional formatting

d) Data consolidation

To create drop down lists within a cell, you would use:

a) A pivot table

b) The validate function

c) Permissions

d) Page breaks

II.

Apply Your Knowledge: 20 questions worth 4 points each

Write the formula in the yellow highlighted cell to compute total hours worked.

Employee #:

Hours Worked:

128367

153823

134879

173054

156398

199843

364921

Write the formula in the yellow highlighted cell to compute the average number of hours worked.

Employee #:

Hours Worked:

Hourly Wage:

Weekly Salary

128367

$10.50

N/A

153823

N/A

$800

134879

N/A

$900

173054

$15.25

N/A

156398

N/A

$1,000

199843

$18.00

N/A

364921

$16.75

N/A

Write the formula in the yellow highlighted cell below to compute total gross payroll.

Employee #:

Hours Worked:

Hourly Wage:

Weekly Salary

128367

$10.50

N/A

153823

N/A

$800

134879

N/A

$900

173054

$15.25

N/A

156398

N/A

$1,000

199843

$18.00

N/A

364921

$16.75

N/A

The following two charts were created from the table above.
1) How are they different?
2) Which Excel function can create Graph II from Graph I with one key stroke?

Revenue by Department per Month
(in Thousands)

Department:

January

February

March

April

May

Accessories

$18,943.43

$17,223.65

$21,945.78

$25,943.93

$28,520.55

Clothing

16,302.03

19,443.43

21,884.73

17,990.69

18,396.49

Jewelry

35,944.34

32,680.64

41,640.64

49,226.84

54,116.70

Graph I

Graph II

Explain the difference between Tables A, B, and C.
Describe the step by step instructions to achieve Tables B and C, from Table A.

Table A

Table B

Table C

Inventory #

Type

Details

Inventory #

Type

Details

Inventory #

Type

Details

1100

Clothing

Women's blouses

1300

Accessories

Belts

1300

Accessories

Belts

1200

Jewlery

Garnet rings

1500

Accessories

Hats

1800

Shoes

Children's shoes

1300

Accessories

Belts

1600

Accessories

Scarves

1400

Clothing

Children's shorts

1400

Clothing

Children's shorts

1100

Clothing

Women's blouses

2600

Jewlery

Diamond necklaces

1500

Accessories

Hats

1400

Clothing

Children's shorts

2800

Jewlery

Diamond rings

1600

Accessories

Scarves

2000

Clothing

Men's shorts

1900

Jewlery

Emerald rings

1700

Jewlery

Sapphire necklaces

2200

Clothing

Men's dress shirts

1200

Jewlery

Garnet rings

1800

Shoes

Children's shoes

2500

Clothing

Women's skirts

2900

Clothing

Girls dresses

1900

Jewlery

Emerald rings

2900

Clothing

Girls dresses

1500

Accessories

Hats

2000

Clothing

Men's shorts

1200

Jewlery

Garnet rings

2200

Clothing

Men's dress shirts

2100

Jewlery

Men's wedding rings

1700

Jewlery

Sapphire necklaces

3000

Shoes

Men's shoes

2200

Clothing

Men's dress shirts

1900

Jewlery

Emerald rings

2000

Clothing

Men's shorts

2300

Jewlery

Sterling silver rings

2100

Jewlery

Men's wedding rings

2100

Jewlery

Men's wedding rings

2400

Jewlery

Women's Wedding bands

2300

Jewlery

Sterling silver rings

1700

Jewlery

Sapphire necklaces

2500

Clothing

Women's skirts

2400

Jewlery

Women's Wedding bands

1600

Accessories

Scarves

2600

Jewlery

Diamond necklaces

2600

Jewlery

Diamond necklaces

2300

Jewlery

Sterling silver rings

2700

Shoes

Women's shoes

2800

Jewlery

Diamond rings

1100

Clothing

Women's blouses

2800

Jewlery

Diamond rings

1800

Shoes

Children's shoes

2700

Shoes

Women's shoes

2900

Clothing

Girls dresses

2700

Shoes

Women's shoes

2500

Clothing

Women's skirts

3000

Shoes

Men's shoes

3000

Shoes

Men's shoes

2400

Jewlery

Women's Wedding bands

Describe what would cause Table B to report Inventory #s as #VALUE! for the first 5 items.

Table B

Inventory #

Type

Details

#VALUE!

Shoes

Children's shoes

#VALUE!

Shoes

Women's shoes

#VALUE!

Accessories

Belts

#VALUE!

Accessories

Hats

#VALUE!

Accessories

Scarves

1100

Clothing

Women's blouses

1200

Clothing

Children's shorts

1300

Clothing

Men's shorts

1400

Clothing

Men's dress shirts

1500

Clothing

Women's skirts

1600

Clothing

Girls dresses

1700

Jewlery

Garnet rings

1800

Jewlery

Sapphire necklaces

1900

Jewlery

Emerald rings

2000

Jewlery

Men's wedding rings

2100

Jewlery

Sterling silver rings

2200

Jewlery

Women's Wedding bands

2300

Jewlery

Diamond necklaces

2400

Jewlery

Diamond rings

3000

Shoes

Men's shoes

Which Excel function could create the table below that contains red, yellow, and green markers?

Revenue Reported by Manager per Month

Manager

January

February

March

April

May

Apple, Bridget

$30,309.49

$27,557.84

$35,113.25

$41,510.29

$45,632.88

Pear, Derrick

18,943.43

17,223.65

21,945.78

25,943.93

28,520.55

Banana, Kathy

33,151.00

30,141.39

38,405.12

45,401.88

49,910.96

Plum, Florence

36,371.39

33,069.41

42,135.90

49,812.35

54,759.46

Grape, Sharon

85,927.40

78,126.48

99,546.06

117,681.67

129,369.21

Peach, Ron

137,483.84

125,002.36

159,273.69

188,290.67

206,990.74

Grapefruit, Anne

35,944.34

32,680.64

41,640.64

49,226.84

54,116.70

Totals

$378,130.88

$343,801.77

$438,060.43

$517,867.62

$569,300.51

Using the invoice template below, write formulas in the yellow highlighted cells to compute the values. Assume a tax rate of 7.5% and a discount of 10%.

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.98

Corned beef sandwiches

$5.98

Whitefish salad sandwiches

$4.50

Potato Latkes

$1.98

SUB-TOTAL BEFORE DISCOUNT

DISCOUNT

SUB-TOTAL AFTER DISCOUNT

TAX

TOTAL

Create 2 (collapsible) groups on this spreadsheet: Part I and Part II.

Add 5 additional rows below this question and highlight them green.

Create a drop down list of the following items in the highlighted cells below.

FAR = Financial Accounting and Reporting

AUD = Auditing

REG = Taxation and Business Law

BEC Business and Environmental Concepts

Label the areas in the screen shot below.

Write the formula to compute the Total Percentage Weights in the yellow highlighted cell below.

Angela Jade's Grades

Percentage Weights

Assignment

Grades Earned

% Grade

Letter
Grade

Quizzes

20%

Quiz 1

90-100%

Midterm Exam

30%

Quiz 2

80-89%

Project A

Quiz 3

70-79%

Project B

15%

Midterm

Below 70%

Final Exam

30%

Quiz 4

Project A

Quiz 5

Quiz 6

Final Exam

Project B

Using the information below, write the formula to compute Angela Jade's final percentage grade. Also report Angela Jade's final letter grade.

Angela Jade's Grades

Percentage Weights

Assignment

Grades Earned

% Grade

Letter
Grade

Quizzes

20%

Quiz 1

90-100%

Midterm Exam

30%

Quiz 2

80-89%

Project A

Quiz 3

70-79%

Project B

15%

Midterm

Below 70%

Final Exam

30%

Quiz 4

100%

Project A

Quiz 5

Quiz 6

Final Exam

Project B

Create a table similar to the one in the previous question. Enter the formula to compute your final course grade for this course.

Assuming 80% is the lowest passing grade, write the formula in the yellow highlighted cells below indicating whether each student Passed or Failed. Hint: the resulting cell contents should read "Passed" or "Failed."

Write the "IF" formula to mark cells as "PASSED" or "FAILED" if the value of cell B158 is greater than 74.
Use the formula to complete the table below.

Student

Grades Earned:

Passed or Failed?

A. Jade

D. Rouge

S. Plum

H. White

Create a column chart using the data in Table A below. Group similar assignments into 3 group in this order: Quizzes, Exams, and Projects. Fill the Quiz bars with red, Projects with Purple, and Exams with Dark 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.

Table A

Assignment

Due Date

Grade

Quiz 1

Jan. 8

Quiz 2

Jan. 15

Quiz 3

Jan. 23

Quiz 4

Jan. 30

Quiz 5

Feb. 7

Quiz 6

Feb. 10

Project A

Feb. 14

Project B

Feb. 21

Midterm

Feb. 25

Final Exam

Feb. 28

Using the Inventory TYPE data, describe the step by step instructions to see the Jewelry items only, as is shown to the right. Use your step by step instructions to create Table III, which will be identical to Table II.

Table I

Table II

Inventory #

TYPE

Details

Inventory #

TYPE

Details

1100

Clothing

Women's blouses

1200

Jewelry

Garnet rings

1200

Jewelry

Garnet rings

1700

Jewelry

Sapphire rings

1300

Accessories

Belts

1900

Jewelry

Emerald rings

1400

Clothing

Children's shorts

2000

Jewelry

Ruby rings

1500

Accessories

Hats

2200

Jewelry

925 rings

1600

Accessories

Scarves

2300

Jewelry

Cocktail rings

1700

Jewelry

Sapphire rings

2500

Jewelry

Multi-gem rings

1800

Shoes

Children's shoes

2700

Jewelry

Diamond rings

1900

Jewelry

Emerald rings

2000

Jewelry

Ruby rings

Table III

2100

Clothing

Men's dress shirts

2200

Jewelry

925 rings

2300

Jewelry

Cocktail rings

2400

Clothing

Women's skirts

2500

Jewelry

Multi-gem rings

2600

Shoes

Women's shoes

2700

Jewelry

Diamond rings

Provide a review of this Excel Assessment. Be sure to include which Excel function(s) were new to you, what you learned, what you hope to learn about Excel in this course.

Demonstrate your knowledge of Excel not already assessed in this Excel Assessment by creating a new Excel Assessment question (and the solution) for consideration by your professor in future semesters.

10 years ago
30.09.2016
5

Report issue

Answer(0)

Bids(1)

PrincessMary tutor

other Questions(10)