Microsoft Excel Interview Questions

Introduction to Excel
Microsoft Excel Interview Questions

Introduction to Excel

Microsoft Excel or MS Excel over the years has become more so a skill than an application. Although it is very underrated, the importance it has in daily life of a working professional is very significant. Listed are some of the most important Excel interview questions, you should learn answers for.

Microsoft Excel Interview Questions

What is MS Excel?

Microsoft Excel, also commonly denoted as MS Excel, is a widely used application of Microsoft Office. It is an electronic spreadsheet that enables users to store, organize and analyze data in the format of a table. Users can work on MS Excel with Microsoft Windows and Mac OS operating systems on their computers. It is also available as a mobile application on Android and iOS platforms. It is commercially used by businesses as a part of MS Office Suite.

How to remove duplicates in Excel?

To remove duplicated in Excel, follow these steps –

Select the range of cells that you want to remove.
Click Data.
Under the columns in the Data Group, click Remove Duplicates.
Check or uncheck the columns where you want to remove duplicates.
Click OK.
A message will appear showing how many duplicates were removed.

How to calculate percentage in Excel?

Follow these steps to calculate percentage in Excel spreadsheet–

Select the desired cell to display the percentage.
Start by typing an equal (‘=’) sign.
Apply the basic formula for percentage which is = part/total.
Type A1/A2 and hit Enter.
Click Home and select the percent (% ) symbol from the numbers group.
The result will be displayed as decimal fractions.

How to freeze rows in excel?

Select the rows you want to freeze.
Click View in the main menu.
Go to the Ribbon, click ‘Freeze Panes’, and then again click ‘Freeze Panes.’

How to merge cells in excel?

Select the cell you want to merge the combined data.
Click on the first cell and select the range you want to merge.
Click Home.
Select “Merge & Center” from the menu.

How to convert pdf to excel?

Open the PDF document you want to convert in XLSX format in Acrobat DC.
Go to the right pane and click on the “Export PDF” option.
Choose spreadsheet as the Export format.
Select “Microsoft Excel Workbook.”
Now click “Export.”
Download the converted file or share it.

How to enable macros in excel?

Click the file tab and then click “Options.”
A dialog box will appear. In the “Excel Options” dialog box, click on the “Trust Center” and then “Trust Center Settings.”
Go to the “Macro Settings” and select “enable all macros.”
Click OK to apply the macro settings.

How to convert excel to pdf?

Select the MS Excel file you want to convert to PDF.
Click on the File menu on the top-left corner.
It will open an Export Panel. Click “Export” from the menu.
Look for “Create PDF/XPS document.”
On the “Options” tab, you can adjust the settings accordingly.
Choose the PDF options to save the spreadsheet as a PDF.
Under the tab “Publish What,” choose Active Sheet(s) if you wish to save the entire worksheet as PDF or select “Selection” if you wish to save the selected area as PDF.
Click OK to continue.
Choose the folder location to save the new file.
Name the file and hit “publish.” The new file will be saved as a PDF file.

How to change date format in excel?

First, select the cells containing the date.
Right-click on the mouse or keypad and select “Format” cells.
Go to the “Number” tab and select “Custom.”
Then type the date format you want in the Type box.
Click OK to continue.
It will format the selected dates.

How to add drop down in excel?

Here is how to create a drop-down list in Excel –

Select the cells you want to contain in the drop-down list.
Go to ribbon and click “Data,” then “Data Validation.”
In the dialog box, select “Allow to List.”
Click on Source and type the numbers or text that you want in your drop-down lists.
Click OK to continue.
Note that commas should separate the numbers and texts.

Check out this online excel course to get started with MS Excel

How to use VLOOKUP in excel?

