MGSC 290 Exam 2 Computer Part Questions And Answers 100% Verified 2024/2025

MGSC 290 Exam 2 Computer Part Questions And Answers 100% Verified 2024/2025 1) Switch the rows and columns in the chart, so the data point - answerOn the Chart Tools Design tab, in the Data group, click the Switch Row/Column button. 2) Enter a formula using the REPLACE function to replace only the fourth character in cell A2 with the single character "-" (the hyphen character). - answerOn the Formulas tab, in the Function Library group, click the Text button. Click REPLACE. In the Old_text argument box, enter A2. In the Start_num argument box, enter 4. In the Num_characters argument box, enter 1. In the New_text argument box, enter "-". Click OK. 3) Add a linear trendline to this chart. Use the default trendline formatting. - answerClick the Chart Elements button that appears near the upper right corner of the chart. Click the Trendline check box to add a checkmark. 4) Add a report filter for the Employee field and use it to filter the PivotTable to show only data where the value of the Employee field is Dr. Patella. - answerClick the Employee field in the PivotTable Fields pane and drag it to the Filters box in the bottom part of the pane Click the filter arrow next to the report filter. Click Dr. Patella. Click OK.