Free Practice Quiz Question List

1 Spreadsheet Fundamentals and Data Organization Online Quiz Questions

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

20 questions

True or false

1 point

A sales dataset uses each row for one order and each column for an attribute such as date or quantity. This follows the principle of one record per row and one variable per column.

A
True
B
False

Fill in the blank

1 point

A group of spreadsheet cells, such as A1:C4, is called a .

Written response

1 point

In a dataset organized with one characteristic per column, what is that characteristic called?

Choose one

1 point

Which layout is most likely to help spreadsheet tools recognize a dataset as one table?

A
Place totals between groups of records and merge cells for headings.
B
Leave blank rows between records to make the table easier to read.
C
Keep the records in one continuous rectangular block with no merged cells or inserted totals.
D
Put each record in a separate worksheet so the data remains distinct.

True or false

1 point

If a cell is formatted to display a number as a date, that formatting alone guarantees that the cell contains a date value rather than text.

A
True
B
False

Choose all

1 point

Select all practices that support reliable analysis of a dataset.

A
Use one consistent data type within each column.
B
Enter values such as 12, twelve, and N/A in the same numeric column.
C
Give columns short, meaningful, unique headers.
D
Combine city and state in one field even when they need separate analysis.
E
Split information into separate fields when it needs separate analysis.

Fill in the blank

1 point

When missing information should be marked rather than left blank, use a instead of using 0 when zero is not the true value.

Choose one

1 point

An imported quantity column looks numeric, but its entries do not sort or calculate as expected. Which issue could explain this problem?

A
The column has a header row.
B
The value may be stored as text instead of as a number.
C
The value is displayed with a number format.
D
The column contains measurements.

Choose all

1 point

Select all statements that correctly describe spreadsheet cell references.

A
A relative reference such as A2 can change when its formula is copied.
B
An absolute reference such as $A$2 stays fixed when copied.
C
A mixed reference such as $A2 fixes only the row.
D
A mixed reference such as A$2 fixes the row.

Written response

1 point

A ZIP code may start with zero, and arithmetic on it is not needed. Which data type is often most appropriate for storing it?

Open ended

1 point

A spreadsheet contains order records, but city and state are combined in one field, subtotal rows interrupt the records, and notes appear among the entries. Explain how you would reorganize it so the dataset is easier to select, sort, filter, and analyze. Include how you would handle missing values and column headers.

Choose one

1 point

A dataset has a single Location column containing entries such as "Riverton, North State." What change would best support separate analysis of cities and states?

A
Put the combined location in a notes row beneath the records.
B
Keep the combined field and add a duplicate combined-location column.
C
Split the combined location into separate city and state columns.
D
Move all locations to a worksheet that contains no other fields.

Choose one

1 point

How many cells are included in the range A1:C4, counting both endpoints?

A
8 cells
B
12 cells
C
16 cells
D
20 cells

Choose one

1 point

You are preparing a table that will be sorted and filtered. Which header-row choice best supports working with the data?

A
Give each column the same header so related fields are grouped.
B
Leave headers blank when the values below them are consistent.
C
Give each column a clear, distinct header.
D
Put explanatory notes in the header row instead of naming columns.

True or false

1 point

True or false: Changing a cell’s display format alone guarantees that its stored contents have the intended data type.

A
True
B
False

Written response

1 point

A dataset uses one row consistently for each individual order. What is the role of that row called?

Choose one

1 point

A dataset will be used to analyze orders by city and by state separately. How should the location information be organized?

A
Store city and state in separate columns.
B
Combine city and state into one column to keep each record compact.
C
Put the city in a column and the state in a note below the table.
D
Use separate rows for city and state within each record.

Choose one

1 point

A quantity column will be used for calculations. Which approach best keeps its entries consistent?

A
Enter quantities as numbers, but write some values as number words for variety.
B
Use numeric values consistently in the quantity column; handle missing values separately.
C
Replace unavailable quantities with the text N/A in the same numeric column.
D
Use a different unit for each row and leave the unit implicit.

Written response

1 point

A tax rate is stored in F1. Which cell reference should a formula use so that the reference stays fixed when the formula is copied down?

Choose one

1 point

A formula contains the reference $A2. What happens to its column and row references when the formula is copied to another location?

A
Both the column and row stay fixed.
B
The column can change, but the row stays fixed.
C
The column stays fixed, but the row can change.
D
Both the column and row can change.