Computer & IT

note!Answer: A) * and ?
Excel uses * (any number of characters) and ? (a single character) as wildcards in searches and filters.

note!Answer: B) towards the bottom left corner
The sheet tab scroll buttons are located at the bottom left of the Excel window, beside the sheet tabs.

note!Answer: B) Calculating annual sales for a product line
Excel is a spreadsheet program, best suited for calculations such as annual sales totals.

note!Answer: D) All of the above
A cell in an Excel worksheet can hold text, numbers, and formulas, and graphics can be placed over cells.

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.