Skip to content

Excel MCQ Questions

0
Answered
0
Correct
0%
Accuracy
Q51 Easy

Sheet tab names are ________ when they are grouped.

In red
Italicized
Underlined
Bolded
Q52 Easy

Like other block-level elements, you can ____ tables using the same styles you've already studied.

Resize
Float
Both
None of these
Q53 Easy

What tab would you use to format a section of text as a table?

Home tab, Styles Section
Formula Tab
Page Layout Tab
Home tab, Cells Section
Q54 Easy

How do you select noncontiguous cells?

Click in a cell, then hold down SHIFT as you move from cell to cell using the Arrow keys on the keyboard
Click in a cell, hold down CTRL on the keyboard and then select the other cells
Click in a cell, then hold down ALT on the keyboard as you select the other cells
Click a cell, then hold down SHIFT on the keyboard and select the other cells
Q55 Easy

Suppose you enter ="$30"+10 into a cell. What will the cell display?

40
An error message
$30+10
$40.00
Q56 Easy

You can sort rows by:

All listed are correct
Z to A
A to Z
Smallest to Largest
Q57 Easy

Which of the following is not information you can specify using the solver?

Target cell
Input cells
Changing cells
Constraints
Q58 Easy

Can you add borders to cells without having a border for the workbook?

No, this function is only available in Word.
No, cells cannot have borders, they can only be added to the entire workbook.
Yes, individual cells or a collection of them can have borders.
Q59 Easy

The Format Painter can be deactivated by:

Pressing ESC on the keyboard or clicking the "Format Painter" button again.
Selecting the "Clear Format" function.
Double clicking on the "Format Painter" button.
Clicking on "Undo".
Q60 Easy

____________ helps to make a snap to filter the data of a pivot table.

Live Preview
Slicer
Cross-Tabulating
Drop-down
Q61 Easy

Suppose you copy (clone) a slicer onto another worksheet in Microsoft Excel 2010. If you change the selected tiles in one of the slicers, which statement is true?

All cloned copies of that slicer are also updated instantly.
Only the original slicer reflects the changes being made.
An error is displayed because no updates are allowed in slicers having cloned copies.
None of the above.
Q62 Easy

To convert fluid ounces to milliliters you can use the following function:

CALC()
CONVERSION()
CONVERT()
INTO()
Q63 Easy

Excel recognizes an entry as a value if it is a number or it begins with ____.

+
=
$
All of the above.
Q64 Easy

On a worksheet, you have 12 columns showing monthly sales figures, and 15 rows, 1 row per product. How could you create 15 yearly trendline charts for each product, and fit them neatly on the page?

On the Insert tab, click the Store button. Download the free extension called MiniChart. Select the data, then run the extension.
Create 15 trendline charts. Select them, then from the Page Layout tab, choose AutoFit.
Insert a trendline chart, and use the option for One Chart Per Row.
On the Insert tab, choose Sparklines
Q65 Easy

The Subtotals feature works best when Excel sees that the data have:

No blank columns to the left
Formatting
Headers
No blank rows above
Q66 Easy

True or False: There is only ONE way to group a pivot table item.

True
False
Q67 Easy

Which worksheet function returns the serial number of a particular time?

TIME
TIMEVALUE
NOW
NETWORKDAYS
Q68 Easy

Mark is preparing this year's sales report and wants a tiny chart in the last column of each row showing that row's trend across the months. What should he insert into the worksheet?

Timelines
Slicer
Trends
Sparklines
Q69 Easy

What is the keyboard shortcut to copy a formula/value to the highlighted cell from the cell to the left?

ctrl+r
shift+ctrl+right arrow
ctrl+atl+right arrow
ctrl+right arrow
Q70 Easy

A _______ is the cell containing the formula or value the selected cell refers to.

Precedent
Dependent
Reference
Antecedent
Q71 Easy

While entering data in an Excel 2016 worksheet, what happens if you press the tab key in a cell?

You will move to next column.
You will move to the first column.
You will move to the last column.
You will move to the previous column.
Q72 Easy

You're separating a column of full names into a column of first names and a column of last names. Excel should treat the column as what type of data?

Comma-separated
Delimited
CSV
Fixed width
Q73 Easy

Analyze the syntax of LOOKUP function when used in vector form?LOOKUP(lookup_value, lookup_vector, result_vector)Which of the following arguments of the LOOKUP function is optional?

lookup_value
lookup_vector
result_vector
Q74 Easy

Does conditional formatting override the formatting set in a cell?

No - unless a MACRO is used.
Yes - if the condition(s) are met
No - the manually set format will override the conditional formatting
Depends on the user settings.
Q75 Easy

