`All Computer Quiz`

Fundamental Quiz

Ms Word Quiz

Excel Quiz

Ready

Thanks

Excel Quiz

Excel quiz helps us to increase our knowledge

1 / 88

32. Let A1 cell store date ‘14-09-2022’, that is a Wednesday. Which of the following formulas of B1 cell will display ‘Wed’?

A. =TEXT(A1,"dddd")

B. =Day(A1,"dddd")

C. =TEXT(A1,"ddd")

D. =DAY(A1,"ddd")

2 / 88

31. Cell B1 has the “=IF(A1>=80,"AB",IF(A1<=60,"BC",IF(A1>=70,"CD","DE")))” formula, where cell A1 stores 55. Which of the following should be the output in cell B1?

A. AB

B. CD

C. BC

D. DE

3 / 88

30. Which function in MS Excel will return the specified number of characters from the start of a text string?

1. LEFT()

2. RIGHT()

3. LEN()

4. TRIM()

4 / 88

29. Which of the following logical functions in MS Excel 365 returns TRUE if all its arguments are TRUE?

A. FALSE

B. NOT

C. AND

D. OR

5 / 88

28. Where is the application name displayed in MS Excel?

1. Menu bar

2. Title bar

3. Toll bar

4. Task bar

6 / 88

27. In MS Excel, In which category of functions does "IFERROR" belongs to?

1. Statistical

2. Lookup and Reference

3. Text

4. Logical

7 / 88

26. Which of the following MS Excel functions counts the number of cells that are empty in a range?

1. COUNT()

2. COUNTA()

3. COUNTIF()

4. COUNTBLANK()

8 / 88

25. Which of the following is NOT a text function of MS Excel 2019?

1. RIGHT

2. LEFT

3. MID

4. NOT

9 / 88

24. The display value of the cell containing the Excel function=CEILING (10.7, 9) is:

1. 9

2. 10

3. 11

4. 18

10 / 88

23. The display value of the cell containing the Excel function =FLOOR (31.9, 7) is:

1. 7

2. 28

3. 31

4. 32

11 / 88

22. Which of the following can be used to show arrows that indicate which cells affect the value of the currently selected cell?

1. Show Formula

2. Error Checking

3. Trace Precedents

4. Trace Dependents

12 / 88

21. Which of the following can be used to show arrows that indicate what cells are affected by the value of the currently selected cell?

1. Show Formula

2. Error Checking

3. Trace Precedents

4. Trace Dependents

13 / 88

20. Assuming numeric values in the cells A6 to A10 as 29, 19, 27, 49 and 39 respectively, the value of the Excel expression =MAX(A6:A8, A10) is :

1. 39

2. 49

3. 29

4. 19

14 / 88

19. Match the followingSet-1 Set-2I) DELTA A) Tests whether two numbers are equalII) EXACT B) Counts the number of cells containing numbersIII) COUNT C) Tests whether two text strings are same

1. I – A, II – B, III – C

2. I – B, II – A, III - C

3. I – C. II – A. III – B

4. I – A, II – C, III – B

15 / 88

18. The value of the Excel expression = LEN(“1 2 3 4 5 6”) is:

1. 11

2. 6

3. 0

4. 13

16 / 88

17. The value of the Excel expression =LEFT(“MICROSOFT EXCEL”, 10) is:

1. OSOFT EXCEL

2. MICOSOFT E

3. MICROSOFT

4. SOFT EXCEL

17 / 88

16. Which of the following functions changes TRUE to FALSE and vice-versa?

1. AND

2. OR

3. NOT

4. IF

18 / 88

15. Which of the following MS Excel function returns true if all its arguments are true and returns false otherwise?

1. AND

2. OR

3. NOT

4. IF

19 / 88

14. Which of the following does not belong to the Statistical function category in MS-Excel?

1. ROUND ()

2. MAX ()

3. COUNT ()

4. AVERAGE ()

20 / 88

13. In MS Excel, which function is used to calculate depreciation, rates of return, future values and loan payment amounts?

1. Logical

2. Math & Trigonometry

3. Statistical

4. Financial

21 / 88

12. Depreciation, rates of return, future value and loan payment amounts are calculated using which of the following categories of Excel functions?

1. Logical

2. Math & Trigonometry

