Question 1

What values does the user need to input or confirm in the Format as Table dialog box?

Accepted Answer

A)  cell range and worksheet tab name 
B)  cell range and "My table has headers" option 
C)  worksheet tab name and range of cells containing table headers 
D)  range of table column headers and range of table row headers 
A)  cell range and worksheet tab name 
B)  cell range and "My table has headers" option 
C)  worksheet tab name and range of cells containing table headers 
D)  range of table column headers and range of table row headers

Question 2

The prebuilt function COUNT is in the ________ category of the More Functions option in the Function Library group of the Formulas tab.

Accepted Answer

A)  Cube 
B)  Engineering 
C)  Statistical 
D)  Information 
A)  Cube 
B)  Engineering 
C)  Statistical 
D)  Information

Question 3

When content of a cell is rotated or angled, the row height is automatically increased.

Accepted Answer

A) True 
 B)False

Question 4

The Freeze Panes button is in the Window group of the ________ tab.

Accepted Answer

The answer of The Freeze Panes button is in the...

Question 5

Once a column adjacent to a table becomes a calculated column, it also becomes part of the table.

Accepted Answer

A) True 
 B)False

Question 6

Converting a range of cells in a worksheet to an Excel table is done primarily to have a larger selection of styles.

Accepted Answer

A) True 
 B)False

Question 7

The Replace All option, in the Find and Replace dialog box, should be used only when the search string is ________.

Accepted Answer

The answer of The Replace All option, in the Find...

Question 8

The function IF is a logical function.

Accepted Answer

A) True 
 B)False

Question 9

No more than one row and one column can be in the Freeze panes.

Accepted Answer

A) True 
 B)False

Question 10

Borders are always black.

Accepted Answer

A) True 
 B)False

Question 11

The prebuilt Excel function ________ counts the number of cells that are in the entered range and contain numeric values.

Accepted Answer

A)  NOW 
B)  COUNT 
C)  COUNTA 
D)  COUNTIF 
A)  NOW 
B)  COUNT 
C)  COUNTA 
D)  COUNTIF

Question 12

Pressing ________ repeats the previous command performed.

Accepted Answer

The answer of Pressing ________ repeats the previous command performed....

Question 13

Options to rotate and angle text appear when the ________ button in the Alignment group on the Home tab is clicked.

Accepted Answer

A)  Wrap Text 
B)  Merge & Center 
C)  Cell Styles 
D)  Orientation 
A)  Wrap Text 
B)  Merge & Center 
C)  Cell Styles 
D)  Orientation

Question 14

What is applied to a cell when the value of the cell meets a specified condition?

Accepted Answer

A)  Logical formatting 
B)  Conditional formatting 
C)  Criteria formatting 
D)  Provisional formatting 
A)  Logical formatting 
B)  Conditional formatting 
C)  Criteria formatting 
D)  Provisional formatting

Question 15

When conditional formatting is applied to a cell and the value of that cell changes, the logical condition is reevaluated, and, if necessary, the formatting changed.

Accepted Answer

A) True 
 B)False

Question 16

Only text values can be rotated and angled.

Accepted Answer

A) True 
 B)False

Question 17

Row and column headings that are set to print on each printed page, do NOT appear on each page in Print Preview.

Accepted Answer

A) True 
 B)False

Question 18

A(n) ________ function applies a logical test to see if a specific condition is met.

Accepted Answer

A)  Statistical 
B)  engineering 
C)  logical 
D)  text 
A)  Statistical 
B)  engineering 
C)  logical 
D)  text

Question 19

A ________ is an Excel table feature that takes a formula in a column and automatically adjusts cell references for each row in the table.

Accepted Answer

A)  calculated row 
B)  calculated column 
C)  calculated total 
D)  calculated summary 
A)  calculated row 
B)  calculated column 
C)  calculated total 
D)  calculated summary

Question 20

Selecting ________ from the Freeze Panes command gallery removes frozen panes form a worksheet.

Accepted Answer

The answer of Selecting ________ from the Freeze Panes command...

What values does the user need to input or confirm in the Format as Table dialog box?

The prebuilt function COUNT is in the ________ category of the More Functions option in the Function Library group of the Formulas tab.

When content of a cell is rotated or angled, the row height is automatically increased.

The Freeze Panes button is in the Window group of the ________ tab.

Once a column adjacent to a table becomes a calculated column, it also becomes part of the table.

Converting a range of cells in a worksheet to an Excel table is done primarily to have a larger selection of styles.

The Replace All option, in the Find and Replace dialog box, should be used only when the search string is ________.

The function IF is a logical function.

No more than one row and one column can be in the Freeze panes.

Borders are always black.

The prebuilt Excel function ________ counts the number of cells that are in the entered range and contain numeric values.

Pressing ________ repeats the previous command performed.

Options to rotate and angle text appear when the ________ button in the Alignment group on the Home tab is clicked.

What is applied to a cell when the value of the cell meets a specified condition?

When conditional formatting is applied to a cell and the value of that cell changes, the logical condition is reevaluated, and, if necessary, the formatting changed.

Only text values can be rotated and angled.

Row and column headings that are set to print on each printed page, do NOT appear on each page in Print Preview.

A(n) ________ function applies a logical test to see if a specific condition is met.

A ________ is an Excel table feature that takes a formula in a column and automatically adjusts cell references for each row in the table.

Selecting ________ from the Freeze Panes command gallery removes frozen panes form a worksheet.

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

What values does the user need to input or confirm in the Format as Table dialog box?

The prebuilt function COUNT is in the ________ category of the More Functions option in the Function Library group of the Formulas tab.

When content of a cell is rotated or angled, the row height is automatically increased.

The Freeze Panes button is in the Window group of the ________ tab.

Once a column adjacent to a table becomes a calculated column, it also becomes part of the table.

Converting a range of cells in a worksheet to an Excel table is done primarily to have a larger selection of styles.

The Replace All option, in the Find and Replace dialog box, should be used only when the search string is ________.

The function IF is a logical function.

No more than one row and one column can be in the Freeze panes.

Borders are always black.

The prebuilt Excel function ________ counts the number of cells that are in the entered range and contain numeric values.

Pressing ________ repeats the previous command performed.

Options to rotate and angle text appear when the ________ button in the Alignment group on the Home tab is clicked.

What is applied to a cell when the value of the cell meets a specified condition?

When conditional formatting is applied to a cell and the value of that cell changes, the logical condition is reevaluated, and, if necessary, the formatting changed.

Only text values can be rotated and angled.

Row and column headings that are set to print on each printed page, do NOT appear on each page in Print Preview.

A(n) ________ function applies a logical test to see if a specific condition is met.

A ________ is an Excel table feature that takes a formula in a column and automatically adjusts cell references for each row in the table.

Selecting ________ from the Freeze Panes command gallery removes frozen panes form a worksheet.

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