Skip to content

Excel MCQ Questions

0
Answered
0
Correct
0%
Accuracy
Q251 Easy

True or False: It is possible to upload a SWF file into Excel.

True
False
Q252 Easy

True or False: A sparkline usually shows trend information.

True
False
Q253 Easy

Next to a selected PivotChart in Excel 2016, three buttons appear. What does the button with the paintbrush symbol open?

Chart Color
Chart Elements
Format Painter
Chart Style
Q254 Easy

What would the following formula do? =Sheet1!D9+Sheet1!E9

This forumla doesn't do anything.
This would select D9 and E9 and add the two together from sheet1
This would select D9 and E9 and add the two together from sheet2
This would select D9 and E9 and create an average from sheet2
Q255 Easy

To get all rows and columns of data to print on one sheet, you can adjust the page breaks in Page Break Preview or:

Select File, Print, Fit All Columns on One Page
Select File, Print, Print Entire Workbook
Select File, Print, Fit Sheet on One Page
Select File, Print, Print Selection
Q256 Easy

Cells B3 through B121 list several values. What equation shows the average of those values?

#DIV/0!
0
Q257 Easy

Suppose that you have a worksheet that you update frequently by adding new data to columns. You may need a way to reference the last value in column A (the value most recently entered at bottom of column A). If column A contains no empty cells which of the formula returns the last value entered in column A (bottom one)?

0
question_type
content
Panes created using the vertical split bar scroll together horizontally. ________________________
Q258 Easy

True or False? The sumif function can sum data based on multiple criteria.

True
False
Q259 Easy

What is one way to get a new workbook?

File, Save
Format, Row
File, New
Edit, Cut
Q260 Easy

True or false? The Quick Access Toolbar (QAT) is useful for adding popular commands.

True
False
Q261 Easy

To start a new line in a cell press the ____ keys

Footer
ALT+ENTER
Function
CTRL+V
Q262 Easy

What is the correct formula to calculate the total of cell B3 and B4?

#VALUE!
0
Q263 Easy

In Excel, when does a small green triangle appear in the top-left corner of a cell?

When the cell contains hidden information
When the cell contains the Time function
When there is an error in the formula
None of the above
Q264 Easy

Which single-color fill option for a shape in Excel lets you choose a color and set how transparent it is?

No fill
Gradient fill
Solid fill
Pattern fill
Q265 Easy

When working in Page Break Preview, we can do which of the following?

Only change the print area
Only add or remove page breaks and view exactly where the page break occurs
Change the print area, view exactly where the page break occurs, add or remove page breaks
Only add or remove page breaks
Q266 Easy

Which of the following charts have no axes?

Doughnut charts
Pie charts
Both a and b
None of the above
Q267 Easy

How do you make a long sentence fit into the column size?

Increase the size of the column
Wrap Text
Shrink To Fit
Text Edit
Q268 Easy

How do you insert saved images?

Choose Insert/Picture
Choose Home/Images
Choose Home/Illustrations/Picture
Choose Insert/Object
Q269 Easy

A lookup table organizes numbers or text into categories. _____________

True
False
Q270 Easy

Cell A1 has this information "Current Value: $10.00" Which function extracts "Value:" from "Current Value: $10.00"?

Mid()
Left()
None of the above.
Right()
Q271 Easy

To speed up the calculations of a data table on a worksheet,

You can create a running balance formula in Tools menu Formula auditing Mode
Automatic option is not available
You can change the Calculation options to automatically recalculate the worksheet.
Q272 Easy

A ____ total sums all of the data in a row or column.

Grand.
Global.
Master.
Value
Q273 Easy

The quickest ways to save as:

Ctrl+F2
Ctrl+enter
Tab
F12
Q274 Easy

If $34 is entered into a cell, Excel will interpret it as:

Text
A #NAME? error
A value(number) with currency format
A reference to the sum of values in the 34th row
Q275 Easy

Which menu option can be used to split a window?

View > window > split
Format > window
View > split
Window > split
Q276 Easy

Which of the following feature is correct about autofill?

extends a sequential series of data
automatically adds range of cell values
applies a boarder around the selected cells
None of the above
Q277 Easy

How do you begin to record a macro?

Write the code in straight VBA
Click on the Developer tab, click on the drop down arrow on the Macros icon in the Macros group, and choose Record Macro
Right-click anywhere in the spreadsheet and choose Record Macro
Click on the macro icon located to the right of the "In Ready Mode" text at the lower left corner of the screen
Q278 Easy

How do you change the column labels from numbers to letters?

