Skip to content

Excel MCQ Questions

0
Answered
0
Correct
0%
Accuracy
Q1201 Easy

If is an example of a ________ function

Pane
Logical
Page Setup
MEDIAN
Q1202 Easy

State whether true or false:When you sign the stamp signature line in an Office document, you add both a visible stamp and a digital signature.

True
False
Q1203 Easy

The arguments of the formula =SUMIF($G$5:$G$257,"Large",H$5:H$257) are:

Sum the numbers in the range G5 to G257 that have the word "Large" in the same row in the column range H5 to H257
None of these
Sum the numbers in the range H5 to H257 that have the word "Large" in the same row in the column range G5 to G257
For every cell in range G5:G257 that contains the word "Large" multiply the corresponding value in the H: column by 5 and add together
Q1204 Easy

To resize an embedded chart, ____.

Select the chart and drag the corner sizing handle of the selection box
Select the chart and drag the corner sizing handle of the selection chart
Select the chart and drag the corner sizing handle of the unselected box
Select the chart and drag the corner sizing handle of the unselected chart
Q1205 Easy

In Microsoft Excel 2013, which of the following options is/are the miniature chart(s) that fit into a single cell and help(s) in analyzing and viewing trends in data without creating an entire chart?

Sparklines
Add-Ins
PivotChart
Consolidate
Q1206 Easy

To create another worksheet that is exactly the same as the current worksheet you would...

Move or copy
Insert worksheet
Insert workbook
Q1207 Easy

Which Excel chart type is useful for finding the best combinations between two sets of data, showing them as a 3-D surface like a topographic map?

A stock chart
A surface chart
An XY (Scatter) chart
None of the above
Q1208 Easy

Which function checks to see that all conditions are true before returning a TRUE response?

IF
TRUE
VLOOKUP
AND
Q1209 Easy

The ____ criteria filter requires the records displayed to have the current date.

Today
Tabular
Year to Date
Between
Q1210 Easy

What function is NOT considered a Math & Trig function?

RAND
SUM
MAX
ROUND
Q1211 Easy

Excel 2003: True or False: Excel 2003 will not prompt you to save information if anything new has been typed between the last save and the time you close the file.

False
True
Q1212 Easy

At the bottom of column C, you have a simple total formula. You want to reuse it with the values in column D, so you copy and paste. What must you do with the formula after pasting?

Nothing. Excel adjusts the formulas automatically.
You can copy formulas only across rows, not down columns, so this situation couldn't happen.
You need to use the Evaluate Formula command to see if the new formula works correctly.
You have to edit the column and row references so the formula doesn't produce an incorrect result.
Q1213 Easy

Which formula will provide the same result as the following: =CONCATENATE("Smarter","er")

Smarterer
#NAME?
Q1214 Easy

Let's say you have a PivotTable with separate rows of sales from January to December. What's a quick way to further summarize the monthly data?

Group the months into quarters.
Create a second PivotTable based on the first PivotTable and filter the data you need.
In the PivotTable task pane, drag the fields from the Rows section into the Columns section, and vice versa.
Click the AutoSummary button on the PivotTable tab of the Ribbon.
Q1215 Easy

When creating a pivottable report, the active cell should be positioned ____.

Anywhere in the range that contains the data
In cell A1
Anywhere outside the range that contains the data
There is no active cell in a PivotTable report
Q1216 Easy

When you use the Freeze Panes command, Excel freezes all of the columns and rows:

below and to the right of the selected cell.
above and to the right of the selected cell.
below and to the left of the selected cell.
above and to the left of the selected cell.
Q1217 Easy

If you would like to count the number of cells within a range that fit a specific criteria, which function would use?

COUNTONLYFIT
IFFIT
NUMFITCRITERIA
COUNTIF()
Q1218 Easy

lookup _value argument is the value that is searched for in the first column of the table array

True
False
Q1219 Easy

The name peter is entered in cell b4. this is a ____.

Label.
Number.
Formula.
Value.
Q1220 Easy

To go to column a of the current row press ____

Ctrl + Home
Home
Shift + Tab
Tab + Enter
Q1221 Easy

You can customize a format code in a cell entry to specify how ____ are displayed in a cell.

Text
Negative numbers
Positive numbers
All of the above
Q1222 Easy

A special feature that is introduced for mathematical problems in which handwritten equations are converted to text for inserting into your document. How can that feature be accessed?

Insert new equation
Mathematical equation
Ink equation
None of the above
Q1223 Easy

what is the function key for creating a chart for a given table?

F11
F4
F1
F10
Q1224 Easy

In Excel's Format Shape pane, which line option sets the style used for the end of a line, such as flat, round or square?

Compound type
Dash type
Cap type
Join type
Q1225 Easy

