Even complicated and confusing topics will be easily developed and covered if you request our help writing an essay. Place an order today!

Independent Project 1 -6 (Mac 2016 Version)

As accounts receivable clerk for Livingood Income Tax & Accounting, you track daily payments from clients in an Excel

worksheet. After entering the data, you format the worksheet and prepare it for distribution to coworkers

1. Open the EX2016-IndependentProject-1-6 start file. If the workbook opens in Protected View,

click the Enable Editing button so you can modify it. The file will be renamed automatically to

include your name. Change the project file name if directed to do so by your instructor, and

save it.

2. Apply the Organic theme for the workbook.

3. In cell A1, type Livingood Income Tax and

Accounting and press Enter.

4. In cell A2, type Accounts Receivable and

press Enter.

5. In row 4, type the labels as shown here in

Figure 1-104:

6. AutoFit or widen the columns to display

each label in row 4 in its cell.

7. In cell A5, type 8/18/17 to enter the date. In cell A6, type 8/20/17 to set a pattern for the dates.

8. Select cells A5:A6 and use the Fill Handle to fill in dates to cell .

9. In cell B5, type 1001 for the first invoice number. In cell B6, type 1002 to set a pattern for the

invoice numbers.

10. Select cells B5:B6 and use the Fill Handle to

fill in invoice numbers to reach cell B15.

11. In cell C5, type LITA001 as the first client ID.

In cell C6, type LITA002 to set a pattern.

12. Use the Fill Handle to complete the client ID

numbers.

13. Type 425 in cell D5. In cell D6, type 450 to

set the pattern and fill in the amounts.

14. Type the first two payment dates in column

E and fill the cells (Figure 1-105).

16. Format data.

a. Select cells C5:C15, increase the indent one time,

and AutoFit the column. Do the same for the

payment type data.

b. Format the values in column D as Accounting

Number Format.

c. Select cells A1:F2. Click the Format button [Home

tab, Cells group] and select Format Cells... Select

the Alignment tab. Click the Horizontal alignment

arrow, choose Center Across Selection, and click

OK. Change the font size to 18.

d. Select the labels in row 4 and apply bold format

center alignment.

e. AutoFit columns that do not show all the data.

f. Apply All Borders to cells A4:F15. Apply an Outside

Border for cells A1:F2.

g. Apply the Green, Accent 1, Lighter 60% fill color to

cells A1:F2 and A4:F4.

Note: If you do not see this fill color under Theme

Colors, verify that you have completed instruction

2.

h. Apply the Green, Accent 1, Lighter 60% fill color to

cells A6:F6.

i. Use the command key to select the data in rows 8, 10, 12, and 14 and apply the same fill

color.

17. Rename Sheet1 as AR and set the tab

color to Green, Accent 1.

18. Define page layout and add

document properties.

a. Center the worksheet horizontally

on the page.

b. Create a header with the sheet

name in the left section and your

name in the right section.

c. Delete an existing author name

and key your first and last name as

Author in the Properties dialog box.

d. Type Receivables in the Title box

(Figure 1-106).

e. Preview your worksheet.

19. Save and close the workbook

(Figure 1-107).

20. Upload and save your project file.

21. Submit project for grading

Independent Project 1 -6 (Mac 2016 Version)

As accounts receivable clerk for Livingood Income Tax & Accounting, you track daily payments from clients in an Excel

worksheet. After entering the data, you format the worksheet and prepare it for distribution to coworkers

1. Open the EX2016-IndependentProject-1-6 start file. If the workbook opens in Protected View,

click the Enable Editing button so you can modify it. The file will be renamed automatically to

include your name. Change the project file name if directed to do so by your instructor, and

save it.

2. Apply the Organic theme for the workbook.

3. In cell A1, type Livingood Income Tax and

Accounting and press Enter.

4. In cell A2, type Accounts Receivable and

press Enter.

5. In row 4, type the labels as shown here in

Figure 1-104:

6. AutoFit or widen the columns to display

each label in row 4 in its cell.

7. In cell A5, type 8/18/17 to enter the date. In cell A6, type 8/20/17 to set a pattern for the dates.

8. Select cells A5:A6 and use the Fill Handle to fill in dates to cell .

9. In cell B5, type 1001 for the first invoice number. In cell B6, type 1002 to set a pattern for the

invoice numbers.

