Skip to content

Excel MCQ Questions

0
Answered
0
Correct
0%
Accuracy
Q351 Easy

When a cell containing a formula is copied and then pasted into a new cell, Excel:

Does nothing
Edits cell references in the newly copied formula
Doesn't adjust relative cell references
Only adjusts absolute cell references
Q352 Easy

Autofill will fill a series when you establish a pattern ________.

It is centered on the page
Absolute cell reference
With two or more cells
It is a green plus sign
Q353 Easy

If you don't see the Solver button on the Ribbon, how can you get it?

On the Insert tab of the Ribbon, click My Apps. From the drop-down list, choose Solver.
On the File tab of the Ribbon, choose Options. Click Add-Ins, then enable the Solver.
On the Insert tab of the Ribbon, click Store. From Microsoft's app store, download the free Solver app.
If the Ribbon doesn't have the Solver button, it means you need to upgrade Excel to the Professional version.
Q354 Easy

What is not a Excel function category?

Financial
Database
Numbers
Text
Q355 Easy

How would you find the absolute value of A1?

#VALUE!
#NAME?
content
Q356 Easy

The goal of a ______ is to convey the maximum amount of information within a very small space.

Data series
Combination
Sparkline
Move Chart
Q357 Easy

What is the home position in an Excel worksheet?

H
A1
B3
A0
Q358 Easy

In the formula =sum(B1:B5), what does the ":" represent?

First Number
Several Numbers
And
All numbers between (if applicable)
Q359 Easy

Suppose you made some changes in Sheet1 in cell 'B13' and you want to change the same cell in Sheet2. Which of the following functions will help you for this task?

Combine
Group
Macro
Copy and Paste
Q360 Easy

Which of the following is not true regarding naming a cell?

Names are case sensitive
A name can contain up to 255 characters
Names can contain uppercase and lowercase letters
Some keyboard characters can cause unexpected results if used in cell names
Q361 Easy

What function would you use if you want to find the 3rd largest value in a set of data?

PERCENTILE.INC
MAXA
TREND
LARGE
Q362 Easy

By placing the cursor in a cell and inserting a picture, the picture is then "attached" to that cell.

False
True
Q363 Easy

Which of the functions listed will not work if you are looking for an exact value based on a right lookup column?

VLOOKUP
INDEX & MATCH
Both a and b
None of the above
Q364 Easy

A formula can contain ____ and mathematical operators

Arithmetic
Logic
None of these
Q365 Easy

What VLOOKUP parameter provides the multicolumn range or name of the range or date table to be searched?

Table_array
Col_index_num
Lookup_value
range_lookup
Q366 Easy

True or False: You can convert an existing shape to a Freeform Shape.

False
True
Q367 Easy

Spreadsheets are particularly useful for ____.

Real-world
Computer centric
Utility
What If analysis
Q368 Easy

The first step in creating an effective worksheet is to make sure you ____.

Understand what is required
Displays cell contents with two decimal places that align vertically
INSERT
Automatically updated
Q369 Easy

I have a price list stored in a worksheet, and I need to increase all prices by 10%. Can I do this without reentering all the prices?

Yes, several utilities exist for security minded.
No, you need to work all your data at once.
Yes, Insert or find a blank column near the prices.
Yes, Put codes in your work sheet tabs.
Q370 Easy

Which of the following Microsoft Excel 2016 functions is used in order to return the serial number that is used for representing the date, which is the indicated number of months before or after a specified date?

EDATE
EOMONTH
DATEVALUE
NUMBER
Q371 Easy

Which character denotes a text entry?

#
@
'
$
Q372 Easy

Which symbol is used as a reference operator?

All of these can be used
A Space
A Comma
A Colon
Q373 Easy

Each excel file is called a workbook because?

It can contain text and data
It can be modified
It can contain many sheets including worksheets and chart sheets
You have to work hard to create it
Q374 Easy

Imagine a leaderboard of 1000 players. Column A shows player rankings, B their names and C their points. You want to sum the points of the top X players, where X is defined in D1. What is the correct formula?

sumif(A:A,<=D1,C:C)
sumif(A:A,"<="&D1,C:C)
sumif(C:C,<=D1,A:A)
None of these
Q375 Easy

If you want to highlight a row of numbers by less than, greater than or equal to, what should you use?

Font
Fx
Page Layout
Conditonal Formatting
Q376 Easy

Use ____ references when you want different formulas to refer to the same cell

