Mastering Spreadsheets and Databases

What is a spreadsheet?

• A spreadsheet is a type of physical notebook for writing notes.

• A spreadsheet is a programming language for web development.

• A spreadsheet is a digital application for organizing, calculating, and analyzing data in tabular form.

• A spreadsheet is a social media platform for sharing data.

Name a common software used for spreadsheets.

• Microsoft Word

• Adobe Photoshop

• Notepad

• Microsoft Excel

What is the primary function of a database?

• To store and manage data.

• To analyze data trends.

• To send data over the internet.

• To create visual presentations.

Define the term 'cell' in the context of spreadsheets.

• A cell is a collection of multiple data points.

• A cell is a graphical element in a spreadsheet.

• A cell is a single data point in a spreadsheet, defined by its row and column position.

• A cell is a type of spreadsheet formula.

What is a primary key in a database?

• A primary key is a type of foreign key.

• A primary key is used to store large text data.

• A primary key can be duplicated across records.

• A primary key is a unique identifier for a record in a database.

How do you create a formula in a spreadsheet?

• Enter the formula in the header row.

• Type '=' followed by your formula in the desired cell.

• Use '!' to start your formula.

• Select the cell and click 'Insert Formula' from the menu.

What is the difference between a flat file and a relational database?

• A flat file is more complex than a relational database.

• A flat file requires a specific format, while a relational database does not.

• A flat file is a single table of data, while a relational database consists of multiple related tables.

• A flat file can store multiple tables, while a relational database is a single table.

Explain what a pivot table is used for.

• A pivot table is used to summarize and analyze data.

• A pivot table is used to store large datasets permanently.

• A pivot table is used to format text documents.

• A pivot table is used to create charts and graphs.

What is the purpose of data validation in spreadsheets?

• To enhance the visual appeal of the spreadsheet.

• To ensure data integrity and prevent errors in data entry.

• To limit the number of rows in a spreadsheet.

• To automatically generate charts and graphs.

How can you sort data in a spreadsheet?

• Copy the data to a new sheet.

• Select the data range, then use the 'Sort' function in the 'Data' menu.

• Right-click the data and select 'Delete'.

• Use the 'Filter' function in the 'View' menu.