5. How can you add background colors to cells?
6. What is cell address?
H. Solve these questions in Excel.
1. 2412*3/12+6
2. 12*13*14-56
3. 243+122-62*3
Answers
Answer:
please follow
vaishnavi
class 7
Explanation:
Solution: You need to use Excel conditional formatting to highlight the values greater than X, less than Y or between X and Y.
Suppose you have a list of gasoline prices in different states and you want the prices greater than USD 3.7 to be of the color red and equal to or less than USD 3.45 to be of the color green.
A table listing gasoline prices in different states
Answer:
Select the cell or range of cells you want to format.
Click Home > Format Cells dialog launcher, or press Ctrl+Shift+F.
dialog box launcher in the font group
On the Fill tab, under Background Color, pick the color you want.
A cell reference, or cell address, is an alphanumeric value used to identify a specific cell in a spreadsheet. Each cell reference contains one or more letters followed by a number. The letter or letters identify the column and the number represents