Click the cell where you want the VLOOKUP formula to be calculated.
Go to the top of the screen and click “Formulas.”
Click on “Lookup and Reference” on the ribbon.
At the bottom of the drop-down menu, look for VLOOKUP.
Select the cell in which you want to apply the formula.
A VLOOKUP dialog box will open; specify the data you want to use for search in the “Table_array” box.
Specify the column number.
Specify “Range_Lookup” by entering either True or False. If you want an exact match, enter FALSE.
Click OK to continue.
Now enter the value for the data you are searching for.
VLOOKUP will automatically produce the desired result.

Check out this Excel VLOOKUP course to learn VLOOKUP in detail.

How to split cells in excel?

Select the cell or cells with the data you want to split.
Click the “Layout” tab.
Click “Split Cells” in the Merge group tab.
A dialog will appear. In the Split Cells dialog, enter the number of columns and rows you want.
Click OK to save changes.
The cell will be split into fragments.

How to multiply in excel?

The easiest way to multiple in Excel is by using a simple formula for multiplication using the asterisk symbol. It enables users to multiply individuals cells and numbers. All you have to do is separate them by commas. To multiply a series, use a colon.

For example, using the formula – “=PRODUCT (A1, A2:A5, B1,12)”, Excel will multiply (A1XA2XA3XA4XA5XB1X12). Here, A2:A5 indicates that it should multiply A2, A3, A4, and A5.

Another way to do multiplication in Excel is using the following steps –

Type “=” in a cell.
Click the first cell containing the number you want to multiply.
Type “*”.
Now, click the second cell.
Press Enter. The result of multiplication will appear.

How to unprotect an excel sheet?

Go to “File.”
Select Info>Protect>Unprotect Sheet
You can skip this step and also do the changes from the Review tab. Go to Changes>Unprotect Sheet.
Enter the password to proceed in case the sheet is password protected.
Otherwise, click OK to continue.

How to subtract in excel?

Select the cell where you want the subtraction result to appear.
Start by typing “=” in the cell.
Apply the subtraction formula. Enter this syntax – “=MINUS(value1value2) where Value 1 and Value 2 can be numbers, cells, dates, etc.
Press the Enter key.
The difference between the values will appear in that cell.

How to convert numbers to words in excel in rupees?

Select a cell adjacent to the cell you want the currency (Rupees) to be converted into words.
Enter the formula – NumberstoWords(A1) and press Enter. A1 is the cell containing the currency in Rupees.
Press Enter to confirm the formula.

How to round off in excel?

You can use the ROUNDUP function to round off in Excel. Here is how –

Select a blank cell.
Use the ROUND function by entering the syntax – “=ROUNDUP(number,num_digits).

Where number denotes the number to round up and num_digits refers to a number of digits to which it should be rounded up.

Press Return.

Using the button, you can round off in Excel by following these steps –

Select the cells you want to round off.
Go to the Home tab, click Increase Decimal or Decrease Decimal.
Press Enter.

How to unhide rows in excel?

Follow these steps to unhide hidden rows in Excel –

Navigate to the Home tab.
Go to the right side of the toolbar and click “Format.”
Go to the “Visibility” section.
Hover over “Hide & Unhide.”
Select “Unhide Rows” from the menu.
Press Enter.

How to find percentages in excel?

Follow these steps to show a number as percent in Excel –

Select the cells you want to format.
Navigate to the ribbon’s Home tab and locate the Numbers group.
Click the “Percent style” button.
You can increase or decrease the percentage as you like.

What is VLOOKUP in excel?

VLOOKUP is an acronym for Vertical Lookup in Excel. It is a function that looks up a certain value in a column, like a name, number, or data, and returns with the corresponding value from a different column in the same row.

For example, using the VLOOKUP function, you can look up the first name and return the salary corresponding to that name. It should be noted that the VLOOKUP function is case-sensitive.

How to find duplicates in excel?

Select the cells you want to check for duplicates.
Navigate to Home. Click “Conditional Formatting.”
Then click Highlight Cells Rules> Duplicate Values.
Pick the formatting you want to apply the duplicate values in the box.
Click OK to continue.

How to make a graph in excel?

