Check Student Result
| S.no | Code | Conduction Date | Name | Course Name | Marks | Test Type | Total | Obtained | Admission Date | Date Of Birth | Father's Name | Date Of Joining | Subject | Fees |
|---|
Learning of the day
Useful shortcuts for Excel, MS Word and Tally that can help students work faster and improve practical efficiency.
CTRL +
SHIFT + →
Extend Selection MS Excel Shortcut
Extends the selection to the last nonblank cell in the same column or row as the active cell.
- Select the starting cell.
- Hold Ctrl + Shift.
- Press an arrow key to extend the selection.
Exam Tip: Useful when selecting large ranges of continuous data quickly.
ALT + F6
Return to Document MS Word Shortcut
Moves from an open dialog box back to the document when the dialog box supports this behavior.
- Open a supported dialog box.
- Press Alt + F6.
- Return to the document window.
Exam Tip: Remember this shortcut for quickly switching back from supported dialog boxes in Word.
ESC
Go Back / Clear Input Tally Shortcut
Goes back to the previous screen by closing the currently open screen and removes inputs provided or selected for a field.
- Press Esc to close the current screen.
- Use it to return to the previous screen.
- It can also remove entered or selected field inputs.
Exam Tip: Esc is one of the most useful navigation keys in Tally for cancelling inputs and returning to the previous screen.
Downloads – Important Information
Click on the links below to access important study materials, shortcut lists, and financial documents provided by BPA Educators.
Budget 2023 Highlights
DownloadImportant Tally Shortcuts
DownloadTally Ledger List
DownloadImportant Access Shortcuts
DownloadIncome Tax Calculator (FY 2021-22)
DownloadImportant MS Word Shortcuts
DownloadTDS Chart Rate (FY 2022-23)
DownloadImportant Busy Shortcuts
DownloadGoogle Drive Shortcuts
DownloadImportant Excel Shortcuts
DownloadCompliance Calendar (FY 2022-23)
DownloadIncome Tax Calculator (FY 2022-23)
DownloadActivities Marks
Today's Birthdays
Activities of the Month
Student Placements
Batch Launches
Exam Records
Certificates Issued
Excel & Financial Formulas — BPA Educators
A structured, learning-wise list of all important Excel formulas with structure and explanation — categorized for easy reference and practical learning.
Basic Formulas
| Formula | Structure | Explanation |
|---|---|---|
| AVERAGE | =AVERAGE(A2:A10) | Returns the average (mean) of values in the given range. |
| COUNT | =COUNT(A2:A10) | Counts the number of numeric entries in the selected range. |
| MAX | =MAX(A2:A10) | Finds the largest value in the selected range. |
| MEDIAN | =MEDIAN(A2:A10) | Returns the middle value in an ordered range of numbers. |
| MIN | =MIN(A2:A10) | Finds the smallest value in the selected range. |
| SUM | =SUM(A2:A10) | Adds all numeric values in the specified range. |
💡 Tip: Ensure that your selected range contains only numbers; text entries are ignored by these formulas.
Time Formulas
| Formula | Structure | Explanation |
|---|---|---|
| TODAY | =TODAY() | Returns the current date; updates automatically each day. |
| NOW | =NOW() | Returns the current date and time; volatile function. |
| DATEDIF | =DATEDIF(StartDate,EndDate,"Y|M|D") | Finds the difference between two dates in years, months, or days. |
| YEAR | =YEAR(Date) | Extracts the year from a date value. |
| MONTH | =MONTH(Date) | Extracts the month from a date value. |
| DAY | =DAY(Date) | Extracts the day portion of a date. |
🕒 Tip: Change cell format to “Date” or “Number” if results appear incorrect.
Logical Formulas
| Formula | Structure | Explanation |
|---|---|---|
| IF | =IF(LogicalTest, ValueIfTrue, ValueIfFalse) | Tests a condition; returns one value for TRUE and another for FALSE. |
| OR | =OR(Test1, Test2, ...) | Returns TRUE if any condition is TRUE. |
| AND | =AND(Test1, Test2, ...) | Returns TRUE only if all test conditions are TRUE. |
💡 Tip: Combine IF with AND or OR for complex logical testing, e.g., =IF(AND(A1>10,B1<50),"OK","Check").
Lookup Formulas
| Formula | Structure | Explanation |
|---|---|---|
| VLOOKUP | =VLOOKUP(LookupValue, TableArray, ColIndex, RangeLookup) | Looks for a value vertically in a table and returns data from a specified column. |
🔍 Tip: Always use FALSE for exact matches. Lock your range using $ (e.g., $A$2:$C$50) when copying.
Financial Formulas
| Formula | Structure | Explanation |
|---|---|---|
| PMT | =PMT(rate, nper, pv, [fv], [type]) | Calculates periodic loan payment. Rate = interest per period, nper = periods, pv = present value (loan). |
💰 Tip: Divide annual rate by 12 for monthly payments. Negative PMT indicates outgoing cash flow.
Statistical Formulas
| Formula | Structure | Explanation |
|---|---|---|
| SUMIF | =SUMIF(range, criteria, [sum_range]) | Sums values meeting a single condition. |
| SUMIFS | =SUMIFS(sum_range, criteria_range1, criteria1, ...) | Sums values meeting multiple AND-based conditions. |
| COUNTIF | =COUNTIF(range, criteria) | Counts the number of cells matching a condition. |
| COUNTIFS | =COUNTIFS(range1,criteria1,range2,criteria2,...) | Counts cells satisfying multiple conditions simultaneously. |
| AVERAGEIF | =AVERAGEIF(range, criteria, [average_range]) | Finds the average of cells meeting a condition. |
| AVERAGEIFS | =AVERAGEIFS(average_range, criteria_range1, criteria1, ...) | Finds average for data meeting multiple criteria. |
📊 Tip: Use quotes for criteria, e.g., ">100" or "*Apple*" when matching text or ranges.
