USING MICROSOFT EXCEL
USING THE UPPER AND LOWER FUNCTIONS 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: -Modifying the column widths usually is done last because other formatting changes may affect the size of the data in the cells in the column. Live preview is available on a touch screen. You can turn off the Bold formatting for selected text by clicking the Roman button (Home tab, Font group.)
Detailed explanation-2: -Which of the following is true about changing worksheet column width? In Normal view, the Column Width dialog box lets you set the exact number of characters that will fit in the column.
Detailed explanation-3: -Without adjusting the column widths, guarantee that all columns will print on one page. On Page Layout tab, in the scale to fit group, click the width arrow. click 1 page. On the Home tab, in the Clipboard group, click the Format Painter button, Click cell E1.
Detailed explanation-4: -Select one or more columns that you wish to resize. To select all columns, press Ctrl + A or click the Select All button. On the Home tab, in the Cells group, click Format > Column Width. In the Column width box, type the desired number, and click OK.
Detailed explanation-5: -To AutoFit column width: The AutoFit feature will allow you to set a column’s width to fit its content automatically. Position the mouse over the column line in the column heading so the cursor becomes a double arrow. Double-click the mouse. The column width will be changed automatically to fit the content.