Excel Job Interview Questions Answers

Excel Job interview questions answers

If you are searching Microsoft Excel Job interview questions answers then keep reading this article. You can use Ctrl + F to find the answer to your specific topic.

In this article, I will try my best to include all possible questions with their answers that anyone can ask during a job interview for Excel.

If you know the computer office work then you can get a suitable job

What is Microsoft Excel?

Microsoft Excel is the family member of Microsoft Office.  It is an electronic spreadsheet where you can store,  manage, calculate, organize,  format and print data.

Microsoft Excel saves your time with its flexibility and formulas.

Excel spreadsheet includes rows and columns. Each cell has a unique address which helps you to apply formulas

It can also import the external databases and give you calculated and formatted output.

Click here to learn Microsoft Excel complete in details

What is the electronic spreadsheet?

It is the combination of rows and columns. A cell pointer which you use to set the position for typing the data.

What is the difference in Save and Save As?

Save

If are you saving your Microsoft Excel sheet very first time then the computer will ask you

File Name

File type

Saving location

Other Options

When you will save the file then next time this save menu cant open by saving command then you need to use Save As command for this purpose.

Save As

Save As plays an important role in the computer field. It saves lots of time. For example, you have created a result sheet for class 9 and you want to create another result sheet for class 10th.

So it would be easy to use Save As to get the duplicate file with other name and location that you can easily modify.

How many data formats we use in Excel?

There are 12 types of data formats we can use in Excel.

General

This format is normally activated by default. Which we use to type a simple numeric value in the cell

Number

To format the number such as decimal places

Currency

You can use this for adding currency symbol with the amount.

Accounting

You can set the decimal points and currency symbols in a column.

Date

If you apply this format in a specific range. Then as you type the

numeric value, the computer will change it into a date value.

Time

Same as the date we can use time format to calculate time in he

specific range

Percentage

By using this format you can calculate the percent of the specific

range, where you have applied this percentage format.

Fraction

To get the values in the form of a fraction in a range.

Scientific

Use this format to type the numeric value scientifically or you can

convert already typed value too

Text

If you use this format then the computer will treat all your data as a text either you type any numeric value too.

Special

To set the format for zip code, phone number etc

Custom

You can easily modify the format into your own way.

What is Ribbon in Microsoft Excel?

On top of the excel sheet, you can see the ribbons which include different commands. you can customize the ribbon and add new commands.

How many report formats are available in Microsoft Excel?

Following 3 types of report, formats are available

  1. Compact
  2. Report
  3. Tabular

How can we freeze a specific area in Microsoft Excel?

We can freeze the sheet from the cell pointer position. So All the sheet will scroll into that frozen area.

We use to activate this from view tab or from the Windows menu. The command name is Freeze Panes. different versions have different options for this command.

What is the use of COUNT, COUNTA, COUNTIF and COUNTBLANK in Ms Excel?

COUNT

To count the total number of values in the specified range except for text.

COUNTA or Count All

It will count any all numbers, text, logical values, etc. any type of value excluding blanks.

COUNTBLANK

You can use this to count blank cells or cells with an empty string.

COUNTIF and COUNTIFS

Both functions we can use to count the matching criteria in a specific range.

What is the use of Macro in Microsoft Excel?

Macro is a group of commands and functions that we can store in a set of keys.

There are two macro languages ​​that we can use in Excel in Visual Basic applications which are XLM and VBA.

How can you prevent others from copying the MS Excel sheet?

From the Review tab, you can use the Protect Sheet and set the password.

How to sum all the value in a column or row with a single click?

By clicking on the Auto Sum icon you can get the sum of all values in the columns and rows.

How to insert a new row or column in Excel Sheet?

Where you want to insert the row or column right-click the mouse, then click on the Insert and click on what you want to insert.

You can also use Alt + I + C for inserting column and Alt + I + R for the row.

The short cut for inserting columns and row is  Ctrl + Shift + =.

 What does PEMDAS stand for?

  • Parentheses
  • Exponent
  • Multiplication
  • Division
  • Addition
  • Subtraction

Parenthesis ( ) in Microsoft Excel we use parenthesis in our formulas like

=sum(A1+A2)

Exponent

Multiplication To get the result of multiplying of numeric value

=sum(A1*A2)            or         =A1*A2          =sum(2*3)      =2*3

 

Division To get the result of dividing of numeric value

=sum(A1/A2)             or         =A1/A2           =sum(10/2)    =10/2

Addition  To getting the result of adding the numeric value

=sum(A1+A2)           or         =A1+A2          =sum(10+2)               or         =10+2

To add the value in the series from A1 to A10

=sum(A1:A10)

Subtraction To get the result of subtracting the numeric value

=sum(A1-A2)            or         =A1-A2           =sum(10-2)    =10-2

What are the math functions in Microsoft Excel?

SUM()

We use this function to add the numeric values.

To add the value in the range

=SUM(CellAddress:CellAddress)

=SUM(A1:A10)

To add the value of different cells

=SUM(A1+C12+D9)

“You can use a comma (,) instead of plus symbols in the formula like

=SUM(A1,C12,D9)

=SUM(2,3,4)

SUMIF()

To add the numeric value in range with specific criteria.

=SUMIF(Range,Criteria,Range)

AVERAGE()

To calculate the average

=AVERAGE(Start Cell Address:End Cell Address)

=AVERAGE(A1:A10)

We can use the AVERAGEIF() and AVERAGEIFS() function the same as we used SUMIF() function to get the average of specific criteria.

COUNT()

Count the numeric value

ROUND()

To round the after decimal value with a specific digit.

=ROUND(Decimal Value, Number of digits to round)

Suppose you have 24.943 value in C10) and you want to round it in 0 digit

=ROUND(C10,0)

25

and round the value with the 1 digits

=ROUND(C10,1)

24.9

with 2 digits

=ROUND(C10,2)

24.94

INT()

This function will remove the value after decimal point like

10.9 after using =INT(10.9) it will be 10

ABS()

to get the absolute value

=ABS(5-10)

5

if you will solve this equation with SUM then the result will be

=SUM(5-10)

-5

VLOOKUP()

In Excel, VLOOKUP allows fetching the database on criteria.

=VLOOKUP(lookup value,table array,col index)

How to remove duplicates in Excel?

  1. Select the range
  2. Click on Data
  3. Then click on Remove Duplicates

How to protect Excel Sheet?

There are three ways to apply for protection in Ms Excel.

  1. Protection on Ope Excel Sheet.

Asking password before opening the sheet.

Save the file with password. from Tool Options in the Save As. You can get this option with pressing F12 if you want to set a password on the already saved file.

  1. Protect Ms Excel Sheet.

            Make the sheet read-only to modify you need to enter the password.

In the sheet Click on Review and then choose Protect Sheet, set your password

  1. Specific cells protection.

Allow specific cell for editing

  • Select the cells you can use Ctrl to select  multi cells
  • Uncheck the Locked from the protection tab under the font menu
  • Set password in Protect Sheet under the Review Tab.

How to use a Pivot Table in Microsoft Excel?

We use a pivot table to summarize the data with a specific record.

Step 1. Select the data with headers

Step 2. Click on Pivot Table under the Inset Tab

Step 3. Click on New Workbook then Click on the OK

 How to use Charts in Ms Excel?

  • Select the range
  • Under the Insert, Tab Click on the chart option from the charts section

SiteMap

Spread the love

2 thoughts on “Excel Job Interview Questions Answers

Leave a Reply

Your email address will not be published. Required fields are marked *

Rana Mehtab Alam Lunar Computer College. WhatsApp +923004467226