Skip to content

Excel MCQ Questions

0
Answered
0
Correct
0%
Accuracy
Q201 Easy

True or False: When you write a formula in Excel, the references in the formula are limited to that worksheet only.

True
False
Q202 Easy

###### in a cell means that the ____

Formula contains an error
Value contains an error
Label has a spelling error
Column is too narrow to display the value completely
Q203 Easy

Where can you print comments?

You cannot print comments
Either on the worksheet where they appear, or on a separate page
Only on a separate page.
Q204 Easy

Peter was working in a Microsoft Excel 2016 workbook. His workbook closed due to a system error and he couldn't save it. Which of the following is the correct way to recover an unsaved workbook?

Go to the File tab -> Click on Save -> Click on Recovered Workbook
Go to the File tab -> Click on Open -> Click on Recover Unsaved Workbooks
Go to the File tab -> Click on Options -> Click Save -> Click on Recover Unsaved Workbooks
Go to the File tab -> Click on Options -> Save Workbooks -> Click on Recover Unsaved Workbooks
Q205 Easy

Which automation function calls a procedure in a dynamic link library or code resource?

GETPIVOTDATA
SQL.REQUEST
CALLDYN
CALL
Q206 Easy

To share your workbook with another user, what must they have?

Access to the workbook on the hard drive.
Excel 2013. Older versions won't work.
An Office 365 account.
A login on the same server as you.
Q207 Easy

A formula in Excel must begin with the operator:

/
--
=
@
Q208 Easy

If there is text in a column and you try to sort the entire column:

it will keep the text in the same cell and sort the numeric values
sorting function will be disabled
it will not sort the column
an error message will appear
Q209 Easy

Which of the following keyboard shortcuts is used for moving from any cell to the beginning of a worksheet, i.e. cell A1?

Windows + Home key
Alt + 1 key
Ctrl + Home key
Windows + 1 key
Q210 Easy

What does COUNTA () function do?

counts non-empty cells
counts empty cells
counts cells containing numbers
counts cells containing letters
Q211 Easy

An array range that includes both rows and columns is known as____?

A two-dimensional array.
All array ranges must have rows and columns.
A single-dimensional array.
Q212 Easy

An Excel worksheet is made up of columns and rows. Where these columns and rows intersect, they form little boxes called ____

text box
cell
Name Box
intersection
Q213 Easy

You have two columns summing your account totals. The first column looks exactly right but the second one is not displaying the way you want. How do you make the two columns look the same?

Delete both columns. Reytpe values.
Copy the first column. Select the second column. Paste.
Copy the first column. Select the second column. Use "Paste Special" to paste "Formats".
Delete second column. Insert new column. Retype values.
Q214 Easy

Column A contains an apartment number, column B is the street number, and column C contains the street name. I would like all these values to be in the same cell; what function could I use to accomplish this?

Join Cells
Not possible in Excel
Concatenate
Create String
Q215 Easy

You want to lock rows 1:2 and column A in place as you scroll through a large spreadsheet. Which command should you use?

View Side by Side
Freeze Panes
Freeze Top Row
Split
Q216 Easy

What's one way of clearing the effect of a slicer that you've applied?

Click the button in the upper-right corner of the slicer.
Remove the slicer from the page.
Click the Slicer button on the Analyze tab of the Ribbon.
Double-click the slicer's title bar.
Q217 Easy

What additional ability does the Classic PivotTable Layout provide?

Drag & Drop fields into the grid
Create calculated fields
Set custom sort orders
Change the number format for multiple fields simultaneously
Q218 Easy

To hide a selected column, click the _____ button in the cells group on the home tab.

Arrangement
Format
Hide
Columns
Q219 Easy

When creating a vertical page break without creating a horizontal page break as well, the active cell

must be A1
can be anywhere in the worksheet
must be in column A
must be in row one
Q220 Easy

Sam has a table with an Employee column and a Days column. He wants a PivotTable that shows how many employees have each Days value, for example 5 days = 3 employees and 6 days = 2 employees. Which field layout is correct?

FILTERS: Days, VALUES: Count of Days
COLUMNS: Days, VALUES: Count of Days
COLUMNS: Count of Days, VALUES: Days
ROWS: Days, VALUES: Count of Days
Q221 Easy

In Excel 2013, the margin is set to which of the following values, by default, for each workbook?

Wide
Normal
Narrow
None of the above
Q222 Easy

If the source of sparkline data contains non-numeric data, they are neglected while plotting the sparklines.

False
True
Q223 Easy

If you aren't sure what type of chart to use for your data, how can Excel help?

Search Microsoft Bing for the type of data you have, and the word "charts". You'll get downloadable samples.
Click Recommended Charts.
Use the Chart Wizard.
When in doubt, always use a column chart.
Q224 Easy

If you save a workbook with the results of a Goal Seek calculation in place what will occur?

Nothing, your workbook will go back to the same calculations before you performed Goal Seek.
Nothing, the only way to save your Goal Seek results is to do a save as.
You will overwrite the values in our workbook.
You will have saved your workbook.
Q225 Easy

