Skip to content

Excel MCQ Questions

0
Answered
0
Correct
0%
Accuracy
Q451 Easy

Functions can be entered for formulas using all of the following methods except ____.

The Insert Function dialog box
Typing the function
The AutoSum button
Typing the function argument
Q452 Easy

Which feature of Excel allows the user to limit the number of text characters in a cell?

Format Column
Range Names
Concatenation
Data Validation
Q453 Easy

True or False? A pivot table must have column headers.

False
True
Q454 Easy

Which tab will you select to unhide and hide the sheet?

Review
Page Layout
Conditional Formatting
Format
Q455 Easy

The ____ cell on the worksheet is the one into which you can enter data.

File
Maximize
Gallery
Active
Q456 Easy

Choose True or False.Microsoft Excel's custom theme can be applied to content in Word, PowerPoint, Outlook and Access.

True
False
Q457 Easy

What is the short cut for saving a file in Excel?

Shift + C
Ctrl + S
Ctrl + F
Command + K
Q458 Easy

Which of the following is not a standard Excel cell format?

Text
Boolean value
Scientific
Radian
Q459 Easy

The formula ISERROR(A1) returns TRUE if A1 is :

#REF!
#VALUE!
Any of these
Q460 Easy

The ____ dialog box provides options for moving charts between worksheets and chart sheets.

Move chart
DESIGN and FORMAT
Data series
Chart sheet
Q461 Easy

In Microsoft Excel 2016, the commands used for recording, creating and deleting macros is accessed from the Developer tab. Which of the following is the correct way of displaying the developer tab on the ribbon?

Click on the File tab -> Click Options-> In the Excel Options dialog box, click option Customize Ribbon -> Check the Developer tab option -> Click OK
Click on the File tab -> Click Accounts-> In the Excel Accounts dialog box, click option Quick Access Toolbar -> Check the Developer tab option -> Click OK
Click on the View tab -> Click Options -> In the Excel Options dialog box, click option Quick Access Toolbar -> Check the Developer tab option -> Click OK
Click on the View tab -> Click Accounts-> Click Options -> In the Excel Options dialog box, click option Customize Ribbon -> Check the Developer tab option -> Click OK
Q462 Easy

Which of the following is the correct function of the Wrap Text in Microsoft Excel 2016?

it is used to merge multiple cells to one cell.
it is used to delete the hidden text from a cell.
it is used to convert extra-long text of a cell into multiple lines so that user can see all of it.
None of the above.
Q463 Easy

Which of following is NOT one of Excel’s what-if functions?

Scenario manager
Goal seek
Solver
Auto Outline
Q464 Easy

What company distributes Excel?

Microsoft
Intel
Turbotax
Intuit
Q465 Easy

What's one way of unhiding a column that you've hidden?

Double-click the header of the column immediately to its left.
On the Page Layout tab of the Ribbon, click the Columns drop-down. Select any hidden columns that you want visible.
Double-click the header of the column immediately to its right.
Select the columns to either side of it. Right-click one of the column headers, and select Unhide from the pop-up menu.
Q466 Easy

You can convert your Excel document into a Google doc.

False
True
Q467 Easy

The ________ group on the design tab is useful for adjusting the data source of a chart.

Chart Styles
Current Selection
Data
Chart Layouts
Q468 Easy

What are two ways of creating a PivotChart?

Convert a regular chart or use the PivotChart wizard
Create it from an existing PivotTable, or create it using the Insert tab of the Ribbon
Create it from an existing PivotTable, or convert a regular chart
Create it from the Insert tab of the Ribbon or convert a reguar chart
Q469 Easy

Which group under the Home tab contains the "Clear" command

Font
Format
Editing
Alignment
Q470 Easy

In excel, max and average are examples of ____.

Functions
Lists
Arguments
Buttons
Q471 Easy

Which worksheet function returns the average of its arguments, including numbers, text, and logical values?

AVERAGE
AVERAGEA
BETADIST
AVEDEV
Q472 Easy

Which among the following is not true regarding a calculated column?

It uses a single formula that adjusts for each row
It automatically expands to include additional rows
A formula is required to be entered only once in a calculated column
Additional formulae cannot be entered in a calculated column as exceptions
Q473 Easy

The status bar does which of the following:

stores shortcuts and information about a workbook.
hosts specific shortcuts and information about a workbook.
allows viewing of distant parts of a worksheet at the same time.
displays the contents of the currently active cell.
Q474 Easy

Attaining data from a cell located in a different sheet is called what?

referencing
locating
functioning
travelling
Q475 Easy

Laura inserts an image into a shape. She needs to make this image transparent so that the text remains visible. Which of the followings is the correct way to make the image transparent?

Select the shape -> Format Picture pane -> 3-D Format -> Transparency
Select the shape -> Format Picture pane -> Fill -> Transparency
Select the shape -> Picture Tools Format tab -> Color -> Set Transparent Color
Select the shape -> Picture Tools Format tab -> Set Transparency
Q476 Easy

How can you create a custom style?

