MS Office MCQs

MS Excel MCQs | Advance Excel MCQ

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.

More MCQs
HOME
Categories
Computer Science
Microsoft Office MCQs

» MS Word MCQs
» MS PowerPoint MCQs
» MS Access MCQs

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.

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.

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

The basic components of an Excel workbook include the following except:

1. Workbook
2. Row
3. Search bar.
4. Name box.

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

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

Microsoft Excel opens a new workbook with how many default worksheets?

1. Only one worksheet
2. Three worksheets
3. Five worksheets
4. Unlimited worksheets

A template is a ___________ workbook designed for a specific purpose such as tracking sales or budgeting.

1. Blank
2. Preformatted
3. Animated
4. None

The Keyboard shortcut key for Print Preview is:

1. CTRL + P
2. Alt + F4
3. CTRL + F2
4. None

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.

In MS Excel you can enter data as:

1. Numbers
2. Dates
3. Times
4. All of the above.

To enter a number as text in Microsoft Excel worksheet, start the entry with:

1. Apostrophe
2. Hyphen
3. Plus sign
4. Inverted comma

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

The basic unit of a Microsoft Excel worksheet into which you enter data is called:

1. Tab
2. Range
3. Address
4. Cell

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

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

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

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

The horizontal and vertical lines on Microsoft Excel worksheet are called:

1. Gridlines
2. Rows and columns
3. Margins
4. Boundaries

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

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

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

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

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.

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

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.

Underlining: The quickest method is to use a keyboard shortcut:

1. CTRL +B
2. CTRL +I
3. CTRL +U
4. None

Bold text: The quickest method is to use a keyboard shortcut:

1. CTRL +I
2. CTRL +B
3. CTRL +U
4. None

Which of the following is an option of ‘Merge cells’?

1. Merge and center
2. Merge across
3. Both A&B
4. None

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

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

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

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

Column width can be specified between:

1. 0 and 128
2. 0 and 255
3. 0 and 256
4. None

By default, MS Excel shows ______ characters in a column

1. 43
2. 10
3. 55
4. None

Column width of ‘zero’ will ______ the column.

1. Delete
2. Shrink
3. Highlight
4. Hide

Row height can be set between:

1. 0 and 128
2. 0 and 409
3. 0 and 500
4. None

By default, Row height is set at:

1. 43 Points
2. 55 Points
3. 75
4. None

Row height of ‘zero’ will hide the row.

1. Delete
2. Hide
3. Highlight
4. Shrink

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

The following are Freeze panes action except:

1. Freeze entire workbook
2. Freeze First Column
3. Freeze Top Row
4. Freeze Panes

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

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

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

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

Which of the following is a ‘Paste Special’ settings?

1. Formulas
2. Values
3. Comments
4. All of the Above

Keyboard shortcut key for Past Special dialog box is:

1. CTRL+ALT+V
2. CTRL+V
3. Both A&B
4. None

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

Customs number format can have up to _______ code sections separated by semicolons.

1. Four
2. Six
3. Eight
4. None

Custom number format dialog Box Launcher can be seen next to ________ on the Home tab.

1. Alignment
2. Number
3. Cells
4. Editing

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

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

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 + %

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

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

Keyboard shortcut CTRL +G lunches:

1. Go To Special dialog box
2. Disable Gridlines
3. Find and Replace dialog box
4. None

Which of the following is a ‘Go To Special’ option?

1. Hidden cells
2. Visible cells only
3. Current region
4. Both B&C

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

All formulas must start:

1. Without equals (=) sign
2. With equals (=) sign
3. Both A&B are correct
4. None

Formulas are constructed using:

1. Functions
2. Cell references
3. Operators
4. All of the above

In the formula = A14 / B14 + C5 – D6 * F6 which calculation is performed first?

1. Division
2. Multiplication
3. Subtraction
4. Addition

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

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

“Pi ()” is an example of a:

1. Operator
2. Constant
3. Function
4. None

The following are examples of an operator except:

1. * (multiply)
2. + add
3. ^ raise to the power of
4. Equals (=) sign

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

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

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

=PERCENTILE (C1:C1000,0.2) would return the:

1. 80^th percentile
2. 20^th percentile
3. 50^th percentile
4. None

=QUARTILE (C1:C1000,3) would return the:

1. 75^th percentile
2. 30^th percentile
3. 50^th percentile
4. None

=STDEV.S() Returns:

1. Actual Deviation
2. Standard Deviation
3. Results in an error
4. None

= TODAY () Returns the:

1. Current date
2. Current time
3. Current date and time
4. None

=NOW () Returns the current time

1. Current date
2. Current time
3. Current date and time
4. None

What will be the result of Microsoft Excel function =MOD(7,2) ?

1. 5
2. 4
3. 3
4. 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

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

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

Each IS function checks the specified value and returns:

1. Correct or Incorrect
2. True or False
3. Good or Bad
4. None

Which of the following is an example of IS function?

1. ISERROR
2. ISLOGICAL
3. ISNONTEXT
4. All of the above

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

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

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

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)

The syntax of SUMIF is:

1. SUMIF (number1, [number2], …)
2. SUMIF (sum_range, criteria_range1, criteria1, …)
3. SUMIF (range, criteria, [sum_range])
4. None

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

Examples of storing data in an external data source include:

1. Text files
2. Databases
3. OLAP
4. All of the above

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

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

Microsoft Excel cells that you cannot change values in are called:

1. Saved cells
2. Closed cells
3. Protected cells
4. Hidden cell

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

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

To Remove “Mark as Final’ Click:

1. Enable Edit button
2. Edit Anyway button
3. Turn on Edit button
4. None

How many maximum characters are possible in Microsoft Excel password?

1. 8
2. 10
3. 12
4. 15

Microsoft __________ forgotten passwords.

1. Can retrieve
2. Cannot retrieve
3. Resets
4. None

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

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

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

Which of the following is ‘share workbooks’ process?

1. Share workbook
2. Protect shared workbook
3. Verify links
4. All of the above

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

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

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———

MS Excel MCQs | Advance Excel MCQ

SHARE THIS

MS Excel MCQs

Leave a Reply Cancel reply

Join us

Recent Post

Financial Ratios and Ratio Analysis MCQs

MCQs on Risk Management

MCQs on Strategic Control – Performance measurement

Follow us

Sign up for Free MCQs

MS Excel MCQs | Advance Excel MCQ

SHARE THIS

MS Excel MCQs

Leave a Reply Cancel reply

Join us

Recent Post

Financial Ratios and Ratio Analysis MCQs

MCQs on Risk Management

MCQs on Strategic Control – Performance measurement

Follow us

Sign up for Free MCQs

Welcome to the Club

Log in to continue. IT'S FREE