excel chapter 3 and 4

which statement is not a recommended guideline for designing and creating an Excel table?

You have a list of all the employees in your organization. The list contains employee name, office, title, and salary. You want to list all employees in each office branch. The branches should be listed alphabetically, with the employee earning the highest salary listed first in each office. Which is true of your sort order

What is the typical sequence for creating a chart?

Which icon does not display to the right of a selected chart?

Which check box in the Table Style Options group enables you to apply different formatting to the records in a table?

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?

When you select the ______ rule type, the New Formatting Rule dialog box does not show the Format button.

The value axis currently shows increments such as 50,000 and 100,000. What do you select to display increments of 50 and 100?

Which tab contains commands to apply a predefined chart layout that controls which elements are included, where, and their color scheme?

You want to create a single chart that shows each of five divisions’ proportion of yearly sales for each year for five years. Which type of chart can accommodate your needs?

What indicates that the closing price was higher than the opening price in a stock chart?

If you want to show exact values for a data series in a bar chart, which chart element should you display?

Which of the following applies to a sparkline?

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?

You want to display a total row that identifies the oldest date in a field in your table. What function do you select from the list?

Which type of chart is the least appropriate for depicting yearly rainfall totals for five cities for four years?

You suspect a table has several identical records. What should you do?

Which date filter option enables you to specify criteria for selecting a range of dates, such as between 3/15/2016 and 7/15/2016?

What type of conditional formatting displays horizontal colors in which the width of the bar indicates relative size compared to other values in the selected range?

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?