Enter a formula that contains a built-in function. Select an empty cell. Type an equal sign = and then type a function. For example, =SUM for getting the total sales. Type an opening parenthesis (. Select the range of cells, and then type a closing parenthesis). Press Enter to get the result.

You can easily insert a check mark (also known as a "tick mark") in Word, Outlook, Excel, or PowerPoint. These marks are static symbols. If you're looking for an interactive check box that you can click to check or uncheck, see: Add a check box or option button (Excel) or Make a checklist in Word. In your file, place the cursor where you want to insert the symbol.

Plug the USB end of the adapter into a USB charging port on your second display. If your display doesn't have a USB charging port, plug the USB end into any standard USB Type-A charger with 5W (5V/1A).

Select your version of Microsoft 365 below to learn how to activate Microsoft 365. Activate Microsoft 365 or a non-subscription version of Office. Activate Office that's pre-installed on a new Windows device. Activate an Office purchase or offer that's included on a new Windows device. Activate Office from Microsoft Workplace Discount Program.

Select the cell where you want to put the combined data. Type =CONCAT (. Select the cell you want to combine first. Use commas to separate the cells you are combining and use quotation marks to add spaces, commas, or other text. Close the formula with a parenthesis and press Enter. An example formula might be =CONCAT (A2, " Family").

Change the screen resolution. Stay in, or open, Display settings. Open your Display settings. In the Display resolution row, select the list and choose an option. It's usually best to stick with the one that's marked (Recommended). Monitors can support resolutions that are lower than their native resolutions, but text won't look as sharp and ...

Change mouse settings. Windows 7. You can customize your mouse in a variety of ways in Windows. For instance, you can swap the functions of your mouse buttons, make the mouse pointer more visible, and alter the scroll speed of the mouse wheel.

Here's an example of how to use VLOOKUP. =VLOOKUP (B2,C2:E7,3,TRUE) In this example, B2 is the first argument —an element of data that the function needs to work. For VLOOKUP, this first argument is the value that you want to find. This argument can be a cell reference, or a fixed value such as "smith" or 21,000.

The above function says if D2:D7 contains values lesser than $9000 or greater than $19,000, then SUM should display the sum of all those records where the condition is met. The formula finds two records D3 and D5 with values lesser than $9000, and then D4 and D6 with values greater than $19,000, and displays 4. Example 3

To change the power mode, select Start > Settings > System > Power & battery. For Power mode, choose the one you want. Note: You might not be able to change the power mode when a custom power plan is selected. If you can’t set the power mode in Power & battery settings, open Control Panel, select System and Security > Power Options, then ...