MS Excel MCQs | Advance Excel MCQ

Share on facebook
Share on twitter
Share on linkedin
Share on pinterest
Share on reddit
Share on whatsapp

SHARE THIS

Microsoft Excel was released in the year 1985. Excel is one of the most important computer programs because of the key role it plays in many sectors.

MS Excel MCQs

Microsoft Excel was released in the year 1985. Excel is one of the most important computer programs because of the key role it plays in many sectors. Here on MCQs.club we provide easily understood excel mcq questions and answers. The advance Excel mcq question with answer are also given below. Our designed MS Excel mcq are useful for competitive exams. Microsoft Excel is the most used spreadsheet program in many business activities, classwork and even personal data organization.

  1. Which of the following is not a use of Microsoft Excel?
    1. Manage personal finances.
    2. Manage business finances.
    3. Animate your slides to give them greater visual impact.
    4. Create a calendar.
  1. A workbook is a file that contains __________ worksheets (also called spreadsheets) that can be used to organize various kinds of related information.
    1. Only one.
    2. Three
    3. One or more.
    4. None
  1. The basic components of an Excel workbook include the following except:
    1. Workbook
    2. Row
    3. Search bar.
    4. Name box.
  1. You can press CTRL +N whilst in an existing workbook to quickly create a new, blank workbook
    1. CTRL +N
    2. CTRL +O.
    3. CTRL +Esc.
    4. None
  1. If Excel is already open click New + Blank workbook on the File tab. This will:
    1. Replace the already opened workbook.
    2. Closes the already opened workbook.
    3. Open a new workbook in addition to the already open workbook.
    4. None
  1. Microsoft Excel opens a new workbook with how many default worksheets?
    1. Only one worksheet
    2. Three worksheets
    3. Five worksheets
    4. Unlimited worksheets
  1. A template is a ___________ workbook designed for a specific purpose such as tracking sales or budgeting.
    1. Blank
    2. Preformatted
    3. Animated
    4. None

  1. The Keyboard shortcut key for Print Preview is:
    1. CTRL + P
    2. Alt + F4
    3. CTRL + F2
    4. None
  1. There are numerous options for manually entering data into worksheet cells. Data can be entered:
    1. One cell at a time.
    2. In several cells at the same time.
    3. More than one worksheet at the same time.
    4. All of the above.
  1. In MS Excel you can enter data as:
    1. Numbers
    2. Dates
    3. Times
    4. All of the above.
  1. To enter a number as text in Microsoft Excel worksheet, start the entry with:
    1. Apostrophe
    2. Hyphen
    3. Plus sign
    4. Inverted comma
  1. It is a feature of Microsoft Excel that works behind the scenes, correcting different types of common mistakes.
    1. Spelling
    2. AutoFormat
    3. AutoEdit
    4. AutoCorrect
  1. The basic unit of a Microsoft Excel worksheet into which you enter data is called:
    1. Tab
    2. Range
    3. Address
    4. Cell
  1. You can sort data in Microsoft Excel table using which of the following techniques?
    1. Click the Sort & Filter button on the Home tab on the ribbon
    2. Right-click the table and then point to Sort on the shortcut menu
    3. Use the sort button on the Data tab on the ribbon
    4. Any of the above methods may be used

  1. To enter a time or date that stays current when you reopen a worksheet use the:
    1. TIME function.
    2. DATE function.
    3. NOW or TODAY function.
    4. None
  1. If today is Saturday then what will be the result of this Microsoft Excel function =WEEKDAY (TODAY (),1)
    1. Monday
    2. Saturday
    3. 1
    4. 7
  1. Which keyboard key is used to display a key tip badge in Microsoft Excel?
    1. Esc key
    2. Alt key
    3. Ctrl key
    4. Home key
  1. The horizontal and vertical lines on Microsoft Excel worksheet are called:
    1. Gridlines
    2. Rows and columns
    3. Margins
    4. Boundaries
  1. The number of Microsoft Excel worksheets that you can add to a workbook is:
    1. 156
    2. 256
    3. 16384
    4. Limited by the available amount of memory
  1. In Microsoft Excel, the small black square located in the lower-right corner of the heavy border around the active cell is called:
    1. Fill handle
    2. Range handle
    3. Resize handle
    4. View handle
  1. CTRL +D is used to copy a cell:
    1. Downwards across a highlighted range
    2. Right across a highlighted range
    3. To another worksheet
    4. None

  1. CTRL +R is used to copy a cell:
    1. Downwards across a highlighted range
    2. Right across a highlighted range
    3. To another worksheet
    4. None
  1. keyboard shortcut________ is used to add spacing between lines or paragraphs of text in a cell.
    1. ALT +Enter.
    2. CTRL +Enter.
    3. Enter.
    4. None.
  1. In Microsoft Excel a sheet background is used for display purposes only and is:
    1. Printable
    2. Not printable
    3. Printable with fixed width
    4. None
  1. In MS Excel to add a background to Click Background within the Page Setup group on the:
    1. Home tab
    2. Insert tab.
    3. View tab.
    4. Page layout tab.
  1. Underlining: The quickest method is to use a keyboard shortcut:
    1. CTRL +B
    2. CTRL +I
    3. CTRL +U
    4. None
  1. Bold text: The quickest method is to use a keyboard shortcut:
    1. CTRL +I
    2. CTRL +B
    3. CTRL +U
    4. None
  1. Which of the following is an option of ‘Merge cells’?
    1. Merge and center
    2. Merge across
    3. Both A&B
    4. None

  1. Merge and center option merge all selected cells into a single cell retaining only the contents of the:
    1. left-most cells
    2. upper-left most cell
    3. Bottom-most cells
    4. Both B&C
  1. Merge across option merges selected cells on a line by line basis, retaining only the contents of the:
    1. left-most cells
    2. upper-left most cell
    3. Bottom-most cells
    4. Both B&C
  1. When a cell contains a number or a date and the width of its column cannot display all the characters that its format requires you will see _________displayed.
    1. ####
    2. ????
    3. ?!?!?
    4. None
  1. The default top and bottom page margins in Microsoft Excel for both portrait and landscape orientation is:
    1. 50 inch
    2. 75 inch
    3. 25 inch
    4. 50 inch
  1. Column width can be specified between:
    1. 0 and 128
    2. 0 and 255
    3. 0 and 256
    4. None
  1. By default, MS Excel shows ______ characters in a column
    1. 43
    2. 10
    3. 55
    4. None
  1. Column width of ‘zero’ will ______ the column.
    1. Delete
    2. Shrink
    3. Highlight
    4. Hide

  1. Row height can be set between:
    1. 0 and 128
    2. 0 and 409
    3. 0 and 500
    4. None
  1. By default, Row height is set at:
    1. 43 Points
    2. 55 Points
    3. 75
    4. None
  1. Row height of ‘zero’ will hide the row.
    1. Delete
    2. Hide
    3. Highlight
    4. Shrink
  1. Freeze panes and Split panes options can be seen within the: ____________
    1. Cells group on the Home tab.
    2. Workbook views group on the View tab.
    3. Window group on the View tab.
    4. Both B&C
  1. The following are Freeze panes action except:
    1. Freeze entire workbook
    2. Freeze First Column
    3. Freeze Top Row
    4. Freeze Panes
  1. To split a merged cell in Microsoft Excel, select the cell and click the following option on Home tab:
    1. Split
    2. Split and Merge
    3. Merge and Center
    4. Split and Center
  1. Which of the following is true for ‘Hide worksheets’ feature?
    1. Hide feature closes the worksheet
    2. Hide feature erases the worksheet
    3. Hidden worksheet disappears but remains active in memory
    4. None

  1. The Hide/Unhide worksheet feature can be seen under: __________
    1. Background in the Page setup group on the Page layout tab
    2. Sheet option in Page layout tab
    3. Cells style in the Styles group on the Home tab
    4. Format in the Cells group on the Home tab
  1. Which of the following is the command for moving and copying cells and their contents?
    1. Cut
    2. Copy
    3. Paste
    4. All of the above
  1. Which of the following is a ‘Paste Special’ settings?
    1. Formulas
    2. Values
    3. Comments
    4. All of the Above
  1. Keyboard shortcut key for Past Special dialog box is:
    1. CTRL+ALT+V
    2. CTRL+V
    3. Both A&B
    4. None
  1. Which of the following you can enter as ‘custom number’ format code.
    1. Positive values
    2.  Negative values
    3.  Zero values
    4. All of the above
  1. Customs number format can have up to _______ code sections separated by semicolons.
    1. Four
    2. Six
    3. Eight
    4. None
  1. Custom number format dialog Box Launcher can be seen next to ________ on the Home tab.
    1. Alignment
    2. Number
    3. Cells
    4. Editing

  1. Microsoft Excel provides a special number format that allows a number to be entered as a Phone number. This is available as a ‘special’ number format accessible from which of the following dialog box.
    1. Paste Special dialog box
    2. Font Settings dialog box
    3. Number Format dialog box
    4. None
  1. In MS Excel, if the number format of a cell has been customized to “+##-42####-####” and 12325678 is entered in the cell, it will be displayed as:
    1. +12-42-3256-78
    2. 42-1232-5678
    3. +12-42-3256-78##
    4. +-42-1232-5678
  1. To apply a percent style format to a cell in Microsoft Excel using shortcut keys, press the following:
    1. Alt + %
    2. Alt + Shift + %
    3. Ctrl + %
    4. Ctrl + Shift + %
  1. Which of the following is a use of Conditional formatting?
    1. Identifying overdue customer accounts.
    2. Identifying variances.
    3. Which sales clerks achieved PKR 300,000 sales this month.
    4. All of the above
  1. In Microsoft Excel, when all the numbers between 0 and 100 in a range are to be displayed in Red Color, you may apply the following:
    1. Use = if () function to format the required numbers red
    2. Apply Conditional Formatting option from Home tab
    3. Select the cells that contain number between 0 and 100 then click Red color on Text Color tool
    4. Any of the above method may be used
  1. Keyboard shortcut CTRL +G lunches:
    1. Go To Special dialog box
    2. Disable Gridlines
    3. Find and Replace dialog box
    4. None
  1. Which of the following is a ‘Go To Special’ option?
    1. Hidden cells
    2. Visible cells only
    3. Current region
    4. Both B&C

  1. Sometimes it may be difficult to locate hidden columns or rows. To locate them you can use the __________ command under Go To Special dialog box.
    1. Hidden cells
    2. Visible cells only
    3. Current region
    4. None
  1. All formulas must start:
    1. Without equals (=) sign
    2. With equals (=) sign
    3. Both A&B are correct
    4. None
  1. Formulas are constructed using:
    1. Functions
    2. Cell references
    3. Operators
    4. All of the above
  1. In the formula = A14 / B14 + C5 – D6 * F6 which calculation is performed first?
    1. Division
    2. Multiplication
    3. Subtraction
    4. Addition
  1. It checks the formulas of Microsoft Excel workbook in a manner similar to the spell checker that checks misspelled words.
    1. Formula checker
    2. Calculation checker
    3. Arithmetic checker
    4. Math checker
  1. To create an exact copy of Microsoft Excel formula without replication, hold down the following key while dragging the fill handle.
    1. Ctrl key
    2. Alt key
    3. Shift key
    4. TAB key

  1. “Pi ()” is an example of a:
    1. Operator
    2. Constant
    3. Function
    4. None
  1. The following are examples of an operator except:
    1. * (multiply)
    2. + add
    3. ^ raise to the power of
    4. Equals (=) sign
  1. There are almost limitless numbers of constants and operators that can be used in a formula, subject to a maximum ________ characters.
    1. 10,000
    2. 8192
    3. 6245
    4. 4819
  1. Nested formulas mean and include ________________ as their arguments.
    1. Formulas within other formulas
    2. Operators within formulas
    3. Constants within formulas
    4. Functions within formulas
  1. You can set Microsoft Excel in Automatic or Manual calculation mode. If it is in manual mode which key you will press to update the formula values of all worksheets in all open workbooks?
    1. F6
    2. F9
    3. F11
    4. F12
  1. =PERCENTILE (C1:C1000,0.2) would return the:
    1. 80th percentile
    2. 20th percentile
    3. 50th percentile
    4. None
  1. =QUARTILE (C1:C1000,3) would return the:
    1. 75th percentile
    2. 30th percentile
    3. 50th percentile
    4. None

  1. =STDEV.S() Returns:
    1. Actual Deviation
    2. Standard Deviation
    3. Results in an error
    4. None
  1. = TODAY () Returns the:
    1. Current date
    2. Current time
    3. Current date and time
    4. None
  1. =NOW () Returns the current time
    1. Current date
    2. Current time
    3. Current date and time
    4. None
  1. What will be the result of Microsoft Excel function =MOD(7,2) ?
    1. 5
    2. 4
    3. 3
    4. 1
  1. IRR Returns the internal rate of return for a series of cash flows.
    1. Internal rate of return
    2. Payback period
    3. Net present value
    4. None
  1. NPV Returns the __________ of an investment based on a series of periodic cash flows and a discount rate.
    1. Internal rate of return
    2. Payback period
    3. Net present value
    4. None
  1. SLN Returns the ___________ of asset for a specified period.
    1. Sum of digits method deprecation
    2. Straight-line deprecation
    3. Both A&B
    4. None

  1. Each IS function checks the specified value and returns:
    1. Correct or Incorrect
    2. True or False
    3. Good or Bad
    4. None
  1. Which of the following is an example of IS function?
    1. ISERROR
    2. ISLOGICAL
    3. ISNONTEXT
    4. All of the above
  1. The VLOOKUP function is used to search the _________ of a range of cells and then returns a value from any cell on the same row of the range.
    1. First Row
    2. First Column
    3. Entire worksheet
    4. None

