Skip to content

Excel MCQ Questions

0
Answered
0
Correct
0%
Accuracy
Q901 Easy

Another name for an input in a function is a(n) ________.

Argument
Property
Value
Expression
Q902 Easy

How does a user prevent circular references conflict errors?

Click on the "Enable Iterative Calculations" box
click on the "Enable All Calculations" box
Click on the "Enable All Functions" box
Click on the "Enable Circular References" box
Q903 Easy

True or False: Frequency is an array function.

False
True
Q904 Easy

What are ScreenTips in Microsoft Excel 2016?

These are the hyperlinks created in a workbook, which take a user from one worksheet to another.
These are the highlighted arrows displayed on the bottom right corner of a cell, which increase the size of a cell on dragging.
These are the small, onscreen boxes that display descriptive text when the pointer is rested on a command or control.
These are used for hiding/showing the menu bars.
Q905 Easy

The formula ISERR(A1) does not return TRUE if A1 is :

#NAME?
#REF!
Q906 Easy

To use the Subtotals feature, the list that has numbers you want to add must be:

Sorted
Converted to a table
Free of duplicates
Entered numbers and not formulas
Q907 Easy

Tables are organized into rows, called ____.

X-axis
Y-axis
Records
#NA
Q908 Easy

In pivottables, ____ fields correspond to columns in the original data.

Index
Category
Row
Summary
Q909 Easy

In Microsoft Excel 2016, if Sam wants to change the Office theme or background. then which of the following options will he use?

Export
Account
Options
Info
Q910 Easy

Which keyboard shortcut pastes copied information?

Ctrl + p
Shift + v
Ctrl + v
Ctrl + c
Q911 Easy

The formula SUMPRODUCT(a1:a4,b1:b4) is equivalent to:

(a1+b1+a2+b2+a3+b3+a4+b4)*a1
sum(a1:a4)*sum(b1:b4)
a1*b1+a2*b2+a3*b3+a4*b4
a1*b1*a2*b2*a3*b3*a4*b4
Q912 Easy

Pre-made sheet formats like Simple, Classic, Accounting, Colorful etc. can be applied from:

Format >> Cells
Table >> Autoformat
All listed
Format >> Autoformat
Q913 Easy

What does the Mod function do in an equation?

Returns zero
Returns divider
Returns divisor
Returns the remainder
Q914 Easy

An absolute cell reference _____ change when copied to another cell.

Does
Can sometimes
Will always
Does not
Q915 Easy

Which of the following is NOT a 'Solving Method' available in the Solver Add-in?

Simplex LP
GRG Nonlinear
Regression
Evolutionary
Q916 Easy

Which of the following keyboard shortcuts is used for displaying the Record Macro dialog box that is used for recording macros?

CTRL+A+R+M
CTRL+ALT+M+R
CTRL+M+R
ALT+T+M+R
Q917 Easy

How do you control which cells are printed?

Highlight the cells you want to print, go to Format, select Format Cells, and select the Border option. Then place a border around the cells you want to print.
Highlight the cells you want to print, go to File, and select Print Area => Set Print Area
Q918 Easy

To design a form using the form wizard, begin by clicking on the ____ tab on the access ribbon.

Contextual
FORMAT
Control
CREATE
Q919 Easy

How do you turn data from rows into columns in Excel?

Copy data and then use Paste Special option with Transpose box checked.
Regular Copy and Paste Process
Sort Function
You Can't
Q920 Easy

What's a quick way of rearranging the order of the worksheet tabs?

Double-click a tab, then choose the position from the pop-up message
Right-click a tab, then from the pop-up menu, click the corresponding position number where you want the tab to go
Drag them into the position you want
From the Page Layout tab, use the Sheet Order box to drag the sheets into the position you want
Q921 Easy

Spell check can be found in the _______ menu

Insert
Formula
File
Review
Q922 Easy

What will be returned by entering the following formula? =SUM({1,0,1,0,1})

#VALUE!
ERROR
5
3
Q923 Easy

The best way to automate a complex, repetitive task within a worksheet, is to create:

a page break.
a macro.
a bar chart.
a pivot table.
Q924 Easy

____ calculates the average of a range of cells.

AVERAGE: Average
MIN:
MAX:
SUM: Summation
Q925 Easy

When you sort a list of numerical value into ascending or descending order, the value in the middle of the list is the _.

Mode
Modulus
Average
Median
Q926 Easy

Which Windows Keyboard Shortcut unhides any hidden rows within the selection.

