Question 1

Case EX 1-2 Donovan is starting to use the keyboard to navigate around an Excel spreadsheet. To move down one window, Donovan presses the ____.

Accepted Answer

A)  Page Down key 
B)  Page Up key 
C)  Ctrl+End keys 
D)  Ctrl+Home keys 
A)  Page Down key 
B)  Page Up key 
C)  Ctrl+End keys 
D)  Ctrl+Home keys

Question 2

The COUNTA function counts the number of cells that do not have any numbers or text entered in them.

Accepted Answer

A) True 
 B)False

Question 3

The Refresh button is located in the Data group on the ____ tab.

Accepted Answer

A)  Data 
B)  Insert 
C)  View 
D)  Options 
A)  Data 
B)  Insert 
C)  View 
D)  Options

Question 4

The chart element called ____ is the graphical representation of all of the data series.

Accepted Answer

A)  chart area 
B)  plot area 
C)  data area 
D)  data marker 
A)  chart area 
B)  plot area 
C)  data area 
D)  data marker

Question 5

Case EX 3-2 Ben is preparing his worksheet to print and is making adjustments to the margin and print area. Ben wants to choose the margin style that will allow for a 1" margin on the top, bottom, and sides. He would choose the preset margin layout that is called ____.

Accepted Answer

A)  Normal 
B)  Wide 
C)  Narrow 
D)  None of the above 
A)  Normal 
B)  Wide 
C)  Narrow 
D)  None of the above

Question 6

The ____ feature is a great method for separating data in a worksheet, such as first and last names.

Accepted Answer

A)  Data Validation 
B)  Convert Text to Columns 
C)  Watch Window 
D)  Concatenation 
A)  Data Validation 
B)  Convert Text to Columns 
C)  Watch Window 
D)  Concatenation

Question 7

Match between columns
                        Premises: Used to separate hours, minutes, and seconds in a format code.

Accepted Answer

The Answer of $ and : (colon) and 0 and is...

Question 8

A 3-D reference is a reference to the same cell or range in multiple worksheets that you use in a formula.

Accepted Answer

A) True 
 B)False

Question 9

Match between columns
                        Premises: A constant (text or number) or cell reference used in a formula.

Accepted Answer

The Answer of Mixed cell reference and Operand and Operator is...

Question 10

FIGURE EX 2-1   In Figure EX 2-1 above, the cell that shows wrapped text is ____.

Accepted Answer

A)  A16 
B)  A18 
C)  A19 
D)  A21 
A)  A16 
B)  A18 
C)  A19 
D)  A21

Question 11

Case EX 10-2 George is managing the fundraising efforts of a non-profit organization that provides services to the homeless. George is very proud of his performance because he has been able to make great progress in meeting the organization's fundraising goals. He can use a ____ chart to showcase the amount of progress accomplished so far.

Accepted Answer

A)  combination 
B)  comparison 
C)  gauge 
D)  tracking 
A)  combination 
B)  comparison 
C)  gauge 
D)  tracking

Question 12

The Chart Tools appear on the Ribbon with three contextual tabs that do NOT include ____.

Accepted Answer

A)  Design 
B)  Layout 
C)  Style 
D)  Format 
A)  Design 
B)  Layout 
C)  Style 
D)  Format

Question 13

When you print a worksheet with tracer arrows, the tracer arrows are not printed.

Accepted Answer

A) True 
 B)False

Question 14

The ____________________ lets you control the calculation that the Subtotal function performs.

Accepted Answer

The answer of The ____________________ lets you control the calculation...

Question 15

Match between columns
                        Premises: Combination of formatting characteristics such as alignment, font color, and borders.

Accepted Answer

The Answer of Cell style and Font and Font size is...

Question 16

____ charts are also used to illustrate a company's market share in comparison to its competitors.

Accepted Answer

A)  Column 
B)  Bar 
C)  Line 
D)  Pie 
A)  Column 
B)  Bar 
C)  Line 
D)  Pie

Question 17

In the IF function, the first argument sets a condition for comparison, called a relative test.

Accepted Answer

A) True 
 B)False

Question 18

Excel has three types of sparklines: Line, Win/Loss, and ____.

Accepted Answer

A)  Pie 
B)  Cylinder 
C)  Progress 
D)  Column 
A)  Pie 
B)  Cylinder 
C)  Progress 
D)  Column

Question 19

The Save & Send options are found under the ____ tab.

Accepted Answer

A)  Page Layout 
B)  View 
C)  Review 
D)  File 
A)  Page Layout 
B)  View 
C)  Review 
D)  File

Question 20

Match between columns
                        Premises: The character which is a placeholder for a digit in a format code. A zero will appear if there is not another number available.

Accepted Answer

The Answer of 0 and : (colon) and # and is...

Case EX 1-2 Donovan is starting to use the keyboard to navigate around an Excel spreadsheet. To move down one window, Donovan presses the ____.

The COUNTA function counts the number of cells that do not have any numbers or text entered in them.

The Refresh button is located in the Data group on the ____ tab.

The chart element called ____ is the graphical representation of all of the data series.

Case EX 3-2 Ben is preparing his worksheet to print and is making adjustments to the margin and print area. Ben wants to choose the margin style that will allow for a 1" margin on the top, bottom, and sides. He would choose the preset margin layout that is called ____.

The ____ feature is a great method for separating data in a worksheet, such as first and last names.

A 3-D reference is a reference to the same cell or range in multiple worksheets that you use in a formula.

FIGURE EX 2-1 In Figure EX 2-1 above, the cell that shows wrapped text is ____.

The Chart Tools appear on the Ribbon with three contextual tabs that do NOT include ____.

When you print a worksheet with tracer arrows, the tracer arrows are not printed.

The ____________________ lets you control the calculation that the Subtotal function performs.

____ charts are also used to illustrate a company's market share in comparison to its competitors.

In the IF function, the first argument sets a condition for comparison, called a relative test.

Excel has three types of sparklines: Line, Win/Loss, and ____.

The Save & Send options are found under the ____ tab.

Microsoft Access Basics

Microsoft Office 2010 and the Internet

Microsoft Powerpoint Basics

Microsoft Word Basics

Filters

Exam 2: Microsoft Excel Basics

Case EX 1-2 Donovan is starting to use the keyboard to navigate around an Excel spreadsheet. To move down one window, Donovan presses the ____.

The COUNTA function counts the number of cells that do not have any numbers or text entered in them.

The Refresh button is located in the Data group on the ____ tab.

The chart element called ____ is the graphical representation of all of the data series.

Case EX 3-2 Ben is preparing his worksheet to print and is making adjustments to the margin and print area. Ben wants to choose the margin style that will allow for a 1" margin on the top, bottom, and sides. He would choose the preset margin layout that is called ____.

The ____ feature is a great method for separating data in a worksheet, such as first and last names.

A 3-D reference is a reference to the same cell or range in multiple worksheets that you use in a formula.

FIGURE EX 2-1 In Figure EX 2-1 above, the cell that shows wrapped text is ____.

The Chart Tools appear on the Ribbon with three contextual tabs that do NOT include ____.

When you print a worksheet with tracer arrows, the tracer arrows are not printed.

The ____________________ lets you control the calculation that the Subtotal function performs.

____ charts are also used to illustrate a company's market share in comparison to its competitors.

In the IF function, the first argument sets a condition for comparison, called a relative test.

Excel has three types of sparklines: Line, Win/Loss, and ____.

The Save & Send options are found under the ____ tab.

Microsoft Access Basics

Microsoft Office 2010 and the Internet

Microsoft Powerpoint Basics

Microsoft Word Basics

Filters