MS Excel Mcqs Online Test

1. Except for the …… function, a formula with a logical function shows the word “TRUE” or “FALSE” as a result?

 2. How are data organized in a spreadsheet?


 3. Which of the following methods can not be used to edit the contents of a cell?


 4. All worksheet formula?


 5. Macros are “run” or executed from the ….. menu?


6. When you insert an Excel file into a Word document, the data are?

 7. You can open the consolidate dialog box by choosing Consolidate from the ….. menu?


 8. You can edit a cell by?


 9. What function  displays row data in a column or column data in a row?


 10. Which types of charts can excel produce?


 11. If you begin typing an entry into a cell and then realize that you don’t want your entry placed into a cell, you?


 12. What does the VLOOKUP function do?


 13. Without using the mouse or the arrow keys, what is the fastest way of getting to cell A1 in a spreadsheet?


 14. Excel worksheet cells work very similarly to what common element of the windows graphical user interface?


 15. To view a cell comment?


 16. Which of the following is a correct order of precedence in formula calculation?


17. The numbers in our worksheet look like this: You want them to look like this: $1,000.How can you accomplish this?

 18. Which of the following options is not located in the Page Setup dialog box?


 19. Which of the following is not a valid data type in excel?


20. Gridlines?


21. When you want to insert a blank imbedded excel object in a word document you can?

 22. Each excel file is called a workbook because?


 23. You want to track the progress of the stock market on a daily basis. Which type of chart should you use?


 24. The Paste Special command lets you copy and paste?


 25. To save a workbook, you?

(Visited 117 times, 1 visits today)



Leave a Reply