Question 1

The ____ function calculates the number of years between two dates.

Accepted Answer

A)  YEARBET 
B)  YEARTWEEN 
C)  YEARFRAC 
D)  YEARCALC 
A)  YEARBET 
B)  YEARTWEEN 
C)  YEARFRAC 
D)  YEARCALC

Question 2

When you add a schema to a workbook, Excel generates an ____ to create mapped ranges of data, and define the relationships between these ranges and the elements in the XML schema.

Accepted Answer

A)  XML map 
B)  XML diagram 
C)  XML linked table 
D)  XML flow chart 
A)  XML map 
B)  XML diagram 
C)  XML linked table 
D)  XML flow chart

Question 3

You can change the calculation used in the VALUES area by right-clicking a value in the VALUES area to open the shortcut menu, and then clicking Field Settings to open the ____ dialog box.

Accepted Answer

A)  Value Field 
B)  Value Settings 
C)  Field Settings 
D)  Value Field Settings 
A)  Value Field 
B)  Value Settings 
C)  Field Settings 
D)  Value Field Settings

Question 4

When data is formatted as an Excel table, you can insert a new row into the table by selecting the last cell in the last row of the existing data and pressing the ____ key to create a new row.

Accepted Answer

A)  + 
B)  Tab 
C)  Ctrl 
D)  F2 
A)  + 
B)  Tab 
C)  Ctrl 
D)  F2

Question 5

In the RIGHT function, the argument called ____ is the text string or cell reference that contains the characters you want to extract.

Accepted Answer

A)  text 
B)  table 
C)  word 
D)  chars 
A)  text 
B)  table 
C)  word 
D)  chars

Question 6

The syntax for the RIGHT function is as follows: ____.

Accepted Answer

A)  =RIGHT(text,[num_chars]) 
B)  =RIGHT(num_chars,[text]) 
C)  =RIGHT(range,[num_chars]) 
D)  =RIGHT(num_chars,[range]) 
A)  =RIGHT(text,[num_chars]) 
B)  =RIGHT(num_chars,[text]) 
C)  =RIGHT(range,[num_chars]) 
D)  =RIGHT(num_chars,[range])

Question 7

You need to be careful when you export an XML file because only the elements in the XML list are exported, and not the elements from the ____.

Accepted Answer

A)  XML graphic 
B)  XML map 
C)  XML group 
D)  XML category 
A)  XML graphic 
B)  XML map 
C)  XML group 
D)  XML category

Question 8

XML documents are organized in a running tabular form with each element occupying ____.

Accepted Answer

A)  one line 
B)  one map 
C)  one column 
D)  one table 
A)  one line 
B)  one map 
C)  one column 
D)  one table

Question 9

MATCHING
   
Identify the letter of the choice that best matches the PivotTable that has been added to the worksheet shown in the figure above.
-Field headings

Accepted Answer

A) #1 
B) #2 
C) #3 
D) #4 
E) #5
F)#6
G)#7 
A) #1 
B) #2 
C) #3 
D) #4 
E) #5
F)#6
G)#7

Question 10

MATCHING
   
Identify the letter of the choice that best matches the PivotTable that has been added to the worksheet shown in the figure above.
-PivotTable report area

Accepted Answer

A) #1 
B) #2 
C) #3 
D) #4 
E) #5
F)#6
G)#7 
A) #1 
B) #2 
C) #3 
D) #4 
E) #5
F)#6
G)#7

Question 11

A common way of storing data so that it is usable in other programs is to save it in a ____ file.

Accepted Answer

A)  comma-delimited 
B)  comma-limited 
C)  comma-delineated 
D)  comma-lineated 
A)  comma-delimited 
B)  comma-limited 
C)  comma-delineated 
D)  comma-lineated

Question 12

Julie is a sales manager, and she created the table above to organize her customer list. Please refer to the above figure when answering the questions below.
-Julie plans to add some rows with sales information. She wants to perform some calculations including Average, Standard Deviation, and Variance. She would need to display the ____ to access these calculations.

Accepted Answer

A)  Total row 
B)  Function row 
C)  Calculation Wizard 
D)  Formula row 
A)  Total row 
B)  Function row 
C)  Calculation Wizard 
D)  Formula row

Question 13

Excel includes a program called ____________________ that lets you create queries to select data from external sources, including Access, and import the query results into a worksheet.

Accepted Answer

The answer of Excel includes a program called ____________________ that...

Question 14

The FIND function returns the ____ one text value within another text value.

Accepted Answer

A)  starting position of 
B)  ending position of 
C)  middle position of 
D)  comma between 
A)  starting position of 
B)  ending position of 
C)  middle position of 
D)  comma between

Question 15

In comma-delimited files, a comma is the delimiter. Another common delimiter is the ____.

Accepted Answer

A)  slash 
B)  tab character 
C)  paragraph mark 
D)  quotation mark 
A)  slash 
B)  tab character 
C)  paragraph mark 
D)  quotation mark

Question 16

The easiest way to create a PivotChart report is to use an existing PivotTable report as the source data.

Accepted Answer

A) True 
 B)False

Question 17

When you create formulas referencing cells that contain dates and/or times, Excel will never format the result as a date instead of as a number.

Accepted Answer

A) True 
 B)False

Question 18

Identify the letter of the choice that best matches the date and time function.
-Returns the serial number of the date that is the indicated number of months before or after start_date

Accepted Answer

