Electronic Spreadsheet

note!Answer: B) Sort
Sorting arranges list data in alphabetical, numerical, or date order.

note!Answer: A) TRUNC(number, num_digits)
TRUNC takes a number and the number of digits to keep, truncating the rest without rounding.

note!Answer: D) All of the above
Lotus 1-2-3, Excel, and Quattro Pro are all spreadsheet packages.

note!Answer: A) Ctrl+9
Ctrl+9 hides the selected rows in Excel.

note!Answer: B) 12.75
Excel's default row height is 12.75 points, which is the standard value to remember.

note!Answer: B) =B6+C6
Every Excel formula must begin with an equal sign (=), so =B6+C6 is the only valid formula.

note!Answer: A) & (ampersand)
The ampersand (&) is the text concatenation operator in Excel.

note!Answer: D) ' (apostrophe)
Typing an apostrophe before a number forces Excel to store it as text (a label).

note!Answer: B) Worksheets
A workbook is a file made up of one or more worksheets.

note!Answer: C) Ctrl+1
Ctrl+1 opens the Format Cells dialog box in Excel.

note!Answer: B) Absolute cell reference
Dollar signs before both the column and row make the reference absolute.

note!Answer: B) Any one conditions is true
An OR expression returns TRUE if at least one of its conditions is true.

note!Answer: C) = (Equal)
All Excel formulas start with an equal sign.

note!Answer: D) All of the above
Spreadsheets automate calculations, update results when data changes, and offer flexibility, so all three are advantages.

note!Answer: B) Alignment tab
Merging cells is done from the Alignment tab of the Format Cells dialog.

note!Answer: A) Data, sort
The Data > Sort command rearranges data in ascending or descending order.

note!Answer: B) $A$1
An absolute reference uses dollar signs before the column and row, as in $A$1.

note!Answer: A) =
Excel formulas always begin with the equal sign (=).

note!Answer: A) =A1+A2
Adding two cells in Excel uses the = sign followed by the cell references joined with +.

note!Answer: A) A dark wide boarder
The active cell in Excel is shown with a dark, thick border.