Electronic Spreadsheet

note!Answer: C) Counts cells having number
COUNT returns the number of cells in a range that contain numeric values.

note!Answer: D) Ctrl+Space Bar
Ctrl+Spacebar selects the entire column of the active cell.

note!Answer: C) Name box
The Name Box, at the left of the formula bar, shows the address of the active cell.

note!Answer: D) A21
A cell address is a column letter followed by a row number, such as A21. The other options lack a valid letter-number format.

note!Answer: D) All of the above
Spreadsheets are widely used for financial modeling, basic calculations, and scientific data processing.

note!Answer: A) =5+41
In a spreadsheet, a formula must begin with an equals sign, so =5+41 is valid while 5+41 is just text.

note!Answer: B) Create and edit formulas containing functions
The formula palette in Excel helps you build and edit formulas that contain functions.

note!Answer: B) Freeze panes command on the window menu
The Freeze Panes command on the Window menu keeps the titles visible while scrolling.

note!Answer: C) Select columns e,f,and g
Excel inserts new columns to the left of the selected columns, so selecting e, f and g inserts three columns between d and e.

note!Answer: D) All of the above
Page Break Preview lets you see page breaks, change the print area, and add or remove breaks.

note!Answer: D) All of the above
Large worksheets often need scaling to fit pages, page break adjustments, and defined print areas.

note!Answer: D) All of the above
Excel allows printing a named range, an entire workbook, or a single worksheet.

note!Answer: A) Can place a chart on a new chart sheet or on any sheet in the workbook.
The Chart Wizard can place a chart on a new chart sheet or as an embedded object on any worksheet.

note!Answer: B) Spreadsheet
A spreadsheet stores numerical data and can create charts showing change over time.

note!Answer: B) Save As
Save As creates a new file with a new name, keeping the original file unchanged.

note!Answer: B) Insert a row
Inserting a row adds an empty line in the sheet without disturbing the data.

note!Answer: B) Descending order
Highest to lowest means descending order.

note!Answer: B) Formula
Calculations in a spreadsheet are performed using formulas.

note!Answer: C) Undo
The Undo command reverses the most recent action, such as an accidental deletion.

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