Electronic Spreadsheet

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.

note!Answer: C) =A1+A2+A3
SUM(A1:A3) adds every cell in the range A1 to A3, which equals A1+A2+A3.

note!Answer: A) To fill the series of data
The Fill Series command extends a pattern such as numbers, dates or sequences across cells.