CTRL+SHIFT+&
CTRL+SHIFT_
CTRL+SHIFT+~
CTRL+SHIFT+(
Q927 Easy

To create smartart, switch to the insert tab and use a button in the ____ group.

Tables
Current Position
Press the Tab key
Illustrations
Q928 Easy

Excel includes ____ types of smartart graphics.

9
6
19
32
Q929 Easy

The definition of a macro is:

the prevention of unauthorized use.
a feature that allows the user to see how a new font or font size will look before actually applied.
a recording of commands that can be played back at any time.
an anchor which holds that value of a referenced component unchanged.
Q930 Easy

State whether the following statement regarding cell references in Microsoft Excel 2010 is true or false: A Relative cell reference consists of the column letter and row number surrounded by dollar signs ($).

True
False
Q931 Easy

It is possible to password protect content of selected cells so that cannot be modified

True
False
Q932 Easy

If cell A3 contains the text THE DEATH OF CHIVALRY, what will the function =PROPER(A3) return?

The death of chivalry
The death of Chivalry
THE DEATH OF CHIVALRY
The Death Of Chivalry
Q933 Easy

An example of a(n) ____ chart is a column chart with a line chart.

Nested
Combination
Complex
Exploded
Q934 Easy

Which worksheet function returns values along a linear trend?

TRENDLN
LINEAR
TRENDLIN
TREND
Q935 Easy

In Excel, the Insights panel displays online information and images about the text you highlighted. What is that specific control that hold the insights panel when you right click on your highlighted text?

Online Gallery
Quick analysis
Pick from dropdown list
Smart Lookup
Q936 Easy

A data ____ table describes the fields you plan to maintain in a table

Convert to Range
Two or four
Definition
Table tools design
Q937 Easy

Deleting a PivotChart report automatically deletes the associated PivotTable report.

True
False
Q938 Easy

Rows are typically represented by _______ and contain data for individual records.

Numbres
Alphabets
Nambers and alphabets
None of these
Q939 Easy

In a bar graph the horizontal axis is the:

Y-axis
Latitudinal axis
X-axis
Secondary axis
Q940 Easy

Which worksheet function returns the sum of squares of deviations?

DEVSQR
DEVSQ
SQDEV
DEVSQRT
Q941 Easy

To remove extra space from a cell, use the formula:

DELSPC(cellName)
TRIM(cellNumber)
DEL(cellName)
TRIM(cellName)
Q942 Easy

In the formula =(B6+39)/SUM(D4:F8), which part is evaluated first?

Neither is evaluated first.
Both of the above are evaluated at the same time.
SUM(B6+39)
B6+39
Q943 Easy

How many conditions can be set for an individual cell's conditional formatting?

3
Any of these
2
1
Q944 Easy

How would you search an entire workbook with Find & Select?

On the Home tab, click Find & Select > Find > Options (Windows) or Find & Select > Find (Mac). Change the Within drop-down to Workbook.
On the Home tab, click Find & Select > Find > Options (Windows) or Find & Select > Find (Mac). Change the Look in drop-down to Workbook.
On the Home tab, click Find & Select > Find > Options (Windows) or Find & Select > Find (Mac). Change the Search drop-down to All.
You cannot search an entire workbook - you must search the worksheets individually.
Q945 Easy

The Solver in MS Excel is used for what?

To find only optimal maximum solutions to linear programming problems
To find only optimal minimum solutions to linear programming problems
To find optimal minimum or maximum solutions to linear programming problems
Q946 Easy

To force cell A1 to only accept the text value which of the following is correct?

Select Cell A1 and type formula =ISTEXT(A1)
Select cell A1 in worksheet Select Data > Data Validation Validation criteria: Custom Formula: =ISTEXT(A1)
Select cell A1 in worksheet Select Data > Data Validation Validation criteria: Text length Data: greater than equal to Minimum: 1
Select cell A1 in worksheet Select Data > Data Validation Validation criteria: Text length Data: greater than Minimum: 1
Q947 Easy

What is the function of the word "=SUM" at the beginning of an Excel spreadsheet formula?

To calculate all the data correctly without any mistakes
To tell the person viewing that this is a function and it should be added together
To add all the data together using addition only
To inform the computer that an arithmetic function will occur
Q948 Easy

In Excel, you can choose a picture as the background of a:

Cell, or comment or sheet.
Comment, but not a cell.
Only sheets can have background pictures.
Cell, or a comment.
Q949 Easy

What will the formula =A1*C1 return?

B1
The sum of A1 and C1
An error
The product of A1 and C1
Q950 Easy

In the formula =if(a1=b1, c1, c2), the result will be c2 if ____.

A is equal to B
A does not equal B
A1+B1 is equal to C1
None of the above
Showing 950 of 1421 questions

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

Report a mistake

What's wrong?