{{ Excel basic to advanced interview question }}
1. What do you mean by cells in an Excel sheet?
total numbaar of columns are aat 16000384, rows that avelble in excel are 10lak 48000576,
cell will be 10 lakh forty wight thousand five hunderd aand seventy six ceoss 16384
2. What is Microsoft Excel?
Microsoft Excel is a powerful spreadsheet program developed by Microsoft that is used for organizing, manipulating, and analyzing data.
3. What is a workbook in Excel?
A workbook is a collection of one or more worksheets within a single file in Excel.
4. What are some common formatting options in Excel?
Some common formatting options in Excel include font size, font style, font color, number format, cell borders, and shading.
5. How do you copy and paste data in Excel?
To copy and paste data in Excel, select the data that you want to copy, press Ctrl+C, select the cell
where you want to paste the data, and then press Ctrl+V.
6. What is the SUM function in Excel?
The SUM function in Excel is used to add up a range of numbers.7. How do you use the SUM function in Excel?
To use the SUM function in Excel, start by typing the equals sign (=) in the cell where you want to display
the result. Then, type “SUM(” followed by the range of cells that you want to add up and close the parentheses.
8. What is the COUNT function in Excel?
The COUNT function in Excel is used to count the number of cells in a range that contain numerical values.
9. How do you use the COUNT function in Excel?
To use the COUNT function in Excel, start by typing the equals sign (=) in the cell where you want to display
the result. Then, type “COUNT(” followed by the range of cells that you want to count and close the parentheses.
10. What is the AVERAGE function in Excel?
The AVERAGE function in Excel is used to calculate the average of a range of numbers.
11. How do you use the AVERAGE function in Excel?
To use the AVERAGE function in Excel, start by typing the equals sign (=) in the cell where you want to display
the result. Then, type “AVERAGE(” followed by the range of cells that you want to average and close the parentheses.
12. What is conditional formatting in Excel?
Conditional formatting is a feature in Excel that allows you to apply formatting to cells based on specific conditions.
13. How do you apply conditional formatting in Excel?
To apply conditional formatting in Excel, select the cells that you want to apply the formatting to and then
select the desired condition and formatting options from the Conditional Formatting menu on the Home tab of the Ribbon.
14. What is a pivot table in Excel?
A pivot table is a powerful tool in Excel that allows you to summarize and analyze large amounts of data.
15. How do you create a pivot table in Excel?
To create a pivot table in Excel, select the data that you want to summarize and then click on the PivotTable
button on the Insert tab of the Ribbon. Follow the steps in the PivotTable wizard to set up your pivot table.
16. What is a chart in Excel?
A chart is a graphical representation of data in Excel that allows you to visualize trends and patterns.
17. How do you create a chart in Excel?
To create a chart in Excel, select the data that you want to include in the chart and then click on the
desired chart type on the Insert tab of the Ribbon. Follow the steps in the Chart Wizard to customize your chart.
18. What is a filter in Excel?
A filter is a tool in Excel that allows you to display only the data that meets specific criteria.
19. How do you apply a filter in Excel?
To apply a filter in Excel, select the data that you want to filter and then click on the Filter button
on the Data tab of the Ribbon. Follow the steps in the Filter dialog box to set up your filter.
20. What is a validation rule in Excel?
A validation rule is a feature in Excel that allows you to control what data can be entered into a cell.
21. How do you create a validation rule in Excel?
To create a validation rule in Excel, select the cell where you want to apply the rule and then click on the
Data Validation button on the Data tab of the Ribbon. Follow the steps in the Data Validation dialog box to set up your validation rule.
22. What is a named range in Excel?
A named range is a group of cells in Excel that have been given a descriptive name.
23. How do you create a named range in Excel?
To create a named range in Excel, select the cells that you want to name and then click on the Define Name
button on the Formulas tab of the Ribbon. Follow the steps in the Define Name dialog box to set up your named range.
24. What is a macro in Excel?
A macro is a series of commands and actions that can be recorded and then played back in Excel.
25. How do you create a macro in Excel?
To create a macro in Excel, click on the Developer tab of the Ribbon and then click on the Record Macro button.
Follow the steps in the Record Macro dialog box to record your macro.
26. What is a relative cell reference in Excel?
A relative cell reference is a cell reference in a formula that is relative to the position of the formula.
For example, if you copy a formula that contains a relative cell reference from one cell to another, the cell references in the formula will adjust based on their new location.
27. What is an absolute cell reference in Excel?
An absolute cell reference is a cell reference in a formula that does not change when the formula is copied
to another cell. An absolute cell reference is indicated by a dollar sign ($) before the column and/or row reference.
28. What is a mixed cell reference in Excel?
A mixed cell reference is a cell reference in a formula that has either an absolute column reference or an
absolute row reference, but not both. For example, $A1 is a mixed cell reference.
29. What is the difference between a formula and a function in Excel?
A formula is an equation that performs calculations on the data in your Excel spreadsheet, while a function
is a pre-built formula that performs a specific calculation in Excel.
30. What is a nested function in Excel?
A nested function is a function that is used as an argument inside another function in Excel.
31. What is the CONCATENATE function in Excel?
The CONCATENATE function in Excel is used to combine two or more text strings into a single cell.
32. How do you use the CONCATENATE function in Excel?
To use the CONCATENATE function in Excel, start by typing the equals sign (=) in the cell where you want
to display the result. Then, type “CONCATENATE(” followed by the text strings that you want to combine and close the parentheses.
33. What is the VLOOKUP function in Excel?
The VLOOKUP function in Excel is used to search for a specific value in a table and return a corresponding value in the same row.
34. How do you use the VLOOKUP function in Excel?
To use the VLOOKUP function in Excel, start by typing the equals sign (=) in the cell where you want to
display the result. Then, type “VLOOKUP(” followed by the value that you want to search for, the range of
cells that contains the lookup table, the column number that contains the value to return, and the “FALSE” argument
to indicate an exact match.
35. What is the HLOOKUP function in Excel?
The HLOOKUP function in Excel is similar to the VLOOKUP function, but it searches for a specific value in the
first row of a table and returns a corresponding value in the same column.
36. How do you use the HLOOKUP function in Excel?
To use the HLOOKUP function in Excel, start by typing the equals sign (=) in the cell where you want to display
the result. Then, type “HLOOKUP(” followed by the value that you want to search for, the range of cells that
contains the lookup table, the row number that contains the value to return, and the “FALSE” argument to indicate an exact match.
37. What is the IF function in Excel?
The IF function in Excel is used to test a condition and return one value if the condition is true and another
value if the condition is false.
38. How do you use the IF function in Excel?
To use the IF function in Excel, start by typing the equals sign (=) in the cell where you want to display the
result. Then, type “IF(” followed by the condition to test, the value to return if the condition is true, and
the value to return if the condition is false.
39. What is the COUNTIF function in Excel?
The COUNTIF function in Excel is used to count the number of cells in a range that meet a specific condition.
40. How do you use the COUNTIF function in Excel?
To use the COUNTIF function in Excel, start by typing the equals sign (=) in the cell where you want to display
the result. Then, type “COUNTIF(” followed by the range of cells you want to count and the condition to test.
41. What is the SUMIF function in Excel?
The SUMIF function in Excel is used to add up the values in a range of cells that meet a specific condition.
42. How do you use the SUMIF function in Excel?
To use the SUMIF function in Excel, start by typing the equals sign (=) in the cell where you want to display
the result. Then, type “SUMIF(” followed by the range of cells that you want to add up, the condition to test,
and the range of cells to add up.
43. What is the AVERAGEIF function in Excel?
The AVERAGEIF function in Excel is used to calculate the average of the values in a range of cells that meet a specific condition.
44. How do you use the AVERAGEIF function in Excel?
To use the AVERAGEIF function in Excel, start by typing the equals sign (=) in the cell where you want to display
the result. Then, type “AVERAGEIF(” followed by the range of cells that you want to average, the condition to test,
and the range of cells to average.
45. What is the MIN function in Excel?
The MIN function in Excel is used to find the smallest value in a range of cells.
46. How do you use the MIN function in Excel?
To use the MIN function in Excel, start by typing the equals sign (=) in the cell where you want to display the
result. Then, type “MIN(” followed by the range of cells that you want to find the minimum value for.
47. What is the MAX function in Excel?
The MAX function in Excel is used to find the largest value in a range of cells.
48. How do you use the MAX function in Excel?
To use the MAX function in Excel, start by typing the equals sign (=) in the cell where you want to display the
result. Then, type “MAX(” followed by the range of cells that you want to find the maximum value for.
49. What is the ROUND function in Excel?
The ROUND function in Excel is used to round a number to a specific number of decimal places.
50. How do you use the ROUND function in Excel?
To use the ROUND function in Excel, start by typing the equals sign (=) in the cell where you want to display
the result. Then, type “ROUND(” followed by the number that you want to round and the number of decimal places to round to.
51. What is the ROUNDUP function in Excel?
The ROUNDUP function in Excel is used to round a number up to a specific number of decimal places.
52. How do you use the ROUNDUP function in Excel?
To use the ROUNDUP function in Excel, start by typing the equals sign (=) in the cell where you want to display
the result. Then, type “ROUNDUP(” followed by the number that you want to round up and the number of decimal places to round to.
53. What is the ROUNDDOWN function in Excel?
The ROUNDDOWN function in Excel is used to round a number down to a specific number of decimal places.
54. How do you use the ROUNDDOWN function in Excel?
To use the ROUNDDOWN function in Excel, start by typing the equals sign (=) in the cell where you want to
display the result. Then, type “ROUNDDOWN(” followed by the number that you want to round down and the number
of decimal places to round to.
55. What is the TRIM function in Excel?
The TRIM function in Excel is used to remove extra spaces from text strings.
56. How do you use the TRIM function in Excel?
To use the TRIM function in Excel, start by typing the equals sign (=) in the cell where you want to display
the result. Then, type “TRIM(” followed by the text string that you want to trim and close the parentheses.
57. What is the LEN function in Excel?
The LEN function in Excel is used to count the number of characters in a text string.
58. How do you use the LEN function in Excel?
To use the LEN function in Excel, start by typing the equals sign (=) in the cell where you want to display the
result. Then, type “LEN(” followed by the text string that you want to count and close the parentheses.
59. What is the LEFT function in Excel?
The LEFT function in Excel is used to extract a specific number of characters from the beginning of a text string.
60. How do you use the LEFT function in Excel?
To use the LEFT function in Excel, start by typing the equals sign (=) in the cell where you want to display the
result. Then, type “LEFT(” followed by the text string that you want to extract from, the number of characters to
extract, and close the parentheses.
61. What is the RIGHT function in Excel?
The RIGHT function in Excel is used to extract a specific number of characters from the end of a text string.
62. How do you use the RIGHT function in Excel?
To use the RIGHT function in Excel, start by typing the equals sign (=) in the cell where you want to display
the result. Then, type “RIGHT(” followed by the text string that you want to extract from, the number of characters
to extract, and close the parentheses.
63. What is the MID function in Excel?
The MID function in Excel is used to extract a specific number of characters from the middle of a text string.
64. How do you use the MID function in Excel?
To use the MID function in Excel, start by typing the equals sign (=) in the cell where you want to display the
result. Then, type “MID(” followed by the text string that you want to extract from, the starting position of
the extraction, the number of characters to extract, and close the parentheses.
65. What is the CONCAT function in Excel?
The CONCAT function in Excel is used to combine two or more text strings into a single cell, similar to the CONCATENATE function.
66. How do you use the CONCAT function in Excel?
To use the CONCAT function in Excel, start by typing the equals sign (=) in the cell where you want to display
the result. Then, type “CONCAT(” followed by the text strings that you want to combine and close the parentheses.
67. What is the SUBSTITUTE function in Excel?
The SUBSTITUTE function in Excel is used to replace one text string with another within a larger text string.
68. How do you use the SUBSTITUTE function in Excel?
To use the SUBSTITUTE function in Excel, start by typing the equals sign (=) in the cell where you want to
display the result. Then, type “SUBSTITUTE(” followed by the text string that you want to replace, the new
text string, the text string that you want to replace it with, and the instance number of the replacement, and close the parentheses.
69. What is the FIND function in Excel?
The FIND function in Excel is used to find the position of a specific character or text string within a larger text string.
70. How do you use the FIND function in Excel?
To use the FIND function in Excel, start by typing the equals sign (=) in the cell where you want to display
the result. Then, type “FIND(” followed by the character or text string that you want to find, the text string
that you want to search within, and the starting position of the search (optional), and close the parentheses.
71. What is the REPLACE function in Excel?
The REPLACE function in Excel is used to replace a specific number of characters in a text string with a new text string.
72. How do you use the REPLACE function in Excel?
To use the REPLACE function in Excel, start by typing the equals sign (=) in the cell where you want to
display the result. Then, type “REPLACE(” followed by the text string that you want to replace characters
within, the starting position of the replacement, the number of characters to replace, and the new text
string to insert, and close the parentheses.
73. What is the UPPER function in Excel?
The UPPER function in Excel is used to convert text to uppercase letters.
74. How do you use the UPPER function in Excel?
To use the UPPER function in Excel, start by typing the equals sign (=) in the cell where you want to
display the result. Then, type “UPPER(” followed by the text string that you want to convert to uppercase
letters and close the parentheses.
75. What is the LOWER function in Excel?
The LOWER function in Excel is used to convert text to lowercase letters.
76. How do you use the LOWER function in Excel?
To use the LOWER function in Excel, start by typing the equals sign (=) in the cell where you want to
display the result. Then, type “LOWER(” followed by the text string that you want to convert to lowercase
letters and close the parentheses.
77. What is the PROPER function in Excel?
The PROPER function in Excel is used to convert text to proper case, which capitalizes the first letter of each word.
78. How do you use the PROPER function in Excel?
To use the PROPER function in Excel, start by typing the equals sign (=) in the cell where you want to
display the result. Then, type “PROPER(” followed by the text string that you want to convert to proper case and close the parentheses.
79. What is the LEFTB function in Excel?
The LEFTB function in Excel is similar to the LEFT function, but it is used to extract a specific number
of bytes from a text string instead of characters. This function is useful for working with non-Unicode
languages that use double-byte character sets.
80. How do you use the LEFTB function in Excel?
To use the LEFTB function in Excel, start by typing the equals sign (=) in the cell where you want to display
the result. Then, type “LEFTB(” followed by the text string that you want to extract from, the number of bytes
to extract, and close the parentheses.
81. What is the RIGHTB function in Excel?
The RIGHTB function in Excel is similar to the RIGHT function, but it is used to extract a specific number of
bytes from a text string instead of characters. This function works with non-Unicode languages that use double-byte character sets.
82. How do you use the RIGHTB function in Excel?
To use the RIGHTB function in Excel, start by typing the equals sign (=) in the cell where you want to display
the result. Then, type “RIGHTB(” followed by the text string that you want to extract from, the number of bytes
to extract, and close the parentheses.
83. What is the LENB function in Excel?
The LENB function in Excel is similar to the LEN function, but it counts the number of bytes in a text string
instead of characters. This function is useful for working with non-Unicode languages that use double-byte character sets.
84. How do you use the LENB function in Excel?
To use the LENB function in Excel, start by typing the equals sign (=) in the cell where you want to display
the result. Then, type “LENB(” followed by the text string that you want to count the bytes for and close the parentheses.
85. What is the CONCATENATEX function in Excel?
The CONCATENATEX function in Excel is used to combine values from a column into a single text string.
86. How do you use the CONCATENATEX function in Excel?
To use the CONCATENATEX function in Excel, start by typing the equals sign (=) in the cell where you want to
display the result. Then, type “CONCATENATEX(” followed by the delimiter (optional), the column that contains
the values to concatenate, and close the parentheses.
87. What is conditional formatting in Excel?
Conditional formatting in Excel is a feature that allows you to apply formatting to cells based on their
values or the values of other cells in your spreadsheet.
88. How do you use conditional formatting in Excel?
To use conditional formatting in Excel, select the cells you want to apply formatting to, then go to the
Home tab on the ribbon and click on the “Conditional Formatting” button. From there, you can choose from
various formatting options and set the conditions you want to trigger the formatting.
89. What is a pivot table in Excel?
A pivot table in Excel is a powerful tool for summarizing and analyzing large amounts of data. It allows
you to create custom reports by grouping and aggregating data based on different criteria.
90. How do you create a pivot table in Excel?
To create a pivot table in Excel, select the data you want to summarize. Then, go to the Insert tab o
n the ribbon and click the “PivotTable” button. From there, you can choose the pivot table’s location,
the fields you want to include, and the criteria for grouping and summarizing the data.
