WorksheetsMastering Spreadsheets and Databases
Total questions: 12
Worksheet time: 6mins
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.
What is a foreign key?
A foreign key is a field that stores data in a separate database.
A foreign key is a type of primary key used in a single table.
A foreign key is a unique identifier for a record in a table.
A foreign key is a field in a database table that creates a link between two tables.
What is the function of a spreadsheet's 'SUM' formula?
To sort a list of numbers in ascending order.
To display the highest number in a set of numbers.
To find the average of a set of numbers.
To calculate the total of a set of numbers.
