Electronic Spreadsheet

note!Answer: C) Delete
Pressing the Delete key clears the contents of the selected cell.

note!Answer: A) Legend
The legend is the box that explains the colors or patterns of the chart series, usually placed at the right side.

note!Answer: D) 65,536
Excel 2003 and earlier had 65,536 rows. Newer versions have 1,048,576 rows.

note!Answer: D) 16
2+5+1+3+4+1 = 16, and the blank cell adds nothing.

note!Answer: B) F11
Pressing F11 creates a chart from the selected data on a separate chart sheet.

note!Answer: C) Alt key
Holding Alt while dragging a selection over a sheet tab moves the data to that worksheet.

note!Answer: D) All
Tables can be sorted by numbers, text and dates.

note!Answer: A) ()
Parentheses are evaluated first in Excel's operator precedence.

note!Answer: C) Data
In Excel, the Sort command is on the Data menu.

note!Answer: A) A1:B2
A range is written with a colon between the first and last cell, as in A1:B2.

note!Answer: D) Character map
Bar, pie and column are chart types; Character map is a Windows accessory.

note!Answer: A) A method of finding input value to meet target
Goal Seek finds the input value needed to reach a target result.

note!Answer: C) Both a and b
AutoFit adjusts both row height and column width to fit the contents.

note!Answer: A) =
The equals sign (=) is a relational operator used for comparison.

note!Answer: A) Extend sequential series
AutoFill extends sequential series such as numbers, dates or patterns.

note!Answer: D) =
Every Excel formula begins with an equals sign.

note!Answer: D) Insert
The Function command is found on the Insert menu in Excel.

note!Answer: A) Standard
The AutoSum button is on the Standard toolbar.

note!Answer: B) Formula palette
The Formula Palette helps create or edit formulas and shows function information.

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