Select Page

SDSU Wilson Home Entertainment Systems Statement of Cash Flow Project

Question Description

As accounts receivable clerk for Livingood Income Tax and 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.

[Student Learning Outcomes 1.1, 1.2, 1.4, 1.5, 1.6, 1.8]

File Needed: [your name]-EX2019-IndependentProject-1-6 (Available from the Start File link.)

Completed Project File Name: [your name]-EX2019-IndependentProject-1-6

Skills Covered in This Project

  • Create and save a workbook.
  • Enter labels, dates, and values.
  • Use the Fill Handle to build series.
  • Use SUM.
  • Change font size and attributes.
  • Adjust column width and row height.
  • Choose a theme and cell styles.
  • Choose page layout options.
  • Rename and apply color to sheet tabs.

IMPORTANT: If you are a Canadian user, be sure to verify that your browser and Microsoft Office use the same country settings. See here for a Help topic on how to change your settings.

  1. Format data.
  2. Define page layout and add document properties.

    1. The Titleand Author properties are changed
      Figure 1-106 Properties entered in dialog box

  3. Excel 1-6 completed
    Figure 1-107 Excel 1-6 completed

"Place your order now for a similar assignment and have exceptional work written by our team of experts, guaranteeing you "A" results."

Order Solution Now