Free Practice Quiz Question List

4 Tables and Data Preparation Online Quiz Questions

Use this free practice quiz with 20 questions to review 4 Tables and Data Preparation, test your knowledge, and prepare for your next test or exam.

20 questions

Choose one

1 point

You are organizing a sales dataset for sorting and analysis. Which layout follows the recommended table structure?

A
Use one header row, one record per row, and one field per column.
B
Put several records in each row and use a column for each record.
C
Merge related fields into one column and add subtotals throughout the data range.
D
Use extra title rows inside the data range to describe each group of records.

True or false

1 point

A table is filtered to show only one region. Rows from other regions are temporarily hidden, and clearing the filter restores the full dataset.

A
True
B
False

Written response

1 point

A ZIP code begins with zero, and that zero must remain visible. What format type should be used for this identifier?

Fill in the blank

1 point

A dataset may need to be analyzed by first name and last name independently. Store these values in .

Choose one

1 point

A spreadsheet displays a measurement with two decimal places, but a calculation suggests the stored value may have more precision. What should you conclude?

A
The stored value has definitely been rounded to two decimal places.
B
The display may hide additional decimal places, so check the underlying value if precision matters.
C
The value must be a currency amount because it has two decimal places.
D
The cell is invalid because displayed and stored values must always have the same precision.

Choose all

1 point

Select all formatting choices that support clear and consistent interpretation of a dataset.

A
Use one consistent date format in a date column.
B
Format monetary values as currency.
C
Format rates as currency.
D
Use the same units and number of decimal places within comparable fields.

True or false

1 point

A spreadsheet uses color as the only way to distinguish important categories. This is a reliable design choice for a table.

A
True
B
False

Fill in the blank

1 point

To limit new entries to approved category choices and reduce spelling variations, use .

Choose one

1 point

A sales table has repeated customer names and a few repeated transaction IDs. What is the best way to investigate possible duplicates?

A
Delete every repeated customer name because customer names must be unique.
B
Delete all repeated rows immediately without checking what identifies a record.
C
Check repeated transaction IDs as possible issues, and preview duplicates before deleting them.
D
Treat any repeated value in any column as proof that the record is invalid.

Choose all

1 point

A region field contains entries such as “N,” “north,” and “North.” Select all actions that help standardize the data without changing the meaning of missing values.

A
Choose one spelling and format for each category.
B
Remove accidental spaces from entries.
C
Check for inconsistent units.
D
Replace every blank entry with zero.

Written response

1 point

When a data range is made into a table, what built-in controls do its headers provide?

Open ended

1 point

A quantity cell is blank, and an analyst proposes entering zero so calculations will be easier. Explain why this may be inappropriate and describe a better way to handle the blank.

Choose one

1 point

A team gives its sales table and columns meaningful names. What is one practical benefit when formulas refer to data in that table?

A
They guarantee that all values in the table are accurate.
B
They let formulas use table and column names rather than fixed cell ranges.
C
They automatically remove missing values and duplicates.
D
They prevent users from sorting or filtering the table.

True or false

1 point

Before correcting or excluding data during preparation, keeping an untouched copy helps you check or reverse those changes.

A
True
B
False

Choose one

1 point

A sales table has some blank cells in its Units column. Before analyzing the data, what is the best way to handle those blanks?

A
Replace every blank with zero so calculations can proceed.
B
Decide whether blanks are allowed, need correction, or should be marked explicitly.
C
Delete every row containing a blank.
D
Treat each blank as proof that the measurement was zero.

Choose one

1 point

A spreadsheet displays a measurement as 14.20, but a calculation seems to use more precision than that. What should you do before relying on the displayed value?

A
Replace the value with a rounded number because the display already shows two decimals.
B
Change the cell to text so the displayed digits cannot change.
C
Check the underlying value because the number format may hide additional precision.
D
Assume the displayed value is exact unless the cell is formatted as currency.

Choose one

1 point

A product code can begin with zero, and those leading zeros are part of the code. How should the code column be formatted to preserve them?

A
Format the identifier as text.
B
Format the identifier as a percentage.
C
Convert the identifier to a whole-number quantity.
D
Remove leading zeros before entering the identifier.

Choose one

1 point

You need to sort a table by Region. Which action helps ensure each region remains matched with the correct date, product, units, and revenue?

A
Sort only the selected column and leave the other columns unchanged.
B
Copy the selected column elsewhere, sort it, and paste it over the original.
C
Filter the selected column, then rearrange only the visible cells.
D
Sort the entire table so that each record’s fields stay together.

Written response

1 point

Name one method in Excel that can restrict category entries to approved choices and reduce spelling variations.

Written response

1 point

A sales file has a column labeled Transaction Date, but its entries were imported from another system. Before analyzing the dates, what underlying data type should you verify the entries have?