____ are named combinations of values that are assigned to variables in a model.

Constraints
Tables
Scenarios
Data validation rules
Q226 Easy

The Remove Duplicates command:

Copies and pastes the list without duplicates in a new worksheet
Opens a dialog box asking to delete the duplicates in the existing range or copy to a new range
Removes duplicates from the range that is highlighted based on selected criteria
Copies and pastes the list without duplicates in the right-adjoining column
Q227 Easy

A(n) _____ chart is drawn on the same worksheet as the data.

Embedded
Sketch
Author-signature
Cell-outline
Q228 Easy

Choose True or False.If a user specifies a print area from the backstage view, then it saves the setting with the workbook.

True
False
Q229 Easy

The ________, when outlined in black, indicates it is ready to accept data.

Auto complete
Formula Bar
Arguments.
Active cell
Q230 Easy

Functions can be selected by using the ________.

Insert Function dialog box
Bottom - right corner
Black, Text 1, lighter 35%
All of these
Q231 Easy

Which of the following options is not available on the Status bar?

Cell mode
Selection mode
End mode
Start mode
Q232 Easy

Your transactions data set contains more than 10,000 rows. Some rows contain the same transaction. How would you remove the rows containing the identical transactions?

Filter the relevant column, right-click the column head, and select Remove Duplicates.
This is possible only with Power Query.
With your cursors in the data range, on Data tab click Remove Duplicates.
This is possible only using formulas.
Q233 Easy

What is the default shortcut to apply accounting-style cell formatting? ex: ($5,454.25) for the value -5454.25

CTRL + SHIFT + 8
CTRL + SHIFT + 4
CTRL + SHIFT + 2
CTRL + SHIFT + D
Q234 Easy

The source range for a Pivot table may not contain:

A column with data formatted as Scientific abbreviation
A column with no header row in the top cell
A mix of columns containing values and text
Two columns with the same header row
Q235 Easy

By default, after how many minutes does Excel 2013 auto save a user's workbook?

Every 5 minutes
Every 10 minutes
Every 15 minutes
Every 20 minutes
Q236 Easy

A pie chart ____.

Triple-click.
Exploded.
Compares sizes of pieces as part of a whole.
None of these
Q237 Easy

The following sequence, 2, 4, 6, etc., is an example of a ____ series.

Link
Date
Linear
Auto fill
Q238 Easy

The characters +, -, *, and / are examples of ____.

Formulas
Arithmetic operators
Values
Calculations
Q239 Easy

I have a column of values in ranges A2:A100 that I need to concatenate with the number 2. Which of the following is not a way to do this?

Go to B2, enter Concatenate(A2:A100,2) then highlight B2:B100, execute the Array formula.
Go to B2, enter =A2&2 then highlight B2:B100, execute the Array formula.
Go to B2, enter A2:A100&2 then highlight B2:B100, execute the Array formula.
Go to B2, enter Concatenate(A2,2) then drag and drop formula to B100.
Q240 Easy

In Excel, when does the mouse pointer change to a split double arrow?

When it is on the boundary between two column headings, such as A and B
When a cell is being edited
When it is over the fill handle
When it is over the Name box
Q241 Easy

What character is used in a formula cell reference so that it can be copied elswhere but still refer to the same cell or cells?

$
*
/
&
Q242 Easy

How can you drill down into a PivotTable to show details?

Select the cell into which you want to drill down, right-click, and select Show Summary.
Select the cell into which you want to drill down, right-click and select Drill-down.
Select the cell into which you want to drill down and double-click.
Select the cell into which you want to drill down, right-click and select Show Details > Summary Page
Q243 Easy

In Microsoft Excel 2016, Consolidate Option is available under which of the following tabs?

Data
View
Formula
Insert
Q244 Easy

What does the function PV do?

Percentage of Variance
Past Value
Returns the present value of an investment
Post Value
Q245 Easy

Which feature lets you see two sheets of a workbook on screen simultaneously, so you don't have to switch back and forth?

Split
Freeze Panes
Zoom Sheets
New Window
Q246 Easy

You select cell A1, hover the pointer over the cell border to reveal the move icon, then drag the cell to a new location. Which ribbon commands achieve the same result?

Cut and Fill
Cut and Paste
Copy and Transpose
Copy and Paste
Q247 Easy

In Microsoft Excel 2016, which of the following options is used to access the option that is used to get data from a text file?

Click the Data tab -> Select the option
Click the Data tab -> Select the option
Click the Data tab -> Select the option
Click the Formulas tab -> Select the option
Q248 Easy

State whether true or false:Case-sensitive sorting of text in Excel2007 can be performed.

True
False
Q249 Easy

Which of the following sorting options is NOT available under the Sort On dropdown menu in Sort dialog box while sorting the data of a table in an Microsoft Excel 2013 worksheet?

Cell Color
Font Color
Font Style
Q250 Easy

Excel provides _____ so that you can easily create a professional, consistent worksheet appearance.

Styles
Thesaurus
Themes
Ctrl + X
Showing 250 of 1421 questions

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

Report a mistake

What's wrong?