Go to File tab, then to Options, then to formulas, than choose R1C1 reference style.
Go to Excel options, then choose advance and then columns style #.
Go to File tab, then to Options, then to advance and choose columns R1C1
Go to File tab, then to Options, then proofing and then choose number column style.
Q279 Easy

Which of the following is a correct way to hide the contents of a cell?

Click on the Format icon, point to Hide & Unhide, and choose Hide Cells
Right-click on the cell and choose Clear Contents
Click on the Font icon drop down menu and choose Hide
Use a custom format of ;;;
Q280 Easy

To autofill month names you need to type __ and then drag the fill handle. (choose all that apply)

Jan
January
01
01-04-2017
Q281 Easy

What does the Surface chart type describe?

It compares three sets of values in a three dimensional chart
Compares a collection of values from several different data sets
Compares values from different categories
It shows the patterns or relationship between two or more sets of value
Q282 Easy

Which tab do you click to make paragraphs in Excel?

International Tab
Format Tab
Theme Tab
Text Tab
Q283 Easy

How can you zoom in and out of a worksheet, just by using your mouse?

Use the small slider on the right side of the Status bar
On the Home tab of the Ribbon, click the Zoom box and choose a percentage
Right-click the Status bar and select Zoom In or Zoom Out from the pop-up menu
Double-click anywhere on the Status bar
Q284 Easy

Peter made an Excel sheet of the names and prices of articles sold at a jewellery store. When he opened it again, some price cells showed only pound signs (####). What should he do?

The format of the cells should be changed.
The pound signs should be deleted and data should be re-entered.
A filter should be applied.
The width of the cells should be increased.
Q285 Easy

An example of a range address.

A1*B3
A1=B3
A1-B3
A1:B3
Q286 Easy

Which worksheet function returns the skewness of a distribution?

SKEWNESS
SKEWNESSDIST
SKEWDISTRIB
SKEW
Q287 Easy

All of the following are options in the delete menu except ____.

Then by
Delete All
Illustrations
Press the Tab key
Q288 Easy

Which solver method will change variable cells to meet an objective cell?

All Solver Methods
Evolutionary
LP Simplex
Cannot be done in Solver
Q289 Easy

Cell references that reference other sheets behind the summary sheet are known as ____ references.

2-d
3-d
4-d
5-d
Q290 Easy

The definition of the array formula {=SUM((C90:C93)*(D90:D93))} is:

#VALUE!
#VALUE!
The formula will result in an error because the "=" operator is inside the brackets
Q291 Easy

Which formula will provide the same result as the following: =SUMPRODUCT(A1:A10,B1:B10)

0
0
{=PRODUCT(A1:A10+B1:B10)} (array formula)
{=SUM(A1:A10*B1:B10)} (array formula)
Q292 Easy

It is normal practice that numbers are treated as decimals when entering into a cell, but is it possible to enter a fraction (eg 3/4) into a cell in Excel?

Yes
No
Q293 Easy

Which of these choices is NOT one of the four function arguments in a VLOOKUP?

Col_index_num
Lookup_value
Range_lookup
Table_lookup
Q294 Easy

When working with a large worksheet, you can split the window into ____ panes.

Chart sheet
Thursday, Saturday, Monday
Two or four
(HOME tab | Alignment group)
Q295 Easy

When I have selected a column, what is the shortcut I can use to completely delete it?

CTRL + BACKSPACE
CTRL + !
CTRL + "-"
CTRL + D
Q296 Easy

The ____ feature is especially useful when working with very large worksheets.

Outline
Auditing
Summary
Model
Q297 Easy

Which of the following is a valid type of graph?

Regression
Exploded Doughnut
PivotTable Graph
Series Graph
Q298 Easy

Which is the following statement is True for Ribbon?

The ribbon is an area that runs along the top of the application that contains menu items and toolbars available in Excel. The ribbon has various tabs that contain groups of commands for use in the application. The ribbon can be minimized or maximized by pressing CNTRL F1.
The ribbon is an area that runs along the top of the application that contains menu items and toolbars available in Excel. The ribbon has various tabs that contain groups of windows for use in the application. The ribbon can be minimized or maximized by pressing CNTRL F2.
The ribbon is an area that runs along the top of the application that contains menu items and toolbars available in Excel. The ribbon has various tabs that contain groups of back for use in the application. The ribbon can be minimized or maximized by pressing CNTRL F1.
All of the above
Q299 Easy

A ____ is an interactive view of worksheet data.

PivotChart report
Trendline
PivotTable report
2-D column chart
Q300 Easy

Can a macro save a file?

Yes
No
Showing 300 of 1421 questions

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

Report a mistake

What's wrong?