State whether the following statement regarding cell references in Microsoft Excel 2010 is true or false.An Absolute cell reference consists of the column letter and row number.

True
False
Q1226 Easy

What is the function used for removing all non-printable characters from a string in Excel?

DEL
CLEAN
CLEAN()
DEL()
Q1227 Easy

True or false? An absolute reference is designated in the formula by the addition of a pound sign (#).

True
False
Q1228 Easy

What should be the file type of a saved excel macro file

xlsx
xlt
.xlsm
Q1229 Easy

Which feature quickly copies and adjusts a formula down a column or across a row?

AutoFormula
AutoSum
AutoFilter
AutoFill
Q1230 Easy

An answer report shows original and final values of the target cell and changing cells plus ____.

Answer
Scenario summary
Constraints
Q1231 Easy

Suppose you enter =EOMONTH(A1,1) and the date entered in A1 is 2/14/2012. What will be the result of this function?

3/30/2012
1/31/2012
2/29/2012
3/31/2012
Q1232 Easy

You can use the horizontal and vertical scroll bars from?

View different rows and columns edit the contents of a cell
Edit the contents of a cell
view different worksheets
Split a worksheet into two panes
Q1233 Easy

What are Information Functions in Excel?

PDURATION − Returns the number of periods required by an investment to reach a specified value
ISFORMULA − Returns TRUE if there is a reference to a cell that contains a formula
SHEET − Returns the sheet number of the referenced sheet
SHEETS − Returns the number of sheets in a reference
Q1234 Easy

Excel measures row height in _____ and column width in _____.

Characters; points
Inches; values
Values; inches
Points; characters
Q1235 Easy

In Microsoft Excel 2013, theNew Commentoption is available under which of the following tabs?

Insert
File
Review
View
Q1236 Easy

Which of the following options are true about a PivotTable calculated field?

Individual values of other fields are added up and then the calculation is performed on the total value.
Formulas of calculated fields can refer to the PivotTable totals or subtotals.
Worksheet cells cannot be referred by calculated field formulas through address or name.
Sum is the only formula available for a calculated field.
Q1237 Easy

Which of the following is the keyboard shortcut for accessing theSpellingoption in Microsoft Excel 2013?

F11
F7
F10
F9
Q1238 Easy

Text annotations are ____ that you can add to further describe the data in your chart.

Labels
Line
Tick
Legend
Q1239 Easy

Which of the following cell references in a formula should be used for making sure that a column value does not change when copied?

A$2
$A2
!A2
A!2
Q1240 Easy

True or False: It is possible to have a folder of templates in Excel to make it easier to access them.

True
False
Q1241 Easy

Creating a Module, A VBA module can hold following types?

Declarations: One or more information statements that you provide to VBA. For example, you can
declare the data type for variables you plan to use, or set some other module-wide options
Sub procedures: A set of programming instructions that performs some action Function procedures: A set of programming instructions that returns a single value
End procedures: A set of program end
Q1242 Easy

In Excel 2010, you can open the Highlight Changes dialog box by choosing Track Changes from which menu?

Insert
Format
Edit
Review
Q1243 Easy

While you are typing data into a cell, which of these commands cannot be performed?

Translate
Close the Workbook
Insert Symbol
Edit Font Color
Q1244 Easy

A pivot table allows you to:

Merge columns and rows together
Create a worksheet with data using a filtering window where you can include or exclude desired fields of the original table
Save data within a cell
Maneuver from one application database such as Access to another such as Excel
Q1245 Easy

A report formatted where the page is taller than it is wide is formatted in ____.

Landscape orientation
Primary datasheet orientation
Portrait orientation
Wizard orientation
Q1246 Easy

In order to protect your Excel data, which of the given f‌ile-level protections are available in Microsoft Excel 2016?1. File encryption2. Setting a password to open or modify a f‌ile3. Digital signature

All 1, 2, and 3
Only1 and 2
Only1 and 3
Only 2 and 3
Q1247 Easy

Excel's __________ can be used to construct a crosstabulation.

PivotTable report
COUNTIF function
Chart Tools
SUM function
Q1248 Easy

Which option allows you to choose different Chart style options?

Click on Chart and choose Chart Design from Menu
Click on Table and choose Chart Design from Menu
Click on Chart and choose View from Menu
Click on Chart and choose Data from Menu
Q1249 Easy

Quickest way for renaming a sheet:

Double click the sheet tab
Right mouse button-> rename
Q1250 Easy

To insert a link to another worksheet, workbook or file, what dialog box do you use?

The 3D Formula dialog box
The Connections dialog box
The From Other Sources dialog box
The Hyperlink dialog box
Showing 1250 of 1421 questions

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

Report a mistake

What's wrong?