MS Excel Questions and Answers

Answer: C

Correct answer: counts the cells in a range that meet a given condition

COUNTIF counts the cells in a range that satisfy one condition: =COUNTIF(A1:A100,"Delhi") counts how many entries are Delhi, and =COUNTIF(B1:B100,">50") counts the values above fifty. The condition is given as text, which is why comparison operators must be inside quotation marks. Wildcards are allowed: ? stands for one character and * for any number, so "D*" matches every entry beginning with D. Its relatives complete the family. SUMIF adds rather than counts. AVERAGEIF averages. The plural forms - COUNTIFS, SUMIFS, AVERAGEIFS - take several conditions at once, and note that SUMIFS reverses the argument order, putting the sum range first. The plain COUNT counts numeric entries only, COUNTA counts any non-empty cell, and COUNTBLANK counts the empty ones.

Answer: C

Correct answer: Both of above

A condition may test the cell's own value against a comparison, or evaluate a formula that returns TRUE or FALSE - the second allowing a cell to be formatted according to what is in some other cell.

Answer: B

Correct answer: Press the shift key and click the handout master view button

Holding Shift while clicking a view button at the bottom-left of the window switches to the corresponding master instead of the ordinary view - Shift + Slide Sorter gives Handout Master, Shift + Normal gives Slide Master. Without Shift the same button gives the ordinary view.

Answer: D

Correct answer: Pivot Table Report

The Pivot Table Report is one of the Office Web Components, so that a pivot table published to a web page remains interactive and can still be pivoted and filtered in the browser.

Answer: A

Correct answer: Point to speech on the tools menu, and then click show text to speech toolbar

Text to Speech is reached from Tools > Speech, which displays a toolbar with a speak on enter button. Speech recognition, on the same submenu, is the opposite feature.

Answer: C

Correct answer: Tools

Sheet and workbook protection are under Tools > Protection, along with the workbook sharing commands.

Answer: B

Correct answer: Insert > Comments

A comment is something added to a cell, so it is on the Insert menu. Shift + F2 does the same from the keyboard.

Answer: D

Correct answer: All of above

While a cell is being edited the formula bar shows three buttons: the cancel cross, the enter tick, and the edit formula equals sign that opens the formula palette.

Answer: B

Correct answer: Removes extra spaces from text, leaving single spaces between words

TRIM removes leading and trailing spaces and reduces any run of spaces between words to one. It does not shorten text in any other way. It matters because data imported from another system routinely carries invisible surplus spaces, and a trailing space is enough to make a lookup fail or two apparently identical entries count as different. Wrapping a lookup value in TRIM is a standard defensive habit. Its limitation is that it removes only the ordinary space character. Text copied from a web page often contains a non-breaking space, character 160, which TRIM leaves untouched - the usual remedy is =TRIM(SUBSTITUTE(A1,CHAR(160)," ")). CLEAN is its companion, removing non-printing control characters. The second option describes LEFT or MID, and the fourth is done with Go To Special or a filter.

Answer: C

Correct answer: Notes

The left panel of the PowerPoint window offers the Outline and Slides tabs. Speaker notes appear in the pane below the slide, not as a tab beside it.