Question 1

What is not true about tables in Excel?

Accepted Answer

A)  Column headings stay on the screen automatically.
B)  Filter arrows make it quick and easy to filter the data in the table.
C)  Row headings stay on the screen automatically.
D)  You can export the data to a SharePoint list.E) A) and B)
F) A) and C)

Question 2

Even if panes are frozen pressing Ctrl+Home will still make A1 the active cell.

Accepted Answer

A) True 
 B)False

Question 3

Which wildcard character only replaces one character with one other character?

Accepted Answer

A)  Question Mark ?
B)  Asterisk *
C)  Number sign #
D)  Tilde ~E) A) and D)
F) A) and C)

Question 4

When would you not need to use a fully qualified structured reference?

Accepted Answer

A)  When referring to a cell outside the table
B)  When referring to a cell on a different worksheet
C)  When referring to a cell on a different workbook
D)  When referring to a cell within the tableE) A) and B)
F) None of the above

Question 5

What feature in Excel automatically displays a list of field headings when you begin to create a structured reference?

Accepted Answer

A)  Reference AutoComplete
B)  Formula AutoComplete
C)  AutoComplete
D)  Nothing automatically displays a list of field headings.E) A) and B)
F) A) and C)

Question 6

After a table has been named, that name can be used in functions instead of cell references.

Accepted Answer

A) True 
 B)False

Question 7

You can manually adjust a page break by pointing to the page break line and waiting for the four-headed arrow to appear, then drag the page break to your desired location.

Accepted Answer

A) True 
 B)False

Question 8

Which one of the following filter options is not found on the text filter submenu?

Accepted Answer

A)  Begins With
B)  Includes
C)  Contains
D)  Custom FilterE) A) and B)
F) A) and C)

Question 9

Filter arrows are always displayed in data tables.

Accepted Answer

A) True 
 B)False

Question 10

When you have frozen rows and columns, what happens when you press the Ctrl+Home combination?

Accepted Answer

A)  A1 becomes the active cell.
B)  Column A and whatever row was active when you pressed the combination becomes the active cell.
C)  Row 1 and whatever column was active when you pressed the combination becomes the active cell.
D)  The first unfrozen cell becomes the active cell.E) A) and B)
F) C) and D)

Question 11

________ page breaks can be inserted if the automatic page breaks would occur at undesirable places.

Accepted Answer

The answer of ________ page breaks can be inserted if...

Question 12

It is impossible to create a data table from random, unorganized data.

Accepted Answer

A) True 
 B)False

Question 13

Match the following terms with their description:
I. Color scale
II. Icon set
III. Filtering
IV. Sorting
V. Data bars
A. Colors are based on the relative values in the cell.
B. Arranging records
C. Symbols or signs that classify data
D. Various widths represent the cell's value.
E. Using conditions to limit the visible data

Accepted Answer

The answer of Match the following terms with their description:
I....

Question 14

This could be a valid formula in Excel: =[@Cost]-[@Pre_Paid_Taxes].

Accepted Answer

A) True 
 B)False

Question 15

What data does Excel print by default?

Accepted Answer

A)  The selected range of data
B)  The entire dataset on the active sheet
C)  The entire workbook
D)  There is no default setting for this in Excel.E) A) and B)
F) A) and C)

Question 16

Which of the following is not a way to bring up the Go To dialog box?

Accepted Answer

A)  Alt+F7
B)  F5
C)  Ctrl+G
D)  Name BoxE) B) and C)
F) A) and D)

Question 17

On which tab will you find options if you have to print a large dataset?

Accepted Answer

A)  Page Layout
B)  Print
C)  Review
D)  HomeE) C) and D)
F) B) and D)

Question 18

In the formula =SUBTOTAL(102,[PAID]) , what does the 102 represent?

Accepted Answer

A)  The COUNT function
B)  The SUM function
C)  The number of rows to subtotal
D)  The row number in which to place the subtotalE) A) and B)
F) None of the above

Question 19

The print ________ is the range of cells that will be printed.

