IT DIGEST
Where Can I Use a Computer Away from Home? 7 Places to Look At the office: A friend’s house: At the library: Community centers: Cafes and restaurants: Hotels: Fitness centers: Can I use computer at library? You will need your library card to use a computer. If you are visiting from out of town, you […]
Turn Narrator on and off If you’re using a controller, press and hold the Xbox button until it vibrates, and then press the Menu button in the bottom-right corner. Press the Xbox button to open the guide; and then select Profile & system > Settings > Accessibility > Narrator to turn it […]
Open the Gmail app. Tap the menu icon in the upper left corner > Settings > Add account > Exchange and Microsoft 365. Important: Do NOT choose “Outlook, Hotmail, and Live” unless you want to sync email only and not calendar/contacts. Enter your full email address and tap Next. How do I link my Outlook […]
How does the Hlookup function work in Excel? The Microsoft Excel HLOOKUP function performs a horizontal lookup by searching for a value in the top row of the table and returning the value in the same column based on the index_number. The HLOOKUP function is a built-in function in Excel that is categorized as a […]
If you wish to get an array, you need to select the number of cells that are equal to the number of rows that you want HLOOKUP to return. After typing FALSE, we need to press Ctrl + Shift + Enter instead of the Enter key. Why do we need to do so? Ctrl + […]
Use HLOOKUP when your comparison values are located in a row across the top of a table of data, and you want to look down a specified number of rows. Use VLOOKUP when your comparison values are located in a column to the left of the data you want to find. The H in HLOOKUP […]
How do I create a group chat in Skype on mobile or tablet? Tap the New chat. button. Select New Group. Set up your group: Enter a name for your group, which is required to continue. Tap the Picture button to upload, or take a new photo for your group, if you’d like to add […]
Add custom checkbox values On your computer, open a spreadsheet in Google Sheets. Select the cells you want to have checkboxes. In the menu at the top, click Data. Next to “Criteria,” choose Checkbox. Click Use custom cell values. Next to “Checked,” enter a value. Optional: Next to “Unchecked,” enter a value. Click Save. How […]
Slope formula method to find that points are collinear. Three or more points are collinear, if slope of any two pairs of points is same. With three points A, B and C, three pairs of points can be formed, they are: AB, BC and AC. If Slope of AB = slope of BC = slope […]
Tap on the Messages icon, which appears as two speech bubbles. Find the conversation you want to hide and swipe left on it. This will provide you with some choice options. Tap on Archive to hide the messages. How can I hide my chat on Facebook? Click the message link on your home page. It […]