80.Which of the following Microsoft Excel function is used when the table direction is horizontal, or across the worksheet?

    1. VLOOKUP
    2. HLOOKUP
    3. ALOOKUP
    4. WLOOKUP
  1. The HLOOKUP function is used to search the ________ of a range of cells and then returns a value from any cell in the same column of the range.
    1. First Column
    2. First Row
    3. Entire worksheet
    4. None
  1. You may use the following Microsoft Excel function on formulas that potentially can result in more decimal places than the format display in a given cell.
    1. AVERAGE
    2. ROUND
    3. DECIMAL
    4. FIT

  1. The general syntax of the IF function of Microsoft Excel is:
    1. IF(value_if_true, logical_test, value_if_false)
    2. IF(logical_test, value_if_false, value_if_true)
    3. IF(value_if_false, logical_test, value_if_true)
    4. IF (logical_test, value_if_true, value_if_false)
  1. The syntax of SUMIF is:
    1. SUMIF (number1, [number2], …)
    2. SUMIF (sum_range, criteria_range1, criteria1, …)
    3. SUMIF (range, criteria, [sum_range])
    4. None
  1. In Microsoft Excel “What IF analysis” is carried out using the following tool:
    1. Value Seek
    2. IF Seek
    3. Track Seek
    4. Goal Seek
  1. Examples of storing data in an external data source include:
    1. Text files
    2. Databases
    3. OLAP
    4. All of the above
  1. You can export data to a text file simply by saving the worksheet with a:
    1. .txt file-type
    2. .csv file-type
    3. .xml file-type
    4. Both A&B only
  1. Microsoft Excel offers a hierarchy of security features enabling users to protect their work. Users can protect:
    1. Cells
    2. Worksheets
    3. Entire workbooks
    4. All of the above
  1. Microsoft Excel cells that you cannot change values in are called:
    1. Saved cells
    2. Closed cells
    3. Protected cells
    4. Hidden cell

  1. When a workbook is marked as final it becomes read-only. This means that:
    1. Typing, editing commands and proofing marks are disabled and turned off.
    2. Workbook is encrypted
    3. Both A&B
    4. None
  1. When a workbook is marked as final the options without editorial rights are still enabled such as:
    1. Home – Find & Select
    2. Review – Show All Comments
    3. View – Zoom
    4. All of the above
  1. To Remove “Mark as Final’ Click:
    1. Enable Edit button
    2. Edit Anyway button
    3. Turn on Edit button
    4. None
  1. How many maximum characters are possible in Microsoft Excel password?
    1. 8
    2. 10
    3. 12
    4. 15
  1. Microsoft __________ forgotten passwords.
    1. Can retrieve
    2. Cannot retrieve
    3. Resets
    4. None
  1. A digital signature is used to sign the Microsoft Excel workbook in a similar way to signing a paper document for authentication purpose. The digital signature:
    1. Cannot be displayed anywhere on the workbook instead it is stored only inside the Microsoft Excel file
    2. Can also implement password protection
    3. Marks the workbook as final so that it becomes read only
    4. All of the above
  1. Digital signatures can be used to sign important documents electronically. Which of the following is a type of digital signature?
    1. Visible
    2. Invisible
    3. Both A&B
    4. None

  1. With Microsoft Excel workbook sharing enabled, which of the following is/are disabled for the workbook?
    1. Merge cells
    2. Removing passwords
    3. Creating data tables
    4. All of the above
  1. Which of the following is ‘share workbooks’ process?
    1. Share workbook
    2. Protect shared workbook
    3. Verify links
    4. All of the above
  1. In Microsoft Excel all shared workbook users:
    1. Have full control in shared workbook
    2. Can only edit existing data available in shared workbook
    3. Can change only merged cells
    4. None of the above
  1. Microsoft Excel has a feature of shared workbook. Sometimes many users have changed the contents of the same cell causing a conflict. In this conflicting situation Microsoft Excel will:
    1. Keep the first change
    2. Keep the last change
    3. Discard all the changes and keep original contents
    4. Inform the user for conflict
  1. Which is the correct method to unprotect Microsoft Excel workbook?
    1. On Review tab click “Protect Workbook”
    2. On Review tab click “Unprotect Workbook”
    3. On Protect tab click “Unprotect Workbook”
    4. On Page Layout tab click “Unprotect Workbook”

———more to come soon———

Read more
Read more
Read more
Read more
Read more
Read more
Read more
Read more
Read more
Read more
Read more
Read more
Read more
Read more

One Response

Leave a Reply

Sign up for Free MCQs

MCQs Club

Log in to continue. IT'S FREE

OR

Don’t have an account? Sign up