Question 1

The first option that appears with the Format as Table command is Table style selection.

Accepted Answer

A) True 
 B)False

Question 2

Cell references in a function or formula do NOT change when the cell is moved by ________.

Accepted Answer

The answer of Cell references in a function or formula...

Question 3

The prebuilt Excel function ________ returns the serial number of the current date and time.

Accepted Answer

A)  TODAY 
B)  COUNT 
C)  DATE 
D)  NOW 
A)  TODAY 
B)  COUNT 
C)  DATE 
D)  NOW

Question 4

When data in a table are ________, only those table rows matching the specific criteria are displayed.

Accepted Answer

The answer of When data in a table are ________,...

Question 5

Which is NOT a Total row summary function?

Accepted Answer

A)  SUM 
B)  AVERAGE 
C)  TODAY 
D)  COUNT 
A)  SUM 
B)  AVERAGE 
C)  TODAY 
D)  COUNT

Question 6

The default chart type for a sparkline is ________.

Accepted Answer

The answer of The default chart type for a sparkline...

Question 7

All prebuilt Excel functions are volatile.

Accepted Answer

A) True 
 B)False

Question 8

The tab label for a worksheet that is named Total and is copied to the same workbook is ________.

Accepted Answer

The answer of The tab label for a worksheet that...

Question 9

Sparklines are used to show ________.

Accepted Answer

The answer of Sparklines are used to show ________....

Question 10

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

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 11

Match each function-related term with its description.
-Comparison operator

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

When a table is filtered, the rows that do not match the filtered criteria are permanently removed from the table.

Accepted Answer

A) True 
 B)False

Question 13

The function IF can have a maximum of ________ argument(s).

Accepted Answer

A)  no 
B)  one 
C)  two 
D)  three 
A)  no 
B)  one 
C)  two 
D)  three

Question 14

The symbols >, =,  are ________.

Accepted Answer

comparison

Question 15

Match each table-related term with its description.
-Sort arrow

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 16

Formatting options in the Format Cells dialog box are NOT available for conditional formatting.

Accepted Answer

A) True 
 B)False

Question 17

A data bar is a format that quickly identifies higher and lower numbers in a large group of data.

Accepted Answer

A) True 
 B)False

Question 18

The condition specified in a logical test is the ________.

Accepted Answer

The answer of The condition specified in a logical test...

Question 19

The Text That Contains dialog box can be accessed by clicking the ________ button.

Accepted Answer

A)  Quick Access Lens 
B)  Options 
C)  Quick Analysis Lens 
D)  Conditional Formatting 
A)  Quick Access Lens 
B)  Options 
C)  Quick Analysis Lens 
D)  Conditional Formatting

Question 20

The ________ is the first argument of the function IF.

Accepted Answer

The answer of The ________ is the first argument of...

The first option that appears with the Format as Table command is Table style selection.

Cell references in a function or formula do NOT change when the cell is moved by ________.

The prebuilt Excel function ________ returns the serial number of the current date and time.

When data in a table are ________, only those table rows matching the specific criteria are displayed.

Which is NOT a Total row summary function?

The default chart type for a sparkline is ________.

All prebuilt Excel functions are volatile.

The tab label for a worksheet that is named Total and is copied to the same workbook is ________.

Sparklines are used to show ________.

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

Match each function-related term with its description. -Comparison operator

When a table is filtered, the rows that do not match the filtered criteria are permanently removed from the table.

The function IF can have a maximum of ________ argument(s).

The symbols >, <, >=, <=, =, and <> are ________.

Match each table-related term with its description. -Sort arrow

Formatting options in the Format Cells dialog box are NOT available for conditional formatting.

A data bar is a format that quickly identifies higher and lower numbers in a large group of data.

The condition specified in a logical test is the ________.

The Text That Contains dialog box can be accessed by clicking the ________ button.

The ________ is the first argument of the function IF.

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

The first option that appears with the Format as Table command is Table style selection.

Cell references in a function or formula do NOT change when the cell is moved by ________.

The prebuilt Excel function ________ returns the serial number of the current date and time.

When data in a table are ________, only those table rows matching the specific criteria are displayed.

Which is NOT a Total row summary function?

The default chart type for a sparkline is ________.

All prebuilt Excel functions are volatile.

The tab label for a worksheet that is named Total and is copied to the same workbook is ________.

Sparklines are used to show ________.

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

Match each function-related term with its description. -Comparison operator

When a table is filtered, the rows that do not match the filtered criteria are permanently removed from the table.

The function IF can have a maximum of ________ argument(s).

The symbols >, <, >=, <=, =, and <> are ________.

Match each table-related term with its description. -Sort arrow

Formatting options in the Format Cells dialog box are NOT available for conditional formatting.

A data bar is a format that quickly identifies higher and lower numbers in a large group of data.

The condition specified in a logical test is the ________.

The Text That Contains dialog box can be accessed by clicking the ________ button.

The ________ is the first argument of the function IF.

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