MS Excel Questions and Answers

Q: Special category of Number tab in Format Cells dialog box can be used to apply formats like

Correct answer: Both of aboveThe Special category holds formats for values that are strings of digits rather than quantities - postal codes, telephone numbers, social security numbers - so that leading zeros and separators are preserved.

Q: In MS Excel, what is the maximum number of rows in a worksheet in recent versions?

Correct answer: 1,048,576A worksheet holds 1,048,576 rows and 16,384 columns, running from A to XFD. Both figures are powers of two: \( 2^{20} \) rows and \( 2^{14} \) columns. The limits were raised with the .xlsx format in Excel 2007. The older .xls format held 65,536 rows and 256 columns, which is why the second option is offered - and why opening a large modern file in an old version truncates it. The shortcut Ctrl + Down Arrow jumps to the last row of a contiguous block, and from an empty column to the very bottom of the sheet, which is how the limit is seen directly. Ctrl + End goes to the last used cell - a figure that often exceeds the real data, because Excel remembers cells that once held content. These are limits of the grid, not of the practical size of a workbook: performance falls well before a million rows, and genuinely large data belongs in a database or in Power Pivot.

Q: Formatting a cell in Currency, you can specify

Correct answer: Both of aboveThe Currency format lets you choose how many decimal places to show and which currency symbol to prefix, as well as how negatives are displayed.

Q: In MS Excel, which of these is a valid cell address?

Correct answer: XFD1048576XFD1048576 is the last cell of a modern worksheet: column XFD is the 16,384th and row 1,048,576 is the last. A cell address is always column letters followed by row number, which disqualifies 1A. Rows are numbered from 1, so A0 does not exist. And column letters run A to Z, then AA to ZZ, then AAA to XFD - three letters at most - so AAAA5 is beyond the grid. The lettering is a base-26 system: after Z comes AA, and after AZ comes BA. The 27th column is AA and the 703rd is AAA. Both limits are powers of two, \( 2^{14} \) columns and \( 2^{20} \) rows, raised from 256 and 65,536 when the .xlsx format arrived in Excel 2007. Ctrl + Right Arrow from an empty row travels to column XFD, and Ctrl + Down Arrow to the last row, which is the quickest way to see the boundary.

Q: Which option allows you to select line, curve, freeform or scribble tools?

Correct answer: Draw custom pathUnder Custom Animation, choosing Motion Paths → Draw Custom Path opens the four drawing tools: Line, Curve, Freeform and Scribble. Each lets you trace the route an object travels across the slide. Insert motion path only offers the ready-made paths, and there is no Create effect command.

Q: When creating a vertical page break

Correct answer: The active cell must be in row 1A vertical page break is inserted to the left of the active cell and runs the full height of the sheet. Selecting a cell in row 1 gives a purely vertical break; a cell further down would produce a horizontal break as well.

Q: You can open the Sort dialog box by choosing Sort from the ….. menu

Correct answer: DataSort is a data command, along with Filter, Subtotals, Validation and PivotTable.

Q: You can open the Highlight Changes dialog box by choosing Track Changes from the …. Menu.

Correct answer: ToolsTrack Changes and the Highlight Changes dialog are under Tools, with the other shared-workbook commands.

251.

Special category of Number tab in Format Cells dialog box can be used to apply formats like

A.Zip Code
B.Phone Number
C.Both of above
D.None of above

Answer: C

Correct answer: Both of above

The Special category holds formats for values that are strings of digits rather than quantities - postal codes, telephone numbers, social security numbers - so that leading zeros and separators are preserved.

Discuss in Forum

252.

In MS Excel, what is the maximum number of rows in a worksheet in recent versions?

A.1,048,576
B.65,536
C.32,767
D.16,384

Answer: A

Correct answer: 1,048,576

A worksheet holds 1,048,576 rows and 16,384 columns, running from A to XFD. Both figures are powers of two: \( 2^{20} \) rows and \( 2^{14} \) columns. The limits were raised with the .xlsx format in Excel 2007. The older .xls format held 65,536 rows and 256 columns, which is why the second option is offered - and why opening a large modern file in an old version truncates it. The shortcut Ctrl + Down Arrow jumps to the last row of a contiguous block, and from an empty column to the very bottom of the sheet, which is how the limit is seen directly. Ctrl + End goes to the last used cell - a figure that often exceeds the real data, because Excel remembers cells that once held content. These are limits of the grid, not of the practical size of a workbook: performance falls well before a million rows, and genuinely large data belongs in a database or in Power Pivot.