3. Statistical

4. Financial

22 / 88

11. What will be the output for the function BASE (17; 10) in an open office calc?

1. 0.7

2. 1.7

3. 17

4. 0.17

23 / 88

10. Which function converts a number into a text representation with the given radix in MS Excel?

1. RADIX function

2. BASE function

3. BRADIX Function

4. NRADIX function

24 / 88

9. Which function returns the arithmetic mean of all the in a range that meet a given criteria in MS Excel?

1. AVERAGE function

2. AVERAGEA function

3. AVG A function

4. AVERAGEIF function

25 / 88

8. Which of the following is a text category function in MS-Excel?

1. COUNTA()

2. VAR()

3. LEN()

4. ABS()

26 / 88

7. Which of the following is NOT a financial category function in MS Excel?

1. NOW()

2. RATE()

3. NPV()

4. PMT()

27 / 88

6. Which of the following is NOT a valid function in MS Excel?

3. ABS()

4. CEILING()

1. SUM()

2. SUBTRACT()

28 / 88

5. In MS Excel, ______ text function is useful for combining values from different cells into a single cell.

1. MATH

2. OR

3. CONCATENATE

4. AND

29 / 88

4. A/An ______ function checks to see if two text values are exactly identical in MS Excel 2019

1. EXACT()

2. FIND()

3. CONCATENATE()

4. CHAR()

30 / 88

3. What is the result of the following MS Excel 2019 formula? =FLOOR(250, 25)

1. 249

2. 240

3. 250

4. 275

31 / 88

2. In MS Excel 2007, to trace errors and show the cells that are referenced in a formula, we use ____________ buttons.

1. Trace Formula

2. Trace

3. Formula Auditing

4. Formula

32 / 88

1. In MS Excel 2016, which among the following is called upon to help you solve the problems?

1. Mathematical Library

2. Logical Library

3. Function Library

4. Scientific Library

33 / 88

25. Which of the following statements is true in case of pie chart in MS Excel?

1. This chart can show continuous data over time on an evenly scaled axis.

2. This chart shows the size of items in one data series, proportional to the sum of the items.

3. This chart is useful when you want to find optimum combinations between two sets of data.

4. This chart can show fluctuations in stock prices.

34 / 88

24. To create an interactive pivot table for the Web, a Microsoft Office Web component called _____ is used.

1. html

2. chart

3. sort

4. pivot table report

35 / 88

23. In column chart, _____ are structured along the horizontal axis and______ along the vertical axis in MS Excel.

1. Scale and series

2. Categories and values

3. Series and names

4. Names and depth

36 / 88

22. To emphasize the total in case of multiple data series _____ chart is useful in MS Excel.

1. Pie

2. Line

3. Stacked column

4. Surface

37 / 88

21. A 3-D surface chart that displays only the lines in MS Excel is called a _____.

1. Wireframe

2. Area

3. Bar

4. XY

38 / 88

20. ________ chart is used in a topographic map in which colours and patterns indicate areas that are in the same range of values in MS Excel.

1. Pie

2. Surface

3. XY

4. Stock

39 / 88

19. _______is helpful to locate exact point where the line intersects the axis in MS Excel.

1. Trend line

2. Horizontal axis

3. Drop line

4. Vertical axis

40 / 88

18. Which statement is FALSE in case of Area chart in MS Excel?

1. An area chart displays the contribution of each value to a total while emphasizing individual values.

2. Stacked area is a type of area chart.

3. 100% stacked area is a type of area chart.

4. An area chart uses three axes (horizontal, vertical, and depth).

41 / 88

17. Which chart implements Cartesian (XY) coordinate system in data plotting process?

1. Bar chart

2. Pie chart

3. Area chart

4. Scatter chart

42 / 88

16. Which of the following statements related to radar chart in MS Excel 2019 is INCORRECT?

1. This chart compares the aggregate values of several data series.

2. This chart displays the changes in the values relative to a centre point.

3. This chart shows the relationship of the parts to a whole.

4. In a filled radar chart, the area covered by a data series is filled with a colour.

43 / 88

15. Which statement is INCORRECT in case of stock chart in MS Excel?

1. Compares pairs of values

2. Used to illustrate the fluctuation of stock prices

