FUNDAMENTALS OF COMPUTER

Previous
Next

USING MICROSOFT EXCEL

USING THE RIGHT LEFT AND MID FUNCTIONS IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
It is known that column A contains No, column B contains Name, column C contains Theory Value, column D contains Practice Value, column E contains Amount. To calculate the number of students who took the computer exam from the table is ____
A
=SAM(Bz..Bsht)
B
=COUNT(B3..B7)
C
= Fasting (Aa..Ah)
D
= countif(b..b)
E
= konta (b..b)
Explanation: 

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.

There is 1 question to complete.
Previous
Next