Exam শুরু করতে Start quiz -এ click করো
"The more that you read, the more things you will know, the more that you learn, the more places you’ll go.”
Microsoft Excel
Quiz-summary
0 of 50 questions completed
Questions:
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
- 11
- 12
- 13
- 14
- 15
- 16
- 17
- 18
- 19
- 20
- 21
- 22
- 23
- 24
- 25
- 26
- 27
- 28
- 29
- 30
- 31
- 32
- 33
- 34
- 35
- 36
- 37
- 38
- 39
- 40
- 41
- 42
- 43
- 44
- 45
- 46
- 47
- 48
- 49
- 50
Information
MCQ
You have already completed the quiz before. Hence you can not start it again.
Quiz is loading…
You must sign in or sign up to start the quiz.
You have to finish following quiz, to start this quiz:
Results
0 of 50 questions answered correctly
Your time:
Time has elapsed
You have reached 0 of 0 points, (0)
Average score |
|
Your score |
|
Categories
- Not categorized 0%
-
MCQ
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
- 11
- 12
- 13
- 14
- 15
- 16
- 17
- 18
- 19
- 20
- 21
- 22
- 23
- 24
- 25
- 26
- 27
- 28
- 29
- 30
- 31
- 32
- 33
- 34
- 35
- 36
- 37
- 38
- 39
- 40
- 41
- 42
- 43
- 44
- 45
- 46
- 47
- 48
- 49
- 50
- Answered
- Review
-
Question 1 of 50
1. Question
1 pointsThe basic units of a excel spreedsheet where we enter data is called?
Correct
Incorrect
-
Question 2 of 50
2. Question
1 pointsThe maximum number of rows supported by Excel 2007 spreadsheet is?
Correct
Incorrect
-
Question 3 of 50
3. Question
1 pointsThe maximum number of columns supported by Excel 2007 spreadsheet is?
Correct
Incorrect
-
Question 4 of 50
4. Question
1 pointsA features that displays only the data in column (s) according to specified criteria
Correct
Incorrect
-
Question 5 of 50
5. Question
1 pointsIn Excel, Rows are labelled as ______
Correct
Incorrect
-
Question 6 of 50
6. Question
1 pointsHow will you graphically represent expenditure in different departments ?
Correct
Incorrect
-
Question 7 of 50
7. Question
1 pointsWhat type of chart is good for single series of data ?
Correct
Incorrect
-
Question 8 of 50
8. Question
1 pointsThe basic unit of a worksheet into which you enter data in Excel is called a
Correct
Incorrect
-
Question 9 of 50
9. Question
1 pointsWhat is the intersection of a column and a row on a worksheet called ?
Correct
Incorrect
-
Question 10 of 50
10. Question
1 pointsWhat type of chart is useful for comparing values over categories ?
Correct
Incorrect
-
Question 11 of 50
11. Question
1 pointsWhich function in Excel tells how many numeric entries are there ?
Correct
Incorrect
-
Question 12 of 50
12. Question
1 pointsA features that displays only the data in column (s) according to specified criteria
Correct
Incorrect
-
Question 13 of 50
13. Question
1 pointsIn Excel, which one denoted a range from B1 through E5
Correct
Incorrect
-
Question 14 of 50
14. Question
1 pointswhat is the extension of excel file?
Correct
Incorrect
-
Question 15 of 50
15. Question
1 pointsAn Excel file is generally called a / an :
Correct
Incorrect
-
Question 16 of 50
16. Question
1 pointsIt is a collection of data that is stored electronically as a series of records in a table.
Correct
Incorrect
-
Question 17 of 50
17. Question
1 pointsWhat is the symbol for multiplying?
Correct
Incorrect
-
Question 18 of 50
18. Question
1 pointsWhich is an example of a function?
Correct
Incorrect
-
Question 19 of 50
19. Question
1 pointsWhich is an example of a formula?
Correct
Incorrect
-
Question 20 of 50
20. Question
1 pointsHow do you tell one cell from another?
Correct
Incorrect
-
Question 21 of 50
21. Question
1 pointsYou accidentally erased a record in the sheet. What command can be used to restore it immediately?
Correct
Incorrect
-
Question 22 of 50
22. Question
1 pointsWhich menu option can be used to split windows into two?
Correct
Incorrect
-
Question 23 of 50
23. Question
1 pointsConcatenation of text can be done using
Correct
Incorrect
-
Question 24 of 50
24. Question
1 points“Data Table” option is found under ___________
Correct
Incorrect
-
Question 25 of 50
25. Question
1 pointsThe first cell in EXCEL worksheet is labeled as
Correct
Incorrect
-
Question 26 of 50
26. Question
1 pointsWhich function is used to calculate depreciation, rates of return, future values and loan payment amounts?
Correct
Incorrect
-
Question 27 of 50
27. Question
1 pointsThe active cell:
Correct
Incorrect
-
Question 28 of 50
28. Question
1 pointsIn Excel, a Data Series is defined as what?
Correct
Incorrect
-
Question 29 of 50
29. Question
1 pointsFormulas in Excel start with
Correct
Incorrect
-
Question 30 of 50
30. Question
1 pointsThe cell reference for cell range of N7 to R7 is _______
Correct
Incorrect
-
Question 31 of 50
31. Question
1 pointsWhat is the keyboard shortcut for creating a chart from the selected cell range?
Correct
Incorrect
-
Question 32 of 50
32. Question
1 pointsA function inside another function is called _______
Correct
Incorrect
-
Question 33 of 50
33. Question
1 pointsWhich of the following format you can decide to apply or not in Auto Format dialog box?
Correct
Incorrect
-
Question 34 of 50
34. Question
1 pointsHow can you remove borders applied in cells?
Correct
Incorrect
-
Question 35 of 50
35. Question
1 pointsWhen all the numbers between 0 and 100 in a range should be displayed in Red Color, apply
Correct
Incorrect
-
Question 36 of 50
36. Question
1 pointsExcel uniquely identifies cells within a worksheet with a cell name
Correct
Incorrect
-
Question 37 of 50
37. Question
1 pointsGetting data from a cell located in a different sheet is called …
Correct
Incorrect
-
Question 38 of 50
38. Question
1 pointsMS-EXCEL can be used to automate
Correct
Incorrect
-
Question 39 of 50
39. Question
1 pointsIn order to arrange the countries from those with the highest population to those with the lowest, you need to sort on the population field in ……………
Correct
Incorrect
-
Question 40 of 50
40. Question
1 pointsIn order to perform a calculation in a spreadsheet, you need to use a:
Correct
Incorrect
-
Question 41 of 50
41. Question
1 pointsWhere a row and a column meet, what do you call that?
Correct
Incorrect
-
Question 42 of 50
42. Question
1 pointsGive me an example of a cell address.
Correct
Incorrect
-
Question 43 of 50
43. Question
1 pointsIn MS-Excel what does SUMIF function do?
Correct
Incorrect
-
Question 44 of 50
44. Question
1 pointsIn MS-Excel which of the following is an absolute cell reference?
Correct
Incorrect
-
Question 45 of 50
45. Question
1 pointsMS-Excel uses the _______ Function when creating a data table
Correct
Incorrect
-
Question 46 of 50
46. Question
1 pointsThe Software which contains rows and columns is called ______
Correct
Incorrect
-
Question 47 of 50
47. Question
1 pointsYou can activate a cell by
Correct
Incorrect
-
Question 48 of 50
48. Question
1 pointsWhich keys are used to Open tab in Ms Excel?
Correct
Incorrect
-
Question 49 of 50
49. Question
1 pointsWhich key is used to “Goto” tab in Ms Excel?
Correct
Incorrect
-
Question 50 of 50
50. Question
1 pointsWhich key is used to edit in Ms Excel?
Correct
Incorrect