{"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":"2026-06-24T14:33:28","modified_gmt":"2026-06-24T04:33:28","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 advanced knowledge of Microsoft Excel, though it may not be the primary function of your job. Advanced Excel skills can certainly boost your chances of grabbing 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 that retrieves a specific value from a large dataset organised 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 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 you want to retrieve the value from; in the above image, that is 2.<\/p>\n\n\n\n

[range_lookup] is a function that deciphers the exact value or the nearest approximation, depending on the command. The [range_lookup] can be set to 0 or FALSE for an exact match, or to 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 how to Create Charts?<\/h4>\n\n\n\n

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

The standard charts are Line, Pie, Column, and Bar. There are other representations as well, such as Area, Scatter, Stock, Doughnut, and Surface.<\/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 with 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 a 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 summarises the data from a detailed spreadsheet or a range of spreadsheets. This table allows you to glance at 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

The Excel pivot table also has a feature to extract relevant data from any part of the summarised 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 this technique and spend hours using Ctrl+F.<\/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 workbook<\/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 spreadsheet:<\/strong><\/p>\n\n\n\n

To protect the spreadsheet in Excel, click the \u2018Review\u2019 tab, then click \u2018Protect Sheet\u2019.<\/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 a few cells editable:<\/strong><\/p>\n\n\n\n

If you want to selectively make cells in a protected spreadsheet editable, select the cells you want to edit. Select the Font down arrow, 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 that you are aware of the commonly asked question, you should do well. There are other topics you should be aware of as well, like Organising Data, Converting rows to Columns, Finding Top and 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 advanced knowledge of Microsoft Excel, though it may not be the primary function of your job. Advanced Excel skills can certainly boost your chances of grabbing 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=\"Master five commonly asked Microsoft Excel questions to increase your chances to succeed in Job interviews. Dynamic Web Training Blog Archives.\" \/>\n<meta name=\"robots\" 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=\"5 Commonly Asked Excel Questions in 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=\"2026-06-24T04:33:28+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2017\/10\/excel-vlookup-formula.png\" \/>\n\t<meta property=\"og:image:width\" content=\"617\" \/>\n\t<meta property=\"og:image:height\" content=\"237\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Dynamic Web Training\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@dynamicwebtrain\" \/>\n<meta name=\"twitter:site\" content=\"@dynamicwebtrain\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Dynamic Web Training\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"8 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@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\"},\"author\":{\"name\":\"Dynamic Web Training\",\"@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\":\"2026-06-24T04:33:28+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/5-commonly-asked-excel-questions-job-interviews\"},\"wordCount\":858,\"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\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/wp-content\\\/uploads\\\/2017\\\/10\\\/excel-vlookup-formula.png\",\"articleSection\":[\"Microsoft Excel\"],\"inLanguage\":\"en-AU\"},{\"@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\":\"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\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/5-commonly-asked-excel-questions-job-interviews#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/wp-content\\\/uploads\\\/2017\\\/10\\\/excel-vlookup-formula.png\",\"datePublished\":\"2017-10-18T06:59:17+00:00\",\"dateModified\":\"2026-06-24T04:33:28+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-AU\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/5-commonly-asked-excel-questions-job-interviews\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-AU\",\"@id\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/5-commonly-asked-excel-questions-job-interviews#primaryimage\",\"url\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/wp-content\\\/uploads\\\/2017\\\/10\\\/excel-vlookup-formula.png\",\"contentUrl\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/wp-content\\\/uploads\\\/2017\\\/10\\\/excel-vlookup-formula.png\",\"width\":617,\"height\":237},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/5-commonly-asked-excel-questions-job-interviews#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Training Blog\",\"item\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Training\",\"item\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/category\\\/training\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Microsoft Excel\",\"item\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/category\\\/training\\\/microsoft-excel\"},{\"@type\":\"ListItem\",\"position\":4,\"name\":\"5 Commonly Asked Excel Questions in Job Interviews\"}]},{\"@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\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-AU\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/#organization\",\"name\":\"Dynamic Web Training\",\"url\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-AU\",\"@id\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/wp-content\\\/uploads\\\/2016\\\/02\\\/logo.png\",\"contentUrl\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/wp-content\\\/uploads\\\/2016\\\/02\\\/logo.png\",\"width\":361,\"height\":109,\"caption\":\"Dynamic Web Training\",\"name\":\"Dynamic Web Training Logo\",\"description\":\"Dynamic Web Training official site logo asset\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/DynamicWebTraining\\\/\",\"https:\\\/\\\/x.com\\\/dynamicwebtrain\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/#\\\/schema\\\/person\\\/c94653aed4a6decc8e357af0a1082233\",\"name\":\"Dynamic Web Training\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-AU\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/0a14e92e62ad4eee0843f5cf7da3a00e1df4c9763922d4d20ba3ed2402a6896d?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/0a14e92e62ad4eee0843f5cf7da3a00e1df4c9763922d4d20ba3ed2402a6896d?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/0a14e92e62ad4eee0843f5cf7da3a00e1df4c9763922d4d20ba3ed2402a6896d?s=96&d=mm&r=g\",\"caption\":\"Dynamic Web Training\"},\"description\":\"This article is written by a senior writer at Dynamic Web Training. Our specialist writers are either Microsoft Certified Trainers, Adobe Certified Professionals or Certified Xero Advisors.\",\"sameAs\":[\"https:\\\/\\\/www.dynamicwebtraining.com.au\",\"https:\\\/\\\/www.facebook.com\\\/DynamicWebTraining\\\/\",\"https:\\\/\\\/www.instagram.com\\\/dynamicwebtraining\\\/\",\"https:\\\/\\\/www.linkedin.com\\\/company\\\/dynamic-web-training\",\"https:\\\/\\\/x.com\\\/dynamicwebtrain\",\"www.youtube.com\\\/@dynamicwebtraining8740\"],\"url\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\"}]}<\/script>","yoast_head_json":{"title":"Top 5 Commonly Asked Excel Questions in a Job Interviews.","description":"Master five commonly asked Microsoft Excel questions to increase your chances to succeed in Job interviews. Dynamic Web Training Blog Archives.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.dynamicwebtraining.com.au\/blog\/5-commonly-asked-excel-questions-job-interviews","og_locale":"en_US","og_type":"article","og_title":"5 Commonly Asked Excel Questions in Job Interviews","og_description":"Master five commonly asked Microsoft Excel questions to increase your chances to succeed in Job interviews. Dynamic Web Training Blog Archives.","og_url":"https:\/\/www.dynamicwebtraining.com.au\/blog\/5-commonly-asked-excel-questions-job-interviews","og_site_name":"Dynamic Web Training Blog","article_publisher":"https:\/\/www.facebook.com\/DynamicWebTraining\/","article_author":"https:\/\/www.facebook.com\/DynamicWebTraining\/","article_published_time":"2017-10-18T06:59:17+00:00","article_modified_time":"2026-06-24T04:33:28+00:00","og_image":[{"width":617,"height":237,"url":"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2017\/10\/excel-vlookup-formula.png","type":"image\/png"}],"author":"Dynamic Web Training","twitter_card":"summary_large_image","twitter_creator":"@dynamicwebtrain","twitter_site":"@dynamicwebtrain","twitter_misc":{"Written by":"Dynamic Web Training","Est. reading time":"8 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@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"},"author":{"name":"Dynamic Web Training","@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":"2026-06-24T04:33:28+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dynamicwebtraining.com.au\/blog\/5-commonly-asked-excel-questions-job-interviews"},"wordCount":858,"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"},"thumbnailUrl":"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2017\/10\/excel-vlookup-formula.png","articleSection":["Microsoft Excel"],"inLanguage":"en-AU"},{"@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":"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"},"image":{"@id":"https:\/\/www.dynamicwebtraining.com.au\/blog\/5-commonly-asked-excel-questions-job-interviews#primaryimage"},"thumbnailUrl":"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2017\/10\/excel-vlookup-formula.png","datePublished":"2017-10-18T06:59:17+00:00","dateModified":"2026-06-24T04:33:28+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-AU","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dynamicwebtraining.com.au\/blog\/5-commonly-asked-excel-questions-job-interviews"]}]},{"@type":"ImageObject","inLanguage":"en-AU","@id":"https:\/\/www.dynamicwebtraining.com.au\/blog\/5-commonly-asked-excel-questions-job-interviews#primaryimage","url":"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2017\/10\/excel-vlookup-formula.png","contentUrl":"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2017\/10\/excel-vlookup-formula.png","width":617,"height":237},{"@type":"BreadcrumbList","@id":"https:\/\/www.dynamicwebtraining.com.au\/blog\/5-commonly-asked-excel-questions-job-interviews#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Training Blog","item":"https:\/\/www.dynamicwebtraining.com.au\/blog\/"},{"@type":"ListItem","position":2,"name":"Training","item":"https:\/\/www.dynamicwebtraining.com.au\/blog\/category\/training"},{"@type":"ListItem","position":3,"name":"Microsoft Excel","item":"https:\/\/www.dynamicwebtraining.com.au\/blog\/category\/training\/microsoft-excel"},{"@type":"ListItem","position":4,"name":"5 Commonly Asked Excel Questions in Job Interviews"}]},{"@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":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dynamicwebtraining.com.au\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-AU"},{"@type":"Organization","@id":"https:\/\/www.dynamicwebtraining.com.au\/blog\/#organization","name":"Dynamic Web Training","url":"https:\/\/www.dynamicwebtraining.com.au\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-AU","@id":"https:\/\/www.dynamicwebtraining.com.au\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2016\/02\/logo.png","contentUrl":"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2016\/02\/logo.png","width":361,"height":109,"caption":"Dynamic Web Training","name":"Dynamic Web Training Logo","description":"Dynamic Web Training official site logo asset"},"image":{"@id":"https:\/\/www.dynamicwebtraining.com.au\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/DynamicWebTraining\/","https:\/\/x.com\/dynamicwebtrain"]},{"@type":"Person","@id":"https:\/\/www.dynamicwebtraining.com.au\/blog\/#\/schema\/person\/c94653aed4a6decc8e357af0a1082233","name":"Dynamic Web Training","image":{"@type":"ImageObject","inLanguage":"en-AU","@id":"https:\/\/secure.gravatar.com\/avatar\/0a14e92e62ad4eee0843f5cf7da3a00e1df4c9763922d4d20ba3ed2402a6896d?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/0a14e92e62ad4eee0843f5cf7da3a00e1df4c9763922d4d20ba3ed2402a6896d?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/0a14e92e62ad4eee0843f5cf7da3a00e1df4c9763922d4d20ba3ed2402a6896d?s=96&d=mm&r=g","caption":"Dynamic Web Training"},"description":"This article is written by a senior writer at Dynamic Web Training. Our specialist writers are either Microsoft Certified Trainers, Adobe Certified Professionals or Certified Xero Advisors.","sameAs":["https:\/\/www.dynamicwebtraining.com.au","https:\/\/www.facebook.com\/DynamicWebTraining\/","https:\/\/www.instagram.com\/dynamicwebtraining\/","https:\/\/www.linkedin.com\/company\/dynamic-web-training","https:\/\/x.com\/dynamicwebtrain","www.youtube.com\/@dynamicwebtraining8740"],"url":"https:\/\/www.dynamicwebtraining.com.au"}]}},"_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":16,"href":"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-json\/wp\/v2\/posts\/419\/revisions"}],"predecessor-version":[{"id":2560,"href":"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-json\/wp\/v2\/posts\/419\/revisions\/2560"}],"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}]}}