Microsoft Excel Quiz for NEA

Microsoft Excel Quiz for NEA

Quiz

Microsoft Excel Quiz for NEA (Nepal Electricity Authority)

0 votes, 0 avg
11
Created on By gyanchautari

Microsoft Excel Quiz for NEA

Welcome to Nepal Electricity Authority (NEA) Excel Quiz

1 / 50

1. A worksheet can have a maximum of …. Number of rows

2 / 50

2. You can use the formula palette to

3 / 50

3. Concatenation of text can be done using

4 / 50

4. Which of the following is not an example of a value?

5 / 50

5. Which shortcut key is used to copy the selected cells in MS Excel ?

6 / 50

6. What is the value of the following MS-Excel function?

=FLOOR(14, 4)

7 / 50

7. Which tool helps better for what if analysis in MS Excel ?

8 / 50

8. What are the basic rectangular building blocks of a spreadsheet?

9 / 50

9. You can set Page Border in Excel from

10 / 50

10.  Hyperlinks can be

11 / 50

11. Which is used to perform what if analysis?

12 / 50

12. How can you print three copies of a workbook?

13 / 50

13. How can you find specific information in a list?

14 / 50

14. To create a formula, you first:

15 / 50

15. ......... appear at the bottom of the Excel window.

16 / 50

16. Which of the following is not true regarding Conditional Formatting?

17 / 50

17. You can activate a cell by

18 / 50

18. Where can you set the shading color for a range of cells in Excel?

19 / 50

19. Text formulas:

20 / 50

20. The auto calculate feature

21 / 50

21. Which of the following formulas will Excel Not be able to calculate?

22 / 50

22. Multiple calculations can be made in a single formula using

23 / 50

23. Which of the following is invalid statement?

24 / 50

24. When a label is too long to fit within a worksheet cell, you typically must

25 / 50

25. Which of the following is not a basic step in creating a worksheet?

26 / 50

26. What is the total region surrounding the chart?

27 / 50

27. How do you delete a column?

28 / 50

28. Excel is a program that is used to prepare a

29 / 50

29. When all the numbers between 0 and 100 in a range should be displayed in Red Color, apply

30 / 50

30. To center worksheet titles across a range of cells, you must

31 / 50

31. Which button do you click to add up a series of numbers?

32 / 50

32. Data can be arranged in a worksheet in a easy to understand manner using

33 / 50

33. A typical worksheet has …. Number of columns

34 / 50

34. A(n) ____ is a series of two or more adjacent cells in a column or row or rectangular group of cells.

35 / 50

35. The name box

36 / 50

36. You can check the conditions against __________ when applying conditional formatting

37 / 50

37. Comments put in cells are called

38 / 50

38. What happens when you select a cell in MS Excel and type  "=B25" ?

39 / 50

39. Which of the following formulas is not entered correctly?

40 / 50

40. Which of the following is used to move an active cell to the first column on the current row?

41 / 50

41. What is the address of the cell in the seventh column of the sixth row in an MS-Excel worksheet?

42 / 50

42. What is the extension of saved file in MS Excel?

43 / 50

43. Excel uniquely identifies cells within a worksheet with a cell name

44 / 50

44. Getting data from a cell located in a different sheet is called …

45 / 50

45. Which of the following identifies a cell in Excel?

46 / 50

46.  To activate the previous cell in a pre-selected range, press

47 / 50

47. When a range is selected, how can you activate the previous cell?

48 / 50

48. How do you insert a row?

49 / 50

49. Which command is used to close the window of Excel?

50 / 50

50. In which tab wrap text feature is present in MS Excel 2007?

Your score is

0%

for more quiz click here

Leave a Reply

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