Free Practice Quiz Question List

1 Spreadsheet Data Foundations Online Quiz Questions

Use this free practice quiz with 20 questions to review 1 Spreadsheet Data Foundations, test your knowledge, and prepare for your next test or exam.

20 questions

Choose one

1 point

Which statement correctly describes how spreadsheet cell formatting relates to the value stored in the cell?

A
Formatting a number to display two decimal places always removes any additional stored decimal places.
B
Formatting controls how a value appears and does not necessarily change the stored value.
C
A cell can contain only numbers or formulas, not text or dates.
D
A date that looks correct is necessarily stored as a date rather than text.

True or false

1 point

A ZIP code beginning with zero may be stored as text to preserve that leading zero.

A
True
B
False

Choose one

1 point

A worksheet contains a simple list that will be sorted and analyzed. Which practice helps prevent non-record content from being treated as part of the data?

A
Merge cells across the data range to make the list look uniform.
B
Insert blank rows between groups so the spreadsheet can identify each group.
C
Keep notes and totals outside the data table.
D
Use multiple header rows to distinguish fields from records.

Fill in the blank

1 point

In a formula copied down several rows, the tax-rate cell must remain fixed at $F$1. This is an .

Choose one

1 point

In a spreadsheet application, what does the range A1:A5 refer to?

A
It includes every cell from A1 through A5 in column A.
B
It includes only cells A1 and A5.
C
It includes the rectangle from A1 through E5.
D
It refers to two separate ranges in columns A and C.

True or false

1 point

When a formula containing the relative reference A2 is copied one row down, that reference changes to A3.

A
True
B
False

Written response

1 point

A formula contains the relative cell reference A2. What reference does it become when the formula is copied exactly one row down?

Choose one

1 point

In a spreadsheet application that accepts comma-separated range arguments, what does A2:A5,C2:C5 designate?

A
One rectangular range from A2 through C5.
B
Two separate ranges: A2 through A5, and C2 through C5.
C
Every cell in column A and column C.
D
The cells A2 and C5 only.

Written response

1 point

A formula copied across and down must continue referring to the tax rate in cell F1. Enter the cell reference that fixes both its column and row.

Choose all

1 point

Which statements correctly describe mixed references? Select all that apply.

A
$A2 fixes the column and allows the row to adjust.
B
A2 fixes both the column and the row.
C
A$2 fixes the row and allows the column to adjust.
D
$A$2 allows both the column and the row to adjust.

True or false

1 point

True or false: Displaying a number with two decimal places guarantees that only two decimal places are stored in the cell.

A
True
B
False

Choose one

1 point

You are setting up a simple order list so it can be sorted and summarized reliably. Which layout should you use?

A
Put each field in its own row and use a separate block of columns for each record.
B
Put each record in one row, each field in one column, and use a clear header row.
C
Merge the header cells for related fields and leave blank rows between records.
D
Use multiple header rows to group records by category.

Choose one

1 point

A ZIP code list includes values that begin with zero. What should you do to help preserve those leading zeros when entering the codes?

A
Store the codes as numbers and increase the displayed decimal places.
B
Enter the codes as dates so the spreadsheet recognizes their fixed length.
C
Format the cells as Text before entering the codes.
D
Remove leading zeros so every code is stored as a number.

Choose one

1 point

You are about to make cleanup changes that may be difficult to undo. What is the best first step to protect the data?

A
Keep an untouched copy of the original data before editing.
B
Delete all rows with blanks before checking what the blanks mean.
C
Replace every unusual value with zero, then save over the original.
D
Sort the data and remove records that appear near the bottom.

Choose one

1 point

A data column has missing entries. Which practice makes those entries easiest to interpret consistently during later analysis?

A
Use a different placeholder in each row to show that the values are missing.
B
Enter zero in every empty cell, regardless of the field.
C
Leave blanks without documenting what they mean.
D
Use a consistent representation for missing values and document what a blank means.

Written response

1 point

Imported entries look like numbers but do not behave as expected in calculations or sorting. What specific data issue should you check for?

Written response

1 point

Enter a mixed cell reference that fixes column A but allows the row number to adjust when the formula is copied.

Choose all

1 point

A spreadsheet contains several orders, and some customers appear on multiple rows. Which actions are appropriate when checking for duplicate records? Select all that apply.

A
Delete every row that repeats a customer name.
B
Compare the fields that identify an order before deciding whether rows are duplicates.
C
Treat any two rows with the same customer name as the same order.
D
Check whether rows with the same customer name could represent different orders.

Fill in the blank

1 point

A date entered in the Product column is an example of a value in the .

Open ended

1 point

A sales table uses “NY,” “New York,” and “New York City” for a category that staff say should have one consistent label. Describe a safe way to clean these entries and one check to perform before summarizing the data.