Skip to content

Excel MCQ Questions

0
Answered
0
Correct
0%
Accuracy
Q1 Easy

When you've created a table, what's a quick way of getting a total for the last column of numbers?

In the bottom cell where you want the total to go, right-click and select Insert Total from the pop-up menu.
Click inside the table, and on the Formulas tab of the Ribbon, click Convert to Totals Table.
On the Design tab of the Ribbon, select the option for Total Row.
On the Table tab of the Ribbon, select the option for Table Summary.
Q2 Easy

In a selected column-layout PivotChart, what's one way to swap which fields are listed across the horizontal axis, and which fields are listed in the legend?

On the Design tab of the Ribbon, click the Switch Row/Column button.
Right-click the chart, and from the pop-up menu select Swap Legend and Axis.
On the Analyze tab of the Ribbon, click the Change Data Source button, then select which field goes where.
On the Format tab of the Ribbon, click the Legend button, then from the drop-down, select the field attached to it.
Q3 Easy

True or False: If there are duplicate items in a list, the COUNT function will not include the duplicates in the total count of items.

True
False
Q4 Easy

Which of the following Excel 2013 features allows sharing file with other people and working together in real time?

Representational State Transfer (REST)
SkyDrive
Online Meeting
Both b and c
Q5 Easy

If you have a worksheet that's several pages long, how can you get the column headers across row 5 to print at the top of each page?

Copy row 5 on page 1. In Page Layout view, scroll down and paste into the top row of the remaining pages.
From the View tab, click Headers. Click in the box on the top of the page, then type $5.
Right-click the header of row 5. From the pop-up menu, select Print on Every Page.
From the Page Layout tab, click Print Titles. In the Sheet tab, click in Rows to Repeat at Top, then click the header of row 5.
Q6 Easy

The insert function dialog box has a(n) ____ option

Search
Normal
Content and formats
None of these
Q7 Easy

Which method will you use to update table data from a Sharepoint list?

On the Data tab, in the Data Tools group, click Refresh
On the View tab, in the Show/Hide group, click Refresh
On the Design tab, in the External Data group, click Refresh
None of the above
Q8 Easy

An Excel worksheet has data in A1:E8 and the cursor is on cell A3. Which shortcut moves the cursor directly to E8, the last used cell?

Ctrl + L
Shift + Z
Ctrl + end
Shift + end
Q9 Easy

What is the Mini Toolbar used for?

It provides a smaller substitute for the Quick Access Toolbar
It gives quick access to common formatting commands
It gives you quick access to common functions
It provides a smaller substitute for the Ribbon
Q10 Easy

Column A contains first names and Column B contains last names. What formula would output in the format "Last, First" in cell C7?

#VALUE!
A red triangle at the top right corner of a cell indicates what?, mcq
mcq, A red triangle at the top right corner of a cell indicates what?
Q11 Easy

True or False: Sparklines are also often called "micro charts."

False
True
Q12 Easy

Placing a chart in a ____ dlls.

Chart sheet
Data series
Surface
Junk
Q13 Easy

Which Function should be used to count all the cells which are not empty?

0
0
All of the Above
Q14 Easy

Under which ribbon item can you find protection options?

Data
View
Edit
Review
Q15 Easy

If a range name is used in a formula and the name is deleted, what happens to the formula?

The formula display a warning but the actual cell address is substituted for the deleted name.
The formula becomes invalid and displays a #NAME? error.
The actual cell addresses replace the original range name in the formula.
The formula becomes invalid and displays a #N/A error
Q16 Easy

What "Insert" option should you use for a PDF?

Spreadsheet
Chart
Picture
Object
Q17 Easy

What is a quick way of viewing the underlying data of any cell of a PivotTable?

Select a cell, then on the PivotTable - Design tab of the Ribbon, click New Report.
Double-click the cell to display the data in a new worksheet.
Select a cell, then press Ctrl + Shift + D.
Select a cell, then on the PivotTable - Analyze tab of the Ribbon, click Show Detail.
Q18 Easy

In Excel, which tab do you use to hide the header row of a table?

Insert
Data
Design
View
Q19 Easy

Where in the ribbon is the "Zoom to Selection" tool located?

Insert tab
Data tab
Review tab
View tab
Q20 Easy

In the Excel formula =PI()*A2^2, which part is a reference?

PI()
A2
^
2
Q21 Easy

State whether true or false:When the table headers are turned off, the table header Autofilters and all other applied filters are removed from the table.

True
False
Q22 Easy

Kristen is working on confidential data and wants to make the Excel 2010 document password protected. Which of the following sets of steps will allow her to protect the document with a password?

Open File menu -> Click on Info -> Click on Protect Document -> Click on Encrypt with Password
Open File menu -> Click on Security -> Select Password Protection
Open File menu -> Click on Security -> Click on Protect Document -> Click on Secure with Password
Open File menu -> Click on Info -> Click on Security -> Click on Encrypt with Password
Q23 Easy

Your spreadsheet is printing, but the grid lines aren't showing up. What is most likely the problem?

Need to set the cell to bold.
Go to page set up and set to print as black and white.
Change out the printer cartridge.
The formatting for grid lines isn't set on the cell.
Q24 Easy

True or False: The print area cannot be set to discontinuous ranges.

False
True
Q25 Easy

The transpose action in Excel is found in:

