Question 1

When you ____________________ rows and columns, the data remains intact; it is just not displayed on the screen.

Accepted Answer

The answer of When you ____________________ rows and columns, the...

Question 2

The default style used to display the date is ____.

Accepted Answer

A)  1/20/14 
B)  1-20-2014 
C)  20-Jan-14 
D)  January 20, 2014 
A)  1/20/14 
B)  1-20-2014 
C)  20-Jan-14 
D)  January 20, 2014

Question 3

By default, Excel aligns numbers at the ____ of the cell.

Accepted Answer

A)  right 
B)  left 
C)  center 
D)  top 
A)  right 
B)  left 
C)  center 
D)  top

Question 4

Which of the following is NOT true about changing the page setup?

Accepted Answer

A)  Page Break Preview shows you how the worksheet will be printed. 
B)  You can drag the page break to a new location. 
C)  The default setting for a worksheet is landscape orientation. 
D)  The Fit to command fits the worksheet to a specific number of pages. 
A)  Page Break Preview shows you how the worksheet will be printed. 
B)  You can drag the page break to a new location. 
C)  The default setting for a worksheet is landscape orientation. 
D)  The Fit to command fits the worksheet to a specific number of pages.

Question 5

Which of the following is NOT true about default print options in Excel?

Accepted Answer

A)  Gridlines, row numbers, and column letters are printed. 
B)  Excel prints the entire worksheet. 
C)  When you create a print area, the print setting is saved with the worksheet. 
D)  You can choose to print the row and/or column headings on every page. 
A)  Gridlines, row numbers, and column letters are printed. 
B)  Excel prints the entire worksheet. 
C)  When you create a print area, the print setting is saved with the worksheet. 
D)  You can choose to print the row and/or column headings on every page.

Question 6

You can easily change the print settings using commands in the ____.

Accepted Answer

A)  Page Setup dialog box 
B)  Backstage view 
C)  HOME tab 
D)  Either a or b 
A)  Page Setup dialog box 
B)  Backstage view 
C)  HOME tab 
D)  Either a or b

Question 7

Which of the following is NOT true about table styles?

Accepted Answer

A)  If you convert the table to a regular range, the table style formatting is removed. 
B)  A table style is a set of predefined formats you can apply to worksheet data. 
C)  You can choose from 60 table styles in the Quick Styles gallery. 
D)  All of the above are true. 
A)  If you convert the table to a regular range, the table style formatting is removed. 
B)  A table style is a set of predefined formats you can apply to worksheet data. 
C)  You can choose from 60 table styles in the Quick Styles gallery. 
D)  All of the above are true.

Question 8

Conditional formatting applies designated formats to cells when the cell value meets specified criteria. ____________________

Accepted Answer

A) True 
 B)False

Question 9

Cate has finished entering data and formatting her worksheet, and she is ready to print and share it with others. Cate wants to share her workbook electronically, but she doesn't want the recipients to be able to modify the data. One of her options is to save it as a(n) ____ file.

Accepted Answer

A)  PDF 
B)  HTML 
C)  .xlsx 
D)  template 
A)  PDF 
B)  HTML 
C)  .xlsx 
D)  template

Question 10

Santiago has entered data in his worksheet and is working on fine-tuning the display. Which of the following is NOT an option for Santiago to apply for conditional formatting?

Accepted Answer

A)  Data Bars 
B)  Color Scales 
C)  Quick Styles 
D)  Icon Sets 
A)  Data Bars 
B)  Color Scales 
C)  Quick Styles 
D)  Icon Sets

Question 11

Match between columns
                        Premises: Screens data to only display data that meets certain criteria
Doing this enables you to focus on a particular range of data
Locks columns and rows to keep them visible
Rearranges data in as many as three different columns
Divides the worksheet into two panes

Accepted Answer

The Answer of Split and Sort and Filter and Freeze is...

Question 12

In the above figure, the worksheet has been ____.

Accepted Answer

A)  merged 
B)  frozen 
C)  split 
D)  unhidden 
A)  merged 
B)  frozen 
C)  split 
D)  unhidden

Question 13

Use the Preview command to control how many pages are in your worksheet. ____________________

