Question 1

How does Excel indicate that a column has been selected in a structured reference?

Accepted Answer

A)  A light shading appears in that column. 
B)  There is nothing to indicate a column has been selected. 
C)  A colored border appears around that column. 
D)  A type of colored sticky note is attached to that column. 
A)  A light shading appears in that column. 
B)  There is nothing to indicate a column has been selected. 
C)  A colored border appears around that column. 
D)  A type of colored sticky note is attached to that column.

Question 2

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 subtotal 
A)  The COUNT function 
B)  The SUM function 
C)  The number of rows to subtotal 
D)  The row number in which to place the subtotal

Question 3

What is the default data table style?

Accepted Answer

A)  Normal 
B)  Medium 1 
C)  Medium 2 
D)  None 
A)  Normal 
B)  Medium 1 
C)  Medium 2 
D)  None

Question 4

In a data table each column is considered a(n) ________.

Accepted Answer

The answer of In a data table each column is...

Question 5

You can select multiple print areas.

Accepted Answer

A) True 
 B)False

Question 6

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

Accepted Answer

A) True 
 B)False

Question 7

Which of the following is not a freeze option?

Accepted Answer

A)  Freeze Panes 
B)  Freeze Top Row 
C)  Freeze First Column 
D)  Freeze Section 
A)  Freeze Panes 
B)  Freeze Top Row 
C)  Freeze First Column 
D)  Freeze Section

Question 8

Match the following terms with their description:
i. Color scale
II. Icon set
III. Filtering
IV. Sorting
v. Data bars

Accepted Answer

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

Question 9

Records are individual pieces of information.

Accepted Answer

A) True 
 B)False

Question 10

In Page Break Preview, the area to be printed has a light blue background.

Accepted Answer

A) True 
 B)False

Question 11

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 table 
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 table

Question 12

Using the data bars conditional formatting, how is the highest value represented?

Accepted Answer

A)  By the darkest bar 
B)  By the tallest bar 
C)  By the longest bar 
D)  By the most number of bars 
A)  By the darkest bar 
B)  By the tallest bar 
C)  By the longest bar 
D)  By the most number of bars

Question 13

What cannot be found on the Manage Rules dialog box?

Accepted Answer

A)  Delete Rule 
B)  Copy Rule 
C)  New Rule 
D)  Edit Rule 
A)  Delete Rule 
B)  Copy Rule 
C)  New Rule 
D)  Edit Rule

Question 14

Match the following table style options with their description:
i. Header Row
II. Total Row
III. First Column
IV. Last Column
v. Filter Button

Accepted Answer

A)  Displays a total row when selected 
B)  Makes sure that the row headings stand out 
C)  Displays on the right side of each heading in the header row 
D)  Used to make aggregated data stand out 
E)  Removes field names when not checked 
A)  Displays a total row when selected 
B)  Makes sure that the row headings stand out 
C)  Displays on the right side of each heading in the header row 
D)  Used to make aggregated data stand out 
E)  Removes field names when not checked

Question 15

What is not true about using the AND function in a custom conditional formatting rule?

Accepted Answer

A)  All the tests must be of the same data type, for example: all numbers or all text. 
B)  All the logical tests must be true for the formatting to be applied. 
C)  You must have at least two tests in the formula. 
D)  You may have as many tests as you need in the formula. 
A)  All the tests must be of the same data type, for example: all numbers or all text. 
B)  All the logical tests must be true for the formatting to be applied. 
C)  You must have at least two tests in the formula. 
D)  You may have as many tests as you need in the formula.

Question 16

Match the following Conditional Formatting Options in the Quick Analysis Gallery with their description:
i. Text Contains
II. Duplicate Values
III. Unique Values
IV. Equal To
v. Clear Format

Accepted Answer

A)  Formats cells that have exactly the same value 
B)  Formats any cell that has content that matches the first content in the first selected cell 
C)  Removes any conditional formatting 
D)  Formats cells that have no matching values 
E)  Formats cells that have the value 
A)  Formats cells that have exactly the same value 
B)  Formats any cell that has content that matches the first content in the first selected cell 
C)  Removes any conditional formatting 
D)  Formats cells that have no matching values 
E)  Formats cells that have the value

Question 17

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

Accepted Answer

A)  Greater Than... 
B)  Between... 
C)  Below Average 
D)  Bottom 10... 
A)  Greater Than... 
B)  Between... 
C)  Below Average 
D)  Bottom 10...

Question 18

Before you freeze panes make sure the active cell is one row above and one column to the left of the rows and columns you want to freeze.

Accepted Answer

A) True 
 B)False

