# mcqsbucket

Best guide for exams of all nature, Competitive exams and Interviews
Here is the MCQs guide for the topic of Excel. you will find various types of questions along with there answers in this
 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 : 1,2,3 etc Q. The ____ feature of MS Excel quickly completes a series of data A. Auto Complete B. Auto Fill C. Fill Handle D. Sorting Answer : Auto Fill Q. The process of arrenging the items of a column in some sequence or order is known as : A. Autofill B. Filtering C. Arrengin D. Sorting Answer : Sorting Q. The Greater Than sign (>) is an example of _____ operator. A. Arithmatic B. Logical C. Greater D. Conditional Answer : Logical 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 : A, B, C, etc Q. Which function in Excel checks whether a condition is true or not ? A. SUM B. COUNT C. IF D. AVERAGE Answer : IF Q. Functions in MS Excel must begin with ___ A. An () sign B. An Equal Sign C. A Plus Sign D. A > Sign Answer : An Equal Sign Q. Which one is not a Function in MS Excel ? A. SUM B. AVG C. MAX D. MIN Answer : AVG 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 : Line Chart Q. Statistical calculations and preparation of tables and graphs can be done using A. Adobe Photoshop B. Excel C. Power Point D. Notepad Answer : Excel
MCQs Bucket