MS Excel Quiz-3

0%
1

MS Excel Quiz-3

1 / 48

Which of the following is the comparison operator?

2 / 48

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

3 / 48

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

4 / 48

What refers to the horizontal cells which can contain information?

5 / 48

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

6 / 48

What is the pictorial representation of worksheet data?

7 / 48

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

8 / 48

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

9 / 48

You can check the conditions against __________ when applying conditional formatting

10 / 48

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

11 / 48

Which of the following is an active cell in excel?

12 / 48

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

13 / 48

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

14 / 48

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

15 / 48

What is the total region surrounding the chart?

16 / 48

Which of the following term is related with legends?

17 / 48

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

18 / 48

Workbook is a collection of

19 / 48

Which of the following identifies a cell in Excel?

20 / 48

Which functionin Excel tells how many numeric entries are there ?

21 / 48

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

22 / 48

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

23 / 48

Which bar show the used formula of selected active cell?

24 / 48

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

25 / 48

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

26 / 48

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

27 / 48

Which of the following is invalid statement?

28 / 48

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

29 / 48

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

30 / 48

Which command is used to close the window of Excel?

31 / 48

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

32 / 48

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

33 / 48

Which of the following is the purpose of AutoSum?

34 / 48

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

35 / 48

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

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

37 / 48

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

38 / 48

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

39 / 48

You can set Page Border in Excel from

40 / 48

When the CPU detects an interrupt, then it saves its

41 / 48

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

42 / 48

Which one is not a Function in MS Excel ?

43 / 48

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

44 / 48

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

45 / 48

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

46 / 48

Which sign indicate to multiplication?

47 / 48

Which sign is used for absolute addressing?

48 / 48

Which of the following is not true regarding Conditional Formatting?

Provide Your Information

Your score is

The average score is 47%

0%

Qunoot e Nazilah
Dua e Hajat
4 Qul
6 Kalma
Dua-e-Akasha
Darood Akbar
Surah Fatiha
Dua-e-Ganj Ul Arsh
Dua-e-Jamilah
Ayat-ul-Kursi