MS Excel Questions and Answers

Answer: D

Correct answer: All of the above

Copying is available from the Edit menu, from the right-click shortcut menu, from the toolbar buttons and from the keyboard - four routes to the same command.

Answer: B

Correct answer: Using the Tools – Wizard – Web Form menu item

Italics can be applied with Ctrl + I, with the Italic button on the Formatting toolbar, or through Format → Cells → Font. The Tools → Wizard → Web Form command builds a web form and has nothing to do with character formatting, so it is the one that will not italicise the selection.

Answer: B

Correct answer: repeat chosen rows or columns on every printed page

Print Titles repeats chosen rows or columns on every printed page - typically the header row of a long table, so that a reader of page seven still knows what each column contains. It is set from Page Setup on the Page Layout tab, where Rows to repeat at top and Columns to repeat at left take a reference such as $1:$1. It is frequently confused with Freeze Panes, and the distinction is worth fixing: Freeze Panes affects only the screen and has no effect whatever on printing, while Print Titles affects only printing and does nothing on screen. A long table usually wants both. The neighbouring print controls are worth knowing together. Print Area restricts what is printed. Fit to scales the sheet to a set number of pages. Page Break Preview shows and lets you drag the page boundaries. And Print Gridlines and Print Headings add the grid and the row and column labels, neither of which prints by default.

Answer: B

Correct answer: 256

A worksheet in Excel up to 2003 has 256 columns, A to IV. Excel 2007 raised it to 16,384.

Answer: B

Correct answer: Right clicking the current slide

During a slide show the toolbars are hidden. Right-clicking anywhere on the slide raises the show’s shortcut menu, with Next, Previous, Go to Slide, Pointer Options, Screen and End Show. The formatting toolbar is not on screen during a show, so there is no button to click.

Answer: A

Correct answer: Enter

Enter commits what has been typed and moves to the next cell. Ctrl + Enter commits it to every cell of a selection at once, and Esc abandons it.

Answer: D

Correct answer: All of the above

Documentation should record where the input comes from, where the output goes and who uses it, and what the workbook is for - everything a person who did not build it would need.

Answer: D

Correct answer: You can not set page border in Excel

Excel has cell borders but no page border: the page setup offers margins, headers, footers and gridlines, and nothing that draws a frame round the sheet. That is a Word feature.

Answer: D

Correct answer: b and c

The organization chart object is placed by the presentation design, which fixes its default size - but that size is not locked: you can drag its handles to resize it, and it also grows or shrinks with the amount of text the chart holds. So both the “determined by the design but can be changed” statement and the “dependent on the amount of text” statement are true, which is why the combined choice is right and the “cannot be changed” option is wrong.

Answer: B

Correct answer: Select column E

Inserted columns appear before the selection, so selecting column E puts the new column between D and E. To insert three, select three columns starting at E.