Review 5 P.I.T.

Front

You are organizing a company-wide database for employee records and must share the information with departments using different software. To ensure everyone can access it, you choose to save the data as a CSV file.

Back

They can be easily integrated into various software systems.

Front

CSV files can be opened by various programs, not only Excel. True or False?

Back

False

Front

Each row in a CSV file corresponds to a record.

Back

True

Front

CSV files are compatible with many programs, making them ideal for sharing.

Back

True

Front

CSV files do not support complex formatting like fonts and colors.

Back

False

Front

To calculate the total sales for each product, use the ____________ function.

Back

SUM

Front

To count the number of times a specific value appears in a range of cells, you can use the ____________ function.

Back

COUNTIF

Front

If you want to show the popularity of different survey options visually, you could create a ____________ chart.

Back

pie

Front

To view only specific rows based on criteria without altering the main data, you would apply a ____________ view.

Back

filter view

Front

Which spreadsheet feature would you use to calculate the total number of support hours? Options: Filter, Cell References, Range, SUM Function

Back

SUM Function