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

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.

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

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...

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 ____.

Identify the letter of the choice that best matches the phrase or definition.

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.