USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Leah and her fellow FBLA officers want to analyze scores from the most recent competitive events. Which of the cell values would least likely be determined by using the Conditional Formatting feature of Excel?
|
|
cell values that indicate advisor names
|
|
|
cell values that are below average
|
|
|
cell values that are above average
|
|
|
cell values that indicate the top three performers
|
Explanation:
Detailed explanation-1: -This is how it is done: STEP 1: Select all the cells in your Excel worksheet by clicking on the top left hand corner of your worksheet. STEP 2: Press the CTRL+G shortcut which will open up the Go To dialogue box and select the Special button. STEP 3: Select the Formula radio button and press OK.
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.
There is 1 question to complete.