Computer & IT

note!Answer: D) All of the above
Excel supports area, line, pie and many other chart types.

note!Answer: D) Format→cells→alignment
Text wrapping is set in the Alignment tab of the Format Cells dialog.

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: A) Logical operators
NOT, AND, OR and XOR are logical operators that work on true/false values.

note!Answer: C) Chart showing rainfall amounts
A chart is the best way to show numerical data such as monthly rainfall amounts visually.

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.