Skip to content

Excel MCQ Questions

0
Answered
0
Correct
0%
Accuracy
Q601 Easy

It is the intersection of a column and row.

Row
cell
Formula bar
Column
Q602 Easy

You should hold down the ____ key to select the nonadjacent cells.

CTRL
Shift
Enter
Alt
Q603 Easy

The entry in cell b15 is =sum(b5:b14) which is a ____.

Formula
Label
Function
Formula bar
Q604 Easy

To discover how many cells in a range contain values that meet a single criterion, use the _ function.

COUNT
SUMIFS
COUNTA
COUNTIF
Q605 Easy

A _______ is used to analyze and summarize your data without graphical support

PivotChart
Chart
PivotTable
Table
Q606 Easy

Which of the following keyboard shortcuts is used to display or hide the ribbon in Microsoft Excel 2016?

Alt+F1
Alt+Shift+F1
Ctrl+F1
F1
Q607 Easy

When you create a calculated column, you can use _____ references to create the formula.

Restricted
Structured
Advanced
Qualified
Q608 Easy

Which is a keyboard shortcut to insert current date into a cell?

"Ctrl" and "semi-colon"
"Ctrl" and "comma"
"Shift" and "colon"
"Shift" and "comma"
Q609 Easy

You can automatically adjust the size of text in a cell if they do not fit in width by

From Format Cells dialog box mark Shrink to fit check box
Right Clicking on the Column Header
Double clicking on the left border of Column header
Double clicking on the right border of column header
Q610 Easy

True or False: You can create a two-input data table.

True
False
Q611 Easy

Under which tab would you access Visual Basic?

Developer
Home
Insert
Formulas
Q612 Easy

To add a sort field in the sort dialog box, click the ____ button.

Add Level
Add box
Add and insert
Q613 Easy

Data displays in the ____ as you type.

status bar
insert function box
name box
formula bar
Q614 Easy

What makes Ln fuction in excel?

power 2
Return natural logarithm of a number
rounds positive and negative numbers
Q615 Easy

Which of the following functions returns the greatest numeric value?

MAX
MAXIMUM
MAXIMUMVAL
MAXVAL
Q616 Easy

Which is false regarding Conditional Formatting?

We can apply FONT, BORDER, and PATTERN formats that meet specified conditions
We can set conditions to look for BOLD and apply ITALICS on cells
We can add more than one condition to check
We can delete any condition from Conditional Formatting if it is not required
Q617 Easy

How do you create a reminder to follow up on a document?

Tools/Scenarios/Add/Merge
Tools/Flag for Follow Up/Enter Date & Time
Data/Validation/Input Message
Insert/New Comment
Q618 Easy

How do you create a range for a sum function that anchors itself on A1, but will increase in range downwards as you drag and drop the formula?

Sum(A1:A2)
Sum(A1:$A$2)
Sum(A$1:A$2)
Sum(A$1:A2)
Q619 Easy

Which command locates values in a worksheet?

Search
Find
Save
Print
Q620 Easy

In an Excel table, cell A3 contains Andrew and cell B3 contains Fuller. What is the result of the formula =B3&", "&A3?

It will display Nancy Davolio
It will display Fuller Andrew
It will display Fuller, Andrew
Both b and c
Q621 Easy

Which worksheet function returns the correlation coefficient between two data sets?

CORREL
CHIDIST
COREL
CHIINV
Q622 Easy

You have a range of cells selected and want to place a duplicate of that range elsewhere on the page. How can you do this?

While holding Shift, place the mouse pointer on the inside of the area, then drag to a new location
While holding Alt + Shift, drag the border of the selection to a new location
While holding Ctrl, drag the border of the selection to a new location
While holding Alt, drag the border of the selection to a new location
Q623 Easy

Which format setting does not change the background appearance of a cell?

Cell style
Fill color
Pattern style
Font color
Q624 Easy

In Excel 2010, to protect a worksheet, choose Protection and then Protect Sheet from which menu?

Review
Format
Data
Edit
Q625 Easy

Which worksheet function returns the k-th smallest value in a data set?

SMALL
RANK.AVG
COUNT
MINA
Q626 Easy

Which option would you choose to display a list of formula used in the current PivotTable report?

On the Options tab, in the Tools group, click on Formula, and then click 'Solve Order'"
On the Formula tab, in the Function library, click 'Show Formula'
On the Options tab, in the Tools group, click on Formula, and then click 'List Formula'
None of the above
Q627 Easy

