Question 1

A ____ is the space between the page content and the edges of the page

Accepted Answer

A)  margin 
B)  border 
C)  frame 
D)  ruler 
A)  margin 
B)  border 
C)  frame 
D)  ruler

Question 2

As a general rule,you should ____.

Accepted Answer

A)  center column titles,left-align text,and right-align numbers 
B)  center column titles,right-align text,and left-align numbers 
C)  right-align column titles,left-align text,and right-align numbers 
D)  left-align column titles,left-align text,and right-align numbers 
A)  center column titles,left-align text,and right-align numbers 
B)  center column titles,right-align text,and left-align numbers 
C)  right-align column titles,left-align text,and right-align numbers 
D)  left-align column titles,left-align text,and right-align numbers

Question 3

The code ____ will display the filename of the current workbook.

Accepted Answer

A)  &name 
B)  &[File] 
C)  +name 
D)  +[File] 
A)  &name 
B)  &[File] 
C)  +name 
D)  +[File]

Question 4

When using the Format Painter,double-click the Format Painter button to paste the same format multiple times and click the Format Painter again to ____.

Accepted Answer

A)  turn it on 
B)  turn it off 
C)  copy formatting 
D)  paste formatting 
A)  turn it on 
B)  turn it off 
C)  copy formatting 
D)  paste formatting

Question 5

To set a page break in Excel,____.

Accepted Answer

A)  select the first cell below the row where you want to insert a page break 
B)  select the first cell above the row where you want to insert a page break 
C)  select the row above where you want to insert a page break 
D)  select the row below where you want to insert a page break 
A)  select the first cell below the row where you want to insert a page break 
B)  select the first cell above the row where you want to insert a page break 
C)  select the row above where you want to insert a page break 
D)  select the row below where you want to insert a page break

Question 6

A(n)____________________ is a key that shows each color used in the worksheet and what it means.

Accepted Answer

The answer of A(n)____________________ is a key that shows each...

Question 7

Conditional formats are dynamic,so a cell's appearance will change to reflect its current value.

Accepted Answer

A) True 
 B)False

Question 8

In column C,there are too many numbers after the decimal place.Karl does not need this level of detail as it is distracting from the data,and you really don't need more than two numbers after the decimal.How could Karl make the data appear cleaner?

Accepted Answer

A)  reenter all numbers 
B)  decrease column width 
C)  decrease font size 
D)  use Number group to decrease number of digits displayed 
A)  reenter all numbers 
B)  decrease column width 
C)  decrease font size 
D)  use Number group to decrease number of digits displayed

Question 9

____ merges each of the rows in the selected range across the columns in the range.

Accepted Answer

A)  Merge build 
B)  Merge and Center 
C)  Merge Across 
D)  Merge Cells 
A)  Merge build 
B)  Merge and Center 
C)  Merge Across 
D)  Merge Cells

Question 10

In the figure above the border line color is ____.

Accepted Answer

A)  green 
B)  dashed 
C)  outlined 
D)  you cannot tell from the figure 
A)  green 
B)  dashed 
C)  outlined 
D)  you cannot tell from the figure

Question 11

Ajeesh wants to print two separate parts of his second spreadsheet - one for the cell range B6:F15 and the other for the full sheet.Ajeesh's best option is to ____.

Accepted Answer

A)  copy and paste B6:F15 to a separate worksheet 
B)  cut B6:F15 and print in a separate document 
C)  adjust the margins to print the selected range 
D)  set Print Areas for the two selections 
A)  copy and paste B6:F15 to a separate worksheet 
B)  cut B6:F15 and print in a separate document 
C)  adjust the margins to print the selected range 
D)  set Print Areas for the two selections

Question 12

Karl would like to center a title across the top of his data.His data runs across five columns,from column A to column E.One way he could accomplish this is to ____.

Accepted Answer

A)  type the data in A1 and Merge cells A1:A5 
B)  type the data in A1 and Merge cells A1:E1 
C)  type the data in C1 
D)  choose Center from the Format menu 
A)  type the data in A1 and Merge cells A1:A5 
B)  type the data in A1 and Merge cells A1:E1 
C)  type the data in C1 
D)  choose Center from the Format menu

Question 13

Case Based Critical-Thinking Questions
Case 2-1
Karl has been working on a field survey project where he has gathered data from across five cities in the last six months.Karl has a lot of data to report and needs help organizing his data sheet for an effective presentation.
-Karl has chosen green as the background color for his workbook.Karl should not use ____ for any of the font or highlight colors.

Accepted Answer

A)  red 
B)  white 
C)  black 
D)  any color is fine 
A)  red 
B)  white 
C)  black 
D)  any color is fine

Question 14

MATCHING
Match each of the following icons with the description that most closely matches its function.
-Aligns the cell content with the cell's bottom edge

Accepted Answer

