Electronic Spreadsheet

note!Answer: A) Ctrl+Space bar
Ctrl+Space selects an entire column in spreadsheet programs such as Excel.

note!Answer: A) MS Excel
In MS Excel, Ctrl+End moves the cursor to the last used cell of the worksheet.

note!Answer: C) Spreadsheet
A spreadsheet recalculates dependent formulas instantly when a number is changed.

note!Answer: C) Double click the right side of the column heading
Double-clicking the right border of a column heading auto-fits the column width. The option text is a close paraphrase of this.

note!Answer: C) Click the report, and on the Pivot Table toolbar, click the refresh data button
The Refresh Data button on the PivotTable toolbar reloads the report from the updated source data.

note!Answer: D) All of the above
Excel supports Number, Text, and Currency as valid data types, so 'All of the above' is correct.

note!Answer: B) =A1+A2
A formula in Excel must begin with an equal sign (=) followed by the calculation.

note!Answer: D) Now()
The NOW() function returns the current date and time, while TODAY() returns only the date.

note!Answer: C) Cell B7 through B9
A colon between two cell references denotes a range including all cells from the first to the last.

note!Answer: B) An absolute cell address is created
Dollar signs fix the row and/or column, creating an absolute reference that does not change when copied.

note!Answer: A) Lotus 1-2-3
Lotus 1-2-3 was a popular spreadsheet program that ran under DOS.

note!Answer: D) A cell
A cell is the box formed where a row and a column meet in a spreadsheet.

note!Answer: B) 256
Classic Excel worksheets have 256 columns (A to IV).

note!Answer: B) Insert → Comment
In Excel, comments are added through the Insert menu using the Comment command.

note!Answer: B) Referencing
Referencing means using a cell's address from another sheet to get its value.

note!Answer: D) All of the above
Excel's sheet protection can lock contents, objects, and scenarios against changes.

note!Answer: D) All of these
Auto formatting, styles, and font changes are all ways to make worksheet data easier to read.

note!Answer: C) Formula Bar
The Formula Bar displays and lets you enter or edit values and formulas for the active cell.

note!Answer: B) Array Formula
Array formulas perform several calculations at once and can return multiple results.

note!Answer: D) ####
Excel shows #### when a number is too wide to fit in the cell's column.