Question 1

When the Freeze Panes command is applied in a worksheet, the frozen rows and columns become separate ________.

Accepted Answer

panes

Question 2

There is NO Style gallery for a sparkline chart.

Accepted Answer

A) True 
 B)False  False

Question 3

The ________ chart type is NOT a sparkline option.

Accepted Answer

A)  line 
B)  column 
C)  win/loss 
D)  pie 
A)  line 
B)  column 
C)  win/loss 
D)  pie D

Question 4

A filter is removed from a table column by selecting ________ from the Filter gallery.

Accepted Answer

The answer of A filter is removed from a table...

Question 5

The Freeze Panes command is useful in working with ________.

Accepted Answer

A)  short worksheets 
B)  large worksheets 
C)  multiple worksheets 
D)  multiple workbooks 
A)  short worksheets 
B)  large worksheets 
C)  multiple worksheets 
D)  multiple workbooks

Question 6

Match each table-related term with its description.
-Calculated column

Accepted Answer

A) Small arrow that appears to the right of the label at the top of a table column 
B) Up arrow or down arrow indicating sort direction of a column 
C) Excel table column that uses a single formula and adjusts its cell references for the rest of the rows in the table 
D) Labels above each table column 
A) Small arrow that appears to the right of the label at the top of a table column 
B) Up arrow or down arrow indicating sort direction of a column 
C) Excel table column that uses a single formula and adjusts its cell references for the rest of the rows in the table 
D) Labels above each table column

Question 7

When a Total row summary function is inserted at the bottom of a table column and the summary function COUNT is selected, the displayed value of the COUNT function represents the number of ________.

Accepted Answer

A)  cells in the entire table 
B)  cells in the column that contain a text value 
C)  the number of cells in the column that contain a number value 
D)  rows in the entire table 
A)  cells in the entire table 
B)  cells in the column that contain a text value 
C)  the number of cells in the column that contain a number value 
D)  rows in the entire table

Question 8

The Logical test in the function IF function must contain a(n) ________.

Accepted Answer

A)  arithmetic operator 
B)  reference operator 
C)  comparison operator 
D)  precedence operator 
A)  arithmetic operator 
B)  reference operator 
C)  comparison operator 
D)  precedence operator

Question 9

The functions TODAY and NOW have no arguments.

Accepted Answer

A) True 
 B)False

Question 10

Arguments in a function are separated by a(n) ________.

Accepted Answer

A)  colon 
B)  comma 
C)  semi-colon 
D)  exclamation point 
A)  colon 
B)  comma 
C)  semi-colon 
D)  exclamation point

Question 11

Match each function-related term with its description.
-Criteria

Accepted Answer

A) Applies a logical test to see if a specific condition is true 
B) Placed around text values used as function arguments 
C) Conditions specified in a logical test 
D) Compares two values and returns true or false 
E) Placed between function arguments 
A) Applies a logical test to see if a specific condition is true 
B) Placed around text values used as function arguments 
C) Conditions specified in a logical test 
D) Compares two values and returns true or false 
E) Placed between function arguments

Question 12

In ________, the selected format is applied to a cell if the cell content makes the specified condition true.

Accepted Answer

conditiona

Question 13

When a range of cells is converted to a table, the default setting in the Filter gallery is ________.

Accepted Answer

A)  Select All 
B)  Sort by Color 
C)  Sort Smallest to Largest 
D)  Sort Largest to Smallest 
A)  Select All 
B)  Sort by Color 
C)  Sort Smallest to Largest 
D)  Sort Largest to Smallest

Question 14

Two worksheets can have the same sheet tab name.

Accepted Answer

A) True 
 B)False

Question 15

The function COUNT counts the number of cells that are in the entered range and contain ________.

Accepted Answer

The answer of The function COUNT counts the number of...

Question 16

What conditional formatting option is useful in identifying higher and lower numbers in a large group of data?

Accepted Answer

The answer of What conditional formatting option is useful in...

Question 17

Data in an Excel table can be sorted in a variety of ways.

Accepted Answer

A) True 
 B)False

Question 18

The ________ key can be used to move from one input box to another in a dialog box.

Accepted Answer

