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
Answered by
42
1Q answer A .pie chart 2Q answer B. Count 3Q answer A .Formula 4Q answer c . power point 5Q answer. A .column chart 6Q answer D .Min 7Q answer. c. a plus sign
Answered by
1
Choose the correct answer:
Explanation:
1) A. Pie Chart
2) B. Count
3)A. Formula
4)c. power point
5)A .column chart
6) D .MIN
7) c. a plus sign
8)C. IF
9) A. A, B, C, etc
10) C. Conditional
11) C. Line Chart
12) C. Sorting
13)B. Auto Fill
14) C. Line Chart
15) .B. 1,2,3 etc
16) D. Chart Wizard
17) C. Pie Chart
18) C. Pie Chart
19)A. cell
20) B. B1:E5
21) B. Woorksheet
22)C. database
23) C. Pie Chart
24) A) Formatting Toolbar
25) C) Tools
26) A) Today
27) C) MOD ( )
28) C) Tools
29) B) Worksheets
30)B) Currency
31) D) Data
32) D) Graph
33) C) Data Series
34) A) WINDOWS
35) A) Workbook
36) B) .xlsx
37) C) Data label
38) D) #
Similar questions