10. Select cells B5:B6 and use the Fill Handle to

fill in invoice numbers to reach cell B15.

11. In cell C5, type LITA001 as the first client ID.

In cell C6, type LITA002 to set a pattern.

12. Use the Fill Handle to complete the client ID

numbers.

13. Type 425 in cell D5. In cell D6, type 450 to

set the pattern and fill in the amounts.

14. Type the first two payment dates in column

E and fill the cells (Figure 1-105).

16. Format data.

a. Select cells C5:C15, increase the indent one time,

and AutoFit the column. Do the same for the

payment type data.

b. Format the values in column D as Accounting

Number Format.

c. Select cells A1:F2. Click the Format button [Home

tab, Cells group] and select Format Cells... Select

the Alignment tab. Click the Horizontal alignment

arrow, choose Center Across Selection, and click

OK. Change the font size to 18.

d. Select the labels in row 4 and apply bold format

center alignment.

e. AutoFit columns that do not show all the data.

f. Apply All Borders to cells A4:F15. Apply an Outside

Border for cells A1:F2.

g. Apply the Green, Accent 1, Lighter 60% fill color to

cells A1:F2 and A4:F4.

Note: If you do not see this fill color under Theme

Colors, verify that you have completed instruction

2.

h. Apply the Green, Accent 1, Lighter 60% fill color to

cells A6:F6.

i. Use the command key to select the data in rows 8, 10, 12, and 14 and apply the same fill

color.

17. Rename Sheet1 as AR and set the tab

color to Green, Accent 1.

18. Define page layout and add

document properties.

a. Center the worksheet horizontally

on the page.

b. Create a header with the sheet

name in the left section and your

name in the right section.

c. Delete an existing author name

and key your first and last name as

Author in the Properties dialog box.

d. Type Receivables in the Title box

(Figure 1-106).

e. Preview your worksheet.

19. Save and close the workbook

(Figure 1-107).

20. Upload and save your project file.

21. Submit project for grading

Independent Project 1 -6 (Mac 2016 Version)

As accounts receivable clerk for Livingood Income Tax & Accounting, you track daily payments from clients in an Excel

worksheet. After entering the data, you format the worksheet and prepare it for distribution to coworkers

1. Open the EX2016-IndependentProject-1-6 start file. If the workbook opens in Protected View,

click the Enable Editing button so you can modify it. The file will be renamed automatically to

include your name. Change the project file name if directed to do so by your instructor, and

save it.

2. Apply the Organic theme for the workbook.

3. In cell A1, type Livingood Income Tax and

Accounting and press Enter.

4. In cell A2, type Accounts Receivable and

press Enter.

5. In row 4, type the labels as shown here in

Figure 1-104:

6. AutoFit or widen the columns to display

each label in row 4 in its cell.

7. In cell A5, type 8/18/17 to enter the date. In cell A6, type 8/20/17 to set a pattern for the dates.

8. Select cells A5:A6 and use the Fill Handle to fill in dates to cell .

9. In cell B5, type 1001 for the first invoice number. In cell B6, type 1002 to set a pattern for the

invoice numbers.

10. Select cells B5:B6 and use the Fill Handle to

fill in invoice numbers to reach cell B15.

11. In cell C5, type LITA001 as the first client ID.

In cell C6, type LITA002 to set a pattern.

12. Use the Fill Handle to complete the client ID

numbers.

13. Type 425 in cell D5. In cell D6, type 450 to

set the pattern and fill in the amounts.

14. Type the first two payment dates in column

E and fill the cells (Figure 1-105).

16. Format data.

a. Select cells C5:C15, increase the indent one time,

and AutoFit the column. Do the same for the

payment type data.

b. Format the values in column D as Accounting

Number Format.

c. Select cells A1:F2. Click the Format button [Home

tab, Cells group] and select Format Cells... Select

the Alignment tab. Click the Horizontal alignment

arrow, choose Center Across Selection, and click

OK. Change the font size to 18.

d. Select the labels in row 4 and apply bold format

center alignment.

e. AutoFit columns that do not show all the data.

f. Apply All Borders to cells A4:F15. Apply an Outside

Border for cells A1:F2.

g. Apply the Green, Accent 1, Lighter 60% fill color to

cells A1:F2 and A4:F4.

Note: If you do not see this fill color under Theme

Colors, verify that you have completed instruction

