CSC Questions and Answers

CSC Questions and Answers A worksheet contains columns listing new movie releases, total production costs, week 1 gross revenue, and week 2 gross revenue. Which of the following would least likely form a data series in a column chart? Movie names What is an advantage of using the Recommended Charts command? The Insert Chart dialog box displays recommended chart types based on the selected data. Previous Play Next Rewind 10 seconds Move forward 10 seconds Unmute 0:00 / 0:15 Full screen Brainpower Read More What type of chart would display the names of seven city names (such as Jefferson City and Salt Lake City) on a category axis that is the easiest to read? Bar Chart You want to create a single chart that shows the proportion of yearly sales for five divisions for each year for five years. Which type of chart can accommodate your needs? 100% Stacked column chart Why would you add Alt Text to a combo chart? To adhere to accessibility compliance for screen reader capabilities The value axis currently shows increments such as 50,000 and 100,000. What option would you select to display the values in increments of 50 and 100? Show Axis in Thousands Which chart element should you display to show exact values for a data series in a bar chart? Data labels Currently, a column chart shows values on the value axis, years on the category axis, and state names in the legend. What should you do if you want to organize data with the states on the category axis and the years shown in the legend? Switch the rows and columns in the chart. You have a large dataset that will print on several pages. You want to ensure that related records print on the same page with column and row labels visible and that confidential information is not printed. You should apply all of the following page setup options except which one to accomplish this task? Change the print page order. You are working with a large worksheet. Your row headings are in column A. Which command(s) should be used to see the row headings and the distant information in columns X, Y, and Z? Freeze Panes command Which statement is not a recommended guideline for designing and creating an Excel table? Leave one blank row between records in the table. Correct Answer Which of the following characters is a wildcard in Excel? * What should you do to ensure that records in a table are unique? Use the Remove Duplicates command. Which conditional formatting rule is best suited to highlight sales value less than $300? less than