Skip to content

Excel MCQ Questions

0
Answered
0
Correct
0%
Accuracy
Q1301 Easy

Choose True or False.Data of a copied cell remains on the clipboard until a cell is not edited.

True
False
Q1302 Easy

How can you rename a worksheet?

From the File tab, click Save As, then save with a new file name
From the View tab, click Rename Sheet
From the Page Layout tab, click Rename Sheet
Double-click the worksheet's tab and type a new name
Q1303 Easy

Which worksheet function returns the average of selected database entries?

DAVG
DCOUNTA
DAVERAGE
DGET
Q1304 Easy

What is the best way to activate the Excel Help system?

Right-click anywhere and select Help.
Press F1 or click the Help tab in the ribbon.
Press F10.
All of these answers.
Q1305 Easy

Of the four chart types listed, which works best for summarizing time-based data?

Pie chart
Line chart
XY scatter chart
Bar chart
Q1306 Easy

What is the difference between the .XLSX and .XLS file format?

.XLSX format the xml as per the Excel sheet formatting but .XLS keeps the content as it is without formatting.
.XLSX is the XML file format in which Excel automatically saves any new workbook created but .XLS file format cannot support XML.
.XLSX does not support the XML file format but .XLS supports the XML.
None of the above.
Q1307 Easy

Assuming Cell A1 is populated with 16.8942, which of the following formulas would result in 16?

#VALUE!
#VALUE!
Q1308 Easy

The code _____ will display the filename of the current workbook.

&name
&[File]
+name
+[File]
Q1309 Easy

Which worksheet function returns the poisson distribution?

PDIST
POISONDISTRUB
POISSONDIST
POISSON
Q1310 Easy

The ________ function returns one value if a condition is met, and a different value if it is not.

IF
MEDIAN
MAX
COUNTIF
Q1311 Easy

Which of the given statements are correct about the slicers in Microsoft Excel 2016?1. They can be used to filter data in a table.2. They can be used to f‌ilter data in a PivotTable.3. They can only be connected to PivotTables that share the same data source.

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

Functions like MATCH, INDEX, VLOOKUP and HLOOKUP require absolute cell references for the data range. What feature can make those references easier to read and understand?

Create a name for the data range, and use the name in the formula.
Instead of writing absolute cell references, select the cells, then go to the Data tab on the Ribbon and click the button for Make Ranges Absolute.
Instead of writing absolute cell references, press Ctrl + Shift when entering the formulas.
Instead of writing absolute cell references, go into Excel's advanced options and check the option to make all ranges absolute.
Q1313 Easy

You can access the find and replace feature by pressing the ____ key(s).

CTRL+H.
CTRL+A
CTRL+B.
CTRL+C
Q1314 Easy

Suppose that you conducted an aptitude test in a class room to check if the students are ready for competitive exams. Now you want to calculate the average of the total marks obtained by the students in the test. Which of the following formulas can be used to calculate the average of the "Marks Obtained" in the cell "I4"?

#DIV/0!
#NULL!
Both options a and c.
Q1315 Easy

When you nest functions, you should have ____.

Type the data in A1 and Merge cells A1:E1
The same number of left and right parentheses
Decrease number of digits displayed by clicking on the command in Numbers group
Autofits the column by double-clicking its border
Q1316 Easy

____provide descriptive text for the individual data markers, such as pie slices

Asset labels
Legend values
Data labels
Leader lines
Q1317 Easy

The formula =countif(a1,a1) typed in cell b1 will result in:

1, always
#VALUE!
#NAME!
1, unless a1 is blank
Q1318 Easy

The difference between centering text in a cell and centering a number is:

A number must always be right justified and cannot be centered
The text center command is part of the font selection
A number must be centered with the "Accounting" format option
There is no difference
Q1319 Easy

Which of the following types of files preserves cell properties, formulas, graphics, and other formatting?

.slk
All of these
.csv
None of these
Q1320 Easy

Data can be arranged in ascending or descending order by using:

Sort Command from Formatting Menu
Sort Command from Table Menu
Sort Command from Data Menu
Sort Command from Tools Menu
Q1321 Easy

How to open VBA coding pane?

Type alt f11
Alt-B
Q1322 Easy

In the formula =VLOOKUP(a2,c2:d100,2,false) the final argument indicates:

Find all numbers ending in zero
Find the closest match
Find an exact match
Return the first column
Q1323 Easy

Which of the following functions can be performed on a protected worksheet if the password is not known?

We can copy and paste data from the protected sheet to a new Workbook.
Insert columns are protected, but delete columns are not protected, therefore, we can only insert columns but can't delete columns in the protected worksheet
We can paste data into the protected worksheet.
We can de-crypt the password of the protected sheet.
Q1324 Easy

In Microsoft Excel 2016, what does the Look up value function do

