Electronic Spreadsheet

note!Answer: C) Ctrl + H
Ctrl+H opens the Replace dialog, and Ctrl+F opens Find.

note!Answer: A) Which cells are used in current formula
Trace Precedents shows the cells that feed into the active cell's formula.

note!Answer: B) In which formula the current cell is used
Trace Dependents shows the formulas that depend on the active cell.

note!Answer: C) Both of above
Auditing arrows can be deleted by selecting them and pressing Delete, or by using Remove All Arrows on the Formula Auditing toolbar.

note!Answer: D) Remove all arrows for this cell
Excel offers removal of precedent, dependent, and all arrows, but no option to remove arrows for just one cell.

note!Answer: D) Goal Seek
Goal Seek is one of the What-If Analysis tools in Excel.

note!Answer: D) Goal Seek
Goal Seek finds the input value needed to reach a target result in a formula cell.

note!Answer: C) shows the name of cell or range currently working on
The Name box displays the address or name of the currently selected cell or range.

note!Answer: A) Press the Alt key
F2, clicking the formula bar, or double-clicking a cell all enter edit mode; pressing Alt alone does not.

note!Answer: A) Custom List
Custom Lists let Excel auto-fill a user-defined sequence such as Nepali month names when dragging the fill handle.

note!Answer: B) F9
Pressing F9 recalculates all formulas in all open workbooks when automatic calculation is turned off.

note!Answer: D) None of above
The Formula Bar, Status Bar, and toolbars can all be shown or hidden from the View menu.

note!Answer: A) The cell content of selected cells disappear from cell and stored in clipboard
Ctrl+X cuts the selected content, removing it from the cells and placing it on the clipboard.

note!Answer: D) SQRT
Paste Special's Operation section offers Add, Subtract, Multiply, and Divide, but not SQRT.

note!Answer: B) Edit → Paste Special → Transpose
The Transpose option in Paste Special rotates copied column data into a row.

note!Answer: B) no data will be entered in the adjacent cells
Text overflows into neighbouring cells only when those cells are empty; otherwise the overflow is cut off.

note!Answer: B) small thin plus icon
The small thin black plus appears when hovering over the fill handle, which is used to fill series.

note!Answer: D) Ctrl+Home
Ctrl+Home moves the active cell to A1 of the worksheet.

note!Answer: A) Formula
A formula is the expression that calculates values in a worksheet cell.

note!Answer: C) equals sign
Every Excel formula starts with an equals sign (=).