Skip to content

Excel MCQ Questions

0
Answered
0
Correct
0%
Accuracy
Q1101 Easy

You can add a text box using the chart tools ____ tab.

Triple-click.
False.
True.
Format.
Q1102 Easy

The functions AVERAGEIF and SUMIF both use cell values that match specified criteria.

False
True
Q1103 Easy

The conditional formatting button provides access to the _____.

Manage Rules option
Organized option
Rules
Logical option
Q1104 Easy

Which Excel error appears when a formula uses the wrong type of value, such as adding text to a number?

#VALUE!
#NUM!
#NULL!
#####
Q1105 Easy

Which of the following is not true about the Watch Window?

The Watch Window makes it convenient to inspect, audit, or confirm formula calculations
When cells are not visible on the worksheet, those cells and their formulae can be seen in the Watch Window
There can be two Watch Windows per cell
Q1106 Easy

Using a cell address in a formula is known as:

Cell mathematics
Cell referencing
Formularizing
Prefixing
Q1107 Easy

A(n) ____ is a built-in formula that uses arguments to calculate information

Label
Function
Template
Indicator
Q1108 Easy

Which worksheet function returns the k-th largest value in a data set?

HIGHEST
LARGEST
LARGEK
LARGE
Q1109 Easy

How to change the number of sheets in new workbooks?

Excel menu, click Preferences
Under Authoring, click General
open all files in box, enter the location of the files that you want Excel
In the Sheets in new workbook box, enter the number of sheets the you want in the workbook
Q1110 Easy

What do you use to create a chart?

Chart Wizard
Pie Wizard
Data Wizard
Excel Wizard
Q1111 Easy

How can you change the date format of a cell or group of cells?

type preferred format into formula bar
Ctrl + F3
right click, copy, paste
Select cell or cells, right click, format cells, date, choose option.
Q1112 Easy

Which of the following functions is used for providing the decimal number of the time represented by a text string?

Now()
Trend()
TimeValue()
Numbervalue()
Q1113 Easy

The opposite of merging cells is splitting a merged cell. _________________________

Insertion point
Equal sign (=)
Auto Fill Options
Standard
Q1114 Easy

The summary function that calculates the smallest data value in a pivottable report is ____.

Varp
Min
Max
Average.
Q1115 Easy

What happens when you start a formula out with a minus sign (-)?

All of the choices
It opens the dialogue box
It returns the negative value of the answer
It breaks the formula
Q1116 Easy

A red triangle at the top right corner of a cell indicates what?

The cell can’t accept a formula
The font color of the text in cell is red
The cell is connected to another cell
There is a comment associated with the cell
Q1117 Easy

How will you find cells with data validation?

On the Home tab, in the Editing group, click the arrow next to Find & Select,, then click Go To Special. Click on Data Validation, and then click All
On the View tab, in the Windows group, click Data Validation
Both a and b
None of the above
Q1118 Easy

Which of the following is not a date function? ____

AND
Algebra
<<
AVERAGE
Q1119 Easy

In an Excel 2010 worksheet, cells D3 to D7 contain 5, 12, 9, 8 and 8. Cell D9 contains =SUM(D3:D7). Which statement is true?

The value of cell D9 will be 24
The value of cell D9 will be 42
The value of cell D9 will be #VALUE!
Q1120 Easy

True or False: There are three worksheets with every new workbook. You can change that automatic number if you want to.

False
True
Q1121 Easy

True or False: The visual basic editor can be used even when Excel is not running

True
False
Q1122 Easy

In order to change page margin, which menu would you choose to select "Margins"?

Page Layout
View
Insert
Review
Q1123 Easy

The ________ displays the current cell mode, the page number, and the zoom buttons.

Ribbon
Status bar
Formula Bar
Quick Access Toolbar
Q1124 Easy

To remove all non printing characters from a cell you can use the following function?

TRIM()
PROPER()
CLEAN()
CHAR()
Q1125 Easy

What term describes explanatory text attached to a cell ?

Callout
Dialog
Context
Comment
Q1126 Easy

In Microsoft Excel 2016, what does the VALUE function do?

It is used for converting a text argument to a number.
It counts the cells that contain numbers in an Excel sheet.
It is used for adding numeric values.
It is used for calculating the ASCII values of a text string.
Q1127 Easy

How will you reverse the direction of a SmartArt graphic?

Right-click on the SmartArt graphic, select Reverse
Under SmartArt Tools, on the Format tab, in the Arrange group, select Reverse
Under SmartArt Tools, on the Design tab, in the Create Graphic group, click on Right to Left
All of the above
Q1128 Easy

If cell A1 contains the value "32.96" and you format the cell to show only 1 decimal place, which value is displayed?

None of These
32.9
32.960
33.0
Q1129 Easy

What function do you use to insert the current date and time into a cell?

Now()
Today()
CURRENT()
DATE()
Q1130 Easy

True or False: A Name can be applied to a single cell or a range of cells.

True
False
Q1131 Easy

What does the Excel 'Reduce file size....' option do? (choose all that apply)

compress pictures
compress text cells
Delete cropped areas of pictures
Saves in compressed format
Q1132 Easy

When number signs (#####) are displayed in the cell, it means:

There are too many characters in the cell to be displayed with the current cell width
All of the above
The decimal point placement in the cell is wrong
The formula in the cell is wrong
Q1133 Easy

Which of the following is an absolute cell reference?

#A#1
$1$A
%A%1
$A$1
Q1134 Easy

If you created a macro by recording your keystrokes, how can you modify it?

By editing the VBA code, just as if you wrote the macro by hand.
Purchase the full Visual Basic software from Microsoft. Only that can edit recorded macros.
Use the Recording Editor to drag the commands up and down and change their options.
You can't. You have to delete the macro and re-record it.
Q1135 Easy

What will happen if you enter XYZ1 in a cell and drag the fill handle down?

It will fill XYZ1 in all the cells that are dragged through.
It will fill the series with XYZ2, XYZ3, XYZ4 and so on, respectively.
It will fill the series with XYZ2, ABC3, DEF4 and so on, respectively.
None of the above.
Q1136 Easy

Which keyboard shortcut should be used to minimize or restore the ribbon?

CTRL+F3
CTRL+F2
CTRL+F1
None of the above
Q1137 Easy

How to search text in Excel?

control-S
Control-F
Q1138 Easy

Data in a form created from the primary table is contained in the ____.

Form
Main form
One-to-many
Auto format
Q1139 Easy

To insert a chart for data in a table, select any cell in the table and then choose ____

Table > Recommended Charts
Table > Line Chart
Insert > Recommended Charts
Insert > Table Chart
Q1140 Easy

True or False: Zero values are not plotted using sparklines.

False
True
Q1141 Easy

What tool is used to split the window into different parts of the same worksheet?

Title Bar
Duplicate Box
Seperate Box
Split Box
Q1142 Easy

You insert a comment in a worksheet by using a command on the ____ tab on the ribbon.

Ribbon
Format
Review
Home
Q1143 Easy

How can you replicate only the formatting of a graph onto other graphs in your workbook?

Format Painter
Copy, Paste
Copy, Past Special, All
Copy, Paste Special, Format
Q1144 Easy

Which keyboard shortcut copies cell data?

Shift + v
Ctrl + c
Ctrl + v
Ctrl + Shift + c
Q1145 Easy

Mary wants to copy a worksheet from WorkBook1 to WorkBook2. Which of the following is correct about this scenario?

This is not possible because a worksheet cannot be copied to another workbook.
The worksheet can be copied if WorkBook2 is closed.
The worksheet can be copied but its formatting will be lost.
The worksheet can be copied if WorkBook2 is also opened.
Q1146 Easy

The ____ button gives options for how to fill cells following a fill operation.

Auto Fill Options.
Insert Options
Paste Options
None of these
Q1147 Easy

The accounting style shows negative numbers in

italics
parentheses
bold
strikethrough font
Q1148 Easy

Which button allows you to copy cell formats from one cell to another?

enter
format painter
autofit
esc
Q1149 Easy

If A1=6 and B1=4, then what is =A1&B1?

10
1.5
24
64
Q1150 Easy

You can use the ____ key(s) on the keyboard to navigate a worksheet.

Down arrow key
Left arrow key
Right arrow key
Arrow
Showing 1150 of 1421 questions

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

Report a mistake

What's wrong?