DATABASE FUNDAMENTALS
USING THE RIGHT LEFT AND MID FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
=SAM(Bz..Bsht)
|
|
|
=COUNT(B3..B7)
|
|
|
= Fasting (Aa..Ah)
|
|
|
= countif(b..b)
|
|
|
= konta (b..b)
|
Detailed explanation-1: -In a relational database, a column is a set of data values of a particular type, one value for each row of the database. A column may contain text values, numbers, or even pointers to files in the operating system.
Detailed explanation-2: -The key difference between columns and rows is that a column arranges data vertically from top to bottom, while a row arranges data horizontally from left to right. Rows and columns are different based on how they align data.
Detailed explanation-3: -You can use the MATCH() function to check if the values in column A also exist in column B. MATCH() returns the position of a cell in a row or column. The syntax for MATCH() is =MATCH(lookup value, lookup array, [match type]) .
Detailed explanation-4: -A column is a vertical series of cells in a chart, table, or spreadsheet. Below is an example of a Microsoft Excel spreadsheet with column headers (column letter) A, B, C, D, E, F, G, and H. As you can see in the image, the last column H is highlighted in red, and the selected cell (D8), is in the D column.