Question 46

in which three formats can you export a worksheet from the Worksheet menu? Choose three
  • Question 47

    Open the link to Book1 found on the desktop. Open the Line worksheet.
    Modify the chart to show only main and max values of both measures in each region.

    Question 48

    You have a dataset that contains daily sales by business segment from 2017 to the present You want to use monthly historical trends to predict sales by segment in the future Which three actions should you perform m order?
    (Place the three correct options in order Use the arrows to move Options lo Answer Area I In Answer Area arrows to re order the options.)

    Question 49

    Open the link to Book1 found on the desktop. Open the CategoryPercentage worksheet.
    Modify the bar chart show the percentage of sales for each Subcategory within every Category. The total percentage for every Category must be 100%.

    Question 50

    You have a table that contains four columns named Order Date, Country, Sales, and Profit.
    You need to add a column that shows the day of the week for each row. For example, orders placed on August
    31, 2022, will show a day of
    Wednesday.
    How should you complete the formula? (Use the dropdowns in the Answer Area to select the correct options to complete the formula.)