[fusion_builder_container type=”flex” hundred_percent=”no” equal_height_columns=”no” menu_anchor=”” hide_on_mobile=”small-visibility,medium-visibility,large-visibility” class=”” id=”” background_color=”” background_image=”” background_position=”center center” background_repeat=”no-repeat” fade=”no” background_parallax=”none” parallax_speed=”0.3″ video_mp4=”” video_webm=”” video_ogv=”” video_url=”” video_aspect_ratio=”16:9″ video_loop=”yes” video_mute=”yes” overlay_color=”” video_preview_image=”” border_color=”” border_style=”solid” padding_top=”” padding_bottom=”” padding_left=”” padding_right=””][fusion_builder_row][fusion_builder_column type=”1_1″ layout=”1_1″ background_position=”left top” background_color=”” border_color=”” border_style=”solid” border_position=”all” spacing=”yes” background_image=”” background_repeat=”no-repeat” padding_top=”” padding_right=”” padding_bottom=”” padding_left=”” margin_top=”0px” margin_bottom=”0px” class=”” id=”” animation_type=”” animation_speed=”0.3″ animation_direction=”left” hide_on_mobile=”small-visibility,medium-visibility,large-visibility” center_content=”no” last=”true” min_height=”” hover_type=”none” link=”” border_sizes_top=”” border_sizes_bottom=”” border_sizes_left=”” border_sizes_right=”” first=”true”][fusion_text]
[/fusion_text][/fusion_builder_column][/fusion_builder_row][/fusion_builder_container][fusion_builder_container type=”flex” hundred_percent=”no” hundred_percent_height=”no” min_height=”” hundred_percent_height_scroll=”no” align_content=”stretch” flex_align_items=”flex-start” flex_justify_content=”flex-start” flex_column_spacing=”” hundred_percent_height_center_content=”yes” equal_height_columns=”no” container_tag=”div” menu_anchor=”” hide_on_mobile=”small-visibility,medium-visibility,large-visibility” status=”published” publish_date=”” class=”” id=”” margin_top_medium=”” margin_bottom_medium=”” margin_top_small=”” margin_bottom_small=”” margin_top=”0px” margin_bottom=”” padding_top_medium=”” padding_right_medium=”” padding_bottom_medium=”” padding_left_medium=”” padding_top_small=”” padding_right_small=”” padding_bottom_small=”” padding_left_small=”” padding_top=”” padding_right=”” padding_bottom=”” padding_left=”” link_color=”” link_hover_color=”” border_sizes_top=”” border_sizes_right=”” border_sizes_bottom=”” border_sizes_left=”” border_color=”” border_style=”solid” box_shadow=”no” box_shadow_vertical=”” box_shadow_horizontal=”” box_shadow_blur=”0″ box_shadow_spread=”0″ box_shadow_color=”” box_shadow_style=”” z_index=”” overflow=”” gradient_start_color=”” gradient_end_color=”” gradient_start_position=”0″ gradient_end_position=”100″ gradient_type=”linear” radial_direction=”center center” linear_angle=”180″ background_color=”” background_image=”” background_position=”center center” background_repeat=”no-repeat” fade=”no” background_parallax=”none” enable_mobile=”no” parallax_speed=”0.3″ background_blend_mode=”none” video_mp4=”” video_webm=”” video_ogv=”” video_url=”” video_aspect_ratio=”16:9″ video_loop=”yes” video_mute=”yes” video_preview_image=”” render_logics=”” absolute=”off” absolute_devices=”small,medium,large” sticky=”off” sticky_devices=”small-visibility,medium-visibility,large-visibility” sticky_background_color=”” sticky_height=”” sticky_offset=”” sticky_transition_offset=”0″ scroll_offset=”0″ animation_type=”” animation_direction=”left” animation_speed=”0.3″ animation_offset=”” filter_hue=”0″ filter_saturation=”100″ filter_brightness=”100″ filter_contrast=”100″ filter_invert=”0″ filter_sepia=”0″ filter_opacity=”100″ filter_blur=”0″ filter_hue_hover=”0″ filter_saturation_hover=”100″ filter_brightness_hover=”100″ filter_contrast_hover=”100″ filter_invert_hover=”0″ filter_sepia_hover=”0″ filter_opacity_hover=”100″ filter_blur_hover=”0″][fusion_builder_row][fusion_builder_column type=”1_1″ layout=”1_1″ align_self=”auto” content_layout=”column” align_content=”flex-start” valign_content=”flex-start” content_wrap=”wrap” spacing=”” center_content=”no” link=”” target=”_self” min_height=”” hide_on_mobile=”small-visibility,medium-visibility,large-visibility” sticky_display=”normal,sticky” class=”” id=”” type_medium=”” type_small=”” order_medium=”0″ order_small=”0″ dimension_spacing_medium=”” dimension_spacing_small=”” dimension_spacing=”” dimension_margin_medium=”” dimension_margin_small=”” margin_top=”” margin_bottom=”” padding_medium=”” padding_small=”” padding_top=”” padding_right=”” padding_bottom=”” padding_left=”” hover_type=”none” border_sizes=”” border_color=”” border_style=”solid” border_radius=”” box_shadow=”no” dimension_box_shadow=”” box_shadow_blur=”0″ box_shadow_spread=”0″ box_shadow_color=”” box_shadow_style=”” background_type=”single” gradient_start_color=”” gradient_end_color=”” gradient_start_position=”0″ gradient_end_position=”100″ gradient_type=”linear” radial_direction=”center center” linear_angle=”180″ background_color=”” background_image=”” background_image_id=”” background_position=”left top” background_repeat=”no-repeat” background_blend_mode=”none” render_logics=”” filter_type=”regular” filter_hue=”0″ filter_saturation=”100″ filter_brightness=”100″ filter_contrast=”100″ filter_invert=”0″ filter_sepia=”0″ filter_opacity=”100″ filter_blur=”0″ filter_hue_hover=”0″ filter_saturation_hover=”100″ filter_brightness_hover=”100″ filter_contrast_hover=”100″ filter_invert_hover=”0″ filter_sepia_hover=”0″ filter_opacity_hover=”100″ filter_blur_hover=”0″ animation_type=”” animation_direction=”left” animation_speed=”0.3″ animation_offset=”” last=”true” border_position=”all” first=”true”][fusion_text columns=”” column_min_width=”” column_spacing=”” rule_style=”default” rule_size=”” rule_color=”” content_alignment_medium=”” content_alignment_small=”” content_alignment=”” hide_on_mobile=”small-visibility,medium-visibility,large-visibility” sticky_display=”normal,sticky” class=”” id=”” margin_top=”” margin_right=”” margin_bottom=”” margin_left=”” font_size=”” fusion_font_family_text_font=”” fusion_font_variant_text_font=”” line_height=”” letter_spacing=”” text_color=”” animation_type=”” animation_direction=”left” animation_speed=”0.3″ animation_offset=””]
Even if you’ve been using Excel for years, preparing for an interview requires focused practice. Employers often expect experienced professionals to know more than just the basics. You might be asked about advanced formulas, data validation, automation using macros, and how to troubleshoot errors in Excel sheets. For many roles in operations, reporting, finance, or supply chain, Excel is still a go-to tool, and strong Excel skills are a must.
This page is designed for professionals with little to no work experience who want to review and strengthen their Excel knowledge before an interview. We’ve gathered important Excel interview questions that go beyond the surface. These include real-world scenarios and challenges that test your critical thinking and technical ability.
Whether you’re preparing for a new career or switching to a new job, practicing these questions will help you perform better and make a good impression during your interview.
[/fusion_text][/fusion_builder_column][/fusion_builder_row][/fusion_builder_container][fusion_builder_container type=”flex” hundred_percent=”no” hundred_percent_height=”no” min_height=”” hundred_percent_height_scroll=”no” align_content=”stretch” flex_align_items=”flex-start” flex_justify_content=”flex-start” flex_column_spacing=”” hundred_percent_height_center_content=”yes” equal_height_columns=”no” container_tag=”div” menu_anchor=”” hide_on_mobile=”small-visibility,medium-visibility,large-visibility” status=”published” publish_date=”” class=”” id=”” margin_top_medium=”” margin_bottom_medium=”” margin_top_small=”” margin_bottom_small=”” margin_top=”” margin_bottom=”” padding_top_medium=”” padding_right_medium=”” padding_bottom_medium=”” padding_left_medium=”” padding_top_small=”” padding_right_small=”” padding_bottom_small=”” padding_left_small=”” padding_top=”” padding_right=”” padding_bottom=”” padding_left=”” link_color=”” link_hover_color=”” border_sizes_top=”10px” border_sizes_right=”10px” border_sizes_bottom=”10px” border_sizes_left=”10px” border_color=”#007dc6″ border_style=”solid” box_shadow=”yes” box_shadow_vertical=”4″ box_shadow_horizontal=”4″ box_shadow_blur=”30″ box_shadow_spread=”0″ box_shadow_color=”rgba(0,0,0,0.32)” box_shadow_style=”” z_index=”” overflow=”” gradient_start_color=”” gradient_end_color=”” gradient_start_position=”0″ gradient_end_position=”100″ gradient_type=”linear” radial_direction=”center center” linear_angle=”180″ background_color=”” background_image=”” background_position=”center center” background_repeat=”no-repeat” fade=”no” background_parallax=”none” enable_mobile=”no” parallax_speed=”0.3″ background_blend_mode=”none” video_mp4=”” video_webm=”” video_ogv=”” video_url=”” video_aspect_ratio=”16:9″ video_loop=”yes” video_mute=”yes” video_preview_image=”” render_logics=”” absolute=”off” absolute_devices=”small,medium,large” sticky=”off” sticky_devices=”small-visibility,medium-visibility,large-visibility” sticky_background_color=”” sticky_height=”” sticky_offset=”” sticky_transition_offset=”0″ scroll_offset=”0″ animation_type=”” animation_direction=”left” animation_speed=”0.3″ animation_offset=”” filter_hue=”0″ filter_saturation=”100″ filter_brightness=”100″ filter_contrast=”100″ filter_invert=”0″ filter_sepia=”0″ filter_opacity=”100″ filter_blur=”0″ filter_hue_hover=”0″ filter_saturation_hover=”100″ filter_brightness_hover=”100″ filter_contrast_hover=”100″ filter_invert_hover=”0″ filter_sepia_hover=”0″ filter_opacity_hover=”100″ filter_blur_hover=”0″][fusion_builder_row][fusion_builder_column type=”1_1″ layout=”1_1″ align_self=”auto” content_layout=”column” align_content=”flex-start” valign_content=”flex-start” content_wrap=”wrap” spacing=”” center_content=”no” link=”” target=”_self” min_height=”” hide_on_mobile=”small-visibility,medium-visibility,large-visibility” sticky_display=”normal,sticky” class=”” id=”” background_image_id=”” type_medium=”” type_small=”” order_medium=”0″ order_small=”0″ spacing_left_medium=”” spacing_right_medium=”” spacing_left_small=”” spacing_right_small=”” spacing_left=”” spacing_right=”” margin_top_medium=”” margin_bottom_medium=”” margin_top_small=”” margin_bottom_small=”” margin_top=”” margin_bottom=”” padding_top_medium=”” padding_right_medium=”” padding_bottom_medium=”” padding_left_medium=”” padding_top_small=”” padding_right_small=”” padding_bottom_small=”” padding_left_small=”” padding_top=”20px” padding_right=”20px” padding_bottom=”20px” padding_left=”20px” hover_type=”none” border_sizes_top=”” border_sizes_right=”” border_sizes_bottom=”” border_sizes_left=”” border_color=”” border_style=”solid” border_radius_top_left=”” border_radius_top_right=”” border_radius_bottom_right=”” border_radius_bottom_left=”” box_shadow=”no” box_shadow_vertical=”” box_shadow_horizontal=”” box_shadow_blur=”0″ box_shadow_spread=”0″ box_shadow_color=”” box_shadow_style=”” background_type=”single” gradient_start_color=”” gradient_end_color=”” gradient_start_position=”0″ gradient_end_position=”100″ gradient_type=”linear” radial_direction=”center center” linear_angle=”180″ background_color=”” background_image=”” background_position=”left top” background_repeat=”no-repeat” background_blend_mode=”none” render_logics=”” filter_type=”regular” filter_hue=”0″ filter_saturation=”100″ filter_brightness=”100″ filter_contrast=”100″ filter_invert=”0″ filter_sepia=”0″ filter_opacity=”100″ filter_blur=”0″ filter_hue_hover=”0″ filter_saturation_hover=”100″ filter_brightness_hover=”100″ filter_contrast_hover=”100″ filter_invert_hover=”0″ filter_sepia_hover=”0″ filter_opacity_hover=”100″ filter_blur_hover=”0″ animation_type=”” animation_direction=”left” animation_speed=”0.3″ animation_offset=”” last=”true” border_position=”all” first=”true”][fusion_accordion type=”accordions” boxed_mode=”no” border_size=”1″ border_color=”” background_color=”” hover_color=”” divider_line=”” title_font_size=”” icon_size=”” icon_color=”” icon_boxed_mode=”” icon_box_color=”#4f4f4f” icon_alignment=”right” toggle_hover_accent_color=”#3ed9df” hide_on_mobile=”small-visibility,medium-visibility,large-visibility” class=”interview_list” id=””][fusion_toggle title=”Question 41: How do you insert a new worksheet in Excel?” open=”no” class=”” id=””]
Answer:
To insert a new worksheet, right-click on an existing worksheet tab and select “Insert” from the context menu. Choose the type of worksheet you want to insert and click “OK.”
[/fusion_toggle][fusion_toggle title=”Question 42: How do you freeze panes in Excel?” open=”no” class=”” id=””]
Answer:
To freeze panes, select the row below and column to the right of the area you want to freeze. Then, go to the “View” tab, click on “Freeze Panes,” and choose the desired option.
[/fusion_toggle][fusion_toggle title=”Question 43: How do you protect a worksheet in Excel?” open=”no” class=”” id=””]
Answer:
To protect a worksheet, go to the “Review” tab, click on “Protect Sheet,” and set a password if required. You can specify what actions users can perform on the protected sheet.
[/fusion_toggle][fusion_toggle title=”Question 44: How to build named ranges in Excel?” open=”no” class=”” id=””]
Answer:
To build named ranges in Excel, you can follow these steps:
- Select the range of cells that you want to name. This could be a single column, row, or a rectangular block of cells.
- Click on the “Formulas” tab in the Excel ribbon.
- In the “Defined Names” group, click on the “Name Manager” button. This will open the Name Manager dialog box.
- In the Name Manager dialog box, click on the “New” button. This will open the New Name dialog box.
- In the “Name” field, enter the name you want to assign to the selected range. Make sure the name is meaningful and easy to remember.
- In the “Refers to” field, you should see the range reference for the cells you previously selected. If it’s not already filled in, you can manually enter the range reference or click on the “Collapse Dialog” button and then select the desired range on the worksheet.
- Optionally, you can add a comment in the “Comment” field to provide additional information about the named range.
- Click on the “OK” button to create the named range.
[/fusion_toggle][fusion_toggle title=”Question 45: Explain what do you mean by a variant data type?” open=”no” class=”” id=””]
Answer:
In Excel, a variant data type refers to a type of data that can hold different types of values. Unlike other specific data types in Excel, such as numbers or text, a variant data type can be used to store various kinds of data, including numbers, text, dates, Boolean values (True/False), and even error values.
[/fusion_toggle][fusion_toggle title=”Question 46: Explain what is the meaning of “relative cell address.” ” open=”no” class=”” id=””]
Answer:
A “relative cell address” refers to the location of a cell within a spreadsheet or worksheet, expressed in relation to the position of another cell. In spreadsheet applications like Microsoft Excel or Google Sheets, each cell is identified by a unique combination of a column letter and a row number.
[/fusion_toggle][fusion_toggle title=”Question 47: what is the use of relative cell address?” open=”no” class=”” id=””]
Answer:
A relative cell address is typically used when referencing cells in formulas or functions. When a formula or function is entered into a cell, it can reference other cells to perform calculations or retrieve data. The relative cell address allows the formula or function to adjust its references automatically when copied or moved to different cells.
[/fusion_toggle][fusion_toggle title=”Question 48: Where is the code window in VBA located?” open=”no” class=”” id=””]
Answer:
In Microsoft Excel, the code window for writing VBA (Visual Basic for Applications) code is located within the Visual Basic Editor (VBE).
[/fusion_toggle][fusion_toggle title=”Question 49: Mention three core modules in VBA.” open=”no” class=”” id=””]
Answer:
In VBA (Visual Basic for Applications), there are several core modules that provide essential functionality. Below are three important modules commonly used in VBA programming:
- Code modules
- Class modules
- User forms
[/fusion_toggle][fusion_toggle title=”Question 50: What is the purpose of Flash Fill in Microsoft Excel?” open=”no” class=”” id=””]
Answer:
The purpose of Flash Fill is to save time and effort when working with large datasets. It analyzes the patterns in your data and automatically fills in values in a column based on the existing data.
[/fusion_toggle][fusion_toggle title=”Question 51: What is a NameBox in Microsoft Excel?” open=”no” class=”” id=””]
Answer:
A Name Box in Microsoft Excel is a feature that facilitates you to easily navigate to a specific cell or range of cells within a worksheet. It is located at the top-left corner of the Excel window, just above the column headers. It displays the address of the currently selected cell or range, such as “A1” or “B2:C5.” You can also use the Name Box to enter or edit the name of a defined range or a named cell in Excel.
[/fusion_toggle][fusion_toggle title=”Question 52: How can you perform a what-if analysis in the spreadsheet?” open=”no” class=”” id=””]
Answer:
Performing a what-if analysis in a spreadsheet typically involves using formulas, functions, and data tables to explore different scenarios and understand the impact of changing variables on the results. Here’s a general approach to performing a what-if analysis in a spreadsheet:
- Define your objectives
- Set up your spreadsheet
- Identify the variables
- Use formulas and functions
- Set up data tables
- Analyse the results
- Refine and iterate
[/fusion_toggle][fusion_toggle title=”Question 53: What do the AND and OR functions do in Excel?” open=”no” class=”” id=””]
Answer:
In Microsoft Excel, the AND and OR functions are logical functions that allow you to evaluate multiple conditions and return a result based on the outcome of those conditions.
[/fusion_toggle][fusion_toggle title=”Question 54: What function in Excel can you use to determine whether a day is a weekday?” open=”no” class=”” id=””]
Answer:
In Microsoft Excel, you can use the WEEKDAY function to determine if a day is a weekday or a weekend day. The WEEKDAY function returns a number representing the day of the week for a given date, where Sunday is considered the first day of the week (represented by 1) and Saturday is the last day of the week (represented by 7).
[/fusion_toggle][fusion_toggle title=”Question 55: How to outline a group of cells in Microsoft Excel?” open=”no” class=”” id=””]
Answer:
To outline a group of cells in Microsoft Excel, you can use the built-in outlining feature that allows you to collapse or expand rows or columns, making it easier to manage and view large sets of data. Here’s how you can outline a group of cells:
- Select the range of cells that you want to outline. You can do this by clicking and dragging the mouse over the desired cells.
- Once the cells are selected, go to the “Data” tab on the Excel ribbon.
- In the “Outline” group, you’ll find two buttons: “Group” and “Ungroup.” Click on the “Group” button.
- Excel will automatically add a collapsible outline to the left side of the selected rows or above the selected columns, depending on your selection. You will see small symbols indicating the outline level.
- To collapse or expand the outline, use the symbols. Clicking the “-” symbol collapses the group, hiding the details within it, while clicking the “+” symbol expands the group, showing the hidden details.
[/fusion_toggle][fusion_toggle title=”Question 56: How to lock cell references in a formula?” open=”no” class=”” id=””]
Answer:
To lock cell references in a formula in Microsoft Excel, you can use the dollar sign ($) to create absolute references. Absolute references prevent the cell references from changing when you copy or fill the formula to other cells.
[/fusion_toggle][fusion_toggle title=”Question 57: What is the significance of the SUBTOTAL function?” open=”no” class=”” id=””]
Answer:
The SUBTOTAL function is a powerful tool in spreadsheet software, commonly used in programs like Microsoft Excel or Google Sheets. It calculates a subtotal of a range of values based on specified criteria or operations. Below are some key points regarding the significance of the SUBTOTAL function:
- Automatic exclusion of subtotals
- Enhanced data analysis
- Dynamic range inclusion
- Conditional calculations
[/fusion_toggle][fusion_toggle title=”Question 58: Why use cross-tabulation in excel?” open=”no” class=”” id=””]
Answer:
Cross-tabulation, also known as a pivot table in Excel, is a powerful tool used for data analysis and summarization. It allows you to examine the relationships between two or more variables in a dataset and provides a structured way to analyze and present the data.
[/fusion_toggle][fusion_toggle title=”Question 59: How would you add notes to a cell in Microsoft Excel?” open=”no” class=”” id=””]
Answer:
To add notes to a cell in Microsoft Excel, follow these steps:
- Open your Excel worksheet and navigate to the desired cell where you want to add the note.
- Right-click on the cell and select “Insert Comment” from the context menu. Alternatively, you can select the cell and go to the “Review” tab in the Excel ribbon, then click on the “New Comment” button.
- A small text box will appear next to the selected cell, where you can enter your note or comment. Type the desired text into the comment box.
- Once you have entered your note, you can resize the comment box by clicking and dragging the edges to make it larger or smaller.
- By default, the comment will be displayed when you hover over the cell with the mouse cursor. If you want the comment to always be visible, right-click on the comment box, select “Show/Hide Comment,” and the comment will stay visible on the cell.
- To edit the comment, right-click on the cell, select “Edit Comment” from the context menu, and make the necessary changes.
- To delete the comment, right-click on the cell, select “Delete Comment” from the context menu, and the comment will be removed.
[/fusion_toggle][fusion_toggle title=”Question 60: How many cells are in Microsoft Excel?” open=”no” class=”” id=””]
Answer:
From Excel 2007 onwards (Excel 2007, 2010, 2013, 2016, 2019, and Microsoft 365), the maximum number of rows increased to 1,048,576, while the number of columns remained at 256. This expansion allows for a total of 268,435,456 cells in a single worksheet.
[/fusion_toggle][/fusion_accordion][/fusion_builder_column][/fusion_builder_row][/fusion_builder_container]
