Question 1

Filters can be applied to more than one column in a table.

Accepted Answer

A) True 
 B)False

Question 2

The ________ dialog box is where the user enters cell addresses, cell ranges, or constants to complete a function.

Accepted Answer

A)  Input 
B)  Function Arguments 
C)  Data 
D)  Parameter 
A)  Input 
B)  Function Arguments 
C)  Data 
D)  Parameter

Question 3

When a large worksheet is to take up more than one printed page, Page Setup options can be set to make row and column headings appear on each printed page.

Accepted Answer

A) True 
 B)False

Question 4

The two orientations that can be applied to a worksheet are portrait and ________.

Accepted Answer

The answer of The two orientations that can be applied...

Question 5

More than one column in a table can have the Sort Arrow icon on its filter button.

Accepted Answer

A) True 
 B)False

Question 6

Match each table-related term with its description.
-Header row

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

In a table with manual or conditional formatting, a column can be sorted only by ________.

Accepted Answer

A)  color 
B)  smallest to largest value 
C)  largest to smallest value 
D)  style 
A)  color 
B)  smallest to largest value 
C)  largest to smallest value 
D)  style

Question 8

The ________ appears on a Filter button to indicate that the values in a column are sorted from largest to smallest.

Accepted Answer

The answer of The ________ appears on a Filter button...

Question 9

Select the ________ of the single occurrence you want to replace in the Find All list of the Find and Replace dialog box to change just that one occurrence.

Accepted Answer

The answer of Select the ________ of the single occurrence...

Question 10

When a cell containing a sparkline is selected, the Sparkline Tools ________ contextual tab appears on the Ribbon.

Accepted Answer

The answer of When a cell containing a sparkline is...

Question 11

Orientation and scaling CANNOT be applied to grouped worksheets.

Accepted Answer

A) True 
 B)False

Question 12

The functions TODAY and NOW are in the ________ category in the Function Library group of the Formulas tab.

Accepted Answer

A)  Date & Time 
B)  Lookup & Reference 
C)  Math & Trig 
D)  More Functions 
A)  Date & Time 
B)  Lookup & Reference 
C)  Math & Trig 
D)  More Functions

Question 13

The ________ tab in the Page Setup dialog box has options for keeping rows at the top of, and columns at the left of, each printed page of a large worksheet.

Accepted Answer

A)  Page 
B)  Margins 
C)  Header/Footer 
D)  Sheet 
A)  Page 
B)  Margins 
C)  Header/Footer 
D)  Sheet

Question 14

In large worksheets, scrolling down 50 rows causes the labels above the columns to disappear from view.

Accepted Answer

A) True 
 B)False

Question 15

In function arguments, text values are surrounded by ________.

Accepted Answer

The answer of In function arguments, text values are surrounded...

Question 16

A function is said to be ________ when its displayed value automatically updates.

Accepted Answer

The answer of A function is said to be ________...

Question 17

The ________ button is the arrow to the right of a header row label in a table.

Accepted Answer

A)  edit 
B)  sort 
C)  analyze 
D)  filter 
A)  edit 
B)  sort 
C)  analyze 
D)  filter

Question 18

A comparison operator returns a value of yes or no.

Accepted Answer

A) True 
 B)False

Question 19

Match each function-related term with its description.
-Quotation marks

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

When the Filter button is clicked, the ________ displays filter options.

Accepted Answer

The answer of When the Filter button is clicked, the...

Filters can be applied to more than one column in a table.

The ________ dialog box is where the user enters cell addresses, cell ranges, or constants to complete a function.

When a large worksheet is to take up more than one printed page, Page Setup options can be set to make row and column headings appear on each printed page.

The two orientations that can be applied to a worksheet are portrait and ________.

More than one column in a table can have the Sort Arrow icon on its filter button.

Match each table-related term with its description. -Header row

In a table with manual or conditional formatting, a column can be sorted only by ________.

The ________ appears on a Filter button to indicate that the values in a column are sorted from largest to smallest.

Select the ________ of the single occurrence you want to replace in the Find All list of the Find and Replace dialog box to change just that one occurrence.

When a cell containing a sparkline is selected, the Sparkline Tools ________ contextual tab appears on the Ribbon.

Orientation and scaling CANNOT be applied to grouped worksheets.

The functions TODAY and NOW are in the ________ category in the Function Library group of the Formulas tab.

The ________ tab in the Page Setup dialog box has options for keeping rows at the top of, and columns at the left of, each printed page of a large worksheet.

In large worksheets, scrolling down 50 rows causes the labels above the columns to disappear from view.

In function arguments, text values are surrounded by ________.

A function is said to be ________ when its displayed value automatically updates.

The ________ button is the arrow to the right of a header row label in a table.

A comparison operator returns a value of yes or no.

Match each function-related term with its description. -Quotation marks

When the Filter button is clicked, the ________ displays filter options.

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

Filters can be applied to more than one column in a table.

The ________ dialog box is where the user enters cell addresses, cell ranges, or constants to complete a function.

When a large worksheet is to take up more than one printed page, Page Setup options can be set to make row and column headings appear on each printed page.

The two orientations that can be applied to a worksheet are portrait and ________.

More than one column in a table can have the Sort Arrow icon on its filter button.

Match each table-related term with its description. -Header row

In a table with manual or conditional formatting, a column can be sorted only by ________.

The ________ appears on a Filter button to indicate that the values in a column are sorted from largest to smallest.

Select the ________ of the single occurrence you want to replace in the Find All list of the Find and Replace dialog box to change just that one occurrence.

When a cell containing a sparkline is selected, the Sparkline Tools ________ contextual tab appears on the Ribbon.

Orientation and scaling CANNOT be applied to grouped worksheets.

The functions TODAY and NOW are in the ________ category in the Function Library group of the Formulas tab.

The ________ tab in the Page Setup dialog box has options for keeping rows at the top of, and columns at the left of, each printed page of a large worksheet.

In large worksheets, scrolling down 50 rows causes the labels above the columns to disappear from view.

In function arguments, text values are surrounded by ________.

A function is said to be ________ when its displayed value automatically updates.

The ________ button is the arrow to the right of a header row label in a table.

A comparison operator returns a value of yes or no.

Match each function-related term with its description. -Quotation marks

When the Filter button is clicked, the ________ displays filter options.

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