A)    
B)    
C)   
D)    
E)     
F)  
G)  
H)  
I)  
J)  
K)  
L)   
A)    
B)    
C)   
D)    
E)     
F)  
G)  
H)  
I)  
J)  
K)  
L)

Question 15

A ____ indicates a manual page break.

Accepted Answer

A)  dashed blue line 
B)  solid blue line 
C)  dashed red line 
D)  solid red line 
A)  dashed blue line 
B)  solid blue line 
C)  dashed red line 
D)  solid red line

Question 16

All of the following options are available on the Format Cells dialog box except ____.

Accepted Answer

A)  number 
B)  font 
C)  border 
D)  size 
A)  number 
B)  font 
C)  border 
D)  size

Question 17

You can add a border in Excel ____.

Accepted Answer

A)  to enhance readability 
B)  to the top,right,or bottom of a cell 
C)  and specify the thickness 
D)  all of the above 
A)  to enhance readability 
B)  to the top,right,or bottom of a cell 
C)  and specify the thickness 
D)  all of the above

Question 18

-In the figure above,an example of a non-theme font is ____.

Accepted Answer

A)  Algerian 
B)  Calibri 
C)  Arial 
D)  all of the above 
A)  Algerian 
B)  Calibri 
C)  Arial 
D)  all of the above

Question 19

One of Ajeesh's colleagues thought it would be best to use a database program for this project.Ajeesh explained that Excel can ____.

Accepted Answer

A)  sort data 
B)  transfer data to and from an external file 
C)  filter the data 
D)  all of the above 
A)  sort data 
B)  transfer data to and from an external file 
C)  filter the data 
D)  all of the above

Question 20

By default,numbers appear in the ____ and generally display values exactly as you type them.

Accepted Answer

A)  Home tab 
B)  General number format 
C)  General number toolbar 
D)  currency format 
A)  Home tab 
B)  General number format 
C)  General number toolbar 
D)  currency format

A ____ is the space between the page content and the edges of the page

As a general rule,you should ____.

The code ____ will display the filename of the current workbook.

When using the Format Painter,double-click the Format Painter button to paste the same format multiple times and click the Format Painter again to ____.

To set a page break in Excel,____.

A(n)____________________ is a key that shows each color used in the worksheet and what it means.

Conditional formats are dynamic,so a cell's appearance will change to reflect its current value.

In column C,there are too many numbers after the decimal place.Karl does not need this level of detail as it is distracting from the data,and you really don't need more than two numbers after the decimal.How could Karl make the data appear cleaner?

____ merges each of the rows in the selected range across the columns in the range.

In the figure above the border line color is ____.

Ajeesh wants to print two separate parts of his second spreadsheet - one for the cell range B6:F15 and the other for the full sheet.Ajeesh's best option is to ____.

Karl would like to center a title across the top of his data.His data runs across five columns,from column A to column E.One way he could accomplish this is to ____.

MATCHING Match each of the following icons with the description that most closely matches its function. -Aligns the cell content with the cell's bottom edge

A ____ indicates a manual page break.

All of the following options are available on the Format Cells dialog box except ____.

You can add a border in Excel ____.

-In the figure above,an example of a non-theme font is ____.

One of Ajeesh's colleagues thought it would be best to use a database program for this project.Ajeesh explained that Excel can ____.

By default,numbers appear in the ____ and generally display values exactly as you type them.

Getting Started With Excel

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 2: Formatting a Workbook

A ____ is the space between the page content and the edges of the page

As a general rule,you should ____.

The code ____ will display the filename of the current workbook.

When using the Format Painter,double-click the Format Painter button to paste the same format multiple times and click the Format Painter again to ____.

To set a page break in Excel,____.

A(n)____________________ is a key that shows each color used in the worksheet and what it means.

Conditional formats are dynamic,so a cell's appearance will change to reflect its current value.

In column C,there are too many numbers after the decimal place.Karl does not need this level of detail as it is distracting from the data,and you really don't need more than two numbers after the decimal.How could Karl make the data appear cleaner?

____ merges each of the rows in the selected range across the columns in the range.

In the figure above the border line color is ____.

Ajeesh wants to print two separate parts of his second spreadsheet - one for the cell range B6:F15 and the other for the full sheet.Ajeesh's best option is to ____.

Karl would like to center a title across the top of his data.His data runs across five columns,from column A to column E.One way he could accomplish this is to ____.

MATCHING Match each of the following icons with the description that most closely matches its function. -Aligns the cell content with the cell's bottom edge

A ____ indicates a manual page break.

All of the following options are available on the Format Cells dialog box except ____.

You can add a border in Excel ____.

-In the figure above,an example of a non-theme font is ____.

One of Ajeesh's colleagues thought it would be best to use a database program for this project.Ajeesh explained that Excel can ____.

By default,numbers appear in the ____ and generally display values exactly as you type them.

Getting Started With Excel

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