USING MICROSOFT EXCEL
USING THE UPPER AND LOWER FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Theme
|
|
|
Cell style
|
|
|
Style
|
|
|
Font style
|
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: -On the Home tab, in the Style group, click the arrow next to Conditional Formatting, and then click Highlight Cells Rules. Select the command you want, such as Between, Equal To Text that Contains, or A Date Occurring. Enter the values you want to use, and then select a format.
Detailed explanation-3: -You can use Ctrl+Shift+Cto copy a format, and Ctrl+Shift+Vto paste a format. While the cursor does not change to a paintbrush, you can repeatedly paste formatting to multiple areas without re-copying.
Detailed explanation-4: -1. Select the cell you want to apply multiple font colors or fonts, then get into the cell with pressing the F2 key (or just double click the cell). 2. Select the text you need to use different font colors or fonts, click Home > Font Color or Font in the Font group, then specify the certain font color or font you need.