DATABASE FUNDAMENTALS
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Column Styles
|
|
|
cell styles
|
|
|
Either A or B
|
|
|
None of the above
|
Detailed explanation-1: -A cell style is a defined set of formatting characteristics, such as fonts and font sizes, number formats, cell borders, and cell shading. To prevent anyone from making changes to specific cells, you can also use a cell style that locks cells.
Detailed explanation-2: -A style is a set of formatting characteristics, such as font name, size, color, alignment, and spacing. When you want to apply more than one format at a time to a cell or range of cells, it is easiest to apply a style. Styles also help you keep formatting consistent throughout a workbook.
Detailed explanation-3: -More information. In most cases, the current limit of different formatting combinations for a single workbook (4, 000 for . xls format and 64, 000 for .
Detailed explanation-4: -Select the cells that have the style applied. Click the Cell Styles button on the Home tab. Select Normal.
Detailed explanation-5: -In just a few steps by applying the Total style helps the “Total” column of sales figures stand out. 2. Now within the Style options, under the section, “Titles and Headings” just select the Total option. The selected range of cells will now display the Total formatting.