Which of the following commands in Microsoft Excel allows a user to automatically create groups and use common functions such as sum, count and average for helping in summarizing data?

Group
Filter
Data Validation
Subtotal
Q628 Easy

If the Formula bar is too short to see all its contents, how can you enlarge it?

Click the Down arrow on its right side
Click inside it and press the Enter key a few times
Right-click inside it and select Tall from the pop-up menu
Double-click inside it
Q629 Easy

Which of the following components of Excel Services enables the user to edit a published workbook inside a web browser?

Excel Calculation Services (ECS)
Excel Web Access (EWA)
Excel Web Services (EWS)
Q630 Easy

You can click the ____ button to undo an automatic correction.

AutoCorrect Options
False - yes, we can
False - we can not use the arrow keys in Point mode
Auto Fill Options
Q631 Easy

Which worksheet function returns a value along a linear trend?

FISHER
FORECAST
FTEST
FDIST
Q632 Easy

Which one is NOT a column chart type?

Stacked pyramid
Doughnut
Stacked column
Clustered cylinder
Q633 Easy

When a list is filtered (showing only rows that meet the criteria) and highlighted, the copy command will result in:

No option; Excel will not allow copying of filtered rows
A dialog box asking which rows to copy
Both visible and hidden rows being copied
Only the highlighted cells being copied
Q634 Easy

If you type "Your your" in a single cell, what will be the output?

Your you're
You and Your
You're your
Your and You're
Q635 Easy

Which function returns the Student's t-distribution?

TDIST
DISTIRBT
STUDENT
TDISTRIB
Q636 Easy

Which of the following options is the correct keyboard shortcut for accessing the backstage view in Microsoft Excel 2016?

Ctrl + B
Alt + F
Alt + B
Tab + F
Q637 Easy

You have a table of data listing each sales person in one column and their territory in a second column. Each sales person is only listed once but there are hundreds of sales people. What function could you use to quickly display a salesperson's territory by typing in their name?

SUBSTITUTE
ISERROR
TEXT
VLOOKUP
Q638 Easy

How can you remove borders applied in cells?

Both of these
Open the list on Border tool in Formatting toolbar then choose first tool (no border)
Choose None on Border tab of Format cells
Q639 Easy

Which of the following can be accomplished by Creating Highlighted Cell Rules?

Which cell values are less than 0?
What are the top 10 values?
Which cell values are above average, and which are below average?
Which cells values are duplicate?
Q640 Easy

Which of the following is not a type of expansion slot?

ISA
EISA
PCI
IDE
Q641 Easy

Using formulas, how could I combine text resulting in "Check # 1234 paid 02/15/2013 - pending cash application"? Cell B4 refers to the date.

1899-12-30
#VALUE!
Check # 1234 paid mcq - pending cash application
Q642 Easy

When you split the screen horizontally or vertically, why might you want to immediately freeze the top or left pane?

To avoid accidentally entering duplicate data on the sheet.
To keep column or row headers visible while you scroll the rest of the sheet.
When the panes aren't frozen, the sheet will have two vertical or two horizontal scrollbars, and that can be confusing.
Scrolling two parts of the screen uses a lot of video memory, and Excel might crash.
Q643 Easy

Each column in Excel has a corresponding number. To extract this number you can use the following formula:

countcolumn()
column()
colnumber(column letter)
colcount()
Q644 Easy

Which of the following is NOT an option for formatting a row?

Hide
Height
Autofit
Width
Q645 Easy

Charts button in Excel 2013 can change ________, ________ , and _________.

Charts, Formatting, Data.
Data, Elements, Label.
Elements, Layout, Filters.
Filters, Table, Animation.<br>
Q646 Easy

Which among the following settings is the default macro security setting

Disable all macros except digitally signed macros.
Disable all macros except digitally signed macros.
Enable all macros.
Q647 Easy

When using Goal Seek, you can find a target result by varying _ at most.

Three inputs
Four inputs
Two inputs
One input
Q648 Easy

True or False: Formulas can be edited across multiple worksheets at the same time.

True
False
Q649 Easy

To show the actual formula instead of Cell Values which function can be used?

FORMULACELL(cell)
FORMULA(cell)
FORMULATEXT(cell)
SHOWFORMULA(cell)
Q650 Easy

After typing data or a formula into a cell and hitting ENTER, the default action is:

Move Right one cell
Move up one cell
Stay in the cell
Move down one cell
Showing 650 of 1421 questions

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

Report a mistake

What's wrong?