Start by selecting the data for which you want to create a graph.
Choose from the suitable graph options.
Highlight the data.
Click “Insert” and choose your desired graph from “Recommended Charts.”
Adjust the layout or colors as per your preferences.
Click Ok to continue.

How to compare two columns in excel?

You can compare two columns in Excel using the simple IF formula. The syntax to be used is – “=IF(A2=B2,”Match,” Mismatch”)

If the values to be compared are case-sensitive, use the following formula –

=IF(EXACT(A2,B2),”Match”,”Mismatch”)

How to remove blank rows in excel?

Delete blank rows in Excel using these steps –

Navigate to the Home tab.
Go to the “Editing Group” and click “Find & Select.”
Click “Go to special.”
Select the blank rows and click OK.
Click “Delete.”
Click “Delete Sheet Rows” and press Enter.

How to learn excel?

You can learn Excel with the help of various online courses, most of which are usually available for free. Once you learn the basics, you can start practicing some of the easiest Maths problems in Excel, creating tables and charts. You can also opt for an advanced online course to learn and earn Microsoft Excel Specialist certification.

How to remove the formula in excel?

Select the cells or rows that contain the formula.
Go to the Home tab and the “Editing Group.”
Click “Find & Select” and then “Go To.
Click “Special” and then “Current Array.”
Press DELETE.

How to add in excel?

One of the easiest ways to do addition in Excel is using the feature AutoSum. Here is how to do it –

Click on an empty cell.
Go to the “Formula” tab and click “Autosum”>Sum.
The sum will appear in the result.

How to remove space in excel?

To remove extra spaces in Excel –

Press Ctrl+Space to select cells in a column.
Open the “Find & Replace” dialog box using the shortcut Ctrl+H.
In the “Find What” field, press the spacebar.
Leave the “Replace with” field empty.
Click on “Replace all” and press OK. All spaces will be removed.

How to calculate age in excel?

The easiest way to calculate age in MS Excel is using the formula –

“=DATEDIF(birth_date,as_of_date,”y”)”

The result will be the number of complete years.

How to calculate average in excel?

Click on the empty cell below the cells containing numbers you want to find the average.
Navigate to the “Home” tab and go to the “Editing Group.”
Click the arrow next to the “Autosum.”
Click Average and press Enter.

How to remove scroll lock in excel?

Click on the Settings>Select Ease of Access>Keyboard.
Use the On-screen keyboard or use the shortcut Windows logo key + Ctrl + O.
Click the “ScrLk” button.
Right-click from your mouse or keypad.
You can click on the status bar to either display or hide the scroll lock.

How to compare two excel sheets?

You can easily compare two excel sheets using the “view side by side” option. It is recommended while comparing small datasets manually. In the case of a large dataset, it is best to use the formula method.

Using the “View side by side” option –

Open the files and select the sheets you want to compare.
Click the “View” tab.
Click the “View Side By Side” option in the Windows group.
When you click OK, Excel will arrange both the sheets to be viewed horizontally, and you can compare them side by side.

How to lock cells in excel?

Here are the steps to lock cells in Excel for protection and added security –

Select the cells you want to lock.
Go to the “home” tab and navigate to the “Alignment” group.
Click on the arrow, and it will open the “Format Cells” dialog box.
Go to the “Protection” tab and select the “Loaded” checkbox.
Click OK to continue.

How many rows and columns are in excel?

There are 1,048,576 rows and 16,384 columns in a Microsoft Excel sheet, along with 1,026 horizontal and vertical page breaks.

How to search in excel?

To search for something in Excel, use these steps –

Navigate to the “Home” tab and click “Find & Select.”
Go to Find>Find What, and a box will appear.
Type the text or numbers you want to search or find.
Click “Find Next,” and it will run your search.
The search will return the results.

What is the shortcut to change small letters to capital letters in excel?

You can use the shortcut key Shift + F3 to change the text from lowercase to uppercase and vice versa.

How to filter in excel?

