DATABASE FUNDAMENTALS
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
True
|
|
|
False
|
|
|
Either A or B
|
|
|
None of the above
|
Detailed explanation-1: -If you hide rows 3:5 in your worksheet, row 4 will not print. To rename a worksheet, you can double-click the sheet tab and type the new name without pressing [Delete] or [Backspace]. While multiple sheets are selected, you can modify all of the selected sheets by making changes to one of them.
Detailed explanation-2: -How can you quickly add a border around a set of cells covering 3 rows and 12 columns? Use Draw Border under Border on the ribbon under Home.
Detailed explanation-3: -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-4: -Set row 1 to print on every page by clicking on the page layout tab, in the page setup group, click the print titles button. In the page setup dialog, on the Sheet tab, click in the Rows to repeat at top box. Click the row selector for row 1. Click Ok in the dialog.