Muft Shiksha™ एक 100% Free Education Portal है 🇮🇳, जिसका उद्देश्य Class 9–12 के हर विद्यार्थी तक High-Quality Education को पूरी तरह मुफ्त पहुँचाना है। 🇮🇳 हम मानते हैं कि अच्छी शिक्षा किसी student की आर्थिक स्थिति पर निर्भर नहीं होनी चाहिए। 🇮🇳 हर विद्यार्थी को वही Quality Study Material, MCQs, Quizzes, Exam Preparation, Concept-Based Learning और Bilingual Support मिलना चाहिए, जो आमतौर पर महंगी Coaching या Premium Platforms में मिलता है। Muft Shiksha™ 🇮🇳 इसी सोच के साथ बनाया गया है
SubjectsInformation Technology
परिदृश्यों और लक्ष्य-खोज का उपयोग करके डेटा का विश्लेषण
In this Class 10 Information Technology topic, students learn to analyse data in LibreOffice Calc by using Scenarios and Goal Seek. They explore how different sets of input values affect results, compare possible outcomes for planning and decision-making, and identify the value needed to achieve a specific target. The lesson builds practical spreadsheet skills, including organising assumptions, examining changes, and interpreting results within the chapter Electronic Spreadsheet Advanced using LibreOffice Calc.
TOPIC PRACTICE
Up to 4 questions from this page. Select your focus, then start.
Spreadsheet software stores data in cells arranged in rows and columns and can calculate results with formulas and functions. It is useful for tables, budgets, lists, analysis, and charts. Presentation programs create slides, image editors modify pictures, and web browsers display websites, so they are different primary tools.
View question detailsAn average is calculated from the values included in the selected range. Blank cells may be ignored by many spreadsheet functions, but selecting the wrong range can also include missing, unintended, or related cells and produce a misleading result. Therefore, option A is the safest correct answer. The other choices have no connection with selecting cells for an average.
View question detailsFiltering displays only the rows that meet a selected condition, such as attendance below a chosen percentage, while temporarily hiding the remaining rows. Therefore, option B is correct. Sorting changes the order of rows but normally keeps all rows visible. Printing and spell check do not select records according to attendance values.
View question detailsSorting rearranges records according to a selected field, such as marks, and can arrange numerical values in descending order. All records remain part of the list, although their order changes. Thus option B is correct. Filtering displays only selected records and may hide others, while Recycle Bin and blind carbon copy belong to different computer functions.
View question detailsQUIZ COMPLETE
