Question: Create a new spreadsheet titled [Your Name] - Application. Title the worksheet Step 3 and 4. In Cell A1, type Spending Categories. In Cell A3,

Create a new spreadsheet titled "[Your Name] - Application."

  • Title the worksheet "Step 3 and 4."
  • In Cell A1, type Spending Categories.
  • In Cell A3, type Salaries;
  • In Cell A4, type Fringe Benefits;
  • In Cell A5, type OTPS; [NOTE in general budgeting, finance, and administration, a budget category "OTPS" would mean Other Than Non-Personal Services; which means items like supplies, contractual services, or equipment.]
  • In Cell A6, type Total.
  • Adjust the column width, so that the text does not cross over into the other column.
  • Put the months of the year in the next 12 columns (i.e., columns B1M1), and put a Total column (sum of line) after the months (i.e., column N1). Adjust any columns as necessary, so the text fits.
  • Skip Line7.
  • In Cell A8, type Next Year (YSR2).
  • In Cell A9, type YR2 Salaries.
  • In Cell A10, type YR2 Fringe Benefits.
  • In Cell A11, type YR2 OTPS.
  • In Cell A12, type YR2 Total.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!