Electronic Spreadsheet

note!Answer: D) Excel
Microsoft Excel is a spreadsheet program, while Access is a database and Word is a word processor.

note!Answer: D) F11
Pressing F11 in Excel creates a chart on a new chart sheet from the selected data.

note!Answer: A) Conditional formatting
Conditional formatting applies formats to cells only when they meet specified criteria.

note!Answer: A) ()
Parentheses have the highest precedence in Excel, so expressions inside them are evaluated first.

note!Answer: A) NEPAL
The UPPER function converts all letters in the text to capitals, giving NEPAL.

note!Answer: A) What if analysis
Scenarios are part of What-If Analysis, used to compare different sets of input values.

note!Answer: C) /
The division operator in Excel is the forward slash (/).

note!Answer: D) *
The multiplication operator in Excel is the asterisk (*).

note!Answer: A) Tools
In older versions of Excel, the Protection submenu is under the Tools menu.

note!Answer: D) All of the above
A cell can be activated with the arrow keys, the Tab key, or a mouse click.

note!Answer: A) Sheet3!A10
In Excel, a cell on another sheet is referenced as SheetName!CellAddress.

note!Answer: A) Visual Basic
Excel macros are written in VBA (Visual Basic for Applications).

note!Answer: D) Document
Cells, rows and columns are Excel terms; a 'Document' is a general word, while Excel uses 'Workbook'.

note!Answer: B) Insert→Chart
In Excel, charts are created from the Insert menu's Chart option.

note!Answer: C) Pie Chart
A pie chart shows the proportion of parts relative to a whole.

note!Answer: C) Tools
In Excel (older versions), Spelling is found under the Tools menu.

note!Answer: C) F7
F7 is the shortcut key for the Spelling check in Microsoft Office.

note!Answer: D) Macro Recorder
Macro Recorder records keystrokes and mouse actions so they can be replayed later.

note!Answer: B) A1
The first cell in an Excel worksheet is A1 (column A, row 1).

note!Answer: D) Sheet tabs
The tabs at the bottom of a workbook that identify each worksheet are called sheet tabs.