Select the desired cell.
Go to “Data” and click “Filter” in the Sort & Filter group.
Select the column header. It will display a list with filter choices.
Select between “Text Filters” or “Number Filters” in the list.
Select a Comparison and enter the filter criteria.
Click Ok to see changes.

How to use pivot table in excel?

Click the desired cell.
Click Insert > PivotTable.
The “Create PivotTable” dialog box will appear.
Select a table or range as per your requirement.
Select either the New worksheet or the Existing worksheet under the “Choose where you want the PivotTable report to be placed” option.
After selecting the location for PivotTable to appear, click OK to continue.

How to sort in excel?

If you want to sort by column or row in the Excel sheet, follow these steps –

Select the desired cell in the data range.
Navigate to the “Data” tab.
Go to the “Sort & Filter” group and click “Sort.”
The “Sort” dialog box will appear. Go to “Column,” and under it, select the column you want to sort.
Select the type of sort under “Sort On.”
Select how you want to order under the option “Under Order.”
Click Ok to see the changes.

What is the extension of the saved file in ms excel?

Microsoft Excel saved file has a .xls extension. The XLS-based extension has been used as the default format for Microsoft Excel 1997-2003. Files saved in the .xlsx extension are associated with Microsoft Excel 2007-10.

How to unprotect an excel sheet without a password?

Navigate to the worksheet tab at the bottom of your screen.
Right-click on it and select “Unprotect Sheet” in the Context menu.
Click Unprotect sheet from the drop-down menu.
If the sheet is password-protected, Excel will ask you to enter the password.
Type the password and click OK to continue.

How to open the XML file in excel?

Open MS Excel.
Click File and then click Open.
Browse for the XML file and click on Open file.
A pop-up box with three options will open. Select the radio button with As an XML table option.
Click Ok to continue and open the XML file in Excel.

How to print an excel sheet?

Click the worksheet and select the range that you want to print.
Click File> Print.
Navigate to the “Settings” and click the arrow next to “Print Active Sheets.”
Select the option of your choice.
Click Print.

How to use if formula in excel?

The IF formula in Excel is used to run a logical test with one value for TRUE and the other for FALSE. The IF formula can be used in conjunction with AND and OR to test for a specific condition.

The IF formula can be used by incorporating the following syntax –

“=IF (logical_test, [value_if_true], [value_if_false])”

How to maintain stock in excel sheet format?

Navigate to the Search bar and type Inventory list.
Press Enter and a list of templates for inventory management will appear.
Select the inventory template that fit your requirement. It can be used to maintain stock in excel sheet format.

How to convert pdf to excel offline?

Open the PDF file.
Navigate to Tools and click on “Export PDF.”
Click on “Convert to.”
Select “Spreadsheet” as the export format.
Click on “Export” and save the file in Excel format.

How to remove drop down in excel?

Follow these steps to remove a drop-down list in Excel –

Select the cell with a drop-down list you want to remove.
In the case of multiple cells, click Ctrl + Left to select them all.
Click Data> Data validation.
Click Clear All on the settings tab.
Click OK to save the changes.

How to calculate EMI in excel?

EMI can be calculated in Excel using the simple formula –

“PMT (rate, nper, pv, [fv], [type])”

Where PMT – Payment;

Rate – the interest rate on the EMI;

Nper – total number of EMIs paid;

Pv – Present value or outstanding amount;

Fv (optional) – Future value or Cash balance;

Type (optional) – when payment is due. The default value is 0.

How to add a column in excel?

Right-click on the side where you want to add new columns.
Select “Insert Columns.”
Click Ok to continue.

How to convert text to number in excel?

Select the cells you want to convert from text to number.
Click the yellow diamond-shaped option.
A menu will appear. In the menu, select the “Convert to Number” option.

How to transpose in excel?

Select the range of cells.
Select the first cell to paste the data. Go to the Home tab, click the arrow next to Paste, and then click Transpose.
The copies data will overwrite the previous data.

How to separate text in excel?

