Skip to content

Excel MCQ Questions

0
Answered
0
Correct
0%
Accuracy
Q501 Easy

Formulas created using the point-and-click method contain ____ references.

Absolute
Mixed
Relative
Relational
Q502 Easy

How can you set 0.5 inch left indentation for a cell in Excel?

This is impossible.
Indentation can be set from Format Cells box.
The indentation can be specified only when printing.
This is possible, but the answer is not listed here.
Q503 Easy

Which worksheet function returns the negative binomial distribution?

NGBNDIST
NBINOMDIST
NEGBINOMDIST
NEGBINDIST
Q504 Easy

Error messages begin with the _____ symbol.

#
Assumptions
<>
True
Q505 Easy

If you place the cursor in cell A2 which contains text and press the keystrokes CTRL-B / CTRL-I / CTRL-U the result will be:

Text is copied up to cells B1 and I1
Cell A2 and all cells under it are made bold and italic
All cells in worksheet are Book Antiqua font, in italics and underlined
Text in cell A2 is bold, in italics and underlined
Q506 Easy

A ___ is similar to a data bar in that it compares the relative values of cells in a range. Instead of bars in each cell, you see cell shading, where the shading color reflects the cell’s value?

color bar
color scale
color cell
color range
Q507 Easy

To select nonadjacent changing cells, press and hold the _______ key as you click each cell.

Alt
Ctrl
Esc
Shift
Q508 Easy

To ensure that a collection of shapes are evenly spaced apart from left to right, select the shapes, click Page Layout > Align, and then click _.

Distribute Horizontally
Align Center
Distribute Vertically
Align Middle
Q509 Easy

Which character always appears in formulas with external references?

*
^
!
&
Q510 Easy

In which tab is located the Proofing group?

View Tab
Data Tab
Review tab
Q511 Easy

True of False: You can filter an Excel Pivot chart so that it shows only the information you want it to show.

False
True
Only by creating completely new pivot tables
You can only filter subsets in a Pivot table
Q512 Easy

The standard name of each cell is based on its ___________ and __________

Level and priority
Row and column
Age and sequence
Height and width
Q513 Easy

____ shows you how a fill color will look before you apply it.

Sneak Peek
Live Preview
Quick Look
Advance Look
Q514 Easy

What's the function for calculating variance?

VAR
VARIANCE
VARI
It does not exist
Q515 Easy

Which can format cell contents according to predetermined conditions?

Conditional formatting
Cell color
Format
None of these options
Q516 Easy

Which keyboard shortcut applies strikethrough to selected cells in Excel?

ALT+F9
CTRL+ALT+F10
SHIFT+F5
CTRL+5
Q517 Easy

A cell is referred to by its cell ____.

Reference
Included
Absolute
Function
Q518 Easy

How can an interactive chart be created?

With Form Controls, or with Active-X Controls, or with Custom VBA Userforms
Only with Custom VBA Userforms
Only with Form Controls
Only with a third-party add-in
Q519 Easy

________ is the process of arranging data in a specific order based on the value in a field.

IF function
NOW function
Function
SUM function
Q520 Easy

Anytime when you return more than a single cell, you should be using array formula. Array formulas are special formulas that work on an array of numbers and it will work effectively if you press the following keys combination?

Ctrl+Enter
Ctrl+Shift+Enter
Ctrl+F5
None of the above
Q521 Easy

Which of the following methods would you follow to remove subtotals?

On the Data tab, in the Outline group, click on Subtotal. The Subtotal dialog box is displayed. Click Remove All
On the Data tab, in the Data Tools, select Remove Subtotals
Both a and b
None of the above
Q522 Easy

What happens when you use the combination Ctrl+Space

Marks a whole column
Marks a whole row
Q523 Easy

Which Excel tool turns a list of text into a diagram made of shapes, such as a process or a hierarchy?

Slicer
SmartArt
Macros
Q524 Easy

In the formula =VLOOKUP(A1,D1:H30,3,FALSE), the lookup value (A1) is being looked for in _.

Column D
Columns D through H
Column H
Column F
Q525 Easy

Which of the following formats can you decide to apply in the AutoFormat dialog box?

