Skip to content

Excel MCQ Questions

0
Answered
0
Correct
0%
Accuracy
Q801 Easy

How do you change text's alignment within a cell?

You can not align an individual cell
Select auto-fit in the cell
Use the commands in the font group on the Home tab
Select the cell and click the appropriate alignment button in the alignment group on the Home tab
Q802 Easy

True or False: The list of items for a dropdown box must be on the same worksheet as the dropdown box.

True
False
Q803 Easy

The general format of a 3-d cell reference is ____.

WorksheetRange!cellrange
Tiled, cascade, & horizontal
3D cell reference
Q804 Easy

In a large data set with 121,005 rows, You are on the top row (row 1) of the data set. What is the fastest way to get to row 121,005?

ctrl + A + delete
ctrl + down arrow
double click down arrow
ctrl + D
Q805 Easy

What combination of keys do you need to use for an array formula to work?

No key combination is required, an array formula can be entered in the same way as any other formula
Ctrl+Shift+A
Ctrl+a
Ctrl+Shift+Enter
Q806 Easy

How would you locate the last filled cell on a worksheet?

Click anywhere in the worksheet, and then press CTRL+HOME
Click anywhere in the worksheet, and then press CTRL+INSERT
Click anywhere in the worksheet, and then press CTRL+END
None of the above
Q807 Easy

Cell references in a formula are called ____.

Assumptions
Comments
Numbers
Content
Q808 Easy

To ________ a table means to arrange all of the data in a specific order.

Pane
SUM
NOW
Sort
Q809 Easy

The ____ error code indicates that a cell reference in a formula is not valid.

#INVAL!
#REF!
#NAME!
Q810 Easy

How many passwords can be set on a Microsoft Excel 2013 file?

One
Two
Three
Four
Q811 Easy

How do you debug a formula by looking at each part of the formula individually?

Conditional Formatting
Formula Auditing > Error Check
Formula Auditing > Evaluate Formula
Impossible in Excel
Q812 Easy

What tool allows you to summarize and analyze data in various categories?

Square root analysis
Pivot tables
Pie chart
copy and paste
Q813 Easy

Which of the following is an example of a conditional formatting rule?

Create Rules
Color Scales
Font Sets
Formatting Scales
Q814 Easy

What does this formula do? =IF(E6=G6;"Nice";"Not so Nice")

Checks if E6 equals G6 and if it does, the result is true and the formula returns 'Nice'
Sums up the range E6 to G6 and if the sum is greater than zero then, the formula returns 'Nice'
Creates borders around cell G6
It changes your font color to Red
Q815 Easy

Which worksheet function estimates variance based on a sample?

VARA
SVAR
VARS
sVAR
Q816 Easy

You can use predesigned, formatted files called ____ to create new worksheets quickly.

Screens
Templates
Format sheets
Layouts Spreadsheet
Q817 Easy

Which worksheet function Calculates standard deviation based on the entire population, including numbers, text, and logical values?

STDEV
STDEVA
STDEVP
STDEVPA
Q818 Easy

Excel, When you use group worksheets?

A) You can enter variable data on multiple worksheets at one time
B) You can print more than one worksheet at a time
C) You can enter common data, formats, and formulas on multiple worksheets at one time
D) B, and C
Q819 Easy

In Microsoft Excel 2016, which of the following tabs will you click for accessing the View Macros option?

Developer
Review
View
Home
Q820 Easy

A sales worksheet shows all sales for the year. Customer name in column A, sale status in column B and sale value in Column C. What value will the formula "=SumProduct(--(B3:B70="pending"))" return?

#N/A
The sum of the sale value of all accounts with pending status.
#Value
The number of accounts which have pending status.
Q821 Easy

The numbers, text, or cell references used by the function to return a value are called ____.

Classes
Objects
Arguments
None of these
Q822 Easy

To create a summary sheet requires navigation of ____________.

Summary sheet.
Detail sheet.
Synopsis sheet.
Review sheet
Q823 Easy

Which function returns the highest value of a range of cells?

