Explanation

Most Important Questions about MS Office

Explanation

Important Information about MS Excel

1.      Default name of a newly created MS Excel file is? → Book1

2.      Default extension of an MS Excel workbook is? → .xlsx

3.      Default worksheet name is? → Sheet1

4.      Default font in modern MS Excel is? → Calibri

5.      Default font size in MS Excel is? → 11

6.      Default page orientation in MS Excel is? → Portrait

7.      Default zoom level in MS Excel is? → 100%

8.      Default file format in MS Excel (2007 and later) is? → .xlsx

9.      Default text alignment for text is? → Left

10.  Default alignment for numbers is? → Right

11.  Default row height is? → 15 points

12.  Default column width is? → 8.43 characters

Explanation

• MATCH function returns the position of a value in a given range.
• It searches for a value in a list or range.
• It returns the relative position (index) of that value.
• It does not return the value itself, only its location.
• It is commonly used in Excel for lookup operations.

Last verified on 07-06-2026

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

• In MS Excel, Paste Special is used to paste only specific parts like values, formulas, or formats.
• The correct shortcut in Ribbon-based Excel is Alt + H + V + S.
• It opens the Paste Special dialog box.
• From there, you can choose different paste options.

Last verified on 29-05-2026

Explanation

• A Pivot Table is a powerful Excel tool used for data analysis.
• It summarizes large datasets into meaningful reports.
• It helps in identifying trends, comparisons, and patterns easily.

Last verified on 29-05-2026

Explanation

• The VLOOKUP is used when data is listed in columns.
• This function searches for a value in the left-most column.
• You can use VLOOKUP to find data in a sorted or unsorted table.
• VLOOKUP stands for Vertical Lookup function.

Last verified on 29-05-2026