EXERCISE 08: PAYROLL


 EXERCISE 08: PAYROLL

    For this exercise, the main task is to use various formulas such as: VLOOKUP, IF Conditions, AVERAGE, MAXIMUM, and MINIMUM. Way back when I was on Grade-11, I was introduced to this formulas on Google Sheets and understood the elements needed to avoid errors on the formula. As of today, I recall some few formulas, but it was a relief to actually have my old files to use as reference. I have used the same business set-up with the previous exercise which is the "Haus of Cookies" with a total of 6 employees to run the small business.


PAYROLL



PAYROLL FORMULAS



Comments

Post a Comment

Popular posts from this blog

EXERCISE 11: HYPERLINKS AND ACTION BUTTONS

Image
 EXERCISE 11: HYPERLINKS AND ACTION BUTTONS       For the Final Exercise in this Fisrt Semester, I want to apply my ample learnings from the prelim, midterm, and the final term. With my running theme being this retro and vintage appearance, it was really fun to play around the elements such as cutouts and textured shapes that would just simply go well with each other. For some parts of the slides, I used glitch or static moving backgrounds to add more depth to the appearance of the presentation. As per the fonts that I used, I have discovered this futuristic set of font family that would go well when organized and used in the right way.      From the previous lessons, I learned about various transition and effects to improve the interactiveness of the presentation. But I carefully used each animations to not make it too exhausting and messy to the viewers.      For the Hyperlinks and Action Buttons, I used a button that looks like o...
Read more

EXERCISE 03: SMART ART GRAPHICS

Image
_______________________________________________________________________________ INFOGRAPHIC DESIGN       This exercise in general challenged me to understand the use of Smart Art Templates provided by Microsoft Office. At first there were certain parts that took me time to understand such as the adding of columns for this Infographic. To unify my creative thought for this Infographic, I created digital artworks that would accompany the whole design.  _______________________________________________________________________________ HIERCHY CHART      On creating this Heirchy Chart, I have formulated an idea of a small cafe business compossed of 6 employees an 1 head manager/owner. The taskings are divided in 3 which are the Financial Department, Service Department, and Production Stocks Department. The Assistant Manager is incharge of daily supervision of how the employees work and the customer service. With the Head Barista, the taskings can be distrubut...
Read more

EXERCISE 10: ANIMATED AND AUTOMATIC POWERPOINT INSPIRATIONAL PRESENTATION

Image
 EXERCISE 09: ANIMATED AND AUTOMATIC POWERPOINT INSPIRATIONAL PRESENTATION      For this activity combined with the application of the principles of design, I have managed to create this presentation that centers on the topic of how relevant Multimedia Arts is in the modern world that we are currently in. As time progress in the development of our country and the world, Multimedia Arts holds the capacity to elevate and become sophisticated through adaptation in this modernity.      These are a couple of word edits and a little minimalistic art piece that I have created and used for the presentation. With the use of textures and the lines used for the buildings adds a subtle relaxing city view and as if the whole piece is in motion. Upon adding textured background, it sets the line art apart from the whole horizon of the clear sky. With the word art, it came along with the same princple of making it appear in motion. The word is repeated in a way that i...
Read more