USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
On the Profits worksheet, enter a formula in cell A29 that uses an Excel function to return the average costs of the fudge flavors based on the values in the Cost column. What formula would you use?
|
|
AVERAGE
|
|
|
SUM
|
|
|
COUNTIF
|
|
|
AVERAGEIF
|
Explanation:
Detailed explanation-1: -Configure Excel to always print cell range A1:F17 on the Q1 Sales worksheet. On the Q1 Sales worksheet, select cell range A1:F17. Click the Page Layout tab. In the Page Setup group, click Print Area and select Set Print Area.
Detailed explanation-2: -To remove a chart’s data series, click “Chart Filters” and then click “Select Data.” Select the series in the Legend Entries (Series) box, and then select “Remove.” Click “OK” to update the chart.
Detailed explanation-3: -The quickest and easiest way to sum a range of cells is to use the Excel AutoSum button. It automatically enters an Excel SUM function in the selected cell.
There is 1 question to complete.