Computer & IT

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.

note!Answer: B) Calibri
Excel 2007 introduced Calibri as the default body font.

note!Answer: C) Spreadsheet
Excel is an electronic spreadsheet program, the digital version of a paper ledger sheet.

note!Answer: B) Workbooks
An Excel file is called a workbook, and it contains one or more worksheets.

note!Answer: D) formula bar
The formula bar shows the content of the active cell, including formulas.

note!Answer: D) both a and c
A chart can be embedded in a worksheet or placed on its own chart sheet.

note!Answer: B) Three
A new Excel workbook contains three worksheets by default.

note!Answer: B) cell reference
AD is a column letter, and a cell reference combines a column letter and row number, such as AD1.

note!Answer: C) Number
Excel row headings are numbers, while column headings are letters.

note!Answer: A) Cell
The intersection of a row and column in a spreadsheet is called a cell.

note!Answer: C) Style
60%-Accent6 is a built-in cell style in Excel, found in the Cell Styles gallery.

note!Answer: C) Feb, Mar, Apr
Excel recognizes month names and continues the series in calendar order: Feb, Mar, Apr.

note!Answer: C) A does not equal B
IF returns the value_if_false (C2) when the logical test A1=B1 is false, which means A1 does not equal B1.

note!Answer: B) To show trends or relationships across data
Charts are used to visualize trends and relationships in data, which are hard to see in raw tables.

note!Answer: A) Pie
A pie chart shows each category as a share of the whole, which is why it is used for part-to-whole comparison.

note!Answer: C) Design, Layout, and Format
When a chart is selected, Excel shows the Chart Tools contextual tabs: Design, Layout, and Format.

note!Answer: D) chart sheet
A chart sheet is a separate sheet that holds only a chart, with no worksheet cells visible.