Skip to content

Excel MCQ Questions

0
Answered
0
Correct
0%
Accuracy
Q401 Easy

The _____ sheet button allows you to add worksheets to a workbook.

New
Add
Show
None of these
Q402 Easy

To split a single column into multiple columns based on delimiters or fixed width you may use which option?

Data > Split
Data > What if analysis
Data > Group
Data > Text to columns
Q403 Easy

In Microsoft Excel 2016, the Split command enables a user to view a worksheet in how many panes?

Two
Three
Four
Five
Q404 Easy

By default, numbers appear in the _____ and generally display values exactly as you type them.

Home tab
General number toolbar
General format
Currency format
Q405 Easy

What type of chart would you create in order to present how much each component comprise the whole?

Bar chart
Bubble chart
Scatter plot
Pie chart
Q406 Easy

What is the function of DEGREES?

To return a numeric expression as a degree string.
To convert a numeric string into temperature.
To convert numbers values in to degrees.
To convert radians into degrees.
Q407 Easy

What does the function FV stand for?

Current Value
Present Value
Future Value
Future Variety
Q408 Easy

You have a column of dog breeds that are in all capital letters. What function would you use to convert those dog breeds so that only the first letter of each word is capitalized?

Sentence
Upper
Titlecase
Proper
Q409 Easy

Which function lets you reference a cell or range (that hasn't been named) using text values?

VALUE
INDEX
REFERENCE
INDIRECT
Q410 Easy

In Excel 2016, the Lookup & Reference Option is available under which Of the following tabs?

Insert
Page Layout
Formulas
Review
Q411 Easy

Suppose you create a workbook in Microsoft Excel 2010 and run the 'Check Accessibility' option. This option is used to check the workbook for ____________.

Content that people with disabilities might find difficult to read.
Checking features not supported by earlier versions of Excel.
Both a and b
Q412 Easy

Which function calculates your monthly mortage payment?

PMT (payments)
NPER (number of periods)
PV (present value)
All of these
Q413 Easy

How do you manage range names?

Choose Format/Named Cells/Name Manager
Choose Home/Named Cells/Name Manager
Choose Formulas/Named Cells/Name Manager
Q414 Easy

To create range names for multiple cells at once, use the ________ tool.

Namer
Range creator
Defined names
Create from selection
Q415 Easy

The displayed value of cell A1=FALSE. The formula in cell A2=ISLOGICAL(A1) returns:

FALSE
0
TRUE
1
Q416 Easy

A Pivot table enables fast and easy ____________of inbuilt relationships in the data sources.

accessibility and examination
analysis and interpretation
examination and analysis
accessibility and interpretation
Q417 Easy

Which of the following statements is/are correct about the customization of the Quick Access Toolbar?

A user can change the size of the Quick Access Toolbar.
A user can add command buttons to the Quick Access Toolbar.
A user CANNOT remove the command buttons from the Quick Access Toolbar.
All of the above statements are correct.
Q418 Easy

How can you use Format Painter to apply the format of a single source cell to several nonadjacent destination cells?

A: Right-click the source cell. Click the Format Painter. Right-click each destination cell. Press Esc.
B: Ctrl-click (Windows) or Command-click (Mac) each destination cell to select it. Click the Format Painter. Click the source cell.
C: Select the source cell. Double-click the Format Painter. Click each destination cell. Press Esc.
D: Select the source cell. Right-click the Format Painter. Click each destination cell. Press Esc.
Q419 Easy

Which of the following is NOT a command tab in Microsoft Excel 2016?

Formulas
Format Painter
Data
Review
Q420 Easy

You should ____ a function name in the formula autocomplete list to select the function.

Double click
Click
Right click
None of the above
Q421 Easy

We can perform What-If Analysis in Excel with the use of Data Tables in which we can see the effect of changing an input value on the result returned by a formula as soon as we enter a new input value in the cell that feeds into the formula. Which types of Data Tables can we create to perform What-If Analysis in Excel?

One-variable, Two-variable & Three-Variable data tables
Single & Multi-variable data tables
One & Two-variable data tables
None of the above
Q422 Easy

In Microsoft Excel 2016, which of the following commands should NOT be removed from the Quick Access Toolbar because these commands are NOT available on the ribbon

Undo
Redo
Save
Copy
Q423 Easy

Which of the following is not a style of conditional formatting for value based rule for cells?

five color scale
four color scale
three color scale
two color scale
Q424 Easy

As a general rule, you should _____.

Center column titles, left-align text, and right-align numbers
Center column titles, right-align text, and left-align numbers
Right-align column titles, left-align text, and right-align numbers
Left-align column titles, left-align text, and right-align numbers
Q425 Easy

Let's say you have a large sheet of expenses and want to highlight those that are higher than 100 or less than 5. How would you do this?

Select the cells and bring up the Format Cells dialog box. Create a custom style.
Select all the cells and create a conditional format for cells greater than 100, and another conditional format for cells less than 5.
Select all the cells and create a conditional format for cells between 5 and 100.
Select all the cells and create a conditional format using the Exceptions rule. Enter 100 and 5.
Q426 Easy

You can edit a cell by

None of the Above
Selecting Edit>Edit Cell from the menu
Clicking the formula button
Double clicking the cell to edit it in-place
Q427 Easy

What is the keyboard shortcut for moving the cursor to the first cell in the current worksheet (assuming no frozen panes, this would be cell A1)?

Ctrl + End
Ctrl + Shift + End
Ctrl + Shift + Home
Ctrl + Home
Q428 Easy

Can you print only a selected part of your workbook?

Yes, you can control what part of the workbook is printed.
No, you cannot select parts of a workbook, only the number of pages to print.
Q429 Easy

We can use Excel's _____________ feature to see how the pivot table would look in any style.

Live table
Animated pivot table
Live preview
Live slicer
Q430 Easy

what is the maximum limit of digits in excel?

15
14
16
12
Q431 Easy

To ensure shapes and other objects are an equal left-to-right distance apart, select the shapes, click Page Layout > Align, and then click _.

Align Middle
Distribute Horizontally
Distribute Vertically
Align Center
Q432 Easy

Excel provides ____, which are labels applied to a single cell or to a range of cells?

Label Names
Range Labels
Range Names
Range Values
Q433 Easy

Which of the following will be true to add only positive numbers in a column.

0
#VALUE!
Q434 Easy

An excel ____ allows data to be summarized and charted easily.

Worksheet
Workflow
Document
Presentation
Q435 Easy

When the string 12345678910 is contained in Cell B3, which formula below returns the last 5 digits of the string?

#VALUE!
mcq
mcq
mcq
Q436 Easy

What is the best formula to use to calculate 12 to the 4th power?

#VALUE!
20736
4!12
Q437 Easy

Which chart displays axes but cannot display axis titles?

Radar chart
Doughnut chart
Pie chart
All of the above
Q438 Easy

You can import data stored on a web site using a(n) ____.

Web query
Web dictionary
Web extension
None of the above
Q439 Easy

Which of the following types of filters can be created using the AutoFilter option in Microsoft Excel 2016?i) By list values.ii) By format.iii) By criteria.

