Skip to content

Excel MCQ Questions

0
Answered
0
Correct
0%
Accuracy
Q851 Easy

Imported data appears entirely in column A. How do you separate the data into individual columns?

Data
Text to Column
Data Validation
Ungroup
Q852 Easy

You can change, or ____, the contents of an active cell at any time.

Edit
Delete
Save
All of these
Q853 Easy

Which of the following terms is NOT part of pivot table terminology?

Table filter
Column labels
Item
Table area
Q854 Easy

Which setting must you modify to print a worksheet using a letterhead?

Lay-out
Paper
Orientation
Margin
Q855 Easy

A ____ file contains data fields separated by a selected character.

Fixed
Marked
Delimited
Formatted
Q856 Easy

Shape Data include the following steps?

Rename a Table
Rename a Column
Transform a Data Table
Remove Rows
Q857 Easy

In Microsoft Excel 2016, which of the following arguments of the YEARFRAC function is/are optional?i) Start date.ii) End date.iii) The type of day count basis to use.

Only option ii).
Only options i) and ii).
Only option iii).
Only options ii) and iii).
Q858 Easy

Which table option gives you different background color for odd/even rows?

Banded columns
Odd/Even rows
Banded rows
Stripes
Q859 Easy

If all of the logical conditions are true, the and function returns the logical value _____.

ON
FALSE
TRUE
OFF
Q860 Easy

In order to create a new report in Excel you have to go to:

Team Tab --->New Report
Create Tab ---> New Report
Data Tab ---> New Report
Insert Tab ---> New Report
Q861 Easy

To create an outline in Excel in order to easily expand a heading and show the summary below it, you would select from the menu:

Data > Consolidate
Data > Subtotal
Data > Filter
Data > Group
Q862 Easy

A range of cells can be converted into an excel ________ so that the data can be analyzed.

Filter
Detail sheet
Data bar
Table
Q863 Easy

When you click the header & footer button on the insert tab, excel switches to _____ view.

Ctrl
Page Layout
Immediately click the Undo button.
Space ( )
Q864 Easy

Which of the following is correct when #VALUE! error appears in cell?

Formula contains an invalid cell reference
Excel doesn’t recognize a name you used in a formula
Formula couldn’t return a legitimate result
It means you’ve used an inappropriate argument in a function
Q865 Easy

Instead of using the Hide and Unhide feature for rows and columns, what feature lets you hide and unhide rows and columns interactively?

Advanced Filter
Data consolidation
AutoShow
Outlining
Q866 Easy

When tracking changes to a workbook, what restrictions can you apply?

When the changes were made, who made the changes, which cells to track
When the changes were made, who made the changes, what their IP address is, which cells to track
When the changes were made, and which cells to track
When the changes were made, and who made the changes
Q867 Easy

A(n) ____ is a group of cells in a rectangular block

Cluster
Selection
Adjunct
Range
Q868 Easy

How do you change the orientation of a spreadsheet from portrait to landscape?

Page layout > scale to fit > landscape
Page layout > orientation > landscape
Page layout > landscape > orientation
Q869 Easy

The countif function is sometimes referred to as a(n) _____ count.

Information
Qualifier
Validation
Conditional
Q870 Easy

Where do you place a MACRO that is supposed to run automatically after every entry on a worksheet?

Must manually run the Macro after each entry.
In a cell, place a hyperlink to the code on a webpage.
On the worksheet tab, go to "View Code" and place the Macro there.
Must use a Form to do this.
Q871 Easy

What is the maximum number of columns allowable in an Excel worksheet?

512
256
16,384
65536
Q872 Easy

Excel allows you to take a ____ of any open window and add it to a workbook.

Microsoft.com
True
Promoting
Screen shot
Q873 Easy

The columns and pie slices in the charts above are ____.

Data markers
Chart areas
Major tick marks
Minor tick marks
Q874 Easy

Opening a workbook or switching from one sheet to another is an example of what?

An event
An object
A property
A method
Q875 Easy

The formula EXACT("Fish","fish") returns:

