Skip to content

Excel MCQ Questions

0
Answered
0
Correct
0%
Accuracy
Q1401 Easy

Which worksheet function returns the individual term binomial distribution probability?

BETAINV
BINOMDIST
AVERAGEA
AVEDEV
Q1402 Easy

Pivot tables are very useful for ___________ one set of data in your data list with another data set.

quickly analyzing
formatting tables of
cross-tabulating
analyzing relationships of
Q1403 Easy

What do you click on to navigate between worksheets in a workbook?

Files
Tab
Rows
Cell
Q1404 Easy

How does one change the font style of the selected cell to *bold*.

(Ctrl+B)
click twice
Q1405 Easy

All of the following are recognized file extensions in Excel except:

.xlsbb
.pdf
.xlsb
.csv
Q1406 Easy

What function would you use to extract a portion of a text string from the center of the string?

mid
text
find
trim
Q1407 Easy

How cell reference is useful in the calculation?

In order to avoid writing the data again and again forcalculating purpose, cell reference is used. When you write any formula, for specific function, you need to direct excel the specific location of that data. This location is referred as, cell reference. So, every time a new value added to the table, the workhand will calculate according to the reference cell formula.
In order to avoid writing the data again and again forcalculating purpose, cell reference is used. When you write any formula, for specific function, you are not need to direct excel the specific location of that data. This location is referred as, cell reference. So, every time a new value added to the cell, the cell will calculate according to the reference cell formula.
In order to avoid writing the data again and again forcalculating purpose, cell reference is used. When you write any formula, for specific function, you need to direct excel the specific location of that data. This location is referred as, cell reference. So, every time a new value added to the cell, the cell will calculate according to the reference cell formula.
All of the above
Q1408 Easy

Choose True or False.In SharePoint Foundation 2010, co-authoring of Excel 2010 workbooks is supported by the Microsoft Excel 2010 Web App.

True
False
Q1409 Easy

A function inside another function is called a _____ function.

Nested
Text
Round
2nd Level
Q1410 Easy

A _____ indicates a manual page break.

Dashed Blue Line
Solid Blue Line
Dashed Red Line
Solid Red Line
Q1411 Easy

To add a comment, select the:

Formulas tab
Insert tab
File tab
Review tab
Q1412 Easy

True or False: A fixed dollar sign appears to the far left in the cell often with spaces between it and the first digit. Whereas a floating dollar sign appears immediately to the left of the first digit with no spaces.

False
True
Q1413 Easy

Which is not a type of Cell Format?

Text
Fraction
Time
Digit
Q1414 Easy

Which options are available for Auto Fill?

Copy Cells
Fill Cells
Fill Series
Fill Formatting Only
Q1415 Easy

How can you quickly display or hide the parts of a selected chart, like gridlines, axes and legend?

Click the Chart Elements button at the top of the chart, then make your selections.
Re-run the Chart Wizard.
Right-click each part, and from the pop-up menu, choose Hide or Display.
In the Chart Tools - Format tab of the Ribbon, select which chart parts you want to display.
Q1416 Easy

Every ____ consists of an object that contains a button for each unique value in that field.

Part
Piece
Section
Slicer
Q1417 Easy

You want a drop down list with a blank space between "apple" and "banana". How do you do this?

Create a Named Range with "apple" in the first cell, nothing in the second cell, and "banana" in the third cell. Then, point the list to that named range.
Go to data validation, list, source and type the following: "apple", "", "banana"
Not possible.
Q1418 Easy

The formula =EOMONTH(2/1/2011,4) will return what date, if the cell is formatted MM/DD?

2/5
6/1
5/31
6/31
Q1419 Easy

Which worksheet function counts the number of cells containing data (either numbers or labels) in a selected range?

COREL
CHITEST
COUNTA
COUNT
Q1420 Easy

A _____ is a rectangular-shape block of cells in an excel worksheet.

Range
Matrix
Table
Column
Q1421 Easy

A header contains ____ boxes.

The largest value in the argument
255
January 1, 2000
3

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

Report a mistake

What's wrong?