MAXIMUM
BIGGEST
MAX
HIGHEST
Q824 Easy

On a chart created in excel, the vertical axis is also called the ____.

Y-axis
Z- axis
X-axis
Labels
Q825 Easy

In Excel, what does the Signatures icon on the status bar indicate?

It signifies that a macro is enabled.
It signifies that the document contains digital signatures.
It signifies that a macro is disabled.
It signifies that a webcam has been detected.
Q826 Easy

A table name cannot include ____.

Numbers
Spaces
Underscores
All of these
Q827 Easy

The Doughnut chart type

Compares a collection of values from several different data sets
Compares values from different categories. Values are indicated by the height of the columns
Compares relative values of different categories to the whole. Similar to the pie chart except that it can display multiple sets of data.
Compares three sets of values in a three-dimensional chart
Q828 Easy

Analyze the syntax of LOOKUP function when used in vector form?LOOKUP(lookup_value, lookup_vector, result_vector)The values in the lookup_vector must be placed in ________ order.

Ascending
Descending
Either ascending or descending
Q829 Easy

In Microsoft Excel 2016, which of the following options can be locked in a worksheet?i) Rangesii) Formulas

Only option i).
Only option ii).
Both options i) and ii).
Neither option i) nor ii).
Q830 Easy

The median function finds ________.

The middle value in a range of cells
Final cell
Receiving range
Receiver cell
Q831 Easy

In a pie chart, slices that are pulled away are said to be ____.

Dentified
Exploded
Opened
Extracted
Q832 Easy

Which of the following is the correct keyboard shortcut to insert a new worksheet?

CTRL+N
SHIFT+F11
CTRL+ALT+F6
ALT +N
Q833 Easy

True or False: The SUMIF function adds values in a range that cannot be defined by the user.

False
True
Q834 Easy

Which of the following chart types is featured in Excel?

Pointed Charts
Vertical Charts
Surface Charts
Dense Charts
Q835 Easy

The _____ error value means that a value is not available to a function or formula.

#N/A
Principal
RATE
.doc
Q836 Easy

To compare B14 and C12 and return the value of C12 if it is less than the value of B14, write: =IF(____, B14, C12)

B15
C12>B14
B14>C12
B19
Q837 Easy

Is SmartArt available in Excel?

Yes
No, it is only available in Word.
No, it is only available in PowerPoint.
Q838 Easy

What is the result of the formula =4&3?

43
12
7
Q839 Easy

This counts the number of chosen data in a range of cells.

COUNT:
Counter
C#Num
CON
Q840 Easy

True or False: When you record a macro in Excel, you are actually creating a VBA program.

False
True
Q841 Easy

Cell A1 has the number "3" in it. Cell A2 has the value "5" in it. If you merge these two cells together, what is left in the merged cell?

3
Merge is not allowed betweens cells that each contain a value.
8
5
Q842 Easy

The date you change a file is an example of a(n) ____ property.

Indexed
Standard
Automatically updated
Baseline
Q843 Easy

Which chart would be best used to illustrate a proportional relationship?

Column Chart
XY Chart
Line Chart
Pie Chart
Q844 Easy

True or False: Converting a table back to a range will maintain the table style used

True
False
Q845 Easy

How does one save the active workbook without altering the file or folder name.

Copy and paste.
Double click the box.
Highlight and drag a cell.
Click save button (on top of home)
Q846 Easy

Cell A1 has the formula =5+A+6. The formula result of B1 = IFERROR(A1,22) is:

TRUE
FALSE
11
22
Q847 Easy

Which worksheet function returns the most common value in a data set?

MODE
MAXIMUM
MEAN
MEDIAN
Q848 Easy

Which option would you to use visualize the relative value of cells in a range?

Icon Scale
Icon Sets
Icon Range
Icon Values
Q849 Easy

What is the term for an expression that is entered into a worksheet cell and begins with an equal sign?

Function
Argument
Formula
Contents
Q850 Easy

A constant is a value in a formula that doesn’t change. _______________

True
False
Showing 850 of 1421 questions

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

Report a mistake

What's wrong?