Question

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) #

Answer 1

pie chart

count

excel

columnchart

Answer 2

Answer:

pie chart

count

excel

column chart