Computer & IT

note!Answer: D) all of the above
Excel is used for spreadsheets, charts, and simple database tasks, so all of the above apply.

note!Answer: C) 16777216
Excel 2003 has 256 columns × 65,536 rows = 16,777,216 cells.

note!Answer: A) 17179869184
Excel 2007 has 16,384 columns × 1,048,576 rows = 17,179,869,184 cells.

note!Answer: A) 1048576
Excel 2007 worksheets have 1,048,576 rows.

note!Answer: A) 16384
Excel 2007 worksheets have 16,384 columns, ending at column XFD.

note!Answer: A) XFD
The last column in Excel 2007 and later is XFD, which is column 16,384.

note!Answer: B) 10, 400
Excel's zoom range is 10% to 400%.

note!Answer: B) 409 pt.
The maximum row height in Excel is 409 points.

note!Answer: C) 1024
A formula in Excel can contain up to 1024 characters in older versions.

note!Answer: B) Shift+F2
Shift+F2 opens a cell comment for editing in Excel.

note!Answer: D) All of the above
A spreadsheet stores numbers, formulas, and labels (text).

note!Answer: C) Both of the above
Excel data tables can be one-variable or two-variable.

note!Answer: B) Format→Cell→Alignment→Orientation
Text orientation is set in Format Cells under the Alignment tab, in the Orientation section.

note!Answer: A) Table
The Excel menu bar has File, Edit, View, Insert, Format, Tools, Data, Window, and Help, but no Table menu.

note!Answer: B) C7
A relative reference has no dollar signs, so C7 is relative.

note!Answer: D) MID function
MID is a text (string) function that extracts characters from the middle of a string.

note!Answer: B) INT function
INT rounds a number down to the nearest integer.

note!Answer: C) Ctrl+;
Ctrl+; enters the current date in the active cell.

note!Answer: C) Data, filter, Auto filter
Filtering is found under the Data menu, as Filter and then AutoFilter.

note!Answer: B) Windows→Freeze
Freeze Panes is found under the Window menu.