HIGH COURT ASSISTANT

📣Quotes on Media “Whoever controls the media, controls the mind” – Jim Morrison   The man who reads nothing at all is better educated than the man who reads nothing but newspapers. – Thomas Jefferson.   The media’s the most powerful entity on earth. They have the power to make the innocent guilty and to make the guilty innocent, and that’s power. Because they control the minds of the masses. –Malcom

2️⃣ What do you understand by “freeze panes” in MS excel? With freeze panes, any row or column can be locked. Even if we vertically or horizontally scroll the sheet, the locked row or column will still be visible on the screen. Observe the instructions below to freeze panes in Excel. ➖Choose the Rows and Columns you want to Freeze first. ➖Then choose Freeze Pane from the View tab. ➖Now, you have the following three options to pick and choose which rows and columns to freeze.

1️⃣ How can one restrict copying a cell from a worksheet? ➖Select the data you wish to safeguard first. ➖Press Ctrl, Shift, and F. It then shows the Format Cells tab. Select the Protection tab. Click OK after selecting Locked. ➖Then, click Protect Sheet from the Review menu. To secure the sheet, enter the password.

3️⃣ What is VLOOKUP in excel? How does the VLOOKUP function work? Excel's VLOOKUP (which stands for Vertical Lookup) function is used to find and produce data from a specific set. To make use of this functionality, we need to arrange the data vertically because V is for Vertical in VLOOKUP. Whenever we need to find a certain amount of data from a vast amount of data, VLOOKUP is tremendously helpful. The VLOOKUP function in Excel has a lookup value and starts searching in the left-hand column. VLOOKUP will move right, or into the search value row if the value of that search appears first. It keeps on until the specified column number is returned. This function compares estimated and true search values. Nonetheless, the default match is approximate. Here, ➖lookup_value: The value that you wish to check for is known as the lookup value. ➖table_index: The set of data to be taken from is the table index. ➖col_index_num: col index num specifies the column you wish to extract the value from. ➖range_lookup: Logical value, i.e., TRUE or FALSE, is the range lookup (TRUE finds the closest match; FALSE will check for an exact match)

4️⃣Discuss the functionality of IF() in Excel. The IF() function in Excel does a logical test. ➖If the test results in true, it returns a value; ➖if the test results in false, it returns a different value. Whether the condition holds for the full chosen range determines what value is returned.

❇️ હાઈકોર્ટ આસિસ્ટન્ટ મુખ્ય પરીક્ષા ───────────────── 👨🏻‍💻 JOIN FOR MORE 👨🏻‍💻 https://t.me/Webnagar ➺ 🔷Whatsapp Group⤵️    https://chat.whatsapp.com/BcK1ACPnvHpIJPsQsAhuVE 📥 WEB NAGAR APP NOW  DOWNLOAD 👉 https://clpdiy17.page.link/oaGY 💠 High Court Assistant Mains Batch કોર્ષ ખરીદવા માટે :- https://gsxdm.courses.store/366245?utm_source%3Dother%26utm_medium%3Dtutor-course-referral%26utm_campaign%3Dcourse-overview-webapp