Using wildcard characters in searches - Microsoft Support
Use wildcard characters as comparison criteria for text filters, and when you're searching and replacing content. This feature enables you to find values that share a simple pattern. These characters can be the asterisk (*), the question mark (?), and the tilde (~).
FIXED function - Microsoft Support
This article describes the formula syntax and usage of the FIXED function in Microsoft Excel. Description. Rounds a number to the specified number of decimals, formats the number in decimal format using a period and commas, and returns the result as text. Syntax. FIXED (number, [decimals], [no_commas])
SWITCH function - Microsoft Support
Applies To. The SWITCH function evaluates one value (called the expression) against a list of values, and returns the result corresponding to the first matching value. If there is no match, an optional default value may be returned.
Keyboard shortcuts for the File menu in Microsoft 365 for Windows
Use the File menu keyboard shortcuts. Frequently used shortcuts. Create a new Microsoft 365 file. List, open, and search for files. Save and rename Microsoft 365 files. Print Microsoft 365 files. Create a PDF or XPS file or change the file type. Protect, …
File formats that are supported in Excel - Microsoft Support
Applies To. You can save an Excel file in another file format by clicking the File > Save As. The file formats that are available in the Save As dialog box vary, depending on what type of sheet is active (a worksheet, chart sheet, or other type of sheet).
CEILING.MATH function - Microsoft Support
This article describes the formula syntax and usage of the CEILING.MATH function in Microsoft Excel. Description. Rounds a number up to the nearest integer or to the nearest multiple of significance. Syntax. CEILING.MATH (number, [significance], [mode]) The CEILING.MATH function syntax has the following arguments. Number Required.
CEILING function - Microsoft Support
Description. Returns number rounded up, away from zero, to the nearest multiple of significance. For example, if you want to avoid using pennies in your prices and your product is priced at $4.42, use the formula =CEILING (4.42,0.05) to round prices up to the nearest nickel. Syntax. CEILING (number, significance)