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.

recruitmentresult.com

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 ?

1. Tab
2. Ctrl+Enter
3. Enter
4. Alt+Enter

Question 2) Which of these will not select all the cells in a document ?

1. Using the Edit – Select All menu
2. Pressing Ctrl + A on the keyboard
3. Clicking three times with the right mouse button in the spreadsheet

Question 3) What term describes explanatory text attached to a cell ?

1. Context
2. Callout
3. Comment
4. Dialog

Question 4) With which of the following all formulas in excel starts ?

1. /
2. *
3. $
4. =

Question 5) The default style for new data keyed in a new workbook is ?

1. Comma
2. Normal
3. Currency
4. Percent

Read Out: Basic Internet Questions and Answers

Question 6) How we can view a cell comment ?

1. position the mouse pointer over the cell
2. click the comment command on the view menu
3. click the edit comment commands on the Insert menu
4. click the Display comment command on the window menu

Question 7) On an excel sheet the active cell in indicated by ?

1. A dotted border
2. A dark wide border
3. A blinking border
4. By italic text

Question 8) Formula palette is used to ?

1. format cells containing numbers
2. create and edit formulas containing functions
3. entered assumptions data
4. copy all cells

Question 9) A Spreadsheet contains ?

1. columns
2. rows
3. rows and columns
4. None of above

Question 10) Which among following is not associated with spelling dialogue box ?

1. Edit
2. Ignore
3. Ignore All
4. Change

Question 11) Which of the following keyboard shortcut can be used for creating a chart from the selected cells ?

1. F11
2. F10
3. F4
4. F2

Question 12) A value used in a formula that does not change is called a ?

1. Constant
2. Cell address
3. Varaible
4. Static

Get Here: MS Power Point Questions

Question 13) To open an existing workbook, click the Open button on the ___ toolbar ?

1. Form
2. Standard
3. Drawing
4. Formatting

Question 14) What term describes a background that appears as a grainy, non smooth surface ?

1. Pattern
2. Gradient
3. Texture
4. Velvet

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 ?

1. C1:10H
2. C1:H10
3. C1:H-10
4. C1:H:10

Question 16) To create an interactive Pivot Table for the web, you use a Microsoft Office Web component called ?

1. HTML
2. Pivot Table Field List
3. Pivot Table Report
4. 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 ?

1. NOT
2. OR
3. IF
4. AND

Question 18) Which among following is associated with excel ?

1. Graphic program
2. Word Processor
3. Presentation
4. Spreadsheet

Question 19) You can convert existing Excel worksheet data and charts to HTML document by using the ?

1. Internet Assistant Wizard
2. Intranet Wizard
3. Import Wizard
4. Export Wizard

Question 20) What function displays row data in a column or column data in a row ?

1. Transpose
2. Index
3. Rows
4. Hyperlinks

Question 21) Macros can be executed from the which of the following menu ?

1. Format
2. Home
3. Insert
4. Tools

Question 22) Which of the following is not a valid Zoom percentage in Excel ?

1. 10
2. 100
3. 300
4. 500

Question 23) How can we set Page Border in Excel ?

1. From Edit menu
2. From Home
3. You cannot set page border in Excel
4. From Tools menu

Question 24) Which types of charts can excel produce ?

1. Line graphs and pie charts only
2. Bar charts, line graphs and pie charts
3. Bar charts and line graphs only
4. Only line graphs

Question 25) Protection and the Protect Sheet options can be selected from ?

1. Data
2. Tools
3. Edit
4. Format

Question 26) You can check the conditions against ____ when applying conditional formatting?

1. Cell Value
2. Formula
3. Both of above
4. None of above

Question 27) Which function calculates your monthly mortage payment ?

1. PV
2. NPER
3. PMT
4. All of above

Question 28) How is data organized in a spreadsheet ?

1. Rows and columns
2. Layers and planes
3. Lines and spaces
4. Height and width

Question 29) How do you change column width to fit the contents ?

1. Single-click the boundary to the left to the column heading
2. Double click the boundary to the right of the column heading
3. Press Alt and single click anywhere in the column
4. All of above

Question 30) To drag a selected range of data to another worksheet in the same workbook, use the ?

1. Ctrl key
2. Shift key
3. Alt key
4. Tab key

Question 31) A function inside another function is known as ?

1. Round function
2. Sandwich function
3. Switch function
4. Nested function

Question 32) VLOOKUP function used to ?

1. Finds related records
2. Looks up text that contain “v”
3. Check if two cells are identical
4. None of above

Question 33) To insert three columns between columns A and B you would

1. Select column A
2. Select A and B
3. Select B
4. All of above

Question 34) You can activate a cell by ?

1. Pressing the Tab key
2. Clicking the cell
3. Pressing an arrow key
4. All of above

Question 35) Which function is used for creating a data table ?

1. Sum
2. Table
3. Add
4. Count

Question 36) 3-D reference in a formula?

1. Spans worksheets
2. Cannot be modified
3. Only appears on summary worksheets
4. Limits the formatting options

Question 37) Which among following wildcard characters are recognized by excel ?

1. + and –
2. ! and ^
3. * and ?
4. < and >

Question 38) What excel feature can you use if you want to work with one record at a time ?

1. Auto Complete
2. Data Form
3. Set Form
4. Auto Text

Question 39) The accounting style shows negative numbers in ?

1. Bold
2. Italics
3. Parentheses
4. Quotes

Question 40) Which among following is divide symbol in excel ?

1. /
2. D
3. Div
4. \

Answers:

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
• Exponent
• Multiplication
• Division
• Addition
• Subtraction

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