Question 1

The Subtotal command creates summary reports that let you ____ the level of detail in a report.

Accepted Answer

A)  collapse 
B)  expand 
C)  both a and b 
D)  neither a nor b 
A)  collapse 
B)  expand 
C)  both a and b 
D)  neither a nor b

Question 2

When working with an Excel table, you should insert ____ around the list to segregate it from any other data in the worksheet.

Accepted Answer

A)  empty columns 
B)  empty rows 
C)  both a and b 
D)  neither a nor b 
A)  empty columns 
B)  empty rows 
C)  both a and b 
D)  neither a nor b

Question 3

Clicking within an Excel table opens the ____ tab on the ribbon.

Accepted Answer

A)  TABLE TOOLS DESIGN 
B)  TOOLS DESIGN 
C)  TABLE DESIGN 
D)  WORKSHEET DESIGN 
A)  TABLE TOOLS DESIGN 
B)  TOOLS DESIGN 
C)  TABLE DESIGN 
D)  WORKSHEET DESIGN

Question 4

The Subtotal command works with ____ calculation(s) at a time.

Accepted Answer

A)  one category and one subtotal 
B)  multiple categories and one subtotal 
C)  one category and multiple subtotal 
D)  multiple categories and multiple subtotal 
A)  one category and one subtotal 
B)  multiple categories and one subtotal 
C)  one category and multiple subtotal 
D)  multiple categories and multiple subtotal

Question 5

What is XML? How does Microsoft Excel take advantage of the benefits of XML data in spreadsheets?

Accepted Answer

XML is the acronym for Extensible Markup

Question 6

The ____________________ function returns the starting position of one text value within another text value.

Accepted Answer

The answer of The ____________________ function returns the starting position...

Question 7

The START function returns the starting position of one text value within another text value. _________________________

Accepted Answer

A) True 
 B)False

Question 8

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 9

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 10

Identify the letter of the choice that best matches the date and time function.
-Converts a date in the form of text to a serial number

Accepted Answer

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

Question 11

Case 7-1
   
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 12

To convert data to an XML document that can be used in any application that supports XML data, take the following steps: Click the Export button in the XML group, enter a filename in the ____ dialog box, and then click the Export button.

Accepted Answer

A)  Export XML 
B)  Import XML 
C)  Save XML 
D)  Convert XML 
A)  Export XML 
B)  Import XML 
C)  Save XML 
D)  Convert XML

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

In the FIND function, ____ is the text that you want to find.

Accepted Answer

A)  find_text 
B)  find_words 
C)  text_find 
D)  words_find 
A)  find_text 
B)  find_words 
C)  text_find 
D)  words_find

Question 15

A(n) ____________________ is a set of validation rules for an XML document.

Accepted Answer

The answer of A(n) ____________________ is a set of validation...

Question 16

Case 7-1
   
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 wants to find a company that starts with the letter Z, but she can't remember its complete name. The quickest way to find the company name is to choose the ____ option.

Accepted Answer

A)  Sort Z to A 
B)  Sort A to Z 
C)  Text Filters 
D)  Date Filters 
A)  Sort Z to A 
B)  Sort A to Z 
C)  Text Filters 
D)  Date Filters

Question 17

A ____ identifies the end of each field in a comma-delimited file.

Accepted Answer

A)  paragraph mark 
B)  pound sign 
C)  comma 
D)  question mark 
A)  paragraph mark 
B)  pound sign 
C)  comma 
D)  question mark

Question 18

The CONCATENATE function combines the values in a range of cells into one numeric item in a new cell.

Accepted Answer

A) True 
 B)False

Question 19

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 20

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])

The Subtotal command creates summary reports that let you ____ the level of detail in a report.

When working with an Excel table, you should insert ____ around the list to segregate it from any other data in the worksheet.

Clicking within an Excel table opens the ____ tab on the ribbon.

The Subtotal command works with ____ calculation(s) at a time.

What is XML? How does Microsoft Excel take advantage of the benefits of XML data in spreadsheets?

The ____________________ function returns the starting position of one text value within another text value.

The START function returns the starting position of one text value within another text value. _________________________

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

Identify the letter of the choice that best matches the date and time function. -Converts a date in the form of text to a serial number

To convert data to an XML document that can be used in any application that supports XML data, take the following steps: Click the Export button in the XML group, enter a filename in the ____ dialog box, and then click the Export button.

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.

In the FIND function, ____ is the text that you want to find.

A(n) ____________________ is a set of validation rules for an XML document.

A ____ identifies the end of each field in a comma-delimited file.

The CONCATENATE function combines the values in a range of cells into one numeric item in a new cell.

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

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

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 Subtotal command creates summary reports that let you ____ the level of detail in a report.

When working with an Excel table, you should insert ____ around the list to segregate it from any other data in the worksheet.

Clicking within an Excel table opens the ____ tab on the ribbon.

The Subtotal command works with ____ calculation(s) at a time.

What is XML? How does Microsoft Excel take advantage of the benefits of XML data in spreadsheets?

The ____________________ function returns the starting position of one text value within another text value.

The START function returns the starting position of one text value within another text value. _________________________

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

Identify the letter of the choice that best matches the date and time function. -Converts a date in the form of text to a serial number

To convert data to an XML document that can be used in any application that supports XML data, take the following steps: Click the Export button in the XML group, enter a filename in the ____ dialog box, and then click the Export button.

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.

In the FIND function, ____ is the text that you want to find.

A(n) ____________________ is a set of validation rules for an XML document.

A ____ identifies the end of each field in a comma-delimited file.

The CONCATENATE function combines the values in a range of cells into one numeric item in a new cell.

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

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

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