#NAME?
None of these
TRUE
FALSE
Q876 Easy

What is the answer for this formula? =if(A1>=B1,"Good","Not Good") ---> A1=90 , B1=90

Good
Not Good
Q877 Easy

To copy cell contents, you can select the cell and then press the ____ keys.

CTRL+V
CTRL+X
CTRL+B
CTRL+C
Q878 Easy

What is the fastest way to retrieve more than one comment?

Click the cells one by one to read comments.
Click on "Review" and scroll down to "show all comment."
Ctrl + F2
Not sure, I would go to the "Help'' tab.
Q879 Easy

What would the function "=Large(DataRange, 2)" return?

The second largest value in the DataRange
The longest string in the DataRange
The number with the highest exponent in the DataRange
Q880 Easy

When using a spreadsheet, the expression =d8-d17 is called a ________.

Function
Range
Cell
Formula
Q881 Easy

Can Excel open two documents with the same file name simultaneously?

Yes
No
Q882 Easy

Each location in an Excel spreadsheet is called a:

Tab
Square
Cell
Cube
Q883 Easy

Most software programs can both save and retrieve data in a(n) _______ file format.

False
Tab
True
Text
Q884 Easy

You can use a template on Excel by going to...

Excel doesn't have this option.
File > New > then picking a template.
Insert > Smart Art > then picking a template
Page Layout > Background > then picking a template
Q885 Easy

Which keyboard shortcut selects all cells referenced by formulas in the selection?

CTRL+SHIFT+}
CTRL+[
CTRL+]
CTRL+SHIFT+{
Q886 Easy

In the Find and Replace function it is NOT possible to replace what you've searched for with an alternative at the same time.

False
True
Q887 Easy

Which of the following absolute references should be used to ensure that on copying, neither the column nor the row changes?

$A2
&A2
$A$2
&A&2
Q888 Easy

What is the correct answer: A1 value = 10 A2 value = 0 =IFERROR(A1/COUNT(A1:A2),"Err")

Err
5
10
Q889 Easy

What will be displayed if custom format is [>8/15/16]"OVERDUE!";mm/dd/yy and cell contains 8/23/2016?

8/3/2016
#VALUE
#NULL
OVERDUE!
Q890 Easy

The total sales for Year 1 is in C20, and the total sales for Year 2, which is greater, is in D20. What formula will show the percentage increase?

#VALUE!
#DIV/0!
Q891 Easy

When you widen a column that results in excess row height, you can eliminate the excess row height by:

Using the shortcut keys Alt-O,R,A
Using Home/Cells/Format/Auto Fit Row Height
All of these
Double-clicking the bottom of the row number box
Q892 Easy

When entering formulas and functions in Excel, the symbols *, /, +, and - are called:

Signs
Operators
Divisors
Changers
Q893 Easy

Using ________ enables you to select one or more rows or columns and lock them into place.

Logical test
IF function
Conditional format
Freeze Panes
Q894 Easy

True or False: A Name can be applied to a range of non-contiguous cells.

True
False
Q895 Easy

When a formatted number does not fit within a cell, what does the cell display?

#DIV/0
#DIV@
#####
none of these
Q896 Easy

True or False: You cannot insert comments for individual cells.

True
False
Q897 Easy

Cells and ranges in a worksheet can be formatted ____.

Only before data is entered
Only after data is entered
Before or after data is entered
At the same time data is entered
Q898 Easy

What is a sparkline in Excel?

A type of trend chart which floats on the spreadsheet.
An in-cell chart that displays with the purpose of showing trend.
A trend indicator add-on of a pre-existing line chart.
A format type of a line chart.
Q899 Easy

You want to restrict the values entered in a cell to a specified set, such as Hop, Skip, Jump. Which type of data validation should you use?

Input range
List
Custom
Database
Q900 Easy

When you're sharing a workbook with someone, how often does the workbook get updated?

When the workbook gets saved
After a set period of time
Either when the workbook gets saved or after a set period of time, depending on the option you select
When you click the Update button
Showing 900 of 1421 questions

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

Report a mistake

What's wrong?