MS Excel Questions and Answers

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.

Answer: C

Correct answer: The ctrl key and mouse

Ctrl with the mouse picks out sheets that are not next to each other; Shift selects a contiguous run of tabs. Grouped sheets then receive the same entries and formatting together.

Answer: A

Correct answer: Select both cells, and then drag the fill handle over the range you want, for instance 18 more cells

Two cells establish the step, and dragging the fill handle continues it. One cell alone would be copied rather than extended, since Excel would have no interval to work from.