3. Type of chart requires four series of values in the correct order (open, high, low, and then

4. Type of chart requires five series of values in the correct order (volume, open, high, low, close) and then close)

44 / 88

14. To represent the information in the same order on each bar ______ chart is useful in MS Excel.

1. Doughnut

2. Line

3. Radar

4. Stacked

45 / 88

13. Which of the following is NOT a variant of the Pie chart?

1. Doughnut

2. Line

3. Spie

4. Ring

46 / 88

12. The Radar chart is also known as:

1. Web chart

2. Bar chart

3. Line chart

4. Surface chart

47 / 88

11. Which chart in MS Excel 2013 can show continuous data over time on an evenly scaled axis which makes them ideal for showing trends in data at equal intervals, like months, quarters or fiscal years?

1. Line

2. Surface

3. Radar

4. Area

48 / 88

10. An Area chart is typically based on:

1. Line chart

2. Bar chart

3. Radar chart

4. Pie chart

49 / 88

9. ______ chart is used to shows proportions within hierarchical levels as rectangles.

1. Treemap

2. Sunburst

3. Area

4. Column

50 / 88

8. Under which of the following conditions scatter chart is NOT recommended?

1. You want to make that axis a logarithmic scale.

2. You want to divide data into slices to illustrate numerical proportion.

3. Values for horizontal axis are not evenly spaced.

4. There are many data points on the horizontal axis.

51 / 88

7. In MS Excel, ______ chart shows changes in values relative to a centre point.

1. Stock

2. Radar

3. Bar

4. Line

52 / 88

6. If there are many categories or the values are approximate, use a:

1. Pie chart

2. Line chart with markers

3. Line chart without markers

4. Doughnut chart

53 / 88

5. ______ is a chart that is supposed to be placed on a worksheet as opposed to on a separate chart sheet when using a spread sheet software package in MS Excel.

1. Bar chart

2. Column chart

3. Embedded chart

4. Stock chart

54 / 88

4. If a chart comprises of several categories, a ______ is needed to pinpoint the pattern in MS Excel.

1. Title

2. Legend

3. Scale

4. Source

55 / 88

3. PivotTable field names are formed from the source data's:

1. Sheet tab names

2. Column titles

3. Row titles

4. PivotChart report

56 / 88

2. Data visualization programs such as business intelligence software make use of the ______tool for data summarization.

1. Function

2. Macros

3. Chart

4. PivotTable

57 / 88

32. Let A1 cell store date ‘14-09-2022’, that is a Wednesday. Which of the following formulas of B1 cell will display ‘Wed’?

A. =TEXT(A1,"dddd")

B. =Day(A1,"dddd")

C. =TEXT(A1,"ddd")

D. =DAY(A1,"ddd")

58 / 88

31. Cell B1 has the “=IF(A1>=80,"AB",IF(A1<=60,"BC",IF(A1>=70,"CD","DE")))” formula, where cell A1 stores 55. Which of the following should be the output in cell B1?

A. AB

B. CD

C. BC

D. DE

59 / 88

30. Which function in MS Excel will return the specified number of characters from the start of a text string?

1. LEFT()

2. RIGHT()

3. LEN()

4. TRIM()

60 / 88

29. Which of the following logical functions in MS Excel 365 returns TRUE if all its arguments are TRUE?

A. FALSE

B. NOT

C. AND

D. OR

61 / 88

28. Where is the application name displayed in MS Excel?

1. Menu bar

2. Title bar

3. Toll bar

4. Task bar

62 / 88

27. In MS Excel, In which category of functions does "IFERROR" belongs to?

1. Statistical

2. Lookup and Reference

3. Text

4. Logical

63 / 88

26. Which of the following MS Excel functions counts the number of cells that are empty in a range?

1. COUNT()

2. COUNTA()

3. COUNTIF()

4. COUNTBLANK()

64 / 88

25. Which of the following is NOT a text function of MS Excel 2019?

1. RIGHT

2. LEFT

3. MID

4. NOT

65 / 88

24. The display value of the cell containing the Excel function=CEILING (10.7, 9) is:

1. 9

2. 10

3. 11

4. 18

66 / 88

23. The display value of the cell containing the Excel function =FLOOR (31.9, 7) is:

1. 7

2. 28

3. 31

4. 32

67 / 88

