MS Excel Questions and Answers

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

Correct answer: Slides

In the Print dialog, choosing the Slides option lets you type a range, and non-adjacent slides are entered as a comma-separated list - here 5,12. Current slide prints only the one on screen, and a custom show would have to be defined in advance.

Answer: B

Correct answer: Placed in a word table

An Excel range pasted into Word with an ordinary paste arrives as a Word table - the cells become table cells that Word formats and edits itself, with no connection back to the workbook. Linking and embedding are alternatives chosen through Paste Special, and a hyperlink would only point at the file.

Answer: C

Correct answer: Tools

In the classic menu interface a macro is run from Tools → Macro → Macros (Alt + F8), which lists the available macros and offers the Run button. The same submenu holds Record New Macro and the Visual Basic Editor. Insert, Format and Data have no macro commands.

Answer: D

Correct answer: Data

Consolidation gathers values from several ranges into one summary, so it sits with the other data-analysis commands: Data → Consolidate. Insert adds objects, Format changes appearance, and Tools holds macros and add-ins.

Answer: C

Correct answer: It can contain many sheets including worksheets and chart sheets

An Excel file is called a workbook because it is a bound collection of sheets - worksheets of cells and chart sheets - rather than a single page, and the tabs along the bottom let you leaf through them. Holding text and data, or being editable, is true of almost any document and does not explain the name.

Answer: C

Correct answer: Bar charts, line graphs and pie charts

Excel’s Chart Wizard offers a wide range of chart types - column and bar, line, pie, XY scatter, area, doughnut, radar, surface, bubble and stock among them. Of the choices offered, only the one naming bar charts, line graphs and pie charts reflects that breadth; the others exclude types Excel plainly supports.

Answer: D

Correct answer: None of above

Excel evaluates a formula in this order: parentheses, then the negation sign, then percent, then exponentiation, then multiplication and division, and finally addition and subtraction - operators of equal rank being taken left to right. So \( -2^2 \) yields \( 4 \), because the negation is applied first. None of the three listed sequences matches that order, so the correct choice is none of above.

Answer: A

Correct answer: Nested Function

A function used as an argument of another function is nested - for example =IF(SUM(A1:A5)>100,"High","Low"), where SUM is nested inside IF. Excel evaluates the inner function first and passes its result outward. SUM, ROUND and the text functions are individual functions, not a category.

Answer: B

Correct answer: On the file menu, click print, and then click selection under print what

Select the cells you want, then open File → Print and choose Selection under “Print what”. That prints just the highlighted range for this one job and leaves any saved print area untouched - which is what you need when the area differs from the usual one. Setting a print area would overwrite the stored setting, and custom views belong to Excel’s view management.