Skip to content

Excel MCQ Questions

0
Answered
0
Correct
0%
Accuracy
Q1001 Easy

Choose True or False.A PivotChart is a graphical representation for a summary of data displayed in a Pivot table.

True
False
Q1002 Easy

Excel's __________ can be used to construct a frequency distribution for categorical data.

Quantitative data
COUNTIF function
Categorical data
Q1003 Easy

Print all, pages, and selected record(s) are options available from the ____ for printing forms.

Search box
Print dialog box
Shift
Drag objects
Q1004 Easy

State whether true or false:No data is deleted when an outline is hidden or removed.

True
False
Q1005 Easy

What will F11 command do?

It will insert a chart in a new worksheet
It will open up the Microsoft Script Editor
It will toggle the task pane
It will open up the Visual Basic Editor
Q1006 Easy

True or False: You can save any Excel document as a web page.

True
False
Q1007 Easy

Excel 2003: True or False: You can never open any workbook that has previously been saved and given a name.

True
False
Q1008 Easy

Which keyboard shortcut selects cells that contain formulas that directly reference the active cell?

CTRL+SHIFT+O (the letter O)
CTRL+] (closing bracket)
CTRL+[
CTRL+SHIFT+}
Q1009 Easy

Is it possible to sort by the color of a cell in the most recent version of excel?

No
Yes
Q1010 Easy

What is the effect of adding an apostrophe before the equals sign in the cell entry =(98-42)^0.5?

The result is centered when viewed in the cell
That cell will require recalculation (press F9) to update
Excel treats it as a text entry and displays the formula
The result is #VALUE!
Q1011 Easy

Which of the following feature correctly represents the following statement? In Excel we can use text series (such as January, February, March, or Sunday, Monday, Tuesday) and numeric series (such as 1, 3, 5, or 2014, 2015, 2016). Instead of entering these series by hand, you can use the fill handle to create them automatically.

Auto Fill
Copy Cells
Fill Range
Fill Series
Q1012 Easy

If cell A1="Smith,Joe" then =Find(",",A1) returns:

4
6
TRUE
FALSE
Q1013 Easy

What is the difference between a workbook and a worksheet?

Workbooks are Access databases and worksheets are Excel
They are the same
A worksheet contains workbooks
A workbook contains worksheets
Q1014 Easy

True or False: To calculate trig functions in degrees, you must convert them, or Excel will calculate them in radians.

False
True
Q1015 Easy

John selects separate theme colors, formatting effects and theme fonts from their respective galleries. Now he wants to save the current settings for future use. In the Themes option under the Page Layout tab, which of the following is the correct option that can be used to save the current theme?

Save Custom Theme
Create New Theme
Save Current Theme
None of the above.
Q1016 Easy

A formula may return any of the following error values:

#DIV/0!
#NAME?
#SUM!
Q1017 Easy

When your chart is selected, how can you get a small pop-up of alternate chart styles to choose?

From the Chart Tools - Design tab of the Ribbon, click Change Colors.
Right-click the chart background and choose Format Chart Area from the pop-up menu.
Double-click anywhere on the chart.
Click the Chart Styles button.
Q1018 Easy

In Microsoft Excel 2016, which of the following statements is/are correct about dates?i) The default date format uses 4 digits for the year.ii) The dates are left-justified in the cells by default.

Only option i) is correct.
Only option ii) is correct.
Both options i) and ii) are correct.
Both options i) and ii) are incorrect.
Q1019 Easy

If you start a date series by dragging down the fill handle of a single cell that contains the date 12/1/19, what will you get?

A series of consecutive days following the initial date
A series of days exactly one month apart
A series of days identical to the initial date
A series of days exactly one year apart
Q1020 Easy

Which Group on the ribbon gives you quick access to the Sum, Average, Count, Min, and Max functions?

Insert Function
AutoSum
AutoFill
Paste
Q1021 Easy

How do you view the 5th decimal place when calculating costs?

Cannot view more than 2 decimals on currency.
Convert to text and view.
Increase the decimal to 5 digits.
Set to smaller font size.
Q1022 Easy

Is it possible to determine the day of the week for a particular date?

Yes, Excel offers several ways of doing so.
No, Excel does not have this capability
No, this will result to computer error.
Q1023 Easy

The ____ is the typeface used to display and print data. it is measured in

Font: points
Window: View
Plus sign: Copied
None of these
Q1024 Easy

A cell with a numerical value has a green corner. What does this mean?

Cell has a comment
Result of a formula
Formatting error
Number stored as text
Q1025 Easy