22. Which of the following can be used to show arrows that indicate which cells affect the value of the currently selected cell?

1. Show Formula

2. Error Checking

3. Trace Precedents

4. Trace Dependents

68 / 88

21. Which of the following can be used to show arrows that indicate what cells are affected by the value of the currently selected cell?

1. Show Formula

2. Error Checking

3. Trace Precedents

4. Trace Dependents

69 / 88

20. Assuming numeric values in the cells A6 to A10 as 29, 19, 27, 49 and 39 respectively, the value of the Excel expression =MAX(A6:A8, A10) is :

1. 39

2. 49

3. 29

4. 19

70 / 88

19. Match the followingSet-1 Set-2I) DELTA A) Tests whether two numbers are equalII) EXACT B) Counts the number of cells containing numbersIII) COUNT C) Tests whether two text strings are same

1. I – A, II – B, III – C

2. I – B, II – A, III - C

3. I – C. II – A. III – B

4. I – A, II – C, III – B

71 / 88

18. The value of the Excel expression = LEN(“1 2 3 4 5 6”) is:

1. 11

2. 6

3. 0

4. 13

72 / 88

17. The value of the Excel expression =LEFT(“MICROSOFT EXCEL”, 10) is:

1. OSOFT EXCEL

2. MICOSOFT E

3. MICROSOFT

4. SOFT EXCEL

73 / 88

16. Which of the following functions changes TRUE to FALSE and vice-versa?

1. AND

2. OR

3. NOT

4. IF

74 / 88

15. Which of the following MS Excel function returns true if all its arguments are true and returns false otherwise?

1. AND

2. OR

3. NOT

4. IF

75 / 88

14. Which of the following does not belong to the Statistical function category in MS-Excel?

1. ROUND ()

2. MAX ()

3. COUNT ()

4. AVERAGE ()

76 / 88

13. In MS Excel, which function is used to calculate depreciation, rates of return, future values and loan payment amounts?

1. Logical

2. Math & Trigonometry

3. Statistical

4. Financial

77 / 88

12. Depreciation, rates of return, future value and loan payment amounts are calculated using which of the following categories of Excel functions?

1. Logical

2. Math & Trigonometry

3. Statistical

4. Financial

78 / 88

11. What will be the output for the function BASE (17; 10) in an open office calc?

1. 0.7

2. 1.7

3. 17

4. 0.17

79 / 88

10. Which function converts a number into a text representation with the given radix in MS Excel?

1. RADIX function

2. BASE function

3. BRADIX Function

4. NRADIX function

80 / 88

9. Which function returns the arithmetic mean of all the in a range that meet a given criteria in MS Excel?

1. AVERAGE function

2. AVERAGEA function

3. AVG A function

4. AVERAGEIF function

81 / 88

8. Which of the following is a text category function in MS-Excel?

1. COUNTA()

2. VAR()

3. LEN()

4. ABS()

82 / 88

7. Which of the following is NOT a financial category function in MS Excel?

1. NOW()

2. RATE()

3. NPV()

4. PMT()

83 / 88

6. Which of the following is NOT a valid function in MS Excel?

1. SUM()

2. SUBTRACT()

3. ABS()

4. CEILING()

84 / 88

5. In MS Excel, ______ text function is useful for combining values from different cells into a single cell.

1. MATH

2. OR

3. CONCATENATE

4. AND

85 / 88

4. A/An ______ function checks to see if two text values are exactly identical in MS Excel 2019.

1. EXACT()

2. FIND()

3. CONCATENATE()

4. CHAR()

86 / 88

3. What is the result of the following MS Excel 2019 formula? =FLOOR(250, 25)

1. 249

2. 240

3. 250

4. 275

87 / 88

2. In MS Excel 2007, to trace errors and show the cells that are referenced in a formula, we use ____________ buttons.

1. Trace Formula

2. Trace

3. Formula Auditing

4. Formula

88 / 88

1. In MS Excel 2016, which among the following is called upon to help you solve the problems?

1. Mathematical Library

2. Logical Library

3. Function Library

4. Scientific Library

Your score is

Quiz

All Computer Quiz

Fundamental Quiz

Ms Word Quiz

Excel Quiz

Powerpoint Quiz

Hello!

`All Computer Quiz`