TRANSP() formula
Paste Special Command
A format option
An add-in
Q26 Easy

To move the insertion point to the next cell to the right in a table, you can ____.

Press the Tab key
Press the Alt + Tab key
Press Alt + Home
Press Backspace Tab Enter
Q27 Easy

Which of the following function(s) accepts criteria?

SUMIF()
AVERAGEIF()
COUNTIFS()
DGET()
Q28 Easy

The best way to apply page setup options to multiple worksheets is to ________.

Group the worksheets
Relative worksheets
Both
None of these
Q29 Easy

How do you create Word Art?

On the Insert tab, in the Text group, click WordArt
On the Review tab, in the Text group, click WordArt
On the Page Layout tab, in the Themes group, click Effects
On the Page Layout tab, in the Page Setup group, click WordArt
Q30 Easy

Clicking the ____ box completes an entry.

INSERT
Enter
End
CRT+A
Q31 Easy

While creating a PivotTable in Excel 2016, where can a user place the PivotTable report? It is always placed in a new worksheet. It is always placed in an existing worksheet. It can either be placed in a new worksheet or in an existing worksheet. In Microsoft Excel 2016, which of the following values can be returned by the ISTEXT() function?

TRUE
False
0
1
Q32 Easy

State whether the following is true or false: Excel Web App supports Undo/Redo but it is disabled when multiple users are collaborating on the same workbook

True
False
Q33 Easy

Which function returns the largest value amongst all values within the range H2:H30?

#REF!
#REF!
Q34 Easy

You can ____ a table field if the information stored in a field becomes unnecessary.

Block
Remove
Freeze
Hide
Q35 Easy

For a formula that calculates gross pay based on hourly wage (column A) and hours worked (column B), what are the cells in columns A and B called?

Antecedent Cells
Proprietary Cells
Dependent Cells
Precedent Cells
Q36 Easy

If you want to enter the days of the week across a row, how can you save a lot of typing?

Click the Insert tab on the Ribbon and select the QuickParts drop-down. Choose Days of the Week.
Enter "Sunday" into the first cell, then drag the small dot at the lower-right corner of the cell to the right.
Enter "Sunday" into the first cell, then click the next cell to the right. From the Insert tab on the Ribbon, select Equation, then choose +6.
Enter "Sunday" into the first cell. Click the Insert tab on the Ribbon and select Complete Series.
Q37 Easy

How do you make sure that a formula's result will always fit into the cell?

Set the font size to 8 or less.
Use Zoom to see the cell.
Set the cell's format to "Shrink to fit".
Make the cell very large.
Q38 Easy

In an Excel chart, what are the items in the chart's key, each showing a data series' name and color, called?

Chart title
Axis labels
Legend entries
None of the above
Q39 Easy

A ________________ consists of a grid made from columns and rows?

Label
Cell
Spreadsheet
Formula
Q40 Easy

A cell contains the value 7.877 and you want it to display as 7.9. How can you accomplish this?

Use the ROUND() function.
Click the Decrease Decimal button twice.
In the cells group on the Home tab, click Format > Format Cells. Then click the Alignment tab and select Right Indent.
Click the Decrease Decimal button once.
Q41 Easy

Which keyboard shortcut should be used to enter the current time in a cell in an excel sheet using a QWERTY computer keyboard?

CTRL+SHIFT+"
CTRL+SHIFT+:
CTRL+;
None of the above
Q42 Easy

Excel's data validation feature enables you to...

request that all edits be sent to you for approval
set up certain rules that dictate what can be entered into a cell
limit what kinds of graphs a user can create
only accept data with a citation
Q43 Easy

In Excel, what does a small red triangle in the top-right corner of a cell mean?

It signifies that the cell contains a formula
It signifies that the cell contains a comment
It signifies that the cell contains a macro
All of the above
Q44 Easy

Excel recognizes certain values, such as ____ and Quarter 1, as parts of larger lists. When you drag the fill handle from a cell containing one of these values, Excel fills the cells with the appropriate series?

January, Sunday
Jan, 1st
A, B
First, Second
Q45 Easy

June 6th, 2011 was a Monday. Based on the normally set week, date value 6/6/2011 is in cell A1. The formula in B1 =Weekday(A1) returns:

2
Monday
6
None of the above
Q46 Easy

Function used to join several text strings to one is:

CONTATENATE
CONCATENATE
CONTACTENATE
CHAR
Q47 Easy

The ____ of a cell determines how the labels and values look.

Value
Formula
Label
Format
Q48 Easy

Only images that are ____ are free for anyone to use without permission.

In the public domain
Convert to Shapes
Text Import Wizard
Rotate Objects
Q49 Easy

How do you know a range is active?

I'm psychic & I just Know!!
The data changes to Bold to let me know it's active
It is highlighted on the screen.
It has a marquee around it.
Q50 Easy

Where is conditional formatting located?

Home tab-> styles-> conditional formatting
Data tab->conditional formatting
Developer tab->conditional formatting
Showing 50 of 1421 questions

About these Excel questions

Questions on Microsoft Excel: formulas and functions (including VLOOKUP and statistics), cell references, formatting, charts, comments, slicers and the ribbon.

Topics: Formulas and functions, Cell references, Formatting, Charts and analysis, and Workbooks.

What the Excel test covers and how to prepare

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

Report a mistake

What's wrong?