Skip to main content

ads1

Class 10th Chapter 6 Data Editing and Formating in Calc


  

Data Editing and Formating in Calc


A spreadsheet is made up of rows and columns intersecting each other forming multiple cells

Operations such as opening a new or an existing spreadsheet, saving the spreadsheet, renaming the whole spreadsheet with save as option; renaming work sheets, adding/deleting worksheets etc. are frequently used operations on spreadsheet or work sheet level.

To open a new Calc document, that is a Calc spreadsheet, perform the following procedures.
Select File → New → Spreadsheet; from the Menu Bar.
Press CTRL + N; or

The first way is to open the Calc first and go to file menu and select open.
Select File → Open;

 To insert a worksheet using the sheet tab, perform the steps mentioned.
• Select a worksheet and right click on it;
• A vertical menu will open;

Select a cell from a column (row);
• Select Format → Column → Width or Format → Row → Height; .

Freezing a Pane
When many rows and columns are accommodated in a single worksheet, the row or column headers do not remain visible; which makes handling the data difficult.

(1) Which of the following technique arranges the data set in a particular order such as ascending or descending ?

(a) Data formatting
(b) Data validations
(c) Data filtering
(d) Data sorting

(2) Which of the following techniques can be used to allow only date values in a cell ?
(a) Data formatting
(b) Data validations
(c) Data filtering
(d) Data sorting

(3) Which of the following options when selected deletes all data validations ?

(a) Delete formatting
(b) Delete all
(c) Delete formula
(d) Delete me

(4) We can replace multiple occurrences of a word using which of the following facility
of Calc ? 

(a) Find and replace
(b) By replace only
(c) By copy command
(d) By preview command

(5) Page preview will also allow you to do which of the following setting ?

(a) Borders
(b) Margins
(c) Column and row heading
(d) All of the above

(6) Which of the following function key is used to check spelling in Calc ?

(a) F1
(b) F2
(c) F4
(d) F7

(7) Which of the following function key is used to get help in Calc ?

(a) F1
(b) F2
(c) F4
(d) F7

(8) What is the name of mechanism to arranging the data in a particular order ?

(a) Sorting
(b) Searching
(c) Filtering
(d) Validating

(9) What is the name of mechanism to filter out unnecessary data ?
 
(a) Sorting
(b) Searching
(c) Filtering
(d) Validating

(10) What is the name of mechanism to allow only valid data ?

(a) Sorting
(b) Searching
(c) Filtering
(d) Validating

Link to Download MCQ 




Labels:

ads2

Popular posts from this blog

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

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

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