Select the cells or the range of cells with text.
Navigate to Data, Click Data Tools> Text to Columns.
In the Text to Column, select Delimited.
Click Next and select the Delimiters for data.
Click Finish.

How to calculate standard deviation in excel?

To calculate standard deviation in Excel, use this formula –

“=STDEV.S(A2:A10)”

When the formula is applied, it will return the standard deviation of the data along with the average.

How to read excel files in Python?

You can read excel files in Python using the xlrd module. This module is used to retrieve information from the worksheet.

Import xlrd.
Give the location of the file.
Open the workbook – wb = xlrd.open_workbook(loc)
Run the python code to import and read the Excel file.

How to count characters in excel?

It is easy to count characters in Excel using the LEN function. It helps count numbers, characters, spaces, and letters.

Simply enter the LEN function in the formula bar using the syntax –

=LEN(cell)

Now, press Enter on the keyboard, and the count of characters will appear.

How to remove the page break in excel?

Select the sheet and go to the View tab.
Navigate to the Workbook Views group.
Click Page Break Preview.
On the Page Layout tab, navigate to the Page Setup Groups and click Breaks.
Click Remove Page Break.

For what purpose is excel function countif used?

Countif is the statistical function used to count the number of cells that meet a specific criterion within the range of the entered data.

How to divide in excel?

To divide in Excel, you can use the arithmetic operator – forward-slash (/) and the formula – “=A2/A3.”

How to increase cell size in excel?

Select the cell size you want to change.
Navigate to the Home tab and Cells.
Click Format.
Go to the Cell Size option and click Row Height.
Type the desired size or height in the Row Height box.
Click Ok to see the changes.

How to unhide columns in excel?

Navigate to the top left corner of your worksheet and spot the triangle icon.
Click on the triangle, and it will select the entire sheet.
Right-click anywhere on the sheet selection.
Choose the option “Unhide” from the menu.
You can see all hidden columns in Excel now.

How to use excel formulas?

Formulas in Excel are expressions that can make the calculation based on the information in your spreadsheet. The formula can be used in Excel by first selecting an empty cell where you want to enter the formula. The way to add formula syntax is by typing the “=” equal sign and then followed by operators to be used in the calculation.

The relevant operators used in the formula should be kept between opening and closing parenthesis. Press Enter to get the results.

What is macro in excel?

Macro refers to an algorithm or a set of actions that help automate a task in Excel by recording and playing back the steps taken to complete that task. Once the steps are stored, you create a Macro, and it can be edited and played back as many times as the user wants.

Macro is great for repetitive tasks and also eliminates errors. For example, suppose an account manager has to share reports regarding the company employees for non-payment of dues. In that case, it can be automated using a Macro and doing minor changes every month, as needed.

How to count text in excel?

The Countif function helps to count text in Excel. Here is how to do it using the formula to count text cells-

=COUNTIF(range;”*”)

How to remove hyperlinks in excel?

The easiest method to remove hyperlinks in Excel is by first selecting all the cells containing hyperlinks. It can be done using the shortcut Ctrl + A. Then, right-click anywhere on the selection and click “Remove Hyperlinks” from the menu. Click Ok to continue.

How to merge columns in excel?

Select the cells or range of cells you want to merge
Navigate to the Home tab and select the Format Cells button.
In the Format Cells dialog box, click on Alignment and then tick the box that says Merge Cells.
Click Ok to see the final changes.

How to freeze columns in excel?

Select a column to the right of the column you want to freeze.
Go to the View tab, select Windows Group.
Click on Freeze Panes to view the drop-down menu.
Select Freeze Panes from the drop-down.
Excel will freeze columns and mark a line to show the beginning of the frozen pane.

How to make an excel sheet?

You can make an Excel sheet using the keyboard shortcut Ctrl + N. The other method involves these steps –

Start by clicking on the File tab> Click New.
Go to Available Templates.
Double-click Blank Workbook to make an Excel sheet.

