DATABASE FUNDAMENTALS
ADJUSTING COLUMN WIDTH ROW HEIGHT IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
CTRL+1
|
|
|
CTRL+2
|
|
|
CTRL+3
|
|
|
CTRL+4
|
Detailed explanation-1: -Ctrl +1 or ! is a shortcut key in the Microsoft Excel 2007 to display the format cell dialog box. The Format Cells Dialog Box is where you set the formatting options for your report objects. One can format the number, font, alignment, border, and pattern for a row or column header and the values.
Detailed explanation-2: -Apply single spacing to the paragraph. Ctrl+1. Apply double spacing to the paragraph.
Detailed explanation-3: -Ctrl+Shift+U (Windows) or Option+Fn+U (Mac): This shortcut will open the Format Cells dialog box, which can be used to format cells. This is a great way to quickly change the number format of a cell, or to apply other formatting options.
Detailed explanation-4: -The shortcut to launch Format cells dialog box is “CTRL + 1”; there’s no need to use mouse; hence, you can save your precious time.
Detailed explanation-5: -4 ways to open the Format Cells dialog Click the Dialog Box Launcher arrow at the bottom right corner of the Number, Alignment or Font group to open the corresponding tab of the Format Cells dialog: On the Home tab, in the Cells group, click the Format button, and then click Format Cells…