MS Excel Questions and Answers

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.

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.

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.

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.

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.

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.

Answer: D

Correct answer: Data

Sort is a data command, along with Filter, Subtotals, Validation and PivotTable.

Answer: D

Correct answer: Tools

Track Changes and the Highlight Changes dialog are under Tools, with the other shared-workbook commands.

Answer: C

Correct answer: Indentation can be set from Format Cells dialog box

Excel does have indentation: it is on the Alignment tab of Format Cells, and there are also increase and decrease indent buttons on the toolbar.

Answer: D

Correct answer: all of above

Page Break Preview shows the breaks as movable blue lines over the sheet, so they can be seen, dragged, added, removed, and the print area resized by dragging its boundary.