All of these
Number format
Border format
Font format
Q526 Easy

Suppose you want VBA to run a loop that will continue until it finds an empty cell. Which of the following will allow you to do this?

Do loop and the isempty() function
Do loop and the isblank() function
If loop and the isblank() function
If loop and the isempty() function
Q527 Easy

How many users can work simultaneously on a shared workbook?

Maximum of 256 users
Excel is a front-end application that does not support dynamic sharing of workbooks
Only one user can edit, and unlimited users may open the file as Read Only
As many as indicated in the Shared Workbook options
Q528 Easy

What is the default number for maximum iterations?

1000
50
100
10
Q529 Easy

How can you remove duplicate rows in Excel?

No, duplicate rows can not be removed in Excel
To remove duplicate rows choose Data > Remove Duplicate from menu
To remove duplicate rows choose Data > Data Consolidate from menu
To remove duplicate rows choose Data > What-If-Analysis from menu
Q530 Easy

To center worksheet data horizontally and vertically on a page, use the ________ dialog box.

Sorting
Margins
Gridlines
Editing
Q531 Easy

If you want to print only from A1 to F20 of a much larger worksheet, and print that range several times, how could you make it the area that gets printed?

Select from A1 to F20, then click the Page Layout tab. Click Print Area, then select Set Print Area.
On the Page Layout tab, type A1 and F20 in the Print From and Print To fields
Select from A1 to F20. In the Print dialog box, select the option for Always Print Selection
Select from A1 to F20, and in the Print dialog box, click Print. When Excel asks if that should be the default print range, click Yes
Q532 Easy

Which of the following formulas contains the correct syntax for a calculated field within a PivotTable?

#NAME?
#NAME?
Q533 Easy

____ is the amount added to the prinicpal of a loan by the lender.

Interest
Borrowing
Exchanging
None of these
Q534 Easy

Can Excel spreadsheets contain images?

Only when the Workbook is imported from another file format
Yes
No, Excel files cannot have images
They can be inserted only with Macros
Q535 Easy

What kind of formatting allows you to create a set of rules to format cells based on a cell value or another cell?

Conditional Formatting
Text Formatting
Input Formatting
Output Formatting
Q536 Easy

The formula bar displays the value or formula of the active cell. _________________________

True
False
Q537 Easy

The find & select button is found in the editing group on the ____ tab on the ribbon.

HOME
PAGE LAYOUT
Horizontal and vertical axes
Column
Q538 Easy

What is a group of cells that form a rectangle on the screen?

label
worksheet
range
workbook
Q539 Easy

How do you close a formula?

)
"
,
(
Q540 Easy

Clipart can be found under what menu?

Insert
File
Review
Formulas
Q541 Easy

Which of the following depicts a correct range?

B1:B30
Sheet1:Sheet3!A1:E10
'First Quarter:Fourth Quarter'!A1:F16
Shee1:A3:B30
Q542 Easy

Which of the following is not a date and time function?

Networkdays
Weekend
Today
Weekday
Q543 Easy

Choose True or False.VBA is used to automate tasks in Microsoft Excel 2010.

True
False
Q544 Easy

Which of the following features is/are available in Excel 2010?

Using Excel 2010, one can take screenshots of any open window.
Excel 2010 has the Paste preview feature.
Based on the value in a cell, Excel 2010 can have solid fill in the cell.
All of the above.
Q545 Easy

The default border color around a chart title is ____.

Red
Black
Green
Blue
Q546 Easy

Today is an example of a(n) ____________________ function.

Nested
Date
Both
None of these
Q547 Easy

In which tab is the page breaks preview located?

View
design
file
help
Q548 Easy

Columns and rows in a spreadsheet collectively are called a(n) ______.

Portable
Enterprise
Office
Worksheet
Q549 Easy

Which worksheet function returns the standard normal cumulative distribution?

NSDIST
NMSDIST
NORMDIST
NORMSDIST
Q550 Easy

Statistical methods have been used for statistical analyses. A brief list of the more popular methods as following?

General linear model
Generalized linear model
Structural equation modelling
Item response theory
Showing 550 of 1421 questions

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

Report a mistake

What's wrong?