FUNDAMENTALS OF COMPUTER

DATABASE FUNDAMENTALS

HOW TO MODIFY THE WORKSHEET TAB IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
Referring to a rectangle on a spreadsheet by naming the column and then the row in which it lies (i.e. B17) is called the ____
A
Cell Reference
B
Cell Marker
C
Cell Name
D
Cell Location
Explanation: 

Detailed explanation-1: -Cell: A cell is a rectangular area formed by the intersection of a column and a row. Cells are identified by the Cell Name (or Reference, which is found by combining the Column Letter with the Row Number. For example the cell in Column ā€œCā€ in Row ā€œ3ā€ would be cell C3.

Detailed explanation-2: -A cell is the intersection point of a column and a row.

Detailed explanation-3: -In an Excel worksheet, each small rectangle or box is known as a cell. The active cell is the selected cell in which data is entered when you begin typing.

Detailed explanation-4: -There are two types of cell references: relative and absolute. Relative and absolute references behave differently when copied and filled to other cells. Relative references change when a formula is copied to another cell. Absolute references, on the other hand, remain constant no matter where they are copied.

There is 1 question to complete.