12,804 views
???? 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 will learn how to solve an Excel test for a job interview. An Excel test that was included in a job interview. In this job interview, four Excel questions were asked. The first involved basic math in Excel, addition, multiplication, subtraction and division. The second question is about addition and addition with criteria or sumif. The third question is about conditional formatting to automatically paint a cell in Excel, highlight values, paint an entire row in the Excel spreadsheet. The fourth question is about the vlookup function in Excel, one of the most important Excel formulas, as well as lookup, lookupx, lookup and index match. 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 day-to-day life and how to solve an Excel test in a job interview. With practical examples from everyday life, we will solve several Excel challenges that came up in an Excel test for a job interview. 0:00 - Subscribe to the Channel 0:15 - Like the Video 0:30 - Question 01 3:32 - Question 02 8:53 - Question 03 14:27 - Question 04 #ExcelenteJoão #Excel #Dashboard