Question 1

____________________ corrects two initial capital letters by changing the second letter to lowercase.

Accepted Answer

The answer of ____________________ corrects two initial capital letters by...

Question 2

The Top status bar command is used to display the highest value in the selected range in the AutoCalculate area._________________________

Accepted Answer

A) True 
 B)False

Question 3

The ____ is the small black square located in the lower-right corner of the heavy border around the active cell.

Accepted Answer

A)  selection handle 
B)  sizing handle 
C)  fill handle 
D)  copy handle 
A)  selection handle 
B)  sizing handle 
C)  fill handle 
D)  copy handle

Question 4

A given range contains the data that determines the size of slices in a corresponding pie chart;these entries are called the category names.

Accepted Answer

A) True 
 B)False

Question 5

Identify the letter of the choice that best matches the phrase or definition.
-Deletes characters to the left of the insertion point.

Accepted Answer

A) ALT+PAGE DOWN 
B) ARROW 
C) CTRL+HOME 
D) HOME 
E) CTRL+F
F)END
G)INSERT
H)SHIFT+RIGHT ARROW
I)BACKSPACE
J)SPACEBAR 
A) ALT+PAGE DOWN 
B) ARROW 
C) CTRL+HOME 
D) HOME 
E) CTRL+F
F)END
G)INSERT
H)SHIFT+RIGHT ARROW
I)BACKSPACE
J)SPACEBAR

Question 6

Identify the letter of the choice that best matches the phrase or definition.
-Should not be used to clear a cell.

Accepted Answer

A) ALT+PAGE DOWN 
B) ARROW 
C) CTRL+HOME 
D) HOME 
E) CTRL+F
F)END
G)INSERT
H)SHIFT+RIGHT ARROW
I)BACKSPACE
J)SPACEBAR 
A) ALT+PAGE DOWN 
B) ARROW 
C) CTRL+HOME 
D) HOME 
E) CTRL+F
F)END
G)INSERT
H)SHIFT+RIGHT ARROW
I)BACKSPACE
J)SPACEBAR

Question 7

The range of cells receiving the content of copied cells is called the ____.

Accepted Answer

A)  receiver cell 
B)  final cell 
C)  receiving range 
D)  destination area 
A)  receiver cell 
B)  final cell 
C)  receiving range 
D)  destination area

Question 8

A character with a point size of 10 is about 10/72 of one inch in height.

Accepted Answer

A) True 
 B)False

Question 9

The group of adjacent cells beginning with B4 and ending with B8,written as B4:B8,is called a(n)range._________________________

Accepted Answer

A) True 
 B)False

Question 10

Identify the letter of the choice that best matches the phrase or definition.
-Selects cell A1.

Accepted Answer

A) ALT+PAGE DOWN 
B) ARROW 
C) CTRL+HOME 
D) HOME 
E) CTRL+F
F)END
G)INSERT
H)SHIFT+RIGHT ARROW
I)BACKSPACE
J)SPACEBAR 
A) ALT+PAGE DOWN 
B) ARROW 
C) CTRL+HOME 
D) HOME 
E) CTRL+F
F)END
G)INSERT
H)SHIFT+RIGHT ARROW
I)BACKSPACE
J)SPACEBAR

Question 11

Pressing the ____ key to complete an entry activates the adjacent cell to the right.

Accepted Answer

A)  RIGHT ARROW 
B)  LEFT ARROW 
C)  UP ARROW 
D)  DOWN ARROW 
A)  RIGHT ARROW 
B)  LEFT ARROW 
C)  UP ARROW 
D)  DOWN ARROW

Question 12

The ____ button allows you to choose whether you want to copy the values from the source area to the destination area with formatting.

Accepted Answer

A)  Copy Options 
B)  Replace Options 
C)  Formatting Options 
D)  Auto Fill Options 
A)  Copy Options 
B)  Replace Options 
C)  Formatting Options 
D)  Auto Fill Options

Question 13

If you have multiple Excel workbooks open,to close all open workbooks and exit Excel,____.

Accepted Answer

A)  press F4 
B)  press ALT+F4 
C)  press and hold the Excel app button on the taskbar and then tap 'Close all windows' on the shortcut menu 
D)  right-click the Excel app button on the taskbar and then click 'Close all windows' on the shortcut menu 
A)  press F4 
B)  press ALT+F4 
C)  press and hold the Excel app button on the taskbar and then tap 'Close all windows' on the shortcut menu 
D)  right-click the Excel app button on the taskbar and then click 'Close all windows' on the shortcut menu

Question 14

You use ____ to view an XPS file.

Accepted Answer

A)  Adobe Reader 
B)  Backstage View 
C)  Microsoft PowerView 
D)  XPS Viewer 
A)  Adobe Reader 
B)  Backstage View 
C)  Microsoft PowerView 
D)  XPS Viewer

Question 15

If the next entry you want to make is in an adjacent cell,use the ____________________ keys to complete the entry in the current cell and make the adjacent cell the active cell.

Accepted Answer

The answer of If the next entry you want to...

Question 16

A ____ reference is an adjusted cell reference in a copied and pasted formula.

Accepted Answer

A)  revised 
B)  relative 
C)  recycled 
D)  retained 
A)  revised 
B)  relative 
C)  recycled 
D)  retained

Question 17

A(n)____________________ conveys a visual representation of data.

Accepted Answer

The answer of A(n)____________________ conveys a visual representation of data....

Question 18

Press ____ to select the entire worksheet.

Accepted Answer

A)  F1 
B)  CTRL+A 
C)  ALT+A 
D)  F4 
A)  F1 
B)  CTRL+A 
C)  ALT+A 
D)  F4

Question 19

Identify the letter of the choice that best matches the phrase or definition.
-Selects the cell at the beginning of the row that contains the active cell.

