CGS 2518 CH#7 EXAM QUESTIONS AND
ANSWERS
What is the Query Wizard, and when would you use it? - Answer-Lets you choose your
data source and select the database table and fields you want to import into a
workbook.
How does Excel store date and time values? - Answer-As serial number where
day/month/year are a whole number and hour/minute/second are a decimals.
What are the arguments for the YEARFRAC function? What are the possible values for
calculating months and years using this function? - Answer-The arguments are start
date, end date, and basis of the type of day count to use. Calculates years and decimal
fraction of the year between the start and end date.
When should you use a PivotTable report to analyze data? - Answer-When you have
data lots of complicated data and want it to be summarized to a few details.
List and describe the four areas of a PivotTable report. - Answer-report filter, column
labels, row labels, and values.
How is a PivotChart different from a normal chart in Excel? - Answer-Summarizes data
from a PivotTable and changes with the filters of the table
List and describe the differences and similarities between HTML and XML. - Answer-
They are both markup languages but HTML is used to write websites and XML is a
language that can be automatically read by computers everywhere to interpret data
consistently
Describe the steps you would take to import XML data as an XML table in Excel. -
Answer-1. Open worksheet
2. select first blank cell and select data from XML Data Import
3. Find your folder
4. Click on the XML document (create a schema)
5. click ok button
6. select new or existing worksheet
How do you import an XML map into a workbook and map its elements into the
worksheet? - Answer-1. Display developer tab
2. open worksheet
3. select XML source task pane
4. Click XML Maps button
5. Click add button
6. Find document and select it
ANSWERS
What is the Query Wizard, and when would you use it? - Answer-Lets you choose your
data source and select the database table and fields you want to import into a
workbook.
How does Excel store date and time values? - Answer-As serial number where
day/month/year are a whole number and hour/minute/second are a decimals.
What are the arguments for the YEARFRAC function? What are the possible values for
calculating months and years using this function? - Answer-The arguments are start
date, end date, and basis of the type of day count to use. Calculates years and decimal
fraction of the year between the start and end date.
When should you use a PivotTable report to analyze data? - Answer-When you have
data lots of complicated data and want it to be summarized to a few details.
List and describe the four areas of a PivotTable report. - Answer-report filter, column
labels, row labels, and values.
How is a PivotChart different from a normal chart in Excel? - Answer-Summarizes data
from a PivotTable and changes with the filters of the table
List and describe the differences and similarities between HTML and XML. - Answer-
They are both markup languages but HTML is used to write websites and XML is a
language that can be automatically read by computers everywhere to interpret data
consistently
Describe the steps you would take to import XML data as an XML table in Excel. -
Answer-1. Open worksheet
2. select first blank cell and select data from XML Data Import
3. Find your folder
4. Click on the XML document (create a schema)
5. click ok button
6. select new or existing worksheet
How do you import an XML map into a workbook and map its elements into the
worksheet? - Answer-1. Display developer tab
2. open worksheet
3. select XML source task pane
4. Click XML Maps button
5. Click add button
6. Find document and select it
