Skip to content

Excel MCQ Questions

0
Answered
0
Correct
0%
Accuracy
Q551 Easy

What is the sequence of operating mathematical operation in Excel?

Brackets, Exponents
Division, Multiplication
Addition, Subtraction
All of the above
Q552 Easy

If a sheet tab has ________ you know that it is not selected.

Background color
Text color
Border color
Q553 Easy

Use___ to visualize the relative values of cells in a range. In this case, however, Excel adds a particular icon to each cell in the range, and that icon tells you something about the cell’s value relative to the rest of the range?

Icon Scale
Icon Sets
Icon Range
Icon Values
Q554 Easy

What can be protected from accidental modification?

Contents, objects, and scenarios
Only contents
Objects and scenarios
Contents and objects
Q555 Easy

You can enable or disable macros with options in the ____ dialog box

Macro Options
Trust Center
Excel Options
Security Center
Q556 Easy

By default, excel includes _______________ when copying or filling a series.

Formatting
One million
Worksheet
Arguments
Q557 Easy

Can the Match & Index Functions be combined together to perform a lookup?

No
Yes
Q558 Easy

Data can be arranged in a worksheet in an easy to understand manner by

Applying Styles
Changing fonts
All of these
Changing decimals
Q559 Easy

You've selected a range of sales data that has categories across the top row of the columns. How can you get filter buttons on this row, and alternate-row striping for the data?

Use only the Format as Table command on the Home tab. The Table command on the Insert tab will insert a table from Microsoft Word
Use the AutoFilter button on the Insert tab to get the filter buttons, then select an alternate-stripe style from the Page Layout tab
Use either the Format as Table command on the Home tab, or the Table command on the Insert tab of the Ribbon
Use only the Table command on the Insert tab. The Format as Table command on the Home tab won't insert filter buttons
Q560 Easy

Excel remembers the last ____ actions you have completed

25
50
75
100
Q561 Easy

Cell B1 contains the text "A1". What function do you enter in cell C1 that refers to B1 and as a result shows the value in cell A1?

Search()
Substitute()
Indirect()
Replace()
Q562 Easy

Which worksheet function returns the minimum value in a list of arguments?

MINA
MINARG
MIN
MINVAL
Q563 Easy

To show a "-" instead of a zero in cells with zero value, you must adjust the settings in what way?

View / 'Show/Hide' menu / Suppress zeros
Requires a macro
Font Settings / Suppress Zeros
Set the number system to "accounting"
Q564 Easy

What does the keyboard shortcut F12 do?

Inserts a new worksheet.
Maximizes or restores the selected workbook window.
Displays the Paste Name dialog box.
Displays the Save As dialog box.
Q565 Easy

Which function would you use to find the largest number of a selected range?

LARGEST
MAX
LARGE
MAXIMUM
Q566 Easy

Cell A1 contains the number 3, Cell A2 contains the number 4. If Cell A3 contains the formula =IF(A1>A2, "true", "false") what solution will Excel return?

#name?
#NUM
false
N/A
Q567 Easy

The ____ function is useful when you want to assign a value to a cell based on a logical test.

IF
Fill Without Formatting
NOW
Sparkline
Q568 Easy

What is the correct term for separating contents from one cell into two by a common character?

Seperated
Fixed Width
Text to Columns
Delimited
Q569 Easy

If you have a workbook with links to another workbook, but the links haven't updated automatically, how can you update them manually?

From the Data tab, click Update all Links.
Press Ctrl + Shift + L.
From the File tab, click Properties. Select the option for Update Links in this Workbook.
From the Data tab, click Edit Links, then click Update Values.
Q570 Easy

By default, excel worksheets appear in ____________ view.

Font style
Normal
Legend
Sort
Q571 Easy

Concatenation of text can be done using

Ampersand (&)
Question mark (?)
Exclamation (!)
Semi-colon (;)
Q572 Easy

What is the keyboard shortcut to display the Format Cells dialog box?

Ctrl + F1
Ctrl + C
Ctrl + 1
Ctrl + F
Q573 Easy

What is the intersection of a worksheet row and column?

Cell
Selection
Element
Scalar
Q574 Easy

Which of the following is a math & trig function? ____

INT
COUNT
MIN
AVERAGE
Q575 Easy

