Question 1

Excel automatically adjusts the cell width when the font size changes.

Accepted Answer

A) True 
 B)False

Question 2

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 3

Match between columns
                        Premises: Doing this enables you to focus on a particular range of data.

Accepted Answer

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

Question 4

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 workbook. 
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 workbook. 
D)  You can choose to print the row and/or column headings on every page.

Question 5

Santiago has entered data in his worksheet and is working on fine-tuning the display. Santiago wants to be able to view and scroll through different parts of the worksheet at the same time. He ____ the worksheet.

Accepted Answer

A)  hides 
B)  filters 
C)  freezes 
D)  splits 
A)  hides 
B)  filters 
C)  freezes 
D)  splits

Question 6

____________________ can be used to automatically insert dates, times, filenames, and more in a header or footer.

Accepted Answer

The answer of ____________________ can be used to automatically insert...

Excel automatically adjusts the cell width when the font size changes.

In the above figure, the worksheet has been ____.

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

Santiago has entered data in his worksheet and is working on fine-tuning the display. Santiago wants to be able to view and scroll through different parts of the worksheet at the same time. He ____ the worksheet.

____________________ can be used to automatically insert dates, times, filenames, and more in a header or footer.

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

Filters

Exam 19: Organizing and Enhancing Worksheets

Excel automatically adjusts the cell width when the font size changes.

In the above figure, the worksheet has been ____.

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

Santiago has entered data in his worksheet and is working on fine-tuning the display. Santiago wants to be able to view and scroll through different parts of the worksheet at the same time. He ____ the worksheet.

____________________ can be used to automatically insert dates, times, filenames, and more in a header or footer.

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

Filters