Computer & IT

note!Answer: B) Descending order
Highest to lowest means descending order.

note!Answer: B) Formula
Calculations in a spreadsheet are performed using formulas.

note!Answer: C) Undo
The Undo command reverses the most recent action, such as an accidental deletion.

note!Answer: A) A cell
The intersection of a row and a column in a spreadsheet is called a cell.

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.