Skip to content

Excel MCQ Questions

0
Answered
0
Correct
0%
Accuracy
Q651 Easy

How do you change all positive numbers in a sheet to negatives?

Write -1 anywhere in the sheet, copy it, select the data to change, Paste Special, select Multiply
Type everything again with a - sign
Select - and Press Enter
Delete the numbers and reenter
Q652 Easy

If you didn't assign a macro to a button, keystroke or to run automatically, how can you run the macro?

From the File Open dialog box, find the macro you want, then open it.
In the Developer tab, click Macros, then double-click the macro you want to run.
Press Ctrl + Shift + M, select the macro you want, then click Execute.
You can't. Macros run only from buttons, keystrokes, and automatically.
Q653 Easy

State whether true or false:For XY (Scatter) and bubble charts; error bars for the x values, the y values, or both, can be displayed.

True
False
Q654 Easy

In Microsoft Excel 2016, which of the following statements are correct about a Pivot chart?1. A Pivot chart is a graphical depiction of a data summary.2. You cannot create a Pivot chart without a Pivot table.3. You can create a Pivot table and a Pivot chart at the same time.

All 1, 2, and 3
Only 1 and 2
Only 1 and 3
Only 2 and 3
Q655 Easy

The Char() formula does the reverse of which worksheet formula?

Code()
IsNumber()
Hex2Dec()
Text()
Q656 Easy

Mark inserts an image into a current worksheet. His client demands that the image should be attached with a cell and should resize when the cell is resized. Which of the following options is the correct Format Picture property, which will fulfil this requirement?

Move and Size with Cells
Fit in Cells
Stitch with Cells
Cell Bounded
Q657 Easy

What are the Report categories in Excel?

Summary − General information about the structure and content of the Workbook
Workbook (with subcategories) − General Workbook Statistics
Formulas (with subcategories) − Specific information about formulas in the Workbook
Cells (with subcategories) − Specific information about the cells in the Table
Q658 Easy

Excel 2013 automatically arranges any two workbooks __________, when comparing them.

vertically
horizontally
diagonally
None of these
Q659 Easy

You probably have Excel 2013 on your computer if you have any of the following installed, EXCEPT:

Microsoft Office Home and Student 2013
Microsoft Office Home and Business 2013
Google Sheets
Microsoft Office Professional 2013
Q660 Easy

Daniel groups three sheets: Q1, Q2 and Q3, containing sales data. What will happen on deleting the data of cell B2 from sheet Q1?

A warning message will be displayed.
Data cannot be deleted when sheets are grouped.
Data of cell B2 will also be deleted from sheets Q2 and Q3.
None of the above.
Q661 Easy

True or False: Excel has the capability to sort horizontally from left to right or right to left.

False
True
Q662 Easy

Before applying a conditional format in a report, the ____ box must be selected.

Field labelb
Captionc.
Field valued.
Design
Q663 Easy

A cell containing a formula that references other cells is said to have ____.

Precedents
Dependant
Both
Q664 Easy

The formula =VLOOKUP(A1,B2:D100,3,0) returns a result from column:

D
C
A
B
Q665 Easy

Normal view shows how the worksheet will appear when printed. _________________________

True
False
Q666 Easy

What formula generates a fractional number that is greater than 0 and less than 1?

0.685967481741414
0
Q667 Easy

From which field list was the pivotTalble created?

Rows:event, donor / values: Sum of amount
Columns: event / row:donor / values: Sum of amount
Rows:donor, event / values: Sum of amount
Filter: event / row:donor / values: Sum of amount
Q668 Easy

The auto calculate feature in Excel does which of the following?

Can only add values in a range of cells
Provides a quick way to view the result of an arithmetic operation on a range of cells
Automatically creates formulas and adds them to a worksheet
None of the above
Q669 Easy

If either ____ or sharing is enabled, excel enables the other by default.

Distributing
Formatting
Collaborating
Tracking
Q670 Easy

A(n) ____________________ conveys a visual representation of data.

Icon
Chart
Data
Information
Q671 Easy

Two common wildcard characters that Excel recognizes are

< and >
+ and -
* and ?
^ and /
Q672 Easy

What happens when you push F1 button

Opens Help menu
Save
Saves as
Q673 Easy

Which of the following is true for dates and times (choose all that apply)