Accepted Answer

A) True 
 B)False

Question 14

When you use the Cut and Copy commands, the data and formats are also moved or copied.

Accepted Answer

A) True 
 B)False

Question 15

Turning a range of cells into an Excel database allows you to manage data separately from any other data in the same worksheet. ____________________

Accepted Answer

A) True 
 B)False

Question 16

A(n) ____________________ is descriptive text that is printed in the top margin of a worksheet.

Accepted Answer

The answer of A(n) ____________________ is descriptive text that is...

Question 17

Comments added to an Excel worksheet are automatically printed by default.

Accepted Answer

A) True 
 B)False

Question 18

By default, new blank workbooks include ____ worksheet(s) .

Accepted Answer

A)  zero 
B)  one 
C)  two 
D)  three 
A)  zero 
B)  one 
C)  two 
D)  three

Question 19

Which of the following is NOT true about working with multiple worksheets?

Accepted Answer

A)  When you need to add a new category to a workbook, you add a new worksheet. 
B)  Sheet tabs are located at the top of the workbook window. 
C)  You can copy and paste data from one worksheet to another. 
D)  All of the above are true. 
A)  When you need to add a new category to a workbook, you add a new worksheet. 
B)  Sheet tabs are located at the top of the workbook window. 
C)  You can copy and paste data from one worksheet to another. 
D)  All of the above are true.

Question 20

Cate has finished entering data and formatting her worksheet, and she is ready to print and share it with others. Cate wants to print her workbook. By default, which of the following worksheet data will print?

Accepted Answer

A)  comments 
B)  headers 
C)  column letters 
D)  gridlines 
A)  comments 
B)  headers 
C)  column letters 
D)  gridlines

Exam 19: Organizing and Enhancing Worksheets

When you ____________________ rows and columns, the data remains intact; it is just not displayed on the screen.

The default style used to display the date is ____.

By default, Excel aligns numbers at the ____ of the cell.

Which of the following is NOT true about changing the page setup?

Which of the following is NOT true about default print options in Excel?

You can easily change the print settings using commands in the ____.

Which of the following is NOT true about table styles?

Conditional formatting applies designated formats to cells when the cell value meets specified criteria. ____________________

Cate has finished entering data and formatting her worksheet, and she is ready to print and share it with others. Cate wants to share her workbook electronically, but she doesn't want the recipients to be able to modify the data. One of her options is to save it as a(n) ____ file.

Santiago has entered data in his worksheet and is working on fine-tuning the display. Which of the following is NOT an option for Santiago to apply for conditional formatting?

In the above figure, the worksheet has been ____.

Use the Preview command to control how many pages are in your worksheet. ____________________

When you use the Cut and Copy commands, the data and formats are also moved or copied.

Turning a range of cells into an Excel database allows you to manage data separately from any other data in the same worksheet. ____________________

A(n) ____________________ is descriptive text that is printed in the top margin of a worksheet.

Comments added to an Excel worksheet are automatically printed by default.

By default, new blank workbooks include ____ worksheet(s) .

Which of the following is NOT true about working with multiple worksheets?

Cate has finished entering data and formatting her worksheet, and she is ready to print and share it with others. Cate wants to print her workbook. By default, which of the following worksheet data will print?

Computers and Computer Systems

Input, Output and Processing

Computer Protection

Computer Maintenance

Computer-Related Issues

Software and Hardware Interaction

Software Fundamentals

Operating Systems

Windows Management

Operating System Customization

Exploring Microsoft Office 2010

Getting Started With Word Essentials

Editing and Formatting Documents

Sharing Documents

Working With Tables

Using Templates, Styles, and Building Blocks

Enhancing Documents

Getting Started With Excel Essentials

Creating Formulas and Charting Data

Getting Started With Powerpoint Essentials

Enhancing Presentations With Multimedia Effects

Getting Started With Access Essentials

Managing and Reporting Database Information

Networks Fundamentals

Communication Services

Communications and Collaboration

Using the Internet and the World Wide Web

Web Content

Technology and Society

Security, Privacy, and Ethics Online

Using Windows 7

Filters