Home » Agriculture Quiz » MS Excel Quiz-3

MS Excel Quiz-3

0%
1

MS Excel Quiz-3

1 / 48

You can set Page Border in Excel from

2 / 48

Workbook is a collection of

3 / 48

When you enter text in a cell in Excel. It also appears in the

4 / 48

Which functionin Excel checks whether a condition is true or not ?

5 / 48

What type of chart is useful for comparing parts of a whole ?

6 / 48

What type of chart is good for single series of data ?

7 / 48

What type of chart is useful for showing trends or changes over time ?

8 / 48

Which of the following is not a term pertaining to spreadsheets?

9 / 48

Which of the following is the default numbers of worksheet in MS Excel?

10 / 48

You can automatically adjust the size of text in a cell if they do not fit in width by

11 / 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?

12 / 48

What refers to the horizontal cells which can contain information?

13 / 48

When the CPU detects an interrupt, then it saves its

14 / 48

Which of the following is the purpose of AutoSum?

15 / 48

Which functionin Excel tells how many numeric entries are there ?

16 / 48

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

17 / 48

Which term is used to join the selected cells in to one cell?

18 / 48

You can undo and redo up to ____ action in Microsoft Office Excel, even after a worksheet is saved.

19 / 48

Which of the following is the comparison operator?

20 / 48

Which of the following format you can decide to apply or not in AutoFormat dialog box?

21 / 48

Which of the following term is related with legends?

22 / 48

When a chart is placed on this, it is much larger and there is no other data on it.

23 / 48

Which sign indicate to multiplication?

24 / 48

What is the total region surrounding the chart?

25 / 48

What is the intersection of a column and a row on a worksheet called ?

26 / 48

Which function displays row data in a column or column data in a row?

27 / 48

Which of the following characteristics is used to compute dynamically the results from Excel data?

28 / 48

Which function will you use to enter current time in a worksheet cell?

29 / 48

What type of chart will you use to compare performance of two employees in the year 2016 ?

30 / 48

Which sign is used for absolute addressing?

31 / 48

Which of the following is an active cell in excel?

32 / 48

What is the pictorial representation of worksheet data?

33 / 48

Which one is not a Function in MS Excel ?

34 / 48

Which of the following is not a valid Zoom percentage in Excel?

35 / 48

Which of the following is invalid statement?

36 / 48

What type of chart is useful for comparing values over categories ?

37 / 48

Which command is used to close the window of Excel?

38 / 48

You can check the conditions against __________ when applying conditional formatting

39 / 48

While selecting multiple worksheets in Excel, the following key must also be used when clicking the sheet tab.

40 / 48

Which of the following Excel charts represents only one value for each variable?

41 / 48

When we can create a chart on a separate sheet in the same workbook, it is called a

42 / 48

Which Excel feature enables predefined layouts to selected tables in the worksheet?

43 / 48

Which bar show the used formula of selected active cell?

44 / 48

Which one of the following software applications would be the most appropriate for performing numerical and statistical calculations?

45 / 48

Where can you set the shedding color for a range of cells in Excel?

46 / 48

Which of the following is not true regarding Conditional Formatting?

47 / 48

Which of the following identifies a cell in Excel?

48 / 48

What type of chart will you use to compare performance of sales of two products ?

Provide Your Information

Your score is

The average score is 47%

0%

Share on facebook
Facebook
Share on twitter
Twitter
Share on whatsapp
WhatsApp
MS Office Quiz-1
MS Office Quiz-2
MS Office Quiz-3
MS Office Quiz-4
MS Office Quiz-5
MS Excel Quiz-1
MS Excel Quiz-2
MS Powerpoint Quiz-1
MS Powerpoint Quiz-2
MS Powerpoint Quiz-3

Help Concept 360 Please. We need 500 Youtube Subscriber. Please Subscribe our Youtube Channel. Click below link to subscribe Please

آپ سے گزارش ہے کہ ہمارے یوٹیوب چینل کوسبسکرائب کر کے ہماری مدد کریں جیسا کہ یہ ویب سائٹ آپکی مدد کر رہی ہے۔ شکریہ