SCERT à´ªുറത്à´¤ിറക്à´•ിà´¯ à´¨ിർദേശങ്ങൾ à´…à´¨ുസരിà´š്à´šു 2023 à´•ംà´ª്à´¯ൂà´Ÿ്à´Ÿà´±ൈà´¸്à´¡് à´…à´•്à´•ൗà´£്à´Ÿിംà´—് à´ª്à´°ാà´•്à´Ÿിà´•്കൽ പരീà´•്à´·à´•്à´•് à´µേà´£്à´Ÿി ഹരിà´•ുà´®ാർ à´¸ാർ തയ്à´¯ാà´±ാà´•്à´•ിà´¯ à´¹െà´²്à´ª് ഫയലുകൾ (Published on 26-11-2022)
1. SUM, SUMIF, LOOKUP
┗➤ Download![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjUuMhYn9BzRzb5xfrGTVFzS2G9prRGzwBffSuArlW0NtrfymCW2B3LJmJfvAbXcNjoycjT8IIsBQg9Daz6N1PF66vuUF3AjPHeGDgEq0SbBvEmfaF5rNR6xOUwqQBcpG2oH8Ge2Hm995PE/s0-rw/new1.gif)
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjUuMhYn9BzRzb5xfrGTVFzS2G9prRGzwBffSuArlW0NtrfymCW2B3LJmJfvAbXcNjoycjT8IIsBQg9Daz6N1PF66vuUF3AjPHeGDgEq0SbBvEmfaF5rNR6xOUwqQBcpG2oH8Ge2Hm995PE/s0-rw/new1.gif)
2. Use of IF Function
┗➤ Download![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjUuMhYn9BzRzb5xfrGTVFzS2G9prRGzwBffSuArlW0NtrfymCW2B3LJmJfvAbXcNjoycjT8IIsBQg9Daz6N1PF66vuUF3AjPHeGDgEq0SbBvEmfaF5rNR6xOUwqQBcpG2oH8Ge2Hm995PE/s0-rw/new1.gif)
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjUuMhYn9BzRzb5xfrGTVFzS2G9prRGzwBffSuArlW0NtrfymCW2B3LJmJfvAbXcNjoycjT8IIsBQg9Daz6N1PF66vuUF3AjPHeGDgEq0SbBvEmfaF5rNR6xOUwqQBcpG2oH8Ge2Hm995PE/s0-rw/new1.gif)
3. Use of the COUNT Function
┗➤ Download![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjUuMhYn9BzRzb5xfrGTVFzS2G9prRGzwBffSuArlW0NtrfymCW2B3LJmJfvAbXcNjoycjT8IIsBQg9Daz6N1PF66vuUF3AjPHeGDgEq0SbBvEmfaF5rNR6xOUwqQBcpG2oH8Ge2Hm995PE/s0-rw/new1.gif)
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjUuMhYn9BzRzb5xfrGTVFzS2G9prRGzwBffSuArlW0NtrfymCW2B3LJmJfvAbXcNjoycjT8IIsBQg9Daz6N1PF66vuUF3AjPHeGDgEq0SbBvEmfaF5rNR6xOUwqQBcpG2oH8Ge2Hm995PE/s0-rw/new1.gif)
4. Pivot Table
┗➤ Download![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjUuMhYn9BzRzb5xfrGTVFzS2G9prRGzwBffSuArlW0NtrfymCW2B3LJmJfvAbXcNjoycjT8IIsBQg9Daz6N1PF66vuUF3AjPHeGDgEq0SbBvEmfaF5rNR6xOUwqQBcpG2oH8Ge2Hm995PE/s0-rw/new1.gif)
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjUuMhYn9BzRzb5xfrGTVFzS2G9prRGzwBffSuArlW0NtrfymCW2B3LJmJfvAbXcNjoycjT8IIsBQg9Daz6N1PF66vuUF3AjPHeGDgEq0SbBvEmfaF5rNR6xOUwqQBcpG2oH8Ge2Hm995PE/s0-rw/new1.gif)
5. MIN, MAX, AVG, Concatenate
┗➤ Download![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjUuMhYn9BzRzb5xfrGTVFzS2G9prRGzwBffSuArlW0NtrfymCW2B3LJmJfvAbXcNjoycjT8IIsBQg9Daz6N1PF66vuUF3AjPHeGDgEq0SbBvEmfaF5rNR6xOUwqQBcpG2oH8Ge2Hm995PE/s0-rw/new1.gif)
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjUuMhYn9BzRzb5xfrGTVFzS2G9prRGzwBffSuArlW0NtrfymCW2B3LJmJfvAbXcNjoycjT8IIsBQg9Daz6N1PF66vuUF3AjPHeGDgEq0SbBvEmfaF5rNR6xOUwqQBcpG2oH8Ge2Hm995PE/s0-rw/new1.gif)
6. One Variable Table
┗➤ Download![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjUuMhYn9BzRzb5xfrGTVFzS2G9prRGzwBffSuArlW0NtrfymCW2B3LJmJfvAbXcNjoycjT8IIsBQg9Daz6N1PF66vuUF3AjPHeGDgEq0SbBvEmfaF5rNR6xOUwqQBcpG2oH8Ge2Hm995PE/s0-rw/new1.gif)
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjUuMhYn9BzRzb5xfrGTVFzS2G9prRGzwBffSuArlW0NtrfymCW2B3LJmJfvAbXcNjoycjT8IIsBQg9Daz6N1PF66vuUF3AjPHeGDgEq0SbBvEmfaF5rNR6xOUwqQBcpG2oH8Ge2Hm995PE/s0-rw/new1.gif)
7. COLUMN CHART
┗➤ Download![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjUuMhYn9BzRzb5xfrGTVFzS2G9prRGzwBffSuArlW0NtrfymCW2B3LJmJfvAbXcNjoycjT8IIsBQg9Daz6N1PF66vuUF3AjPHeGDgEq0SbBvEmfaF5rNR6xOUwqQBcpG2oH8Ge2Hm995PE/s0-rw/new1.gif)
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjUuMhYn9BzRzb5xfrGTVFzS2G9prRGzwBffSuArlW0NtrfymCW2B3LJmJfvAbXcNjoycjT8IIsBQg9Daz6N1PF66vuUF3AjPHeGDgEq0SbBvEmfaF5rNR6xOUwqQBcpG2oH8Ge2Hm995PE/s0-rw/new1.gif)
8. PIE CHART
┗➤ Download![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjUuMhYn9BzRzb5xfrGTVFzS2G9prRGzwBffSuArlW0NtrfymCW2B3LJmJfvAbXcNjoycjT8IIsBQg9Daz6N1PF66vuUF3AjPHeGDgEq0SbBvEmfaF5rNR6xOUwqQBcpG2oH8Ge2Hm995PE/s0-rw/new1.gif)
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjUuMhYn9BzRzb5xfrGTVFzS2G9prRGzwBffSuArlW0NtrfymCW2B3LJmJfvAbXcNjoycjT8IIsBQg9Daz6N1PF66vuUF3AjPHeGDgEq0SbBvEmfaF5rNR6xOUwqQBcpG2oH8Ge2Hm995PE/s0-rw/new1.gif)
9. Depreciation_SLN
┗➤ Download![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjUuMhYn9BzRzb5xfrGTVFzS2G9prRGzwBffSuArlW0NtrfymCW2B3LJmJfvAbXcNjoycjT8IIsBQg9Daz6N1PF66vuUF3AjPHeGDgEq0SbBvEmfaF5rNR6xOUwqQBcpG2oH8Ge2Hm995PE/s0-rw/new1.gif)
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjUuMhYn9BzRzb5xfrGTVFzS2G9prRGzwBffSuArlW0NtrfymCW2B3LJmJfvAbXcNjoycjT8IIsBQg9Daz6N1PF66vuUF3AjPHeGDgEq0SbBvEmfaF5rNR6xOUwqQBcpG2oH8Ge2Hm995PE/s0-rw/new1.gif)
10. Depreciation_DB
┗➤ Download![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjUuMhYn9BzRzb5xfrGTVFzS2G9prRGzwBffSuArlW0NtrfymCW2B3LJmJfvAbXcNjoycjT8IIsBQg9Daz6N1PF66vuUF3AjPHeGDgEq0SbBvEmfaF5rNR6xOUwqQBcpG2oH8Ge2Hm995PE/s0-rw/new1.gif)
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjUuMhYn9BzRzb5xfrGTVFzS2G9prRGzwBffSuArlW0NtrfymCW2B3LJmJfvAbXcNjoycjT8IIsBQg9Daz6N1PF66vuUF3AjPHeGDgEq0SbBvEmfaF5rNR6xOUwqQBcpG2oH8Ge2Hm995PE/s0-rw/new1.gif)
11. PAYROLL
┗➤ Download![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjUuMhYn9BzRzb5xfrGTVFzS2G9prRGzwBffSuArlW0NtrfymCW2B3LJmJfvAbXcNjoycjT8IIsBQg9Daz6N1PF66vuUF3AjPHeGDgEq0SbBvEmfaF5rNR6xOUwqQBcpG2oH8Ge2Hm995PE/s0-rw/new1.gif)
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjUuMhYn9BzRzb5xfrGTVFzS2G9prRGzwBffSuArlW0NtrfymCW2B3LJmJfvAbXcNjoycjT8IIsBQg9Daz6N1PF66vuUF3AjPHeGDgEq0SbBvEmfaF5rNR6xOUwqQBcpG2oH8Ge2Hm995PE/s0-rw/new1.gif)
12. Loan Repayment Schedule
┗➤ Download![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjUuMhYn9BzRzb5xfrGTVFzS2G9prRGzwBffSuArlW0NtrfymCW2B3LJmJfvAbXcNjoycjT8IIsBQg9Daz6N1PF66vuUF3AjPHeGDgEq0SbBvEmfaF5rNR6xOUwqQBcpG2oH8Ge2Hm995PE/s0-rw/new1.gif)
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjUuMhYn9BzRzb5xfrGTVFzS2G9prRGzwBffSuArlW0NtrfymCW2B3LJmJfvAbXcNjoycjT8IIsBQg9Daz6N1PF66vuUF3AjPHeGDgEq0SbBvEmfaF5rNR6xOUwqQBcpG2oH8Ge2Hm995PE/s0-rw/new1.gif)
13. Cash Book
┗➤ Download![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjUuMhYn9BzRzb5xfrGTVFzS2G9prRGzwBffSuArlW0NtrfymCW2B3LJmJfvAbXcNjoycjT8IIsBQg9Daz6N1PF66vuUF3AjPHeGDgEq0SbBvEmfaF5rNR6xOUwqQBcpG2oH8Ge2Hm995PE/s0-rw/new1.gif)
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjUuMhYn9BzRzb5xfrGTVFzS2G9prRGzwBffSuArlW0NtrfymCW2B3LJmJfvAbXcNjoycjT8IIsBQg9Daz6N1PF66vuUF3AjPHeGDgEq0SbBvEmfaF5rNR6xOUwqQBcpG2oH8Ge2Hm995PE/s0-rw/new1.gif)
14. Final Accounts
┗➤ Download![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjUuMhYn9BzRzb5xfrGTVFzS2G9prRGzwBffSuArlW0NtrfymCW2B3LJmJfvAbXcNjoycjT8IIsBQg9Daz6N1PF66vuUF3AjPHeGDgEq0SbBvEmfaF5rNR6xOUwqQBcpG2oH8Ge2Hm995PE/s0-rw/new1.gif)
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjUuMhYn9BzRzb5xfrGTVFzS2G9prRGzwBffSuArlW0NtrfymCW2B3LJmJfvAbXcNjoycjT8IIsBQg9Daz6N1PF66vuUF3AjPHeGDgEq0SbBvEmfaF5rNR6xOUwqQBcpG2oH8Ge2Hm995PE/s0-rw/new1.gif)
15. BRS
┗➤ Download![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjUuMhYn9BzRzb5xfrGTVFzS2G9prRGzwBffSuArlW0NtrfymCW2B3LJmJfvAbXcNjoycjT8IIsBQg9Daz6N1PF66vuUF3AjPHeGDgEq0SbBvEmfaF5rNR6xOUwqQBcpG2oH8Ge2Hm995PE/s0-rw/new1.gif)
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjUuMhYn9BzRzb5xfrGTVFzS2G9prRGzwBffSuArlW0NtrfymCW2B3LJmJfvAbXcNjoycjT8IIsBQg9Daz6N1PF66vuUF3AjPHeGDgEq0SbBvEmfaF5rNR6xOUwqQBcpG2oH8Ge2Hm995PE/s0-rw/new1.gif)
16. Trial Balance
┗➤ Download![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjUuMhYn9BzRzb5xfrGTVFzS2G9prRGzwBffSuArlW0NtrfymCW2B3LJmJfvAbXcNjoycjT8IIsBQg9Daz6N1PF66vuUF3AjPHeGDgEq0SbBvEmfaF5rNR6xOUwqQBcpG2oH8Ge2Hm995PE/s0-rw/new1.gif)
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjUuMhYn9BzRzb5xfrGTVFzS2G9prRGzwBffSuArlW0NtrfymCW2B3LJmJfvAbXcNjoycjT8IIsBQg9Daz6N1PF66vuUF3AjPHeGDgEq0SbBvEmfaF5rNR6xOUwqQBcpG2oH8Ge2Hm995PE/s0-rw/new1.gif)
17. Creation of Table in Design View
┗➤ Download![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjUuMhYn9BzRzb5xfrGTVFzS2G9prRGzwBffSuArlW0NtrfymCW2B3LJmJfvAbXcNjoycjT8IIsBQg9Daz6N1PF66vuUF3AjPHeGDgEq0SbBvEmfaF5rNR6xOUwqQBcpG2oH8Ge2Hm995PE/s0-rw/new1.gif)
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjUuMhYn9BzRzb5xfrGTVFzS2G9prRGzwBffSuArlW0NtrfymCW2B3LJmJfvAbXcNjoycjT8IIsBQg9Daz6N1PF66vuUF3AjPHeGDgEq0SbBvEmfaF5rNR6xOUwqQBcpG2oH8Ge2Hm995PE/s0-rw/new1.gif)
18. Relationship between Tables
┗➤ Download![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjUuMhYn9BzRzb5xfrGTVFzS2G9prRGzwBffSuArlW0NtrfymCW2B3LJmJfvAbXcNjoycjT8IIsBQg9Daz6N1PF66vuUF3AjPHeGDgEq0SbBvEmfaF5rNR6xOUwqQBcpG2oH8Ge2Hm995PE/s0-rw/new1.gif)
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjUuMhYn9BzRzb5xfrGTVFzS2G9prRGzwBffSuArlW0NtrfymCW2B3LJmJfvAbXcNjoycjT8IIsBQg9Daz6N1PF66vuUF3AjPHeGDgEq0SbBvEmfaF5rNR6xOUwqQBcpG2oH8Ge2Hm995PE/s0-rw/new1.gif)
19. PAYROLL through LibreOffice Base
┗➤ Download![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjUuMhYn9BzRzb5xfrGTVFzS2G9prRGzwBffSuArlW0NtrfymCW2B3LJmJfvAbXcNjoycjT8IIsBQg9Daz6N1PF66vuUF3AjPHeGDgEq0SbBvEmfaF5rNR6xOUwqQBcpG2oH8Ge2Hm995PE/s0-rw/new1.gif)
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjUuMhYn9BzRzb5xfrGTVFzS2G9prRGzwBffSuArlW0NtrfymCW2B3LJmJfvAbXcNjoycjT8IIsBQg9Daz6N1PF66vuUF3AjPHeGDgEq0SbBvEmfaF5rNR6xOUwqQBcpG2oH8Ge2Hm995PE/s0-rw/new1.gif)
20. Preparation of Report
┗➤ Download![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjUuMhYn9BzRzb5xfrGTVFzS2G9prRGzwBffSuArlW0NtrfymCW2B3LJmJfvAbXcNjoycjT8IIsBQg9Daz6N1PF66vuUF3AjPHeGDgEq0SbBvEmfaF5rNR6xOUwqQBcpG2oH8Ge2Hm995PE/s0-rw/new1.gif)
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjUuMhYn9BzRzb5xfrGTVFzS2G9prRGzwBffSuArlW0NtrfymCW2B3LJmJfvAbXcNjoycjT8IIsBQg9Daz6N1PF66vuUF3AjPHeGDgEq0SbBvEmfaF5rNR6xOUwqQBcpG2oH8Ge2Hm995PE/s0-rw/new1.gif)
Computerised Accounting CA-Practical Help File By Other Teachers
┗➤ Click here
Plus two Computerised Accounting help files by Binoy George
(Model record work,29 selected questions with procedures and output. Model viva questions with answers)
┗➤ Download![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjUuMhYn9BzRzb5xfrGTVFzS2G9prRGzwBffSuArlW0NtrfymCW2B3LJmJfvAbXcNjoycjT8IIsBQg9Daz6N1PF66vuUF3AjPHeGDgEq0SbBvEmfaF5rNR6xOUwqQBcpG2oH8Ge2Hm995PE/s0-rw/new1.gif)
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjUuMhYn9BzRzb5xfrGTVFzS2G9prRGzwBffSuArlW0NtrfymCW2B3LJmJfvAbXcNjoycjT8IIsBQg9Daz6N1PF66vuUF3AjPHeGDgEq0SbBvEmfaF5rNR6xOUwqQBcpG2oH8Ge2Hm995PE/s0-rw/new1.gif)
Thanks for your response