Question 1

The header and footer commands are located on the ____ tab.

Accepted Answer

A)  Home 
B)  File 
C)  Page Layout 
D)  Insert 
A)  Home 
B)  File 
C)  Page Layout 
D)  Insert D

Question 2

By default, Excel prints comments that are added to the worksheet.

Accepted Answer

A) True 
 B)False  False

Question 3

Which of the following is TRUE about the figure above?

Accepted Answer

A)  The workbook is in Page Break Preview. 
B)  The workbook is split. 
C)  The workbook contains hidden columns. 
D)  There are frozen panes. 
A)  The workbook is in Page Break Preview. 
B)  The workbook is split. 
C)  The workbook contains hidden columns. 
D)  There are frozen panes. A

Question 4

After converting a range of cells to an Excel database , you can manage and calculate the data independently.

Accepted Answer

A) True 
 B)False

Question 5

Common uses of spreadsheets include reporting finances and managing expenses.

Accepted Answer

A) True 
 B)False

Question 6

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 7

A(n) ____ contains column headings or field names in a data source.

Accepted Answer

A)  header row 
B)  column header 
C)  table header 
D)  footer 
A)  header row 
B)  column header 
C)  table header 
D)  footer

Question 8

The font size is a measurement in ____ that determines the height of the font.

Accepted Answer

A)  characters 
B)  points 
C)  pixels 
D)  millimeters 
A)  characters 
B)  points 
C)  pixels 
D)  millimeters

Question 9

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

Accepted Answer

A)  Comments 
B)  Header row 
C)  Column letters 
D)  Gridlines 
A)  Comments 
B)  Header row 
C)  Column letters 
D)  Gridlines

Question 10

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 11

When you freeze columns and rows, the worksheet is divided into two panes.

Accepted Answer

A) True 
 B)False

Question 12

If the text does not fit on one line of a cell, you can wrap to new lines.

Accepted Answer

A) True 
 B)False

Question 13

To remove the contents and the formats from the cell, you need to ____________________ the cell.

Accepted Answer

The answer of To remove the contents and the formats...

Question 14

How many worksheets are contained in a blank workbook by default? Why would you add a new worksheet to a workbook? What do you click to display a different worksheet? Can you copy and paste data from one worksheet to another? List at least one method for inserting a new worksheet. What happens when you delete a tab for a worksheet that contains data?

Accepted Answer

Three worksheets are contained in a blan

Question 15

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

Accepted Answer

A) True 
 B)False

Question 16

The default Fit to command setting is 100% .

Accepted Answer

A) True 
 B)False

Question 17

Santiago has entered data in his worksheet and is working on fine-tuning the display. Santiago applies conditional formatting. Which of the following is NOT one of the options?

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 18

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 19

When you use the Insert Sheet button, the new sheet tab appears to the right of the active sheet tab.

Accepted Answer

A) True 
 B)False

Question 20

The default date style 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

Exam 19: Organizing and Enhancing Worksheets

The header and footer commands are located on the ____ tab.

By default, Excel prints comments that are added to the worksheet.

Which of the following is TRUE about the figure above?

After converting a range of cells to an Excel database , you can manage and calculate the data independently.

Common uses of spreadsheets include reporting finances and managing expenses.

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

A(n) ____ contains column headings or field names in a data source.

The font size is a measurement in ____ that determines the height of the font.

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

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

When you freeze columns and rows, the worksheet is divided into two panes.

If the text does not fit on one line of a cell, you can wrap to new lines.

To remove the contents and the formats from the cell, you need to ____________________ the cell.

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

The default Fit to command setting is 100% .

Santiago has entered data in his worksheet and is working on fine-tuning the display. Santiago applies conditional formatting. Which of the following is NOT one of the options?

Which of the following is NOT true about table styles?

When you use the Insert Sheet button, the new sheet tab appears to the right of the active sheet tab.

The default date style is ____.

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