DATABASE FUNDAMENTALS
WORKBOOK THEMES
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Write a letter to business associates
|
|
|
Keep track of your emails
|
|
|
Organize data and make calculations quicker and easier
|
|
|
Develop a presentation
|
Detailed explanation-1: -Excel is generally better for analyzing data: performing complex calculations, exploring possible outcomes, and producing high quality charts. If you use Access to store your data and Excel to analyze it, you can gain the benefits of both programs.
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: -Microsoft Excel enables users to identify trends and organize and sort data into meaningful categories. Excel also performs Human Resources functions, such as sorting worked hours and organizing employee profiles and expenses, which help businesses better understand the structure and activities of their workforce.
Detailed explanation-4: -Use the Auto Fill feature to fill cells with data that follows a pattern or are based on data in other cells.