Computer & IT

note!Answer: B) F11
Pressing F11 creates a chart from the selected data on a separate chart sheet.

note!Answer: C) Alt key
Holding Alt while dragging a selection over a sheet tab moves the data to that worksheet.

note!Answer: D) All
Tables can be sorted by numbers, text and dates.

note!Answer: A) ()
Parentheses are evaluated first in Excel's operator precedence.

note!Answer: C) Data
In Excel, the Sort command is on the Data menu.

note!Answer: A) A1:B2
A range is written with a colon between the first and last cell, as in A1:B2.

note!Answer: D) Character map
Bar, pie and column are chart types; Character map is a Windows accessory.

note!Answer: A) A method of finding input value to meet target
Goal Seek finds the input value needed to reach a target result.

note!Answer: C) Both a and b
AutoFit adjusts both row height and column width to fit the contents.

note!Answer: A) =
The equals sign (=) is a relational operator used for comparison.

note!Answer: A) Extend sequential series
AutoFill extends sequential series such as numbers, dates or patterns.

note!Answer: D) =
Every Excel formula begins with an equals sign.

note!Answer: D) Insert
The Function command is found on the Insert menu in Excel.

note!Answer: A) Standard
The AutoSum button is on the Standard toolbar.

note!Answer: B) Formula palette
The Formula Palette helps create or edit formulas and shows function information.

note!Answer: B) *
The asterisk (*) is the multiplication operator in Excel.

note!Answer: B) IF
IF is the conditional function that tests a condition.

note!Answer: A) &
The ampersand (&) joins text values together in Excel.

note!Answer: C) Double click
In Excel, double-clicking a chart object enters edit mode for it.

note!Answer: B) Constant
A constant is a fixed value that does not change, unlike a cell reference whose value can change.