Spreadsheets Assignment

Spreadsheets Assignment - Student Edition Lab Assignment:...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
Student Edition Lab Assignment: Spreadsheets CASE: You are an administrative assistant for a real estate developer. The realtors are reimbursed for expenses, such as mileage and meals. You need to track these expenses in an Excel worksheet. Apply the skills you learned in the Lab to complete the worksheet. TASK: 1. Open the Excel file Spreadsheets_Expenses.xls , then save it as Staff Expenses.xls. 2. Complete the worksheet by doing the following: Enter your name in cell A2. Insert a new row above Meals and Entertainment (Row 8). Enter the row label “License Fees” in the new row. Enter the data in the following table: January February March Mileage 250 200 300 Gas 125 250 300 Mileage cost Enter a formula to multiply the mileage in row 5 by the allowance per mile in cell J1. Use an absolute reference for cell J1. License Fees 55 78 98 Meals and Entertainment 220 440 330 Film 125 175 225 Office supply 120 140 160 Create data for April, May, and June by using a formula to add 20 to the values
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 2

Spreadsheets Assignment - Student Edition Lab Assignment:...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online