Explanation

• The DATEDIF() function in Excel calculates the difference between two dates.
• It can return difference in days, months, or years.
• For whole days, it uses the “D” unit.
• It is useful for age calculation and date analysis.

Last verified on 29-05-2026

Explanation

• In MS Excel, most data tools are found in the Data tab.
• What-If Analysis, Data Validation, and Text to Columns are all part of Data tools.
• PivotTable is located in the Insert tab, not Data tab.
• It is used for summarizing and analyzing large datasets.

Last verified on 29-05-2026

Explanation

• To show the gridlines, in Excel, PowerPoint, or Word, click the View tab, and then check the Gridlines box.
• To hide the gridlines, clear the Gridlines check box.
• The keyboard shortcut to remove the gridlines is to press Alt and enter W, V, G.

Last verified on 29-05-2026

Explanation

• In MS Excel, different workbook views are available to change how data is displayed.
• Page Break Preview is found in the View tab.
• It helps users see how pages will be printed.
• It is useful for adjusting print layout.

Last verified on 29-05-2026

Explanation

• Pressing F2 allows you to edit the contents or formula of the current cell in MS Excel.

Additional information:

• F4: Repeat last action / toggle absolute and relative references
• CTRL + 1: Opens Format Cells dialog
• CTRL + F: Opens Find dialog
• Works in: Excel 2007, 2010, 2013, 2016, 2019, 365

Last verified on 12-03-2026