USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
In cell B28 on the Profits worksheet, insert a formula that displays the number of Sales greater than 250. Which formula would you use?
|
|
COUNTIF
|
|
|
IF
|
|
|
COUNTNUMBERS
|
|
|
MAx
|
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: -Which of the following formulas will yield the correct daily average as in cell G8? The correct answer is B. The average function sums the scope of elements and divides that sum by the number of elements. Answer B averages all the daily paychecks in the table; therefore, it will yield the total daily average.
Detailed explanation-3: -On the Qtr 2 worksheet, select the Formulas tab. 2. On the Formulas tab, in the Formula Auditing group, click Show Formulas.
There is 1 question to complete.