Skip to content

Excel MCQ Questions

0
Answered
0
Correct
0%
Accuracy
Q301 Easy

An .xlsx workbook is saved into .csv format. What is preserved in the new .csv file?

Cell values only
Cell values and formats
Cell values and formulas
Cell value, formats, and formulas
Q302 Easy

Is it possible to make Pivot table using multiple sources of data?

a. If the multiple sources are different worksheets, from same workbook, then it is possible to make Pivot table using multiple sources of data.
b. If the multiple sources are different context, from same hiding, then it is possible to make Pivot table using multiple sources of data.
c. If the multiple sources are different formulas, from same handbook, then it is possible to make Pivot table using multiple sources of data.
d. None of the above
Q303 Easy

Which of the following is a concatenating operator?

!
&
'
All are concatenating operators
Q304 Easy

Excel's ________ function retrieves the date and time from the computer's calendar and clock.

Now
Pane
Table
Sort
Q305 Easy

Does changing the number of displayed decimals change the value Excel is storing?

No - Unless you zoom first.
Yes - Unless you set your cell to "Auto fit"
Yes - changing the decimals will cause the number stored to round to the nearest decimal.
No - the number remains the same no matter how it is displayed.
Q306 Easy

A(n) ____ contains little or no formatting.

Text file
Web page
Access query
Word table
Q307 Easy

A _______ is a predefined formula that helps perform common mathematical functions.

calculate
math
function
equation
Q308 Easy

