D388 Fundamentals of Spreadsheets and Data Presentations - Set 1 - Part 2

Test your knowledge of technical writing concepts with these practice questions. Each question includes detailed explanations to help you understand the correct answers.

Question 21: In which scenario would you use the AVERAGE function?

To count the number of entries in a dataset

To find the midpoint of a set of values

To calculate the sum of all values in a dataset

To compute the mean of a set of values

Question 22: What does the term "parsing" refer to in data management?

The process of summarizing data

The process of structuring and converting data from one form to another

The process of cleaning up erroneous data

The process of visualizing data

Question 23: Which Excel function would you use to identify how many cells contain numeric values?

COUNTA

COUNT

SUM

AVERAGE

Question 24: In Excel, how does an absolute reference differ from a relative reference?

Absolute references adjust when copied; relative references do not.

Absolute references remain fixed; relative references change when copied.

Absolute references are only used in charts; relative references are not.

There is no difference between absolute and relative references.

Question 25: What are the three main strategies for dealing with missing values in a dataset?

Substitute, delete, or ignore

Leave missing, replace with average, or replace based on other columns

Always delete, replace with zero, or leave as missing

Create duplicates, ignore, or analyze trends

Question 26: What is the purpose of using filters in Excel?

To visually represent data trends

To isolate specific data points based on criteria

To permanently delete data

To automate data entry

Question 27: What does the term "range" refer to in Excel?

The highest and lowest values in a dataset

A group of cells selected for a function

A graphical representation of data

The average value in a dataset

Question 28: Which type of chart is best for comparing trends over time?

Pie chart

Column chart

Line chart

Area chart

Question 29: In a statistical context, what does the term "outlier" refer to?

A common value within the data

A value that is significantly different from other observations

A calculated average of the dataset

A data point that is repeated frequently

Question 30: How can you determine the median in a dataset?

Add all values and divide by the number of values

Identify the middle value when the data is sorted

Find the mode of the dataset

Calculate the difference between the highest and lowest values

Question 31: Which of the following is an example of a categorical variable?

Height of individuals

Age of respondents

Favorite color of participants

Weight of objects

Question 32: In Excel, which function would you use to calculate the smallest value in a set of data?

MAX

MIN

AVERAGE

SUM

Question 33: What does the term "vertical axis" refer to in a chart?

The axis that runs horizontally

The axis that typically represents categories

The axis that usually shows values or measures

The axis that indicates the total sum

Question 34: When should you use "descriptive statistics"?

To predict future trends

To summarize and describe the main features of a dataset

To determine the relationship between variables

To test hypotheses

Question 35: What is the significance of using absolute references in Excel formulas?

They allow formulas to change when copied.

They keep certain cell references fixed during calculations.

They simplify data entry.

They can only be used in charts.

Question 36: What would be the consequence of having duplicate data in a dataset?

It enhances the accuracy of analyses.

It may skew results and lead to incorrect conclusions.

It simplifies data entry.

It provides additional insights.

Question 37: When presenting data, what is the primary benefit of using a bar chart?

It displays proportions of a whole.

It allows for easy comparison across categories.

It shows trends over time.

It simplifies complex data.

Question 38: What is an important aspect of the frequency distribution table?

It includes all data points individually.

It organizes data into specified classes or categories.

It provides a single summary measure of the data.

It visualizes trends over time.

Question 39: In Excel, how would you find the average of a range of cells labeled A1 to A10?

=SUM(A1)

=AVERAGE(A1)

=COUNT(A1)

=MAX(A1)

Question 40: What is the purpose of a header in an Excel worksheet?

To display the total number of rows

To describe the content of the column below

To highlight the most important data

To provide a summary of calculations

Don't Want to Study?

Save Time on Studies, Spend More with Family & Friends! Pay-After-you-Pass!

Get Exam Support