MS Excel Questions
MS Excel is always considered as important one in all the competitive examinations. 55+ MS Excel Questions and Answers that includes both MCQ as well as Interview Questions are given here on this page. These given MS Excel Objective Questions are updated ones and are based on the computer basics.
Candidates can improve their performance of computer knowledge section by learning these MS Excel Questions and Answers. For MS Excel Interview Questions and Answers, complete explanation is provided, so that participants don’t face any kind of problem while preparing for the interview round as well as entrance tests.
MS Excel Questions
MS Excel MCQ Questions and Answers
Answers for these questions are available at the end.
Question 1) If you press ___, the cell accepts your typing as its contents ?
Question 2) Which of these will not select all the cells in a document ?
- Using the Edit – Select All menu
- Pressing Ctrl + A on the keyboard
- Clicking three times with the right mouse button in the spreadsheet
Question 3) What term describes explanatory text attached to a cell ?
Question 4) With which of the following all formulas in excel starts ?
Question 5) The default style for new data keyed in a new workbook is ?
Read Out: Basic Internet Questions and Answers
Question 6) How we can view a cell comment ?
- position the mouse pointer over the cell
- click the comment command on the view menu
- click the edit comment commands on the Insert menu
- click the Display comment command on the window menu
Question 7) On an excel sheet the active cell in indicated by ?
- A dotted border
- A dark wide border
- A blinking border
- By italic text
Question 8) Formula palette is used to ?
- format cells containing numbers
- create and edit formulas containing functions
- entered assumptions data
- copy all cells
Question 9) A Spreadsheet contains ?
- rows and columns
- None of above
Question 10) Which among following is not associated with spelling dialogue box ?
- Ignore All
Question 11) Which of the following keyboard shortcut can be used for creating a chart from the selected cells ?
Question 12) A value used in a formula that does not change is called a ?
- Cell address
Get Here: MS Power Point Questions
Question 13) To open an existing workbook, click the Open button on the ___ toolbar ?
Question 14) What term describes a background that appears as a grainy, non smooth surface ?
Question 15) The cell reference for a range of cells that starts in cell C1 and goes over to column H and down to row 10 is ?
Question 16) To create an interactive Pivot Table for the web, you use a Microsoft Office Web component called ?
- Pivot Table Field List
- Pivot Table Report
- Pivot Table List
Question 17) Except which of the following function, a formula with a logical function shows the word “TRUE” or “FALSE” as a result ?
Question 18) Which among following is associated with excel ?
- Graphic program
- Word Processor
Question 19) You can convert existing Excel worksheet data and charts to HTML document by using the ?
- Internet Assistant Wizard
- Intranet Wizard
- Import Wizard
- Export Wizard
Question 20) What function displays row data in a column or column data in a row ?
Question 21) Macros can be executed from the which of the following menu ?
Question 22) Which of the following is not a valid Zoom percentage in Excel ?
Question 23) How can we set Page Border in Excel ?
- From Edit menu
- From Home
- You cannot set page border in Excel
- From Tools menu
Question 24) Which types of charts can excel produce ?
- Line graphs and pie charts only
- Bar charts, line graphs and pie charts
- Bar charts and line graphs only
- Only line graphs
Question 25) Protection and the Protect Sheet options can be selected from ?
Question 26) You can check the conditions against ____ when applying conditional formatting?
- Cell Value
- Both of above
- None of above
Question 27) Which function calculates your monthly mortage payment ?
- All of above
Question 28) How is data organized in a spreadsheet ?
- Rows and columns
- Layers and planes
- Lines and spaces
- Height and width
Question 29) How do you change column width to fit the contents ?
- Single-click the boundary to the left to the column heading
- Double click the boundary to the right of the column heading
- Press Alt and single click anywhere in the column
- All of above
Question 30) To drag a selected range of data to another worksheet in the same workbook, use the ?
- Ctrl key
- Shift key
- Alt key
- Tab key
Question 31) A function inside another function is known as ?
- Round function
- Sandwich function
- Switch function
- Nested function
Question 32) VLOOKUP function used to ?
- Finds related records
- Looks up text that contain “v”
- Check if two cells are identical
- None of above
Question 33) To insert three columns between columns A and B you would
- Select column A
- Select A and B
- Select B
- All of above
Question 34) You can activate a cell by ?
- Pressing the Tab key
- Clicking the cell
- Pressing an arrow key
- All of above
Question 35) Which function is used for creating a data table ?
Question 36) 3-D reference in a formula?
- Spans worksheets
- Cannot be modified
- Only appears on summary worksheets
- Limits the formatting options
Question 37) Which among following wildcard characters are recognized by excel ?
- + and –
- ! and ^
- * and ?
- < and >
Question 38) What excel feature can you use if you want to work with one record at a time ?
- Auto Complete
- Data Form
- Set Form
- Auto Text
Question 39) The accounting style shows negative numbers in ?
Question 40) Which among following is divide symbol in excel ?
|Ans1) 3||Ans15) 2||Ans29) 2|
|Ans2) 3||Ans16) 3||Ans30) 1|
|Ans3) 3||Ans17) 3||Ans31) 4|
|Ans4) 4||Ans18) 4||Ans32) 1|
|Ans5) 2||Ans19) 1||Ans33) 3|
|Ans6) 1||Ans20) 1||Ans34) 4|
|Ans7) 2||Ans21) 4||Ans35) 2|
|Ans8) 2||Ans22) 4||Ans36) 1|
|Ans9) 3||Ans23) 3||Ans37) 3|
|Ans10) 1||Ans24) 2||Ans38) 2|
|Ans11) 1||Ans25) 2||Ans39) 3|
|Ans12) 1||Ans26) 3||Ans40) 1|
|Ans13) 2||Ans27) 3|
|Ans14) 2||Ans28) 1|
MS Excel Interview Questions and Answers
Question 1) Explain Spreadsheet and its Basics.
Answer 1) Spreadsheet can be compared to a paper ledger sheet. It consists of rows and columns and their intersection called cells.
Question 2) Specify the order of operations used for evaluating formulas in Excel.
Answer 2) The order of operations in Microsoft Excel is same as in standard mathematics. It’s defined by the term “PEMDAS” or “BEDMAS”.
- Parentheses or Brackets
Question 3) Explain Macro in MS-Excel.
Answer 3) Macros are used for iterating over a group of tasks. Users can create macros for their customized repetitive functions and instructions. Macros can be either written or recorded depending on the user.
Question 4) Is it possible to prevent someone from copying the cell from your worksheet?
Answer 4) Yes, it is possible. To protect your worksheet from getting copied, you need to go into Menu bar >Review > Protect Sheet > Password. By entering a password, you can secure your sheet from getting copied by others.
Question 5) How can you sum up the Rows and Column number quickly in the Excel sheet?
Answer 5) By using SUM function, you can get the total sum of the rows and columns, in an Excel worksheet.
Question 6) What does a red triangle at the top right of a cell indicate?
Answer 6) The red triangle indicates that some comment is associated with the cell. Hover the mouse over it, and you can read the full comment.
Question 7) What is the use of NameBox in MS-Excel?
Answer 7) Name Box is used to return to a particular area of the worksheet by typing the range name or cell address in the name box.
Question 8) Explain pivot tables and its uses.
Answer 8) A pivot table is a tool that allows for quick summarization of large data. It automatically performs a sort, count, total or average of the data stored in the spreadsheet and displays result in another spreadsheet. It saves a lot of time. Allows to link external data sources to our Excel.
Question 9) How would you provide a Dynamic range in “Data Source” of Pivot Tables?
Answer 9) To provide a dynamic range in “Data Source” of Pivot tables, first, create a named range using offset function and base the pivot table using a named range created in the first step.
Question 10) Which event do you use to check whether the Pivot Table is modified or not?
Answer 10) To check whether the pivot table is modified or not we use “PivotTableUpdate” in worksheet containing the pivot table.
Question 11) What is Freeze Panes in MS-Excel?
Answer 11) To lock any row or column, freeze panes is used. The locked row or column will be visible on the screen even after we scroll the sheet vertically or horizontally.
Question 12) Explain workbook protection types in Excel.
Answer 12) Excel provides three ways to protect a workbook:
- Password protection for opening a workbook
- Protection for adding, deleting, hiding and unhiding sheets
- Protection from changing size or position of windows.
Read Out: Computer Science Questions and Answers
Question 13) Can we create shortcuts to Excel functions?
Answer 13) Yes. ‘Quick Access Toolbar’ above the home button can be customized to display most frequently used shortcuts.
Question 14) How can you apply the same formatting to every sheet in a workbook in MS-Excel?
Answer 14) Right Click ‘Worksheet tab’ > Choose ‘Select All Sheets’. Now any formatting done will be applied to the whole workbook. To apply to a particular group of sheets, select only those sheets that need formatting.
Question 15) To move to the previous worksheet and next sheet, what keys will you press?
Answer 15) To move to the previous worksheet, you will use the keys Ctrl + PgUp, and to move to the next sheet you will use keys Ctrl + PgDown.
Question 16) What is the quick way to return to a particular area of a worksheet?
Answer 16) The quick way to return to a specific area of the worksheet is by using name box. You can type the cell address or range name in name box to return to a specific area of a worksheet.
Question 17) What is the benefit of using formula in Excel sheet?
Answer 17) Calculating the numbers in Excel sheet, not only help you to give the final ‘sum up’ of the number but, it also calculates automatically the number replaced by another number or digit. Through Excel sheet, the complex calculations become easy like payroll deduction or averaging the student’s result.
Question 18) How cell reference is useful in the calculation?
Answer 18) In order to avoid writing the data again and again for calculating purpose, cell reference is used. When you write any formula, for specific function, you need to direct Excel the specific location of that data. This location is referred as, cell reference. So, every time a new value added to the cell, the cell will calculate according to the reference cell formula.
Also Read Out: Computer Networking Interview Questions
Question 19) What is the use of LOOKUP function in Excel?
Answer 19) In Microsoft Excel, the LOOKUP function returns a value from a range or an array.
Question 20) What could you do to stop the pivot table from loosing the column width upon refreshing?
Answer 20) Format loss in a pivot table can be stopped simply by changing the pivot table options. Under the “Pivot Table Options” turn on the “Enable Preserve Formatting” and disable “Auto Format” option.
Updated MS Excel Questions and Answers Objective as well as MS Excel Interview Questions are given above on this page of recruitmentresult.com for the individuals that are preparing for the computer awareness section of various competitive exams.
Something That You Should Put an Eye On
|Quantitative Aptitude Quiz||Online Quiz for Competitive Exams|
|Computer Hardware Engineer Salary||How to Prepare For English|