Skip to content

Excel MCQ Questions

0
Answered
0
Correct
0%
Accuracy
Q151 Easy

Where can you see the contents of an active cell?

Tool bar
View bar
Screenshot bar
Formula bar
Q152 Easy

How do you insert a blank worksheet using keyboard shortcut?

Shift + F 10
Shift + N
Shift+F11
Alt + N
Q153 Easy

Using the _____ key allows you to select multiple items, including multiple worksheet tabs.

Page Layout
Space ( )
Text
Ctrl
Q154 Easy

What is the correct syntax for the first line of code of a basic macro?

Sub(DoStuff)
Sub DoStuff
Sub DoStuff()
Begin sub DoStuff()
Q155 Easy

You have a list of names and addresses, and it's filtered to show only the rows from 7 of 9 states. How can someone else tell with a quick glance that the list is filtered by the State column?

There are blue borders around all the cells
The list is shorter than it would otherwise be
The button on top of the State column is a filter symbol
Only 7 states are visible in the State column
Q156 Easy

To create a drop down list box which only allows you to choose the value defined in range O1:O12 you need to setup:

Data > Data Validation
Data > Group
Data > Data Table
Data > Advanced
Q157 Easy

Elements in a smartart graphic are grouped in ____.

Aggregates
Clusters
Levels
Fields
Q158 Easy

If you have values in a range named Data, you can determine the smallest value by using the following formulas?

#NAME?
#NAME?
Q159 Easy

How can you make the width of a column automatically adjust to the widest item in the column?

Shift + click the column header.
Right-click the column header and choose Fit to Widest from the pop-up menu.
Double-click the column header.
Double-click the dividing line between the header of the column and the header of the column to its right.
Q160 Easy

Can you set 1-inch left indentation for a cell in Excel?

You can specify indentation only if you turn the rulers on
Indentation can be set from Format Cells dialog box
The indentation can be specified only when printing
You can specifiy indentation only if you turn the rulers off
Q161 Easy

The two types of cell references are:

Relative and Absolute
Numeric and Data
Basic and Absolute
Figurative and Numeric
Q162 Easy

True or False: You can download content from the net directly into Excel.

False
True
Q163 Easy

Which function returns a reference to a cell (or cell range) that is a specified distance from a base cell?

OFFSET
VLOOKUP
INDEX
MATCH
Q164 Easy

How could one delete an embedded object?

Select it, press Delete
Press Shift + Delete
Select it
Press Alt + Delete
Q165 Easy

Which worksheet function returns covariance, the average of the products of paired deviations?

CHITEST
COUNT
COVAR
DEVSQ
Q166 Easy

Which of below functions will give you TRUE as an answer if Cell A1 contains 2 & Cell A2 contains 1?

#VALUE!
#VALUE!
None of the above
Q167 Easy

The advanced filter tool can ________.

Data_array, bins_array
Search for unique records, only
A function embedded within an argument of another function
Sum_range
Q168 Easy

In Excel's Consolidate dialog box, what happens when you select the 'Create links to source data' check box?

The consolidated data updates automatically when the source data changes, but you can no longer change which ranges are included
The source worksheets are deleted after consolidation
The consolidation is converted into a PivotTable
Nothing changes until the workbook is saved
Q169 Easy

What could you do to stop the pivot table from losing the column width upon refreshing?

Format loss in a pivot table can be prevented simply by changing the pivot table options. Under the “Pivot Table Options” turn on the “Disable Preserve Formatting” and disable the “Auto Format” options.
Format loss in a pivot table can be prevented simply by changing the pivot table options. Under the “Pivot Table Options” turn on the “Disable Preserve Formatting” and enable the “Auto Format” options.
Format loss in a pivot table can be prevented simply by changing the pivot table options. Under the “Pivot Table Options” turn on the “Enable Preserve Formatting” and disable the “Auto Format” options.
All of the above
Q170 Easy

A #VALUE! error is very common and can occur under the following conditions:

When a formula attempts to perform an operation using incorrect data.
A function’s argument is a range when it should be a single value.
You delete the worksheet of a cell that is referenced by the formula.
The formula uses a worksheet function that’s defined in an add-in, and the add-in is not installed.
Q171 Easy

If you want to make a text box transparent, you should:

Right click the text box > Options > Transparent
Right click the text box > Format Shape > Fill > No Fill
Left click the text box > Home tab > Fill > No Fill
Not possible with a text box; only Word Art allows this option
Q172 Easy

How do you keep others from changing the values on a worksheet?

Name the file "Do not change.xls"
Make all values Bold font.
Use "Protect Sheet" and assign a password.
Use track changes to see what has been changed.
Q173 Easy

