The Knowledge Vault

1. What is the name of India’s first manned deep-sea submersible mission? [A] Gaganyaan [B] Samudrayaan [C] Sagaryaan [D] Chandrayaan Show Answer Correct Answer: B [Samudrayaan] Notes: Samudrayaan is India’s first manned deep-ocean submersible mission to reach 6,000 metres depth. Testing is delayed due to late supply of syntactic foam from France, now expected by year-end after testing in Norway. The project is led by the National Institute of Ocean Technology under the Ministry of Earth Sciences. A steel model has been tested up to 100 metres; a 500-metre trial is planned by April next year. The final titanium hull, built by the Indian Space Research Organisation, will be tested in Russia. The mission will carry three crew members to collect seabed soil and rocks for future deep-sea mining. 2. Which organization has released the Annual Groundwater Quality Report 2025? [A] Cent...

Advanced Google Sheets Practice Exercises for Data Analysts Advanced Google Sheets Practice Exercises for Data Analysts This guide contains practice exercises to master advanced Google Sheets formulas. Each formula is explained with multiple practice tasks progressing from basic to advanced, plus examples on how to combine formulas for powerful data analysis. Click the links to open ready-to-use Google Sheets for hands-on practice. 1. Advanced SUMIFS with Multiple Criteria & Date Ranges Formula Syntax: =SUMIFS(AmountRange, RegionRange, "North", CategoryRange, "Electronics", DateRange, ">=2025-07-01", DateRange, "<=2025-07-31") Practice Questions: Sum all sales where Region is "North" and Category is "Electronics" in July 2025. Sum sales for Region "South" or "East" in the first quarter of 2025. Calculate total sales for "Furniture" ...

15 Advanced Google Sheets Formulas for Data Analysts Mastering Google Sheets: 15 Advanced Formulas Every Data Analyst Must Know (With Real Examples) Pro Tip: These formulas are useful in real-world data analysis and often asked in interviews. Bookmark this guide for future reference. Table of Contents SUMIF / SUMIFS COUNTIF / COUNTIFS VLOOKUP / XLOOKUP INDEX + MATCH FILTER QUERY ARRAYFORMULA TEXT & DATE Functions IF / IFS / SWITCH Text Functions UNIQUE / SORT / SORTN IS Functions IFERROR REGEX Functions SPARKLINE 1. SUMIF / SUMIFS – Conditional Totals When to use: Use SUMIF when you want to add up numbers in one range based on a single condition applied to another range. Use SUMIFS when you have multiple conditions to meet. Example: If you want to calculate the total sales where the region is "East", you can use: =SUMIF(B:B, "East", A:A) This sums all values in column A only when the co...

  Pulse Code Modulation (PCM) In this blog, we’ll explore the fundamentals of Pulse Code Modulation (PCM), a widely used technique for converting analog signals into digital form. PCM is the backbone of many digital communication systems, including audio, telephony, and media streaming. PCM converts the continuous-time, continuous-amplitude analog signals into discrete-time, discrete-amplitude digital signals, allowing for more reliable and noise-resistant communication compared to traditional analog methods. The PCM process involves three key steps at the transmitter side: sampling, quantization, and encoding. By converting signals into digital bits, PCM facilitates error detection, correction, and encryption, making it indispensable in modern communication systems such as telephony, broadcasting, and digital audio We'll break down its core step i.e the processes that are involved at the transmitter end — Sampling, Quantization, and Encoding —to understand how continuous sig...