MS Excel mcq Questions and Answer | Microsoft Excel-1

1 min read

MS Excel mcq Questions and Answer | Microsoft Excel-1

Ms Excel Set-1

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

 

Leave a Reply

Your email address will not be published.

Previous Story

MS Word mcq Questions and Answer | Microsoft Word-11

Next Story

MS Excel mcq Questions and Answer | Microsoft Excel-2

Latest from Blog

error: Content is protected !!