Ms Excel - Study Mode

[#91] What is represented by the small, black square in the lower-right corner of an active cell or range?
Correct Answer

(B) Fill handle

Explanation

Solution: Fill handle is a feature to extend (and fill) a series of numbers, dates, or even text to a desired number of cells in Excel. In the active cell of the spreadsheet, the fill handle is a small black box at the bottom right corner, as shown in the image.

[#92] In Excel, a Data Series is defined as what?
Correct Answer

(C) A collection of related data

Explanation

Solution: In Excel, a Data Series is defined as a collection of related data. A data series is just a fancy name for a collection of related numbers in the same row, or the same column.

[#93] In Excel, the Fill Color button on the Formatting toolbar is used for what?
Correct Answer

(D) To add shading or color to a cell range

Explanation

Solution: Fill Color is used to add or change the background color or pattern of cells.

[#94] In help menu of Excel, which of the following tabs are found?
Correct Answer

(D) all of the above

Explanation

Solution: In help menu of Excel 2003, Contents tab, Answer Wizard tab, Index tab are available.

[#95] A ________ is a grid with labeled columns and rows.
Correct Answer

(B) Worksheet

Explanation

Solution: A worksheet in Excel is made up of Rows and Columns grids. Intersection of a Row and column in an Excel worksheet is a rectangle called as a Cell. Cells store a value, a formula, or text.