Skip to content

Excel MCQ Questions

0
Answered
0
Correct
0%
Accuracy
Q1251 Easy

When you write up a lookup formula to look up the text "budget", the formula considers any of the following a match: BUDGET, Budget, or BuDgEt. Is it possible to perform a case-sensitive lookup?

Yes
No
Q1252 Easy

When working in a Pivot Table, the additional menu items "Options" and "Design" are found:

In the right click menu with the Pivot Table is activated
As tabs on the far right side of the ribbon
In the system tray
At the top of the Pivot Table
Q1253 Easy

What is a circular reference?

A modeling tool
An animation tool
Always wrong
A formula that either directly or indirectly depends on itself
Q1254 Easy

What does SHIFT+DELETE do?

Delete
Cut
Copy
Delete Row
Q1255 Easy

Which of the following statements are correct about worksheet grouping?

When multiple sheets are grouped together, content or formatting added to one sheet also gets added to all the grouped sheets.
When a header row is added to one sheet, it automatically appears on all the grouped sheets.
When sheets are grouped together, Excel adds the word "[Grouped Sheets]" (in square brackets) after the sheet's name.
Data cannot be deleted from grouped sheets.
Q1256 Easy

You can ____ the chart title text to select it.

Triple-click
Data point
Change Chart Type
Format
Q1257 Easy

True or False: Excel has trigonometry functions built into it.

False
True
Q1258 Easy

The combination Ctrl+F1:

Hides the ribbon / Shows the ribbon
Opens the Name manager
Saves a workbook
Q1259 Easy

Which keyboard shortcut can be used to embolden text?

Shift + E
Shift + B
Ctrl + B
Ctrl + E
Q1260 Easy

Which formulas use absolute references?

#VALUE!
#VALUE!
Q1261 Easy

Where can I find formulas in excel without having to type it?

Data tab in toolbar-->Formulas
Home tab in toolbar-->Formulas
Formulas tab in toolbar --> search for formula
Q1262 Easy

In Microsoft Excel 2016, the CHOOSE function can be used for selecting up to how many values based on an index number?

64
128
254
508
Q1263 Easy

How can you insert a chart from selected data?

On the Home tab, run the Chart Wizard
On the Page Layout tab, insert a chart sheet
On the Data tab, click Insert Chart
On the Insert tab, choose a chart type on the Ribbon
Q1264 Easy

You need to add a line chart showing a sales trends over the last 12 months and you have only a little space to work with. How can you convey the required information within a single cell?

Add an image of the chart to a comment.
Add a hyperlink to another worksheet that displays a chart when clicked.
Add an image of the chart to the worksheet.
Add a sparkline, a graphic that summarizes data visually within a single worksheet cell.
Q1265 Easy

You're working with columns whose width and font-size should not be changed. Yet the columns are too narrow to display all the text in each cell. What tool should you use to solve the problem?

Sparklines
Wrap Text
Fill Handle
Centered Alignment
Q1266 Easy

Can you create Macros on excel?

true
false
Q1267 Easy

You can apply font styles and alignment options using the ____ tab of the ribbon.

INSERT
PAGE LAYOUT
HOME
VIEW
Q1268 Easy

If you're drawing multiple shapes, how can you keep the Shapes drop-down panel visible, so you don't have to keep clicking the Shapes button?

Enable Keep Panels Visible in Excel's options
Right-click the top of the Shapes panel and select Keep Visible from the pop-up menu
You can't. The Shapes panel always closes after you select a shape
Position the mouse pointer on the top bar of the panel. When the bar becomes blue, drag downwards to tear off the panel
Q1269 Easy

A ____ is essentially a dynamic summary report generated from a database.

table
chart
pivot table
filter
Q1270 Easy

Which worksheet function returns the one-tailed probability of the chi-squared distribution?

BETADIST
AVERAGE
BETAINV
CHIDIST
Q1271 Easy

How do you print an Excel Workbook with the Title Row A1:A2 on each page?

Go to Headers and add Title from A1:A2
Page Layout, Title Header, Rows to Repeat at Top and type "A1:A2"
Page Layout, Print Titles, Rows to Repeat at Top and type "A1:A2"
Page Layout, Print Titles, Rows to Repeat at Top and type "A1"
Q1272 Easy

In the formula =int(average(a1:a100)), which would occur first? ____

The average of the values in the range A1:A100 is added to the integer.
The average of the integer value is calculated.
The average of the values in the range A1:A100 is calculated.
The integer portion of the value is extracted
Q1273 Easy

A chart sheet can contain ____.

Only one value
Surface
Only one chart
Future value
Q1274 Easy

In Excel, what happens when you click the box where the row headings and the column headings meet, at the top-left corner of the sheet?

It will select the whole sheet
It will close and save this particular worksheet of the workbook.
Nothing will happen.
It will hide this particular worksheet.
Q1275 Easy

A formula palette is used to:

Create and edit formulas containing functions
Enter assumptions data
Format cells containing numbers
Copy a range of cells
Q1276 Easy

