Skip to content

Excel MCQ Questions

0
Answered
0
Correct
0%
Accuracy
Q701 Easy

Which worksheet function returns the rank of a number in a list of numbers?

RANK
NRANK
RANKN
RANKL
Q702 Easy

In an Excel table with data in rows 2 to 6, you enter the formula =B2*C2 in cell D2. What happens if you select D2 and drag its fill handle down to D6?

The same formula will be applied to all the other cells.
The value of cell D2 will be copied to all other cells.
It will increment the value of cell D2 by 1 for every cell up to cell D6.
Error value will be displayed in all other cells.
Q703 Easy

What will be the result of this formula =MOD (40, 0) ?

#DIV/0!
40
Blank
#VALUE
Q704 Easy

Cell A1 of an Excel sheet contains the text "this is a book". What is the result of entering =PROPER(A1) in cell A2?

This is a Book
This Is A Book
This is a book
It will throw an error because the formula cannot contain cell reference.
Q705 Easy

Which of the following is NOT a way to align a cell?

Align Left
Align Reverse
Align Center
Align Right
Q706 Easy

What happens when the Freeze Panes option is used on some of the rows and columns in Microsoft Excel 2016?

It keeps the rows and columns visible when the rest of the worksheet is scrolled.
It keeps the rows and columns visible when the rest of the worksheet is scrolled.
The selected rows and columns cannot be edited while the rest of the worksheet can be edited.
The selected rows and columns can accept only a particular type of data.
Q707 Easy

_____ messages appear as screentips next to the active cell.

Value
Input
Key
User
Q708 Easy

in relation to the Backstage view in Microsoft Excel 2016, which of the given commands! options are available under the Info tab?1. Protect Document2. Manage Workbook3. Browser View Options

All 1, 2, and 3
Only1 and 2
Only1 and 3
Only 2 and 3
Q709 Easy

If you choose Find & Replace All when the cursor is in one cell, it will result in:

Replacement only in that cell
Replacement only in that column.
None of these
The command replacement of the entire worksheet
Q710 Easy

In Excel 2016, the Forecast Sheet feature can turn a worksheet which contains historical financial data in a visual forecast worksheet. What type of chart is used by default if you do not use a chart of your own choice?

Area Chart
Line Chart
Pie Chart
Bar Chart
Q711 Easy

What is the purpose of the Σ button?

Totaling a column or row
Auto-saving
Recording a macro
Sorting Data
Q712 Easy

Which Consolidate option would you choose when you want to arrange the data in all the worksheets in identical order and location?

Consolidate by position
Consolidate by category
Consolidate by formula
None of the above
Q713 Easy

Column A lists a long string (example:A3= 1234Smith1740.434.21) where the first four digits are the employee number. What formula in B3 will extract only the employee number from the string in cell A3?

#VALUE!
#VALUE!
den?
Q714 Easy

Formatting a cell in Currency, you can specify...

currency symbol
decimal places
none of the above
both decimal places and the currency symbol
Q715 Easy

Robert inserts a PivotTable in Sheet 2 of a worksheet. He drags the "Days" field from the PivotTable Fields to Values section. Which of the following options will be the default selection under Values?

Max of Days.
Average of Days.
Sum of Days.
Count of Days.
Q716 Easy

How can you format one sparkline separately from all the others?

Ungroup the sparklines.
Just select any one, and apply the formatting you want.
On the Sparkline tab on the Ribbon, select the option for Current Only.
On the Design tab on the Ribbon, click the Sparkline Editor button.
Q717 Easy

Currency figures in Excel can be changed from US Dollars to the:

Yuan
Euro
None Listed
All Listed
Q718 Easy

In an Excel worksheet, the cells in the Registrations column have small red triangles in their upper-right corners. What do these signify?

The red triangles represent the comment associated.
The red triangles signify an associated data validation control.
The red triangles represent the tracking of the cell.
The red triangles signify that the cell is a hidden cell.
Q719 Easy

A ____ is text and graphics that print at the bottom of every page.

Toe
Footer
Margin
Stopper
Q720 Easy

If you want to set the print area which ribbon should you use?

HOME
DATA
REVIEW
PAGE LAYOUT
Q721 Easy

What function do you use to find the present value of a series of annual cash flows at a specified discount rate?

PVA
PV
NPV
PVCF
Q722 Easy

Which feature lets you scroll through two worksheets simultaneously, making it easier to check one sheet against another?

Freeze Panes
Synchronous Scrolling
AutoScroll
Arrange All
Q723 Easy

Identify all the arguments and the correct order of arguments needed to execute the IF() function.

logic test, value if false
logic test
logic test, value if true, value if false
logic test, value if false, value if true
Q724 Easy

What is the main difference between a Sumif equation and a Sumifs equation?

