Electronic Spreadsheet

note!Answer: B) /
The forward slash (/) is the division operator in Excel.

note!Answer: C) A1:A5;F1:G5
A semicolon separates two separate ranges that do not touch, so this is a nonadjacent range.

note!Answer: B) Ctrl
Holding Ctrl while selecting additional ranges adds them to the selection without removing the earlier ones.

note!Answer: B) parentheses
Parentheses are used in formulas to make parts of the expression calculate first.

note!Answer: D) =SUM(F6:F9)
The correct syntax is =SUM(first cell:last cell), so =SUM(F6:F9) adds F6 through F9.

note!Answer: C) font styles
Bold, italic, and underline are font styles applied to text.

note!Answer: C) Custom
Custom colors are created by choosing RGB values for red, green, and blue.

note!Answer: A) red and green
Red-green color blindness is the most common form, so red and green should not be combined for text and background.

note!Answer: A) Right
Excel right-aligns numeric values, and dates are stored as numbers, so they align right by default.

note!Answer: D) Size
The Format Cells dialog has Number, Alignment, Font, Border, Fill and Protection tabs, but font size is set under Font, not as a separate tab.

note!Answer: A) Number
The Number tab holds currency, number, and comma style formatting options.

note!Answer: D) all of the above
Paste Options provides choices to keep source formatting, paste values only, or paste formatting only.

note!Answer: C) use a table style
Applying a table style formats the whole table at once and is faster than formatting cells one by one.

note!Answer: C) Macros
Goal Seek and Scenarios are What-If analysis tools in Excel. Macros are automation scripts, not a What-If tool.

note!Answer: A) F9
In manual calculation mode, F9 recalculates all formulas in open workbooks.

note!Answer: C) Tools → Options → Edit tab
The 'Move selection after Enter' direction is set in Tools → Options → Edit tab.

note!Answer: C) AutoComplete
AutoComplete suggests text matching entries already in the same column.

note!Answer: A) 3 and 255
Excel 2003 creates 3 worksheets by default and allows up to 255 per workbook.

note!Answer: C) Custom List
Excel's fill series for days of the week comes from its built-in custom lists.

note!Answer: A) This will remove row headings and column headings of your data
Unchecking Row & Column headers in the View tab hides the row numbers and column letters on the worksheet.