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.  Hyperlinks can be

2 / 50

2. How do you insert a row?

3 / 50

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

4 / 50

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

5 / 50

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

6 / 50

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

7 / 50

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

8 / 50

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

9 / 50

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

10 / 50

10. Concatenation of text can be done using

11 / 50

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

12 / 50

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

13 / 50

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

14 / 50

14. Text formulas:

15 / 50

15. The auto calculate feature

16 / 50

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

17 / 50

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

18 / 50

18. You can set Page Border in Excel from

19 / 50

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

20 / 50

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

21 / 50

21. The name box

22 / 50

22. You can use the formula palette to

23 / 50

23. What is the total region surrounding the chart?

24 / 50

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

25 / 50

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

26 / 50

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

27 / 50

27. Which is used to perform what if analysis?

28 / 50

28. Which of the following is invalid statement?

29 / 50

29. To create a formula, you first:

30 / 50

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

31 / 50

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

32 / 50

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

33 / 50

33. How do you delete a column?

34 / 50

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

35 / 50

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

36 / 50

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

37 / 50

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

38 / 50

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

39 / 50

39. You can activate a cell by

40 / 50

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

=FLOOR(14, 4)

41 / 50

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

42 / 50

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

43 / 50

43. A typical worksheet has …. Number of columns

44 / 50

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

45 / 50

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

46 / 50

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

47 / 50

47. Comments put in cells are called

48 / 50

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

49 / 50

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

50 / 50

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

Your score is

0%

for more quiz click here

Leave a Reply

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