MS Excel mcq Questions and Answer | Microsoft Excel-1
Ms Excel Set-1
MS Excel mcq Questions and Answer | Microsoft Excel-1
Question 1
Which of the following is not a valid Zoom
10
100
300
500
None Of he Above
Question 2
The spelling tool Is placed on _toolbar
Standard
Formatting
Drawing
Reviewing
None of these
Question 3
If you need a text to show vertically In a cell. How will you achieve this?
Choose Vertical on Text alignment In Format Cells
dialog box
Choose 90 Degrees in Orientation of Format Cells
dialog box
Choose Distributed from the Vertical drop down list of
Format Cells dialog box
'Choose Center Across Selection from Horizontal combo
box In Format Cells dialog box
Question 4
Can you set 0,5 Inch left Indentation for a cell in Excel?
Excel does not have 1 ^Indentation feature
can specify Indentation only If you turn the rulers on
Indentation can be set from Format Cells dialog box
Serifs on characters help to differentiate between similar
looking letters
Question 5
You can automatically adjust the ! size of text in a cell if
they do not fit in width by
Double clicking on the right border of column header
From Format choose Columns and then Autofit Selection
Serifs are fine cross strokes that appear at the bottom
and top of a letter
All of above
Question 6
Formatting a cell In Currency, you can specify
Decimal Places
Currency Symbol
Both of above
Insert a new slide
Question 7
Formatting a cell In Number format you can't set
Decimal Places
Use 1000 separator
Negative numbers
Currency Symbol
Backspace
Question 8
What Is entered by the function today ()
The date value for the day according to system clock
The time value according to system clock
Today's date as Text format
none of above
Question 9
Which function will you use to enter the current time In a worksheet cell?
=today( )
=now ( )
=CurrentTime ( )
None of these
Question 10
Special category of Number tab in Format Cells dialog box can be used to apply formats like
Zip Code
Phone Number
Both of above
None of above
Question 11
Merge cells option can be applied from
Format Cells dialog box Alignment Tab
Formatting toolbar
Both of above
All of above
Question 12
Pre-made sheet formats like Simple, Classic, Accounting, Colorful etc can be applied from
from Fromat » Cells
from Format > > Auto format
from Table > > Auto format
All of above
Question 13
Which of the following format you can decide to apply or not In AutoFormat dialog box?
Number format
Border format
Font format
All of above
Question 14
How can you remove borders applied In cells?
Choose None on Border , tab of Format cells
Open the list on Border tool in Formatting toolbar then
choose first tool (no border)
Both of the above
None of above
Question 15
Where can you set the shedding color for a range of cells in Excel?
Choose required color form Patterns tab of Format Cells
dialog box
Choose required color on Fill Color tool in Formatting
toolbar
Choose required color on Fill Color tool in Drawing
toolbar
All of above
Question 16
You can set Page Border in Excel from
From Border tab in Format Cells dialog box
From Border tool in Formatting toolbar
From Line Style tool in Drawing toolbar
You can not set page border in Excel
Question 17
When all the numbers between 0 and 100 in a range should be displayed in Red Color, apply
Use –if O function to format the required numbers red
Apply Conditional Formatting command on Format
menu
Select the cells that contain number between 0 and 100
then click Red color on Text Color tool
All of above
Question 18
You can check the conditions against ___ when applying conditional formatting
Cell value
Formula
Both Of the Above
writing
Question 19
Which of the following is not true regarding Conditional
Formatting?
You can add more than one condition to check
Which of the following features should you use when
typing in the notes text box?
You can apply Font, border and pattern formats that
meets the specified conditions
You can delete any condition from Conditional
Formatting dialog box if it is not requried
Question 20
Which of the following is invalid statement?
Sheet tabs can be colored
Some picture can be applied as a background of a
sheet
You can set the column width automatically fit the
amount of text
The width of a row and be specified manually or fit
automatically
Question 21
Which of the following is not an option in the spelling dialog box?
Edit
Ignore
Ignore all
Change
Question 22
You can quickly change the appearance of your work by choosing Auto Format from the .... Menu
Edit
View
Format
Tools
Question 23
To protect a worksheet, you can choose Protection and the Protect Sheet from the..... menu
Edit
Format
Tools
Data
Question 24
You can open the Highlight Changes dialog box by choosing Track Changes from the .... Menu.
Edit
Insert
Format
Tools
Question 25
Which of the following is not a worksheet design criterion?
Efficiency
Auditabiiity
Description
Clarity
Question 26
To copy cell contents using drag and drop, press the
End key
Shift key
Esc key
All the above
None of these
Question 27
If you press ..... the cell accepts your typing as its contents.
Enter
Ctrl + Enter
TAB
Insert
Question 28
The autofill feature
Extends a sequential series of data
Automatically adds a range of cell values
Applies a boarder around selected cells
All of above
Question 29
What is the keyboard shortcut {button or buttons to be pressed for creating a chart from the selected cells?
F3
F5
F7
F11
Question 30
you can use the formula palette to
format cells containing numbers
create and edit formulas containing functions
entered assumptions data
copy a range of cells
Question 31
What Pivot Table toolbar button updates the data in a Pivot Table or Pivot Chart report if the source data chas
changed
Format Report
Pivot Table
Refresh Data
Show Detail
Question 32
What is an expression that tells how the numbers in a
determined set of cells are to be calculated?
Formula
Field
Data
Query
Question 33
"Qtr 1, Qtr 2, Qtr 3" is an example of a
Formula
Function
Series
Syntax
Question 34
You can edit existing Excel data by pressing the
F1 key
F2 key
F3 key
F4 key
Question 35
The cell reference for a range of cells that starts in cell Bl
and goes over to column G and down to row 10 is ....
G1-G10
B1.G10
B1;G10
B1:G10
Question 36
A user wishes to remove a spreadsheet from a workbook. Which is the correct sequence of gents that will do this?
Go to File-Save As - Save As Type - Excel worksheet
Right click on the spreadsheet tab and setect DELETE
Right click on the spreadsheet and select Insert – Entire Column
None of above
Question 37
What feature enables you to adjust or back solve the value in a cell to reach the desired outcome in a formula?
Scenario Summary report
Goal Seek
Forecasting
Trend line
Question 38
what term describes a background that appears as a grainy, nonsmooth surface
gradient
pattern
solid
texture
Question 39
Excel is a
Graphic program
None of these
Word processor
A spreadsheet
Question 40
To create an interactive Pivot Table for the web, you use a Microsoft Office Web component called
HTML
Pivot Table Field List
Pivot Table List
Pivot Table Report
There are 40 questions to complete.
