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
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
