Intermediate To Advanced Excel

1. You can use text in a formula.

True

False

You may use text in a formula when referring to the name of a range: When A1=2 and is named "Cars", you can enter =CARS+3 and the result will be 5. You may also also use text as a logical answer; Using A1=2, the function =IF(A1>0,"TRUE","FALSE") will result as TRUE.

Explanation

You may use text in a formula when referring to the name of a range: When A1=2 and is named "Cars", you can enter =CARS+3 and the result will be 5. You may also also use text as a logical answer; Using A1=2, the function =IF(A1>0,"TRUE","FALSE") will result as TRUE.

2. A macro is a recording of a series of steps that completes a task or group of tasks that can be "played back" later when needed.

True

False

A macro is a "mini program" the user creates in Excel by actually going through the steps desired while Excel records the keystrokes and commands typed.

Explanation

A macro is a "mini program" the user creates in Excel by actually going through the steps desired while Excel records the keystrokes and commands typed.

3. Conditional formatting allows you to restrict what data the user enters into a cell.

True

False

Conditional formatting will change the format of the cell when a condition in the cell is met. Data validation is the tool for restricting what data can be entered into a cell.

Explanation

Conditional formatting will change the format of the cell when a condition in the cell is met. Data validation is the tool for restricting what data can be entered into a cell.

4. To set up subtotals the data must first be formatted as a table.

True

False

The subtotals tool is grayed out and cannot be used unless the table formatting is removed.

Explanation

The subtotals tool is grayed out and cannot be used unless the table formatting is removed.

5. When creating a chart, you should never include total of the data.

True

False

True, if you include the total it will skew the data with one column, pie slice or point being far greater, 50% of all the displayed data combined, with the actual data you are analyzing only distributed over 50% of the chart.

Explanation

True, if you include the total it will skew the data with one column, pie slice or point being far greater, 50% of all the displayed data combined, with the actual data you are analyzing only distributed over 50% of the chart.

6. When sorting, you must highlight the entire column of the column you wish to sort by.

True

False

This is false. If you highlight the entire column, it will only sort the highlighted column changing the data for each record. It is only necessary to select the cell at the top of the column when selecting sort criteria.

Explanation

This is false. If you highlight the entire column, it will only sort the highlighted column changing the data for each record. It is only necessary to select the cell at the top of the column when selecting sort criteria.

7. How many data series can be used in a pie chart?

0

As many as you want.

1

7

A pie chart would be meaningless with more than one data series, therefore Excel will not even produce a pie chart if you try to use more than one data series.

Explanation

A pie chart would be meaningless with more than one data series, therefore Excel will not even produce a pie chart if you try to use more than one data series.