Class 10th Chapter 8 Charts in Calc

Charts in Calc

Choose the correct option from the following:

(1) Which of the following option is used to print a chart ?
(a) Insert → Chart
(b) File → View

(c) File → Print
(d) View → Chart

(2) The charts in Calc may have how many of the following axis ?
(a) Two
(b) Three
(c) Two or three

(d) Four

(3) Which of the following is used to enter 3D text in Calc ?
(a) Fontwork
(b) Artwork

(c) Drawing work
(d) Graphwork

(4) Which of the following is used to provide a link to the chart ?
(a) Activelink
(b) Hyperlink
(c) Drawinglink
(d) Connectionlink

(5) Which of the following shows us the preview of the chart ?
(a) Save as XHTML
(b) Page preview
(c) Export chart
(d) Any of these

(6)To fix the column or row in a data range - to make it absolute, which symbol is used ?

(a) #
(b) $
(c) &
(d) %

(7) To which of the entity can a Calc chart be linked ?
(a) To an existing document
(b) To a new document
(c) Web page
(d) All of these

Link to Download MCQ

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