ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
1. What is the shortcut key to display the “Format Cells” dialog box in Excel?
2
a) Ctrl+1
3
b) Ctrl+2
4
c) Ctrl+3
5
d) Ctrl+4
6
Answer: a) Ctrl+1
7
Explanation: Ctrl+1 is the shortcut key to display the “Format Cells” dialog box in Excel. This dialog box allows you to change the formatting of cells, such as font, alignment, and number format.
8
2. Which of the following functions is used to find the highest value in a range of cells?
9
a) MAX
10
b) MIN
11
c) AVERAGE
12
d) COUNT
13
Answer: a) MAX
14
Explanation: The MAX function is used to find the highest value in a range of cells. For example, =MAX(A1:A10) would return the highest value in cells A1 through A10.
15
3. What is the shortcut key to create a new worksheet in Excel?
16
a) Ctrl+N
17
b) Ctrl+W
18
c) Ctrl+Shift+N
19
d) Ctrl+Alt+N
20
Answer: c) Ctrl+Shift+N
21
Explanation: Ctrl+Shift+N is the shortcut key to create a new worksheet in Excel. This creates a new tab at the bottom of the workbook with a blank worksheet.
22
4. Which of the following chart types is used to display trends over time?
23
a) Line chart
24
b) Bar chart
25
c) Pie chart
26
d) Scatter chart
27
Answer: a) Line chart
28
Explanation: A line chart is used to display trends over time. For example, you might use a line chart to show how your company’s sales have increased or decreased over the past year.
29
5. What is the shortcut key to insert a new row in Excel?
30
a) Ctrl+R
31
b) Ctrl+I
32
c) Ctrl+Shift+R
33
d) Ctrl+Alt+R
34
Answer: b) Ctrl+I
35
Explanation: Ctrl+I is the shortcut key to insert a new row in Excel. This will insert a new row above the currently selected row.
36
6. Which of the following functions is used to count the number of cells in a range that contain a specific value?
37
a) COUNTIF
38
b) SUMIF
39
c) AVERAGEIF
40
d) MAXIF
41
Answer: a) COUNTIF
42
Explanation: The COUNTIF function is used to count the number of cells in a range that contain a specific value. For example, =COUNTIF(A1:A10,”Apples”) would count the number of cells in A1 through A10 that contain the word “Apples”.
43
7. What is the shortcut key to switch between worksheets in Excel?
44
a) Ctrl+Tab
45
b) Ctrl+Page Up
46
c) Ctrl+Page Down
47
d) Alt+Tab
48
Answer: c) Ctrl+Page Down
49
Explanation: Ctrl+Page Down is the shortcut key to switch between worksheets in Excel. This will move to the next worksheet in the workbook.
50
8. Which of the following chart types is used to compare values across different categories?
51
a) Line chart
52
b) Bar chart
53
c) Pie chart
54
d) Scatter chart
55
Answer: b) Bar chart
56
Explanation: A bar chart is used to compare values across different categories. For example, you might use a bar chart to compare the sales of different products.
57
9. What is the shortcut key to format a cell as bold in Excel?
58
a) Ctrl+B
59
b) Ctrl+U
60
c) Ctrl+I
61
d) Ctrl+Shift+B
62
Answer: a) Ctrl+B
63
Explanation: Ctrl+B is the shortcut key to format a cell as bold in Excel. This will make the text in the cell bold.
64
10. Which of the following functions is used to find the average of a range of cells?
65
a) MAX
66
b) MIN
67
c) AVERAGE
68
d) COUNT
69
Answer: c) AVERAGE
70
Explanation: The AVERAGE function is used to find the average of a range of cells. For example, =AVERAGE(A1:A10) would return the average value of cells A1 through A10.
71
11. What is the shortcut key to display the “Find and Replace” dialog box in Excel?
72
a) Ctrl+F
73
b) Ctrl+H
74
c) Ctrl+R
75
d) Ctrl+Shift+F
76
Answer: b) Ctrl+H
77
Explanation: Ctrl+H is the shortcut key to display the “Find and Replace” dialog box in Excel. This dialog box allows you to search for and replace specific values in your worksheet.
78
12. Which of the following chart types is used to show the relationship between two sets of data?
79
a) Line chart
80
b) Bar chart
81
c) Pie chart
82
d) Scatter chart
83
Answer: d) Scatter chart
84
Explanation: A scatter chart is used to show the relationship between two sets of data. For example, you might use a scatter chart to show how the price of a product affects its sales.
85
13. What is the shortcut key to select all cells in a worksheet in Excel?
86
a) Ctrl+A
87
b) Ctrl+S
88
c) Ctrl+Shift+A
89
d) Ctrl+Alt+A
90
Answer: a) Ctrl+A
91
Explanation: Ctrl+A is the shortcut key to select all cells in a worksheet in Excel. This will highlight all cells in the active worksheet.
92
14. Which of the following functions is used to find the smallest value in a range of cells?
93
a) MAX
94
b) MIN
95
c) AVERAGE
96
d) COUNT
97
Answer: b) MIN
98
Explanation: The MIN function is used to find the smallest value in a range of cells. For example, =MIN(A1:A10) would return the smallest value in cells A1 through A10.
99
15. What is the shortcut key to save an Excel workbook?
100
a) Ctrl+S