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

• A macro is an automated sequence of commands used to perform repetitive tasks quickly in software applications.
• It saves time by executing multiple steps with a single command.
• Commonly used in MS Word, Excel, and other office software.
• It can be recorded or programmed by the user.

Last verified on 21-06-2026

Explanation

• =SUM(A1:A10) is the formula used to calculate the sum of cells A1 through A10.
• The SUM function adds values in a specified range of cells.
• It is one of the most commonly used spreadsheet functions.
• The colon (:) indicates a continuous range of cells.
• It works in spreadsheet software like Excel and Google Sheets.

Last verified on 08-06-2026

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