How to sort data in excel?

Select the range of cells you want to sort.
Go to the ribbon and select the Data tab.
Click Sort Command.
In the Sort dialog box, you can decide the sorting order – ascending or descending.
After the selection, press Ok to continue.
The selected column will sort the range.

How to enable macros in excel 2007?

Click Excel Options.
Click Trust Center> Trust Center Settings.
Click Macro Settings.
In Macro settings, disable all macros with notification.
Click Ok to continue.
The workbook will open with a security warning bar right below the ribbon.
Click Options on the Security Warning bar.
Click Enable this Content under Macros & ActiveX.

How to protect an excel sheet?

Select the worksheet you want to protect.
Navigate to the Review tab and click Protect Sheet.
A dialog box will open with the “Allow all users of this worksheet to” list.
Check “Protect worksheet and contents of locked cells.”
Check the options you want, such as “Select locked cells.”
Click OK to continue.

How to reduce excel file size?

There are many ways to reduce the file size of an Excel sheet. One way to reduce the sheet size further is by removing unwanted formulas, data, Pivot cache, worksheets, and formatting.

Another way to compress the file size is by either saving it as a binary file or a zip archive.

In addition to the above methods, there is another way to reduce sheet size without opening it. Here’s how to do it –

Right-click on the Excel file without opening it.
From the Context menu, choose Properties.
Select the Advanced button.
Choose the option “Compress contents to save the Disk space.”

How to password protect excel files?

Go to File and select Info.
In the Protect Workbook box, select Encrypt with Password.
Enter a password in the Password box.
Click OK to continue.
Re-confirm the password and click Ok again.

How to disable scroll lock in excel?

To disable scroll lock in Excel sheet, simply click on Start> Settings> Ease of Access> Keyboard. Use the on-screen keyboard and press the shortcut Windows logo + CTRL + O. Now click on the “ScrLk” button on the right side of the on-screen keyboard. The Screen lock will not be visible in the bottom left corner of the sheet.

How to split a cell in excel?

Click the cell you want to split.
Go to the Layout tab and Merge group.
Click Split Cells.
The Split Cells dialog will open up.
You can select the number of rows and columns you want to split.
Click OK to continue.

How to insert tick marks in excel?

Navigate to the Insert tab.
Go to the “Symbols” group.
In the Symbol dialog box, click on the drop-down menu.
Select Wingdings.
Select the symbol of your choice or the tick mark symbol.
Click Insert.
Click OK to continue.

How to wrap text in excel?

Go to the Home ribbon and the Alignment group.
Click Wrap Text.
Or you can also use the keyboard shortcut Alt + H + W after selecting the cell.
The data in the selected cells will be wrapped automatically to fit the column width.

How to normalize data in excel?

The normalization technique aims to change the numerical values of data and prepare it for Machine Learning. To normalize data in Excel means changing the values so that the mean of all values is zero and the standard deviation is 1.

First, find the data set’s mean by using the function =AVERAGE(range of values).
The next step is to find the standard deviation of the dataset by using the function =STDEV(range of values).
Now, to normalize the values, use the function STANDARDIZE(x, mean, standard_dev). It will normalize each value in the dataset.
Once you have normalized the first value in the cell (say B2), go to the right corner of the cell until a ‘+’ sign appears.
Double click on the ‘+’ and copy the formula to the remaining cells.
The Excel will normalize every value in the dataset.

How to update excel 2007?

To update Excel 2000 to the new version, simply follow these steps –

Open any app within Microsoft Office and create a new document.
Go to File> Account.
Navigate to the Product Information and choose Update options.
Click Update Now.
When “You’re up to date!” appears, close the window.
The updated version of Excel is ready to use.

How to insert multiple rows in excel?

To insert multiple rows in Excel, start by selecting the number of rows you want. You can also use the shift key on your keyboard to hold multiple rows at a time. Now, hold down the control key and click on the selection, the pop-up menu will appear. Click insert rows to continue.

