Microsoft Excel Basic Exam Quiz (Solving Exam step by step)
Learn how to take a basic Excel job interview test. Solving Excel Exam step by step. #ExcelBasic #ExamExcel #TestExcel
Download exam:
https://eltiotech.com/resolucion-exam...
1. Create an Excel file and save it with the name: Paternal surname Example: Vela.
2. Name the leaves. To sheet 1 with the Table label and to sheet 2 with the Charts label.
3. Set the sheet to landscape orientation. Insert a heading with the name of your school on the left and your name on the right. In the footer insert today's date aligned to the right.
4. On the first page capture the following table:
5. Apply borders, shading and a font different from the one defined by Excel BASIC OPERATIONS (2 POINTS) 1. Calculate the following data: VAT= COST*IGV (uses absolute references) TOTAL= COST+IGV
Basic Computing
2. Apply two-decimal number format and thousands style to the COST and IGV columns, and monetary style to the TOTAL column.
BASIC FUNCTIONS (3 points)
1. Calculate the sum of the total column.
2. Use the corresponding functions to calculate the average, maximum and minimum of requested units.
3. Using the COUNTIF function, find how many goods were ordered for more than 12 units.
4. If more than 4 goods requested more than 12 units, then “DISCOUNT APPLIES”, otherwise “DISCOUNT DOES NOT APPLY”. Use the IF function.
GRAPHICS (3 POINTS)
1. On the charts sheet, create a 3D column chart using the Description and Units ranges.
2. Create a 3D pie chart to show a comparison between the maximum and minimum units requested.
3. Format to your liking using colors, textures, titles, legends, etc.
Subscribe on my other channel:
/ @miguelvelaa
🎯Follow us on TikTok:
/ excelformulas_
🤗 Visit our social networks:
Website: https://www.tiotech.net
https://www.eltiotech.com
Facebook: / eltiotechh
Instagram: / luismiguelvelavela
🟩 Excel Help Group:
/ excelayudas
🟦 Word Help Group:
/ 2954410744838915
Download exam:
http://www.mediafire.com/file/mq3bq6q...