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