2.

h. Apply the Green, Accent 1, Lighter 60% fill color to

cells A6:F6.

i. Use the command key to select the data in rows 8, 10, 12, and 14 and apply the same fill

color.

17. Rename Sheet1 as AR and set the tab

color to Green, Accent 1.

18. Define page layout and add

document properties.

a. Center the worksheet horizontally

on the page.

b. Create a header with the sheet

name in the left section and your

name in the right section.

c. Delete an existing author name

and key your first and last name as

Author in the Properties dialog box.

d. Type Receivables in the Title box

(Figure 1-106).

e. Preview your worksheet.

19. Save and close the workbook

(Figure 1-107).

20. Upload and save your project file.

21. Submit project for grading

Independent Project 1 -6 (Mac 2016 Version) Independent Project 1 -6 (Mac 2016 Version)

As accounts receivable clerk for Livingood Income Tax & Accounting, you track daily payments from clients in an Excel As accounts receivable clerk for Livingood Income Tax & Accounting, you track daily payments from clients in an Excel

worksheet. After entering the data, you format the worksheet and prepare it for distribution to coworkers worksheet. After entering the data, you format the worksheet and prepare it for distribution to coworkers

1. Open the EX2016-IndependentProject-1-6 start file. If the workbook opens in Protected View, 1. Open the EX2016-IndependentProject-1-6 start file. If the workbook opens in Protected View,

click the Enable Editing button so you can modify it. The file will be renamed automatically to click the Enable Editing button so you can modify it. The file will be renamed automatically to

include your name. Change the project file name if directed to do so by your instructor, and include your name. Change the project file name if directed to do so by your instructor, and

save it. save it.

2. Apply the Organic theme for the workbook. 2. Apply the Organic theme for the workbook.

3. In cell A1, type Livingood Income Tax and 3. In cell A1, type Livingood Income Tax and 3. In cell A1, type

Accounting and press Enter. Accounting and press Enter. Accounting

4. In cell A2, type Accounts Receivable and 4. In cell A2, type Accounts Receivable and Accounts Receivable

press Enter. press Enter.

5. In row 4, type the labels as shown here in 5. In row 4, type the labels as shown here in

Figure 1-104: Figure 1-104:

6. AutoFit or widen the columns to display 6. AutoFit or widen the columns to display

each label in row 4 in its cell. each label in row 4 in its cell.

7. In cell A5, type 8/18/17 to enter the date. In cell A6, type 8/20/17 to set a pattern for the dates. 7. In cell A5, type 8/18/17 to enter the date. In cell A6, type 8/20/17 to set a pattern for the dates. 8/18/17 8/20/17

8. Select cells A5:A6 and use the Fill Handle to fill in dates to cell . 8. Select cells A5:A6 and use the Fill Handle to fill in dates to cell .

9. In cell B5, type 1001 for the first invoice number. In cell B6, type 1002 to set a pattern for the 9. In cell B5, type 1001 for the first invoice number. In cell B6, type 1002 to set a pattern for the 1001 1002

invoice numbers. invoice numbers.

10. Select cells B5:B6 and use the Fill Handle to 10. Select cells B5:B6 and use the Fill Handle to

fill in invoice numbers to reach cell B15. fill in invoice numbers to reach cell B15.

11. In cell C5, type LITA001 as the first client ID. 11. In cell C5, type LITA001 as the first client ID. LITA001

In cell C6, type LITA002 to set a pattern. In cell C6, type LITA002 to set a pattern. LITA002

12. Use the Fill Handle to complete the client ID 12. Use the Fill Handle to complete the client ID

numbers. numbers.

13. Type 425 in cell D5. In cell D6, type 450 to 13. Type 425 in cell D5. In cell D6, type 450 to 425 450

set the pattern and fill in the amounts. set the pattern and fill in the amounts.

14. Type the first two payment dates in column 14. Type the first two payment dates in column

E and fill the cells (Figure 1-105). E and fill the cells (Figure 1-105).

16. Format data. 16. Format data.

a. Select cells C5:C15, increase the indent one time, a. Select cells C5:C15, increase the indent one time,

and AutoFit the column. Do the same for the and AutoFit the column. Do the same for the

payment type data. payment type data.

b. Format the values in column D as Accounting b. Format the values in column D as Accounting

Number Format. Number Format.