A) TIMEVALUE 
B) EDATE 
C) EOMONTH 
D) DATEVALUE 
E) WEEKDAY 
A) TIMEVALUE 
B) EDATE 
C) EOMONTH 
D) DATEVALUE 
E) WEEKDAY

Question 19

The maximum number of rows and columns in a worksheet limits the number of records and fields you can have in your list to ____ rows and 16,384 columns.

Accepted Answer

A)  16,384 
B)  65,535 
C)  148,576 
D)  1,048,576 
A)  16,384 
B)  65,535 
C)  148,576 
D)  1,048,576

Question 20

The ____ function returns the last character or characters in a text string, based on the number of characters specified.

Accepted Answer

A)  LEFT 
B)  CHARACTER 
C)  RIGHT 
D)  NUMBER 
A)  LEFT 
B)  CHARACTER 
C)  RIGHT 
D)  NUMBER

The ____ function calculates the number of years between two dates.

When you add a schema to a workbook, Excel generates an ____ to create mapped ranges of data, and define the relationships between these ranges and the elements in the XML schema.

You can change the calculation used in the VALUES area by right-clicking a value in the VALUES area to open the shortcut menu, and then clicking Field Settings to open the ____ dialog box.

When data is formatted as an Excel table, you can insert a new row into the table by selecting the last cell in the last row of the existing data and pressing the ____ key to create a new row.

In the RIGHT function, the argument called ____ is the text string or cell reference that contains the characters you want to extract.

The syntax for the RIGHT function is as follows: ____.

You need to be careful when you export an XML file because only the elements in the XML list are exported, and not the elements from the ____.

XML documents are organized in a running tabular form with each element occupying ____.

MATCHING Identify the letter of the choice that best matches the PivotTable that has been added to the worksheet shown in the figure above. -Field headings

MATCHING Identify the letter of the choice that best matches the PivotTable that has been added to the worksheet shown in the figure above. -PivotTable report area

A common way of storing data so that it is usable in other programs is to save it in a ____ file.

Excel includes a program called ____________________ that lets you create queries to select data from external sources, including Access, and import the query results into a worksheet.

The FIND function returns the ____ one text value within another text value.

In comma-delimited files, a comma is the delimiter. Another common delimiter is the ____.

The easiest way to create a PivotChart report is to use an existing PivotTable report as the source data.

When you create formulas referencing cells that contain dates and/or times, Excel will never format the result as a date instead of as a number.

Identify the letter of the choice that best matches the date and time function. -Returns the serial number of the date that is the indicated number of months before or after start_date

The maximum number of rows and columns in a worksheet limits the number of records and fields you can have in your list to ____ rows and 16,384 columns.

The ____ function returns the last character or characters in a text string, based on the number of characters specified.

Applying Fundamental Excel Skills and Tools in Problem Solving

Solving Problems with Statistical Analysis Tools

Determining Effective Data Display with Charts

Applying Logic in Decision Making

Retrieving Data for Computation, Analysis, and Reference

Evaluating the Financial Impact of Loans and Investments

Using Data Tables and Excel Scenarios for What-If Analysis

Enhancing Decision Making with Solver

Troubleshooting Workbooks and Automating Excel Applications

Filters

Exam 7: Organizing Data for Effective Analysis

The ____ function calculates the number of years between two dates.

When you add a schema to a workbook, Excel generates an ____ to create mapped ranges of data, and define the relationships between these ranges and the elements in the XML schema.

You can change the calculation used in the VALUES area by right-clicking a value in the VALUES area to open the shortcut menu, and then clicking Field Settings to open the ____ dialog box.

When data is formatted as an Excel table, you can insert a new row into the table by selecting the last cell in the last row of the existing data and pressing the ____ key to create a new row.

In the RIGHT function, the argument called ____ is the text string or cell reference that contains the characters you want to extract.

The syntax for the RIGHT function is as follows: ____.

You need to be careful when you export an XML file because only the elements in the XML list are exported, and not the elements from the ____.

XML documents are organized in a running tabular form with each element occupying ____.

MATCHING Identify the letter of the choice that best matches the PivotTable that has been added to the worksheet shown in the figure above. -Field headings

MATCHING Identify the letter of the choice that best matches the PivotTable that has been added to the worksheet shown in the figure above. -PivotTable report area

A common way of storing data so that it is usable in other programs is to save it in a ____ file.

Excel includes a program called ____________________ that lets you create queries to select data from external sources, including Access, and import the query results into a worksheet.

The FIND function returns the ____ one text value within another text value.

In comma-delimited files, a comma is the delimiter. Another common delimiter is the ____.

The easiest way to create a PivotChart report is to use an existing PivotTable report as the source data.

When you create formulas referencing cells that contain dates and/or times, Excel will never format the result as a date instead of as a number.

Identify the letter of the choice that best matches the date and time function. -Returns the serial number of the date that is the indicated number of months before or after start_date

The maximum number of rows and columns in a worksheet limits the number of records and fields you can have in your list to ____ rows and 16,384 columns.

The ____ function returns the last character or characters in a text string, based on the number of characters specified.

Applying Fundamental Excel Skills and Tools in Problem Solving

Solving Problems with Statistical Analysis Tools

Determining Effective Data Display with Charts

Applying Logic in Decision Making

Retrieving Data for Computation, Analysis, and Reference

Evaluating the Financial Impact of Loans and Investments

Using Data Tables and Excel Scenarios for What-If Analysis

Enhancing Decision Making with Solver

Troubleshooting Workbooks and Automating Excel Applications

Filters