{"id":419,"date":"2017-10-18T17:59:17","date_gmt":"2017-10-18T06:59:17","guid":{"rendered":"https:\/\/www.dynamicwebtraining.com.au\/blog\/?p=419"},"modified":"2024-11-14T13:31:50","modified_gmt":"2024-11-14T02:31:50","slug":"5-commonly-asked-excel-questions-job-interviews","status":"publish","type":"post","link":"https:\/\/www.dynamicwebtraining.com.au\/blog\/5-commonly-asked-excel-questions-job-interviews","title":{"rendered":"5 Commonly Asked Excel questions in Job Interviews"},"content":{"rendered":"\n

Today, every employer expects that you have some advance knowledge of Microsoft Excel, though it may not be the primary function of your job. Advanced excel skills can certainly boost your chances to grab that vacancy. We have selected the Five commonly asked Excel questions in Job interviews:<\/p>\n\n\n\n\n\n\n\n

Microsoft Excel: Interview Questions<\/h2>\n\n\n\n

1: What is a Vlookup?<\/h4>\n\n\n\n

Vertical Lookup or Vlookup is an Excel function which retrieves or finds the value a specific data from a big list of data organized in a table array. It is a lookup formula which allows you to fetch data based on a criterion.<\/p>\n\n\n\n

This Excel function ‘looks up’ from, a particular value in the left-hand column of a table array and retrieves the corresponding value that is assigned to it from another column of the array.<\/p>\n\n\n\n

The vlookup syntax looks like this:<\/p>\n\n\n\n

VLOOKUP( lookup_value, table_array, col_index_num, [range_lookup] )<\/em><\/p>\n\n\n\n

\n
\"Excel
Click image to enlarge <\/i><\/figcaption><\/figure>\n<\/div><\/div><\/div>\n\n\n\n

Where these parameters mean:<\/strong><\/p>\n\n\n\n

lookup_value is the cell that you have defined to look up. It is the cell D2 in the top image.<\/p>\n\n\n\n

table_array is the whole data array or a part of the table. (The table array is A: B)<\/p>\n\n\n\n

col_index_num is the column number of the table that you want to retrieve the value from, and that is 2 in the above image.<\/p>\n\n\n\n

[range_lookup] is a function that deciphers the exact value or the nearest approximate depending on the command. The [range_lookup] can be set to 0 or FALSE for exact match and 1 or TRUE for the closest value.<\/p>\n\n\n\n

The result:<\/strong><\/p>\n\n\n\n

\n
\"Excel
Click image to enlarge <\/i><\/figcaption><\/figure>\n<\/div><\/div><\/div>\n\n\n\n

2: Do You Know to Create Charts?<\/h4>\n\n\n\n

Charts in Excel are of great help for visual reference. Excel has included different type of charts.<\/p>\n\n\n\n

The standard charts are \u2013 Line chart, Pie Chart, Columns, and Bars. There are also other representations like Area, Scatter, Stock, Doughnut, Surface, etc.<\/p>\n\n\n\n

You can find charts by clicking \u2018Insert\u2019<\/strong> and then the Chart<\/strong> button.<\/p>\n\n\n\n

\n
\"Create
Click image to enlarge <\/i><\/figcaption><\/figure>\n<\/div><\/div><\/div>\n\n\n\n

If someone asks to find the charts by one click, you have a shortcut for that.<\/p>\n\n\n\n

Press F11<\/strong><\/p>\n\n\n\n

The default chart is the column chart<\/strong>.<\/p>\n\n\n\n

\n
\"Excel
Click image to enlarge <\/i><\/figcaption><\/figure>\n<\/div><\/div><\/div>\n\n\n\n

You can choose other charts too. For example : The Line Chart<\/strong><\/p>\n\n\n\n

\n
\"Excel
Click image to enlarge <\/i><\/figcaption><\/figure>\n<\/div><\/div><\/div>\n\n\n\n
\n
\"Excel
Click image to enlarge <\/i><\/figcaption><\/figure>\n<\/div><\/div><\/div>\n\n\n\n

Here is another option \u2013 Pie chart<\/strong>.<\/p>\n\n\n\n

\n
\"Excel
Click image to enlarge <\/i><\/figcaption><\/figure>\n<\/div><\/div><\/div>\n\n\n\n

3: What are Pivot Tables?<\/h4>\n\n\n\n

A Pivot Table gathers and summarizes the data from a detailed spreadsheet or a range of a spreadsheet. This table allows you to glance on the information such as:<\/p>\n\n\n\n

Number of items based on each data type;<\/p>\n\n\n\n

Sum of a column based on specific data types;<\/p>\n\n\n\n

Average of the column based on particular data types.<\/p>\n\n\n\n

\n
\"Excel
Click image to enlarge <\/i><\/figcaption><\/figure>\n<\/div><\/div><\/div>\n\n\n\n

Excel pivot table also has an added feature to extract relevant data from any part of the summarized pivot table.<\/p>\n\n\n\n

If you click on sales representative- Brown\u2019s name, you get his sales details only.<\/p>\n\n\n\n

\n
\"Excel
Click image to enlarge <\/i><\/figcaption><\/figure>\n<\/div><\/div><\/div>\n\n\n\n

4- Do You Know How to Remove Duplicates?<\/h4>\n\n\n\n

Removing duplicate cells from the spreadsheet is relatively simple. Surprisingly many Excel users don\u2019t know the technique and spend hours using that with Ctrl + F<\/strong> option.<\/p>\n\n\n\n

\n
\"Excel
Click image to enlarge <\/i><\/figcaption><\/figure>\n<\/div><\/div><\/div>\n\n\n\n
\n
\"Excel
Click image to enlarge <\/i><\/figcaption><\/figure>\n<\/div><\/div><\/div>\n\n\n\n

Select the whole column from which you want to remove the duplicates. Go to the \u2019Data\u2019<\/strong> tab and click Remove Duplicates<\/strong>.<\/p>\n\n\n\n

\n
\"Excel
Click image to enlarge <\/i><\/figcaption><\/figure>\n<\/div><\/div><\/div>\n\n\n\n
\n
\"Excel
Click image to enlarge <\/i><\/figcaption><\/figure>\n<\/div><\/div><\/div>\n\n\n\n

Click OK<\/strong>. The duplicate numbers are removed.<\/p>\n\n\n\n

\n
\"Excel
Click image to enlarge <\/i><\/figcaption><\/figure>\n<\/div><\/div><\/div>\n\n\n\n
\n
\"Excel
Click image to enlarge <\/i><\/figcaption><\/figure>\n<\/div><\/div><\/div>\n\n\n\n

It is a simple step, but many don\u2019t know about it.<\/p>\n\n\n\n

5- Do you know the ways of Protecting the Books and the Sheets?<\/h4>\n\n\n\n

Protection is key, and if you don\u2019t know how to protect the files, it will not go down well with the interviewer.
There are three levels of protection in Microsoft Excel:<\/p>\n\n\n\n

1- Protecting the complete work book<\/strong><\/p>\n\n\n\n

You can protect your entire workbook by putting a password.<\/p>\n\n\n\n

\n
\"Excel
Click image to enlarge <\/i><\/figcaption><\/figure>\n<\/div><\/div><\/div>\n\n\n\n

Go to \u2018File\u2019<\/strong> and then \u2019 Info.’<\/strong> Choose \u2018Encrypt with Password\u2019<\/strong> and enter a password.<\/p>\n\n\n\n

Click Ok<\/strong>, and your book is protected. Nobody can open the file without your password.<\/p>\n\n\n\n

\n
\"Excel
Click image to enlarge <\/i><\/figcaption><\/figure>\n<\/div><\/div><\/div>\n\n\n\n

2- The spread sheet:<\/strong><\/p>\n\n\n\n

To protect the spreadsheet in Excel, you click the \u2018Review\u2019<\/strong> Tab and then the \u2018Protect Sheet.’<\/strong><\/p>\n\n\n\n

\n
\"Excel
Click image to enlarge <\/i><\/figcaption><\/figure>\n<\/div><\/div><\/div>\n\n\n\n
\n
\"Excel
Click image to enlarge <\/i><\/figcaption><\/figure>\n<\/div><\/div><\/div>\n\n\n\n

Enter a password and click OK<\/strong>. The spreadsheet is now protected.<\/p>\n\n\n\n

3- Locking the sheet and making few cells editable:<\/strong><\/p>\n\n\n\n

If you want to make the cell editable in protected spreadsheet selectively, Make a selection of the cells you want to be made editable. Select the Font down arrow and unlock the cells and hit OK<\/strong> as shown below:<\/p>\n\n\n\n

\n
\"Excel
Click image to enlarge <\/i><\/figcaption><\/figure>\n<\/div><\/div><\/div>\n\n\n\n
\n
\"Excel
Click image to enlarge <\/i><\/figcaption><\/figure>\n<\/div><\/div><\/div>\n\n\n\n

These are the three protection tips used in Excel to protect your files.<\/p>\n\n\n\n

Now you are aware of the commonly asked question; you should do well. There are other topics as well you should be aware of like- Organizing Data, Converting rows to Columns, Finding Top Bottom Performance, Dropdown Lists and Printing all data on one sheet.<\/p>\n\n\n\n

To learn more about excel, you can check our excel courses.<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

Today, every employer expects that you have some advance knowledge of Microsoft Excel, though it may not be the primary function of your job. Advanced excel skills can certainly boost your chances to grab that vacancy. We have selected the Five commonly asked Excel questions in Job interviews:<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-419","post","type-post","status-publish","format-standard","hentry","category-microsoft-excel"],"yoast_head":"Top 5 Commonly Asked Excel Questions in a Job Interviews.<\/title>\n<meta name=\"description\" content=\"View and Share Dynamic Web Training Blog Archives. This is a great source of articles and posts on Computer and IT training, tutorials and insights\" \/>\n<meta name=\"robots\" content=\"index, follow\" \/>\n<meta name=\"googlebot\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<meta name=\"bingbot\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dynamicwebtraining.com.au\/blog\/5-commonly-asked-excel-questions-job-interviews\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Top 5 Commonly Asked Excel Questions in a Job Interviews.\" \/>\n<meta property=\"og:description\" content=\"Master five commonly asked Microsoft Excel questions to increase your chances to succeed in Job interviews. Dynamic Web Training Blog Archives.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dynamicwebtraining.com.au\/blog\/5-commonly-asked-excel-questions-job-interviews\" \/>\n<meta property=\"og:site_name\" content=\"Dynamic Web Training Blog\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/DynamicWebTraining\/\" \/>\n<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/DynamicWebTraining\/\" \/>\n<meta property=\"article:published_time\" content=\"2017-10-18T06:59:17+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-11-14T02:31:50+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2017\/10\/excel-vlookup-formula.png\" \/>\n<meta name=\"twitter:card\" content=\"summary\" \/>\n<meta name=\"twitter:creator\" content=\"@dynamicwebtrain\" \/>\n<meta name=\"twitter:site\" content=\"@dynamicwebtrain\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/#organization\",\"name\":\"Dynamic Web Training\",\"url\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/\",\"sameAs\":[\"https:\/\/www.facebook.com\/DynamicWebTraining\/\",\"https:\/\/www.linkedin.com\/company\/dynamic-web-training\",\"https:\/\/twitter.com\/dynamicwebtrain\"],\"logo\":{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/#logo\",\"inLanguage\":\"en-US\",\"url\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2016\/02\/logo.png\",\"width\":361,\"height\":109,\"caption\":\"Dynamic Web Training\"},\"image\":{\"@id\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/#logo\"}},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/#website\",\"url\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/\",\"name\":\"Dynamic Web Training Blog\",\"description\":\"The Ultimate Training Experience.\",\"publisher\":{\"@id\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/?s={search_term_string}\",\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/5-commonly-asked-excel-questions-job-interviews#primaryimage\",\"inLanguage\":\"en-US\",\"url\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2017\/10\/excel-vlookup-formula.png\",\"width\":617,\"height\":237},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/5-commonly-asked-excel-questions-job-interviews#webpage\",\"url\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/5-commonly-asked-excel-questions-job-interviews\",\"name\":\"Top 5 Commonly Asked Excel Questions in a Job Interviews.\",\"isPartOf\":{\"@id\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/5-commonly-asked-excel-questions-job-interviews#primaryimage\"},\"datePublished\":\"2017-10-18T06:59:17+00:00\",\"dateModified\":\"2024-11-14T02:31:50+00:00\",\"description\":\"Master five commonly asked Microsoft Excel questions to increase your chances to succeed in Job interviews. Dynamic Web Training Blog Archives.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/5-commonly-asked-excel-questions-job-interviews#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dynamicwebtraining.com.au\/blog\/5-commonly-asked-excel-questions-job-interviews\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/5-commonly-asked-excel-questions-job-interviews#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"item\":{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\",\"url\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\",\"name\":\"Training Blog\"}},{\"@type\":\"ListItem\",\"position\":2,\"item\":{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/category\/training\",\"url\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/category\/training\",\"name\":\"Training\"}},{\"@type\":\"ListItem\",\"position\":3,\"item\":{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/category\/training\/microsoft-excel\",\"url\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/category\/training\/microsoft-excel\",\"name\":\"Microsoft Excel\"}},{\"@type\":\"ListItem\",\"position\":4,\"item\":{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/5-commonly-asked-excel-questions-job-interviews\",\"url\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/5-commonly-asked-excel-questions-job-interviews\",\"name\":\"5 Commonly Asked Excel questions in Job Interviews\"}}]},{\"@type\":\"Article\",\"@id\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/5-commonly-asked-excel-questions-job-interviews#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/5-commonly-asked-excel-questions-job-interviews#webpage\"},\"author\":{\"@id\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/#\/schema\/person\/c94653aed4a6decc8e357af0a1082233\"},\"headline\":\"5 Commonly Asked Excel questions in Job Interviews\",\"datePublished\":\"2017-10-18T06:59:17+00:00\",\"dateModified\":\"2024-11-14T02:31:50+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/5-commonly-asked-excel-questions-job-interviews#webpage\"},\"publisher\":{\"@id\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/5-commonly-asked-excel-questions-job-interviews#primaryimage\"},\"articleSection\":\"Microsoft Excel\",\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/#\/schema\/person\/c94653aed4a6decc8e357af0a1082233\",\"name\":\"Dynamic Web Training\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/#personlogo\",\"inLanguage\":\"en-US\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/0a14e92e62ad4eee0843f5cf7da3a00e1df4c9763922d4d20ba3ed2402a6896d?s=96&d=mm&r=g\",\"caption\":\"Dynamic Web Training\"},\"description\":\"Dynamic Web Training is Australia's leading provider of instructor led software training. We offer training courses in Adobe, Web Design, Graphic Design, Photoshop, InDesign, Dreamweaver and many more.\",\"sameAs\":[\"https:\/\/www.facebook.com\/DynamicWebTraining\/\",\"https:\/\/www.linkedin.com\/company\/dynamic-web-training\",\"https:\/\/twitter.com\/dynamicwebtrain\"]}]}<\/script>","_links":{"self":[{"href":"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-json\/wp\/v2\/posts\/419","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-json\/wp\/v2\/comments?post=419"}],"version-history":[{"count":15,"href":"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-json\/wp\/v2\/posts\/419\/revisions"}],"predecessor-version":[{"id":1922,"href":"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-json\/wp\/v2\/posts\/419\/revisions\/1922"}],"wp:attachment":[{"href":"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-json\/wp\/v2\/media?parent=419"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-json\/wp\/v2\/categories?post=419"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-json\/wp\/v2\/tags?post=419"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}