Microsoft Excel MCQ

The correct order from largest to smallest is: Workspace → Workbook → Worksheet → Cell. Workspace is the entire application, a Workbook is a file, a Worksheet is a tab inside the file, and a Cell is a single box on the worksheet.

1,048,576 rows is the maximum in Excel 2007 and later (.xlsx format). The older .xls format (Excel 97–2003) had a limit of only 65,536 rows.

16,384 columns (labelled up to XFD) is the maximum in Excel 2007+. The older .xls format supported only 256 columns (up to column IV).

The Formula bar is located just above the column headers and shows the exact content or formula of the active cell. The Name box (to the left of the formula bar) shows the cell address.

A cell address always follows the format Column letter + Row number. So B5 means Column B, Row 5. This is fundamental to navigating and referencing cells.

.xlsx is the standard Excel format introduced in Office 2007 (XML-based). .xls is the older binary format. .xlsm is for Excel files containing macros. .ods is LibreOffice Calc's format.

.xlsx is the standard Excel format introduced in Office 2007 (XML-based). .xls is the older binary format. .xlsm is for Excel files containing macros. .ods is LibreOffice Calc's format.

The Status bar is at the very bottom of the spreadsheet window. It shows quick statistics of selected cells (SUM, COUNT, AVERAGE), the current cell mode, and the zoom level.

Ctrl+1 opens the Format Cells dialog box, which has 6 tabs: Number, Alignment, Font, Border, Fill, and Protection.

There are exactly 6 tabs in the Format Cells dialog: Number, Alignment, Font, Border, Fill, and Protection.

The Fill tab (previously called Patterns in older versions) is used to set the background color and pattern of a cell. Font tab controls text appearance; Border controls cell borders.

Paste Special (Ctrl+Alt+V) allows you to paste only certain attributes: values only (removes formulas), formats only, formulas only, or even transpose rows and columns.

Navigation pane is a feature of word processors (like MS Word), not spreadsheets. The standard spreadsheet elements include the Formula bar, Name box, Status bar, Ribbon, Sheet tabs, and Scrollbars.

The Name box is located at the left end of the Formula bar. It displays the address of the currently active cell (e.g. A1, B3). It can also be used to navigate directly to a cell by typing its address.

By default, Excel creates 3 worksheets (Sheet1, Sheet2, Sheet3) in a new workbook. However, this can be changed in Excel Options → General → 'Include this many sheets'. Note that newer versions of Excel may default to 1 sheet.