Q
Q. What type of chart is useful for comparing values over categories ?
A. Pie Chart
B. Column Chart
C. Line Chart
D. Dot Graph
Q. Which functionin Excel tells how many numeric entries are there ?
A. NUM
B. COUNT
C. SUM
D. CHKNUM
Q. A features that displays only the data in column (s) according to specified criteria
A. Formula
B. Sorting
C. Filtering
D. Pivot
Q. Statistical calculations and preparation of tables and graphs can be done using
A. Adobe Photoshop
B. Excel
C. Notepad
D. Power Point
Q. What type of chart will you use to compare performance of two employees in the year 2016 ?
A. Column Chart
B. Line Chart
C. Pie Chart
D. Dot Chart
Q. Which one is not a Function in MS Excel ?
A. SUM
B. AVG
C. MAX
D.MIN
Q. Functions in MS Excel must begin with ___
A. An () sign
B. An Equal Sign
C. A Plus Sign
D. A > Sign
Q.
Which functionin Excel checks whether a condition is true or not ?
A. SUM
B. COUNT
C. IF
D. AVERAGE
Q. In Excel, Columns are labelled as ___
A. A, B, C, etc
B. 1,2,3 etc
C. A1, A2, etc.
D. $A$1, $A$2, etc.
Q. The Greater Than sign (>) is an example of _____ operator.
A. Arithmatic
B. Logical
C. Conditional
D. Greater
Q. What type of chart is useful for showing trends or changes over time ?
A. Pie Chart
B. Column Chart
C. Line Chart
D. Dot Graph
Q. The process of arrenging the items of a column in some sequence or order is known as :
A. Arrengin
B. Autofill
C. Sorting
D. Filtering
Q. The ____ feature of MS Excel quickly completes a series of data
A. Auto Complete
B. Auto Fill
C. Fill Handle
D. Sorting
Q. What type of chart is useful for comparing parts of a whole ?
A. Pie Chart
B. Column Chart
C. Line Chart
D. Dot Graph
Q. In Excel, Rows are labelled as ______
A. A, B, C, etc
B. 1,2,3 etc
C. A1, A2, etc.
D. $A$1, $A$2, etc.
Q. What do you use to create a chart?
A. Pie Wizard
B. Excel Wizard
C. Data Wizard
D. Chart Wizard
Q. How will you graphically represent expenditure in different departments ?
A. Column Chart
B. Line Chart
C. Pie Chart
D. Dot Chart
Q. What type of chart is good for single series of data ?
A. Column Chart
B. Line Chart
C. Pie Chart
D. Cone Chart
Q. The basic unit of a worksheet into which you enter data in Excel is called a
A. cell
B. table
C. box
D. column
Q. In Excel, which one denoted a range from B1 through E5
A. B1 - E5
B. B1:E5
C. B1 to E5
D. B1$E5
Q. An Excel file is generally called a / an :
A. E-Spreadsheet
B. Woorksheet
C. Workbook
D. Sheet
Q. It is a collection of data that is stored electronically as a series of records in a table.
A. spreadsheet
B. presentation
C. database
D. MS Word
Q. What type of chart will you use to compare performance of sales of two products ?
A. Column Chart
B. Line Chart
C. Pie Chart
D. Both A and B
Q. In MS Excel, in which bar have the currency option
A) Formatting Toolbar B) Standard Toolbar
C) Status Bar D) Formula bar
Q. Which menu contains macro options in MS Excel
A) Insert B) Format C) Tools D) Data
Q. Which function is used to input the date only in MS Excel?
A) Today B) Now C) Time D) Calendar
Q. Which Function is used to calculate Remainder in MS Excel?
A) INT ( ) B) FACT ( ) C) MOD ( ) D) DIV ( )
Q. Which menu have the Fill option in MS Excel?
A) View B) Format C) Tools D) Edit
Q. Excel is a collection of workbook ………….
A) Workbooks B) Worksheets C) Charts and Slides D) Data
Q. Which of these data types is not in MS.excel?
A) Number B) Currency C) Label D) Date/Time
Q. In MS Excel, which menu does have Sort option
A) Edit B) Format C) Tool D) Data
Q. Which of these charts does not exist in MS Excel
A) Scatter B) Line C) Doughnut D) Graph
Q. Which of these options is not available in the Chart Options in MS Excel “CHART WIZARD”?
A) Axes B) Data Label C) Data Series D) Data Table
Q. MS EXCEL Based on _______ Software
A) WINDOWS B) DOS C) UNIX D) LINUX
Q. A spreadsheet is a collection of pages is called a _______
A) Workbook B) Art book C) Worksheet D) Documents
Q. What is the Extension of Excel Workbook in MS Excel 2007?
A) .xlx B) .xlsx C) .xlcx D) .xlxx
Q. Which option of Chart Wizard contains the option of Series Name, Category and Value in Data?
A) Legend B) Chart area C) Data label D) Data Titles
Q. Which sign display when Formula Error in MS Excel
A) $ B) * C) \ D) #
Answers
Answer:
1. Column Chart is useful for comparing values over categories.
2. COUNT function in Excel tells how many numeric entries are there.
3. Filtering is the feature that displays only the data in column(s) according to specified criteria.
4. Statistical calculations and preparation of tables and graphs can be done by using Excel.
5. Line Chart will be used to compare performance of two employees in the year 2016.
6. AVG is not a Function in MS Excel.
7. Functions in MS Excel must begin with An Equal Sign.
8. IF function in Excel checks whether a condition is true or not.
9. In Excel, Columns are labelled as A, B, C, etc
10. The Greater Than sign is an example of Logical operator.
11. Line Chart is useful for showing trends or changes over time.
12. The process of arranging the items of a column in some sequence or order is known as Sorting.
13. The Auto Fill feature of MS Excel quickly completes a series of data.
14. Pie Chart is useful for comparing parts of a whole.
15. In Excel, Rows are labelled as 1,2,3 etc.
16. Chart Wizard is used to create a chart.
17. By using Pie Chart we will graphically represent expenditure in different departments.
18. Pie Chart is good for single series of data.
19. The basic unit of a worksheet into which you enter data in Excel is called a cell.
20. In Excel, B1:E5 is denoted as a range from B1 through E5.
21. An Excel file is generally called a / an Workbook.
22. Database is a collection of data that is stored electronically as a series of records in a table.
23. Column Chart will be used to compare performance of sales of two products.
24. In MS Excel, in Formatting Toolbar we have the currency option.
25. Tools menu contains macro options in MS Excel.
26. Today is the function used to input the date only in MS Excel.
27. MOD ( ) function is used to calculate Remainder in MS Excel.
28. Edit menu have the Fill option in MS Excel.
29. Excel is a collection of workbook Worksheets.
30. Label data type is not in MS Excel.
31. In MS Excel, Data menu have Sort option.
32. Graph chart does not exist in MS Excel.
33. Data Series option is not available in the Chart Options in MS Excel “CHART WIZARD”.
34. MS EXCEL is based on WINDOWS Software.
35. A spreadsheet is a collection of pages is called a Workbook.
36. .xlsx is the Extension of Excel Workbook in MS Excel 2007.
37. Data label is the option of Chart Wizard which contains the option of Series Name, Category and Value in Data.
38. # is the sign which displays when there is Formula Error in MS Excel.
Answer:
column chart
Explanation:
is is the correct answer for this ok