MS Excel Questions and Answers

Answer: D

Correct answer: With the copy and paste buttons on the standard toolbar

A plain paste inserts a static copy with no connection to the workbook. Linking requires Paste Special with the Paste Link option, the right-drag menu, or a hyperlink.

Answer: B

Correct answer: Excel edits cell references in the newly copied formula

A copied formula keeps its relative references relative, so each one is adjusted by the distance the formula has moved. References made absolute with dollar signs are the ones that do not change.

Answer: C

Correct answer: Speed

A paper spreadsheet can have rows, columns and headings just as an electronic one does. What it cannot do is recalculate instantly when a figure changes, which is the whole advantage of the electronic form.

Answer: B

Correct answer: =now()

NOW() returns the current date and time; TODAY() returns the date alone. Formatting the cell as time then displays only the time part.

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: Toggles between showing formulas and showing their results

Ctrl + `, using the grave accent below the Escape key, toggles Show Formulas: every cell displays its formula instead of its result, and columns widen to fit. It is the fastest way to audit a sheet. Formulas that have been overwritten with typed constants become immediately visible, and inconsistencies in a column that should hold one repeated formula stand out at a glance. It is also useful for printing a formula listing as documentation. Pressing it again returns to normal. The same setting is on the Formulas tab and in Excel’s options, where it applies per worksheet. It is worth knowing because its effect is alarming if triggered accidentally - the sheet appears to have lost all its results - and the key is close enough to Escape and Tab to be hit by mistake. The related auditing tools are Trace Precedents, Trace Dependents and Evaluate Formula, which examine one formula at a time rather than all of them at once.

Answer: D

Correct answer: All of above

A slide can be added from the Insert menu, from the New Slide button on the toolbar, or by right-clicking in the slides panel - three routes to one command.

Answer: D

Correct answer: b, and c

Grouped sheets act as one: an entry, a format or a formula typed into the active sheet appears on every sheet in the group, and all of them print together. What cannot be done is entering data that differs from sheet to sheet.

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

Correct answer: On the tools menu, click Add-Ins, and select the Euro Currency Tools check box

The EUROCONVERT function, which converts between the euro and the legacy national currencies at the fixed conversion rates, is supplied by an add-in. Turn it on with Tools → Add-Ins and tick Euro Currency Tools. Inserting the € symbol only changes how a number looks; it converts nothing.