MS EXCEL MCQ

Q.	What is the intersection of a column and a row on a worksheet called ? A. Column B. Value C. Address D. Cell Answer : Option D
Q.	What type of chart is useful for comparing vaues over categories ? A. Pie Chart B. Column Chart C. Line Chart D. Dot Graph Answer : Option B
Q.	Which functionin Excel tells how many numeric entries are there ? A. NUM B. COUNT C. SUM D. CHKNUM Answer : Option B
Q.	A features that displays only the data in column (s) according to specified criteria A. Formula B. Sorting C. Filtering D. Pivot Answer : Option C
Q.	Statistical calculations and preparation of tables and graphs can be done using A. Adobe Photoshop B. Excel C. Notepad D. Power Point Answer : Option B
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 Answer : Option B
Q.	Which one is not a Function in MS Excel ? A. SUM B. AVG C. MAX D. MIN Answer : Option B
Q.	Functions in MS Excel must begin with ___ A. An () sign B. An Equal Sign C. A Plus Sign D. A > Sign Answer : Option B
Q.	Which functionin Excel checks whether a condition is true or not ? A. SUM B. COUNT C. IF D. AVERAGE Answer : Option C
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. Answer : Option A
Q.	The Greater Than sign (>) is an example of _____ operator. A. Arithmatic B. Logical C. Conditional D. Greater Answer : Option B
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 Answer : Option C
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 Answer : Option C
Q.	The ____ feature of MS Excel quickly completes a series of data A. Auto Complete B. Auto Fill C. Fill Handle D. Sorting Answer : Option B
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 Answer : Option A
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. Answer : Option B
Q.	What do you use to create a chart? A. Pie Wizard B. Excel Wizard C. Data Wizard D. Chart Wizard Answer : Option D
Q.	How will you graphically represent expenditure in different departments ? A. Column Chart B. Line Chart C. Pie Chart D. Dot Chart Answer : Option C
Q.	What type of chart is good for single series of data ? A. Column Chart B. Line Chart C. Pie Chart D. Cone Chart Answer : Option C
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 Answer : Option A
Q.	How many sheets are there, by default, when we create a new Excel file ? A. 1 B. 3 C. 5 D. 10 Answer : Option B
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 Answer : Option B
Q.	An Excel file is generally called a / an : A. E-Spreadsheet B. Woorksheet C. Workbook D. Sheet Answer : Option C
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 Answer : Option C
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 Answer : Option A