Only option ii).
Only options ii) and iii).
Only options i) and iii).
All options i), ii) and iii).
Q440 Easy

____ arguments may provide more control over the returned value.

Relative
Required
Optional
Absolute
Q441 Easy

Placing a chart in a ____ displays only the chart and no worksheet cells.

Chart sheet
Chart worksheet
Chart cells
None of the above
Q442 Easy

The following sequence, jan, feb, mar, etc., is an example of a ____ series.

Test Data
Linear
Auto fill
Date
Q443 Easy

The _____ alert accepts the invalid data but still allows you to cancel the data entry.

Information
Knowledge
Data
Instruction
Q444 Easy

Which is NOT a method to calculate A1 to the power of B1

#VALUE!
#VALUE!
Q445 Easy

How are rows named?

Metamorphically
Numerically
Alphabatically
Symbolically
Q446 Easy

How do you create a table on excel?

insert>table
data>table
Q447 Easy

You can insert a ____ at the bottom of a table.

Total row
Criterion
AutoFilter
Ascending
Q448 Easy

What is the result of the formula =FLOOR(23.4, 0.5)?

23.4
24
23
23.9
Q449 Easy

Which of the following is not a valid file extension in which an Excel file can be saved?

.XLSB
.XLSM
.XLSX
All of the above are valid
Q450 Easy

Excel 2003: _________ allow you to move to another worksheet in an Excel workbook. They are used to display the first, previous, next, or last worksheets in a workbook.

Title bar
Toolbar
Formula bar
Navigation buttons and sheet tabs
Showing 450 of 1421 questions

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

Report a mistake

What's wrong?