![]() ![]() AVERAGE The RAND function returns a random number between 0 and 1. AVERAGEIFS The _ function returns the arithmetic mean of a range of numbers. AVERAGEIF The _ function requires these arguments: (average_range,criteria_range1,criteria1,criteria_range2,criteria2.). The _ function is used to find the arithmetic mean of the cells within a specified range that meet a single criterion. The COUNTIFS function is used to count cells that meet multiple criteria. The COUNTIF function counts cells within a range that meet a single criterion. The COUNTA function is used when the cells in the range contain text or a combination of text and numbers. copy In the SUMIF function, the range argument is where to look for the data. name At the Name Manager dialog box, you can do all the following except _ a range name. the same L2 C2: Assigning a _ to a range of cells allows you to reference the source by a descriptive label rather than the range address. Action To apply an advanced filter using the And logical operator, enter criteria in _ row(s). At the Advanced Filter dialog box, use options in the _ section to filter the list in its current location or copy the filtered list to another location. ![]() positive numbers negative numbers In addition to the asterisk, which wildcard character can be used in a custom filter? question mark (?) What is the first step in sorting by color? Select the range. The custom number format will display _ in green and _ in red. ![]() In a custom number format, the # format code represents a digit. Custom number formats are stored in the workbook in which they are created. Which of the following is not one of them? Fraction Style At the Format Cells dialog box with the Number tab selected, if Special is selected in the Category list box and English (United States.) is selected in the Locale option box, the Type list box will contain each of the following options except Student ID. Scientific The Number group on the Home tab contains three buttons for popular formats. _ formatting converts a number to exponential notation. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |