USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
How can we find a cell?
|
|
with a number
|
|
|
we cannot find it
|
|
|
with a capital letter and a number
|
|
|
with a letter
|
Explanation:
Detailed explanation-1: -You can identify all cells with uppercases in a selection with following steps: 1. In a blank cell, says Cell C1, enter the formula of =EXACT(B1, UPPER(B1)), and press the Enter key. This formula will identify whether the text in Cell B1 is uppercase or not.
Detailed explanation-2: -Excel 2016 Tip: Use the formula =UPPER(A1) for all UPPERCASE; =LOWER(A1) for all lowercase.
There is 1 question to complete.