# MS Excel MCQs Questions Answers

**MS Excel MCQs** Questions and Answers paper for the competitive examination is given below. Candidates who are looking for MS Excel Questions and Answers Objective model question paper can find in this section. MS Excel Interview Questions under MS Office Package for various competitive exam all over India.

Here are certain direct links are given to download the Questions about Excel in Interview to help the participants who are in preparation for their exams. Hence download the MS Excel Questions and Answers in Hindi Paper and practice by solving the questions. Use these question paper of MS Excel MCQs as a reference for your preparation by the best Materials for MS Excel MCQs. including Excel 97-2003, XP, 2007, 2010, 2014 and 360 Just click on the relevant link to get the Questions about Excel in Interview.

So, applicants can begin the preparation for Questions about Excel in Interview. Therefore providing the MS Excel Questions and Answers Objective Paper for free of cost.

So, click to download the reference materials for the MS Excel MCQs Questions and Answers in Hindi for Exam preparation. The Advanced Excel Interview Questions Papers will also be available.

## MS Excel MCQs Practical Questions

1. Formulas in Excel start with

(a) %

(b) =

(c) +

(d) –

2. The cell reference for cell range of G2 to M12 is _________

(a) G2:M12

(b) G2:M12

(c) G2:M12

(d) G2-M12

3. What is the keyboard shortcut for creating a chart from the selected cell range?

(a) F2

(b) F4

(c) F8

(d) F11

4. The box on the chart that contains the name of each individual record is called the _________.

(a) Cell

(b) Title

(c) Axis

(d) legend

5. What happens when dollar signs ($) are entered in a cell address? (eg. $B$2:$B$10)

(a) An absolute cell address is created.

(b) Cell address will change when it is copied to another cell.

(c) The sheet tab is changed.

(d) The status bar does not display the cell address.

6. What will be the output if you format the cell containing 5436.8 as ‘#,##0.00’?

(a) 5,430.00

(b) 5,436.80

(c) 5,436.8

(d) 6.8

7. A numeric value can be treated as label value if _________ precedes it.

(a) Apostrophe (‘)

(b) Exclamation (!)

