Download all datasets (Zip File)
What is the difference between relative & absolute referencing?
How do you freeze panes in MS Excel?
How to restrict someone from modifying data in a worksheet?
What is the order of operations used in MS Excel while evaluating formulas?
How will you write the formula for this?
What is the difference between count, counta, and countblank?
What is the shortcut to add a filter to a data table?
How to create a hyperlink in MS Excel?
How can we merge multiple text strings in MS Excel?
How can you split a column into 2 or more columns?
How to create a dropdown list in MS Excel?
How to apply advanced filters in MS Excel?
Using the below-given sales data, highlight those cells where total sales > $500
How to find duplicate values in a column?
How to remove duplicate values from a range of cells?
What is Data Validation? Illustrate with an example.
How to calculate your age in years from the current date?
How to get today's date in MS Excel?
How to password protect a MS Excel file?
what is the use of name manager in MS Excel?
How to protect the workbook structure in MS Excel?
How to fill cells with all dates in a year from today till 31 December?
How to replace a word with another word in MS Excel?
How to select all empty cells in a dataset?
How to add multi-level sorting to a dataset in MS Excel?
How to show all formulas in a sheet in MS Excel?
How to display the formula of one cell in another cell?
How to create a heat map in MS Excel?
How to create a sparkline chart in MS Excel?
How to print a row on all pages of your data?
How to use wildcards in MS Excel?
What is Format Painter in MS Excel used for?
How can you clear the formatting of cells without deleting the cell data?
How to make cell data invisible in MS Excel?
How do you remove all extra spaces from a cell data?
What is the shortcut to insert a chart for the selected data in MS Excel?
How to insert a watermark in MS Excel?
What is the shortcut to select an entire row or a column?
How to calculate your age in years from the current date?
How to change the default font & font size in MS Excel?
How can you split a column into 2 or more columns?
