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. Which of the following is not true regarding Conditional Formatting?

2 / 50

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

3 / 50

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

4 / 50

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

5 / 50

5. You can activate a cell by

6 / 50

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

7 / 50

7. How do you delete a column?

8 / 50

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

9 / 50

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

10 / 50

10.  Hyperlinks can be

11 / 50

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

12 / 50

12. Which of the following is invalid statement?

13 / 50

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

14 / 50

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

15 / 50

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

16 / 50

16. To create a formula, you first:

17 / 50

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

18 / 50

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

19 / 50

19. How do you insert a row?

20 / 50

20. Which is used to perform what if analysis?

21 / 50

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

22 / 50

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

23 / 50

23. Comments put in cells are called

24 / 50

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

=FLOOR(14, 4)

25 / 50

25. You can use the formula palette to

26 / 50

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

27 / 50

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

28 / 50

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

29 / 50

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

30 / 50

30. A typical worksheet has …. Number of columns

31 / 50

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

32 / 50

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

33 / 50

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

34 / 50

34. Concatenation of text can be done using

35 / 50

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

36 / 50

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

37 / 50

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

38 / 50

38. You can set Page Border in Excel from

39 / 50

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

40 / 50

40. What is the total region surrounding the chart?

41 / 50

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

42 / 50

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

43 / 50

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

44 / 50

44. The name box

45 / 50

45. Text formulas:

46 / 50

46. The auto calculate feature

47 / 50

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

48 / 50

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

49 / 50

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

50 / 50

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

Your score is

0%

for more quiz click here

Leave a Reply

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