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.

Dear Friends,
Please share your valuable suggestions and share this channel with your friends and please subscribe.
Thank you