Which worksheet function returns the standard error of the predicted y-value for each x in the regression?

STDYREG
STDYX
STEXY
STEYX
Q1026 Easy

In Excel, right-clicking the sheet navigation arrows at the bottom-left of the window opens which dialog box?

Activate
Tab color
Hide
Select all sheets
Q1027 Easy

In the following formula, where is the Table Array located? =VLOOKUP(A5:A19,[RegionalSales]FY2012!$D$2:$J$31,7,FALSE)

Regional Sales Workbook, FY2012 Worksheet, Cells D2:J31
FY2012 Workbook, Regional Sales Worksheet, Cells D2:J31
Regional Sales Worksheet, Cell Range A5:A19
Cell Range A5:A19
Q1028 Easy

In Excel, which error does VLOOKUP return when the lookup value is not found?

#REF!
#DIV/0!
#N/A
#NAME?
Q1029 Easy

The less precise way to move objects in report layout view is to ____.

Use the Move command to move objects
Drag objects
Use the arrow keys
None of these
Q1030 Easy

The path to the format painter button is ____.

(HOME tab | Clipboard group).
(REVIEW tab | Proofing group)
Qtr2
Semi-colon (;)
Q1031 Easy

In the following formula: =if(a1=""yes"", ""done"", ""restart""), what happens if a1= no? _____

The formula returns the text
The formula returns the text
The formula returns the text
None of these
Q1032 Easy

A(n) ________ is a worksheet where totals from other worksheets are summarized and displayed.

Summary sheet
Scale to fit
Data bar
Logical test
Q1033 Easy

Which of the following formulas is not entered correctly?

98-B11=
#VALUE!
Q1034 Easy

Circular errors are caused by adding the cell name of a/an _______ cell to a formula

Absolute
Adjacent
Relative
Active
Q1035 Easy

The ____ button allows you to erase recent cell entries.

Undo
Enter
Space
Tab
Q1036 Easy

All functions begin with the formula prefix ____.

=
$
?
>
Q1037 Easy

To make data easier to understand, use a ________ instead of a table of numbers.

Chart
Relative cell reference.
Data marker
Data point
Q1038 Easy

In which tab do you find Macros in Excel 2013?

Insert
Data
View
Formula
Q1039 Easy

The clear all option in the clear button removes the ____ from the active cell.

Contents
Formats
Comments
All of these
Q1040 Easy

Which of the following statements is correct about the #Data constant in Microsoft Excel 2016?

It is the set of all the cells that contains data, which includes any header rows but excludes the total or subtotal rows.
It is the set of all the cells that contain data, which includes any total or subtotal rows but excludes the header rows.
It is the set of all the cells that contain data including header rows as well as any total or subtotal rows.
It is the set of all the cells that contain data excluding header rows as well as any total or subtotal rows.
Q1041 Easy

Which language is used to create macros in Excel?

C#
C
Java
Visual Basic for Applications
Q1042 Easy

For an IF function to check whether cell B3 contains a value between 15 and 20 inclusively, what condition should you use?

OR(B3=>15,B3<=20)
AND (B3>=15,B3<=20)
OR(B3>15,B3<20)
AND(B3>15, B3<20)
Q1043 Easy

What does the function DATE(year, month, day) do?

Adds the number of days in between dates
Extracts the day of the month from the date value
Creates a date value for the date represented by the year, month, and day arguements
Extracts the year number from the date value
Q1044 Easy

Which of the following statements is correct about Excel file protection?

Forgotten passwords can be retrieved by Microsoft.
Passwords are case-sensitive.
The length of a password should be limited to 15 characters.
Q1045 Easy

By default, excel keeps a change history of ____ days for a shared workbook.

10
20
30
40
Q1046 Easy

Voice and unified communications are ________ applications that use 64-byte ip packets.

Infrastructure
Security
Real-time
Session Initiation Protocol (SIP)
Q1047 Easy

How to you create a pivot table?

right click> options> pivot table
Insert>pivot table
Q1048 Easy

In an Excel pie chart, the rectangular box beside the chart that shows which color stands for each slice is the ____.

Legend
Precedents
Dependant
None of these
Q1049 Easy

To view a cell comment, do which of the following?

click the comment command in the insert menu
click the comment command on the view menu
position the mouse pointer over the cell
click the display comment command on the window menu
Q1050 Easy

How will you display the Go To dialog box?

You will press F4
You will press F5
You will press F6
You will press F7
Showing 1050 of 1421 questions

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

Report a mistake

What's wrong?