Question 1

What is a spreadsheet?

Accepted Answer

A software package that organizes data in rows and columns.

Answer

A type of database for storing images.

Answer

A tool for creating presentations.

Answer

A software used for programming.

Question 2

What is a cell in a spreadsheet?

Accepted Answer

A single unit formed at the intersection of a column and a row.

Answer

A command for data manipulation.

Answer

A graph that represents data.

Answer

A type of formula used in calculations.

Question 3

What is the purpose of an absolute cell referencing?

Accepted Answer

To prevent a cell reference from changing when other cells are filled in.

Answer

To calculate averages across rows.

Answer

To format cells in different colors.

Answer

To change cell references automatically.

Question 4

What does VLOOKUP do?

Accepted Answer

It searches for a value in a column.

Answer

It compares values between rows.

Answer

It creates a pie chart for data representation.

Answer

It calculates the minimum value in a range.

Question 5

What is a pivot table used for?

Accepted Answer

To provide summary data such as totals and averages for a data set.

Answer

To create static charts and graphs.

Answer

To protect sensitive data in cells.

Answer

To enter data manually into a spreadsheet.

Question 6

What does CSV stand for?

Accepted Answer

Comma-separated values.

Answer

Coded structured visuals.

Answer

Column-selected variables.

Answer

Computer saved values.

Question 7

What function would you use to round a number down to the nearest whole number?

Accepted Answer

The INT function.

Answer

The ROUNDUP function.

Answer

The SUM function.

Answer

The AVERAGE function.

Question 8

What is the purpose of macros in a spreadsheet?

Accepted Answer

They are a set of instructions that run all at once.

Answer

To enhance graphical representations.

Answer

To manage different data formats.

Answer

To establish data import settings.

Question 9

What does the HLOOKUP function do?

Accepted Answer

It searches for a value in a row.

Answer

It calculates the total of a range.

Answer

It creates horizontal graphs.

Answer

It looks for values in columns.

Question 10

What do comparative line graphs show?

Accepted Answer

How more than one series of data changes over time.

Answer

Single data trends over a fixed period.

Answer

Relationships between two unrelated variables.

Answer

Static snapshots of data at a moment.

Related quizzes

Related quizzes