Question 1

What effect does the Accounting Number Format have on the selected cells?

Accepted Answer

A)  Converts alphabetic characters to numbers 
B)  Displays cell contents with two decimal places that align vertically 
C)  Performs tax calculations 
D)  Copies the numbers of one cell to another 
A)  Converts alphabetic characters to numbers 
B)  Displays cell contents with two decimal places that align vertically 
C)  Performs tax calculations 
D)  Copies the numbers of one cell to another

Question 2

Which of the following keys moves the insertion point to the beginning of data in a cell?

Accepted Answer

A)  HOME 
B)  ENTER 
C)  INSERT 
D)  TAB 
A)  HOME 
B)  ENTER 
C)  INSERT 
D)  TAB

Question 3

Combining two or more selected cells into one cell is called ____ cells.

Accepted Answer

A)  merging 
B)  mixing 
C)  combining 
D)  spanning 
A)  merging 
B)  mixing 
C)  combining 
D)  spanning

Question 4

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 5

The person or persons requesting the worksheet should supply their requirements in a ____ document.

Accepted Answer

A)  blank 
B)  test issues 
C)  requirements 
D)  certified 
A)  blank 
B)  test issues 
C)  requirements 
D)  certified

Question 6

____ is / are used to place worksheet,column,and row titles on a worksheet.

Accepted Answer

A)  Color 
B)  Text 
C)  Links 
D)  Tabs 
A)  Color 
B)  Text 
C)  Links 
D)  Tabs

Question 7

How many chart types does Excel offer?

Accepted Answer

A)  5 
B)  15 
C)  30 
D)  50 
A)  5 
B)  15 
C)  30 
D)  50

Question 8

What effect does the Comma Style format have on the selected cells?

Accepted Answer

A)  Converts decimals to commas within a cell 
B)  Converts decimals to commas within merged cells 
C)  Displays cell contents with two decimal places and commas as thousands separators 
D)  Allows for substitution of selected characters 
A)  Converts decimals to commas within a cell 
B)  Converts decimals to commas within merged cells 
C)  Displays cell contents with two decimal places and commas as thousands separators 
D)  Allows for substitution of selected characters

Question 9

You can enter the correct range in a function by typing the beginning and ending cell references separated by a ____.

Accepted Answer

A)  semi-colon (;) 
B)  colon (:) 
C)  period (.) 
D)  none of the above 
A)  semi-colon (;) 
B)  colon (:) 
C)  period (.) 
D)  none of the above

Question 10

Excel's ____________________ function,which adds all of the numbers in a range of cells,provides a convenient means to calculate a total.

Accepted Answer

The answer of Excel's ____________________ function,which adds all of the...

Question 11

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

Accepted Answer

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

Question 12

A single point is about 1 / 32 of one inch in height.

Accepted Answer

A) True 
 B)False

Question 13

The opposite of merging cells is splitting a merged cell._________________________

Accepted Answer

A) True 
 B)False

Question 14

You can apply the Bold font style by pressing the ____ keyboard shortcut keys.

Accepted Answer

A)  ALT+B 
B)  CTRL+B 
C)  SHIFT+B 
D)  TAB+B 
A)  ALT+B 
B)  CTRL+B 
C)  SHIFT+B 
D)  TAB+B

Question 15

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

Accepted Answer

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

Question 16

The easiest way to select a cell is to move the block _______________________ pointer to the cell and then click.

Accepted Answer

The answer of The easiest way to select a cell...

Question 17

A requirements document includes a needs statement,source of data,summary of calculations,and any other special requirements for a worksheet.

Accepted Answer

A) True 
 B)False

Question 18

You should press the SPACEBAR to clear a cell.

Accepted Answer

A) True 
 B)False

Question 19

The AutoCorrect feature can automatically capitalize the first letter in the names of days.

Accepted Answer

A) True 
 B)False

Question 20

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

Accepted Answer

The answer of The ____________________ button allows you to choose...

What effect does the Accounting Number Format have on the selected cells?

Which of the following keys moves the insertion point to the beginning of data in a cell?

Combining two or more selected cells into one cell is called ____ cells.

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

The person or persons requesting the worksheet should supply their requirements in a ____ document.

____ is / are used to place worksheet,column,and row titles on a worksheet.

How many chart types does Excel offer?

What effect does the Comma Style format have on the selected cells?

You can enter the correct range in a function by typing the beginning and ending cell references separated by a ____.

Excel's ____________________ function,which adds all of the numbers in a range of cells,provides a convenient means to calculate a total.

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

A single point is about 1 / 32 of one inch in height.

The opposite of merging cells is splitting a merged cell._________________________

You can apply the Bold font style by pressing the ____ keyboard shortcut keys.

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

The easiest way to select a cell is to move the block _______________________ pointer to the cell and then click.

A requirements document includes a needs statement,source of data,summary of calculations,and any other special requirements for a worksheet.

You should press the SPACEBAR to clear a cell.

The AutoCorrect feature can automatically capitalize the first letter in the names of days.

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

Formulas, Functions, and Formatting

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

Financial Functions, Data Tables, and Amortization Schedules

Working With Multiple Worksheets and Workbooks

Creating, Sorting, and Querying a Table

Creating Templates, Importing Data, and Working With Smartart, Images, and Screenshots

Working With Trendlines, Pivot Table Reports, Pivotchart Reports, and Slicers

Formula Auditing, Data Validation, and Complex Problem Solving

Using Macros and Visual Basic for Applications Vba With Excel

Collaboration Features for Workbooks

Essential Concepts and Skills

Productivity App: Productivity Apps for School and Work

Filters

Exam 1: Creating a Worksheet and a Chart

What effect does the Accounting Number Format have on the selected cells?

Which of the following keys moves the insertion point to the beginning of data in a cell?

Combining two or more selected cells into one cell is called ____ cells.

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

The person or persons requesting the worksheet should supply their requirements in a ____ document.

____ is / are used to place worksheet,column,and row titles on a worksheet.

How many chart types does Excel offer?

What effect does the Comma Style format have on the selected cells?

You can enter the correct range in a function by typing the beginning and ending cell references separated by a ____.

Excel's ____________________ function,which adds all of the numbers in a range of cells,provides a convenient means to calculate a total.

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

A single point is about 1 / 32 of one inch in height.

The opposite of merging cells is splitting a merged cell._________________________

You can apply the Bold font style by pressing the ____ keyboard shortcut keys.

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

The easiest way to select a cell is to move the block _______________________ pointer to the cell and then click.

A requirements document includes a needs statement,source of data,summary of calculations,and any other special requirements for a worksheet.

You should press the SPACEBAR to clear a cell.

The AutoCorrect feature can automatically capitalize the first letter in the names of days.

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

Formulas, Functions, and Formatting

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

Financial Functions, Data Tables, and Amortization Schedules

Working With Multiple Worksheets and Workbooks

Creating, Sorting, and Querying a Table

Creating Templates, Importing Data, and Working With Smartart, Images, and Screenshots

Working With Trendlines, Pivot Table Reports, Pivotchart Reports, and Slicers

Formula Auditing, Data Validation, and Complex Problem Solving

Using Macros and Visual Basic for Applications Vba With Excel

Collaboration Features for Workbooks

Essential Concepts and Skills

Productivity App: Productivity Apps for School and Work

Filters