image Guest

You need to login to ask any Questions from chapter Ms-Office of Basic-Computer

Chapter:

Ms-Office

Match following MS Excel formula:

Excel Function/Operation Output
a. =LEFT("Microsoft Excel", 6) i) 26
b. =LOWER("HELLO WORLD") ii) 123.46
c. =SUM(10, 5, 11) iii) hello world
d. =AVERAGE(100, 120, 150) iv) Micros


Hint Answer

Previous Question
Next Question

All Chapters

View all Chapter and number of question available From each chapter from Basic-Computer

Similar Question

This Chapter Ms-Office consists of the following topics

In MS-Word, which of the following keyboard shortcuts is used to select text and graphics from the current position to the top of the screen?</p>

Match following MS Excel formula:

Excel Function/Operation Output
a. =LEFT("Microsoft Excel", 6) i) 26
b. =LOWER("HELLO WORLD") ii) 123.46
c. =SUM(10, 5, 11) iii) hello world
d. =AVERAGE(100, 120, 150) iv) Micros

</p><p>Match the following:</p> <table border="1" cellpadding="1" cellspacing="1" style="width: 300px;"> <thead> <tr> <th scope="col" style="text-align: center;"><span style="font-weight: 400;">&nbsp; &nbsp;<span style="font-weight: bolder;">&nbsp;MS Office 365 Option Icon</span></span></th> <th scope="col" style="text-align: center;">&nbsp; &nbsp; &nbsp; &nbsp;Meaning&nbsp; &nbsp; &nbsp; &nbsp;</th> </tr> </thead> <tbody> <tr> <td style="text-align: center;">A.&nbsp;<img alt="Screenshot 2024-07-09 145749" src="./img-uploads/Screenshot 2024-07-09 145749.png" style="width: 38px; height: 37px;"></td> <td style="text-align: center;">I. Comment</td> </tr> <tr> <td style="text-align: center;">B.&nbsp;<img alt="Screenshot 2024-07-09 145838" src="./img-uploads/Screenshot 2024-07-09 145838.png" style="width: 46px; height: 38px;"></td> <td style="text-align: center;">II. Page Break</td> </tr> <tr> <td style="text-align: center;">C.&nbsp;<img alt="Screenshot 2024-07-09 145900" src="./img-uploads/Screenshot 2024-07-09 145900.png" style="width: 42px; height: 39px;"></td> <td style="text-align: center;">III. Shapes</td> </tr> <tr> <td style="text-align: center;">D.&nbsp;<img alt="Screenshot 2024-07-09 150015" src="./img-uploads/Screenshot 2024-07-09 150015.png" style="width: 55px; height: 38px;"></td> <td style="text-align: center;">IV. Drop Cap</td> </tr> </tbody> </table> <p></p>

</p><p>Match the following MS Excel formula:</p> <table border="1" cellpadding="1" cellspacing="1" style="width:500px;"> <tbody> <tr> <td>Excel Function/Operation</td> <td>Output</td> </tr> <tr> <td>a. =LEFT("Microsoft Excel"

6)</td> <td>i) 26</td> </tr> <tr> <td>b. =LOWER("HELLO WORLD")</td> <td>ii) 123.46</td> </tr> <tr> <td>c. =SUM(10

5

11)</td> <td>iii) hello world</td> </tr> <tr> <td>d. =AVERAGE(100

120

150)</td> <td>iv) Micros</td> </tr> </tbody> </table> <p></p>

Ms Office

Basic-Computer