Question 1

A page ________ indicates where data starts on a new printed page.

Accepted Answer

The answer of A page ________ indicates where data starts...

Question 2

Filtering:

Accepted Answer

A)  helps to remove duplicate data in a dataset.
B)  displays data in chronological order.
C)  is the process of displaying only records that meet special conditions.
D)  arranges dates in alphabetical order.E) B) and D)
F) A) and D) C

Question 3

A structured reference uses field names instead of cell references to make it easier to create formulas.

Accepted Answer

A) True 
 B)False

Question 4

Match between columns
                        Premises: View tab
Insert tab
File tab
Home tab
Page Layout tab

Accepted Answer

The Answer of Print and Breaks and Table and Go is...

Question 5

If you have a table that extends to row 21 and you start typing in row 22,what happens?

Accepted Answer

Excel will extend the table to...

Question 6

Tables provide advantages over regular ranges but you cannot convert a table back to a regular range of data.

Accepted Answer

A) True 
 B)False

Question 7

You can apply text,value,and date filters to fields based on the data in a particular field.

Accepted Answer

A) True 
 B)False

Question 8

Freezing rows and/or columns:

Accepted Answer

A)  collects structured,related data in columns and rows.
B)  keeps them visible as you scroll through a worksheet.
C)  keeps all worksheets on the screen.
D)  enables you to adjust settings to control how the worksheet will print.E) A) and B)
F) A) and C) B

Question 9

Which of the following is NOT a Table Style option?

Accepted Answer

A)  Subtotal Row
B)  Filter Button
C)  First Column
D)  Banded RowsE) B) and D)
F) A) and C)

Question 10

Match between columns
                        Premises: Unqualified reference
Top/Bottom Rules
Conditional formatting
Fully qualified structured reference
Structured reference

Accepted Answer

The Answer of type of conditional formatting and applies special is...

Question 11

Semiselection cannot be used to create formulas in a table.

Accepted Answer

A) True 
 B)False

Question 12

In a worksheet,it is possible to ________ a manual page break to a new,desired location.

Accepted Answer

The answer of In a worksheet,it is possible to ________...

Question 13

When you freeze panes and press Ctrl+Home when columns A and B and row 1 are frozen,what happens?

Accepted Answer

In this case,cell C2 becomes t...

Question 14

After you have created a table,you cannot add new fields to it.

Accepted Answer

A) True 
 B)False

Question 15

________ keeps rows and/or columns visible as you scroll through a worksheet.

Accepted Answer

The answer of ________ keeps rows and/or columns visible as...

Question 16

Sorting by ________ arranges data together for cells containing a particular fill or font color.

Accepted Answer

The answer of Sorting by ________ arranges data together for...

Question 17

Which of the following is TRUE about the print area feature?

Accepted Answer

A)  In Page Break Preview,the area of the worksheet that won't be printed has a dark blue background.
B)  In Page Break Preview,the print area has a white background and dashed red border.
C)  The print area can be cleared from the Home tab.
D)  The print area defines the range of data to print.E) B) and D)
F) All of the above

Question 18

A page break:

Accepted Answer

A)  indicates which worksheet is set to print.
B)  is the sequence in which pages print.
C)  indicates where data starts on a new printed page.
D)  stops the printer from printing.E) All of the above
F) A) and B)

Question 19

When you no longer need conditional formatting,you can clear it for a selected range or for an entire worksheet.

Accepted Answer

A) True 
 B)False

Question 20

Conditional formatting is the process of conditioning data to make it more manageable.

Accepted Answer

A) True 
 B)False  False

Exam 21: Excel: Datasets and Tables: Managing Large Volumes of Data

A page ________ indicates where data starts on a new printed page.

Correct Answer
verified

Filtering:

Correct Answer
verified
C

A structured reference uses field names instead of cell references to make it easier to create formulas.

Correct Answer
verified

Match the tab name to the feature available on that tab:

If you have a table that extends to row 21 and you start typing in row 22,what happens?

Correct Answer
verified
Excel will extend the table to...
View Answer

Tables provide advantages over regular ranges but you cannot convert a table back to a regular range of data.

Correct Answer
verified

You can apply text,value,and date filters to fields based on the data in a particular field.

Correct Answer
verified

Freezing rows and/or columns:

Correct Answer
verified
B

Which of the following is NOT a Table Style option?

Correct Answer
verified

Match the following terms to their descriptions:

Semiselection cannot be used to create formulas in a table.

Correct Answer
verified

In a worksheet,it is possible to ________ a manual page break to a new,desired location.

Correct Answer
verified

When you freeze panes and press Ctrl+Home when columns A and B and row 1 are frozen,what happens?

Correct Answer
verified
In this case,cell C2 becomes t...
View Answer

After you have created a table,you cannot add new fields to it.

Correct Answer
verified

________ keeps rows and/or columns visible as you scroll through a worksheet.

Correct Answer
verified

Sorting by ________ arranges data together for cells containing a particular fill or font color.

Correct Answer
verified

Which of the following is TRUE about the print area feature?

Correct Answer
verified

A page break:

Correct Answer
verified

When you no longer need conditional formatting,you can clear it for a selected range or for an entire worksheet.

Correct Answer
verified

Conditional formatting is the process of conditioning data to make it more manageable.

Correct Answer
verified
False

Exam 21: Excel: Datasets and Tables: Managing Large Volumes of Data

A page ________ indicates where data starts on a new printed page.

Correct AnswerverifiedShow Answer

Filtering:

Correct AnswerverifiedC

A structured reference uses field names instead of cell references to make it easier to create formulas.

Correct AnswerverifiedShow Answer

Match the tab name to the feature available on that tab:

If you have a table that extends to row 21 and you start typing in row 22,what happens?

Correct AnswerverifiedExcel will extend the table to...View AnswerShow Answer

Tables provide advantages over regular ranges but you cannot convert a table back to a regular range of data.

Correct AnswerverifiedShow Answer

You can apply text,value,and date filters to fields based on the data in a particular field.

Correct AnswerverifiedShow Answer

Freezing rows and/or columns:

Correct AnswerverifiedB

Which of the following is NOT a Table Style option?

Correct AnswerverifiedShow Answer

Match the following terms to their descriptions:

Semiselection cannot be used to create formulas in a table.

Correct AnswerverifiedShow Answer

In a worksheet,it is possible to ________ a manual page break to a new,desired location.

Correct AnswerverifiedShow Answer

When you freeze panes and press Ctrl+Home when columns A and B and row 1 are frozen,what happens?

Correct AnswerverifiedIn this case,cell C2 becomes t...View AnswerShow Answer

After you have created a table,you cannot add new fields to it.

Correct AnswerverifiedShow Answer

________ keeps rows and/or columns visible as you scroll through a worksheet.

Correct AnswerverifiedShow Answer

Sorting by ________ arranges data together for cells containing a particular fill or font color.

Correct AnswerverifiedShow Answer

Which of the following is TRUE about the print area feature?

Correct AnswerverifiedShow Answer

A page break:

Correct AnswerverifiedShow Answer

When you no longer need conditional formatting,you can clear it for a selected range or for an entire worksheet.

Correct AnswerverifiedShow Answer

Conditional formatting is the process of conditioning data to make it more manageable.

Correct AnswerverifiedFalse

Correct Answer
verified

Correct Answer
verified
C

Correct Answer
verified

Correct Answer
verified
Excel will extend the table to...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
B

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
In this case,cell C2 becomes t...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
False