Discuss in Forum

253.

Formatting a cell in Currency, you can specify

A.Decimal Places
B.Currency Symbol
C.Both of above
D.None of above

Answer: C

Correct answer: Both of above

The Currency format lets you choose how many decimal places to show and which currency symbol to prefix, as well as how negatives are displayed.

Discuss in Forum

254.

In MS Excel, which of these is a valid cell address?

A.XFD1048576
B.A0
C.1A
D.AAAA5

Answer: C

Correct answer: XFD1048576

XFD1048576 is the last cell of a modern worksheet: column XFD is the 16,384th and row 1,048,576 is the last. A cell address is always column letters followed by row number, which disqualifies 1A. Rows are numbered from 1, so A0 does not exist. And column letters run A to Z, then AA to ZZ, then AAA to XFD - three letters at most - so AAAA5 is beyond the grid. The lettering is a base-26 system: after Z comes AA, and after AZ comes BA. The 27th column is AA and the 703rd is AAA. Both limits are powers of two, \( 2^{14} \) columns and \( 2^{20} \) rows, raised from 256 and 65,536 when the .xlsx format arrived in Excel 2007. Ctrl + Right Arrow from an empty row travels to column XFD, and Ctrl + Down Arrow to the last row, which is the quickest way to see the boundary.

Discuss in Forum

255.

Which option allows you to select line, curve, freeform or scribble tools?

A.Create effect
B.Insert motion path
C.Draw custom path
D.All of the above

Answer: C

Correct answer: Draw custom path

Under Custom Animation, choosing Motion Paths → Draw Custom Path opens the four drawing tools: Line, Curve, Freeform and Scribble. Each lets you trace the route an object travels across the slide. Insert motion path only offers the ready-made paths, and there is no Create effect command.

Discuss in Forum

256.

When creating a vertical page break

A.The active cell must be A1
B.The active cell can be anywhere in the worksheet
C.The active cell must be in row 1
D.The active cell must be in column A

Answer: C

Correct answer: The active cell must be in row 1

A vertical page break is inserted to the left of the active cell and runs the full height of the sheet. Selecting a cell in row 1 gives a purely vertical break; a cell further down would produce a horizontal break as well.

Discuss in Forum

257.

In MS Excel, the Solver add-in is used to

A.find the best values for several inputs subject to constraints
B.solve a single equation for one unknown
C.check formulas for errors
D.convert text formulas into results

Answer: B

Correct answer: find the best values for several inputs subject to constraints

Solver is an optimisation tool. It adjusts several input cells at once to maximise, minimise or hit a target in an objective cell, while respecting constraints that may be placed on any of them. It is an add-in rather than a built-in feature and must be enabled from File, Options, Add-ins before it appears on the Data tab. Its relationship to Goal Seek is the point most often examined. Goal Seek changes exactly one cell to reach an exact target, with no constraints. Solver changes many, accepts constraints such as total hours must not exceed 40 or quantities must be whole numbers, and can seek a maximum or minimum rather than a specific value. Typical uses are production planning, portfolio allocation, staff rostering and transport routing - the classic linear-programming problems. It offers several solving methods, and the Simplex method is chosen where the model is genuinely linear.

Discuss in Forum

258.

Your German supplier still invoices for parts in deutsche marks. How can you have Excel convert those sums to Euros?

A.On the Insert menu, click Symbol and from the currency symbols subset, select the Euro sign.
B.On the tools menu, click Add-Ins, and select the Euro Currency Tools check box
C.Apply a selected background color
D.All of above

Answer: B

Correct answer: On the tools menu, click Add-Ins, and select the Euro Currency Tools

Currency conversion is not built into Excel; it comes from the Euro Currency Tools add-in, which supplies the EUROCONVERT function and the fixed conversion rates. Inserting a symbol changes only the appearance of a number.