Accepted Answer

A) ALT+PAGE DOWN 
B) ARROW 
C) CTRL+HOME 
D) HOME 
E) CTRL+F
F)END
G)INSERT
H)SHIFT+RIGHT ARROW
I)BACKSPACE
J)SPACEBAR 
A) ALT+PAGE DOWN 
B) ARROW 
C) CTRL+HOME 
D) HOME 
E) CTRL+F
F)END
G)INSERT
H)SHIFT+RIGHT ARROW
I)BACKSPACE
J)SPACEBAR

Question 20

A pie chart with one or more slices offset is referred to as a(n)____ pie chart.

Accepted Answer

A)  exploded 
B)  outer 
C)  offset 
D)  rasterized 
A)  exploded 
B)  outer 
C)  offset 
D)  rasterized

____________________ corrects two initial capital letters by changing the second letter to lowercase.

The Top status bar command is used to display the highest value in the selected range in the AutoCalculate area._________________________

The ____ is the small black square located in the lower-right corner of the heavy border around the active cell.

A given range contains the data that determines the size of slices in a corresponding pie chart;these entries are called the category names.

Identify the letter of the choice that best matches the phrase or definition. -Deletes characters to the left of the insertion point.

Identify the letter of the choice that best matches the phrase or definition. -Should not be used to clear a cell.

The range of cells receiving the content of copied cells is called the ____.

A character with a point size of 10 is about 10/72 of one inch in height.

The group of adjacent cells beginning with B4 and ending with B8,written as B4:B8,is called a(n)range._________________________

Identify the letter of the choice that best matches the phrase or definition. -Selects cell A1.

Pressing the ____ key to complete an entry activates the adjacent cell to the right.

The ____ button allows you to choose whether you want to copy the values from the source area to the destination area with formatting.

If you have multiple Excel workbooks open,to close all open workbooks and exit Excel,____.

You use ____ to view an XPS file.

If the next entry you want to make is in an adjacent cell,use the ____________________ keys to complete the entry in the current cell and make the adjacent cell the active cell.

A ____ reference is an adjusted cell reference in a copied and pasted formula.

A(n)____________________ conveys a visual representation of data.

Press ____ to select the entire worksheet.

Identify the letter of the choice that best matches the phrase or definition. -Selects the cell at the beginning of the row that contains the active cell.

A pie chart with one or more slices offset is referred to as a(n)____ pie chart.

Word: Creating, Formatting, and Editing a Word Document With a Picture

Word: Creating a Research Paper With References and Sources

Word: Creating a Business Letter With a Letterhead and Table

Powerpoint: Creating and Editing a Presentation With Pictures

Powerpoint: Enhancing a Presentation With Pictures, Shapes, and Wordart

Powerpoint: Reusing a Presentation and Adding Media and Animation

Outlook: Managing Email Messages With Outlook

Outlook: Managing Calendars With Outlook

Office 2013 and Windows 8: Essential Concepts and Skills

Office 365 Essentials

Introduction to Technology

Excel: Formulas, Functions, and Formatting

Excel: Working With Large Worksheets, Charting, and What-If Analysis

Access: Databases and Database Objects: an Introduction

Access: Querying a Database

Access: Maintaining a Database

Filters

Exam 12: Excel: Creating a Worksheet and a Chart

____________________ corrects two initial capital letters by changing the second letter to lowercase.

The Top status bar command is used to display the highest value in the selected range in the AutoCalculate area._________________________

The ____ is the small black square located in the lower-right corner of the heavy border around the active cell.

A given range contains the data that determines the size of slices in a corresponding pie chart;these entries are called the category names.

Identify the letter of the choice that best matches the phrase or definition. -Deletes characters to the left of the insertion point.

Identify the letter of the choice that best matches the phrase or definition. -Should not be used to clear a cell.

The range of cells receiving the content of copied cells is called the ____.

A character with a point size of 10 is about 10/72 of one inch in height.

The group of adjacent cells beginning with B4 and ending with B8,written as B4:B8,is called a(n)range._________________________

Identify the letter of the choice that best matches the phrase or definition. -Selects cell A1.

Pressing the ____ key to complete an entry activates the adjacent cell to the right.

The ____ button allows you to choose whether you want to copy the values from the source area to the destination area with formatting.

If you have multiple Excel workbooks open,to close all open workbooks and exit Excel,____.

You use ____ to view an XPS file.

If the next entry you want to make is in an adjacent cell,use the ____________________ keys to complete the entry in the current cell and make the adjacent cell the active cell.

A ____ reference is an adjusted cell reference in a copied and pasted formula.

A(n)____________________ conveys a visual representation of data.

Press ____ to select the entire worksheet.

Identify the letter of the choice that best matches the phrase or definition. -Selects the cell at the beginning of the row that contains the active cell.

A pie chart with one or more slices offset is referred to as a(n)____ pie chart.

Word: Creating, Formatting, and Editing a Word Document With a Picture

Word: Creating a Research Paper With References and Sources

Word: Creating a Business Letter With a Letterhead and Table

Powerpoint: Creating and Editing a Presentation With Pictures

Powerpoint: Enhancing a Presentation With Pictures, Shapes, and Wordart

Powerpoint: Reusing a Presentation and Adding Media and Animation

Outlook: Managing Email Messages With Outlook

Outlook: Managing Calendars With Outlook

Office 2013 and Windows 8: Essential Concepts and Skills

Office 365 Essentials

Introduction to Technology

Excel: Formulas, Functions, and Formatting

Excel: Working With Large Worksheets, Charting, and What-If Analysis

Access: Databases and Database Objects: an Introduction

Access: Querying a Database

Access: Maintaining a Database

Filters