Spreadsheet Knowledge Quiz

What file extension does Google Sheets use for spreadsheet documents?

• None. Google Sheets save documents in online servers, so the exact file extension is not visible.

• .xls or .xlsx

• .odt

• .ods

Which spreadsheet program is locally installed and sold by Microsoft?

• Excel

• Calc

• Docs

• Sheets

What is a "csv" file?

• A "Comma Separated Value" file

• A "Common Sheets Value" file

• A "Cool Spreadsheet Verification" file

• A "Calculation Spreadsheet Verification" file

With spreadsheets, you can perform calculations, sort data, and create charts and graphs very easily.

• True

• False

What kind of data can be placed in a cell?

• Numbers

• Text

• Dates

• All of these are true.

Letters are used to refer to which spreadsheet areas?

• columns

• rows

• individual cells

• function bar

In spreadsheet software, what do you call a single box in the grid of rows and columns?

• A cell

• A cell range

• A column

• A row

Which shortcut keys will perform a "cut" operation on selected cell data?

• Ctrl-X or Command-X

• Ctrl-Y or Command-Y

• Ctrl-V or Command-V

• Ctrl-B or Command-B

Which type of chart can be used to compare relative sizes of data?

• A pie chart

• A line chart

• A bar chart

• A tube chart

Which type of chart will allow you to visualize a trend in data over a specific period of time?

• A line chart

• A pie chart

• A bar chart

• An area chart