A)  Enter 
B)  Tab 
C)  F4 
D)  Page Down 
A)  Enter 
B)  Tab 
C)  F4 
D)  Page Down

Question 19

Data in an Excel table are managed ________ from other data in the worksheet.

Accepted Answer

The answer of Data in an Excel table are managed...

Question 20

No more than one row and one column can be frozen using the Freeze Panes feature.

Accepted Answer

A) True 
 B)False

When the Freeze Panes command is applied in a worksheet, the frozen rows and columns become separate ________.

There is NO Style gallery for a sparkline chart.

The ________ chart type is NOT a sparkline option.

A filter is removed from a table column by selecting ________ from the Filter gallery.

The Freeze Panes command is useful in working with ________.

Match each table-related term with its description. -Calculated column

When a Total row summary function is inserted at the bottom of a table column and the summary function COUNT is selected, the displayed value of the COUNT function represents the number of ________.

The Logical test in the function IF function must contain a(n) ________.

The functions TODAY and NOW have no arguments.

Arguments in a function are separated by a(n) ________.

Match each function-related term with its description. -Criteria

In ________, the selected format is applied to a cell if the cell content makes the specified condition true.

When a range of cells is converted to a table, the default setting in the Filter gallery is ________.

Two worksheets can have the same sheet tab name.

The function COUNT counts the number of cells that are in the entered range and contain ________.

What conditional formatting option is useful in identifying higher and lower numbers in a large group of data?

Data in an Excel table can be sorted in a variety of ways.

The ________ key can be used to move from one input box to another in a dialog box.

Data in an Excel table are managed ________ from other data in the worksheet.

No more than one row and one column can be frozen using the Freeze Panes feature.

Create Database Tables

Create Select Queries

Create Forms

Create Reports

Common Features of Office 2013

Getting Started With Computer Concepts

Create Workbooks With Excel 2013

Insert Summary Functions and Create Charts

Manage Multiple Worksheets

Browse With Internet Explorer

Getting Started With Powerpoint 2013

Format a Presentation

Enhance Presentations With Graphics

Present Data Using Tables, Charts, and Animation

Getting Started With Windows 8

Create Letters and Memos

Create Business Reports

Create Flyers

Create Newsletters and Mail Merge Documents

Filters

Exam 10: More Functions and Excel Tables

When the Freeze Panes command is applied in a worksheet, the frozen rows and columns become separate ________.

There is NO Style gallery for a sparkline chart.

The ________ chart type is NOT a sparkline option.

A filter is removed from a table column by selecting ________ from the Filter gallery.

The Freeze Panes command is useful in working with ________.

Match each table-related term with its description. -Calculated column

When a Total row summary function is inserted at the bottom of a table column and the summary function COUNT is selected, the displayed value of the COUNT function represents the number of ________.

The Logical test in the function IF function must contain a(n) ________.

The functions TODAY and NOW have no arguments.

Arguments in a function are separated by a(n) ________.

Match each function-related term with its description. -Criteria

In ________, the selected format is applied to a cell if the cell content makes the specified condition true.

When a range of cells is converted to a table, the default setting in the Filter gallery is ________.

Two worksheets can have the same sheet tab name.

The function COUNT counts the number of cells that are in the entered range and contain ________.

What conditional formatting option is useful in identifying higher and lower numbers in a large group of data?

Data in an Excel table can be sorted in a variety of ways.

The ________ key can be used to move from one input box to another in a dialog box.

Data in an Excel table are managed ________ from other data in the worksheet.

No more than one row and one column can be frozen using the Freeze Panes feature.

Create Database Tables

Create Select Queries

Create Forms

Create Reports

Common Features of Office 2013

Getting Started With Computer Concepts

Create Workbooks With Excel 2013

Insert Summary Functions and Create Charts

Manage Multiple Worksheets

Browse With Internet Explorer

Getting Started With Powerpoint 2013

Format a Presentation

Enhance Presentations With Graphics

Present Data Using Tables, Charts, and Animation

Getting Started With Windows 8

Create Letters and Memos

Create Business Reports

Create Flyers

Create Newsletters and Mail Merge Documents

Filters