DATABASE FUNDAMENTALS
BASICS OF BIG DATA
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
It is a program used for printing.
|
|
|
It is a program used to design images.
|
|
|
It is a program that handles data in tables very well.
|
|
|
It is a program that helps to decorate images and characters well.
|
Detailed explanation-1: -As a spreadsheet program, Excel can store large amounts of data in workbooks that contain one or more worksheets. However, instead of serving as a database management system, such as Access, Excel is optimized for data analysis and calculation.
Detailed explanation-2: -Microsoft Excel enables users to format, organize and calculate data in a spreadsheet. By organizing data using software like Excel, data analysts and other users can make information easier to view as data is added or changed. Excel contains a large number of boxes called cells that are ordered in rows and columns.
Detailed explanation-3: -Excel can restrict data entry to certain cells by using data validation, prompt users to enter valid data when a cell is selected, and display an error message when a user enters invalid data.
Detailed explanation-4: -Tables in Excel helps group related data into one or more rows and/or columns. Once a table is created, Excel assigns a unique name to the columns and the table itself. Such names are used as structured references, which make it easy to apply Excel formulas.