Question 1

The formula bar displays the value or formula of the active cell.

Accepted Answer

A) True 
 B)False

Question 2

-In the figure above Box 3,points to color coded ____ references.

Accepted Answer

A) cell 
B) formula 
C) row 
D) function 
A) cell 
B) formula 
C) row 
D) function

Question 3

Which of the following takes precedence over multiplication?

Accepted Answer

A) division 
B) exponentiation 
C) addition 
D) subtraction 
A) division 
B) exponentiation 
C) addition 
D) subtraction

Question 4

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-A group of worksheet cells

Accepted Answer

A) function 
B) Name box 
C) worksheet 
D) range 
E) order of operations
F)sheet tabs
G)Ctrl
H)Normal view
I)formula view
J)template 
A) function 
B) Name box 
C) worksheet 
D) range 
E) order of operations
F)sheet tabs
G)Ctrl
H)Normal view
I)formula view
J)template

Question 5

In the formula,=2+6*2,addition would be calculated $\underline {  \text { after }  }$multiplication._________________________

Accepted Answer

A) True 
 B)False

Question 6

When you ____________________ a workbook,a dialog box might open,asking whether you want to save the workbook.

Accepted Answer

The answer of When you ____________________ a workbook,a dialog box...

Question 7

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-A preformatted workbook with many design features and some content already filled in.

Accepted Answer

A) function 
B) Name box 
C) worksheet 
D) range 
E) order of operations
F)sheet tabs
G)Ctrl
H)Normal view
I)formula view
J)template 
A) function 
B) Name box 
C) worksheet 
D) range 
E) order of operations
F)sheet tabs
G)Ctrl
H)Normal view
I)formula view
J)template

Question 8

A(n)____ is a group of cells in a rectangular block.

Accepted Answer

A) cluster 
B) adjunct 
C) selection 
D) range 
A) cluster 
B) adjunct 
C) selection 
D) range

Question 9

An adjacent range is a collection of separate ranges.

Accepted Answer

A) True 
 B)False

Question 10

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Multiplication before addition

Accepted Answer

A) function 
B) Name box 
C) worksheet 
D) range 
E) order of operations
F)sheet tabs
G)Ctrl
H)Normal view
I)formula view
J)template 
A) function 
B) Name box 
C) worksheet 
D) range 
E) order of operations
F)sheet tabs
G)Ctrl
H)Normal view
I)formula view
J)template

Question 11

In ____ orientation,a page is taller than it is wide.

Accepted Answer

A) natural 
B) landscape 
C) portrait 
D) basic 
A) natural 
B) landscape 
C) portrait 
D) basic

Question 12

The characters +,-,*,and / are examples of ____.

Accepted Answer

A) formulas 
B) values 
C) arithmetic operators 
D) calculations 
A) formulas 
B) values 
C) arithmetic operators 
D) calculations

Question 13

To make A1 the active cell,you should press which of the following keys?

Accepted Answer

A) Page Up 
B) Page Down 
C) Home 
D) Ctrl + Home 
A) Page Up 
B) Page Down 
C) Home 
D) Ctrl + Home

Question 14

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Displays the cell reference of the active cell

Accepted Answer

A) function 
B) Name box 
C) worksheet 
D) range 
E) order of operations
F)sheet tabs
G)Ctrl
H)Normal view
I)formula view
J)template 
A) function 
B) Name box 
C) worksheet 
D) range 
E) order of operations
F)sheet tabs
G)Ctrl
H)Normal view
I)formula view
J)template

Question 15

The sheets in a workbook are identified in the sheet tabs at the top of the workbook window.

Accepted Answer

A) True 
 B)False

Question 16

Changing the page orientation affects only the ____________________ sheet.

Accepted Answer

The answer of Changing the page orientation affects only the...

Question 17

When text wraps within a cell,the $\underline {  \text { column width }  }$increases so that all of the text within the cell is displayed._________________________

Accepted Answer

A) True 
 B)False

Question 18

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-When you copy a range of cells,you must press this key while you drag the selection to its new location

Accepted Answer

A) function 
B) Name box 
C) worksheet 
D) range 
E) order of operations
F)sheet tabs
G)Ctrl
H)Normal view
I)formula view
J)template 
A) function 
B) Name box 
C) worksheet 
D) range 
E) order of operations
F)sheet tabs
G)Ctrl
H)Normal view
I)formula view
J)template

Question 19

When you insert a new row,the existing rows are shifted down and the new row has the same $\underline { \text { width }   }$ as the row above it._________________________

