module 2 Flashcards
1
Q
what is a database
A
a collection of data stored in a computer system
2
Q
what is a formula
A
a set of instructions used to perform a calculation with data in a spreadsheet
3
Q
what is a function
A
a preset command that automatically performs a process or task in the spreadsheet
4
Q
what is a query
A
a request for data from a database
5
Q
what is a query language
A
a computer programming language used to communicate with a database
6
Q
what are the three data analysis tools
A
spreadsheets query languages visualisation tools
7
Q
what is the difference between databases and spreadsheets
A
databases hold vast amounts of data
databases allow more than one person to use it at a given time
spreadsheets are filled manually
spreadsheets are opened through a software application
