DATABASE FUNDAMENTALS
BASICS OF BIG DATA
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Formatting as a table will only add color bands to your headers and rows. A PivotTable turns your data into a 3D graph.
|
|
|
Formatting your spreadsheet as a table will format all of your data in a separate worksheet. A PivotTable creates a table within your worksheet.
|
|
|
There is no difference.
|
|
|
Formatting your spreadsheet as a table changes the overall look and feel of your spreadsheet. PivotTables instantly calculate and summarize the data separately from your original spreadsheet.
|
Detailed explanation-1: -There is no difference. Formatting your spreadsheet as a table changes the overall look and feel of your spreadsheet. PivotTables instantly calculate and summarize the data separately from your original spreadsheet.
Detailed explanation-2: -1. Worksheet is a single page file/spreadsheet, where rows and columns are available, You can easily fill your data into that row and column. 1. Spreadsheet is a program that allows users to create a work report.
Detailed explanation-3: -The four types of data are text, number, logical and error. You may perform different functions with each type, so it’s important to know which ones to use and when to use them. You may also consider that some data types may change when exporting data into a spreadsheet.
Detailed explanation-4: -The data that you enter can be numbers, text, dates, or times. You can format the data in a variety of ways. And, there are several settings that you can adjust to make data entry easier for you. This topic does not explain how to use a data form to enter data in worksheet.
Detailed explanation-5: -To make data look more interesting and descriptive, formatting is often used. A good formatting method helps you to find meaning in the spreadsheet without the trouble of going through each and every individual cell. Cells with good formatting will draw your attention to the important cells automatically.