Viewing a pivottable report only for a subset that meets a selection criterion is known as ____.

Organizing
Implementing
Sorting.
Filtering
Q576 Easy

What happens when you double click on a cell?

Nothing
It is highlighted
It become editable
Q577 Easy

Cells of the second line of defense called ________ recognize and kill virus-infected cells.

Basophils
Eosinophils
Macrophages
NK cells
Q578 Easy

Using the mouse to move or copy cells is called ____.

Mouse copy.
Move and drop.
Drag and drop.
Mousing
Q579 Easy

____ adds a range of cells together.

AVERAGE: Average
MIN:
COUNT:
SUM: Summation
Q580 Easy

If you want to freeze the top row and first column which cell must you highlight before clicking Freeze Panes?

B1
A1:B2
B2
A1
Q581 Easy

Which function will return the largest value within the range?

MID
NLARGE
LN
MAX
Q582 Easy

The SUMIF function is very useful for single-criterion sum formulas. The SUMIF function takes three arguments NOT including:

Criteria
Range
Sum_range
Point
Q583 Easy

Which of the following formulas shows the correct syntax of a VLOOKUP() formula in the 3rd column?

#NAME?
#NAME?
Q584 Easy

Using IF(), to test if a number in cell D2 was between 10 and 1000 the correct function would be:

false
true
Q585 Easy

By using names, you can make your formulas much easier to understand and maintain. You can define a name for a cell range, function, constant, or table. Names must be no more than 255 characters long, you can also use any single letter as a range name except the following?

R
A
C
Z
Q586 Easy

What is the default font for a new Microsoft Excel 2016 workbook?

Arial - 12 points
Dante - 11 points
Calibri - 11 points
Courier New - 12 points
Q587 Easy

The if function's logical test returns _____ result.

Criteria
Balance at the end of the loan
Very small and very large numbers
Only a true or false
Q588 Easy

The chart wizard term data series refers to:

a set of values you plot in a chart
a chart legend
a collection of chart data markers
a data label
Q589 Easy

To print a page number on the bottom of every printed page:

Select the option in the format menu
Make a selection in the Page Setup dialog box
Type a number in the bottom-center cell of each page
Insert the function =PAGENUMBER(True) as a footer
Q590 Easy

Make sure the header row option button is selected to indicate ____.

You add a new row to the bottom of the table
Delete All
The alignment remains intact.
Not to include that row in a sort
Q591 Easy

To control the display of the numbers along the horizontal axis of a line graph, adjust the:

Scale of the x axis
Scale of the y axis
Range of the source data
Maximum value of the Y axis
Q592 Easy

Which worksheet function counts all cells with numerical and text values?

CHITEST
COUNT
COUNTA
COREL
Q593 Easy

Select _______ to apply formatting to several cells at the same time.

A range
A label text cell
A cell containing a value
Any cell
Q594 Easy

What happens to a "relative" cell when it is copied to a new cell?

It's relatively modified
Nothing
####
It returns an error message
Q595 Easy

What are the correct purposes of CEILINGMATHI) function in Microsoft Excel 2016?

It rounds a number up, to the nearest integer.
It rounds a number up, to the nearest multiple of significance.
It rounds a number down, to the nearest even integer.
It rounds a number up, to the nearest odd integer.
Q596 Easy

Which of the following is a default method of a PivotTable report for scoping the conditional format of fields in the values area?

By selection
By corresponding field
By value field
By number field
Q597 Easy

In Microsoft Excel 2016, which of the followings is NOT a valid option for Macro Settings under the Trust Center?

Disable all macros without notification.
Disable all macros with notification.
Disable all macros including digitally signed macros.
Enable all macros.
Q598 Easy

To rotate text in a worksheet, in the format cells dialog box, you can click and drag the ________.

Red circle
Blue diamond
Red diamond
Black, bold triangle
Q599 Easy

To size a chart proportionately, hold down the ________ key and ________.

Shift; drag a corner sizing handle.
Expressions Within Parentheses
Width
Height
Q600 Easy

What is a cell?

A series of columns.
A series of rows.
The intersection of a column and row.
The total of two numbers.
Showing 600 of 1421 questions

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

Report a mistake

What's wrong?