(c) Hash (#)

(d) Tilde (~)

8. In MS-Excel two common wildcard characters that MS-Excel recognizes are

(a) * and ?

(b) < and >

(c) ^ and /

(d) None of these

9. Which of the following is correct syntax in Excel?

(a) IF(LogicalTest, TrueResult, FalseResult)

(b) IF(LogicalTest, (TrueResult, FalseResult))

(c) IF(LogicalTest, TrueResult) (LogicalTest, FalseResult)

(d) IF(LogicalTest, TrueResult), IF(LogicalTest, FalseResult)

10. Which function in Excel tells how many numeric entries are there?

(a) NUM

(b) COUNT

(c) SUM

(d) CHKNUM

11. A features that displays only the data in column (s) according to specified criteria

(a) Formula

(b) Sorting

(c) Filtering

(d) Pivot

12. What type of chart is good for single series of data?

(a) Column Chart

(b) Line Chart

(c) Pie Chart

(d) Cone Chart

13. In excel, all cells by default are ________.

(a) Unlocked

(b) Locked

(c) Neither unlock nor lock

(d) None of these

14. Which of the following is used for limiting the number of text in a cell?

(a) Text length in Data validation

(b) Text Size in Data validation

(c) Word count in Proofing

(d) Comment in Review

15. Which function will you use to enter current time in a worksheet cell?

(a) =today()

(b) =now()

(c) =time()

(d) =currentTime()

16. In referring to formula =sum($A$1:$A$10), which of the following statements is true:

(a) A1 to A10 will be added and it is a relative reference.

(b) A1 to A10 will be added and it is absolute reference.

(c) A1 to A10 will be added and it is has a relation with other worksheet.

(d) A1 to A10 will be added in two worksheets.

17. When all the numbers between 0 and 100 in a range should be displayed in Red Color

(a) Use =if() function to format the required numbers red

(b) Apply Conditional Formatting command on Format menu

(c) Select the cells that contain number between 0 and 100 then click Red color on Text Color tool

(d) All of these

18. Assume that all the cells in workbook are empty. You are entering the formula =Sheet1!A1+Sheet2!A1 in Cell B1 of sheet3. What will be the output?

(a) 0

(b) #REF

(c) #NAME

(d) Incorrect formula

19. Which of the following is true for RANK function?

(a) It gives a rank of numerical value which is always sequential

(b) It gives a rank of numerical value which may not be in sequence

(c) It gives alphabetical rank

(d) None of these

20. What will be the output if you format the cell containing 1234.5 as ‘#,##0.002 ?

(a) 1,230.40

(b) 1,234.50

(c) 1,234.5

(d) 12345

21. If you need a text to show vertically in a cell. How will you achieve this?

(a) Choose Vertical on Text alignment in Format Cells dialog box

(b) Choose 90 Degrees in Orientation of Format Cells dialog box

(c) Choose Distributed from the Vertical drop down list of Format Cells dialog box

(d) Choose Center Across Selection from Horizontal combo box in Format Cells dialog box

22. Except for the …… function, a formula with a logical function shows the word “TRUE” or “FALSE” as a result

(a) IF

(b) AND

(c) OR

(d) NOT

23. The box on the chart that contains the name of each individual record is called the _________.

(a) Cell

(b) Title

(c) Axis

(d) Legend

24. What is a quick way to extend these numbers to a longer sequence, for instance 1 through 20?

(a) Select both cells, and then drag the fill handle over the range you want, for instance 18 more rows

(b) Select the range you want, include both cells, point to fill on the Edit menu, and then click down.

(c) Copy the second cell, click in the cell below it, on the standard toolbar click the down arrow on the Paste button, and then click Paste Special

(d) All of the above

25. Formulas in Excel start with

(a) %

(b) =

(c) +

(d) –

26. The cell reference for cell range of K2 to N12 is

(a) K2:N12

(b) K2:N12

(c) K2:N12

(d) K2:N12

27. What is the AutoComplete feature of Excel?

(a) It automatically completes abbreviated words

(b) It completes text entries that match an existing entry in the same column

(c) It completes text and numeric entries that match an existing entry in the same column

(d) It completes text entries that match an existing entry in the same worksheet

28. Which of the following is correct syntax in Excel?

(a) IF(LogicalTest, TrueResult, FalseResult)

(b) IF(LogicalTest, (TrueResult, FalseResult))

(c) IF(LogicalTest, TrueResult) (LogicalTest, FalseResult)

(d) IF(LogicalTest, TrueResult), IF(LogicalTest, FalseResult)

29. If the cell B1 contains the formula =$A$1, which of the following statements is true?

(a) There is a relative reference to cell A1

(b) There is an absolute reference to cell A1

(c) Further changes in value of A1 will not affect the value of B1

(d) Further changes in value of B1 will affect the value of A1

30. When all the numbers between 0 and 100 in a range should be displayed in Red Color,

(a) Use =if() function to format the required numbers red

(b) Apply Conditional Formatting command on Format menu

(c) Select the cells that contain number between 0 and 100 then click Red color on Text Color tool

(d) All of above

31. Which of the following can you paste selectively using Paste Special command?

(a) Validation

(b) Formats

(c) Formulas

(d) All of these

32. Which of the following series type is not valid for Fill Series dialog box?

(a) Linear

(b) Growth

(c) Autofill

(d) Time

33. A numeric value can be treated as label value if __________ precedes it.

(a) Apostrophe (‘)

(b) Exclamation (!)

(c) Hash (#)

(d) Tilde (~)

34. Which Chart can be created in Excel?

(a) Area

(b) Line

(c) Pie

(d) All of these

35. Getting data from a cell located in a different sheet is called

(a) Accessing

(b) Referencing

(c) Updating

(d) Functioning

36. How do you select entire cells in particular column of worksheet?

(a) Pressing Ctrl+A

(b) Click Column heading letter

(c) Click Edit, Then Click Select All

(d) Typing same letter as Column heading letter

37. What will you do to save existing Excel workbook in different name?

(a) Ctrl+s

(b) Save

(c) Save as

(d) Shift + s

38. If you have a list of numbers in cells B2 through B20 and you wanted the average of these numbers, what would be the formula?

(a) =AVERAGE(B2-B20)

(b) =AVERAGE(B2:B20)/18

(c) =AVERAGE((B2:B20)/18)

(d) =AVERAGE(B2:B20)

39. Which of the following is not a way to complete a cell entry?

(a) Pressing enter

(b) Pressing any arrow key on the keyboard

(c) Clicking the Enter button on the Formula bar

(d) Pressing spacebar

40. Comments put in cells are called

(a) Smart tip

(b) Cell tip

(c) Web tip

(d) Soft tip

41. To create a formula, you first:

(a) Select all the cells you want to place the formula into

(b) Type the equals sign (=) to tell Excel that you’re about to enter a formula in a cell

(c) Enter the formula using any input values and the appropriate mathematical operators that make up your formula

(d) Choose the new command from the file menu

42. Which area in an Excel window allows entering values and formula?

(a) Title bar

(b) Menu bar

(c) Formula bar

(d) Standard toolbar

43. What is the correct formula to round sum of data from cell D4 to D17 without decimal point?

(a) =round(sum(D4:D17),0)

(b) = sum(round(D4:D17))

(c) =round(sum(D4:D17))

(d) = sum(round(D4:D17),0)

44. The numbers in our worksheet look like 1000, You want them to look like $1,000.00. How can you accomplish this?

(a) Select Money>US Dollar

(b) Select Format > Money from the menu

(c) Click the Currency Style button on the formatting toolbar

(d) You have to retype everything and manually add the dollar signs, commas, and decimals.

45. Which of the following is an absolute cell reference?

(a) !A!1

(b) $A$1

(c) #a#1

(d) A1

46. If a variable is to be created in Excel, the variable and value must be in

(a) same cell

(b) same row next to each other

(c) same column next to each other

(d) same row or same column next to each other

47. What are the three tools in what-if analysis in Excel?

(a) Scenarios, Data tables and Goal seek

(b) Scenarios, Data tables and Target

(c) Scenarios, Data Set and Prediction

(d) Scenario, Prediction and Future Value

48. The maximum number of work sheet in a work book is____________

(a) 100

(b) 155

(c) 200

(d) 255

49. Excel recognizes an entry as formula if it is preceded by either = or __________

(a) +

(b) –

(c) *

(d) /

50. By default, MS-Excel uses ____________ referencing while copying formulas.

(a) Absolute

(b) Relative

(c) Mixed

(d) Transitive

51. To make the cell referencing absolute, the column label or row number should be preceded by_______

(a) &

(b) @

(c) #

(d) $

52. To set all the columns with equal width

(a) Select all visible column, then place cell pointer on column dividing line, press left mouse button and drag to either left or right.

(b) Select all visible column, click insert then enter the desired width in numerical number.

(c) Select the first two columns, then place cell pointer on column dividing line between them, press left mouse button and drag to either left or right.

(d) Click Edit, from dropdown menu select column width, then enter desired column width

53. The formula to find sum of all value within the cell ranges from F2 to F23 is___________

(a) =sum(F2+F23)

(b) =sum(F2-F23)

(c) =sum(F2:F23)

(d) =sum(F2#F23)

54. What are the two types of data tables?

(a) One variable data table and two variable data table

(b) Row variable data table and column variable data table

(c) Vertical variable data table and Horizontal variable data table

(d) Odd variable data table and Even variable data table

55. In MS-Excel, how many data series can be displayed with Pie Chart?

(a) 1

(b) 2

(c) 3

(d) 4

56. Which of the following option is not available in Paste Special dialog box?

(a) Add

(b) Subtract

(c) Divide

(d) SQRT

57. Width of a column can be auto fitted by

(a) Double clicking on the column name on column header

(b) Double click on the cell pointer in worksheet

(c) Double clicking on column right border on column header

(d) Double clicking on the column left border of column header

58. The function to return the remainder after a number is divided by a divisor in EXCEL is ___________

(a) ROUND ( )

(b) FACT ( )

(c) MOD ( )

(d) DIV ( )