FUNDAMENTALS OF COMPUTER

DATABASE FUNDAMENTALS

HOW TO MODIFY THE WORKSHEET TAB IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
Page headers and footers can be changed in this view
A
print preview
B
page layout view
C
normal view
D
None of the above
Explanation: 

Detailed explanation-1: -When you select one or more sheets and then click File > Print, you’ll see a preview of how the data will appear on the printout. Select the worksheet(s) you want to preview. Click File, and then click Print to display the Preview window and printing options. Keyboard shortcut You can also press Ctrl+F2.

Detailed explanation-2: -Switch the view that shows all the worksheet elements as they will print, including headers and footers. Click the Page Layout button at the lower right corner of the status bar, to the left of the zoom slider.

Detailed explanation-3: -Changing the column width in Excel automatically You can quickly adjust the column width to accommodate the longest entry. Select any column from the worksheet. From the Cells group on the Home tab, choose Format. Select AutoFit Column Width to set that column to auto-fit the width depending on the contents.

Detailed explanation-4: -The Fill Handle is the small green square located in the bottom right corner of your selection-be it one cell or a larger group of cells. Double-clicking the Fill Handle causes the selected text, formula, or data to be copied downward, with different behaviors resulting depending on the contents of the cell.

There is 1 question to complete.