FUNDAMENTALS OF COMPUTER

USING MICROSOFT EXCEL

USING THE UPPER AND LOWER FUNCTIONS IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
A series of two or more adjacent cells in a column, row, or rectangular group of cells, notated using the cell address of its upper left and lower right corners, such as B5:C10.
A
Range
B
Group
C
Reference
D
Total
Explanation: 

Detailed explanation-1: -A range is a group of two or more cells in a worksheet. The cells in a range can be adjacent or nonadjacent.

Detailed explanation-2: -Range: A range is a group of cells in a spreadsheet that have been selected. If the cells are all together in a rectangular or square shape, it is an adjacent range. An adjacent range is identified by the cell reference in the upper left and lower right corners of the selection separated by a colon.

Detailed explanation-3: -A spreadsheet is a configuration of rows and columns. Rows are horizontal vectors while columns are vertical vectors. A spreadsheet is also known as a worksheet. It is used to record, calculate and compare numerical or financial data.

There is 1 question to complete.