Information Technology [1 Mark Questions]

With the help of legend, each data series can be uniquely identified by assigning a unique color or pattern.

Titles have not been entered in chart elements step. And, these cannot be added later once chart is ready.

MIN function will return O(zero) in this case.

The only difference between the COUNT() and COUNTA() function is that the COUNTA() function computes the numbers as well as text entries, while the COUNT() function counts only numbers.

-4 will be contained in cell as a result.

Cells A2, A3, A4 and A5 will contain Tuesday, Wednesday, Thursday and Friday respectively.

There would be 4 cells in the given cell range.

Cell referencing in which the cells are referred by their relative position in the worksheet relative to a particular cell is called relative referencing.

Formatting Toolbar

Numbers in Excel can be expressed in many different formats like date, time, percentage or decimals.

There are two methods of adding a new worksheet iasm Excel workbook; Insert worksheet tab at the bor >m and Insert button on cells group under Home tab.

First row and ninth column address will be II.

With formatting, we can make some data to be bolder, rotated or in different color. So, basically formatting provides worksheet a neater and more legible outlook.

Default alignment of text or label entry is left alignment and for numbers and formula it is right alignment.

An active cell is a cell with heavy black color boundary.

A workbook is a collection of worksheets. By default, there are three worksheets in every workbook.