FUNDAMENTALS OF COMPUTER

DATABASE FUNDAMENTALS

USING THE UPPER AND LOWER FUNCTIONS IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
____ are where information is keyed and is identified by column letter followed by row number
A
workbooks
B
worksheets
C
cells
D
files
Explanation: 

Detailed explanation-1: -Cell Reference: A cell reference is the name of the cell that is found by combining the Column Letter with the Row Number.

Detailed explanation-2: -A cell reference or cell address is a combination of a column letter and a row number that identifies a cell on a worksheet. For example, A1 refers to the cell at the intersection of column A and row 1; B2 refers to the second cell in column B, and so on.

Detailed explanation-3: -CELL REFERENCE. A cell reference is the set of coordinates that a cell occupies on a worksheet. It identifies the location of a cell in the spreadsheet. A cell reference is always the column letter followed by the row number. For example, the first cell in the top left-hand corner of a worksheet is cell A1.

Detailed explanation-4: -The three types of data you can enter into a cell are data, labels and formulas.

There is 1 question to complete.