What is the formula to find the first day of the following month?

#NAME?
46174
All of them
Q1277 Easy

In Excel a ____ is an instruction in a spreadsheet to carry out a calculation

Formula
VLOOKUP
Function
Data
Q1278 Easy

The marketing team of XYZ Corp collects data of foods from multiple resources. If the marketing team wants to highlight the duplicate records of food, then which of the following sets of steps should be used?

Select data -> Right-click on the selected data -> Click on Find Duplicate Records.
Go to Home -> Click on Conditional Formatting -> Click on Highlight Cells Rules -> Click on Duplicate Values.
Go to View -> Click on Data -> Click on Duplicate Records.
None of the above.
Q1279 Easy

How do you make a chart?

Highlight cells of interest go to Tools, Chart
Highlight cells of interest go to Insert, Chart
Highlight cells of interest go to File, Cart
Highlight cells of interest go to Edit, Chart
Q1280 Easy

In order to treat a numerical value as a text value in Microsoft Excel 2016, it should precede with which of the following symbols?

Apostrophe ( ' )
Exclamation ( ! )
Equal ( = )
Hash ( # )
Q1281 Easy

Which of the following are advantages of range names?

Range coordinates are easier to remember than names.
When you move a range to another part of the worksheet that names don't change.
Named ranges adjust automatically whenever you insert or delete rows or columns within the range.
Named ranges don't adjust automatically whenever you insert or delete rows or columns within the range.
Q1282 Easy

To quickly jump to the last cell in a worksheet press ____.

[Alt][Page Down].
[Page Down].
[Shift][Down].
[Ctrl][End].
Q1283 Easy

In the formula "=VLOOKUP(A3,$J$3:$K$12,2,TRUE)", the 4th argument of the VLOOKUP function, "TRUE", indicates

that the table array for the look up has already been validated
to ignore blank values in the index column and return the next value in the index column when a blank is encountered
to only look up values that are greater than zero
to use a range look up, returning the closest matches to the lookup values
Q1284 Easy

Because a chart is _______, it can be dragged to another area of the worksheet.

A picture
Clip art
A table
A graphic
Q1285 Easy

What is the correct way to refer the cell A10 on sheet3 from sheet1?

A10
sheet3:A10
sheet3!A10
sheet1!A10
Q1286 Easy

_____ is a single cell that occupies more than one cell row and/or column.

Table cell
Spanning cell
​Data cell
Header cell
Q1287 Easy

In a Excel spreadsheet, It's possible to select multiple non-adjacent ranges of cells.

True. We select the first block of cells and then we use the CTRL key + selecting the other blocks .
False. It's not possible to select multiple non adjacent rages of cells, in Excel.
True. We select the first block of cells and then we use the SHIFT key + selecting the other blocks.
Q1288 Easy

The formula used to multiply cell a1 by cell c1 is ____.

#VALUE!
#VALUE!
C1*A1
A1*C1
Q1289 Easy

By default, all cells in a workbook are:

Locked or unlocked, depending on a setting in Excel's options
Locked for entering data, but unlocked for applying formatting
Unlocked
Locked
Q1290 Easy

Cell A1 contains the string " Tom Jones" (two blank spaces before the name Tom). To remove the two blank spaces, the formula is:

#VALUE!
content
co
content
Q1291 Easy

A ____ in excel is like a notebook.

Onenote
Workbook
Placeholder
Cell reference
Q1292 Easy

The ____ button allows you to move through a formula step by step.

Evaluate Formula
Undo
Enter
Space
Q1293 Easy

If there is text in cell C5 and the formula in cell F10 =SUM(B2:E6) then the formula result will...

not be entered; Excel will prompt to correct the error
return a #NUM! Error
return a #VALUE! Error
ignore the text value and add the numeric values
Q1294 Easy

You want to find the second-largest invoice in a column containing all the invoices in a given month. What function would you use?

NEXT
MAX
LARGE
MATCH
Q1295 Easy

In Windows, which command creates a connection to a shared network folder and assigns it a drive letter?

Map Network Drive
Disconnect Network Drive
Open File Location
Properties
Q1296 Easy

You can split the worksheet window into ____ separate panes.

Two or four
Four or six
Six or eight
Between two and eight
Q1297 Easy

To insert a character that is not part of an alphabetic font sent (such as copyright ©) use the:

Draw command to create it
#VALUE!
Character set in WORD and copy into the worksheet
Insert/Symbol commands
Q1298 Easy

A(n) _______ is a limit that is placed on a solver problem

Max
Target
Constraint
Adjustment.
Q1299 Easy

A green flag will appear on the upper right-hand side of a cell when it contains:

A number formatted as text or preceded by an apostrophe
An entry obtained from a formula
An ignored circular reference
A number with leading or trailing spaces
Q1300 Easy

The study of human interaction with machines in general is called ____.

Human factors engineering
Human-computer interaction
User-centered design
Usability
Showing 1300 of 1421 questions

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

Report a mistake

What's wrong?