P4 Use appropriate tools to present data.
P8 Export the contents of the spreadsheet model to an alternative format.
M1 Refine a spreadsheet model by changing rules and values
M2 Analyse and interpret data from a spreadsheet model
M3 Compare different automation methods
Scenario
You work for a smal...
p8 export the contents of the spreadsheet model to an alternative format
m1 refine a spreadsheet model by changing rules and values
m2 analyse and interpret da
Escuela, estudio y materia
BTEC
Pearson (PEARSON)
Information Technology 2010 QCF
Unit 42 - Spreadsheet Modelling
Todos documentos para esta materia (3)
3
reseñas
Por: akhsalov41 • 5 año hace
Por: minhazshah82 • 6 año hace
Very unclear on what is what... Not impressed at all!
Por: petercriss • 6 año hace
This is written as a report up to Merit standard using the correct jargon and advanced language.
Por: sabesonncs11 • 6 año hace
Vendedor
Seguir
petercriss
Comentarios recibidos
Vista previa del contenido
Refining a spreadsheet model and
presenting data
Task 4
What data was incorrectly archived?
By using the sort tool on the expired data, I could see that the
data on the dates had been entered incorrectly. Excel will
automatically sort the data into its relevant fields but I have to
make sure that the highlighted range is selected, that the
correct data is to be checked and sorted.
Is it still worth opening the function room to
conferences?
As you can see from this pivot table I have created, that the conference
room isn’t worth keeping as it only made £6,600 in the year 2015
compared to the other rooms that are booked. It’s clear to see that
weddings make the most money.
Los beneficios de comprar resúmenes en Stuvia estan en línea:
Garantiza la calidad de los comentarios
Compradores de Stuvia evaluaron más de 700.000 resúmenes. Así estas seguro que compras los mejores documentos!
Compra fácil y rápido
Puedes pagar rápidamente y en una vez con iDeal, tarjeta de crédito o con tu crédito de Stuvia. Sin tener que hacerte miembro.
Enfócate en lo más importante
Tus compañeros escriben los resúmenes. Por eso tienes la seguridad que tienes un resumen actual y confiable.
Así llegas a la conclusión rapidamente!
Preguntas frecuentes
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
100% de satisfacción garantizada: ¿Cómo funciona?
Nuestra garantía de satisfacción le asegura que siempre encontrará un documento de estudio a tu medida. Tu rellenas un formulario y nuestro equipo de atención al cliente se encarga del resto.
Who am I buying this summary from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller petercriss. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy this summary for 6,15 €. You're not tied to anything after your purchase.