Question 1

Roger notices that the Dog Name column is too wide and he could use that extra space for other columns so he ____.

Accepted Answer

A)  autofits the column by double-clicking the cell with the longest entry 
B)  autofits the column by double-clicking its border 
C)  autofits the column by selecting it,then clicking the AutoFit button in the Cells group 
D)  places the mouse pointer on the column border and drags to the right 
A)  autofits the column by double-clicking the cell with the longest entry 
B)  autofits the column by double-clicking its border 
C)  autofits the column by selecting it,then clicking the AutoFit button in the Cells group 
D)  places the mouse pointer on the column border and drags to the right

Question 2

Scrolling through sheet tabs does not change the active sheet in the workbook window.

Accepted Answer

A) True 
 B)False

Question 3

What is the result of the expression =50/(10*5)?

Accepted Answer

A)  1/5 
B)  1 
C)  25 
D)  50 
A)  1/5 
B)  1 
C)  25 
D)  50

Question 4

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Press Ctrl + ` to switch to this view

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 5

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 6

The cell reference for the active cell appears in the ____________________ located in the upper-left corner of the worksheet.

Accepted Answer

The answer of The cell reference for the active cell...

Question 7

To create a line break within a cell,press Alt + Enter.

Accepted Answer

A) True 
 B)False

Question 8

A(n)____________________ is a collection of text and numbers laid out in a rectangular grid.

Accepted Answer

The answer of A(n)____________________ is a collection of text and...

Question 9

A text string contains a string of text ____________________.

Accepted Answer

The answer of A text string contains a string of...

Question 10

The AutoComplete feature automatically completes an entry based on previous entries in a column.

Accepted Answer

A) True 
 B)False

Question 11

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Quickly inserts Excel functions

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 12

To move a cell,select it,then place the mouse over the bottom border of the cell before dragging it to a new location._________________________

Accepted Answer

A) True 
 B)False

Question 13

-Referring to the figure above,the Zoom control is set at 100%.

Accepted Answer

A) True 
 B)False

Question 14

A documentation sheet is a valuable element if you intend to share the workbook with others.

Accepted Answer

A) True 
 B)False

Question 15

Put the following steps for entering multiple lines of text within a cell in the proper order:
1)Press and hold the Alt key,then press the Enter key to move the insertion point to a
New line within the cell,then enter the next line of text.
2)Press the Alt + Enter keys for each new line of text you need to enter within the cell.
3)Click the cell in which you want to enter the text.
4)Enter the line of text.

Accepted Answer

A)  2,1,3,4 
B)  1,2,3,4 
C)  3,4,1,2 
D)  3,4,2,1 
A)  2,1,3,4 
B)  1,2,3,4 
C)  3,4,1,2 
D)  3,4,2,1

Question 16

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Allows you to use Excel to change one or more values in a spreadsheet and
then assess the effect those changes have on the calculated values

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 17

Copying a range of cells is similar to moving a range,except that you must press the ____ key while you drag the selection to its new location.

Accepted Answer

A)  Shift 
B)  F3 
C)  Esc 
D)  Ctrl 
A)  Shift 
B)  F3 
C)  Esc 
D)  Ctrl

Question 18

Case-Based Critical Thinking Questions
Case 1-1
Roger has created a spreadsheet to keep track of his customers for his dog-walking business.In the spreadsheet,he includes the dog owners' names,addresses,phone numbers,dog name,dog breed,dog age,and days of the week his services are needed.
-Column B in Roger's spreadsheet contains the addresses of his clients.Some of the addresses are truncated so Roger ____.

Accepted Answer

A)  uses the AutoComplete command to allow for complete entries 
B)  uses the AutoFit command to remove unwanted space 
C)  resizes the column width until all addresses are visible 
D)  switches to Edit mode 
A)  uses the AutoComplete command to allow for complete entries 
B)  uses the AutoFit command to remove unwanted space 
C)  resizes the column width until all addresses are visible 
D)  switches to Edit mode

Question 19

Excel makes reading formulas simpler by ____ each cell reference in the formula and its corresponding cell in the worksheet.

Accepted Answer

A)  color coding 
B)  bolding 
C)  highlighting 
D)  italicizing 
A)  color coding 
B)  bolding 
C)  highlighting 
D)  italicizing

Question 20

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

Roger notices that the Dog Name column is too wide and he could use that extra space for other columns so he ____.

Scrolling through sheet tabs does not change the active sheet in the workbook window.

What is the result of the expression =50/(10*5)?

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Press Ctrl + ` to switch to this view

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

The cell reference for the active cell appears in the ____________________ located in the upper-left corner of the worksheet.

To create a line break within a cell,press Alt + Enter.

A(n)____________________ is a collection of text and numbers laid out in a rectangular grid.

A text string contains a string of text ____________________.

The AutoComplete feature automatically completes an entry based on previous entries in a column.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Quickly inserts Excel functions

To move a cell,select it,then place the mouse over the bottom border of the cell before dragging it to a new location._________________________

-Referring to the figure above,the Zoom control is set at 100%.

A documentation sheet is a valuable element if you intend to share the workbook with others.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Allows you to use Excel to change one or more values in a spreadsheet and then assess the effect those changes have on the calculated values

Copying a range of cells is similar to moving a range,except that you must press the ____ key while you drag the selection to its new location.

Excel makes reading formulas simpler by ____ each cell reference in the formula and its corresponding cell in the worksheet.

Which of the following takes precedence over multiplication?

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

Roger notices that the Dog Name column is too wide and he could use that extra space for other columns so he ____.

Scrolling through sheet tabs does not change the active sheet in the workbook window.

What is the result of the expression =50/(10*5)?

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Press Ctrl + ` to switch to this view

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

The cell reference for the active cell appears in the ____________________ located in the upper-left corner of the worksheet.

To create a line break within a cell,press Alt + Enter.

A(n)____________________ is a collection of text and numbers laid out in a rectangular grid.

A text string contains a string of text ____________________.

The AutoComplete feature automatically completes an entry based on previous entries in a column.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Quickly inserts Excel functions

To move a cell,select it,then place the mouse over the bottom border of the cell before dragging it to a new location._________________________

-Referring to the figure above,the Zoom control is set at 100%.

A documentation sheet is a valuable element if you intend to share the workbook with others.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Allows you to use Excel to change one or more values in a spreadsheet and then assess the effect those changes have on the calculated values

Copying a range of cells is similar to moving a range,except that you must press the ____ key while you drag the selection to its new location.

Excel makes reading formulas simpler by ____ each cell reference in the formula and its corresponding cell in the worksheet.

Which of the following takes precedence over multiplication?

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