{"id":20088,"date":"2020-10-12T22:00:09","date_gmt":"2020-10-12T20:00:09","guid":{"rendered":"https:\/\/www.myexcelonline.com\/?p=20088"},"modified":"2024-03-18T08:10:20","modified_gmt":"2024-03-18T07:10:20","slug":"excel-interview-questions","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/excel-interview-questions\/","title":{"rendered":"Top 7 Excel Interview Questions to Land Your Dream Job!"},"content":{"rendered":"<p><img loading=\"lazy\" decoding=\"async\" title=\"Top 7 Excel Interview Questions to Land Your Dream Job!\"  class=\"alignnone size-full wp-image-20191\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/10\/Top-7-Excel-Interview-Questions.png\" alt=\"Top 7 Excel Interview Questions to Land Your Dream Job!\" width=\"800\" height=\"450\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/10\/Top-7-Excel-Interview-Questions.png 800w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/10\/Top-7-Excel-Interview-Questions-300x169.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/10\/Top-7-Excel-Interview-Questions-768x432.png 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><\/p>\n<p><a class=\"wpil_keyword_link\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/free-microsoft-excel-online-course\/\" target=\"_blank\" rel=\"noopener\" title=\"Microsoft Excel\" data-wpil-keyword-link=\"linked\">Microsoft Excel<\/a> is the<strong> most frequently used application around the globe<\/strong> with over 800 million users.<\/p>\n<p>It is a<strong> must know software<\/strong> for anyone working on number crunching, data analysis, business reporting, charting, and various ad-hoc reports. If you are searching for a job that has &#8220;Microsoft Excel&#8221; as a prerequisite, you<strong> should be prepared to face a few Excel questions when you have your job interview<\/strong>.<\/p>\n<p>Don&#8217;t be afraid as we are here to help you CRUSH these Excel interview questions!<\/p>\n<p>This tutorial will <strong>guide you on the most popular Excel interview questions that will be asked by the interviewer<\/strong> when you are looking for jobs related to finance, accounting, auditing, budgeting, management, project management, administration, and sales, just to name a few.<\/p>\n<p>Following are the <strong>Top 7 Excel interview questions<\/strong> that you need to prepare for to take you to the next round:<\/p>\n<ul>\n<li><a href=\"#vlookup-function\"><strong>#1 &#8211; VLOOKUP Function<\/strong><\/a><\/li>\n<li><a href=\"#freeze-panes\"><strong>#2 &#8211; Freeze Panes<\/strong><\/a><\/li>\n<li><a href=\"#remove-duplicates\"><strong>#3 &#8211; Remove Duplicates<\/strong><\/a><\/li>\n<li><a href=\"#excel-data-tables\"><strong>#4 &#8211; Excel Tables<\/strong><\/a><\/li>\n<li><a href=\"#excel-pivot-tables\"><strong>#5 &#8211; Excel Pivot Tables<\/strong><\/a><\/li>\n<li><a href=\"#protect-sheets\"><strong>#6 &#8211; Protect Sheets<\/strong><\/a><\/li>\n<li><strong><a href=\"#merge-cells\">#7 &#8211; Merge Cells<\/a><\/strong><\/li>\n<\/ul>\n<p>For some bonus tips on crushing your Excel interview questions, listen to our podcast below to get the <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/podcast\/020-how-to-prepare-for-an-excel-assessment-test-for-a-job-interview\/\" target=\"_blank\" rel=\"noopener noreferrer\">best Excel interview tips<\/a> from the Excel experts and MVP&#8217;s around the world:<br \/>\n<div class=\"smart-track-player-container stp-color-f77223-EEEEEE spp-stp-desktop\" data-uid=\"edfccfae\"><\/div><div class=\"spp-shsp-form spp-shsp-form-edfccfae\"><\/div><\/p>\n<p>Let&#8217;s look at each of these topics one-by-one!<\/p>\n<p>Before you proceed forward, make sure you <strong>download this Excel Workbook<\/strong> and follow along:<\/p>\n<div class=\"after-post-box\">\n<p class=\"line-two\"><a class=\"IRPP_minimalist icon-download button small\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/10\/Excel-Interview-Questions.xlsx\" target=\"_blank\" rel=\"noopener noreferrer\" data-leadbox=\"https:\/\/www.myexcelonline.com\/meo-staging\/100-39.html\" data-leadbox-id=\"147284833f72a2:12f08263ab46dc\"><span class=\"ctaText px-3 text-capitalize\"><strong> download excel workbook<\/strong> <i class=\"fa fa-download\"><\/i><\/span><span class=\"postTitle px-3\">Excel-Interview-Questions.xlsx<\/span><\/a><\/p>\n<\/div>\n<p>&nbsp;<\/p>\n<h3><strong><a id=\"vlookup-function\"><\/a>#1 &#8211; VLOOKUP Function<\/strong><\/h3>\n<ul>\n<li><em>What are the arguments of a <strong>VLOOKUP function<\/strong>?<\/em><\/li>\n<li><em>What are the <strong>limitations<\/strong> of this function?<\/em><\/li>\n<li><em>What are the alternate functions that can be used to <strong>overcome the limitations<\/strong>?<\/em><\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<h3>VLOOKUP is the <strong>most used function<\/strong> and <span data-story-id=\"story_117d4b73e8d0471e764c2b5333b55b78\" data-room-id=\"room_d62db1d106bc54e2ee4e1d1ed91d580e\" data-timestamp=\"1602490176537\" data-text=\"hence is most likely to be asked in your Excel interview.\" data-userid=\"1245285956862005248\" data-orgid=\"425304450073260032\">hence is most likely to be asked in your Excel interview questions.<\/span><\/h3>\n<p>It is used to <strong>look up the value in the left-most column<\/strong> of the data table and returns a value in the same row from another column (to the right) in the table array.<\/p>\n<p>&nbsp;<\/p>\n<p>The syntax of<a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/vlookup-function-introduction-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\"><strong> VLOOKUP<\/strong><\/a> is:<\/p>\n<p><strong>=VLOOKUP(<span style=\"color: #0000ff;\">lookup_value<\/span>, <span style=\"color: #ff6600;\">table_array<\/span>, <span style=\"color: #008000;\">col_index_num<\/span>, <span style=\"color: #ff00ff;\">[range_lookup]<\/span>)<\/strong><\/p>\n<p>where:<\/p>\n<ul>\n<li><span style=\"color: #0000ff;\">lookup_value<\/span> &#8211; the value you want to look for in the 1<sup>st<\/sup> column of the data table<\/li>\n<li><span style=\"color: #ff6600;\">table_array<\/span> &#8211; the data table<\/li>\n<li><span style=\"color: #008000;\">col_index_num<\/span> &#8211; the column form which you want to derive the value<\/li>\n<li><span style=\"color: #ff00ff;\">[range_lookup]<\/span> &#8211; Approximate match (TRUE) or Exact match (FALSE).\u00a0The default value is TRUE. <em>This is an optimal argument.<\/em><\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p>In the example below, we have used the <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/vlookup-function-introduction-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\"><strong>VLOOKUP<\/strong> <\/a>function to extract the price of the item from the stock list:<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/10\/Screenshot-790.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Top 7 Excel Interview Questions to Land Your Dream Job!\"  class=\"alignnone wp-image-20105 size-full\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/10\/Screenshot-790.png\" alt=\"Top 7 Excel Interview Questions to Land Your Dream Job!\" width=\"1083\" height=\"397\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/10\/Screenshot-790.png 1083w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/10\/Screenshot-790-300x110.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/10\/Screenshot-790-1024x375.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/10\/Screenshot-790-768x282.png 768w\" sizes=\"(max-width: 1083px) 100vw, 1083px\" \/><\/a><\/p>\n<p><em>To learn about the different ways you can apply the VLOOKUP Function in Excel, <strong><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/vlookup-function-introduction-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">CLICK HERE<\/a><\/strong> for Excel help!<\/em><\/p>\n<p>&nbsp;<\/p>\n<p>The <strong>limitations<\/strong> of this function are:<\/p>\n<ul>\n<li>If the <strong>lookup value is not the 1st column<\/strong> of the data table, it cannot be used.<\/li>\n<li>If you <strong>add or delete columns<\/strong> in the data table, the function will produce the wrong results.<\/li>\n<li>Vlookup <strong>only finds the first match<\/strong>, ignores the rest.<\/li>\n<li>The <strong>default value<\/strong> of the range_lookup argument is an <strong>approximate match<\/strong>.<\/li>\n<li>Vlookup is <strong>not case-sensitive<\/strong>.<\/li>\n<\/ul>\n<p>You can use either <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/how-to-use-index-match-formula-in-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\"><strong>INDEX-MATCH<\/strong><\/a> or <strong>XLOOKUP<\/strong> to overcome these limitations. Learn more about these advanced functions and be prepared for your Excel interview questions.<\/p>\n<p>&nbsp;<\/p>\n<h3><strong><a id=\"freeze-panes\"><\/a>#2 &#8211; Freeze Panes<\/strong><\/h3>\n<ul>\n<li><em>How to <strong>freeze top row or 1st column<\/strong> in Excel?<\/em><\/li>\n<li><em>How to<strong> fix column headings to keep them visible<\/strong> whilst we are scrolling down data?<\/em><\/li>\n<li>How to <strong>freeze multiple rows<\/strong> in Excel?<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p>You can easily <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/how-to-freeze-panes-in-excel\/\" target=\"_blank\"><strong>freeze top rows or columns<\/strong><\/a> in Excel by following the steps below:<\/p>\n<p><span style=\"text-decoration: underline;\"><span style=\"color: #339966;\"><strong>Freeze Top Row<\/strong><\/span><\/span><\/p>\n<p>Go to <strong>View &gt; Freeze Panes &gt; Freeze Top Row<\/strong><\/p>\n<p>This will freeze the Row 1 of your sheet:<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/05\/How-to-Freeze-Panes-in-Excel-1.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to Freeze Panes in Excel\"  class=\"alignnone size-full wp-image-6334\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/05\/How-to-Freeze-Panes-in-Excel-1.jpg\" sizes=\"(max-width: 954px) 100vw, 954px\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/05\/How-to-Freeze-Panes-in-Excel-1.jpg 954w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/05\/How-to-Freeze-Panes-in-Excel-1-300x86.jpg 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/05\/How-to-Freeze-Panes-in-Excel-1-768x219.jpg 768w\" alt=\"How to Freeze Panes in Excel\" width=\"954\" height=\"272\" \/><\/a><\/p>\n<p>Try scrolling down, the\u00a0<strong>first row<\/strong>\u00a0is always visible!<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/05\/How-to-Freeze-Panes-in-Excel-2.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to Freeze Panes in Excel\"  class=\"alignnone size-full wp-image-6335\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/05\/How-to-Freeze-Panes-in-Excel-2.jpg\" sizes=\"(max-width: 689px) 100vw, 689px\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/05\/How-to-Freeze-Panes-in-Excel-2.jpg 689w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/05\/How-to-Freeze-Panes-in-Excel-2-300x65.jpg 300w\" alt=\"How to Freeze Panes in Excel\" width=\"689\" height=\"149\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"text-decoration: underline;\"><span style=\"color: #339966;\"><strong>Freeze First Column<\/strong><\/span><\/span><\/p>\n<p>To freeze the 1st column of your data, Go to <strong>View &gt; Freeze Panes &gt; Freeze First Column.<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/10\/Screenshot-791.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Top 7 Excel Interview Questions to Land Your Dream Job!\"  class=\"alignnone size-full wp-image-20107\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/10\/Screenshot-791.png\" alt=\"Top 7 Excel Interview Questions to Land Your Dream Job!\" width=\"1179\" height=\"286\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/10\/Screenshot-791.png 1179w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/10\/Screenshot-791-300x73.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/10\/Screenshot-791-1024x248.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/10\/Screenshot-791-768x186.png 768w\" sizes=\"(max-width: 1179px) 100vw, 1179px\" \/><\/a><\/p>\n<p>The first column of your data will be frozen!<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/10\/Screenshot-792.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Top 7 Excel Interview Questions to Land Your Dream Job!\"  class=\"alignnone size-full wp-image-20108\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/10\/Screenshot-792.png\" alt=\"Top 7 Excel Interview Questions to Land Your Dream Job!\" width=\"720\" height=\"457\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/10\/Screenshot-792.png 720w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/10\/Screenshot-792-300x190.png 300w\" sizes=\"(max-width: 720px) 100vw, 720px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"text-decoration: underline;\"><span style=\"color: #339966;\"><strong>Freeze Multiple Rows<\/strong><\/span><\/span><\/p>\n<p>If you wish to freeze multiple rows (say from Row 1 to 5), select the 6th row and then go to <strong>View &gt; Freeze Panes &gt; Freeze Panes.<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" alt=\"How to Freeze Panes in Excel\"  title=\"How to Freeze Panes in Excel\"  src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/05\/How-to-Freeze-Panes-in-Excel-5.jpg\" \/><\/p>\n<p>This will freeze all rows above Row 6!<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" alt=\"How to Freeze Panes in Excel\"  title=\"How to Freeze Panes in Excel\"  src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/05\/How-to-Freeze-Panes-in-Excel-6.jpg\" \/><\/p>\n<p>You can go through the tutorial on Excel freeze panes by Microsoft by <strong><a href=\"https:\/\/support.microsoft.com\/en-us\/office\/freeze-panes-to-lock-rows-and-columns-dab2ffc9-020d-4026-8121-67dd25f2508f\" target=\"_blank\" rel=\"noopener noreferrer nofollow\">Clicking Here<\/a><\/strong>.<\/p>\n<p>&nbsp;<\/p>\n<h3><strong><a id=\"remove-duplicates\"><\/a>#3 &#8211; Remove Duplicates<\/strong><\/h3>\n<ul>\n<li><em>How to get a unique list of customers from sales data?<\/em><\/li>\n<li><em>How to remove duplicate value from a column?<\/em><\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p>Let&#8217;s <strong>use an example<\/strong> to understand how to answer these Excel interview questions.<\/p>\n<p>To <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/remove-duplicates-in-an-excel-table\/\" target=\"_blank\" rel=\"noopener noreferrer\"><strong>remove duplicates<\/strong><\/a> from a set of data, <strong>follow the steps below<\/strong>:<\/p>\n<p><span style=\"color: #339966;\"><strong>STEP 1:<\/strong><\/span> Select the column containing duplicate values.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/10\/Screenshot-796.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Top 7 Excel Interview Questions to Land Your Dream Job!\"  class=\"alignnone wp-image-20114 size-full\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/10\/Screenshot-796-e1602501192919.png\" alt=\"Top 7 Excel Interview Questions to Land Your Dream Job!\" width=\"737\" height=\"432\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/10\/Screenshot-796-e1602501192919.png 737w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/10\/Screenshot-796-e1602501192919-300x176.png 300w\" sizes=\"(max-width: 737px) 100vw, 737px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #339966;\"><strong>STEP 2:<\/strong><\/span> Go to <strong>Data<\/strong> &gt; <strong>Remove Duplicates.<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/10\/Screenshot-793.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Top 7 Excel Interview Questions to Land Your Dream Job!\"  class=\"alignnone size-full wp-image-20109\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/10\/Screenshot-793.png\" alt=\"Top 7 Excel Interview Questions to Land Your Dream Job!\" width=\"1001\" height=\"128\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/10\/Screenshot-793.png 1001w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/10\/Screenshot-793-300x38.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/10\/Screenshot-793-768x98.png 768w\" sizes=\"(max-width: 1001px) 100vw, 1001px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #339966;\"><strong>STEP 3:<\/strong><\/span> In the Remove Duplicates dialog box, make sure the<strong> box for\u00a0 &#8220;My data has headers&#8221; is checked<\/strong> and click <strong>OK<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/10\/Screenshot-794.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Top 7 Excel Interview Questions to Land Your Dream Job!\"  class=\"alignnone size-full wp-image-20110\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/10\/Screenshot-794.png\" alt=\"Top 7 Excel Interview Questions to Land Your Dream Job!\" width=\"437\" height=\"279\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/10\/Screenshot-794.png 437w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/10\/Screenshot-794-300x192.png 300w\" sizes=\"(max-width: 437px) 100vw, 437px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>Excel will <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/remove-duplicates-in-an-excel-table\/\" target=\"_blank\" rel=\"noopener noreferrer\"><strong>remove the duplicate values<\/strong> <\/a>and provide you with a unique list!<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/10\/Screenshot-795.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Top 7 Excel Interview Questions to Land Your Dream Job!\"  class=\"alignnone size-full wp-image-20111\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/10\/Screenshot-795.png\" alt=\"Top 7 Excel Interview Questions to Land Your Dream Job!\" width=\"443\" height=\"147\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/10\/Screenshot-795.png 443w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/10\/Screenshot-795-300x100.png 300w\" sizes=\"(max-width: 443px) 100vw, 443px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<h3><strong><a id=\"excel-data-tables\"><\/a>#4 &#8211; Excel Tables<\/strong><\/h3>\n<ul>\n<li><em>How to <strong>convert a range of data into Excel Tables<\/strong>?<\/em><\/li>\n<li><em>What are the <strong>benefits<\/strong> of using an Excel Data Table?<\/em><\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/category\/analysis\/excel-tables\/\" target=\"_blank\" rel=\"noopener noreferrer\"><strong>Excel Tables<\/strong><\/a> are an excellent way to <strong>organize and analyze data accurately<\/strong>. It can be used to easily<strong> sort and filter data<\/strong>. There are numerous benefits of converting your data into Excel Tables<\/p>\n<p>Converting a range into a formatted table can be <strong>done in a matter of seconds<\/strong>. Take the <strong>steps below<\/strong> to do so:<\/p>\n<p><span style=\"color: #339966;\"><strong>STEP 1:<\/strong><\/span> Select the <strong>Data<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/10\/Screenshot-796.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-20114\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/10\/Screenshot-796.png\" alt=\"excel interview questions\" width=\"762\" height=\"460\" title=\"\"><\/a><\/p>\n<p><span style=\"color: #339966;\"><strong>STEP 2:<\/strong><\/span> Go to <strong>Insert<\/strong> &gt; <strong>Table<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/10\/Screenshot-797.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Top 7 Excel Interview Questions to Land Your Dream Job!\"  class=\"alignnone size-full wp-image-20115\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/10\/Screenshot-797.png\" alt=\"Top 7 Excel Interview Questions to Land Your Dream Job!\" width=\"737\" height=\"128\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/10\/Screenshot-797.png 737w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/10\/Screenshot-797-300x52.png 300w\" sizes=\"(max-width: 737px) 100vw, 737px\" \/><\/a><\/p>\n<p><span style=\"color: #339966;\"><strong>STEP 3:<\/strong><\/span> In the Create Table dialog box, Click <strong>OK<\/strong>. <em>(Make sure you check the box next to My Data has headers)<\/em><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/10\/Screenshot-798.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Top 7 Excel Interview Questions to Land Your Dream Job!\"  class=\"alignnone size-full wp-image-20116\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/10\/Screenshot-798.png\" alt=\"Top 7 Excel Interview Questions to Land Your Dream Job!\" width=\"229\" height=\"152\" \/><\/a><\/p>\n<p>This is how your formatted <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/category\/analysis\/excel-tables\/\" target=\"_blank\"><strong>Excel Data Tables<\/strong><\/a> looks like!<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/10\/Screenshot-799.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Top 7 Excel Interview Questions to Land Your Dream Job!\"  class=\"alignnone size-full wp-image-20117\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/10\/Screenshot-799.png\" alt=\"Top 7 Excel Interview Questions to Land Your Dream Job!\" width=\"780\" height=\"458\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/10\/Screenshot-799.png 780w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/10\/Screenshot-799-300x176.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/10\/Screenshot-799-768x451.png 768w\" sizes=\"(max-width: 780px) 100vw, 780px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>There are a plethora of benefits that you can utilize when you convert your data range into an Excel Table:<\/p>\n<ul>\n<li>Structured referencing;<\/li>\n<li>Many different built-in <strong>Table Styles<\/strong> with color formatting;<\/li>\n<li>Use of a <strong>\u201cTotal Row\u201d<\/strong> which uses built-in functions to calculate the contents of a particular column;<\/li>\n<li>Dropdown lists that allow you to <strong>Sort &amp; Filter<\/strong>;<\/li>\n<li>Insert interactive buttons or <strong>Slicers<\/strong>, to filter your Table&#8217;s data;<\/li>\n<li>When you scroll down from the Table, its <strong>Headers replace the Column Letters<\/strong> in the worksheet;<\/li>\n<li>Remove Duplicate Rows automatically;<\/li>\n<li>Summarize the Table with a <strong>Pivot Table<\/strong>;<\/li>\n<li>Supports calculated Columns so you can <strong>create dynamic formulas outside the Table<\/strong>;<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<h3><strong><a id=\"excel-pivot-tables\"><\/a>#5 &#8211; Excel Pivot Tables<\/strong><\/h3>\n<ul>\n<li><em>What is an Excel Pivot Table?<\/em><\/li>\n<li><em>Why do you need an Excel Pivot Table? <\/em><\/li>\n<li><em>What are the features of Excel Pivot Tables?<\/em><\/li>\n<li><em>How can you filter data in Pivot Table?<\/em><\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p>If you want to analyze your data quickly (without using Formulas) and create informative reports, an Excel <a class=\"wpil_keyword_link\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/101-excel-pivot-tables\/\" target=\"_blank\" rel=\"noopener\" title=\"Pivot Table\" data-wpil-keyword-link=\"linked\">Pivot Table<\/a> is your answer!<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/category\/pivot-tables\/\" target=\"_blank\" rel=\"noopener noreferrer\"><strong>Pivot Tables<\/strong><\/a> in Excel are one of the<strong> most powerful features<\/strong> within Microsoft Excel.\u00a0 It allows you to <strong>analyze more than 1 million rows of data with just a few mouse clicks<\/strong>\u00a0and show the results in an easy to read table.<\/p>\n<p>&nbsp;<\/p>\n<p>Follow the<strong> steps below<\/strong> to learn how to create <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/category\/pivot-tables\/\" target=\"_blank\" rel=\"noopener noreferrer\"><strong>Excel Pivot Table<\/strong><\/a> and answer those Excel interview questions like a pro:<\/p>\n<p><strong><span style=\"color: #339966;\">STEP 1:<\/span> <\/strong>Select the <strong>Data<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/10\/Screenshot-800.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Top 7 Excel Interview Questions to Land Your Dream Job!\"  class=\"alignnone size-full wp-image-20119\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/10\/Screenshot-800.png\" alt=\"Top 7 Excel Interview Questions to Land Your Dream Job!\" width=\"796\" height=\"469\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/10\/Screenshot-800.png 796w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/10\/Screenshot-800-300x177.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/10\/Screenshot-800-768x453.png 768w\" sizes=\"(max-width: 796px) 100vw, 796px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #339966;\">STEP 2:<\/span> <\/strong>Go to <strong>Insert<\/strong> &gt; <strong>Pivot Table<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/10\/Screenshot-801.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Top 7 Excel Interview Questions to Land Your Dream Job!\"  class=\"alignnone size-full wp-image-20120\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/10\/Screenshot-801.png\" alt=\"Top 7 Excel Interview Questions to Land Your Dream Job!\" width=\"942\" height=\"128\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/10\/Screenshot-801.png 942w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/10\/Screenshot-801-300x41.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/10\/Screenshot-801-768x104.png 768w\" sizes=\"(max-width: 942px) 100vw, 942px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #339966;\">STEP 3:<\/span> <\/strong>In the Create PivotTable dialog box, Click <strong>OK<\/strong>.<br \/>\n<em>(Select whether you want Pivot Table in a <strong>New or Existing Worksheet)<\/strong><\/em><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/10\/Screenshot-802.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Top 7 Excel Interview Questions to Land Your Dream Job!\"  class=\"alignnone size-full wp-image-20121\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/10\/Screenshot-802.png\" alt=\"Top 7 Excel Interview Questions to Land Your Dream Job!\" width=\"386\" height=\"345\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/10\/Screenshot-802.png 386w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/10\/Screenshot-802-300x268.png 300w\" sizes=\"(max-width: 386px) 100vw, 386px\" \/><\/a><\/p>\n<p>This will create a Pivot Table structure for you. Simply <strong>drag and drop fields<\/strong> in the row and values section and your Pivot is ready!<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/10\/Screenshot-803.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Top 7 Excel Interview Questions to Land Your Dream Job!\"  class=\"alignnone size-full wp-image-20122\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/10\/Screenshot-803.png\" alt=\"Top 7 Excel Interview Questions to Land Your Dream Job!\" width=\"865\" height=\"320\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/10\/Screenshot-803.png 865w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/10\/Screenshot-803-300x111.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/10\/Screenshot-803-768x284.png 768w\" sizes=\"(max-width: 865px) 100vw, 865px\" \/><\/a><\/p>\n<p><em><span class=\"subtitle\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/50-things-you-can-do-with-excel-pivot-tables\/\" target=\"_blank\" rel=\"noopener noreferrer\"><strong>Click here<\/strong><\/a> to read about an interactive tutorial on the 50 different things you can do with an Excel Pivot Table!<\/span><\/em><\/p>\n<p>&nbsp;<\/p>\n<p>Here are some of the advantages of using Pivot Table in your data:<\/p>\n<ul>\n<li>It is<strong> very easy to create<\/strong> a summary report of your data.<\/li>\n<li>It helps to <strong>analyze\u00a0a large set of data<\/strong> with just a few clicks.<\/li>\n<li>You can<strong> create a report without writing any formulas<\/strong>.<\/li>\n<li>To<strong> see the transactions behind a Pivot Table value<\/strong>, simply <strong>double click on any value<\/strong>.<\/li>\n<li>You can insert <strong>inetractive buttons or Slicers<\/strong> to filter your data.<\/li>\n<li>You can add new data to your data source and <strong>Refresh your Pivot Table <\/strong>to see the new information in your Pivot Table report.<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p>To filter data in the Pivot Table, simply create a<strong><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/category\/pivot-tables\/slicers\/\" target=\"_blank\" rel=\"noopener noreferrer\"> Slicer<\/a>:<\/strong><\/p>\n<p><strong><span style=\"color: #339966;\">STEP 1:<\/span> <\/strong>Select a <strong>cell inside the Pivot Table<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/10\/Screenshot-808.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Top 7 Excel Interview Questions to Land Your Dream Job!\"  class=\"alignnone size-full wp-image-20124\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/10\/Screenshot-808.png\" alt=\"Top 7 Excel Interview Questions to Land Your Dream Job!\" width=\"232\" height=\"204\" \/><\/a><\/p>\n<p><strong><span style=\"color: #339966;\">STEP 2:<\/span> <\/strong>Go to<strong> PivotTable Analyze <\/strong>&gt; <strong>Insert Slicer.<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/10\/Screenshot-804.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Top 7 Excel Interview Questions to Land Your Dream Job!\"  class=\"alignnone size-full wp-image-20125\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/10\/Screenshot-804.png\" alt=\"Top 7 Excel Interview Questions to Land Your Dream Job!\" width=\"1028\" height=\"127\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/10\/Screenshot-804.png 1028w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/10\/Screenshot-804-300x37.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/10\/Screenshot-804-1024x127.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/10\/Screenshot-804-768x95.png 768w\" sizes=\"(max-width: 1028px) 100vw, 1028px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #339966;\">STEP 3:<\/span> <\/strong>In the Insert Slicers dialog box, select the <strong>checkboxes next to the column<\/strong> (Sales Region) \u00a0you want to display as a filter.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/10\/Screenshot-805.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Top 7 Excel Interview Questions to Land Your Dream Job!\"  class=\"alignnone size-full wp-image-20126\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/10\/Screenshot-805.png\" alt=\"Top 7 Excel Interview Questions to Land Your Dream Job!\" width=\"238\" height=\"446\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/10\/Screenshot-805.png 238w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/10\/Screenshot-805-160x300.png 160w\" sizes=\"(max-width: 238px) 100vw, 238px\" \/><\/a><\/p>\n<p>An <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/category\/pivot-tables\/slicers\/\" target=\"_blank\" rel=\"noopener noreferrer\"><strong>Excel Slicer<\/strong><\/a> will be created for the fields (Sales Region) you have selected above.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/10\/Screenshot-806.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Top 7 Excel Interview Questions to Land Your Dream Job!\"  class=\"alignnone size-full wp-image-20128\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/10\/Screenshot-806.png\" alt=\"Top 7 Excel Interview Questions to Land Your Dream Job!\" width=\"504\" height=\"332\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/10\/Screenshot-806.png 504w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/10\/Screenshot-806-300x198.png 300w\" sizes=\"(max-width: 504px) 100vw, 504px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #339966;\">STEP 4<\/span><span style=\"color: #339966;\">: <\/span>Select <em>Americas<\/em><\/strong> to filter the data for that particular item.<br \/>\n<em>The data has been filtered!<\/em><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/10\/Screenshot-807.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Top 7 Excel Interview Questions to Land Your Dream Job!\"  class=\"alignnone size-full wp-image-20129\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/10\/Screenshot-807.png\" alt=\"Top 7 Excel Interview Questions to Land Your Dream Job!\" width=\"499\" height=\"327\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/10\/Screenshot-807.png 499w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/10\/Screenshot-807-300x197.png 300w\" sizes=\"(max-width: 499px) 100vw, 499px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<h3><strong><a id=\"protect-sheets\"><\/a>#6 &#8211; Protect Sheets<\/strong><\/h3>\n<ul>\n<li><em>How to protect sheets in Excel?<\/em><\/li>\n<li><em>How to secure formulas in your Excel sheet?<\/em><\/li>\n<\/ul>\n<p>If you have <strong>lots of <a class=\"wpil_keyword_link\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/top-excel-formulas-function-examples-to-get-better-at-microsoft-excel\/\" target=\"_blank\" rel=\"noopener\" title=\"formulas\" data-wpil-keyword-link=\"linked\">formulas<\/a> in your Excel Worksheet and you want to secure those formulas<\/strong>, you can protect your sheets. To protect sheets in Excel, <strong>follow the steps below<\/strong>:<\/p>\n<p><span style=\"color: #339966;\"><strong>STEP 1:<\/strong> <\/span>Press the Go To Special <a class=\"wpil_keyword_link\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/333-excel-shortcuts-for-windows-and-mac\/\" target=\"_blank\" rel=\"noopener\" title=\"shortcut\" data-wpil-keyword-link=\"linked\">shortcut<\/a> <strong>CTRL+G<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"Lock &amp; Protect Formula Cells\"  class=\"alignnone size-full wp-image-19295\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/07\/Lock-and-Protect-Formula-Cells-01.png\" sizes=\"(max-width: 734px) 100vw, 734px\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/07\/Lock-and-Protect-Formula-Cells-01.png 734w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/07\/Lock-and-Protect-Formula-Cells-01-300x138.png 300w\" alt=\"Lock &amp; Protect Formula Cells\" width=\"734\" height=\"338\" \/><\/p>\n<p><span style=\"color: #339966;\"><strong>STEP 2:<\/strong> <\/span> Select the <strong>Constants<\/strong>\u00a0box and press OK (this highlights all the non-formula cells)<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"Lock &amp; Protect Formula Cells\"  class=\"alignnone size-full wp-image-19296\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/07\/Lock-and-Protect-Formula-Cells-02.png\" sizes=\"(max-width: 314px) 100vw, 314px\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/07\/Lock-and-Protect-Formula-Cells-02.png 314w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/07\/Lock-and-Protect-Formula-Cells-02-285x300.png 285w\" alt=\"Lock &amp; Protect Formula Cells\" width=\"314\" height=\"330\" \/><\/p>\n<p><span style=\"color: #339966;\"><strong>STEP 3:<\/strong> <\/span> Press CTRL+1 to bring up the Format Cells dialogue box<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"Lock &amp; Protect Formula Cells\"  class=\"alignnone size-full wp-image-19297\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/07\/Lock-and-Protect-Formula-Cells-03.png\" sizes=\"(max-width: 497px) 100vw, 497px\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/07\/Lock-and-Protect-Formula-Cells-03.png 497w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/07\/Lock-and-Protect-Formula-Cells-03-300x185.png 300w\" alt=\"Lock &amp; Protect Formula Cells\" width=\"497\" height=\"307\" \/><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"Lock &amp; Protect Formula Cells\"  class=\"alignnone size-full wp-image-19298\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/07\/Lock-and-Protect-Formula-Cells-03b.png\" sizes=\"(max-width: 859px) 100vw, 859px\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/07\/Lock-and-Protect-Formula-Cells-03b.png 859w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/07\/Lock-and-Protect-Formula-Cells-03b-300x175.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/07\/Lock-and-Protect-Formula-Cells-03b-768x448.png 768w\" alt=\"Lock &amp; Protect Formula Cells\" width=\"859\" height=\"501\" \/><\/p>\n<p><span style=\"color: #339966;\"><strong>STEP 4:<\/strong> <\/span> Select the <strong>Protection<\/strong>\u00a0tab and\u00a0<strong>Un-check the Locked box<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"Lock &amp; Protect Formula Cells\"  class=\"alignnone size-full wp-image-19299\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/07\/Lock-and-Protect-Formula-Cells-04.png\" sizes=\"(max-width: 877px) 100vw, 877px\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/07\/Lock-and-Protect-Formula-Cells-04.png 877w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/07\/Lock-and-Protect-Formula-Cells-04-300x172.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/07\/Lock-and-Protect-Formula-Cells-04-768x441.png 768w\" alt=\"Lock &amp; Protect Formula Cells\" width=\"877\" height=\"504\" \/><\/p>\n<p><span style=\"color: #339966;\"><strong>STEP 5:<\/strong> <\/span>Go to <strong>Review &gt; Protect Sheet &gt; then enter your custom password<\/strong>\u00a0(optional)<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"Lock &amp; Protect Formula Cells\"  class=\"alignnone size-full wp-image-19300\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/07\/Lock-and-Protect-Formula-Cells-05.png\" sizes=\"(max-width: 842px) 100vw, 842px\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/07\/Lock-and-Protect-Formula-Cells-05.png 842w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/07\/Lock-and-Protect-Formula-Cells-05-300x231.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/07\/Lock-and-Protect-Formula-Cells-05-768x590.png 768w\" alt=\"Lock &amp; Protect Formula Cells\" width=\"842\" height=\"647\" \/><\/p>\n<p>This will lock all the cells that are not constant, so all the <a class=\"wpil_keyword_link\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/top-excel-formulas-function-examples-to-get-better-at-microsoft-excel\/\" target=\"_blank\" rel=\"noopener\" title=\"formula\" data-wpil-keyword-link=\"linked\">formula<\/a> cells &#x1f642;<\/p>\n<p>To know more about how to protect your sheet and to ace that Excel practice test, <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/protect-all-worksheets-using-macros-in-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\"><strong>Click Here<\/strong><\/a>!<\/p>\n<p>&nbsp;<\/p>\n<h3><strong><a id=\"merge-cells\"><\/a>#7 &#8211; Merge Cells<\/strong><\/h3>\n<ul>\n<li><em>How to merge cells in Excel?<\/em><\/li>\n<li><em>How to combine multiple cells in Excel?<\/em><\/li>\n<\/ul>\n<p>A great way to customize the layout of your Excel worksheet is to\u00a0<strong><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/how-to-merge-cells-in-excel-definitive-guide\/\" target=\"_blank\" rel=\"noopener noreferrer\">merge multiple cells<\/a> into one cell<\/strong>.<\/p>\n<p>&nbsp;<\/p>\n<p><strong>Follow the steps below<\/strong> to learn how to answer this Excel interview question on Excel merged cells:<\/p>\n<p><span style=\"color: #339966;\"><strong>STEP 1:<\/strong><\/span>\u00a0Make sure to select all of the cells you want to merge together:<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/06\/How-to-Merge-Cells-in-Excel-2.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to Merge Cells in Excel\"  class=\"alignnone size-full wp-image-6511\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/06\/How-to-Merge-Cells-in-Excel-2.jpg\" sizes=\"(max-width: 574px) 100vw, 574px\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/06\/How-to-Merge-Cells-in-Excel-2.jpg 574w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/06\/How-to-Merge-Cells-in-Excel-2-300x111.jpg 300w\" alt=\"How to Merge Cells in Excel\" width=\"574\" height=\"212\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #339966;\">STEP 2<\/span>:<\/strong>\u00a0Go to\u00a0<em><strong>Home &gt; Alignment &gt; Merge &amp; Center<\/strong><\/em><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/06\/How-to-Merge-Cells-in-Excel-3.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to Merge Cells in Excel\"  class=\"alignnone size-full wp-image-6512\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/06\/How-to-Merge-Cells-in-Excel-3.jpg\" sizes=\"(max-width: 630px) 100vw, 630px\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/06\/How-to-Merge-Cells-in-Excel-3.jpg 630w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/06\/How-to-Merge-Cells-in-Excel-3-300x64.jpg 300w\" alt=\"How to Merge Cells in Excel\" width=\"630\" height=\"135\" \/><\/a><\/p>\n<p>The top row is now\u00a0<strong>merged<\/strong>\u00a0together!<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/06\/How-to-Merge-Cells-in-Excel-4.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to Merge Cells in Excel\"  class=\"alignnone size-full wp-image-6513\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/06\/How-to-Merge-Cells-in-Excel-4.jpg\" sizes=\"(max-width: 574px) 100vw, 574px\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/06\/How-to-Merge-Cells-in-Excel-4.jpg 574w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/06\/How-to-Merge-Cells-in-Excel-4-300x109.jpg 300w\" alt=\"How to Merge Cells in Excel\" width=\"574\" height=\"209\" \/><\/a><\/p>\n<p>Excel has a number of approaches on how to merge cells in Excel that spans across rows and\/or columns. <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/how-to-merge-cells-in-excel-definitive-guide\/\" target=\"_blank\"><strong>Click here<\/strong><\/a> to learn more about it and answer those Excel questions by the interviewer with confidence.<\/p>\n<p>&nbsp;<\/p>\n<h3>Conclusion<\/h3>\n<p>In this article, you have been provided with a detailed guide on the<strong> frequently asked Microsoft <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/delete-onenote-notebooks\/\" target=\"_blank\" rel=\"noopener\">Excel interview questions<\/a> and answers in any Excel practice test<\/strong>.<\/p>\n<p>There are many important features in Excel that you must be prepared for before sitting for an interview. You can learn more about how to use Excel by viewing our FREE Excel webinar training on <strong><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/100-43.html\" target=\"_blank\" rel=\"noopener noreferrer\">Formulas<\/a><\/strong>,\u00a0<strong><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/100-5.html\" target=\"_blank\" rel=\"noopener noreferrer\">Pivot Tables<\/a><\/strong>,\u00a0and\u00a0<strong><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/100-39.html\" target=\"_blank\" rel=\"noopener noreferrer\">Macros &amp; VBA<\/a><\/strong>!<\/p>\n<p>Go through these Excel help tutorials to gauge your Excel skills and crush your Excel interview questions so that you can land your dream job.<\/p>\n<p>For some bonus tips on crushing your Excel interview questions, listen to our podcast below to get the <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/podcast\/020-how-to-prepare-for-an-excel-assessment-test-for-a-job-interview\/\" target=\"_blank\" rel=\"noopener noreferrer\">best Excel interview tips<\/a> from the Excel experts and MVP&#8217;s around the world:<br \/>\n<div class=\"smart-track-player-container stp-color-f77223-EEEEEE spp-stp-desktop\" data-uid=\"edfccfaf\"><\/div><div class=\"spp-shsp-form spp-shsp-form-edfccfaf\"><\/div><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Microsoft Excel is the most frequently used application around the globe with over 800 million users. It is a must know software for anyone working on number crunching, data analysis, business reporting, charting, and various ad-hoc reports. If you are searching for a job that has &#8220;Microsoft Excel&#8221; as a prerequisite, you should be prepared [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":20191,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"cos_headline_score":0,"cos_seo_score":0,"cos_headline_text":"","cos_headline_has_been_analyzed":false,"cos_last_analyzed_headline":[],"om_disable_all_campaigns":false},"categories":[6,3,4,7],"tags":[691,97,692,618,86,693,262,44],"acf":[],"_links":{"self":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/20088"}],"collection":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/comments?post=20088"}],"version-history":[{"count":0,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/20088\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media\/20191"}],"wp:attachment":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media?parent=20088"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/categories?post=20088"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/tags?post=20088"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}