Skip to content

Excel MCQ Questions

0
Answered
0
Correct
0%
Accuracy
Q1051 Easy

Which tab should be used to display or hide axes?

Data tab
Layout tab
Insert tab
View tab
Q1052 Easy

Cell A1 contains two blank spaces (eg press the space bar twice). The formula =ISBLANK(A1) returns:

2
0
TRUE
FALSE
Q1053 Easy

In Microsoft Excel 2016, which of the following functions is used for returning the sheet number of a reference sheet?

Sheets
Sheet
Number
None of the above.
Q1054 Easy

The percent style button formats selected cells as a percentage with ________.

One decimal place
Two decimal places
Three decimal places
Zero decimal places
Q1055 Easy

Cell A1 contains the number 3. Which formula returns the text Apple?

#NAME?
#VALUE!
Q1056 Easy

What is one easy method to see if your spreadsheet will print on one page?

Adjust the Zoom to 100%.
If it fits onto the screen, it will print on one page.
Use Page Break Preview.
Select "landscape" on paper set up.
Q1057 Easy

When a cell is part of an active formula, it is surrounded with ________.

A colored background with small circles on each corner
A bold, black border with small circles on each side
A colored border with small boxes on each side
A white border with small boxes on each corner
Q1058 Easy

What you could do to stop the pivot table from loosing the column width upon refreshing?

a. Format loss in pivot table can be stopped simply by changing the pivot table options. Under the “Pivot Table Options” turn on the “Disable Preserve Formatting” and disable “ Auto Format” option.
b. Format loss in pivot table can be stopped simply by changing the pivot table options. Under the “Pivot Table Options” turn on the “Disable Preserve Formatting” and enable “ Auto Format” option.
c. Format loss in pivot table can be stopped simply by changing the pivot table options. Under the “Pivot Table Options” turn on the “Enable Preserve Formatting” and disable “ Auto Format” option.
d. All of the above
Q1059 Easy

If you are working in English (US), Chinese or Japanese, Excel 2002 can speak data as you enter it, to help you verify accuracy. How do you activate this feature?

Click validation on the data menu
Point to speech on the tools menu, and then click speech recognition
Point to speech on the tools menu, and then click show text to speech toolbar
All of the above
Q1060 Easy

Which of the following is NOT an option to erase the contents of a cell?

Clear Formulas
Clear All
Clear Contents
Clear Formats
Q1061 Easy

Cell A2 contains a person's age. Cells E2:F6 hold a lookup table with the lowest age of each group in column E (0, 18, 25, 35, 45) and the group's name in column F. Which formula in cell B2 returns the person's age group?

=VLOOKUP(A2,$E$2:$F$6,2,TRUE)
=VLOOKUP(A2,$E$2:$F$6,2,FALSE)
=HLOOKUP(A2,$E$2:$F$6,2,TRUE)
=MATCH(A2,$F$2:$F$6,0)
Q1062 Easy

State weather the following statement is true or false.We can use the drag drop option to copy the content in Excel 2013.

False
True
Q1063 Easy

A/an _______ is a mathematical statement that calculates a value.

Argument
Function
Order of operations
Formula
Q1064 Easy

If you want to select margin sizes,where you should go?

Page Layout tab
View tab
Data tab
Review tab
Q1065 Easy

Clicking the ____ opens the insert function dialog box.

(DATA tab | Data Tools group)
(VIEW tab | Zoom group)
(HOME tab | Number group)
Insert Function box in the formula bar
Q1066 Easy

Columns D, E, and F are hidden in your worksheet. What is one way to unhide these columns?

Select column G, then right-click and select Unhide.
Select column C, then right-click and select Unhide.
On the Page Layout tab, in the Rows and Columns section, select Unhide.
Click and drag to select columns C and G, then right-click and select Unhide.
Q1067 Easy

Excel 2003: You can enter three types of data in a cell these are?

text, numbers, and formulas.
numbers and text only
formulas only
images, sounds, videos
Q1068 Easy

You have entered data in a cell B2. You want cells B3:B16 to have the same data. What is the fastest way?

Highlight B2:B16 and press CTRL+D.
CTRL-D? or CTRL+D?
Select B2, Copy. Select B3:B16, Paste.
Select B3, enter first character of data, press enter. Select B4, enter first character of data, press enter...up to B16.
Q1069 Easy

After generating a summary page of Scenarios, how can you refresh the summary if there are changes to the underlying data?

Click inside the summary, then press the F5 key.
Click inside the summary, then click the Data tab on the Ribbon. Click Refresh.
Display the Scenarios dialog box and click the Refresh button.
You have to create a new one. Scenario summaries aren't linked to the data.
Q1070 Easy

Which worksheet function converts a time in the form of text to a serial number?

TIMEVALUE
NETWORKDAYS
TIME
NOW
Q1071 Easy

Choose True or False.Slicers are typically associated with the PivotTable in which they are created.

True
False
Q1072 Easy

In a worksheet the ____ is called the formula prefix

