Skip to content

Excel MCQ Questions

0
Answered
0
Correct
0%
Accuracy
Q951 Easy

When does the #NAME? error occur?

When you have forgotten to save your current sheet.
When you have entered an invalid SYNTAX.
When you enter the wrong name for a function.
None of these. That is not an error code in Excel.
Q952 Easy

When a template is created, dummy ____ is/are used to verify the formulas in the template.

Formulas
Data
Formatting
Page layout.
Q953 Easy

Which function copies data from a row into a column or vice versa?

Hyperlink
Transpose
Index
Rows
Q954 Easy

A user can sort a maximum of...

3 columns
5 columns
Infinite columns
10 columns
Q955 Easy

Tables offer following advantages?

Sorting
Filtering
One can use Excel table functions
All of the above
Q956 Easy

A file extension of .xlsm indicates what type of workbook?

Macro-enabled workbook
XML-standard workbook
Excel 2003 workbook
Workbook where macros are not allowed
Q957 Easy

When you copy a formula that contains an absolute reference to a new location, the reference ____.

Is updated automatically
Does not change
Becomes bold
Has a dotted outline in its cell
Q958 Easy

Excel supports all of the following types of sparklines except ____.

A true/false sparkline for help making decisions
A win/loss sparkline for highlighting positive and negative values
A column sparkline used for column charts
A line sparkline for highlighting trends
Q959 Easy

What does the equation =TODAY() show?

The Julian date
The current date from Microsoft
Error since there has to be something in () for the equation to work.
The current date on your computer
Q960 Easy

The formula =NOW() displays:

The time the file was last changed
The time the file was last saved
The time the file was opened
The local computer's actual date and time
Q961 Easy

When you type text in a cell it is ________.

A data point
Left aligned
The cell below
Y-axis
Q962 Easy

Are you able to do spell check in Excel?

Yes, but only if there are no charts in the workbook.
No
Depends on Excel version
Yes
Q963 Easy

Which worksheet function returns the slope of the linear regression line?

SLOPE
SLOPLINREG
SLOPLENEAR
LINSLOP
Q964 Easy

Which is not a lookup function in Excel?

HLOOKUP
VLOOKUP
LOOKUP
#LOOKUP
Q965 Easy

To insert a new column to the left of a specific column, right-click the header containing the column's letter and select _.

Insert Column
Paste Special
Insert
Insert Column Left
Q966 Easy

Which type of additional information is stored within the digital signature?

Date information
Time information
The Office version number of the program in which the file was created
All of the above
Q967 Easy

How do you remove the background of an inserted image?

Select the image and, on the Picture Tools Format tab, use the Compress Picture feature.
Select the image and, on the Design tab, use the Format Background feature.
On the Drawing Tools Format tab, select Graphics Fill > Remove Background.
Select the image and, on the Picture Tools Format tab, click the Remove Background button.
Q968 Easy

In order to multiply items in Excel, you would use which symbol?

/
*
#
&
Q969 Easy

Ribbon can be customized by creating new tabs that house your desired commands. Which of the following statements is/are correct about Ribbon customization?

Commands are placed within a group only.
As many groups as desired can be created to keep your tabs organized.
Commands can be added to any of the default tabs.
Q970 Easy

By using Names, data can be understood and maintained in a much easier way. Which of the followings are the correct examples of using Names in Microsoft Excel 2010?

#NAME?
#NAME?
Q971 Easy

A pie chart with one or more slices offset is referred to as a(n) ____ pie chart.

Exploded
Effects
Embedded
None of these
Q972 Easy

What is Colors[Inventory] referring to here? =SUMIFS(Colors[Inventory],Colors[Colors],"Orange")

The Inventory worksheet in the Colors workbook
The Inventory column in the Colors table
The Colors worksheet in the Inventory workbook
The named range Colors[Inventory], which does not use Format as Table Feature
Q973 Easy

You may use the ______________ settings as an easy way to align text in columns.

Alignment options
Arrangement options
Manage text options
None of the above
Q974 Easy

When you double-click on a pivot report value of a PivotTable in Microsoft Excel 2013, Excel creates new ________ with data corresponding to the pivot report value.

Table
Worksheet
Workbook
Q975 Easy

What are two ways of hiding a row or column?

