Excel chapters 1-4

Which conditional formatting option is not found in the quick analysis gallery ?

Where does excel automatically display statistics like count, average, and sum where a range of values is selected ?

Which of the following is not true about a fill color?

Which chart element cannot be chosen from the chart elements dialing box?

What do you use to separate arguments in a function ?

Which of the following is not true about sizing handles?

What should you not select for when selecting data for a chart ?

Which chart type displays tithe data vertically ?

How many sizing handles are found on embedded charts?

What punctuation is used to separate the two cell reference in a range?

Which of the following is not a way to widen a column ?

Which of the following is not a characteristic of a table?

A 100% stacker column chart is similar to which other chart in that it converts values to percentages?

what is the default method of referencing cell formulas?

In a structured reference what do you use to indicate a column heading or field name?

Which function would u use if u wanted to count the number of values but ignore the cells that have text or are empty?

What does pressing the enter key while in a cell do ?

Which excel function changes the value to a desired number of decimal places?

Which icon is not displayed when u select charts ?

To what does the ‘@‘ symbol refer in a structured reference?

Which chart type is not listed in the all chart window?

New workbooks contain how many worksheets

Which chart type cannot be displayed as a sparkline?

Which of the following is not a valid test in an =IF statement?

Which keyboard shortcut toggles through the type of reference options?

What is not found in the chart element list ?

The plot area is surrounded by how many axes?

Which axis displays incremental numbers to identify the approximate value of data points?

In a bar chart which axis displays the categories?

What is not true about creating a data table?

Which excel function changes the value to a desired number or decimal places?

Which of the following is not a conditional formatting option ?

In the formula SUBTOTAL(103,range) what does the 103 represent?

What is not a purpose of using an effective chart ?

In the task pane, what does a diagonal white triangle next to a chart category indicate ?

What chart type displays data as spokes going from the center to the outer edge of the chart?

What describes a function’s purpose?

What data does excel print by default?

Which of the following is not a chart element?

How does excel indicate that a column has been selected in a structured reference ?

Where does excel display the total row in a table ?

Where does the primary axis display on a combo chart ?

Which axis in a chart displays incremental numbers for the data points?

What terms refers to the necessity of following the rules when it comes to using functions ?

What can you not do from the select data dialog box?

What is not true about creating a data table?