33 : MS office - Excel

Home >> Computer Awareness
1234567891011121314151617181920
1).
Which menu option in MS Excel has the option to sort the data?
2).
How can a cell be activated in MS Excel?
3).
Which is the correct formula for SUM function in MS Excel
4).
What is the use of VLOOKUP function in MS Excel?
5).
Which button in MS Excel is clicked to calculate the sum of a series of numbers?
6).
What is the default file extension of MS Excel files?
7).
What do we call a function inside a function?
8).
Which of these tools is available in MS Excel?
9).
Which of the key combination is used to move to the bottom of the column in MS Excel?
10).
Which of the key combination is used to hide a selected row?
11).
What is the use of 'Ctrl + ;' key combination in MS Excel?
12).
How to insert current time in a cell in MS Excel?
13).
How can entire column be selected in MS Excel?
14).
Where is the Insert function button located in MS Excel?
15).
What is the shortcut to insert a comment in MS Excel?
16).
What does Autofill feature of MX Excel do?
17).
Which function in MS Excel counts the number of characters in a cell?
18).
What is the use of Shift + F11 in MS Excel?
19).
Which function in MS Excel will be used to convert miles into Kilometres?
20).
Which of these is a shortcut to add a border to the selected cell in MS Excel?
1. Which menu option in MS Excel has the option to sort the data?
[A] Review
[B] Data
[C] Insert
[D] Formulas
2. How can a cell be activated in MS Excel?
[A] By pressing TAB key
[B] By pressing arrow keys
[C] By clicking the cell
[D] All of the above
3. Which is the correct formula for SUM function in MS Excel
[A] /SUM (A1+A5)
[B] =SUM (A1 – A5)
[C] =SUM (A1:A5)
[D] +SUM (A1:A5)
4. What is the use of VLOOKUP function in MS Excel?
[A] to get the maximum value among set of data
[B] to copy a row
[C] to find things in a table
[D] None of the above
5. Which button in MS Excel is clicked to calculate the sum of a series of numbers?
[A] Autosum
[B] Fill
[C] Merge
[D] Insert
6. What is the default file extension of MS Excel files?
[A] .acs
[B] .exc
[C] .exe
[D] .xls
7. What do we call a function inside a function?
[A] Double function
[B] Nested function
[C] Switch function
[D] Loop function
8. Which of these tools is available in MS Excel?
[A] Spelling
[B] Thesaurus
[C] Research
[D] All of the above
9. Which of the key combination is used to move to the bottom of the column in MS Excel?
[A] Ctrl + D
[B] Ctrl + U
[C] Ctrl + Down Arrow
[D] Ctrl + End
10. Which of the key combination is used to hide a selected row?
[A] Ctrl + 8
[B] Ctrl + 9
[C] Ctrl +10
[D] Ctrl + H
Advertisement

Kindly help us to keep GKToday updated and error free. Use this form to report error or outdated information in questions. We shall rectify asap...