How to convert excel to pdf in office 2010?

In MS Office 2010, you can convert Excel files to PDF format by following these steps –

Go to the File tab and select Save As.
You can select the folder to save the file in the Navigation pane.
Type the name in the File Name box.
Click on the Save As Type arrow and choose PDF format from the menu.
The Excel sheet will be saved as pdf.

How to write data in an excel sheet using java poi?

Create an empty workbook from the Excel sheet.

XSSFWorkbook workbook = new XSSFWorkbook();

Name the desired sheet.

XSSFSheet spreadsheet = workbook.createSheet(” Student Data “);

Start creating rows.

Row row = sheet.createRow(rownum++);

Now, start adding cells to the sheet.

Repeat the previous step until the data is complete.

How to calculate IRR in Excel?

IRR means Internal Rate of Return, and Excel’s IRR function is used to calculate it for cash flow scenarios, assuming they occur at regular intervals. IRR in Excel can be calculated using the formula IRR(values, [guess]).

Here, values refer to the range of cells representing series of cash flows for which we need to find IRR.

Guess is optional and refers to the projected internal rate of return. In most cases, guess is not required. The default value of guess is 0.1 (10%).

Example – to calculate IRR for cash flows in cells B2 and B4, use the formula :

=IRR(B2:B5)

Since IRR is calculated in percentage, make sure that the format of the formula cell is set to percentage to get the correct results.

How to remove the table in excel?

To remove the data in table format in Excel, you can simply remove the entire table by selecting the cells in that table first. Then click Clear and then select Clear All. Now, select the table and press DELETE to remove it.

How to convert excel to CSV?

Go to your worksheet and click File.
Click Save as.
Click Browse to choose the location where you want to save the file.
Now from Save as type drop-down menu, select CSV.
Click Save to continue.

How to delete empty rows in excel?

You can delete blank rows in Excel by first selecting those rows. Now use the Ctrl key on your keyboard and hold it while clicking on the selected row—Right-click on the selection and press Delete.

How to insert the rupee symbol in excel 2007 from the keyboard?

To insert the rupee symbol in Excel 2007 from the keyboard, use this shortcut. Press the Alt key on the left side of the keyboard and then type 8377. You will get the rupee symbol.

How to create a serial number generator in excel?

You can create serial numbers in Excel using the Autofill method. Here are the steps –

Insert value (let’s say 1) in a row and select it as the active cell.
You will notice that a small box or filler icon at the bottom right of the active cell will appear.
Double click on that box icon to drag to the desired cell.
Now go back to the second row and insert another value (let’s say 2).
Now select both the cells at once, and the box or filler icon will appear again.
Drag down the icon to the desired row, and you will notice that this time it shows serial numbers starting with the first value we inserted (1).

How to delete duplicate rows in excel?

Select the range of cells you want to remove duplicates from.
Go to the Data tab and select the Data Tools group.
Click Remove Duplicates.
Under columns, select one or more columns that contain duplicates.
Click ok to continue.

How to remove table format in excel?

Click on the Table.
Go to Table tools.
On the Ribbon, navigate to Design.
In the Tools group, click Convert to Range.
The table format will be no longer available, and it will be converted back to the range.

How to make a pie chart in excel?

Go to your worksheet and select the data to be used for creating a pie chart.
Click Insert> Insert Pie or Doughnut Chart.
After picking the chart you want, click the chart.
Click the icon next to the chart to customize and add finishing touches to it.

How to maintain accounts in excel sheet format?

You can maintain accounts in an Excel sheet by using its rows and columns for record-keeping and keep track of account-related information such as account numbers, invoicing, and receipt of payments.

The cells can be used to input client or account holder information. The expenses can be calculated using the formula =SUM (F3:F6). You can also use tools such as expense tracking tools and contract tools for auto-invoicing, performing tracking, and billing of expenses.

To enhance your knowledge of excel you can sign up for professional courses designed and delivered by the best industry professionals.