Microsoft Excel KNOWLEDGE LEVEL ASSESSMENT
Microsoft Excel Knowledge Test
Quiz-summary
0 of 60 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
- 51
- 52
- 53
- 54
- 55
- 56
- 57
- 58
- 59
- 60
Information
Hi, this test helps us evaluate your understanding of the subject.
You must specify a text. |
|
You must specify a text. |
|
You must specify a number. |
|
You must specify a number. |
|
You must specify a text. |
|
You must specify an email address. |
|
You must specify a text. |
|
You must specify a text. |
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 60 questions answered correctly
Your time:
Time has elapsed
You have reached 0 of 0 points, (0)
Categories
- Advanced 0%
- Beginner 0%
- Intermediate 0%
- 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
- 51
- 52
- 53
- 54
- 55
- 56
- 57
- 58
- 59
- 60
- Answered
- Review
-
Question 1 of 60
1. Question
1 pointsThe default font in a new work book is
Correct
Incorrect
-
Question 2 of 60
2. Question
1 pointsLabels are aligned at the ________ edge of the cell.
Correct
Incorrect
-
Question 3 of 60
3. Question
1 pointsTrue or False. A range has an address called an range address.
Correct
Incorrect
-
Question 4 of 60
4. Question
1 pointsAn example of a range address.
Correct
Incorrect
-
Question 5 of 60
5. Question
1 pointsHow do you know a range is active?
Correct
Incorrect
-
Question 6 of 60
6. Question
1 pointsWhen you start to select a range of cells, you will see a thick white, cross shaped pointer called a ________________.
Correct
Incorrect
-
Question 7 of 60
7. Question
1 pointsYou can complete a cell entry by pressing: (Choose all that apply)
Correct
Incorrect
-
Question 8 of 60
8. Question
1 points###### means:
Correct
Incorrect
-
Question 9 of 60
9. Question
1 pointsA fast way to add up this column of numbers is to click in the cell below the numbers and then:
Correct
Incorrect
-
Question 10 of 60
10. Question
1 pointsTrue or False. If you choose a larger font size, the height of the row is automatically made taller.
Correct
Incorrect
-
Question 11 of 60
11. Question
1 pointsA_______ is a group of cells that form a retangle on the screen.
Correct
Incorrect
-
Question 12 of 60
12. Question
1 pointsWhich button allows you to copy cell formats from one cell to another?
Correct
Incorrect
-
Question 13 of 60
13. Question
1 pointsWhich key do you press to check spelling?
Correct
Incorrect
-
Question 14 of 60
14. Question
1 pointsWhat do you call the chart that shows the proportions of how one or more data elements relate to another data element?
Correct
Incorrect
-
Question 15 of 60
15. Question
1 pointsWhich would you choose to create a bar diagram?
Correct
Incorrect
-
Question 16 of 60
16. Question
1 pointsWhich setting you must modify to print a worksheet using letterhead?
Correct
Incorrect
-
Question 17 of 60
17. Question
1 pointsWe can save and protect the workbook by
Correct
Incorrect
-
Question 18 of 60
18. Question
1 pointsHow many worksheets can a workbook have?
Correct
Incorrect
-
Question 19 of 60
19. Question
1 pointsYou can display all the formulas in an active worksheet by pressing the ______ key.
Correct
Incorrect
-
Question 20 of 60
20. Question
1 pointsThe view that puts a blue line around each page that would be printed is the _____.
Correct
Incorrect
-
Question 21 of 60
21. Question
1 points_____________ is the horizontal part of the spreadsheet.
Correct
Incorrect
-
Question 22 of 60
22. Question
1 pointsAn easy way to sort data when there is only one sort field is to use the Sort A to Z or Sort Z to A buttons.
Correct
Incorrect
-
Question 23 of 60
23. Question
1 pointsCell A5 shows a figure of 645123.875. Which of the following functions will display to the number is thousand?
Correct
Incorrect
-
Question 24 of 60
24. Question
1 pointsWhich mathematical operation is performed by the ^ key in an Excel formula?
Correct
Incorrect
-
Question 25 of 60
25. Question
1 pointsWhen a formula is written in a cell. It appears in the the active cell in which it is being written and in the __________________ bar as well.
Correct
Incorrect
-
Question 26 of 60
26. Question
1 pointsWhat is the correct forumla to calculate an average between cells B3 and B6?
Correct
Incorrect
-
Question 27 of 60
27. Question
1 pointsTo name a cell or range, you use the _______________
Correct
Incorrect
-
Question 28 of 60
28. Question
1 pointsWhen using a databar, changing the value of one cell in the range will not affect the barsize of all the other cells.
Correct
Incorrect
-
Question 29 of 60
29. Question
1 pointsThe divide symbol is
Correct
Incorrect
-
Question 30 of 60
30. Question
1 pointsA Logical test in Excel can contain =, >=, <=, >,<, <>, $
Correct
Incorrect
-
Question 31 of 60
31. Question
1 pointsA function inside another function is called a _____________ function.
Correct
Incorrect
-
Question 32 of 60
32. Question
1 pointsThe simplest and most convenient way to add a record to a table is to enter the data in the first blank row.
Correct
Incorrect
-
Question 33 of 60
33. Question
1 points=Sheet1!D9+Sheet1!E9
Correct
Incorrect
-
Question 34 of 60
34. Question
1 pointsIf you have data that runs across five columns, from column A to column E, one way to center a title across the top of the data would be to:
Correct
Incorrect
-
Question 35 of 60
35. Question
1 pointsA Function is?
Correct
Incorrect
-
Question 36 of 60
36. Question
1 pointsIf you press _____, the cell accepts your typing as its contents but the focus stays in the same cell.
Correct
Incorrect
-
Question 37 of 60
37. Question
1 pointsA worksheet is..
Correct
Incorrect
-
Question 38 of 60
38. Question
1 pointsWhich feature can be used to keep user desired rows or columns visible at all times when scrolling around the sheet?
Correct
Incorrect
-
Question 39 of 60
39. Question
1 pointsWhen creating an Excel formula, what does the cell reference with dollar signs like $A$1 do?
Correct
Incorrect
-
Question 40 of 60
40. Question
1 pointsGraphics objects on a chart are used to
Correct
Incorrect
-
Question 41 of 60
41. Question
1 pointsA user wishes to remove a worksheet from a workbook. Which is the correct sequence of events that will do this?
Correct
Incorrect
-
Question 42 of 60
42. Question
1 points__________________ is the vertical part of the spreadsheet.
Correct
Incorrect
-
Question 43 of 60
43. Question
1 pointsWhat function offers you the possibility to view different results depending on the entered condition?
Correct
Incorrect
-
Question 44 of 60
44. Question
1 pointsPie charts are most effective with ___________ or fewer slices.
Correct
Incorrect
-
Question 45 of 60
45. Question
1 pointsThe cell reference for a range of cells that starts in cell B1 and goes over to column G and down to row 10 is _____.
Correct
Incorrect
-
Question 46 of 60
46. Question
1 pointsWhich formula can add the all numeric values in a range of cells, ignoring those which are not numeric, and place the result in a different cell?
Correct
Incorrect
-
Question 47 of 60
47. Question
1 pointsWhat is the function of the autofit ?
Correct
Incorrect
-
Question 48 of 60
48. Question
1 pointsYou can print
Correct
Incorrect
-
Question 49 of 60
49. Question
1 pointsMicrosoft Excel is a ___________________?
Correct
Incorrect
-
Question 50 of 60
50. Question
1 pointsThe cell labeled F5 refers to
Correct
Incorrect
-
Question 51 of 60
51. Question
1 pointsWhat function would you use to display today’s date so that tomorrow it will updates automatically
Correct
Incorrect
-
Question 52 of 60
52. Question
1 pointsTo add two cells (A1 and A2) together you use the following formula
Correct
Incorrect
-
Question 53 of 60
53. Question
1 pointsThe most efficient way to format several cells with a specific font, number format, alignment, font color would be to:
Correct
Incorrect
-
Question 54 of 60
54. Question
1 pointsWhat is a Workbook?
Correct
Incorrect
-
Question 55 of 60
55. Question
1 pointsWhat does the LEN() function do?
Correct
Incorrect
-
Question 56 of 60
56. Question
1 pointsWhat would be the effect of the formula shown below in an Excel spreadsheet assuming cells A1 & A2 contain numbers?
=A1^A2Correct
Incorrect
-
Question 57 of 60
57. Question
1 pointsWhich is the part of the Excel screen where you can find all the commands or buttons, depending on the tab you selected before?
Correct
Incorrect
-
Question 58 of 60
58. Question
1 pointsWhat does SUMIFS function do?
Correct
Incorrect
-
Question 59 of 60
59. Question
1 pointsYou use ______ filters to find all objects with a value greater than X or acquired after a certain date
Correct
Incorrect
-
Question 60 of 60
60. Question
1 pointsYou can select the current Row by pressing
Correct
Incorrect