Electronic Spreadsheet

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.

note!Answer: C) Object in:
The 'Object in' option embeds the chart as an object on an existing worksheet.

note!Answer: B) There is comment associated with the cell
A red triangle in the top-right corner of a cell is the indicator for a cell comment (note).

note!Answer: B) data label
A data label is the text shown on a chart that describes a specific data point's value.

note!Answer: B) exploded pie chart
Pulling out one slice from the pie creates an exploded pie chart.