MS Excel Quiz-3
1 / 48
What type of chart is good for single series of data ?
2 / 48
Workbook is a collection of
3 / 48
Which of the following Excel charts represents only one value for each variable?
4 / 48
Which of the following is not true regarding Conditional Formatting?
5 / 48
You can check the conditions against __________ when applying conditional formatting
6 / 48
You can set Page Border in Excel from
7 / 48
What is the pictorial representation of worksheet data?
8 / 48
Which functionin Excel tells how many numeric entries are there ?
9 / 48
Which command is used to close the window of Excel?
10 / 48
Which term is used to join the selected cells in to one cell?
11 / 48
When you enter text in a cell in Excel. It also appears in the
12 / 48
When the CPU detects an interrupt, then it saves its
13 / 48
What is the intersection of a column and a row on a worksheet called ?
14 / 48
Which of the following function used to adds the values in the function argument or the values in the all references in the argument?
15 / 48
Which of the following is not a term pertaining to spreadsheets?
16 / 48
Which of the following term is related with legends?
17 / 48
What is the total region surrounding the chart?
18 / 48
Which function displays row data in a column or column data in a row?
19 / 48
Which functionin Excel checks whether a condition is true or not ?
20 / 48
Which function will you use to enter current time in a worksheet cell?
21 / 48
Which one is not a Function in MS Excel ?
22 / 48
Which sign indicate to multiplication?
23 / 48
When a chart is placed on this, it is much larger and there is no other data on it.
24 / 48
Which of the following characteristics is used to compute dynamically the results from Excel data?
25 / 48
When we can create a chart on a separate sheet in the same workbook, it is called a
26 / 48
Which Excel feature enables predefined layouts to selected tables in the worksheet?
27 / 48
Which of the following identifies a cell in Excel?
28 / 48
Which of the following is the purpose of AutoSum?
29 / 48
While selecting multiple worksheets in Excel, the following key must also be used when clicking the sheet tab.
30 / 48
What type of chart will you use to compare performance of two employees in the year 2016 ?
31 / 48
What type of chart is useful for comparing values over categories ?
32 / 48
You can automatically adjust the size of text in a cell if they do not fit in width by
33 / 48
What type of chart is useful for comparing parts of a whole ?
34 / 48
What refers to the horizontal cells which can contain information?
35 / 48
Which sign is used for absolute addressing?
36 / 48
Which of the following is not a valid Zoom percentage in Excel?
37 / 48
When all the numbers between 0 and 100 in a range should be displayed in Red Color, apply
38 / 48
Which bar show the used formula of selected active cell?
39 / 48
Which of the following format you can decide to apply or not in AutoFormat dialog box?
40 / 48
Which one of the following software applications would be the most appropriate for performing numerical and statistical calculations?
41 / 48
What type of chart will you use to compare performance of sales of two products ?
42 / 48
Which of the following is an active cell in excel?
43 / 48
Which of the following is the default numbers of worksheet in MS Excel?
44 / 48
Which of the following is the comparison operator?
45 / 48
You can undo and redo up to ____ action in Microsoft Office Excel, even after a worksheet is saved.
46 / 48
Which of the following is invalid statement?
47 / 48
Where can you set the shedding color for a range of cells in Excel?
48 / 48
What type of chart is useful for showing trends or changes over time ?
Provide Your Information
Your score is
The average score is 47%
Restart quiz
