LOOKUP function uses a TRUE lookup type. with NESTED function,you include that function inside.Excel provides CONDITIONAL FORMAT tools, tools you can identify.Enter a row_num,column_num,area_num,excel display ERROR MESSAGE.30 MOVING AVERAGE trendline is used to smooth out the data. goal seek uses AN ITERATIVE approach to finding the right input. X-AXISLABELS identify the category plotted on the x-axis. Excel rounds the display, EQUAL OR GREATER THAN HALF. excel can contain CONSTANT CELL REFERENCE. in this case you enter range as FIRST argument. Dun and Bradstreet 1 to 4. COUNTIF(F3:F13,>_=1). 15DIGITS. Select the cell containing the text you want to change.Click the down arrow next to the size box on the format bar. Typically, the default size is 11 or 12, as shown in the above example.After clicking the down arrow for the size, you should have a selection of different sizes to choose. Some fonts may not scale properly, so they may have limited size options. =B11*D5*B1. #2.$.OPEN HIGH LOW CASE.