MS Excel mcq Questions and Answer | Microsoft Excel-1

Last updated on December 8, 2021
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

Latest Posts

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

Computer Class PDF Download

In this Post we share some Important Questions that Help to your exam The _ may also be called the screen or monitor.(a) scanner(b) printer(c) hard disk(d) software(e) display The primary purpose
computer architecture

computer architecture

Computer architecture refers to the fundamental design and organization of a computer system, including the instruction set architecture (ISA), the memory architecture, and the microarchitecture. It encompasses both the hardware and software
Go toTop