Question 1

The ____________________ sheet has a white sheet tab.

Accepted Answer

The answer of The ____________________ sheet has a white sheet...

Question 2

A spreadsheet is a collection of numbers,not text.

Accepted Answer

A) True 
 B)False

Question 3

Removing the contents of a cell is known as ____ a cell.

Accepted Answer

A)  clearing 
B)  emptying 
C)  editing 
D)  deleting 
A)  clearing 
B)  emptying 
C)  editing 
D)  deleting

Question 4

The name given to an Excel workbook before you rename it is ____.

Accepted Answer

A)  Document1 
B)  Book1 
C)  Workbook1 
D)  Untitled1 
A)  Document1 
B)  Book1 
C)  Workbook1 
D)  Untitled1

Question 5

____ a printout reduces the width and the height of the printout to fit the number of pages you specify by shrinking the text size as needed.

Accepted Answer

A)  Autofitting 
B)  Scaling 
C)  Shrinking 
D)  Resizing 
A)  Autofitting 
B)  Scaling 
C)  Shrinking 
D)  Resizing

Question 6

You can also move to the previous or next sheet by pressing the ____ keys.

Accepted Answer

A)  Alt+Page Up or Alt+Page Down 
B)  Ctrl+Page Up or Ctrl+Page Down 
C)  Tab+Page Up or Tab+Page Down 
D)  F4+Page Up or F4+Page Down 
A)  Alt+Page Up or Alt+Page Down 
B)  Ctrl+Page Up or Ctrl+Page Down 
C)  Tab+Page Up or Tab+Page Down 
D)  F4+Page Up or F4+Page Down

Question 7

If you click the Print Active sheet(s)option button in the Print tab,the entire workbook will be printed.

Accepted Answer

A) True 
 B)False

Question 8

According to the order of precedence in Excel:

Accepted Answer

A)  Excel performs exponentiation,then multiplication and division,then addition and subtraction. 
B)  Excel performs multiplication,then exponentiation,then division,then addition,then subtraction. 
C)  Excel performs exponentiation,then multiplication,then division,then subtraction,then addition. 
D)  Excel performs multiplication,then division,then exponentiation,then addition,then subtraction. 
A)  Excel performs exponentiation,then multiplication and division,then addition and subtraction. 
B)  Excel performs multiplication,then exponentiation,then division,then addition,then subtraction. 
C)  Excel performs exponentiation,then multiplication,then division,then subtraction,then addition. 
D)  Excel performs multiplication,then division,then exponentiation,then addition,then subtraction.

Question 9

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Where spreadsheets are stored

Accepted Answer

A) function 
B) workbook 
C) worksheet 
D) range 
E) order of precedence
F)Name box
G)Ctrl
H)Normal view
I)AutoSum button
J)what-if analysis
K)formula view
L)sheet tabs 
A) function 
B) workbook 
C) worksheet 
D) range 
E) order of precedence
F)Name box
G)Ctrl
H)Normal view
I)AutoSum button
J)what-if analysis
K)formula view
L)sheet tabs

Question 10

A(n)____________________ sheet reminds you why you created a workbook and what it contains.

Accepted Answer

The answer of A(n)____________________ sheet reminds you why you created...

Question 11

The AutoSum button is in the ____________________ group on the Home tab.

Accepted Answer

The answer of The AutoSum button is in the ____________________...

Question 12

Ctrl + G is used to access the ____.

Accepted Answer

A)  Go to Next worksheet command 
B)  G column 
C)  Go To dialog box 
D)  formula view 
A)  Go to Next worksheet command 
B)  G column 
C)  Go To dialog box 
D)  formula view

Question 13

When you copy a selection of cells using drag and drop,which appears before you release the mouse button?

Accepted Answer

A)  an outline of the new location of the selected range 
B)  a ScreenTip 
C)  a cell reference of the new location 
D)  all of the above 
A)  an outline of the new location of the selected range 
B)  a ScreenTip 
C)  a cell reference of the new location 
D)  all of the above

Question 14

Page Layout view displays the location of the different page breaks within the worksheet._________________________

Accepted Answer

A) True 
 B)False

Question 15

In the figure above,the ____ highlights all occurrences of the search string.

Accepted Answer

