Skip to content

Excel MCQ Questions

0
Answered
0
Correct
0%
Accuracy
Q101 Easy

The process of identifying specific rows and columns so that certain columns and rows are always visible on the screen is called?

Selecting
Holding
Fixing
Freezing
Q102 Easy

An organization chart, which shows the hierarchy within a company or organization, is available as _ that is included with Excel.

A 3D model
SmartArt
A Treemap chart
A drawing object
Q103 Easy

The Freeze Panes function allows the user to:

add a macro which sets size-specific formatting within a worksheet.
keep an area of a worksheet visible while you scroll to another area of the worksheet.
lock in all existing formulas and formats within the cells that they currently reside.
drag an existing formula across multiple cells within a range by utilizing the following.
Q104 Easy

In Excel, what do most formulas begin with?

:
=
(
-
Q105 Easy

To set a page break in excel, select the _____.

First cell below the row where you want to insert a page break
First cell above the row where you want to insert a page break
Row above where you want to insert a page break
Row below where you want to insert a page break
Q106 Easy

A(n) ____ is an entry in a cell that contains text such as 2016 sales or travel expenses.

Zoom
Function
Label
Templates
Q107 Easy

Grouping is ________.

Click the field's arrow in the VALUES area and select Value Field Settings.
Aggregate values do not respond to slicers.
Represents the consolidated data of a PivotTable visually
Joining rows or columns of related data into a single entity for analysis
Q108 Easy

An Excel workbook is a collection of ?

Worksheets
Worksheets and charts
Charts
Workbooks
Q109 Easy

How can you delete the contents of a cell and its formatting at the same time?

Select cell and press Delete
Select cell and choose from menu Home > Clear > Clear All
Select cell and choose from menu Home > Clear > Clear Formats
Select cell and choose from menu Home > Clear > Clear Contents
Q110 Easy

_____ are an example of conditional formats in excel.

Data bars
Font sets
Quick Analysis tools
Percentages
Q111 Easy

Which formula returns the value in cell A1 of the worksheet named MySheet?

#NAME?
#NAME?
Q112 Easy

What-If analysis functionality in Excel includes:

All of these
Scenario Manager
Data Tables
Goal Seek
Q113 Easy

Under what tab can the Scenario Manager be found?

Data
View
Formulas
Home
Q114 Easy

A(n) ____ identifies each data series in a chart, generally with a different color.

Axis
Data point
Data marker
Legend
Q115 Easy

____ format codes allow you to specify how a cell entry assigned a format will appear.

CRTL
CTRL
CTRL+D
Custom
Q116 Easy

A theme can be applied using the themes button in the themes group on the ____ tab on the ribbon.

Home
Data
Page Layout
Review
Q117 Easy

Which of these characters is not allowed as part of a tab name?

<
"
>
?
Q118 Easy

What ribbon command on the Home tab can you use to change a cell's fill color automatically, based on the value of the cell?

Conditional Formatting
Format
Cell Styles
Fill
Q119 Easy

Which of the following is/are correct about macro naming rules in Microsoft Excel 2016?

A macro name's first character must be a letter.
A macro name can contain spaces.
An underscore can be used in a macro name.
A macro name cannot contain numbers.
Q120 Easy

A ________can retrieve data from multiple fields in different tables in the data model

Database
Relational
Data model
PivotTable
Q121 Easy

Function(argument1, argument2, ...) is ____.

The syntax of writing optional arguments.
An example of a formula
The general syntax of all formulas
The general syntax of all functions.
Q122 Easy

When 'a' or 'p' is not typed after the time in Worksheet cells, what does Excel enter the default time as?

It displays the prompt box and asks the user to type 'a' or 'p'
It displays an error message
It enters the time as PM
It enters the time as AM
Q123 Easy

What is the function to display only the current date?

NOW()
TODAY()
DATE()
CURRENT()
Q124 Easy

____ order arranges labels in reverse alphabetical order, from a to z

He would develop a PivotTable using the value filter.
Descending
Create a text filter using the Contains operator to display all records that have Camp anywhere in the text value.
Fields
Q125 Easy

Cell A4 contains the number 19.5. What does the formula =T(A4) return?

The text True
The text 19.5
Empty text ("")
An error
Q126 Easy

What does it mean when the "marching ants" border around selected cells disappears?

Your latest edits to the file are now saved
The selected cells are now copied to the clipboard, and you can paste them
The error that Excel was throwing is now cleared
The selection is no longer in the clipboard, and you can no longer paste the selection
Q127 Easy

How would you summarize sales data in a PivotTable by product name?

Select the product sales amounts, then click Insert Slicer
Select the product names, then click Group Selection
Select the product names, then click Summarize
Select the product sales amounts, then insert another PivotTable
Q128 Easy

When using a Lookup to extract data, what is the meaning of the true/false argument?

True means don't throw an error if the request is invalid, and False means throw an error to flag an invalid request.
True means it's OK to get an approximate match, and False means you want only an exact match.
True means you want only an exact match, and False means it's OK to get an approximate match.
True means throw an error to flag an invalid request, and False means don't throw an error if the request is invalid.
Q129 Easy

How can you add a total row to an already created table?

Select any cell in table and from Table menu click on 'Add row'
Select any cell in table and from Table menu click on 'Total row'
Select any cell in table and from Insert menu choose Add row
Right click on first column of last row and select Insert
Q130 Easy

An .xlsx file cannot store VBA macro code or Excel 4.0 macro sheets.

False
True
Q131 Easy

Why is it a good idea to keep track of numbers, projects and lists in Excel, rather than in text files?

Text files can get infected by viruses, but Excel files can't
Nobody uses text files anymore
It's the #1 worldwide standard for these activities
You can't change fonts or apply colors to text files
Q132 Easy

Once you have selected a range to chart, you can press ____ to draw a chart on a worksheet.

True
False
F11
Tru
Q133 Easy

Where do you find the picture icon?

The review tab.
The formula tab.
The insert tab.
The home tab.
Q134 Easy

If A1 contains the text "Red" and B2 contains "Blue" then =OFFSET(A1,1,1) returns

Red
#NAME?
#REF
Blue
Q135 Easy

Which of the following is correct syntax for typing a function into a cell?

1
ABS(A2-A4)
All of these
Q136 Easy

The NOW() function returns the current date and time as 43740.665218. Which part of this value indicates the time?

6652
43740.665218
43740
665218
Q137 Easy

The default format for cells that meet a condition with conditional formatting is ____.

Clipboard
Two
Light Red Fill with Dark Red Text
Format Cells
Q138 Easy

Which would you choose to create a bar diagram?

Format, Chart
Edit, Chart
Insert, Chart
Tools, Chart
Q139 Easy

Which worksheet function returns the probability that values in a range are between two limits?

PROBLIM
PROBABILITY
PROB
PROBLIMIT
Q140 Easy

If two formulas that depend on one another need to be solved at once and a circular reference is created, this can be resolved by:

allowing iterations
tracing precedents and reconfiguring the feed cells
a circular reference is an error and cannot be resolved without changing or correcting the formulas
copying/pasting formula(s) into a different cell to avoid a circular reference
Q141 Easy

What function can be used to identify duplicate values in Column A?

#VALUE!
1
content
Q142 Easy

John inserts a PivotTable based on a table that has a Days column containing only numbers. He drags the Days field into the Values area of the PivotTable Fields pane. Which summary does Excel use by default?

Max of Days
Average of Days
Sum of Days
Count of Days
Q143 Easy

A formula with brackets such as {sum((C2:C1)*(D2:D11))} is called:

A pivot formula
A statistical function
An array formula
The geometric mean
Q144 Easy

How can you remove an icon from the Quick Access Toolbar?

Right-click the icon, then select Remove from Quick Access Toolbar on the pop-up menu.
On the View tab of the Ribbon, click the Quick Access drop-down list. Deselect any icons you want to remove.
Ctrl + Shift + click the icon you want to remove.
Press and hold the Alt key while dragging the icon down, off the toolbar.
Q145 Easy

Which of the following logical functions doesn

AND Function
IF Function
OR Function
XOR Function
Q146 Easy

What is the filename extension of Excel workbooks which are saved as ‘Excel Templates’?

.xlsx
.xslt
.slk
.xltx
Q147 Easy

True or False: The Remove Duplicates command treats items that are spelled the same but capitalized differently as two distinct items.

False
True
Q148 Easy

What is the correct syntax of the worksheet function “RANK”?

RANK(number,ref,order)
RANK(x,mean,standard_dev)
RANK(known_y's,known_x's,new_x's,const)
RANK(known_y's,known_x's)
Q149 Easy

You're writing a macro and want to add the following comment: use this code. How would you add this comment?

<>use this code
"use this code"
use this code
'use this code
Q150 Easy

Under the Format menu, under COLUMN, which of the following is NOT an option?

Hide
Standard Width
Autofit
Showing 150 of 1421 questions

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

Report a mistake

What's wrong?