The CHARLIST is enclosed in brackets ([ ]) and can be used with wildcard characters for more specific matches.Examples of wildcard character pattern matching in expressions. C haracter(s) Use to match ? or _ (underscore) Any single character * or % Zero or more characters How do you run a wildcard search? To perform a […]

To combine text from two or more cells into a single cell, use the CONCATENATE function, which you may enter in Google Sheets on the web (Figure D) as well as the mobile apps. This lets you specify source cells and also add text and or separators before, between, or after the cells that you […]

Here’s how to use this tool: Type or Copy (CTRL+C) & Paste (CTRL+V) the text in the Editor. Click the Lookup button. Spelling, Grammar, and Punctuation mistakes will be underlined. How do you check a sentence is grammatically correct? In order for a sentence to be grammatically correct, the subject and verb must both be […]

Select the method to standardize the data: Subtract mean and divide by standard deviation: Center the data and change the units to standard deviations. Subtract mean: Center the data. Divide by standard deviation: Standardize the scale for each variable that you specify, so that you can compare them on a similar scale. What does it […]

Here are the steps to use the normalization formula on a data set: Calculate the range of the data set. Subtract the minimum x value from the value of this data point. Insert these values into the formula and divide. Repeat with additional data points. What are the three steps in normalizing data? 3 Stages […]

The slope formula slope = (y₂ – y₁) / (x₂ – x₁) Notice that the slope of a line is easily calculated by hand using small, whole number coordinates. The formula becomes increasingly useful as the coordinates take on larger values or decimal values. How do you find the slope of an equation? Using the […]

How to change the text color in Google Slides on desktop Go to slides. Add your text if necessary, and then highlight the text you want to change the color of. Select “Format” in the top toolbar. Hover over “Text” and then “Color.” Select the color you want to use from the available options. Can […]

You can see your Microsoft Planner Tasks and any flagged Outlook emails in the To Do app, and you can add tasks from other apps (like OneNote).To put it simply, To Do is for granular, day-to-day, personal task management, whereas Microsoft Lists is better for larger-scale team project, process, or workflow management. What is the […]

One of Microsoft To Do’s features is an integration with Outlook Tasks. To view your To Do tasks on your Outlook Desktop client or on Outlook.com, use the same Microsoft account to sign in to both Microsoft To Do and Outlook. How do I add Microsoft To Do to Outlook? If you’re signing in to […]

To view your To Do tasks on your Outlook Desktop client or on Outlook.com, use the same Microsoft account to sign in to both Microsoft To Do and Outlook. All tasks are stored on Exchange Online servers, so they’ll be shown in both Microsoft To Do and Outlook Tasks automatically. How do I add Microsoft […]