Logical
Optional
Absolute
Arguments
Q377 Easy

When you don’t want to associate a font with a particular design, you use a _____ font.

Theme.
Serif.
Sans serif.
Non-theme
Q378 Easy

Which of the given page margins are available under the Page Layout tab in Excel 2016?

Normal
Wide
Narrow
All 1, 2, and 3
Q379 Easy

The difference between the COUNT function and the COUNTA function is:

They are interchangeable and return the same value
COUNT only recognizes cells in the range that contain values; COUNTA will also include cells that are text
COUNT only recognizes numbers; COUNTA only recognizes cells that contain text
COUNT recognizes numbers and text; COUNTA only recognizes cells that contain text
Q380 Easy

Cell C6 contains =VLOOKUP(A6,$F$2:$G$10,2,FALSE) and returns #N/A, although Mallory's name in A6 also appears in column F with her ID (2H54) beside it. What is the most likely reason?

The absolute/relative cell references in the formula are wrong
Cell A6 is not actualy text its a formula that need to be copied and pasted as a value
Column C in the lookup range is not sorted properly
A trailing space probably exist in cell A6 or F7
Q381 Easy

Function to find the intersection of a row & a coulmn in a given range

OFFSET
INDEX
VLOOKUP
None of Above
Q382 Easy

All forumulas in Excel begin with the following symbol

+
#
=
%
Q383 Easy

What is the operator for concatenating two text strings together?

#
&
!
+
Q384 Easy

Argument names that display in ________ are required; others are optional.

Bold
Italics
Underlined
Q385 Easy

Can you perform a case sensitive data sorting in Microsoft Excel 2016?

Yes
No
Q386 Easy

What is/are the default file extension(s) of a Microsoft Excel 2016 workbook?

.xls
.xlsx
.doc
Both options a and b.
Q387 Easy

Which of the following is an example of how you would use a data table?

You're estimating loan payments and want to see combinations of different interest rates and principal amounts.
You're planning a small construction project that has 6 variable costs. You want to see different combinations of all these variables.
You have 1000 rows of invoices spanning 3 months and 5 products. You want a summary of product sales by month.
You want to know the rate of return on an investment when you know the present value and future value.
Q388 Easy

True or False: It is possible to sort information both vertically (by columns) and horizontally (by rows)

True
False
Q389 Easy

Identify the error: When entering 325 in a cell, the result shows up as 3.25.

Fixed Decimal mode is turned on.
"What-if" analysis has converted all entries for simple compiling.
Rounding has been set to reduce all numbers by 99%.
This is a common glitch in Excel 2007. Upgrade ASAP.
Q390 Easy

If a cell contains a value that does not begin with the correct operator, Excel evaluates it as...

An array formula
An error
A reference to another file
Text
Q391 Easy

If A1=7 and B1=7 what will the formula "=A1=B1" return?

14
FALSE
It will be an error
TRUE
Q392 Easy

You can change the color of the following in Excel:

Background
Font
Headers/Footers
All Listed
Q393 Easy

Which of the following is available as fill options while formatting cells of an Excel worksheet using the format style as Data Bar?

Gradient Fill
Crystal Fill
Texture Fill
Q394 Easy

You can replace a formula with its function so it remains constant.__________

True/splitting
NOW Function
True/12
True/Function
Q395 Easy

Which is a type of operator?

Arithmetic
All of these
Comparison
Text Concatenation
Q396 Easy

In Microsoft Excel 2016, which of the following Engineering functions tests the equality Of two numbers?

BESSELI
BITOR
BlTAND
DELTA
Q397 Easy

The ____ category of excel functions returns (true-false) values.

Logical
Absolute
Optional
Median
Q398 Easy

Which of the given methods would you follow to add an alternative text to a picture?

Right-click on the picture, click on Size and Properties. Click on the Alt text tab, and then in the alternative text box, enter your text
Right-click on the picture, click on Format. Click on the Alt text tab, and then in the alternative text box, enter your text
Both a and b
None of the above
Q399 Easy

Where do you change the default font for new workbooks?

File --> Options --> Proofing
File --> Info --> Permissions
File --> Options --> General
File --> Options --> Advanced
Q400 Easy

If you add a column within the source data range of a pivot table, then the pivot table...

will require recreation of the pivot table on a new tab
will incorporate the new field upon "Refresh"
will automatically incorporate the new field
will require a reset of the source data manually or by using the Wizard
Showing 400 of 1421 questions

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

Report a mistake

What's wrong?