agustinianoms-hscomputerlab.yolasite.com... · web viewnivel secundaria primer curso sección a, b...

Nivel Secundaria Primer Curso Sección A, BTecnologíaMónica Herrera

EXAMEN IV BIMESTRE

Nombre: Fecha:

1. Open Microsoft Excel2. Create a monthly budget for an imaginary person named Fred. (Title Fred’s budget)3. This budget will need separate columns for expenses and income. 4. You should show totals for the expenses and income. 5. Apply quetzals symbol to all the money amounts6. Also, show what Fred will have left over by subtracting his total expenses from the total

income. 7. Finally make a bar graph that compares Fred’s monthly expenses with his monthly income.

8. Apply borders to the table9. Merge and center the tittle 10. Name the worksheet Fred’s budget11. Save it as: IV period exam name and grade

Checklist to grade excel practiceWrite the title 10 pts.Include the income 10 pts.Include all the expenses 20 pts.Make formulas to add and subtract 10 pts.Insert a graph 10 pts.Add borders and center titles 10 pts.Apply quetzals symbol 5 pts.Add title to the graph 5 pts.Name the worksheet 10 pts.Save it correctly 10 pts.Final grade 100 pts.