Sumifs equations allow multiple sum_range columns. Sumif equations allow only one sum_range column.
Sumifs equations do not exist. Sumif equations do exist.
Sumifs equations allow only one criteria. Sumif equations allow multiple criteria.
Sumifs equations allow multiple criteria. Sumif equations allow only one criteria.
Q725 Easy

Which of the following is True when #NAME, error appears in Excel cell?

You spelled a range name incorrectly.
You used a range name that you haven’t yet defined
You spelled a function name incorrectly.
You used a string value without surrounding it with quotation marks.
Q726 Easy

Which Lookup function should be used when the comparison values are located in a column to the left of the data that is to be found?

HLOOKUP
VLOOKUP
TRANSPOSE
None of the above
Q727 Easy

Which of the following is mixed cell reference with a fixed row address?

P72
$K356
$F$8
G$9
Q728 Easy

How will you apply restrictions on data entry except the whole number to selected cells on the worksheet?

Click the data validation option “Whole number” in the Allow box, click desired Data option under Edit menu then click OK.
Click the data validation option “Whole number” in the Allow box, click desired Data option under Tools menu then click OK.
Click the data option “Whole number” in the Allow box under Data menu then click OK.
Click the data validation option “Whole number” in the Allow box, click desired Data option under Data menu then click OK.
Q729 Easy

Where can the 'Show All Comments' command be found?

On the Page Layout tab
On the View tab
On the Review tab
All of the above
Q730 Easy

Values are evaluated using ________ operators.

Comparis
Arithmetic
Comparison
Serial
Q731 Easy

Which of the following is not a predefined replacement for the [format] portion of the following expression? FORMAT (expression, [format])

Currency
Text
Scientific
Fixed
Q732 Easy

What does an asterisk signify in a formula?

Add
Divide
Subtract
Multiply
Q733 Easy

Which worksheet function returns the probability associated with a Student's t-test?

STDPROB
TTEST
TSTDTEST
PROBTTEST
Q734 Easy

Which database function estimates variance based on a sample from selected database entries?

DSTDEV
DSUM
DVAR
DVARP
Q735 Easy

Which Excel add-in will help you find a target result by varying multiple inputs to a formula?

Goal Seek
Power Pivot
Data Analysis
Solver
Q736 Easy

Like the autofilter query technique, the ____ command displays a subset of the table.

Advanced Filter.
Conditional
Extracting
Outlining
Q737 Easy

What is a shortcut to minimize or maximize the ribbon?

CTRL+ F1
TAB+DEL
CTRL+ALT+DEL
SHFT+DEL+ALT
Q738 Easy

The formula QUARTILE(a1:a100,2) returns the same value as:

#DIV/0!
#VALUE!
Q739 Easy

In Microsoft Excel 2016, the Save As option can be accessed from which of the following tabs?

File
Home
Review
View
Q740 Easy

True or False. If you choose a larger font size, the height of the row is automatically made taller.

True
False
Q741 Easy

What keyboard shortcut will create a chart of the data in the current range in a separate Chart sheet?

Alt + F11
Ctrl + Shift + F11
Ctrl + F11
F11
Q742 Easy

How can you bring up the built-in Help?

On the Ribbon's View tab, click Help
On the Ribbon's File tab, click Help, and by clicking the blue question mark in Excel's upper-right corner
Press Ctrl + H
On the Ribbon's Help tab, click Show Help, and by right-clicking the Formula bar and choosing Help
Q743 Easy

True or False: The value in a cell that contains the formula =RAND() changes every time any change is made to the workbook.

True
False
Q744 Easy

A worksheet range is as following?

A command used for data modeling
A range of values such as from 23 to 234
A group of cells
A group of worksheets
Q745 Easy

True or False: You can protect a single worksheet and leave the others with full access.

True
False
Q746 Easy

Which of the following statements are true regarding PowerPivot in Microsoft Excel 2010?

PowerPivot streamlines the process of integrating data from multiple sources like databases, spreadsheet, reports and text files
PowerPivot does not allow access to slicers when working on data in PowerPivot.
Version control and tracking are NOT supported by PowerPivot.
Q747 Easy

Timelines are particularly designed for _______ fields that sort out data from a pivot table.

formatting
numeric values
date
text
Q748 Easy

Which of the following is a valid option in the Data Validation Allow settings?

Warning
Duplicates
Text Size
Text Length
Q749 Easy

To build a PivotTable, how must your data be formatted?

Without zeros
Each column must have a header
Table format
Each row must have a title
Q750 Easy

A(n) ________ refers to a cell by its fixed position in the worksheet.

Relative cell reference
Absolute cell reference
3-D cell reference
Data marker
Showing 750 of 1421 questions

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

Report a mistake

What's wrong?