True or False: The formula =((A2+B5)*5% is valid.

True
False
Q309 Easy

Selecting the Rows 5 & 6 then choose Insert->Row

2 Rows will be inserted after Row 5
2 Rows will be inserted after Row 7
2 Rows will be inserted after Row 4
2 Rows will be inserted after Row 6
Q310 Easy

When is an absolute cell reference used?

When you want a cell reference to change when copied and pasted to other cells
When you want a cell reference to stay fixed on a specific cell.
Q311 Easy

Which function repeats text a given number of times?

VALUE
PROPER
REPT
LOWER
Q312 Easy

Which formula needs to be typed in B3 to increase sales by 3.5% from the cell above, and then take advantage of autofill to fill the rest of the cells in the column instead of retyping the formula for every cell?

#VALUE!
#VALUE!
Q313 Easy

Which of the following series type is not valid for Fill Series dialog box?

Linear
Autofill
Growth
Time
Q314 Easy

You can apply the bold font style by pressing the ____ keyboard shortcut keys.

CTRL+B
TAB+B
SHIFT+B
ALT+B
Q315 Easy

Cell A1 contains the string "tom jones". To transform the contents to "Tom Jones" the formula is:

CONTENT
#NAME?
Content
Q316 Easy

What does the 1 represent in this formula: =Now()+1

one day
one minute
one hour
an error
Q317 Easy

Arrow a is indicating a(n) _____ protein.

Transport
Enzyme
Signal
Structural
Q318 Easy

An error value begins with a(n) _____ followed by an error name that indicates the type of error.

Number sign
Asterisk
Exclamation point
Plus sign
Q319 Easy

Cell A1 contains a text string Apple, Cell A2 contains a value 5. What will be the result of the formula: =A1*A2

#VALUE!
#N/A
5
Apple
Q320 Easy

____ is extremely useful for making large tables more manageable in size and appearance.

Sorting
Filtering
Outlinin g
Counting
Q321 Easy

The Quick Access toolbar does which of the following?

Stores shortcuts to frequently used features
Displays the name of the currently active cell
Marks the currently active cell or range
Displays the contents of the currently active cell
Q322 Easy

Which of the following function can be used to pad a cell with characters, such as the dot?

TRIM()
CLEAN()
REPT()
TEXT()
Q323 Easy

When you insert a row, you have to reset all the equation references because:

The columns will resize
The formatting has to change as well
The results will skew otherwise
Inserting a row does not require you to reset the equation references
Q324 Easy

By using names, data can be understood and maintained in a much easier way. Peter creates a Named range, but he is not aware about the scope of the Name. Which of the followings is the default level of scope for a Name?

Workbook
Cell Range
Current Worksheet
None of the above.
Q325 Easy

Some of your data in Column C is displaying as hashtags (#) because the column is too narrow. How can you widen Column C just enough to show all the data?

Right-click column C, select Format Cells, and then select Best-Fit.
Right-click column C and select Best-Fit.
Double-click column C.
Double-click the vertical boundary between columns C and D.
Q326 Easy

The function DAY(date)

Extracts the day of the month from the date value
Displays the current date
Extracts the year number from the date value
Displays the current date and time
Q327 Easy

If the Ribbon is taking up too much space on your screen, what can you do?

On the File tab, click Options. In the Advanced section, choose Use Legacy Menu Bar.
Double-click a blank spot on the Ribbon to hide it
Hide it by clicking the small Up arrow on its right side
Maximize Excel on your screen
Q328 Easy

Cell A2 contains the value 8 and cell B2 contains the value 9. What happens when cells A2 and B2 are merged and then unmerged?

Both values are lost.
Cell A2 contains the value 8 and cell B2 is empty.
Cell A2 contains the value 8 and cell B2 contains the value 9.
Cell A2 contains the value 17 and cell B2 is empty.
Q329 Easy

When does the ##### error appear in an Excel cell?

It occurs when a column is not wide enough
It occurs when a negative date is used
It occurs when a negative time is used
All of the above
Q330 Easy

The default number format is ________.

General
Normal
Special
None of the above
Q331 Easy

The logic for the formula in cell B2: =IF(A2>5,.2,0) is expressed as:

.2 in cell B2 if the value in cell A2 is greater than 5; otherwise return 0
0 in cell B2 if the value in cell A2 is greater than or equal to 5; otherwise return .2
.2 in cell B2 if the value in cell A2 is less than 5; otherwise return 0
Q332 Easy

The cell range that starts in cell A1 and goes over to column J and down to row 15 is _____

A1;J15
A1.J15
A1-J15
A1:J15
Q333 Easy

When editing a cell, what do you press to cycle between relative, mixed, and absolute cell references?

Alt+F4 (Windows) or Option+F4 (Mac)
Alt+Shift+4 (Windows) or Option+Shift+4 (Mac)
Ctrl+Shift+4 (Windows) or Command+Shift+4 (Mac)
The F4 (Windows) or Command+T (Mac)
Q334 Easy

State whether true or false:When you freeze panes, you select specific rows or columns that remain visible when scrolling in the worksheet.

True
False
Q335 Easy

True or False: Data being typed does not appears in both the active cell and Formula bar.

False
True
Q336 Easy

State whether true or false:A Macro project can be digitally signed.

True
False
Q337 Easy

A ________ identifies a worksheet in a workbook.

Active cell
Cell styles
Sheet tab
MEDIAN
Q338 Easy

An Excel formula can reference cells on other worksheets in the:

current workbook and in other workbooks, even if they're not open.
same workbook, but not worksheets in other workbooks.
current workbook and worksheets in other workbooks, as long as they're open.
current workbook and in other workbooks, and tables in Word and PowerPoint.
Q339 Easy

What is one way to center text in a cell?

Right-click the cell and select Center (Windows) or Center Text (Mac).
Seletct the cell and, on the View tab in the Cells section, click Alignment and select Center (Windows) or Center Text (Mac).
Select the cell and, on the Home tab in the Alignment section, click Center (Windows) or Center Text (Mac).
Change the width of the cell until the text is centered.
Q340 Easy

What tool would you use to prevent the input in a cell of a date outside a specific range?

Protect Workbook
Watch Window
Data Validation
Filter
Q341 Easy

After activating a chart, which sequence adds a trendline to the chart?

In the Format group, select Trendline from the Insert Shapes list.
Click outside the plot area and select Add Trendline
Click inside the plot and select Forecast.
Right-click a data series and select Add Trendline.
Q342 Easy

The accounting number format assigns a floating dollar sign. _________________________

True
False
Q343 Easy

True or False: Charts from Excel can be pasted into Power Point.

False
True
Q344 Easy

In Excel, how do you make Excel save a backup copy of a workbook automatically every time you save it?

Save As > Tools > Web Options
Save As > Tools > General Options > Always create backup
File > Info > Protect Workbook
Review > Track Changes
Q345 Easy

To convert the date 12/14/2014 in cell A1 to text in the format of YYYYMMDD, which is a valid option?

#NAME?
#VALUE!
tentcoen
content
Q346 Easy

A _______ describes the location of a cell based on its column and row location.

Absolute referance
Numbers
Cells
Cell address
Q347 Easy

If your Microsoft Excel workbook closes due to system error before you could save it, then which of the following is the correct way to recover it?

Go to File -> Click on Save -> Click on Recovered Workbook.
Go to File -> Click on Open -> Click on Recover Unsaved Workbooks.
Go to File -> Click on Options -> Click on Save -> Click on Recover Unsaved Workbooks.
Go to File -> Click on Options -> Click on Open -> Click on Recover Unsaved Workbooks.
Q348 Easy

A chart that compares three set of values in a three-dimensional chart is _____.

Surface
Multi-Chart
3D-Chart
None of the above
Q349 Easy

When entering a formula, what key or combination of keys can be hit to quickly make a cell an absolute reference?

Control + G
Control + J
F8
F4
Q350 Easy

What is the quickest way to highlight all of the blank cells in selected section that has both filled and blank cells?

Write a conditional format with ISBLANK
All of the above
Choose the "Blank" function in the Go To menu
Select each blank cell while holding down the control key
Showing 350 of 1421 questions

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

Report a mistake

What's wrong?