Resolvendo uma Prova de Excel p/ Entrevista de Emprego | Planilha Grátis | Consegue Acertar Tudo?

🟢 LEARN EXCEL WITH ME IN THE COMPLETE EXCEL COURSE WITH CERTIFICATE: http://excelentejoao.com.br/sejaexcel... 🔵 DOWNLOADABLE SPREADSHEET: https://excelentejoao.com.br/wp-conte... In this Excel video lesson, we'll learn how to solve an Excel test for a job interview. An Excel test that appeared in a job interview. If you are studying how to pass a job interview, or if you are interested in taking a basic Excel course for job interviews, this video can help you a lot. It presents the most important Excel formulas for the job market in my opinion and functions to save time in your daily work and how to solve an Excel test in a job interview. With practical, everyday examples, we'll solve several Excel challenges that appeared in an Excel test for a job interview. In this job interview, four Excel questions were asked. The first required solving basic mathematical operations such as addition, multiplication, division, and subtraction using mathematical formulas in Excel. These are the basic Excel formulas. In the second question, we needed to use the VLOOKUP function to return the searched values ​​from a list of items. The VLOOKUP function is an excellent Excel function and one of its main functions. It's one of the most used formulas in Excel because it helps us automate tasks, solve problems, and perform analyses. The VLOOKUP formula can return the corresponding result of a searched value. In the third question, we needed to use the COUNTIF function in Excel to count the number of times a certain value appears in a list. This counts the number of repetitions of something, and in this case, we need to count the number of orders for a specific date. In the fourth and final question, we will use the COUNTA function to count everything we select within the range. In this case, we will use the formula COUNTA DOT VALUES to count the total number of orders in our sales report. 0:00 - Subscribe to the Channel 0:10 - Like the Video 0:18 - Question 01 2:47 - Question 02 8:07 - Question 03 11:38 - Question 04 #ExcellentJoão #Excel #Dashboard