Computer & IT

note!Answer: D) Rules Manager
The Conditional Formatting Rules Manager dialog box lists all rules for the current selection or the whole workbook.

note!Answer: D) sort
The fields used to order records during sorting are called sort keys.

note!Answer: A) automatic subtotals
Excel's Subtotal feature (automatic subtotals) summarizes grouped data within a table.

note!Answer: B) Single Engineering
Excel's underline options are None, Single, Double, Single Accounting and Double Accounting. 'Single Engineering' is not one of them.

note!Answer: C) Column letter and row number
Each cell is identified by its column letter and row number, such as A1 or B3.

note!Answer: B) value
Excel stores dates as serial numbers, so a date entry is treated as a value.

note!Answer: C) A set of value
In a chart, a data series is the set of values plotted from a worksheet range.

note!Answer: B) Ctrl+Shift+ '+'
Ctrl+Shift+'+' opens the Insert dialog so you can insert blank cells.

note!Answer: C) Ctrl+Shift+ '~'
Ctrl+Shift+~ applies the General number format to the selected cells.

note!Answer: A) Ctrl+Shift+Enter
Ctrl+Shift+Enter confirms a formula as an array formula, shown in curly braces.

note!Answer: A) Ctrl+Shift+ '_'
Ctrl+Shift+_ removes the outline border from the selected cells.

note!Answer: C) Ctrl+Shift+F3
Ctrl+Shift+F3 opens the Create Names dialog, which builds names from row and column labels.

note!Answer: B) Ctrl+Shift+O
Ctrl+Shift+O selects all cells that contain comments.

note!Answer: C) Ctrl+Shift+:
Ctrl+Shift+: enters the current time in the active cell.

note!Answer: A) Ctrl+;
Ctrl+; enters the current date in the active cell.

note!Answer: A) table
The row-and-column grid is designed to organize data into tables.

note!Answer: C) field
In a database, each row is a record and each column is a field.

note!Answer: A) column
A column that holds formulas across its rows is called a calculated column.

note!Answer: B) double-clicking
Double-clicking a workbook file in Windows Explorer starts Excel and opens the file.

note!Answer: B) Visual Basic
MS-Word macros are written in VBA (Visual Basic for Applications).