Question 1

Which is NOT a text rotation or angle option in the Orientation list?

Accepted Answer

A)  Angle Clockwise 
B)  Angle Counterclockwise 
C)  Vertical Text 
D)  Reverse Vertical Text 
A)  Angle Clockwise 
B)  Angle Counterclockwise 
C)  Vertical Text 
D)  Reverse Vertical Text

Question 2

The ________ option in the Find and Replace dialog box replaces only the highlighted occurrence of the search string.

Accepted Answer

A)  Find Next 
B)  Find All 
C)  Replace 
D)  Replace All 
A)  Find Next 
B)  Find All 
C)  Replace 
D)  Replace All

Question 3

The combination of using the Merge Cells feature, increasing font size, and adding borders gives a worksheet row a banner-like appearance.

Accepted Answer

A) True 
 B)False

Question 4

When the Markers option in the Design contextual tab is checked, ________.

Accepted Answer

A)  a mark for each data value is placed on the sparklines 
B)  a mark for only the high data value is placed on the sparklines 
C)  a mark for only the low data value is placed on the sparklines 
D)  marks for the first and last data values are placed on the sparklines 
A)  a mark for each data value is placed on the sparklines 
B)  a mark for only the high data value is placed on the sparklines 
C)  a mark for only the low data value is placed on the sparklines 
D)  marks for the first and last data values are placed on the sparklines

Question 5

The Unfreeze Panes option appears when the ________ button is clicked.

Accepted Answer

A)  New Window 
B)  Freeze Panes 
C)  Arrange All 
D)  Full Screen 
A)  New Window 
B)  Freeze Panes 
C)  Arrange All 
D)  Full Screen

Question 6

That Freeze Panes is being used in a worksheet is indicated by ________.

Accepted Answer

A)  a border 
B)  an error indicator 
C)  sizing handles 
D)  the range finder 
A)  a border 
B)  an error indicator 
C)  sizing handles 
D)  the range finder

Question 7

Match each table-related term with its description.
-Filter button

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 8

The Find and Select button is located in the ________ group on the Home tab.

Accepted Answer

The answer of The Find and Select button is located...

Question 9

The function COUNT returns the number of cells that are in the user selected range and have a number as the displayed value.

Accepted Answer

A) True 
 B)False

Question 10

What is the comparison operator for not-equal?

Accepted Answer

The answer of What is the comparison operator for not-equal?...

Question 11

The AutoFill method of copying the underlying value of a cell can be used on cells containing the function IF.

Accepted Answer

A) True 
 B)False

Question 12

Various points (e.g., High Point, Low Point, First Point, Last Point) can be marked on a sparkline.

Accepted Answer

A) True 
 B)False

Question 13

When the Sort Smallest to Largest option is selected from the Filter gallery, the Filter button displays ________.

Accepted Answer

A)  in green 
B)  in red 
C)  another up-arrow icon 
D)  another down-arrow icon 
A)  in green 
B)  in red 
C)  another up-arrow icon 
D)  another down-arrow icon

Question 14

The suggested range in the Format as Table dialog box is based on the location of the active cell and the layout of the column and row ________.

Accepted Answer

The answer of The suggested range in the Format as...

Question 15

The ________ group on the Page Layout tab includes options for adjusting worksheet column width and worksheet row height to fit a maximum number of pages.

Accepted Answer

A)  Sheet Options 
B)  Scale to Fit 
C)  Page Setup 
D)  Arrange 
A)  Sheet Options 
B)  Scale to Fit 
C)  Page Setup 
D)  Arrange

Question 16

Find and Replace can be used on selected cells and on the entire worksheet.

Accepted Answer

A) True 
 B)False

Question 17

When the active cell is in a table, the Table Tools ________ contextual tab appears on the Ribbon.

Accepted Answer

The answer of When the active cell is in a...

Question 18

The Format as Table command is in the Styles group of the ________ tab.

Accepted Answer

The answer of The Format as Table command is in...

Question 19

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

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 20

The underlying value that appears in the formula bar for the function TODAY is ________.

Accepted Answer

The answer of The underlying value that appears in the...

Which is NOT a text rotation or angle option in the Orientation list?

The ________ option in the Find and Replace dialog box replaces only the highlighted occurrence of the search string.

The combination of using the Merge Cells feature, increasing font size, and adding borders gives a worksheet row a banner-like appearance.

When the Markers option in the Design contextual tab is checked, ________.

The Unfreeze Panes option appears when the ________ button is clicked.

That Freeze Panes is being used in a worksheet is indicated by ________.

Match each table-related term with its description. -Filter button

The Find and Select button is located in the ________ group on the Home tab.

The function COUNT returns the number of cells that are in the user selected range and have a number as the displayed value.

What is the comparison operator for not-equal?

The AutoFill method of copying the underlying value of a cell can be used on cells containing the function IF.

Various points (e.g., High Point, Low Point, First Point, Last Point) can be marked on a sparkline.

When the Sort Smallest to Largest option is selected from the Filter gallery, the Filter button displays ________.

The suggested range in the Format as Table dialog box is based on the location of the active cell and the layout of the column and row ________.

The ________ group on the Page Layout tab includes options for adjusting worksheet column width and worksheet row height to fit a maximum number of pages.

Find and Replace can be used on selected cells and on the entire worksheet.

When the active cell is in a table, the Table Tools ________ contextual tab appears on the Ribbon.

The Format as Table command is in the Styles group of the ________ tab.

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

The underlying value that appears in the formula bar for the function TODAY is ________.

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

Which is NOT a text rotation or angle option in the Orientation list?

The ________ option in the Find and Replace dialog box replaces only the highlighted occurrence of the search string.

The combination of using the Merge Cells feature, increasing font size, and adding borders gives a worksheet row a banner-like appearance.

When the Markers option in the Design contextual tab is checked, ________.

The Unfreeze Panes option appears when the ________ button is clicked.

That Freeze Panes is being used in a worksheet is indicated by ________.

Match each table-related term with its description. -Filter button

The Find and Select button is located in the ________ group on the Home tab.

The function COUNT returns the number of cells that are in the user selected range and have a number as the displayed value.

What is the comparison operator for not-equal?

The AutoFill method of copying the underlying value of a cell can be used on cells containing the function IF.

Various points (e.g., High Point, Low Point, First Point, Last Point) can be marked on a sparkline.

When the Sort Smallest to Largest option is selected from the Filter gallery, the Filter button displays ________.

The suggested range in the Format as Table dialog box is based on the location of the active cell and the layout of the column and row ________.

The ________ group on the Page Layout tab includes options for adjusting worksheet column width and worksheet row height to fit a maximum number of pages.

Find and Replace can be used on selected cells and on the entire worksheet.

When the active cell is in a table, the Table Tools ________ contextual tab appears on the Ribbon.

The Format as Table command is in the Styles group of the ________ tab.

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

The underlying value that appears in the formula bar for the function TODAY is ________.

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