Home Microsoft Excel Test Preparation Online Mcqs

Microsoft Excel Test Preparation Online Mcqs

Microsoft Excel Test Preparation Online Mcqs With Answer Start Below

Uncategorized

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

 

Question 1 of 25

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

 

Question 2 of 25

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

Question 3 of 25

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

Question 4 of 25

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

 

Question 5 of 25

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

Question 6 of 25

7. Each excel file is called a workbook because?

Question 7 of 25

8. Which types of charts can excel produce?

Question 8 of 25

9. What does the VLOOKUP function do?

Question 9 of 25

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

Question 10 of 25

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

Question 11 of 25

12. All worksheet formula?

Question 12 of 25

13. You can edit a cell by?

 

Question 13 of 25

14. To save a workbook, you?

 

Question 14 of 25

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

Question 15 of 25

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

Question 16 of 25

17. To view a cell comment?

 

Question 17 of 25

18. How are data organized in a spreadsheet?

Question 18 of 25

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

 

Question 19 of 25

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

Question 20 of 25

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

 

Question 21 of 25

22. Gridlines?

Question 22 of 25

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

Question 23 of 25

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

 

Question 24 of 25

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

Question 25 of 25


 

Related Study Posts:

Leave a Reply

Your email address will not be published. Required fields are marked *

error: Content is protected !!