USING MICROSOFT EXCEL
MODIFYING PAGE SETUP PROPERTIES IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
First Point
|
|
|
High Point
|
|
|
Last Point
|
|
|
Low Point
|
|
|
None
|
Detailed explanation-1: -What is the MAX Function? The MAX Function[1] is categorized under Excel Statistical functions. MAX will return the largest value in a given list of arguments. From a given set of numeric values, it will return the highest value.
Detailed explanation-2: -More formatting options to show highest and lowest values On the Home tab, click Conditional Formatting > New Rule. In the New Formatting Rule dialog box, choose Format only top or bottom ranked values. In the drop-down list, select Top or Bottom, and type how many values to highlight in the box next to it.
Detailed explanation-3: -Select the chart series and go to format series (Click on the series, press CTRL+1). Now, set up series overlap to 100% and your maximum value is highlighted.