Excel treats dates and times as special types of numeric values
Excel handles dates by using a serial number system
The earliest date that Excel understands is January 1, 1900
Dates cannot be compared with each other in Excel
Q674 Easy

The path to the sum button is ____.

Formats, numbers, formulas
ALT + ENTER
Test data
Home tab / Editing
Q675 Easy

Select Home->Fill->Series. Excel displays the Series dialog box. Which of the following represent the "Growth" type?

finds the next series value by multiplying the preceding value by the step value
finds the next series value by adding the step value
creates a series of dates
None of the above
Q676 Easy

The function =VLOOKUP("Widget",D4:E9,2,False) is correct format

False
True
Q677 Easy

What is the Programming Language we use to write the macros in Excel?

VB Script
C Language
VB (Visual Basic)
Java
Q678 Easy

True or False: Numbers in Excel can assume many different formats: date, time, percentage, or decimals.

False
True
Q679 Easy

When you have multiple sheets in an excel workbook and want to look at two of them at the same time,you should click:

View->Arrange all windows (vertical)
View->New Window View->Arrange all windows (vertical)
View->Split
Q680 Easy

True or False: You can delete data in a cell by hitting the delete key in the keyboard.

False
True
Q681 Easy

The default view for a worksheet is ____.

Normal view
Standard view
Page view
Basic view
Q682 Easy

Which is a valid Excel formula?

#VALUE!
#VALUE!
Q683 Easy

Given range of cells A1:A100, select the formula that would return the 3rd lowest value from the selected range.

#VALUE!
#VALUE!
Q684 Easy

In Excel 2013, what will happen if you select arow heading, right-click and select the option,Insert?

A new row will be inserted above the selected row.
A new row will be inserted below the selected row.
Irrespective of the selected row, a new row will be inserted at the top of the table.
None of the above.
Q685 Easy

When you are typing information,how are going to type 005 in a cell(after enter typed 005 should look the same 005)?

*005
'005
005
Q686 Easy

The formula in cell C2 is =$A$3*B3. When you copy it to D2, the formula in D2 will be:

$A$3*B3
$B$3*C3
$A$3*D3
$A$3*C3
Q687 Easy

When creating a dual-substitution data table, where must you put the formula that the table is based on?

In the row just above the table
In cell A1
On the same worksheet
In the upper-left corner of the table
Q688 Easy

Each worksheet has a sheet name that appears on a(n) ____ at the bottom of the workbook.

Sheet tab
Office Button
Formula bar
Normal view
Q689 Easy

Excel treats ____ as graphic objects that can be moved, resized, and formatted.

Slicers
PivotTables
Data markers
PivotCharts
Q690 Easy

When a formula references cells that are affected by the same formula, what type of error results?

A circular reference.
#DIV/0!
Text error.
Boundary error.
Q691 Easy

What would you use to only view the rows in a spreadsheet that meet the criteria you want?

Auto Complete
Find
Auto Filter
Goal Seek
Q692 Easy

____ makes it easier to enter repetitive text in cells.

Editing mode
AutoFit
AutoComplete
AutoFill
Q693 Easy

How would you ensure that B1 divided by A1 always equals zero when the value of A1 is zero?

#VALUE!
0
Q694 Easy

An adjacent range is a collection of separate ranges. _________________________

True
False
Q695 Easy

Can macros close currently open worksheets?

No
Yes
Q696 Easy

Which function returns the number of characters in a text string in cell A1?

#VALUE!
7
Q697 Easy

How many arguments exist in the IF function?

5
2
4
3
Q698 Easy

Microsoft does not support the automatic removal of hidden information for signed or protected documents, or for documents that use Information Rights Management (IRM). The Document Inspector has modules that help users inspect and fix specific elements of a given document. Which of the following is not Excel built-in document inspector module?

Document Properties and Personal Information
External Links and Data Functions
Custom Worksheet Properties
None of the above
Q699 Easy

True or False: You can undo several recent actions at once.

True
False
Q700 Easy

How should blank cells be inserted on a Worksheet?

Select the cell or the range of cells. Then on the Home tab, in the Cells group, click 'Insert Cells'
Select the cell or the range of cells. Then right-click on the selected cells and click on Insert in the shortcut menu
Both a and b
None of the above
Showing 700 of 1421 questions

Teachers: using these Excel questions with a class? Tell us about your class.

Report a mistake

What's wrong?