Track Summer Earnings and Expenses
Translated by
ScribdTranslationsTrack Summer Earnings and Expenses
Translated by
ScribdTranslationsAssociate Create Excel
In this project, you will create a workbook to keep track of your earnings from 'jobs' from
summer (for example, mowing the neighbor's lawn, or walking someone's dog, or taking care of pets, or
to take care of children) during the first two weeks of July, and their expenses by category during five
weeks of summer fun for five weeks.
It will create data for two spreadsheets. Enter the data as described in the following paragraphs.
And, next, apply the specifications listed in the table.
You will create the first spreadsheet to track your daily earnings from your summer job.
List each day during the first two weeks of July in the leftmost column,
starting in cell A3. In row 2, add titles for the date, a description of the work, the
nombre del cliente, el apellido del cliente, eltempo invertdo (en horas) y el importe total ganado.
Fill the range with data. Name this spreadsheet Work Register.
She will create the second spreadsheet to track her weekly expenses across a variety of
costs over a period of five weeks. Add the title "Week" in cell A1, then enter the
week 1, week 2, week 3, week 4 and week 5 below the title in column A. The
costs that will be tracked can be for things like movies, food, gasoline, clothes, concerts, etc.
Seleccione cinco "categorías" de costos y enumere losttulos para las categorías en las celdas B1 a F1.
Fill the range with data; it is acceptable to have cells containing the value zero (0). Assign to this sheet
Weekly Expenses
Also, make sure that your workbook adheres to the following specifications:
Make sure that the
first spreadsheet (the
that contains the data of
income) is referred to as
Work register.
In the leaf of
calculation Work record,
set the row height
for row 1 in 30.
Add the
title Earnings to the
cell A1 and center it between
the columns A and G.
Apply the style of
header cell 1 to the
cell A1.
Add the title of the
Column Rate to the
column G and set the
cell orientation in
something different from 0 degrees.
Apply the Date format
long to the dates of the
column A.
Write a formula in the
column Rate that calculated
the hourly rate of each
work.
Apply the name of
range Rate to the values of
the Rate column.
In cell A19 enter the
text rate lower and
insert a formula in the
cell B19 that calculates the
lowest rate. Use it
name of the range in the
formula.
In the data, locate the
client who paid the fee
lower and format the
first and last name of
client with the effect of
struck-through text.
In cell A20 enter the
texto Pago higher and
insert a formula in the
cell B20 that calculates the
highest amount won by
a job.
In cell C20, use a
text function for
show the name
complete of the client that
paid more for a
work.
Apply a format
conditional of the bar
data to the column of
import cattle.
Borre the format
conditional of a cell in
the amount column
cattle.
Enter a formula in
the column I that will show
Pretty good
if the value of the column
The rate is $12 or more, and
Will show the text "Not the"
next summer if the value
is less than 12.
In cell A22, set
the font size
in 20 points, write the
My favorite client is,
Next, adjust the
text in the cell.
In cell B22, enter a
formula that will show the
customer's name that is
show in cell C20 in
uppercase.
In cell C22, enter a
formula that will show
only the last name of the
client listed in the
cell B22.
Insert a header in
the spreadsheet. Write
your name and surname in the
section central del
header, insert a
code to display the
current date in the section
right and, then,
return to Normal view.
Modify the configuration
from the page for the
lines of grid
appear in the print.
Establish an area of
printing that includes only
the data of the
columns B to F.
Configure los ajustes de
printing for the sheet
it fits on one page.
I blocked the first two.
the rows and the column located
more to the left in the
Spreadsheet Register of
work.
Make sure that the
second spreadsheet (the
that lists the expenses) is
denomination Expenses
weekly.
In the spreadsheet Expenses
weekly, convert the
data range in a
table with headers.
Apply a table style to
the table.
Assign a the table
name JulyExpenses.
Add a total row to the
table and configure each
column to show a
total sum.
Apply the option Style of
first column to the
table.
Add formulas to the
column H that will add up
each row of the table for the
five weekly entries.
Add the title Total
weekly to column H.
Insert mini graphics of
column in the
column I for each row of
data.
Insert a chart of
columns that show the
weeks along the X axis
and the categories of expenses
as a legend.
Filter the table so that it does not
show the data of the
week 3.
Apply a design of
graphic to graphic.
Apply a graphic style
to the graph.
Disable the visualization
of the axis titles and
move the legend to the part
superior of the graph.
Add the text
alternative Graphic of
expenses
Mueva el gráfico a su
own graph sheet
called My graph.
Add another sheet of
calculation to the workbook and
assign to the new sheet of
calculation the name Details
Copy the data (cells)
A2:I16) on the sheet of
work registration calculation
and stick them (keeping
the column widths of
origin) on the sheet of
calculation Details from
cell A1.
In the leaf of
calculation Details, delete the
cell format of the
data from column F.
Copy the values from the
column G and paste them from
new in the same
location that values.
In cell A20, insert a
hyperlink
a htp://[Link]
Arrange the data in the
cells A2:G15 in order
ascending by last name of
client (column D) and, to
continuation, in order
descendant for
rate (column G).
Just format the page of
calculation Details for
show formulas instead
of results.
Add the title Earned and
spent and the matter of money
from summer to the
properties delete
document.
IMPORTANT: Do not save this file in the Documents\Jasperactive folder, as all content
it will be removed when the results are evaluated.