Class 10 ch-5 Introduction to Calc

Class 10 ch-5 Introduction to Calc

Calç is an electronic spreadsheet package from the OpenOffice suits. Spreadsheet is a type of package that is used for fast and accurate calculations as well as formatting of data in a document.

There are maximum 256 worksheets per Calc spreadsheet document.

1. Title bar Untitled 1 - OpenOffice.org calc

2. Menu bar Eile Edit View Insert Format Tools Data Window Help

3. Toolbars

4. Column headers

5. Row headers

6. Active cell

7. Address or name filed of selected cell

8. Formula and data input bar

9. Workspace

10. Zoom tool

11. Status bar

12. Sheet tab

This is also known as a user interface of Calc.

Menu Bar :- The menu bar contains menus with commands for various tasks.It consists

File

Edit

View

Insert

Format

Tools

Data

Window

Help

Multiple Choice Question

(1) Which of the following type of package does Calc refer to ?

(a) Spreadsheet (b) Multi-sheet (c) Double sheet (d) Cannot be determined

(2) Which of the following applications are not suitable for Calc ?

(a) Balance sheet preparation (b) Result analysis

(c) Presenting an idea about a product (d) All of these

(3) Which of the following is the extension of a worksheet created in Calc ?

(a) ods (b) odd (c) .xls (d) .obj

(4) Which of the following will be inserted in a worksheet if =starcalcteam() is inserted in a Calc cell ?

(a) Stars (b) Photograph of Calc developer team

(5) How can one calculate total of values entered in a worksheet in a Calc document ?

(a) By manual entry (b) By autosum (c) By formula (d) All of these

(6) If we move a cell containing a formula having reference to another cell in the worksheet what will happen to the cell numbers used in formula ?

(a) The cell row and columns are changed at destination

(b) The cell row numbers are changed at destination

(d) Nothing will be changed

Link to Download Chapter :-

Link to Download Mcq :- Class 10 ch-5 Introduction to Calc

11. Write a Java program to input basic salary of an employee and calculate its Gross salary according to following:

11. Write a Java program to input basic salary of an employee and calculate its Gross salary according to following: Basic Salary <= 10000 : HRA = 20%, DA = 80% Basic Salary <= 20000 : HRA = 25%, DA = 90% Basic Salary > 20000 : HRA = 30%, DA = 95% Static Solution :- class salary { public static void main(String args[]) { double basic=20000.50,gross,da,hra; if(basic <=10000) { da = basic * 0.8; hra = basic *0.2; } else if(basic <=20000) { da = basic * 0.9; hra = basic *0.25; } else { da = basic * 0.95; hra = basic * 0.3; } gross = basic + da + hra; System.out.println("The Gross Salary is :-"+gross); } } Output :- Dynamic Solution :- class salary { public static void main(String args[]) { double basic=20000.50,gross,da,hra; Scanner in = new Scanner(System.in); System.out.println("Enter the Basic Salary

1. Given the school result data, analyses the performance of the students on #different parameters, e.g subject wise or class wise.

1. Given the school result data, analyses the performance of the students on #different parameters, e.g subject wise or class wise. Solution :- # x-axis is shows the subject and y -axis # shows the markers in each subject # import pandas and matplotlib import pandas as pd import matplotlib.pyplot as plt # Simple Line Chart with setting of Label of X and Y axis, # title for chart line and color of line subject = ['Physic','Chemistry','Mathematics', 'Biology','Computer'] marks =[80,75,70,78,82] # To draw line in red colour plt.plot(subject,marks,'r',marker ='*') # To Write Title of the Line Chart plt.title('Marks Scored') # To Put Label At Y Axis plt.xlabel('SUBJECT') # To Put Label At X Axis plt.ylabel('MARKS') plt.show() Output :-

24.Create a Data Frame quarterly sales where each row contains the item category, item name, and expenditure. Group the rows by the category and print the total expenditure per category.

24.Create a Data Frame quarterly sales where each row contains the item category, item name, and expenditure. Group the rows by the category and print the total expenditure per category. import pandas as pd # initialize list of lists data = [['CAR','Maruti',1000000],['AC','Hitachi',55000],['AIRCOLLER','Bajaj',12000], ['WASHING MACHINE','LG',15000],['CAR','Ford',7000000],['AC','SAMSUNG',45000],['AIRCOLLER','Symphony',20000],['WASHING MACHINE','Wirlpool',25000]] Col=['itemcat','itemname','expenditure'] # Create the pandas DataFrame qrtsales = pd.DataFrame(data,columns=Col) # print dataframe. print (qrtsales) qs=qrtsales.groupby('itemcat') print('Result after Filtering Dataframe') print(qs['itemcat','expenditure'].sum()) Output :-

TechOnespot

Search This Blog

ads1