Computer & IT

note!Answer: D) All of the above
Strikethrough, superscript, and subscript are all font effect options in Excel's Format Cells dialog.

note!Answer: D) All of the above
Excel's Arrange Windows options include Tiled, Horizontal, Vertical, and Cascade.

note!Answer: D) All of the above
Cell value conditions in conditional formatting include between, equal to, greater than, and less than, along with their negations.

note!Answer: C) Data Series
A data series is a set of related data points plotted in a chart.

note!Answer: A) rows
As more records are added, more rows are added to the table, and the assigned formats apply to them.

note!Answer: C) validation
Data validation restricts the values that can be entered into cells to specified limits.

note!Answer: B) Convert to Range
The Convert to Range command turns a table back into an ordinary cell range.

note!Answer: B) Warning
A cautionary validation alert is the Warning style, which lets the user continue after acknowledging it.

note!Answer: A) GIGO
GIGO means 'Garbage In, Garbage Out': invalid input produces inaccurate output.

note!Answer: D) formatting
The Table Element list lets you apply separate formatting to header rows, total rows, banding, and so on.

note!Answer: A) TAB
Pressing TAB in the last cell of a table adds a new row at the bottom of the table.

note!Answer: A) Row banding
Row banding alternates the shading of rows so each record stands out.

note!Answer: B) reenter just the value in error
After Retry, Excel expects you to reenter only the value that caused the error.

note!Answer: C) horizontal
HLOOKUP searches horizontally across the top row of a table; VLOOKUP searches vertically.

note!Answer: B) because most tables are vertical
Most data tables are organized vertically, so VLOOKUP is needed more often than HLOOKUP.

note!Answer: C) =VLOOKUP(lookup_value, table_array, col_index_num)
VLOOKUP takes a lookup value, a table array, and a column index number as its arguments.

note!Answer: C) hide
Hiding columns keeps sensitive data from being displayed while leaving it in the worksheet.

note!Answer: B) table
Excel guidelines advise placing only one table per worksheet to avoid problems with sorting and filtering.

note!Answer: A) rules
Conditional formatting works through rules that apply formats when specified conditions are met.

note!Answer: D) all of the above
Highlight cells rules, data bars, and icon sets are all types of conditional formatting in Excel.