Hi Folks,

Hope you all are doing well!

Please try to answer the below question:-

Question:- What is the use of IFERROR function in MS Excel?

Thank You

Hi Folks,
You all tried very well and have given different replies.
Expecting more to come.

Thanks

IFERROR

▶️ Iferror is a function that provides alternate results like blank or text when there is an error in the function.

I hope you all are aligned with this.

Thank You

Hi Folks,

Hope you all are doing well and enjoyed the last question !

Please try to answer the question below:-

Question:- What is the use of a UNIQUE function in MS Excel?

Thank You

UNIQUE

➡️Unique is a function which helps to remove duplicate and provide only unique values in an array.

I hope you all are aligned with this.

Thank You

*Shortcut Keys*


1. Create a new workbook. Ctrl + N.
2. Open an existing workbook. Ctrl + O.
3. Save a workbook/spreadsheet. Ctrl + S.
4. Close the current workbook. Ctrl + W.
5. Close Excel. Ctrl + F4.
6. Move to the next sheet. Ctrl + PageDown.
7. Move to the previous sheet. Ctrl + PageUp.

Shortcut keys

Question: - What is Paste in Excel?
Answer: - Paste is a feature provided by M.S. Office to Cut or Copy content from one location or document to another location of Document.

Question: - What is “Paste Special in Excel?
Answer: - “Paste Special” is same as “Paste” which is available in M.S. Office. “Paste Special” will help to copy or cut and paste the content from one location to another location with different formatting.
As options given in below picture which will discuss one by one in coming days: -

➡️Question: -
Shortcut key for “Paste Special”.
➡️Answer: -
Ctrl + Alt + V
Alt + E + S

❗️Note: - This “Paste Special” only works if you have copied or cut some data.