Question 19

Which table style option is useful to display aggregated data when it is checked?

Accepted Answer

A)  Last Column 
B)  Total Row 
C)  Filter Button 
D)  Header Row 
A)  Last Column 
B)  Total Row 
C)  Filter Button 
D)  Header Row

Question 20

What would be the result if you sorted the following dates in ascending order: December 25, 2000; January 1, 2015; January 16, 1957; December 26, 1959?

Accepted Answer

A)  December 25, 2000; December 26, 1959; January 1, 2015; January 16, 1959 
B)  January 1, 2015; January 16, 1959, December 25, 2000; December 26, 1959 
C)  January 16, 1957; December 26, 1959; December 25, 2000; January 1, 2015 
D)  December 25, 2000; January 1, 2015; January 16, 1957; December 26, 1959 
A)  December 25, 2000; December 26, 1959; January 1, 2015; January 16, 1959 
B)  January 1, 2015; January 16, 1959, December 25, 2000; December 26, 1959 
C)  January 16, 1957; December 26, 1959; December 25, 2000; January 1, 2015 
D)  December 25, 2000; January 1, 2015; January 16, 1957; December 26, 1959

How does Excel indicate that a column has been selected in a structured reference?

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

What is the default data table style?

In a data table each column is considered a(n) ________.

You can select multiple print areas.

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

Which of the following is not a freeze option?

Match the following terms with their description: i. Color scale II. Icon set III. Filtering IV. Sorting v. Data bars

Records are individual pieces of information.

In Page Break Preview, the area to be printed has a light blue background.

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

Using the data bars conditional formatting, how is the highest value represented?

What cannot be found on the Manage Rules dialog box?

Match the following table style options with their description: i. Header Row II. Total Row III. First Column IV. Last Column v. Filter Button

What is not true about using the AND function in a custom conditional formatting rule?

Match the following Conditional Formatting Options in the Quick Analysis Gallery with their description: i. Text Contains II. Duplicate Values III. Unique Values IV. Equal To v. Clear Format

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

Before you freeze panes make sure the active cell is one row above and one column to the left of the rows and columns you want to freeze.

Which table style option is useful to display aggregated data when it is checked?

What would be the result if you sorted the following dates in ascending order: December 25, 2000; January 1, 2015; January 16, 1957; December 26, 1959?

Common Features

Access: Introduction to Powerpoint

Access: Tables and Queries in Relational Databases

Access: Query Calculations and Expressions

Access: Basic Forms and Reports

Excell: Introduction to Excel

Excell: Formulas and Functions

Excell: Charts

Powerpoint: Introduction to Powerpoint

Powerpoint: Effective Presentation Development

Powerpoint: Presentation Enhancement

Powerpoint: Presentation Refinement

Word: Introduction to Word

Word: Document Presentation

Word: Document Productivity

Word: Research and Collaboration

Filters

Exam 9: Excell: Datasets and Tables

How does Excel indicate that a column has been selected in a structured reference?

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

What is the default data table style?

In a data table each column is considered a(n) ________.

You can select multiple print areas.

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

Which of the following is not a freeze option?

Match the following terms with their description: i. Color scale II. Icon set III. Filtering IV. Sorting v. Data bars

Records are individual pieces of information.

In Page Break Preview, the area to be printed has a light blue background.

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

Using the data bars conditional formatting, how is the highest value represented?

What cannot be found on the Manage Rules dialog box?

Match the following table style options with their description: i. Header Row II. Total Row III. First Column IV. Last Column v. Filter Button

What is not true about using the AND function in a custom conditional formatting rule?

Match the following Conditional Formatting Options in the Quick Analysis Gallery with their description: i. Text Contains II. Duplicate Values III. Unique Values IV. Equal To v. Clear Format

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

Before you freeze panes make sure the active cell is one row above and one column to the left of the rows and columns you want to freeze.

Which table style option is useful to display aggregated data when it is checked?

What would be the result if you sorted the following dates in ascending order: December 25, 2000; January 1, 2015; January 16, 1957; December 26, 1959?

Common Features

Access: Introduction to Powerpoint

Access: Tables and Queries in Relational Databases

Access: Query Calculations and Expressions

Access: Basic Forms and Reports

Excell: Introduction to Excel

Excell: Formulas and Functions

Excell: Charts

Powerpoint: Introduction to Powerpoint

Powerpoint: Effective Presentation Development

Powerpoint: Presentation Enhancement

Powerpoint: Presentation Refinement

Word: Introduction to Word

Word: Document Presentation

Word: Document Productivity

Word: Research and Collaboration

Filters