MS Excel Questions and Answers

Answer: A

Correct answer: Esc key

Pressing Esc ends the slide show and returns to the editing view, so it is the one key listed that does not move you forward. The spacebar, the Enter key and a click of the mouse all advance to the next slide or next animation.

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: C

Correct answer: Use comments

Insert → Comment attaches a note to a slide and stamps it automatically with the reviewer’s name and the date, taken from the User Information settings - nothing has to be typed by hand. The notes page is free text with no author or date, and online collaboration is a meeting facility rather than a way of recording remarks.

Answer: C

Correct answer: Keeps chosen rows or columns visible while the rest of the sheet scrolls

Freeze Panes, on the View tab, keeps chosen rows or columns in view while the rest of the sheet scrolls beneath them. Its usual purpose is to hold a header row visible while working far down a long list. The rule for what gets frozen is worth knowing precisely: everything above and to the left of the selected cell is frozen. Selecting B2 therefore freezes row 1 and column A together. The menu also offers Freeze Top Row and Freeze First Column directly, without any selection. It affects only the display and nothing else - not editing, not calculation, not printing. For printing, the equivalent is Print Titles on the Page Layout tab, which repeats chosen rows or columns on every printed page. The two are frequently confused, and freezing panes has no effect at all on the printed output. Split, alongside it, divides the window into independently scrollable panes instead.

Answer: A

Correct answer: Multiplies corresponding items in the given arrays and adds the products

SUMPRODUCT multiplies corresponding elements of two or more ranges and adds the results. =SUMPRODUCT(A1:A10,B1:B10) is the standard way to total quantity times price without a helper column. Its wider usefulness comes from a second property: it handles arrays without needing Ctrl + Shift + Enter. Because a logical test returns TRUE or FALSE, which behave as 1 and 0 in arithmetic, conditions can be embedded directly. =SUMPRODUCT((A1:A10="Delhi")*(B1:B10>100)) counts rows meeting both conditions, and multiplying by a third range totals them. That made it the standard multi-condition tool before COUNTIFS and SUMIFS existed, and it remains more flexible than either, since its conditions can be any expression rather than a criteria string. All ranges must be the same size, or it returns #VALUE!. Text is treated as zero, which is why an unexpected zero usually means a column of numbers stored as text.

Answer: B

Correct answer: Microsoft online

The animated GIFs supplied for PowerPoint live in the online clip collection - the Clips Online link in the Clip Art task pane, which opens Microsoft’s Design Gallery Live. The clip art installed with Word holds still images, and there is no “PowerPoint tools and ins” gallery.

Answer: B

Correct answer: apply an animation scheme

An animation scheme is a ready-made set of coordinated effects that can be applied to the selected slides - or to all of them - in one click, which is by far the quickest way to animate text across a deck. The Custom Animation pane gives finer control but has to be set up effect by effect.

Answer: B

Correct answer: Apply an entrance effect, and then set it to by letter in the effect option dialog box

Give the text an entrance effect in the Custom Animation pane, then open Effect Options → Text Animation and set Animate text: By letter. The animation then plays one character at a time. Slowing a Fly In only makes the whole block move more slowly, and the fade scheme animates by paragraph.

Answer: C

Correct answer: Double click the application control menu icon

Double-clicking the application control-menu icon at the top-left of the PowerPoint window closes the program. Minimizing only hides it, and the document close button or the document control menu closes the presentation while PowerPoint stays open.

Answer: C

Correct answer: Clicking file open

New presentations are created by the New button, by File > New, or by Ctrl + N. File > Open opens an existing one, which is the opposite operation.