Calculate Total Marks, Create Drop-Down, and Use VLOOKUP Function in Microsoft Excel
ฝัง
- เผยแพร่เมื่อ 27 ส.ค. 2024
- How to Calculate Total Marks, Create Drop-Down, and Use VLOOKUP in Microsoft Excel
In this video, I explain the Calculate Total Marks using the SUM function, Create Drop-Down, and the VLOOKUP function in Microsoft Excel.
How to Calculate Total Marks?
I calculate the total marks of students, and I use two methods. Firstly, I calculate all the marks of students plus all the cells one by one. And secondly, I use the SUM function.
What is the Drop-Down list in MS Excel?
Drop-downs allow you to pick an item from a list that you create. In a new worksheet, you can type the entries you want to appear in your drop-down list.
What is the VLOOKUP function in MS Excel?
VLOOKUP stands for "Vertical Lookup". It is a function that makes Excel search for a certain value in a column (the so-called "table array"), in order to return a value from a different column in the same row.
Formula:
=VLOOKUP(What you want to look up, where you want to look for it, the column number in the range containing the value to return, return an Approximate or Exact match - indicated as 1/TRUE, or 0/FALSE).
Thank you for watching my video. I hope to see you again in my next video.
If you have any questions please write in the comment below.
♥️♥️📖♥️♥️
------------------------------------------------
#msexcel #pivottable #advanceexcel #excelbasic #excelfilter #excelhindi #excelinterview #exceltips #excelhindi #exceltrick #exceltipsinhindi #exceltutorial #share #long #longvideo #learning #learnonline #youtube #youtubevideo #shareknowledge #learnexcel #learnexcelfree #learnexcelonline #courseonline #studyonyoutube #exceleducation #exceleasy
@RachanaChiv
------------------------------------------------
Prepared by: Dr. Rachana Chiv