Right-click the row or column header, then choose Hide, or click Format on the Home tab and choose Hide.
Click the row or column header, then press Ctrl + H, or click the Page Layout tab of the Ribbon and choose Hide.
Double-click the row or column header, or Alt + click the row or column header.
Click the row or column header, then either click the Page Layout tab of the Ribbon and choose Hide, or press Ctrl + Shift + H.
Q976 Easy

All of the following are vertical alignment options except ____

Middle
Center
Top
Bottom
Q977 Easy

In default formatting, when you preface the string "10500" with a dollar sign ($) and press enter, what is the result?

$10,500
$10,500.00
$10500
$10500.00
Q978 Easy

The range of cells receiving the content of copied cells is called the ____.

Fill
Range
Location
Paste
Q979 Easy

When editing an advanced filter, which choice is NOT available?

Copy to
List range
Criteria Range
List variance
Q980 Easy

You should create good ____ to ensure your workbooks are free of errors.

Table
CTRL
Test data
None of these
Q981 Easy

You can set Page Border in Excel from...

Border tool in Formatting toolbar
Border tab in Format Cells dialog box
Line Style tool in Drawing toolba
you cannot set page borders
Q982 Easy

A combination chart can add a(n) ____ axis to chart related data.

Combo
Secondary
Tertiary
Clustered
Q983 Easy

You would ________ a table if you wanted to display only data that matches specific criteria.

Freeze
Sort
Scale
Filter
Q984 Easy

Which of the following limitations are valid in Microsoft Excel 2010?

Maximum column width – 255 characters
Maximum number of characters a cell can contain – 32,767
Maximum undo levels – 64
Maximum hyperlinks in a worksheet – 255
Q985 Easy

When a cell is entered in a formula without using the $ symbol, what type of reference occurs?

Verification Reference
Mixed Reference
Relative Reference
Absolute Reference
Q986 Easy

True or False: You can create a connection to a SQL Server Analysis Services Cube in Excel.

False
True
Q987 Easy

Which custom format will make the cells in column A appear like the corresponding cells in column B?

MMM-YYYY
MMMM-YYYY
MMMM&"-"&YYYY
M-YYYY
Q988 Easy

Where can you insert a text box in Excel?

Only in designated rows
In cells that do not currently contain any data or text
Only in columns with red arrows in the corner
Anywhere
Q989 Easy

True or False: You can add new commands to the QAT.

True
False
Q990 Easy

a formula is always started with what symbol?

+
=
-
$
Q991 Easy

To keep a workbook displayed in the recent files list in backstage view, you click the ________.

Pushpin icon
Normal
Record
Field
Q992 Easy

If A1 contains the text "Red" =OFFSET(A1,0,0) will return

#Name?
Red
0
#REF
Q993 Easy

You want to be able to restrict values allowed in a cell and need to create a drop-down list of values from which users can choose. Which feature should you use?

Protect Worksheet
Conditional Formatting
Allow Users to Edit Ranges
Data Validation
Q994 Easy

To store a macro in a workbook or template, what file extension must you save the file in?

.xlsm or .xltm
.xlsm only
.xls only
.xls or .xlsm
Q995 Easy

If you have an error, how can you find ways to fix it?

Left click on the triangle, pause until you see a question mark, click on the arrow, and scroll to " Help on this error."
You cannot request assistance.
Go to "Data" and click on data tools.
Q996 Easy

If a set of numbers has an even number of items, the MEDIAN function will return:

The lower of the two numbers in the middle of the set
The higher of the two numbers in the middle of the set
The average of the two numbers in the middle of the set
An error
Q997 Easy

Is there a way to share your spreadsheet and allow someone to change it?

Only by email
No
Yes
Q998 Easy

To observe the change to a cell on another tab based on changes made in the current tab, use

Freeze Panes functionality
Split Window functionality
Data Tables
Watch window functionality
Q999 Easy

A field ____ uniquely identifies each column in a data source.

Index
Key
Name
Leader
Q1000 Easy

How would you select an entire PivotTable report?

On the Home tab, in the Editing group, select the 'Entire PivotTable' option
On the Options tab, in the Actions group, click on Select, and then click 'Entire PivotTable'"
On the Analyze tab, in the Data group, click on 'Select Entire PivotTable' option
None of the above
Showing 1000 of 1421 questions

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

Report a mistake

What's wrong?