Minus sign (-)
Pound sign (#)
Plus sign (+)
Equal sign (=)
Q1073 Easy

How can you delete a worksheet?

Right-click the worksheet's tab and select Delete
Double-click the worksheet's tab and select Delete
From the File tab, select Delete Sheet
Click the worksheet's tab and press the Delete key on your keyboard
Q1074 Easy

Choose True or False.A valid certificate from a certificate authority is required to add a digital signature in Microsoft Excel 2016 workbook.

True
False
Q1075 Easy

Dates in excel are stored as a serial number starting with ____ as 1 and increasing sequentially.

January 1, 1900
Feb 1, 2000
March 1, 1996
None of these
Q1076 Easy

When using vlookup, the _____argument is optional.

False, COUNTIF
Range_lookup
Green triangle
The first column
Q1077 Easy

How can a chart be modified?

By modifying a legend
By modifying the display of chart axes
By modifying titles and data labels
All of the above
Q1078 Easy

To prevent yourself or others from accidentally deleting formulas or other critical data you can use:

Review > Protect sheet
Review > Restrict Permissions
Data > Protect
Data > Lock
Q1079 Easy

What does the VALUE function do?

Adds all the numbers in a range of cells
Counts the number of cells in a range of cells
Adds the cells specified by a certain criteria or condition
Converts a string that represents a number to a number
Q1080 Easy

When you work with large worksheets, you may need to use?

size the worksheet to fit on the specific number of pages
add and remove page breaks
specify only certain print areas
All of the above
Q1081 Easy

Which is NOT a function?

MAX
AVERAGE
PMT
DMV
Q1082 Easy

Excel displays various ________ on the right to enable you to format different chart elements

Panes
Dialog boxes
Check boxes
Windows
Q1083 Easy

Cells D3 through Z3 list sales total for various months. What does the equation "=SUM(D3:Z3)" show?

Sale averages for each month.
Total sales for all the months in D3 through Z3.
Average sales for all the months in D3 through Z3
Sales quota for each month.
Q1084 Easy

Which formula contains a valid absolute reference?

#VALUE!
#VALUE!
Q1085 Easy

One of the benefits of live preview is that it _____.

Lets you see and evaluate different formats as you develop your workbook
Shows you what a document will look like when printed
Applies thematic styles to your document
Allows you to track changes in your document
Q1086 Easy

The worksheet is organized into individual cells. _________________________

True
False
Q1087 Easy

True or false: To change column width in MS Excel, put cursor on the right side of the cell in that column, in the first row. Click and hold and drag to desired width.

False
True
Q1088 Easy

When you protect a worksheet, all users will still be able to:

filter data
insert and delete columns and rows
sort data
insert and delete other worksheets
Q1089 Easy

The range of cells receiving copied content is called the ____ area

Destination area
Final cell
Receiving range
Receiver cell
Q1090 Easy

Wilson prepares a PivotTable to summarize the month-wise sales of all the salesmen for the Fiscal year 2016-17. His boss asks him to show an additional report to showcase the difference from the previous month. Which of the following tabs in the Value Field Settings dialog box will fulfil this requirement?

Summarized by
Show values as
Summarize Difference
Difference from previous value
Q1091 Easy

What is a function of data markers?

You can automatically apply formatting to a data series
You can change a data print value and automatically turn it into a chart
You can change the position of a data marker and automatically change the data point value in the worksheet
Q1092 Easy

What does letter H stands for in HLOOKUP formula?

Hidden
Horizontal
Header value
However
Q1093 Easy

True or False: All functions begin with the equals sign.

True
False
Q1094 Easy

In Microsoft Excel 2016, which of the following options provides a user the access to options such as Share, Export, Account, Publish, etc.?

Ribbon
View tab
Backstage View
Page Layout tab
Q1095 Easy

A custom list gives you the ability to:

There is no such thing as a custom list in Excel.
create column or row headings within a table.
create a drop down list within your workbook.
Enter the first word in the list and use the autofill handle to complete the list.
Q1096 Easy

How do you make sure that a MACRO won't automatically run on a spreadsheet you've downloaded?

Impossible to block unless you open the spreadsheet and delete/modify the MACROs
Don't download spreadsheets from the Internet.
Set your Security settings so that Excel will ask permission first.
Control-Alt-Delete
Q1097 Easy

State whether true or false:If a SmartArt graphic was converted to individual shapes, it is not possible to convert them back to the SmartArt graphic.

True
False
Q1098 Easy

Which of the following options is used for displaying all the formulas in a spreadsheet?

Ctrl + ^
Ctrl + ~
Ctrl + *
Ctrl + `
Q1099 Easy

A(n) _______ is a limit that is placed on a solver problem's solution.

Max
Target
Constraint
Adjustment
Q1100 Easy

Which of the following is not a reference Operator in Excel?

: (Colon)
, (Comma)
(Space)
; (Semicolon)
Showing 1100 of 1421 questions

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

Report a mistake

What's wrong?