MS Excel Questions and Answers

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.

Answer: A

Correct answer: Use the browse feature in the slide design task pane to find the file that has your design template and apply it to the current file

The Slide Design task pane ends with a Browse… link that opens any presentation or template file and applies its design to the current one, carrying over colours, fonts and masters intact. Copying a slide brings that slide’s design only as a side effect and can leave two masters in the file, and saving under a new name gives you a copy of the whole presentation rather than a reusable design.

Answer: D

Correct answer: Copy the worksheet

The basic steps are to enter the text and data, modify the layout, and save the workbook. Copying a worksheet is something you may do afterwards, not part of creating one.

Answer: C

Correct answer: the small square at the corner of a selection used to copy or extend a series

The Fill Handle is the small square at the bottom right corner of a selection. Dragging it copies the contents into adjacent cells, or extends a recognised series. It recognises a great many patterns. Dragging a single date advances it by a day; dragging Jan produces the months; dragging Monday produces the days. Entering two values first - 5 and 10 - establishes the step, so the fill continues 15, 20 and so on. Double-clicking the handle fills down as far as the adjacent column has data, which is much faster than dragging on a long list. Formulas filled this way have their relative references adjusted, which is exactly the behaviour absolute references with dollar signs exist to prevent. The Auto Fill Options button that appears afterwards offers to copy without formatting, fill formatting only, or fill as a series - useful when the default guess is wrong.

Answer: D

Correct answer: Networkdays

NETWORKDAYS returns the number of whole working days between two dates, excluding weekends and any holidays given to it. WORKDAY does the reverse - it returns the date a given number of working days away.

Answer: D

Correct answer: a and b

Dragging a selection moves it; holding Ctrl while dragging copies it. There is no drag gesture that adds contents to what is already there.