Skip to content

Excel MCQ Questions

0
Answered
0
Correct
0%
Accuracy
Q751 Easy

The path to the comma style button is ____.

HOME
(HOME tab | Clipboard group)
(HOME tab | Number group)
Auto Fill Options
Q752 Easy

A ____ is a predefined set of colors, fonts, chart styles, cell styles, and fill effects that can be applied to an entire workbook.

Format
Layout
Format painter
Theme
Q753 Easy

We can create new custom Theme in Excel 2010. To create a new style, follow these steps?

Click on the save current theme option under Theme in Page Layout Tab.
This will save the current theme to office folder.
You can browse the theme later to load the theme.
All of the above
Q754 Easy

Let's say that for 100 cells down column B, you have a dozen varieties of olives listed, some of them appearing multiple times. How can you use the COUNTIF function to find the number of times the Greek variety is listed?

0
#VALUE!
Q755 Easy

You can use _____ to reference cells within an excel table.

Conditional
Cell and range addresses
Nest
Stop, Warning, and Information
Q756 Easy

In producing a newsletter, you should develop ____ with as few words as possible.

Action calls
Objects
Subheads
Spans
Q757 Easy

True or False: Sparklines are a new part of Excel 2010/2011 and are not available in previous versions.

True
False
Q758 Easy

How can you cause text to display vertically in a cell?

Choose Distributed from the Vertical drop down list of Format Cells box
Choose 90 Degrees in Orientation of Format Cells box
Choose Vertical on Text alignment in Format Cells box
Choose 180 Degrees in Orientation of Format Cells box
Q759 Easy

Which two functions check for the presence of numerical or nonnumerical characters in cells?

ISNUMBER and ISTEXT
ISNUMBER and ISALPHA
ISVALUE AND ISNUMBER
ISVALUE and ISTEXT
Q760 Easy

Which of the following command converts row data into columns?

Row to Column
Convert to Column
Transponse
Paste to Column
Q761 Easy

Where does the "Track Changes" feature highlight changes?

On the entire worksheet
On all sheets of the workbook
On the entire worksheet or in a range of cells that you specify
In a specific range of cells you select
Q762 Easy

Which worksheet function returns the maximum value in a list of arguments, including numbers, text, and logical values?

MAXIMUM
MAXA
LARGEST
MAX
Q763 Easy

Cell A1 has text in the format YYYYMMDD. How do you convert this to a valid Excel date?

1899-12-30
#NAME?
Q764 Easy

How do you remove everything (values, formatting, etc.) from a cell?

Select the cell. On the Home tab, click Clear.
Select the cell and press Delete.
Right-click the cell and select Delete.
Select the cell. On the Home tab, click Clear > Clear All.
Q765 Easy

Cell A20 displays an orange background when its value is 5. Changing the value to 6 changes the background color to green. What type of formatting is applied to cell A20?

Value Formatting
Cell Style Formatting
Conditional Formatting
Tabular format
Q766 Easy

The shortcut for writing the number 5,000,000 in an Excel cell is by typing the following formula