A)  Replace button 
B)  Replace All button 
C)  Find All 
D)  Find Next button 
A)  Replace button 
B)  Replace All button 
C)  Find All 
D)  Find Next button

Question 16

A(n)____________________ includes a series of questions that help you think about the purpose of the workbook and how to achieve your desired results.

Accepted Answer

planning a

Question 17

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 18

____ headings are identified by a number.

Accepted Answer

A)  Sheet 
B)  Workbook 
C)  Row 
D)  Column 
A)  Sheet 
B)  Workbook 
C)  Row 
D)  Column

Question 19

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Shows the contents of the worksheet

Accepted Answer

A) function 
B) workbook 
C) worksheet 
D) range 
E) order of precedence
F)Name box
G)Ctrl
H)Normal view
I)AutoSum button
J)what-if analysis
K)formula view
L)sheet tabs 
A) function 
B) workbook 
C) worksheet 
D) range 
E) order of precedence
F)Name box
G)Ctrl
H)Normal view
I)AutoSum button
J)what-if analysis
K)formula view
L)sheet tabs

Question 20

-The figure above shows part of a worksheet.

Accepted Answer

A) True 
 B)False

The ____________________ sheet has a white sheet tab.

A spreadsheet is a collection of numbers,not text.

Removing the contents of a cell is known as ____ a cell.

The name given to an Excel workbook before you rename it is ____.

____ a printout reduces the width and the height of the printout to fit the number of pages you specify by shrinking the text size as needed.

You can also move to the previous or next sheet by pressing the ____ keys.

If you click the Print Active sheet(s)option button in the Print tab,the entire workbook will be printed.

According to the order of precedence in Excel:

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Where spreadsheets are stored

A(n)____________________ sheet reminds you why you created a workbook and what it contains.

The AutoSum button is in the ____________________ group on the Home tab.

Ctrl + G is used to access the ____.

When you copy a selection of cells using drag and drop,which appears before you release the mouse button?

Page Layout view displays the location of the different page breaks within the worksheet._________________________

In the figure above,the ____ highlights all occurrences of the search string.

A(n)____________________ includes a series of questions that help you think about the purpose of the workbook and how to achieve your desired results.

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

____ headings are identified by a number.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Shows the contents of the worksheet

-The figure above shows part of a worksheet.

Formatting a Workbook

Working With Formulas and Functions

Enhancing a Workbook With Charts and Graphs

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

Managing Multiple Worksheets and Workbooks

Using Advanced Functions and Conditional Formatting

Developing an Excel Application

Working With Financial Tools and Functions

Performing What-If Analyses

Connecting to External Data

Expanding Excel With Visual Basic for Applications

Managing Your Files

Getting Started With Microsoft Office 2010

Filters

Exam 1: Getting Started With Excel

The ____________________ sheet has a white sheet tab.

A spreadsheet is a collection of numbers,not text.

Removing the contents of a cell is known as ____ a cell.

The name given to an Excel workbook before you rename it is ____.

____ a printout reduces the width and the height of the printout to fit the number of pages you specify by shrinking the text size as needed.

You can also move to the previous or next sheet by pressing the ____ keys.

If you click the Print Active sheet(s)option button in the Print tab,the entire workbook will be printed.

According to the order of precedence in Excel:

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Where spreadsheets are stored

A(n)____________________ sheet reminds you why you created a workbook and what it contains.

The AutoSum button is in the ____________________ group on the Home tab.

Ctrl + G is used to access the ____.

When you copy a selection of cells using drag and drop,which appears before you release the mouse button?

Page Layout view displays the location of the different page breaks within the worksheet._________________________

In the figure above,the ____ highlights all occurrences of the search string.

A(n)____________________ includes a series of questions that help you think about the purpose of the workbook and how to achieve your desired results.

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

____ headings are identified by a number.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Shows the contents of the worksheet

-The figure above shows part of a worksheet.

Formatting a Workbook

Working With Formulas and Functions

Enhancing a Workbook With Charts and Graphs

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

Managing Multiple Worksheets and Workbooks

Using Advanced Functions and Conditional Formatting

Developing an Excel Application

Working With Financial Tools and Functions

Performing What-If Analyses

Connecting to External Data

Expanding Excel With Visual Basic for Applications

Managing Your Files

Getting Started With Microsoft Office 2010

Filters