Skip to content

Excel MCQ Questions

0
Answered
0
Correct
0%
Accuracy
Q1351 Easy

Which formula yields the address of the last cell in a range?

0
#NAME?
Q1352 Easy

Double clicking the currently-selected tab on The Ribbon will do what?

Automatically format worksheet
Pull up dialog box
Collapse the ribbon
Open customize window
Q1353 Easy

True or False: Once cells are merged in Excel, they can never be un-merged.

True
False
Q1354 Easy

To ensure a worksheet will print all on one page, adjust the settings in the:

Paper size option
Margin Dialog box: Shrink to Fit
Page Layout/Page Setup dialog box
Zoom command
Q1355 Easy

Which formula below will add the value of B2 to the value of C3

#VALUE!
#VALUE!
Q1356 Easy

The formula QUARTILE(a1:a100,4) returns:

All of these
The highest number in the list
The maximum value of the range
100% Percentile Value of the A1:A100 range
Q1357 Easy

Which of the following wildcard characters can be used as comparison criteria for Text Filters?

?
*
~
All of the above
Q1358 Easy

To unhide a sheet and make viewable with other tabs in the current window:

Press CTRL-U
Adjust Custom View selection in View menu
Right click on any tab, select Unhide, choose the tab from the list to unhide
In the View menu select Unhide
Q1359 Easy

An __________ is an object in a worksheet.

Numbers
Formulas
Formula
Embedded Chart
Q1360 Easy

How to compute a sum?

Ask your friend for his calculator
Use sum formula and select the relevant cells as argument
Q1361 Easy

Center, left and right text justification are examples of ________.

Rules of logic used to solve computational problems.
Cryptographic alignment used in encoding a document.
Different ways to reason over an pattern recognition algorithm.
Typographic alignment used in formatting a document
Q1362 Easy

In Microsoft Excel 2016 worksheet, which of the following shortcuts is used for switching between displaying formulas and their results?

CTRL + s
CTRL + D
CTRL + & (Ampersand)
CTRL + ‘ (grave accent)
Q1363 Easy

If cell A2 has a full name (Fristname, Middle Initial and Lastname) like "Karen E. McRich" which of the following formula will extract the lastname?

distributes Excel?
#VALUE!
Q1364 Easy

Rather than creating a new, blank workbook by clicking the File tab, selecting New, then clicking Blank, what's the keyboard shortcut?

Ctrl + S
Ctrl + N
Ctrl + Shift + N
Ctrl + W
Q1365 Easy

How can you launch a regression in excel 2010?

Data tab->data analysis->analysis tools-> regression
Data tab
Developer tab
Q1366 Easy

If A1 is "=4*2" and B1 is "=6/2", what result would appear if C1 was "=A1(#)B1

Error
0
#REF
VALUE
Q1367 Easy

You can use ____ to move around in a document that is too large to fit on the screen at once.

Zoom
Create what if data scenarios
Templates
Scroll bars
Q1368 Easy

Validation rules are entered in the ____

Text box
Seach box
Find and replace text box
None of the above
Q1369 Easy

The aggregate function extends the capability of the subtotal function. Which function calculates the variance of values in the range by examining a sample of the values?

VAR.P
VSAMPLE
VAR.S
SUMSAMPLE
Q1370 Easy

Excel 2003: Also called a spreadsheet, the _____ is a unique file created by Excel.

formulas
working area
cells
workbook
Q1371 Easy

Using the excel spell checker, you can ____.

Check the spelling in a single cell
Check the spelling of words in a selected range
Add words to the dictionary
All of these
Q1372 Easy

In Microsoft Excel 2016, data sorting in columns can be performed on which Of the given Options?1. Values2. Cell Color3. Font Color4. Cell icon

All 1. 2. 3, and 4
Only1, 2. and 3
Only 2. 3. and 4
Only 1. 3. and 4
Q1373 Easy

Which formula returns the value in cell A10 of the worksheet named Budget Variances?

#NAME?
#NAME?
=
=
Q1374 Easy

How do you ensure that the person using a spreadsheet can always see the column headings?

Use Freeze Panes or Freeze Top Row.
Print to fit on one page.
Re type the headings every few lines.
Reset the view Zoom percentage.
Q1375 Easy

Which of the following is not an excel function category? ____

Math & Trig
Stastical
Algebria
Text
Q1376 Easy

What's the recalculate shortcut?

Tab
F5
F9
Shift
Q1377 Easy

What is the benefit of using Slicers?

