Electronic Spreadsheet

note!Answer: A) True
Excel aligns text to the left and numbers to the right by default.

note!Answer: D) Format
In Excel, Conditional Formatting is found under the Format menu.

note!Answer: A) Click the data menu and click sort
Sorting by multiple criteria is done with Data > Sort, which opens a dialog for several keys.

note!Answer: A) =(4+2)*3
(4+2)*3 equals 18, while 4+2*3 equals 10 because multiplication comes first. The option 4+2*3= is not a valid formula because it lacks the leading equals sign.

note!Answer: C) !
In Excel, a sheet reference uses the sheet name followed by an exclamation mark, as in Sheet2!A1.

note!Answer: C) Double clicking on column right border on column header
Double-clicking the right border of a column header auto-fits that column's width to its longest entry.

note!Answer: D) Select the cells then place the cell pointer on new cell and choose Edit → Paste Special, mark Transpose check box and click OK.
Paste Special with the Transpose option converts rows to columns (and vice versa); option b describes converting columns to rows.

note!Answer: C) Fill down in the selection
Ctrl+D copies the top cell's content and formatting down into the selected cells (Fill Down).

note!Answer: B) 1
The default step value in Excel's Fill Series dialog box is 1.

note!Answer: C) Fill the selection with active cells to the right
Ctrl+R fills the selected cells to the right using the content of the leftmost cell.

note!Answer: B) When many sheets are selected
Fill Across Worksheets needs multiple sheets selected (grouped) so content can be copied across them.

note!Answer: D) All of above
Paste Special lets you paste validation, formats, formulas, values, comments and more selectively.

note!Answer: D) Divide
Paste Special's operations are Add, Subtract, Multiply and Divide, so only Divide is valid here.

note!Answer: D) Deletes selected cells
Edit → Delete removes the selected cells themselves and shifts other cells to fill the gap.

note!Answer: B) Edit → Clear → Contents
Edit → Clear → Contents removes only the cell contents, keeping formats and comments.

note!Answer: A) Edit → Clear → Contents
The Delete key clears the contents of selected cells, which equals Edit → Clear → Contents.

note!Answer: A) From Edit menu choose Clear and then Formats
Edit → Clear → Formats removes only the formatting and leaves numbers and formulas intact.

note!Answer: A) Select the sheet, then choose Edit → Delete Sheet
Edit > Delete Sheet permanently removes a sheet, whereas Format > Sheet > Hide only hides it.

note!Answer: A) You can Find and Replace within the sheet or workbook
Find and Replace can search the current sheet or the whole workbook, and Excel does have a Match case option.

note!Answer: C) From Edit menu choose Move or Copy (new book) from To Book list and click OK
Edit > Move or Copy, then selecting (new book) in the To Book list, moves the sheet into a new workbook.