Blog

Which of the following is not one of the methods for naming a range of cells?

In cell H1, you type the formula =B3-B2 to calculate the change in volume from January to February at Location A. If you then deleted row 2 from the worksheet entirely, what value would result in cell H1?

If I want to fill the numeric cells in the table below with various shades of red, yellow, and green to illustrate the magnitudes of the values, which of the following should I use?

The screenshot below shows a subset of a data set of 263 patients at a local hospital. Variables include gender, age, whether the patient has heart disease or hypertension, whether they have suffered a stroke, their type of work and residence, average glucose level, BMI, smoking status, and the number of times they have visited the hospital’s Emergency Department (ED) in the past 12 months. What formula would return the total ED visits in the last 12 months for children?

Gerald created the PivotTable below that summarizes total the Total ED Visits in the past 12 months by smoking status and residence type. Instead of the integer values shown here, Gerald would like the PivotTable to show what percent of the ED visits were for rural patients vs. urban patients for each smoking status. How could he accomplish this?

A control chart is a specific type of:

Based on the data shown below, what value would be returned by the following formula? =SQRT(-D5)

Which of the following does not allow a user to add data visualization directly in the cell(s) in an Excel worksheet?

Mary works as a business analyst for a local bookstore, and she would like to study the total number of books sold by genre and format (hardcover vs. paperback). Which chart type would be best suited for this type of analysis?

The screenshot below shows a subset of a data set of 263 patients at a local hospital. Variables include gender, age, whether the patient has heart disease or hypertension, whether they have suffered a stroke, their type of work and residence, average glucose level, BMI, smoking status, and the number of times they have visited the hospital’s Emergency Department (ED) in the past 12 months. David needs to create a summary that shows the number of patients seen by Work Type and Smoking Status. He creates a PivotTable, places Work Type in the Columns area, Smoking Status in the Rows area, and Heart Disease? in the Values area. Will this result the summary he needs?