In this section I covered all the important question from Nsqf Class 10th: Part B: Vocational Skill Important Questions answers for students reference.
Q1. What are Styles ? What are the advantages of using styles?
Ans. A style is a set of formats that you can apply to selected pages, text, frames, and other elements in your document to quickly change their appearance.
Advantages of using styles are :
1. Styles help us to apply consistent formatting to the documents.
2. Using styles we can easily change the existing format. 3. Styles makes major formatting changes simple.
Q2. Give any four styles supported by OpenOffice.org
Ans. Four Styles supported by OpenOffice.org are.
1. Page styles include margins, headers and footers, borders and backgrounds.
2. Paragraph styles control all aspects of a paragraph’s appearance, such as text alignment, tab stops, line spacing, and borders.
3. Character styles affect selected text within a paragraph, such as the font and size of text, or bold and italic formats.
4. Numbering styles apply similar alignment, numbering or bullet.
Q3. How can we create our own styles?
Ans. We can create new styles by following two ways :
1. Creating new styles from selection.
2. Dragging And Dropping To Create A Style.
Q4. Explain any four Graphic filters.
Ans. Four graphic filters are :
1.Invert : Inverts the color values of a color image or the brightness values of a grayscale image.
2.Smooth : Softens the contrast of an image.
3.Sharpen : Increases the contrast of an image.
4.Posterize : Makes a picture appear like a painting.
Q5. Explain Image Cropping.
Ans. When you are interested in a section of the image for the purpose of your document, you may wish to crop (cut off) parts of it. Right click on image and select Picture from the pop-up menu. In the Picture dialog box, select the Crop page and select the part from left, right, top and bottom which you want to remove.
Q6. List any three methods of inserting images in a text document.
Ans. Three methods of inserting images in a text document are :
a. Drag and Drop
b. Inserting An Image From The Clipboard
c. Inserting An Image Using A Scanner
Q7. What do you understand by the terms:
a. Text Wrapping
b. Anchoring
Text wrapping-refers to the relation of graphics to the surrounding text, which may wrap around the graphic on one or both sides, be overprinted behind or in front of the graphic.
Anchoring-It refers to the reference point for the graphics. This point could be the page, or frame where the object is. An image always has an anchor point.
Q8. What are templates? What are the advantages of using templates?
Ans. A template is a model that you use to create other documents. For example, you can create a template for business reports that has your company’s logo on the first page. When you create a new documents from this template will all have your company’s logo on the first page.
One of the major advantages of using templates is the ease of updating styles in more than one document. Another advantage is that it also saves your time.
Q9. What is the difference between styles and templates?
Ans. A template is a model that you use to create other documents.
1.A style is a set of formats that you can apply to selected pages, text, frames, and other elements in your document to quickly change their appearance.
2.Styles help to keep formatting consistent in the entire document.
3.Templates help to keep formatting consistent across multiple documents.
Q10. Explain Mail Merge.
Ans. A mail merge is a way to take a letter you’ve written and send it to a whole bunch of people, personalizing it with information about them so they might think that you typed that letter personally for them. In short, it’s a way to be personal, yet efficient.
Q11. What are advantages of Mail Merge?
Ans. Advantages of mail merge are :
1. It saves our time and efforts.
2. It helps to create multiple personalized letters in a very less time. 3. It also help to keep the formatting consistent in all the letters.
Unit 2: Electronic Spreadsheet (Advanced)
Q1. How can we rename a worksheet?
Ans. There are three ways you can rename a worksheet
a. Double-click on one of the existing worksheet names.
b. Right-click on an existing worksheet name, then choose Rename from the resulting Context menu.
c. Select the worksheet you want to rename (click on the worksheet tab) and then select the Sheet option from the Format menu. This displays a submenu from which you should select the Rename option.
Q2. What are the two ways of referencing cells in other worksheets?
Ans. Two ways to reference cells in other sheets:
1) By entering the formula directly using the keyboard
2) By using the mouse.
Q3. Differentiate between Relative and absolute hyperlinks.
Ans. Hyperlinks can be used in Calc to jump to a different location from within a spreadsheet. An absolute link will stop working only if the target is moved. A relative link will stop working only if the start and target locations change relative to each other.
For instance, if you have two spreadsheets in the same folder linked to each other and you move the entire folder to a new location, a relative hyperlink will not break.
Q4. What is the purpose of adding comments?
Ans. Comments are mostly used in shared Calc sheet which is used to explain the changes made in the sheet to the author of the sheet.
Q5. How can we add comments to the changes made?
Ans. Comments can be added as follows:
1. Make the change to the spreadsheet.
2. Select the cell with the change.
3. Choose Edit > Changes > Comments. The automatically-added comment provided by Calc appears in the title bar of this dialog and cannot be edited.
4. Type your own comment and click OK.
After you have added a comment to a changed cell, you can see it by hovering the mouse pointer over the cell.
Q6. What are Macros?
Ans. A macro is a saved sequence of commands or keystrokes that are stored for later use. Macros are especially useful to repeat a task the same way over and over again.
Q7. How can we record a Macro?
Ans. Steps to record macro are as follows
a. Use Tools > Macros > Record Macro to start the macro recorder. The Record Macro dialog is displayed with a stop recording button.
b. Perform the actions you want to be recorded in the document.
c. Click Stop Recording.
d. The Macro dialog appears, in which you can save and run the macro.
Q8. Define consolidating data. Write steps to consolidate data in an electronic spreadsheet.
Ans. Data Consolidation allows you to gather together your data from separate worksheets into a master worksheet. In other words, the Data Consolidation function takes data from a series of worksheets or workbooks and summaries it into a single worksheet that you can update easily.
It is available under Data menu->Consolidate option
Unit 3: Database Management System
Fill in the Blanks
1. A database is an organized collection of data.
2. A DBMS is a software package that can be used for creating and managing databases.
3. A RDBMS is a database management system that is based on the relational model.
4. Three popular DBMS software are Microsoft Access, Open Office Base & MySQL.
5. A Primary Key is a unique value that identifies a row in a table.
6. Composite Key is a combination of one or more columns.
7. A table is a set of data elements that is organized using a model of vertical columns and horizontal rows.
8. A column is a set of data values of a particular type, one for each row of the table.
9. A row represents a single, data item in a table.
10. Datatypes are used to identify which type of data we are going to store in the database.
11. Create table DDL command is used to create a table.
12. Common DDL statements are create, alter and drop.
13. The types of languages used for creating and manipulating the data in the Database are DDL & DML.
14. A DDL is a standard for commands that define the different structures in a database.
15. A DML is a language that enables users to access and manipulate data in a database.
16. A Select is a part of DML involving information retrieval only.
17. A popular data manipulation language is SQL.
18. Tables are the basic building blocks of a database.
19. There are three types of Relationships in a table.
20. A form helps the user to systematically store information in the database.
Question and Answer
Q1. In how many ways tables can be created in Base? Ans. Tables can be created in two ways.
1. In Design view
2. Using Wizard
Q2. List datatypes available in Numeric Datatype?
Ans. The different types of numeric data types are:
1.Boolean Tinyint Smallint Integer Bigint
2.Numeric Decimal Real
3.Float
4.Double
Q3. List datatypes available in Alphanumeric Data Type?
Ans. The different types of Alphanumeric Data Type are:
1.Longvarchar
2.Char
3.Varchar
4.Varchar_Ignore Case
Q4. Define the structure of a table.
Ans. A table is a set of data elements (values) that is organized in vertical columns and horizontal rows. A table has a defined number of columns, but can have any number of rows.
Q5. Differentiate between Tuples and Attributes of a table
Ans. A row also called a Record or Tuple represents a single, data item in a table. Whereas A column is a set of data values of a particular simple type, one for each row of the table.
Q6. Name different Binary data types.
Ans. The different Binary data types are:
1.Longvarbinary
2.Binary
3.Varbinary
Q7. How many types of relationships can be created in Base? Explain each of them.
Ans. There are three types of relationship in OpenOffice Base. 1.ONE to ONE : In this relationship, both the tables must have primary key columns. Example: In the given tables EMP and DEPT, EMP_ID in EMP table and DEPT_ID in DEPT table are the primary keys.
2.ONE to MANY : In this relationship, one of the table must have primary key column. It signifies that one column of primary key table is associated with all the columns of associated table.
3.MANY to MANY : In this relationship, no table has the primary key column. It signifies that all the columns of primary key table are associated with all the columns of associated table.
Q8. What do you mean by Sorting? In how many ways it can be done?
Ans. Sorting means arranging elements in particular sequence. It can be done in two ways.
1. Increasing order
2. Decreasing Order
Unit 4: Maintain Health, Safety and Secure Working Environment
Q1. What do you mean by Hazard?
Ans. A hazard is anything that is the source of any potential harm, damage or any kind of potential loss of health or life.
Q2. Name four types of Hazards.
Ans. The different types of hazards are:
● Physical
● Chemical
● Biological
● Mechanical
Q3. Give a checklist for workstations to minimize the hazards.
Ans. The workstation should:
1. Provide sufficient space for the user to alter position comfortably
2. Provide adequate lighting
3. Have windows fitted with adjustable coverings to alter the sunlight level
4. Be spacious enough when a workstation is shared by more than one person
Q4. Give a checklist for display screen to minimize the health hazards.
Ans. The display screen should:
1. Display well-defined characters of adequate size and spacing
2. Have a stable image
3 Have easily adjustable brightness and contrast
4. Tilt and swivel easily to suit the user
5. Be free from glare and reflections
Q5. What do you mean by Evacuation?
Ans. Evacuation is the process of emptying a place in case of an emergency, disaster.
Q6. What do you mean by Buddy System?
Ans. A ‘buddy system’ for individuals with special needs or disabilities must be designated. This system ensures that differently-abled are assisted and guided out of the premises or the impacted area properly. If you are a buddy to someone, ensure that your buddy is safe at the assembly point with you.
Q7. What do you mean by Healthy Living?
Ans. A healthy living has a lasting impact on an individual which ultimately yields a healthy environment at home as well as at work place. A happy and healthy worker will always perform best to his ability.
Protect Health and Safety at Work Class 10 IT 402
Q8. List any six points of healthy life style.
Ans. A healthy lifestyle includes :
1. Healthy eating habits
2. Physical activities
3. Stress management
4. Healthy mind
5. Sound sleep
6. Goal setting
Q9. Write one advantage of healthy life style.
Ans. Advantage of healthy life style is :
1. A healthy lifestyle helps to keep and improve people’s health and well being.
Q10. Give a checklist for keyboard to minimize the health hazards.
Ans. The keyboard should:
1. be able to tilt easily and should be able to separate from the screen to allow the user to adopt a comfortable working position
2. have space in front to provide support for the hands or arms of the user.
3. have a matt surface.
4. have clearly legible symbols on the keys.
Disclaimer !
It’s for educational purposes only. Copyright Disclaimer Under Section 107 of the Copyright Act 1976, allowance is made for “fair use” for purposes such as criticism, comment, news reporting, teaching, scholarship, and research. Fair use is a use permitted by copyright statute that might otherwise be infringing. Non-profit, educational or personal use tips the balance in favor of fair use
What effects we get for drinking cinnamon tea with Jaggery?
Cinnamon tea has many health benefits. Cinnamon has many powerful health benefits that are both preventative and therapeutic, especially when coupled with honey. Cinnamon is good for lowering and stabilizing blood sugar levels, which makes it a great choice for diabetic patients.
Benefits of Cinnamon tea
Cinnamon is also good for lowering cholesterol and triglycerides in the blood and reducing inflammation and the risk of heart disease.
In addition to that, Cinnamon is also known to be a digestive aid, especially for those with indigestion, gas, and acid reflux. In addition to these benefits, Cinnamon tea with jaggery is also known to be a great remedy for cold and cough.
Women face many problems due to lack of attention to sexual health. Leukorrhea i.e. white water coming from the vagina is also one of them. This is a common problem that can be easily treated.
Let us know in detail about the causes, symptoms and treatment of leucorrhoea in this blog
What is Likoria ?
Leukorrhea is colloquially known as white water, white likoria or white discharge. This is a common problem in women, which usually occurs for one to two days before or after periods.
Leukorrhea increases the risk of infection in women. Usually this problem is seen more in married women, but it can happen to a girl or woman of any age.
Causes, Symptoms and Treatment of Leucorrhoea
Cause of Leukorrhea
The reason for leucorrhoea is the lack of nutrition in the body and the presence of bacteria inside the vagina. Excessive mental stress, heavy work or exercise can also cause this.
Other causes of leucorrhoea i.e. white water may include:-
1.Not taking care of vaginal hygiene
2.Lack of blood in the body
3.Masturbate excessively
4.Having sex inappropriately
5.Excessive consumption of pungent, oily and spicy foods
6.Having sex with a man suffering from a disease
7.Urinary tract infection
8.Vitamin C deficiency
9.Vitamin D deficiency
Symptom of Leucorrhoea
Like other problems related to sexual health of women, there are some symptoms of leucorrhoea, with the help of which a woman can get an idea that she is suffering from it.
Common symptoms of leukorrhea i.e. white water coming from the vagina include:-
1.Feeling weak
2.Dizzy
3.Itching in the vagina
4.Feeling of heaviness in the body
5.Frequent urination
6.Loss of appetite
7.Pain in arms, legs, groin and abdomen
If you feel the above-mentioned symptoms then you should consult an experienced gynecologist so that this problem can be easily overcome with the help of proper investigation and treatment on time.
Treatment of Leucorrhoea
There are many ways to treat leucorrhoea. The doctor starts the treatment process after confirming the cause of the white water. Leukorrhea is not a serious problem, but there is a risk of complications if not treated properly on time.
If you are suffering from leucorrhoea, then you should consult an experienced gynecologist and get it properly examined and treated. Also, you can get rid of it by making some positive changes in your lifestyle such as:-
1.Use an ice pack and wet bandage for itching and burning
2.Take special care of the cleanliness of underwear
3.Do not wear sanitary napkins for a long time during periods
4.Wear cotton or linen panties instead of synthetic panties
5.Do not over-wash the genital area, this can lead to a pH imbalance
6.Wash thoroughly from front to back after passing stool or urinating
Apart from all this,
1.Eat a balanced diet
2.Drink at least 10-12 glasses of water daily
3.Do light exercise
4.Meditate in the morning or evening
5.Have sex with only one partner at a time
Also, if you have any kind of problem or question in your mind, then talk to the doctor about it.
बहुत समय पहले की बात है एक राज्य हुआ करता था और जो वहाँ का राजा था वो हमेशा एक नाई के पास आया जाया करता था। वो नाई के पास अपनी मसाज करवाता, अपने बाल बनवाता और ऐसे ही उसका आना जाना वहाँ लगा रहता था। लेकिन राजा हमेशा एक बात नोटिस करता था।
वो देखता था की जो वो नाई है वो बहुत खुश रहता था, हमेशा उछलता कूदता रहता था, गाता रहता था।उमंग से जूझता रहता था।तो राजा को बड़ी हैरानी हुई कि मैं इतना बड़ा राजा हूँ, इतनी धन संपदा मेरे पास है।लेकिन यह छोटा सा नाई इतना खुश कैसे रहता है ?
Motivational Story of Barber in Hindi
मैं तो हमेशा परेशान रहता तो आखिरकार 1 दिन राजा ने उस नाई से पूछ ही लिया।कि मुझे एक बात बताओ, तुम इतना ज्यादा खुश कैसे रहते हो ? तो नाई ने मुस्कुराते हुए कहा सीधा सा जवाब दिया कि राजा साहब जितना आप मुझे देते हैं, मैं उतने में ही संतुष्ट रहता हूँ और खुश रहता हूँ ? मैं उससे ज्यादा की कामना नहीं करता हूँ और ना मुझे उससे ज्यादा की इच्छा है। इसलिए मैं हमेशा गाता रहता हूँ और भगवान का शुक्रिया अदा करता हूँ।
लेकिन राजा को इस बात पर यकीन नहीं हुआ।उसे लगा कि इसकी खुशी का कोई और कारण है तो राजा ने ये सारी बात अपने मंत्री को बताई तो मंत्री ने कहा राजा साहब वो नहीं बिलकुल सही कह रहा है। उसकी खुशी का यही कारण है कि वो 99 के चक्कर में नहीं फंसा तो राजा ने कहा कि इसका क्या मतलब हुआ तो मंत्री ने कहा मैं आपको बताता हूँ।
तो मंत्री ने राजा के साथ मिलकर एक योजना बनाई।और उस नाई के घर के आगे 99 सोने की मुद्राएं रख di। उसने देखा कि उसके घर के आगे निन्यानबे सोने की मुद्राएं रखी थी। उसने देखा कि ये निन्यानबे मुद्राएं है, वो परेशान हो गया कि कोई उससे इन्हें छीन ले। उसके पास पहली बार इतना धन आया था लेकिन उसके मन में एक इच्छा आयी क्यों ना मैं इन्हें 100 पूरा कर लू ?
उसके बाद अगली सुबह से नाई दिन रात मेहनत करने लगा। उसे बस एक और स्वर्ण मुद्रा चाहिए थी। वो परेशान रहता। वो दिन रात काम करता रहता तो राजा ने जब उसे परेशान देखा तो राजा ने उससे पूछा कि क्या बात है, अब तुम उतना खुश नहीं हो।
आखिर ऐसी क्या बात है जिसने तुम्हें परेशान कर दिया ? नाई ने राजा को साफ साफ सारी बात बता दी। फिर राजा मुस्कुराने लगा कि मंत्री ने बिल्कुल।सही कहा था। तुम 99 के चक्कर में नहीं फंसे, तुम्हारी संतुष्टि ही तुम्हारी खुशी का कारण थी
तो राजा ने उसे साफ साफ सब कुछ बता दिया कि यह उसी की योजना थी और अब वो 99 मुद्राएं तुम रख सकते हो लेकिन परेशान होने की जरूरत नहीं है। तुम उसे 100 करने के चक्कर में मत फंसो तो नाई ने कहा कि राजा साहब मुझे बस एक और स्वर्ण मुद्रा चाहिए, उसके बाद में संतुष्ट हो जाऊंगा।
तो ये छोटी सी कहानी है लेकिन यह हमें बहुत कुछ सिखाती है। भले ही इस कहानी में हमने नाई को 99 से 100 मुद्राएं करते हुए देखा, लेकिन ये सारी बातें हमारी जिंदगी पर लागू होती है। हम जैसे जैसे बड़े होते हैं, हमारी इच्छाएं बढ़ती रहती है।
हमें एक चीज़ मीलती है। हमें दूसरी चीज़ लेने की इच्छा होती हम दूसरी प्राप्त करते हैं। हमें तीसरी की इच्छा होती है और हम कभी संतुष्ट नहीं रहते। जब हम बच्चे थे तो एक खेल से ही संतुष्ट हो जाते थे, लेकिन अब धीरे धीरे हमारी इच्छाएं बढ़ती रहती। हमारी कामनाएं बढ़ती रहती है और हम हमेशा इस जंजाल में फंसे रहते हैं।और इसी को कहते हैं 99 का चक्कर।
तो अगर आप अपनी जिंदगी में खुश रहना चाहते हैं तो जितना आपको मिला है उसके लिए शुक्रगुजार रहिये। आप अपनी जिंदगी में जरूर तरक्की कीजिए, अपनी जिंदगी में आगे बढ़ते रहिए, लेकिन जितना आपके पास है उसके लिए शुक्रगुजार रहिये । खुश रहिए, आनंद में रहिये। 99 के चक्कर में मत फंसिए, खुशी खुशी आगे बढ़िए।
अगर आपको यह कहानी पसंद आई है। तो अपने दोस्तों के साथ शेर कीजिये।अगर आप और कहानियां पढ़ना चाहते हैं। तो यहां क्लिक करें।
Please also subscribe our YouTube Channel for Devotional Cum Inspirational Videos Click Here to Subscribe
एक खूबसूरत सी कहानी आपको सुनाना चाहता हूँ। तो ये कहानी एक पिता और एक पुत्र की है। This motivational story is of a father and a son. तो एक लड़का था। 15 या 16 साल का है। उसे हर बात पर हमेशा गुस्सा आता था। और उसे इतना गुस्सा आता था। की वो कभी भी किसी को गुस्से में कुछ भी कह देता या कुछ भी कर देता था।
तो उसके पिता उसकी इस बात से परेशान हो गए।और उन्होंने सोचा कि मुझे अपने बेटे की इस आदत को सुधारना चाहिए।तो उन्होंने अपने बेटे को बुलाया और उसे एक कील से भरा हुआ बॉक्स दिया और कहा कि अगली बार से जब भी तुम्हें गुस्सा आये, तुम एक कील हमारे घर की पीछे वाली दीवार पर ठोक देना तो उसका बेटा कील का बॉक्स लेकर चला गया।
Motivational Story of father and a son
अब जब भी उस लड़के को गुस्सा आता तो वो एक कील निकालता और दीवार पर ठोक देता है और वो हमेशा ऐसा करता।और ऐसा करते करते वो किलो भरा बॉक्स खत्म हो गया। अब वो अपने पिता के पास आया कि पापा वो बॉक्स खत्म हो चुका है तो उसके पिता ने कहा अब तुम एक काम करो।
अब जब भी तुम्हें अगली बार से गुस्सा आये, तुम एक एक कील वापस निकाल दिया करो।तो अब जब भी उस लड़के को गुस्सा आता वो कील निकाल देता और वो हमेशा ऐसा करता जब भी उसे गुस्सा आता है वो एक ही कील निकाल देता है तो 1 दिन उसने सारे कील निकाल दी।
Motivational Story of father and a son
अब वह अपने पिता के पास आया।की वो सारी किले में निकाल दी तो उसके पिता उसे उस दीवार के पास ले गए और उससे कहा देखो बेटा ये दीवार पहले कैसी थी और तुमने इस पर इतनी कीलें ठोकी, उसके बाद निकाल दी। लेकिन जो इस दीवार पर निशान रह गए उन्हें तुम अब नहीं निकाल सकते। उनका तुम कुछ नहीं कर सकते।
गुस्सा भी बिल्कुल ऐसा होता है।हम गुस्से में कुछ कह देते हैं, कुछ कर देते हैं।और बाद में उसे अगर हम ठीक भी करना चाहे तो ये उसी निशान की तरह हमेशा के लिए रहते हैं और उस लड़के को ये बात समझ आ गयी तो मेरे दोस्त हमारी जिंदगी में भी ऐसा ही होता है।
हमारा गुस्सा कई बार हम पर हावी हो जाता है। हम अपने गुस्से में कभी भी कुछ भी बोल देते है, कुछ भी कर देते हैं, लेकिन बाद में हमें पछतावा होता है कि हमें ऐसा नहीं बोलना चाहिए था। ऐसा नहीं करना चाहिए तो हमेशा अपने गुस्से को काबू में रखें।
रिऐक्ट करने की जगह रिस्पॉन्ड करें, सोच समझकर ही ऐक्शन लें।गुस्से में एक कभी भी कोई बड़ा कदम ना ले।और हमेशा की तरह मैं आपको एक बात बोलना चाहूंगा कि आप अपनी जिंदगी में हर चीज़ हासिल कर सकते हैं। आप हर वो चीज़ हासिल कर सकते हैं जो आप चाहते हैं।और मुझे आपके सपनों पर यकीन है।
अगर आपको यह कहानी पसंद आई है। तो अपने दोस्तों के साथ शेर कीजिये।अगर आप और कहानियां पढ़ना चाहते हैं। तो यहां क्लिक करें।
how to become computer expert,computer expert,how to become expert in computer science,how to become a computer expert,how to become computer expert tips in hindi,how to become computer expert in hindi,how to become a computer expert in hindi?,computer,how to become computer expert in urdu,how to become a computer expert in 7 days,how to become a computer expert in english,how to become a computer expert?,computer expert kaise bane
What is Spreadsheet in Computer and its components
In this post, we will learn about the spreadsheet’s Cell, Row, Column, Worksheet, Cell Reference, Workbook, etc. in details.
Spreadsheets are needed nowadays by everyone who uses computers. Whether it is work related to data entry or related to calculation, it is used for all this work.
In this post, we are going to learn about each and every components of spreadsheet like what is workbook, what is worksheet, why use formula and will also get information about function.
When there was no computer, then even the biggest calculations were done manually, which took a lot of time and the biggest thing was that the chances of making a mistake were the highest. But in today’s time even the biggest calculations are done in a few seconds using a computer.
So to know what a spreadsheet is, let’s get started What is Spreadsheet in Computer ?
Spreadsheet is a computer software that provides the facility of managing, arranging data in the form of a table, meaning in the form of Row and Column. It is also used for numerical calculations and chart making.
Spreadsheet is one such program. By which you use to store and manage the biggest calculations, and data.
In this, with the help of Rows and Columns, you collect and keep data and information.
What are the functions of Spreadsheet?
1.It does any type of calculation and data processing.
2.Sorting and Searching of any database can be done fast and easily.
3.Business can create graphics. such as charts and graphs.
4.It provides us with many functions of mathematics.
5.Old worksheets can be merged into new worksheets.
In Spreadsheet software, data is kept in Rows and Columns. Where Rows and Columns interact with each other, the cell is formed. This is a box of rectangle type, which we call by the name of the cell.
2.Active Cell
A complete worksheet contains a large number of cells but the active cell is that cell. Which has a border around it, which means in Excel, a border is created around the cell on which we click. That is what is called the active cell.
3.Rows
The horizontal arrangement of cells is called row, there is 1048576 row inside a worksheet.
4.Column
Vertical arrangement of cells is called column. There are 16384 columns inside a worksheet.
5.Cell Address
All the rows and columns in the spreadsheet software have a different name. For example, the number of rows is 1,2,3,4…………. The number of or columns is represented by A,B,C,D,AA,BB…….. In a spreadsheet, rows and columns are known by their names.
6.Cell Reference
A formula is needed to do calculations in a spreadsheet and we use cell addresses in the formula. The cell address used in any formula is called a cell reference.
7.Formula
The most commonly used option in a spreadsheet is a formula because of all the calculations we have to do. They do it only with the help of formula. Like adding, subtracting, dividing etc. is done with the help of all the formulas.
To start the formula in Excel, we use the equal to (=) sign.
8.Functions
Some functions are already defined in the spreadsheet, they make our calculations fast. We only apply by clicking on that function like Sum(), Average() etc.
9.WorkSheet
A worksheet contains a collection of cells. A workbook already has 3 worksheets and each worksheet has cells inside.
10.WorkBook
All the work we do in a spreadsheet, all the data is in the workbook itself, that means the file we create is called workbook itself.
Features of Spreadsheet
Now we will know about the benefits of spreadsheet that if we use spreadsheet then how useful it is for us.
1.Automatic Recalculation
In Spreadsheet, if you have entered number data in any table and formula is applied on it. So if you change the data in any cell. So it changes the automatic value. Updates automatic results.
2.Use of Functions
Spreadsheets already have pre-defined functions that you can perform during calculations. This saves a lot of time and results are obtained quickly.
3.Formatting
Along with calculations, formatting is also used very easily in spreadsheets. In this you can format different column rows and cells differently. We also get this facility in spreadsheet software.
4.Database
Whatever big data is, you can easily maintain it in a spreadsheet and keep it. With the help of this sort and filter, you can prepare any report.
5.Graphs
You can also display your data in the form of a graph so that it can be well defined. You can create Graph in Excel with many types like Column bar, Line, Pie, XY Scatter etc.
Some people find it difficult to reduce their fat intake and stay within the recommended guidelines, but it doesn’t have to be this way. Watch this video The Best Healthy Low Fat Foods to Add to Your Diet.
