Electronic Spreadsheet

note!Answer: B) Fill handle
The small black square at the lower-right corner of a selected cell is the fill handle, used to fill data series.

note!Answer: D) To add shading or color to a cell range.
The Fill Color button applies background shading or color to selected cells.

note!Answer: D) All of the above
Excel's Help menu includes Contents, Answer Wizard and Index tabs.

note!Answer: B) Worksheet
A worksheet is a grid of labeled columns and rows where data is entered.

note!Answer: D) Financial
Excel's Financial functions handle depreciation, return rates, future values and loan payments.

note!Answer: B) Cells B7 through B9
A colon in a range reference means all cells from the first to the last, so B7:B9 covers B7, B8 and B9.

note!Answer: B) Formula bar
The Cancel (X) and Enter (check) buttons appear in the Formula bar while editing a cell.

note!Answer: A) Worksheets
An Excel workbook is a file that contains one or more worksheets.

note!Answer: B) worksheet
The default sheet type in Excel is the worksheet.

note!Answer: B) Sorting
Sorting arranges data in a specified order such as alphabetical.

note!Answer: A) '
Typing an apostrophe before a number makes Excel treat it as text (a label).

note!Answer: C) Format
In Excel, Hide for a sheet is found under Format > Sheet > Hide.

note!Answer: C) =A1+B1
Excel formulas begin with = and use the + operator to add cell values.

note!Answer: D) Pages
Cells, rows and columns are parts of a worksheet grid, while pages are not.

note!Answer: A) Range
A range is a group of selected cells in a spreadsheet, such as A1:B5.

note!Answer: C) Auto Sum
The AutoSum button (Σ) quickly adds a selected range of numbers.

note!Answer: C) Delete cells
Edit > Clear removes contents, formats, comments or notes. Deleting cells is done with Edit > Delete.

note!Answer: B) Spreadsheet package
Microsoft Excel is a spreadsheet package used for calculations and data analysis.

note!Answer: D) All of the above
Excel supports area, line, pie and many other chart types.

note!Answer: D) Format→cells→alignment
Text wrapping is set in the Alignment tab of the Format Cells dialog.