Skip to main content

ads1

Class 10th Chapter 7 Functions in Calc


 

 Functions in Calc


Calc provide built-in standard functions for mathematical, logical, statistical, date and time, financial and other calculations on numbers and text.

The process of inserting a function is similar for all functions.That is, to use a function we need to enter a correct spelling of the function along with necessary arguments. This is known as syntax of the functions.

t is possible to loose the grip on it and easy to introduce errors. To avoid this, you may take help of function wizard.

The Calc support some more functions that support logical decision making. These functions are AND, OR, and NOT.

(1) In which of the following ways we can enter a function in Calc ?
(a) Directly typing function name in a cell nan
(b) Function wizard or selecting from tool bar
(c) A and B both
(d) Depends on functions

(2) A function can start with which of the following options ?
(a) '='sign
(b) Alphabets
(c) Numbers
(d) Any of these

(3) Which of the following is not a logical function?
(a) OR
(b) AND
(C) NOT
(d) PROPER

(4) Which date and time function of Calc you will use to find out whether the given year
is leap year or not ?
(a) DATE
(b) TIMESTAMP
(c) YEARS
(d) YEARDIFF
 
(5) Which is the possible mechanism to enter a function in Calc cell ?
(a) Through function wizard
(b) By manually entering
(c) Both (a) and (b)
(d) Depends on function

(6) How many arguments one can use with a Calc function ?
(a) One
(b) Two
(c) Three
(d) Depends on the function

(7) What can be a function argument ?
(a) Value
(b) Text
(c) Other function
(d) All of these


Link to Download MCQ


 
 




Labels:

ads2

Popular posts from this blog

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
Read more

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 :- 
Read more

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 :- 
Read more