## Answer for common question in Excel test for interview

This page list answers for some common question in an Excel test for interview. This page will be updated regularly to ensure it’s most updated accuracy. Please come back regularly or consider to have this page bookmarked. Common question in an Excel test for interview 1) What is Microsoft Excel? Microsoft Excel is software that … Read more

## ABS function – How to get absolute value in excel

This blog explains how to get absolute value in Excel using the ABS function with syntax and examples. How to get absolute value in Excel? The Microsoft Excel ABS function returns the absolute value of a number. What is an absolute value? The absolute value represents its value without its sign. For example: Value Absolute Value … Read more

I have created an excel based Multiplication Time Table practice 20 x 20 program.  This Multiplication Table practice is mainly designed for kids in their primary school. Download from here.   Following is the instruction: Enter the answer in the white area If the answer is correct, it will automatically change the background colour to green. … Read more

## How to replace words in excel? Substitute or replace in excel?

How to replace words in excel? You can use two different functions – substitute and replace. Difference between substitute and replace are shown from the following table. SUBSTITUTE function in excel The substitute function in excel is to replace a text within a cell by a new text Syntax SUBSTITUTE(text,old_text_new_text,[Instance_num]) Argument Argument Description text The … Read more

## Getpivotdata – an easier and better way to reference a pivot table in Excel

From my other blog I have illustrated how to create a pivot table. How to read information from a pivot table Now I am going to mention how to refer information from a pivot table. There are two ways to do the job refer to the corresponding cells  (e.g. = a10) using the “GetPivotData” function … Read more

## How to Create Pivot Table in Excel

This video illustrated hot to create pivot table in excel. What is a Pivot Table? A pivot table is an excel report that quickly summarise a large amount of data. It automatically performs sort, count, total or average of data stored in the spreadsheet and displays result as a report. Usually, the reports will be … Read more

## Difference between all 5 count functions (COUNT, COUNTA, COUNTIF, COUNTIFS and COUNTBLANK) in Excel.

What is the difference between COUNT, COUNTA, COUNTIF, COUNTIFS and COUNTBLANK in Ms-Excel? Suppose we have a table like this.   Different type of count functions The following table illustrated the differences between each function: Usage Count Count number of cells that have numbers or values CountA count any cell value containing numbers, text, logical values, … Read more

## How to use if function with multiple conditions and outcomes in Excel

This paragraph is original in English. From my last blog, we have introduced the if function in Excel where following is the syntax: Syntax: if function with multiple conditions and outcomes What if we have multiple conditions? Can we use the if function with multiple conditions? The answer is “Yes”. There are two ways to … Read more

## How to change report formats in Excel

From my last blog, I have mentioned how to create pivot table in excel. Now, let’s go through different kinds report formats in Excel pivot table. There are three types of report formats in Excel Pivot Table: Compact Form Outline Form Tabular Form Suppose we have a pivot table with the following report fields. Following is … Read more

## How to merge cells in Excel without losing data in 2 steps

Merge cells in Excel can be as easy as one click. However, how to merge cells in Excel without losing data? Before discussing how to merge cells in Excel without losing data. Let’s call over how to merge cells in Excel. How to Merge Cells in Excel As mentioned, merge cells in Excel cab be … Read more