DATABASE FUNDAMENTALS
BASICS OF BIG DATA
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
With a capital letter
|
|
|
With a capital letter and a number
|
|
|
with a number
|
|
|
we cannot identify it
|
Detailed explanation-1: -Each row is identified by a number. For example, the first row has an index 1, the second – 2 and the last – 1048576. Similarly, a column is a group of cells that are vertically stacked and appear on the same vertical line.
Detailed explanation-2: -Understanding cells A cell is the intersection of a row and a column-in other words, where a row and column meet. Columns are identified by letters (A, B, C), while rows are identified by numbers (1, 2, 3).
Detailed explanation-3: -Or click on any cell in the column and then press Ctrl + Space. Select the row number to select the entire row. Or click on any cell in the row and then press Shift + Space. To select non-adjacent rows or columns, hold Ctrl and select the row or column numbers.
Detailed explanation-4: -In Excel, to check if a value exists in a range or not, you can use the COUNTIF function, with the IF function. With COUNTIF you can check for the value and with IF, you can return a result value to show to the user. i.e., Yes or No, Found or Not Found.