面试题与答案

The order of sequence of operating is BEDMAS

• Brackets
• Exponents
• Division
• Multiplication
• Addition
• Subtraction

Like IF function, AND function also does the logical function. To check whether the output will be true or false the AND function will evaluate at least one mathematical expression located in another cell in the spreadsheet. If you want to see the final result or output of more than one cells in single cell it is possible by using AND function.

Example: If you have two cells, A1 and A2, and the value you put in those two cells are >5 and you want result should display as ‘TRUE’ in cell B1 if value>5,   and ‘False’ if any of those values<5. You can use AND function to do that.

COUNT: COUNT is used to count cells containing numbers, dates, etc. any value stored as number excluding blanks.

COUNTA: COUNTAor Count All is used to count any cell value containing numbers, text, logical values, etc. any type of value excluding blanks.

COUNTBLANK: It counts blank cells or cells with an empty string.

COUNTIF and COUNTIFS: These count cells matching a certain criteria.

• Compact
• Report
• Tabular

To disable the automating sorting in pivot tables,

Go to >  “More Sort Options”> Right Click  “Pivot table” > Select “Sort” menu > Select  “ More Options” >  Deselect the “ Sort automatically when the report is created”.

The “What If” condition is used to change the data in Microsoft excel formulas to give different answers.

Example: You are buying a new car and want to calculate the exact amount of tax that will be levied on it then you can use the “What If” function.  For instance there is three cells A4,B4 and C4. First cell says about the amount, second cell will tell about the percentage (7.5%)  of tax and final cell will calculate the exact amount of tax.

To perform the logic test IF function is performed. It checks whether certain conditions is true or false. If the condition is true then it will give result accordingly if the condition is false then the result or out-put will be different.

Example: For example, you select the cell and you want to display that cell as “Greater than five”, when value is true (=5 or 5) and “less than five” when value is false( <5 ). For that by using IF condition you can display result.

=IF (Logical test, value if true, value if false)

=IF (A1>5, “Greater than five, “Less than five”)

Format loss in pivot table can be stopped simply by changing the pivot table options.  Under the “Pivot Table Options” turn on the “Enable Preserve Formatting” and disable “ Auto Format” option.