Accepted Answer

A) True 
 B)False

Question 20

-In the figure above,Box 2 points to a formula in ____ multiplying the values in cells F13 and G13.

Accepted Answer

A) cell F13 
B) cell H13., 
C) cell G13, 
D) cell H13. 
A) cell F13 
B) cell H13., 
C) cell G13, 
D) cell H13.

The formula bar displays the value or formula of the active cell.

-In the figure above Box 3,points to color coded ____ references.

Which of the following takes precedence over multiplication?

MATCHING Identify the letter of the choice that best matches the phrase or definition. -A group of worksheet cells

In the formula,=2+6*2,addition would be calculated $\underline { \text { after } }$ multiplication._________________________

When you ____________________ a workbook,a dialog box might open,asking whether you want to save the workbook.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -A preformatted workbook with many design features and some content already filled in.

A(n)____ is a group of cells in a rectangular block.

An adjacent range is a collection of separate ranges.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Multiplication before addition

In ____ orientation,a page is taller than it is wide.

The characters +,-,*,and / are examples of ____.

To make A1 the active cell,you should press which of the following keys?

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Displays the cell reference of the active cell

The sheets in a workbook are identified in the sheet tabs at the top of the workbook window.

Changing the page orientation affects only the ____________________ sheet.

When text wraps within a cell,the $\underline { \text { column width } }$ increases so that all of the text within the cell is displayed._________________________

MATCHING Identify the letter of the choice that best matches the phrase or definition. -When you copy a range of cells,you must press this key while you drag the selection to its new location

When you insert a new row,the existing rows are shifted down and the new row has the same $\underline { \text { width } }$ as the row above it._________________________

-In the figure above,Box 2 points to a formula in ____ multiplying the values in cells F13 and G13.

Formatting Workbook Text and Data

Calculating Data With Formulas and Functions

Analyzing and Charting Financial Data

Working With Excel Tables, Pivot-tables, and Pivot-charts

Managing Multiple Worksheets and Workbooks

Developing an Excel Application

Working With Advanced Functions

Exploring Financial Tools and Functions

Performing What If Analyses

Connecting to External Data

Collaborating on a Shared Workbook

Managing Your Files

Filters

Exam 1: Getting Started With Excel

The formula bar displays the value or formula of the active cell.

-In the figure above Box 3,points to color coded ____ references.

Which of the following takes precedence over multiplication?

MATCHING Identify the letter of the choice that best matches the phrase or definition. -A group of worksheet cells

In the formula,=2+6*2,addition would be calculated after ‾\underline { \text { after } } after ​ multiplication._________________________

When you ____________________ a workbook,a dialog box might open,asking whether you want to save the workbook.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -A preformatted workbook with many design features and some content already filled in.

A(n)____ is a group of cells in a rectangular block.

An adjacent range is a collection of separate ranges.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Multiplication before addition

In ____ orientation,a page is taller than it is wide.

The characters +,-,*,and / are examples of ____.

To make A1 the active cell,you should press which of the following keys?

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Displays the cell reference of the active cell

The sheets in a workbook are identified in the sheet tabs at the top of the workbook window.

Changing the page orientation affects only the ____________________ sheet.

When text wraps within a cell,the column width ‾\underline { \text { column width } } column width ​ increases so that all of the text within the cell is displayed._________________________

MATCHING Identify the letter of the choice that best matches the phrase or definition. -When you copy a range of cells,you must press this key while you drag the selection to its new location

When you insert a new row,the existing rows are shifted down and the new row has the same width ‾\underline { \text { width } } width ​ as the row above it._________________________

-In the figure above,Box 2 points to a formula in ____ multiplying the values in cells F13 and G13.

Formatting Workbook Text and Data

Calculating Data With Formulas and Functions

Analyzing and Charting Financial Data

Working With Excel Tables, Pivot-tables, and Pivot-charts

Managing Multiple Worksheets and Workbooks

Developing an Excel Application

Working With Advanced Functions

Exploring Financial Tools and Functions

Performing What If Analyses

Connecting to External Data

Collaborating on a Shared Workbook

Managing Your Files

Filters

In the formula,=2+6*2,addition would be calculated $\underline { \text { after } }$ multiplication._________________________

When text wraps within a cell,the $\underline { \text { column width } }$ increases so that all of the text within the cell is displayed._________________________

When you insert a new row,the existing rows are shifted down and the new row has the same $\underline { \text { width } }$ as the row above it._________________________