Simple Computer Learning with Abhishek

  Try Python Code print("Hello Python") Run

Python Programming Problems ........................................................................................................................................Q1. Write a Python program to print any word. print("Hello Python")    # Print(): It shows text or numbers on the screen. Output: Hello Python --------------------------------------------------------------------------------------------------------------- Q2. Write a Python program to input two numbers from the user and print their sum. #input two numbers from the user. a=int(input("Enter the first number:")) b=int(input("Enter the second number:")) sum=a+b print("sum of two numbers=",sum)       #print( ) function is used to display output to console or screen. Output:  Enter the first number: 20 Enter the second number: 40 sum of two numbers=60 Q3.  Write a Python program to input two numbers from the user and print their product. a=int(input("Enter the first number:")) b=int...

 Session -1  What is Subtotal? Subtotal is a feature in LibreOffice Calc used to automatically calculate partial totals(such as Sum, Average, Count, etc.). for a group of data. It works best when the data is sorted. Why Subtotal is used? To summarize large data easily To calculate group wise totals To avoid manual calculations To generate reports quickly Steps to Calculate Subtotals Select the entire data range Go to Data- Subtotals In the Subtotals dialog box, specify: Group by- Column where data changes(eg.TYPE)           Calculate subtotals for- Numeric column (e.g. QUANTITY)           Use function(Sum, Count, Average, Max, Min, Product) Default function is SUM. 4. Click Ok Advantages of Subtotal: 1. Saves Time: Subtotal automatically calculates totals, averages, counts, etc. for each group of data. This reduces the need for manual calculations and saves a lot of time. 2. Easy Data Analysis: Subtotal helps in analyzing data ...

Electronic Spreadsheets An electronic spreadsheet is a powerful and flexible computer program used to organize data in rows and columns and perform automatic calculations using formulas and functions. It help in maintaining numerical figures, analyzing financial or mathematical data, creating graphs, and performing routine tasks easily and efficiently. Common examples are MS Excel, Google Sheets, LibreOffice Calc, Apple numbers, etc. Features of Spreadsheets are: 1. Data Maintenance: Keep track of financial, mathematical, and other records over time. 2. Data Analysis : Use graphs. pivot tables, and what-if analysis for insights. 3. Automation: Automate routine tasks like report generation and calculations using macros. 4. Formulas and functions: perform automatic calculations across changing data. 5. Data Organization and formatting: Sort data, apply filters, use conditional formatting and validate data for accuracy.  Libre Office Calc: LibreOffice Calc is an electronic spread...