Computer & IT

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.

note!Answer: D) An equal sign
Every formula in Excel must begin with an equal sign.

note!Answer: B) Counts the numbers of characters in a cell
LEN returns the number of characters in a text string or cell.

note!Answer: B) 33
3^3 = 27, 9/3 = 3, so 27 + 3 + 3 = 33.

note!Answer: C) Built-in
Excel comes with many built-in functions such as SUM, AVERAGE and IF.

note!Answer: D) F2
F2 puts the active cell into edit mode.

note!Answer: D) Chart
A chart is the graphical representation of worksheet data.

note!Answer: B)
-3 + 3 = 0.

note!Answer: D) Spans worksheets
A 3-D reference refers to the same cell or range across multiple worksheets.

note!Answer: C) Array formula
An array formula can perform multiple calculations and return one or more results.

note!Answer: B) Exam
LEFT returns the first 4 characters of "Examination", which is "Exam".

note!Answer: B) Method of finding input value to meet target
Goal Seek finds the input value needed to make a formula result reach a target value.

note!Answer: A) 21
SUM gives 5+6+10.5=21.5, and INT truncates it to 21.

note!Answer: A) worksheet
An Excel workbook is made up of one or more worksheets.

note!Answer: C) Ctrl+page down
Ctrl+Page Down moves to the next worksheet in Excel, and Ctrl+Page Up moves to the previous one.