c. Select cells A1:F2. Click the Format button [Home c. Select cells A1:F2. Click the Format button [Home

tab, Cells group] and select Format Cells... Select tab, Cells group] and select Format Cells... Select

the Alignment tab. Click the Horizontal alignment the Alignment tab. Click the Horizontal alignment

arrow, choose Center Across Selection, and click arrow, choose Center Across Selection, and click

OK. Change the font size to 18. OK. Change the font size to 18.

d. Select the labels in row 4 and apply bold format d. Select the labels in row 4 and apply bold format

center alignment. center alignment.

e. AutoFit columns that do not show all the data. e. AutoFit columns that do not show all the data.

f. Apply All Borders to cells A4:F15. Apply an Outside f. Apply All Borders to cells A4:F15. Apply an Outside

Border for cells A1:F2. Border for cells A1:F2.

g. Apply the Green, Accent 1, Lighter 60% fill color to g. Apply the Green, Accent 1, Lighter 60% fill color to

cells A1:F2 and A4:F4. cells A1:F2 and A4:F4.

Note: If you do not see this fill color under Theme Note: If you do not see this fill color under Theme

Colors, verify that you have completed instruction Colors, verify that you have completed instruction

2. 2.

h. Apply the Green, Accent 1, Lighter 60% fill color to h. Apply the Green, Accent 1, Lighter 60% fill color to

cells A6:F6. cells A6:F6.

i. Use the command key to select the data in rows 8, 10, 12, and 14 and apply the same fill i. Use the command key to select the data in rows 8, 10, 12, and 14 and apply the same fill

color. color.

17. Rename Sheet1 as AR and set the tab 17. Rename Sheet1 as AR and set the tab AR

color to Green, Accent 1. color to Green, Accent 1.

18. Define page layout and add 18. Define page layout and add

document properties. document properties.

a. Center the worksheet horizontally a. Center the worksheet horizontally

on the page. on the page.

b. Create a header with the sheet b. Create a header with the sheet

name in the left section and your name in the left section and your

name in the right section. name in the right section.

c. Delete an existing author name c. Delete an existing author name

and key your first and last name as and key your first and last name as

Author in the Properties dialog box. Author in the Properties dialog box.

d. Type Receivables in the Title box d. Type Receivables in the Title box Receivables

(Figure 1-106). (Figure 1-106).

e. Preview your worksheet. e. Preview your worksheet.

19. Save and close the workbook 19. Save and close the workbook

(Figure 1-107). (Figure 1-107).

20. Upload and save your project file. 20. Upload and save your project file.

21. Submit project for grading 21. Submit project for grading

testimonials icon
Surname1Name:Professor:Course Title:Date:Standardized Sources of Marketing Data6.1 Which of these two, a product audit (such as the Audits and Survey...
testimonials icon
Health policy...
testimonials icon
Running head: FILM1Second partStudents NameInstitutional AffiliationFILM2An Interview with ZaccurIn interview with Zaccur- music composer and beatmak...
testimonials icon
1. Ethridge Corporation is presently making part H25 that is used is one of its products. A total of 9,000 units of this part are produced and used...
testimonials icon
Find two pieces that address the “gaze” from 1850 CE to 1900 CE. One by a male artist, one by a female artist- both with a female as the “g...
testimonials icon
Case Study 1: Bring Your Own Device (BYOD)Due Week 3 and worth 60 pointsRead the following articles: “...
testimonials icon
rhetorical essaythe homework about analyze commercial if it's ethos, pathos, logos4 page...
testimonials icon
Describe and apply techniques for making computer networks resilient. You will be required to design a resilient network. ULO 2. Explain and impl...
testimonials icon
How do existing criminal justice and social policies create barriers for effective prisoner reentry and rehabilitation? Reentry as a Process ra...
testimonials icon
INTERNATIONAL BUSINESS/MARKETING INVESTIGATIONS PROJECT BRIEFINGThis project requires you to develop a proposal for a piece of primary resea...
testimonials icon
Hey, I need you to do my microsoft access assignments. Please read the steps in the pictures and do them. ...

Other samples, services and questions:

Calculate Price

When you use PaperHelp, you save one valuable — TIME

You can spend it for more important things than paper writing.

Approx. price
$65
Order a paper. Study better. Sleep tight. Calculate Price!
Created with Sketch.
Calculate Price
Approx. price
$65