Format a cell the way you want the style to look. Right-click the cell, then from the pop-up menu, select New Style from Cell.
From the Insert tab, choose Style. From the dialog box, choose the formatting you want, then click OK.
Format a cell the way you want the style to look. On the Home tab, click the Styles drop-down and select New Cell Style.
From the Page Layout tab, click the Fonts button. Click Customize Fonts, choose the fonts you want and assign a name, then click OK.
Q477 Easy

Does delete button remove cell?

DELETE has no effect on cells
Deletes all spreadsheets data
YES it removes cell
NO, it clears cell contents
Q478 Easy

Sometimes, data that you're charting may be missing one or more data points. Excel offers three ways to handle the missing data. All of the following are ways to handle missing data EXCEPT:

Connect with line: Missing data is interpolated
Zero: Missing data is treated as zero
Text: Missing data is bridged with words
Gaps: Missing data is simply ignored
Q479 Easy

What happens if you copy a cell containing the formula =G5/$F5 and paste it into another cell?

Both the row and column of the denominator might change, as Excel sees fit.
The denominator will always remain $F5.
The row in the denominator might change, but the column won't.
The column in the denominator might change, but the row won't.
Q480 Easy

What does the Keep text flat option do for WordArt in Excel's Format Shape pane?

It prevents the text inside the WordArt from rotating when rotate WordArt is rotated
It prevents the text from blurring
It moves the WordArt or text backward
Both b and c
Q481 Easy

How do you remove a field from a pivot table?

Deselect the field in the bottom part of the pivot table field list
Select it in the bottom part of the pivot table field list and "drag it away"
Select it in the top part of the pivot table field list and "drag it away"
Double click on the field you do not want to make it disappear
Q482 Easy

Double-clicking column separators will do what?

Create and additional column in between the two columns
Adjust number alignment
Automatically adjust column width
Delete both columns
Q483 Easy

You can display the ____ tab to specify page setup options.

Groupings
Page setup
Page Layout
On the status bar
Q484 Easy

What's the best type of chart to track the progress of numbers over time?

Line chart
Column chart
Area chart
Temporal chart
Q485 Easy

Which area in an excel window allows entering values and formulas?

Standard toolbar
Formula bar
Menu bar
Title bar
Q486 Easy

Excel 2013 brings in a new method to filter data with __________ feature.

Timeline
Olive office
Live preview
Dynamic filter
Q487 Easy

Viewing and printing options for forms and records are available on the ____ tab.

Field value
PRINT PREVIEW
Portrait orientation
Print dialog box
Q488 Easy

You are creating a new formatting rule which will be used to format a PivotTable report. Which of the following formatting styles is NOT available while formatting all cells of PivotTable report based on their values in an MS Excel 2010 worksheet?

2-Color Scale
3-Color Scale
4-Color Scale
Data Bar
Q489 Easy

Excel organizes fonts into theme and non-theme fonts. _________________________

True
False
Q490 Easy

The cell reference of a range of cells that starts in cell B1 and goes over to column G and down to row 10 is ….

B1*G10
G1-G10
B1:G10
B1;G10
Q491 Easy

To visualize the relative values in a range, that’s where Excel’s ___ come in. __ are colored, horizontal bars that appear “behind” the values in a range?

bar, chart
data, bars
bars, formula
cell, fills
Q492 Easy

On an excel sheet the active cell in indicated by ?

A dark wide border
A blinking border
By italic text
A dotted border
Q493 Easy

lf Sam wants to insert a pivot chart in his Excel worksheet, then which Of the following tabs should he use tO perform the same?

Developer
View
Review
Insert
Q494 Easy

A _______ refers to the entire excel file.

Sheet
Worksheet
Spreadsheet
Workbook
Q495 Easy

In Microsoft Excel 2013, what happens when the Freeze Panes option is used on a few rows and columns?

It keeps the rows and columns visible when the rest of the worksheet is scrolled.
It hides the selected rows and columns.
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 data type.
Q496 Easy

What does this formula do? =Sum(Sheet1:Sheet4!D18)

It adds data from cell D18 of Sheet1 and cell D18 of Sheet4
It adds data from cell A1 of Sheet1 and cell D18 of sheet4
It adds all data in the range A1:D18 in Sheet1, Sheet2, Sheet3 and Sheet4
It adds data from all D18 cells in Sheet1, Sheet2, Sheet3 and Sheet4
Q497 Easy

Which of the following options would you choose to clear a PivotChart report?

On the Analyze tab, in the Data group, click on Clear, and then click 'Clear All'
On the Options tab, in the Actions group, click on Clear, and then click 'Clear All'
Both a and b
None of the above
Q498 Easy

What does Live Preview allow the user to do?

See how a new font, font size, table size, or cell size will look on selected data before it applies
View distant parts of a worksheet at the same time
Control the magnification of the screen
Store frequently used features
Q499 Easy

State whether true or false:When a part of a formula is replaced with its calculated value, it cannot be restored.

True
False
Q500 Easy

Which of the following function accepts a range as an input?

COUNT()
AVERAGE()
MAX()
PRO()
Showing 500 of 1421 questions

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

Report a mistake

What's wrong?