Chapter 3: Advanced Formula and Functions

 

Results

Previous
Next

#1. The Default row height is ____________

Previous
Next

#2. The default Zoom size is ________

Previous
Next

#3. Abs(-125) will return __________

Previous
Next

#4. Len(“computer”) will return ___________

Previous
Next

#5. __________ is the shortcut key for paste command.

Previous
Next

#6. The Shortcut key for Undo is ____________

Previous
Next

#7. The left end of the formula bar is called as _________

Previous
Next

#8. Text to columns present in __________ menu.

Previous
Next

#9. ___________ Number of sheets are opened when excel opens the workbook.

Previous
Next

#10. __________ and _____________ are the two types of filter.

Previous
Next

#11. ODBC is the acronym for ________________

Previous
Next

#12. __________ toolbar is used to run a macro.

Previous
Next

#13. ________ generates the serial number automatically.

Previous
Next

#14. The function power(10,2) Will return ___________

Previous
Next

#15. Merge cells option can be applied from ____________

Previous
Next

#16. We can remove borders applied in cells by ____________

Previous
Next

#17. If we press _________ the cell accepts your typing as its contents.

Previous
Next

#18. We can set page border in excel from ___________

Previous
Next

#19. We can check the conditions against __________ when applying conditional formatting.

Previous
Next

#20. Formatting a cell in number format we can’t set as _____________

Previous
Next

#21. By applying today() function, the result is __________

Previous
Next

#22. _____________ is not an option in the spelling dialog box.

Previous
Next

#23. ________ function is used to remove excess spaces within a string.

Previous
Next

#24. _______ function works by looking in the first column of a table for the value that we specify.

Previous
Next

#25. _________ function works by looking in the first row of a table for the value that we specify.

Previous
Finish