Electronic Spreadsheet

note!Answer: C) By it address
Each cell is identified by its address, such as A1 or B3, which combines column letter and row number.

note!Answer: C) =sum(A1:A2)
SUM is a built-in spreadsheet function; the correct syntax is =SUM(A1:A2).

note!Answer: D) *
The asterisk (*) is the multiplication symbol in spreadsheets and most programming contexts.

note!Answer: A) /
The forward slash (/) is the division symbol.

note!Answer: B) Internet Assistant wizard.
The Internet Assistant Wizard in older Excel versions converted worksheets and charts to HTML.

note!Answer: B) To show a geographic distribution of data.
A data map displays data by geographic region, such as countries or states.

note!Answer: D) Both a and b
Excel data tables (what-if analysis) work with one or two variables.

note!Answer: D) All
In Excel you can select the whole worksheet, individual rows, or individual columns.

note!Answer: D) All of the above
A cell can be activated by clicking it, using arrow keys, or using Tab to move between cells.

note!Answer: C) Pressing Esc key
The Esc key cancels an entry rather than entering data. Arrow and Tab keys confirm entry, and the formula bar can be used to type data.

note!Answer: C) Menu bar
The Menu bar is a separate element that holds menus; the standard, formatting, and drawing items are toolbars.

note!Answer: C) It can contain many sheets including worksheets and chart sheets
An Excel workbook is a file that holds multiple sheets, including worksheets and chart sheets.

note!Answer: D) Ampersand (&)
The ampersand (&) operator joins text values together in Excel formulas.

note!Answer: D) All of the above
Data and formulas can be copied using the Edit menu, right-click shortcut menu, or Standard toolbar buttons.

note!Answer: D) All of the above
Chart data labels can be added to all data markers, a data series, or a selected data marker.

note!Answer: D) Both b & c
Ctrl+Page Up and Ctrl+Page Down move between worksheets in a workbook.

note!Answer: A) * and ?
Excel uses * (any number of characters) and ? (a single character) as wildcards in searches and filters.

note!Answer: B) towards the bottom left corner
The sheet tab scroll buttons are located at the bottom left of the Excel window, beside the sheet tabs.

note!Answer: B) Calculating annual sales for a product line
Excel is a spreadsheet program, best suited for calculations such as annual sales totals.

note!Answer: D) All of the above
A cell in an Excel worksheet can hold text, numbers, and formulas, and graphics can be placed over cells.