1.
What is the purpose of the IF formula in Excel?
2.
How do you remove formulas and keep the values in Excel?
3.
If you need to remove unwanted columns from a dataset in Excel, what should you do?
4.
After using Ctrl + C to copy data, which option do you use to paste values only in Excel?
5.
What formula would you use to replace negative values with zero?
6.
What is the shortcut to copy a selection in Excel?
7.
How can you paste values using the ribbon in Excel?
8.
How do you apply Flash Fill to separate city and pin code data in Excel?
9.
Which shortcut key is used to insert a new worksheet in Excel?
10.
Which method allows you to split data based on a delimiter, such as a space or a comma?