The formula =4>6 returns:

FALSE
-2
TRUE
2
Q76 Easy

True or False: It is possible to access Outlook, Word or other Microsoft products through Excel.

False
True
Q77 Easy

While editing a cell's content, if you change your mind about the changes you made before pressing the enter key, which of the following keys can be pressed to restore to the original text?

F4
Tab
Esc
Alt
Q78 Easy

In Excel, what does a red signature icon on the status bar tell the user?

It tells the user that macro is enabled
It tells the user that the document contains Signatures
It tells the user that macro is disabled
None of the above
Q79 Easy

Which of the following is not true regarding column width?

If the column width is set to 0, the column is hidden
A column width between 0 to 255 can be specified
The default column width is 8.43 characters
All of the above are true
Q80 Easy

How do you remove only the conditional formatting from a cell and leave all other formatting intact?

This is not possible-you can remove only all formatting from a cell.
Select the cell. On the Home tab, click Conditional Formatting > Clear Rules > Clear Rules from Selected Cells.
Right-click the cell and select Delete Conditional Formatting.
Right-click the cell and select Remove Conditional Formatting.
Q81 Easy

All of the following are valid excel arithmetic operators except ____

^
*
%
>
Q82 Easy

To combine data of two or more columns into another column, you can usually use the concatenation operator _____ in a formula.

+
&
.
&&
Q83 Easy

In the case of synchronizing changes between Table and model, a linked table is a live connection between the range or named table that contains the data values, and the Data Model that powers the report, by default. The Data Model is updated automatically if changes occur in _____?

Table
By using the Power Pivot add-in
By setting the Manual update behavior from the linked table properties
Data Model
Q84 Easy

Which types of charts can excel produce?

Line graphs and pie charts only
Only line graphs
Bar charts, line graphs and pie charts
Bar charts and line graphs only
Q85 Easy

Which of the following statements is True Using PivotTables and Charts?

PivotTables are extremely powerful tools for data analysis and pivot charts allow the visualization of that analysis
You will create a pivot table and chart of the data collected from a web survey.
This will allow you to find useful information about the patterns in the data and communicate those findings through a graphical means
Extremely powerful tools for data analysis and pivot tabel won’t the visualization of that analysis
Q86 Easy

Which worksheet function returns the square of the Pearson product moment correlation coefficient?

PEARSONSQ
SQR
RSQCOR
RSQ
Q87 Easy

Cell ____ are predesigned combinations of formats

Resolutions
Dimensions
Alignments
Styles
Q88 Easy

Excel assigns the name ____ to the first excel table created in a workbook.

Range
Table
Insert
None of these
Q89 Easy

The following functions are listed when the office button is selected:

Save as
Close
Print
all of these are functions
Q90 Easy

Your worksheet has the value 27 in cell B3. What value is returned by the function =MOD (B3,6)?

4
1
5
3
Q91 Easy

A ____ is used to display only certain records within a table that meet the specified criteria.

Comment
Template
Filter
Sort
Q92 Easy

When you assign a password to a worksheet, what are the rules or restrictions for what the password can be?

The password must have at least one capital letter and at least one number
The password can't contain any special characters, like "#" or "&"
The password must be at least 8 characters
No restrictions -- the password can be anything you want
Q93 Easy

What does a “Green Triangle” in the top-left corner of a cell indicate?

The cell is empty.
Error checking options.
The cell contains a comment.
The cell contains a smart tag.
Q94 Easy

Excel provides the following analysis features for instant data analysis, Choose a True statements?

Formatting allows you to highlight the parts of your charts by adding things like data bars and tables
Charts are used to depict the data pictorially. There are several types of charts to suit different types of data
Totals can be used to calculate the numbers in columns and data
Tables help you to filter, sort and summarize your data. The Table and chart
Q95 Easy

A subtotal row must contain at least one ________ function.

Financial
Sort
Aggregate
Sum
Q96 Easy

The formula QUARTILE(a1:a100,1) returns:

75% Percentile Value of the A1:A100 range
25% Percentile Value of the A1:A100 range
1% Percentile Value of the A1:A100 range
100% Percentile Value of the A1:A100 range
Q97 Easy

True or False: If a column is hidden, Excel will not copy the contents of the hidden cells in a copy/paste set of commands.

False
True
Q98 Easy

A pie slice is a data marker that represents ____ from a data series

Axis labels
Scale
Surface
Only one value
Q99 Easy

True or False: You can customize your toolbars and menus.

True
False
Q100 Easy

A scatter chart ____.

Exploded
Compares trends over uneven time or measurement intervals
Data series
Combination
Showing 100 of 1421 questions

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

Report a mistake

What's wrong?