They separate data into separate fields, like full name into first and last name fields
They insert new fields into an existing PivotTable
They split a large PivotTable into two or more smaller ones
They provide an interactive way of filtering a PivotTable
Q1378 Easy

The ____ option helps fit the data on a single page without making changes to individual margins.

Page Break View
Scale to Fit
Paginate
Squeeze
Q1379 Easy

The "Merge & Center" button does what?

Merges cells together that are not physically attached
Combines the quantities in two cells and centers the result
Changes the font size on a cell
Merges a cell with text with attached cells and centers the text over the range of cells
Q1380 Easy

What command reveals which cells must contain data for the function in the currently selected cell to work?

Trace Precedents command
Trace Dependents command
PRIOR() function
DEPENDENT() function
Q1381 Easy

What is the purpose of the BIN2HEX function?

To convert a hexadecimal number to a binary number.
To multiply the BIN by 2.
To compare binary and hexadecimal numbers.
To convert a binary number to a hexadecimal number.
Q1382 Easy

True of False? Excel 2013 will let you save a file into a cloud service, like Microsoft OneDrive or Sharepoint.

False
True
Q1383 Easy

You can add an image to a template by clicking the Insert Picture From File button on the __ Toolbar?

Picture
Drawing
Formatting
Standard
Q1384 Easy

The ____ aggregate function finds the smallest value.

Min
Max
Filter
None of these
Q1385 Easy

A screen ____ is a portion, usually of one object or section of a window, of the screen.

Raw data
Clipping
Template
Templates
Q1386 Easy

Let's say you have rows of names & addresses, and you want to sort by Zip code. How would you do this?

Select all the cells that contain data, then sort
Click any cell in the Zip code column, then sort
Select the entire Zip code column, then sort
Select all the columns that contain data, then sort
Q1387 Easy

Category values are usually located in the ____ of the data source.

Exploded pie chart
Quick analysis
Data labels
Either a or b
Q1388 Easy

The formula =REPLACE("the cat in the hat",12,3,"red") returns:

the red cat in the hat
red cat in the hat
red cat in red hat
the cat in red hat
Q1389 Easy

What is a logical function?

A function that inserts or calculates dates or times
A function related to monetary calculations
A function that works with statements that are either true or false
Q1390 Easy

State whether following statement regarding images in Microsoft Excel 2010 is true or false:Microsoft Excel 2010 supports 3D rotation of images.

True
False
Q1391 Easy

Identify the one function in the following list that does not require the use of any argument(s):

RAND
COUNT
SUM
COUNTA
Q1392 Easy

By default, the pivottable report uses the ____ function for numbers in the values area.

COUNT
AVERAGE
MIN
SUM
Q1393 Easy

The oracle string concatenation function is _____.

CONCAT.
+.
||.
&&
Q1394 Easy

What is the difference between pressing the delete key and using the clear command in the Home tab's Editing group?

Deletes removes the entire column or row. Clear removes the content from the column or row
Deletes removes formulas, values and hyperlinks. clear removes formulas, values, hyperlinks, formats, comments and notes
Delete removes the cell itself, shifting cells either up or to the left. Clear removes content and properties but does not muves cells
Delete removes formulas and values. clear removes formulas, values, hyperlinks, formats, comments and notes
Q1395 Easy

John's PivotTable lists employee names with the Sum of Sales. The source data has Employee, Product and Sales columns. He wants to show the products under each employee name. Where should he double-click so that Excel asks him which field to show?

On the header of the Employee column.
On the values of the Sum of Sales column.
On the values of the Employee column.
On the header of the Sum of Sales column.
Q1396 Easy

If you enter the formula =mod(2,5) into a cell, what will the cell display?

5
2.5
An error message.
2
Q1397 Easy

An Excel 2016 table has a Units column, its last column, containing 5, 8, 7 and 9. If you select the table and check Total Row on the Design tab, what does the total row show under Units by default?

15
18
29
79
Q1398 Easy

What does the blue triangle and border color imply in cell B4?

They imply that a comment is associated to cell B4.
They imply that a filter has been applied to cell B4.
They imply that the Goal Seek option of What-if Analysis is applied to cell B4.
They imply that Track Changes has been enabled and cell B4 is edited.
Q1399 Easy

How do you create a cell featuring a drop down list of values?

Using Data Validation and "any value" as validation criteria
Using List Box (form controls) from the Developer tab
Simply creating a name range
Using Data Validation and "list" as validation criteria
Q1400 Easy

A "frequency distribution" is a summary table that shows the frequency of each value in a ___?

Workbook
Cell
Column
Range
Showing 1400 of 1421 questions

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

Report a mistake

What's wrong?