Look up values vertically and horizontally in a list by using an exact match
Look up values vertically in a list by using an exact match
Look up values horizontally in a list by using an approximate match
Look up values vertically and horizontally in a list by using an approximate match
Q1325 Easy

Which of the following options can be copied using the format painter in Microsoft Excel 2016?1. Alignment2. Background color3. Cell text

Only 1 and 2
Only 1 and 3
Only 2 and 3
All 1, 2, and 3
Q1326 Easy

Which of the following is not a term of MS-Excel?

Columns
Document
Rows
Cells
Q1327 Easy

In relation to the Clear option under the Home tab in Microsoft Excel 2016. which of the following options can be cleared from the cell?

Formats
Contents
Comments
Layouts
Q1328 Easy

When would the data validation command be unavailable on the data tab?

When an Excel table is linked to a SharePoint site
When data in a cell is entered
When the workbook is shared or protected
All of the above
Q1329 Easy

A 3D reference means

A special kind of function that uses 3 numbers
Formatting with 3 colors
Adding a graphic to the spreadsheet
Reference to cells on other worksheets
Q1330 Easy

Which worksheet function returns the F probability distribution?

ZDIST
TDIST
FDIST
QIDIST
Q1331 Easy

Your PivotTable shows 20 products listed down column A. How can you make only the first 10 visible, and the rest of the products hidden?

Select the rows for the last 10 products, then press Delete on your keyboard. Remember to undo when you're finished.
On the task pane on the right side, drag products 11 through 20 out of the Rows area.
Collapse all products from 11 through 20.
Click the filter button on the header on column A, and deselect the last 10 products.
Q1332 Easy

To round up a value to the nearest increment of your choice, such as the next five cents, what function should you use?

ROUNDUP
MAX
ROUND
CEILING
Q1333 Easy

Which worksheet function estimates standard deviation based on a sample, including numbers, text, and logical values?

STDEV
STDEVA
STDEVNTL
STDEVALL
Q1334 Easy

The following sequence, 1, 2, 3, etc., is an example of a(n) ____ series.

Link
Date
Linear
Auto fill
Q1335 Easy

When you double-click a value in a PivotTable in Microsoft Excel 2010, Excel creates a new ________ with the data behind that value.

Table
Worksheet
Workbook
Q1336 Easy

In relation to the Cube function in Excel 2016, which Of the following functions returns an aggregated value from the cube?

CUBESET
CUBEMEMBERPROPERTY
CUBEVALUE
CUBEKPIMEMBER
Q1337 Easy

Data catalogs _____.

Can not be shared with everyone within a buseness
Can be shared with everyone within a business
None of these
Q1338 Easy

By default, excel aligns date entries at the ____ of the column.

Background
Right edge
8.11: 14.40
Window: View
Q1339 Easy

While creating a new workbook or editing an existing one, some personal information might get added to the file automatically. If you want to share this workbook with others, then which of the following options will you use to remove such additional personal information?

Lookup & Reference
Data Validation
Document Inspector
Track Changes
Q1340 Easy

_____ refers to cells not wide enough to display the entire entry.

#NULL!
#N/A
####
#REF
Q1341 Easy

Can you insert images from ClipArt into Excel?

Yes
No
Q1342 Easy

Excel keeps the changed history of a workbook for ________ days by default

10 days
20 days
25 days
30 days
Q1343 Easy

Which is the proper vba naming convention for a macro?

SubMacroName
MacroName
MacroName()
SubMacroName()
Q1344 Easy

What is the purpose of the Select All button in the top-left corner of an Excel worksheet?

It selects all the cells in the worksheet
It selects the active row
It selects non-adjacent cells in the worksheet
It selects an entire column in the worksheet
Q1345 Easy

To change the color of a slice in a pie chart:

Double click pie slice, click the fill button from the toolbar
Format Chart Area; Fill; Solid Fill; Color
Right click; Format Data Series; Chart Type; Solid Fill; Color
Right click; Format Data Series; Line Style; Solid Fill; Color
Q1346 Easy

What does the Remove Duplicates command consider to be a match?

When at least two of the fields match
When all of the fields match
When most of the fields match
When the fields you select match
Q1347 Easy

You can switch to page layout view by clicking the page layout button ____.

True
Auto fill
On the status bar
Test data
Q1348 Easy

A colleague shared an excel file with you, and you want to display a worksheet that is hidden in it. How you can do that?

On the Home tab, click Unhide.
On the Review tab, click Unhide Sheet.
On the View tab, click New Window.
Right-click on any worksheet tab and select Unhide
Q1349 Easy

In Excel's PMT(rate, nper, pv, [fv], [type]) function, fv and type are ____.

Optional arguments
Arguments
None of these
Q1350 Easy

To erase an entire entry in a cell and then re enter the data from the beginning press the ____ key

2Oxx
ESC
HOME
END
Showing 1350 of 1421 questions

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

Report a mistake

What's wrong?