Using IF with AND, OR, and NOT functions in Excel
WebIn this case both conditions are true, so TRUE is returned. =IF(AND(A3="Red",B3="Green"),TRUE,FALSE) If A3 (“Blue”) = “Red”, AND B3 (“Green”) equals “Green” then return TRUE, otherwise return FALSE. In this case only the first condition is true, so FALSE is returned. =IF(OR(A4>0,B4<50),TRUE, FALSE)
Use the On-Screen Keyboard (OSK) to type - Microsoft Support
WebThe most common type is a physical, external keyboard that plugs into your PC. But Windows has a built-in Accessibility tool called the On-Screen Keyboard (OSK) that can be used instead of a physical keyboard. You don’t need a touchscreen to use the OSK.
Create a document in Word - Microsoft Support
WebCreate a new document. On the File tab, select New. Select Blank document, or double-click a template image or type the kind of document into the Search for online templates box and press Enter. Tip: For practice using Word features, try a learning guide like Welcome to Word or Insert your first table of contents. Add and format text.
Use Excel built-in functions to find data in a table or a range of ...
WebThis article uses the following terms to describe the Excel built-in functions: The value to be found in the first column of Table_Array. The range of cells that contains possible lookup values. The column number in Table_Array the matching value should be returned for. A range that contains only one row or column.
Basic tasks in Excel - Microsoft Support
WebGet started with basic tasks in Excel such as opening a workbook, entering and formatting data, calculating data, and trying some quick analysis features..
How to search in Outlook - Microsoft Support
WebThese suggestions are based on your search and message history. Any suggested search with a clock icon to the left will return all messages that contain the search string in the subject, message body, and even any Microsoft 365 attachments. Note: Outlook uses what's called prefix matching when searching.
Virus & threat protection in Windows Security - Microsoft Support
WebIn early versions of Windows 10, Windows Security is called Windows Defender Security Center. Virus & threat protection in Windows Security helps you scan for threats on your device. You can also run different types of scans, see the results of your previous virus and threat scans, and get the latest protection offered by Microsoft Defender ...
Create a document - Microsoft Support
WebOpen Word. Select Blank document. Or, if Word is already open, select File > New > Blank document. Open Word. Or, if Word is already open, select File > New. Double-click a template to open it. Tip: Pin templates you like, so you always see them when you start Word. Select the template and then select the pin icon that appears next to the name ...
Customize the Outlook window - Microsoft Support
WebThe reading pane, sometimes called the preview pane, lets you read items without opening them. You can customize the reading pane according to your preferences. Reposition or hide the reading pane. The reading pane can be positioned on the right of the Outlook window, below the item list, or hidden.
Recall an email message that you sent in Outlook
WebSelect Sent Items in the left folder pane, then double-click the sent message to open it in a separate window. From the ribbon, select Recall Message, then select OK in the confirmation dialog box. Shortly thereafter, you'll receive …
Format text as superscript or subscript in Word - Microsoft Support
WebSelect the text that you want to format as superscript or subscript. Go to Home, in the Font group, select the Font Dialog Box Launcher . Select Superscript or Subscript in the Effects group. Tip: You can make text superscript or subscript without changing the font size. For superscript, enter a higher percentage in the Offset box.
Skip to content