Accepted Answer

The answer of The print ________ is the range of...

Question 20

Locking is the process of making sure that certain rows or columns are visible at all times.

Accepted Answer

A) True 
 B)False

Exam 8: Excel : Datasets and Tables

What data does Excel print by default?

Correct Answer
verified

Correct Answer
verified

This could be a valid formula in Excel: =[@Cost]-[@Pre_Paid_Taxes].

Correct Answer
verified

On which tab will you find options if you have to print a large dataset?

Correct Answer
verified

You can manually adjust a page break by pointing to the page break line and waiting for the four-headed arrow to appear, then drag the page break to your desired location.

Correct Answer
verified

________ page breaks can be inserted if the automatic page breaks would occur at undesirable places.

Correct Answer
verified

Even if panes are frozen pressing Ctrl+Home will still make A1 the active cell.

Correct Answer
verified

Locking is the process of making sure that certain rows or columns are visible at all times.

Correct Answer
verified

When would you not need to use a fully qualified structured reference?

Correct Answer
verified

After a table has been named, that name can be used in functions instead of cell references.

Correct Answer
verified

Which one of the following filter options is not found on the text filter submenu?

Correct Answer
verified

What feature in Excel automatically displays a list of field headings when you begin to create a structured reference?

Correct Answer
verified

When you have frozen rows and columns, what happens when you press the Ctrl+Home combination?

Correct Answer
verified

What is not true about tables in Excel?

Correct Answer
verified

The print ________ is the range of cells that will be printed.

Correct Answer
verified

Which wildcard character only replaces one character with one other character?

Correct Answer
verified

It is impossible to create a data table from random, unorganized data.

Correct Answer
verified

Filter arrows are always displayed in data tables.

Correct Answer
verified

Which of the following is not a way to bring up the Go To dialog box?

Correct Answer
verified

In the formula =SUBTOTAL(102,[PAID]) , what does the 102 represent?

Correct Answer
verified

Exam 8: Excel : Datasets and Tables

What data does Excel print by default?

Correct AnswerverifiedShow Answer

Correct AnswerverifiedShow Answer

This could be a valid formula in Excel: =[@Cost]-[@Pre_Paid_Taxes].

Correct AnswerverifiedShow Answer

On which tab will you find options if you have to print a large dataset?

Correct AnswerverifiedShow Answer

You can manually adjust a page break by pointing to the page break line and waiting for the four-headed arrow to appear, then drag the page break to your desired location.

Correct AnswerverifiedShow Answer

________ page breaks can be inserted if the automatic page breaks would occur at undesirable places.

Correct AnswerverifiedShow Answer

Even if panes are frozen pressing Ctrl+Home will still make A1 the active cell.

Correct AnswerverifiedShow Answer

Locking is the process of making sure that certain rows or columns are visible at all times.

Correct AnswerverifiedShow Answer

When would you not need to use a fully qualified structured reference?

Correct AnswerverifiedShow Answer

After a table has been named, that name can be used in functions instead of cell references.

Correct AnswerverifiedShow Answer

Which one of the following filter options is not found on the text filter submenu?

Correct AnswerverifiedShow Answer

What feature in Excel automatically displays a list of field headings when you begin to create a structured reference?

Correct AnswerverifiedShow Answer

When you have frozen rows and columns, what happens when you press the Ctrl+Home combination?

Correct AnswerverifiedShow Answer

What is not true about tables in Excel?

Correct AnswerverifiedShow Answer

The print ________ is the range of cells that will be printed.

Correct AnswerverifiedShow Answer

Which wildcard character only replaces one character with one other character?

Correct AnswerverifiedShow Answer

It is impossible to create a data table from random, unorganized data.

Correct AnswerverifiedShow Answer

Filter arrows are always displayed in data tables.

Correct AnswerverifiedShow Answer

Which of the following is not a way to bring up the Go To dialog box?

Correct AnswerverifiedShow Answer

In the formula =SUBTOTAL(102,[PAID]) , what does the 102 represent?

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified