Размер видео: 1280 X 720853 X 480640 X 360
Показать панель управления
Автовоспроизведение
Автоповтор
what are the key steps involved in calculating a student’s pointer using Excel, as demonstrated in the tutorial?
You can use VLOOKUP function to determine student's pointer and make sure there is fixed pointer table given to calculate it.
can we put colours inside cell? if yes, is there any ways to make it easy and fast to make it?
Of course, you can double click and drag any cell you want to be colour by click the bucket with colour icon located under the font size at Home.
can i just use SUM FUNCTION to calculate the average ?
No, because the SUM function is to sum all the value while AVERAGE function is to determine average value of each subject.
What is the purpose of function COUNTIF?
to count the number of cells that meet a criterion; for example, to count the number of times a particular city appears in a customer list.
What is the purpose of using vlookup?
the purpose of using vlookup is it searches for a value in the first column of a range (table or array) and returns a corresponding value in the same row from a specified column.
what are the key steps involved in calculating a student’s pointer using Excel, as demonstrated in the tutorial?
You can use VLOOKUP function to determine student's pointer and make sure there is fixed pointer table given to calculate it.
can we put colours inside cell? if yes, is there any ways to make it easy and fast to make it?
Of course, you can double click and drag any cell you want to be colour by click the bucket with colour icon located under the font size at Home.
can i just use SUM FUNCTION to calculate the average ?
No, because the SUM function is to sum all the value while AVERAGE function is to determine average value of each subject.
What is the purpose of function COUNTIF?
to count the number of cells that meet a criterion; for example, to count the number of times a particular city appears in a customer list.
What is the purpose of using vlookup?
the purpose of using vlookup is it searches for a value in the first column of a range (table or array) and returns a corresponding value in the same row from a specified column.