In print preview, what is selected/displayed?

the active portion of the worksheet is displayed
the selected range is displayed
the entire worksheet is selected
all of these are selected/displayed
Q174 Easy

Applying a $ to a cell reference in a formula:

Turns on wrap text in that cell.
Converts the result of the formula to text.
Keeps the referenced component unchanged as you copy this formula to other locations.
Applies currency formatting to the result of the formula.
Q175 Easy

A ________________ consists of spreadsheets.

workbook
form
column
cell
Q176 Easy

In a worksheet, column A contains employee last names, column B contains their middle initials (if any), and column C contains their first names. Which tool can combine the last names, initials, and first names in column D without using a worksheet formula?

Concatenation
Columns to Text
Flash Fill
AutoFill
Q177 Easy

Suppose cell A1 has value "1" and cell B1 has value "2". After merging cell A1 and B1, what will be the value of Cell A1?

2
3
1
12
Q178 Easy

In Microsoft Excel 2013, which of the following keyboard shortcuts should be used to switch between relative and absolute cell references while writing a formula in a worksheet?

F1
Ctrl+6
F4
Ctrl+2
Q179 Easy

The format painter button is found in the ____ group on the home tab of the ribbon.

Conditional
Clipboard
Templates
Area chart
Q180 Easy

Italic, bold, bold italic, and underline are examples of _____.

Excel table.
Format, content
Print title.
Font styles
Q181 Easy

What does the "V" in "VLOOKUP" stand for?

Verified
Valkyrie
Validated
Vertical
Q182 Easy

True or False: Excel will recognize patterns in data and automatically enter formulas where the patterns continue.

True.
False.
Q183 Easy

The shortcut to highlight a row is

Control+Shift+L
Control+Shift+R
Control+Enter
Shift+Space
Q184 Easy

Which worksheet function extracts from a database a single record that matches the specified criteria?

DGET
DCOUNT
DMIN
DSTDEVP
Q185 Easy

If you see a small red triangle in the top right corner of a cell, it means there is something "attached" to the cell. What is it?

A macro
A hyperlink
A comment
A formula
Q186 Easy

Where is located "Name manager"?

Formulas Tab->Name manager
Data Tab ->Name manager
Home Tab->Name manager
Q187 Easy

Goal seek uses a different approach from traditional _______ analysis.

Hypothetical
What-if
Worksheet
Trial-and-error
Q188 Easy

Which of the following functions checks whether all the arguments are TRUE, and returns TRUE if all the arguments are TRUE?

AND
OR
IF
XOR
Q189 Easy

To restrict values entered in a range between 0 and 10 we can use?

Review > Protect Sheet
Formula > Error Checking
Data > Validation
Q190 Easy

You finish editing Excel's default document, called Book1. But instead of using the Save As command, you click the Save button or press the equivalent keyboard shortcut. How does Excel respond?

Excel displays the Save As dialog, so you can enter a file name and save the file
Excel saves the file with the name Book1
Excel throws a warning message telling you that you're about to save a file with the default name
Q191 Easy

Which chart type provides the best visual display of the relationship between two numeric variables?

Radar chart
Box and whisker chart
XY scatter chart
Combo chart
Q192 Easy

The fill formula method allows you to copy a formula and fill it into only two different consecutive cells at the same time.

False
True
Q193 Easy

One column of your PivotTables lists 500 dates over 2 years. How can you interactively filter the table to show just a range of dates?

Select the rows you don't want, then on the Analyze tab of the Ribbon, click Clear.
On the task pane, drag the dates you don't want out of the Rows area.
Insert a Timeline.
Click the filter button on top of the date column and deselect the dates you don't want.
Q194 Easy

Using ________ telephone marketing, marketers sell directly to consumers.

Inbound
Outbound
Direct-response
Opt-out
Q195 Easy

To paste copied cell contents, you can press the ____ keys.

CTRL+C
CTRL+P
CTRL+V
CTRL+X
Q196 Easy

All 2-D and 3-D charts have an x-axis known as the horizontal axis and a y-axis known as the vertical axis. Which of the following charts don't have x-axis and y-axis?

Radar Charts
Pareto Charts
Pie Charts
Pyramid Charts
Q197 Easy

True or False: The value in a cell that contains the formula =RAND() only changes when the file is resaved.

True
False
Q198 Easy

Which formula returns the sum of the three smallest values in a range named Data?

#NAME?
#NAME?
Q199 Easy

True or False: The data can be typed in either the cell or in the Formula bar.

False
True
Q200 Easy

Can you save a .xlsx file as a .xls file?

No
Yes
Showing 200 of 1421 questions

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

Report a mistake

What's wrong?