5(##)6
5**6
5.2.6
5^^6
Q767 Easy

What happens when dollar signs ($) are entered in a cell address? (ex. $B$2:$B$10)

The status bar does not display the cell address
Cell address will change when it is copied to another cell
The sheet tab is changed
An absolute cell address is created
Q768 Easy

Where on the Developer's tab is the VBA button located

XML section
Controls section
in the Code section
Add ins section
Q769 Easy

Cell A2 has the name DAVID HAWLEY in it. Which formula extracts the first name from the cell?

#NAME?
What
xcel?
Q770 Easy

When using Goal Seek, the cell that you're setting must be:

A number
A field
Calculated
Validated
Q771 Easy

Cell D1 contains the value 7.877. You want cell D1 to display the value as 7.9 but keep the original number in calculations. How can yu=ou accomplish this?

Click the Decrease Decimal button once.
Click the Decrease Decimal button twice.
Use the ROUND() function.
In the Cells group on the Home tab, click Format > Format Cells. Then click the Alignment tab and select Right Indent.
Q772 Easy

In cell E2, you write the formula =$C2*E$1. You then copy that formula to cell F6. What does it update to?

#VALUE!
#VALUE!
Q773 Easy

In Excel, when you point at the filter arrow in a column heading, the ScreenTip says "Showing All". What does this mean?

It means that a Filter has been applied
It means that Filtering has been enabled but not applied
It means Excel does not support such a Filter
None of the above
Q774 Easy

Cooler colors tend to pull away from the reader. _________________________

True
False
Q775 Easy

Can we change the default font size of a new workbook in Excel 2016 from the Backstage view?

Yes
No
Q776 Easy

The first sort field in a sort is called the major sort field. ____________________

Secondary sort
Year to Date
Two or four
Convert to Range
Q777 Easy

What is a known bug in Excel?

Excel assumes that 1900 is a leap year.
Excel represents 0 as 1/0/1900.
Excel can't visually represent dates prior to 1900.
Excel dates are represented by a number of days after a set date in 1900.
Q778 Easy

What Tab do you use to create a background Graphic?

Insert > Illustrations
Page Layout > Background
Page Layout > Themes
Insert > WordArt
Q779 Easy

Evaluating cell A1 based on font color:

Requires the function =COLOR(A1,"type")
Requires conditional formatting
Requires the function =INFO(A1,RC1C)
Requires a macro
Q780 Easy

Excel accepts the following range name:

Sheet4
This+Rate
All of these
A33
Q781 Easy

The underline format will underline ____

Format Chart Area dialog box
Press the ENTER key
Horizontal split bar
Only the characters in the cell
Q782 Easy

Choose True or False.With respect to Protect Workbook in Microsoft Excel 2016, the Windows option can be used for preventing users from moving, resizing or closing the workbook window.

True
False
Q783 Easy

True or False: A pivot table is a "dynamic summary report generated from a database."

False
True
Q784 Easy

How do you copy paste only a number from a cell and not the formula that goes with it?

Edit, copy, desired location, edit, special paste, values
Control + shift + V
Edit, copy, desired location, paste, format
Edit, copy, control + P
Q785 Easy

________ software is used to perform calculations and numerical analyses.

Spreadsheet.
Project.
Database.
Dataform.
Q786 Easy

The values for A1:A5 are A1=1, A2=3, A3=2, A4=5, A5=4. The formula PERCENTRANK(A1:A5,A2) returns the value:

0.5
0.75
0.20
0.25
Q787 Easy

Which of the given Document properties includes both file system properties and statistics that are maintained by Office programs for the user?

Automatically updated properties
Standard properties
Custom properties
Properties for the organization
Q788 Easy

Combining two or more selected cells into one cell is called ____ cells

Merging
Mixing
Combining
Spanning
Q789 Easy

When you have many different PivotTables in one report, you can share a slicer that you created in one PivotTable with other PivotTables. Which of the following statements is not true?

Any changes that you make to a shared slicer are immediately reflected in all PivotTables that are connected to that slicer
When you share a slicer, you are creating a connection to another PivotTable that contains the slicer that you want to use
A PivotTable can have both local and shared slicers, you can enable this option under Slicer Settings
Any changes that you make to a shared slicer are immediately reflected in all PivotTables that are connected to that slicer
Q790 Easy

What would you enter first in a cell to show formula text?

question mark (?)
colon (:)
apostrophe (')
(ft)
Q791 Easy

In Excel, how do you rotate the text in a column heading cell to an angle?

By using the 'Orientation' button in the alignment group of the 'Home' tab.
By using the 'Orientation' button on the 'Page Layout' tab.
By using the 'WordArt' button on the 'Insert' tab.
Q792 Easy

____ a shape within a smartart graphic means moving it to a lower level.

Resizing
Promoting
Demoting
Increasing
Q793 Easy

How are columns named?

Symbolically
Metamorphically
Alphabetically
Numerically
Q794 Easy

In Excel 2016, which of the following options should be used if you want to prevent other users from opening a file?i) File encryptionii) Mark as Final

Only option i)
Only option ii)
Both options i) and ii)
Neither option i) nor ii)
Q795 Easy

How would you rename the tabs at the bottom of the spreadsheet?

Both ways: right click on tab and type new name or double click tab and type new name.
Left click tab and type new name.
Single click on column header and type new name.
Q796 Easy

A macro name can be up to ____ characters long.

8
32
127
255
Q797 Easy

A Data Model integrates the tables, enabling extensive analysis using PivotTables __ , ___?

Data Mode, Power Pivot
Power View, Data Pivot
Power Pivot, Power View
Power Viewer, Data Viewer
Q798 Easy

How does the appearance of an array formula differ from that of a standard formula?

In a worksheet cell, array formulas have a small blue triangle in the cell's upper-right corner.
A heavy border appears around the range that is occupied by the array formula.
In the formula bar, an array formula appears surrounded by curly brackets.
When a cell that contains an array formula is selected, range finders appear on the worksheet around the formula's precedent cells.
Q799 Easy

In an alphabetical sort, if two cell contents are identical, Excel sorts by:

Merging the two cells
None of these
Placing the item that came first in the original list before the second item
Adding a " ~ " to the end of the second item to make it unique
Q800 Easy

If you enter "August 1, 2012" (without quotes) in cell A1 in a new worksheet, which data type would it be?

both a label and a value
formula
value
label
Showing 800 of 1421 questions

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

Report a mistake

What's wrong?