Microsoft Excel 2019 Objective
Q.1)
∑ is a sign of_______
a) Summarize the Data
b) Autosum
c) Subtractions
d) All
Ans: b
Q.2)
15 points is the default height of ______
a) Column
b) worksheet.
c) row
d) cell
Ans: c
Q.3]
A bar displays content and formula of active cell is called_______ bar
a) Status
b) Formula
c) Address
d) Title
Ans: b
Q.4]
A bar which is displayed at the right side of the name box is called as______in
MS Excel 2010.
a) name bar
b) address bar
c) formula bar
d) no such bar is displayed in MS Excel 2010
Ans: c
Q.5]
A dark colored strip showing the title at the top of MS-Excel window is called
as______
a) Status Bar
b) Title Bar
c) Scroll Bar
d) None of
Ans: b
Q.6]
A formula in Excel always has to start with (fx).
a) True
b) False
Ans: b
Q.7]
A Worksheet may contain many Workbook
a) True
b) False
Ans: b
Q.8]
Active cell is recognized by a broad black border around it, this border is
called as_______
a) Row
b) Column
c) pointer
d) Cell Pointer
Ans: d
Q.9]
After clicking shaded area in Scroll bar the matter gets scroll which can fit
up to one screen.
a) True
b) False
Ans: a
Q.10]
After formula being copied and pasted In new cell, the cell references which
remain unchanged are called as______
a) Absolute References
b) Relational References
c) Relative References
d) Link
Ans: a
Q.11]
After starting MS-Excel 2010, we see_____ file by default
a) Book1
b) Document1
c) Presentation1
d) None
Ans: a
Q.12]
Alignments of cell in Excel sheet can be done by______
a) Files/Cells
b) Format/Cells
c) FTP / Align
d) None
Ans: b
Q.13]
All commands are given in the form of Tabs and Ribbon in Excel 2010.
a) True
b) False
Ans: a
Q.14]
All of these are excel features except____
a) Office Assistant
b) What's this?
c) The help wizard
d) Slide
Ans: d
Q.15]
An animated border indicates_
a) Will be deleted
b) Are closed
c) Have been send to clipboard
d) None of These
Ans: c
Q.16]
________application is most suited for a bar chart
a) Word Processor
b) Database
c) DOS
d) Spreadsheet
Ans: d
Q.17)
Ascending-Descending are type’s of_____
a) Indent
b) Alignment
c) Sorting
d) All of These
Ans: c
Q.18]
At a time only one Cell can be active.
a) True
b) False
Ans: a
Q.19]
At the Left side of the Zoom Slider, we see______Bar
a) Scroll bar
b) Title Bar
c) Task Bar
d) Status Bar
Ans: d
Q.20]
At the right side of the sheet tabs, we get the horizontal_______ Bar
a) Tool Bar
b) Scroll Bar
c) Title Bar
d) Status Bar
Ans: b
Q.21]
Autofit row height and autofit column width options are available under the _____ tab
cells group in MS Excel 2010.
a) insert
b) delete
c) format
d) sort
Ans: c
Q.22]
Auto fill Option is used to get 1,2,3,4... Numbers in_______ Column
a) Serial Number
b) Down
c) Up
d) None of These
Ans: a
Q.23]
Auto formatting cannot be changed by using the normal formatting command
a) True
b) False
Ans: b
Q.24]
Auto Sum option is available in_____
a) Formula
b) Data
c) Insert
d) None of These
Ans: a
Q.25]
Autosum button is available in data tab in MS Excel 2010
a) True
b) False
Ans: b
Q.26]
Aver() function in MS Excel 2010 will find the average of the numbers from given
cells?
a) True
b) False
Ans: b
Q.27]
______Bar is given at the top side of the 'Opening screen' in Excel
a) Status
b) Title
c) Access
d) Tool
Ans: b
Q.28]
Below the_____ area, we get sheet Tabs
a) worksheet
b) Cell
c) Row
d) Column
Ans: a
Q.29]
Below the worksheet area, we get_____
a) Name Box
b) Tabs
c) Formula Bar
d) Sheet Tabs
Ans: d
Q.30]
Beside the Excel logo on the title bar_____ is found in iconized view
a) Commands
b) Menu
c) Page Layout
d) None
Ans: a
Q.31]
Bold is used to make the selected text as_____
a) Bold
b) Italic
c) Bold & Italic
d) Black
Ans: a
Q.32]
By Pressing Ctrl+S,______action is done.
a) Open file
b) new file
c) Save file
d) Exit file
Ans: c
Q.33]
By Pressing Home Key Cell Pointer move to first Cell of current Row.
a) True
b) False
Ans: a
0.34]
By using_____ Command we can save the current workbook.
a) Open
b) New
c) Save
d) Close
Ans: c
35]
By using Exit option, what action is done in Excel
a) Quit Excel
b) Open Excel
c) Close file
d) Open file
Ans: a
36]
By using _____ Option we get the Printouts.
a) Preview
b) Print
c) Page Layout
d) All of These
Ans: b
Q.37)
By using_____ option, only selected matter is removed but format remains as it
is in the cells.
a) Contents
b) Cell contents
c) Comments
d) None
Ans: a
Q.38]
By using_____ option, we can add the cell comments
a) Clear contents
b) Clear Cell contents
c) Clear Comments
d) None of These
Ans: c
0.39]
_____can be used to different mathematical calculations in Excel.
a) Autofill
b) Text
c) Mid
d) Formula
Ans: d
Q.40]
Can we save Excel file in Pdf?
a) True
b) False
Ans: a
Q.41]
Cell Address/Cell Reference is the combination of Column Label and Row Number.
a) True
b) False
Ans: a
Q.42]
Cell address contains column label and row number in MS Excel 2010
a) True
b) False
Ans: a
Q.43]
Cell addresses used in Formula are called as______
a) Formulas
b) Cell Reference
c) Parameters
d) Functionlist
Ans: b
Q.44]
CELL is an information function
a) True
b) False
Ans: a
Q.45]
Cell is the intersection of______
a) two cells
b) workbook
c) worksheet
d) row and column
Ans: d
Q.46]
Cell in MS Excel 2010 is a_____.
a) intersection of only rows
b) intersection of only columns
c) intersection of rows and
columns
d) None of These
Ans: c
Q.47]
Cell Pointer is the______ Border around the Active Cell.
a) Thin
b) Thick
c) Long
d) Outside
Ans: b
Q.48]
Cell value typed in selected cell displayed in_____
a)Status Bar
b) Formula Bar
c) Title Bar
d) None
Ans: b
Q.49)
Cells are always recognized by name of_______
a) Column
b) Row
c) Cell
d) A AND B
Ans: d
0.50]
Chart Option is Available in____ Menu.
a) View
d) Home
c) Data
b) Insert
Ans: b
Q.51)
Chart option is available in______ in MS Excel 2010
a) Insert tab
b) Home tab
c) page layout tab
d) view tab
Ans: a
Q.52]
______Collection is called as Workbook
a) Worknote-Book
b) Work Document
c) Chart Book
d) Worksheet
Ans: d
Q.53)
Column width gets adjusted according to the matter width by using_____ Option
a) Auto Fit.
b) Auto Format
c) Auto Text
d) Auto Cut
Ans: a
Q.54]
Comments can be added to cells using___
a) Smart Tip
b) Web Tip
c) Soft Tip
d) Cell Tip
Ans: d
Q.55]
Ctrl + Pg Dn key combination can be used to go on the next sheet.
a) True
b) False
Ans: a
Q.56]
ctrl + pg up is used to go to next workbook in MS Excel 2010
a) True
b) False
Ans: b
Q.57]
Ctrl+T is used for creating Table in Excel
a) True
b) False
Ans: a
Q.58]
Custom Series Option is used to make Series of Data.
a) True
b) False
Ans: a
Q.59]
Custom View option is available in_____
a) View
b) Review
c) open
d) Home
Ans: a
Q.60]
_____data type cannot be used as a data a cell.
a) Text
b) Formula
c) Tree
d) Number
Ans: c
Q.61]
Date format data into a cell by default, is_____
a) DD-MM-YY
b) YY-DD-MM
c) MM-DD-YY
d) None of These
Ans: c
Q.62]
DB is financial function.
a) True
b) False
Ans: a
Q.63]
Default file name in Excel workbook is
a) Document 1
b) File 1
c) Book 1
d) None of These
Ans: c
Q.64]
Delete Sheet Command is given in Home Tab - ______
a) File
b) View
c) Cells Group
d) Tools
Ans: c
Q.65]
Different types of Underline Style are available in_____ Group of Home Tab.
a) Print
b) Font
c) Save as
d) Mail merge
Ans: b
Q.66]
Doughnut is one of the type of_____ in Excel.
a) Picture
b) Symbol
c) Chart
d) None of These
Ans: c
Q.67]
Each excel file is called as workbook because
a) it contains many sheets
b) it contains many text files
c) it contains many hyperlinks
d) None of These
Ans: a
Q.68]
Each row in Excel has given one Number.
a) True
b) False
Ans: a
Q.69]
Every cell has_____ assigned to it
a) Number
b) row
c) column
d) Address
Ans: d
Q.70]
Every Worksheet has vertical and horizontal lines called_____
a) Cell
b) Pixel
c) Table
d) Grid
Ans: d
Q71] Excel file Extension XLSX means ________
a)
Microsoft Excel Workbook
b)
Microsoft Excel Template
c) Web Page
d)
Microsoft Office Workplace
Ans : a
Q.72] Excel is not generally used for data analysis in offices.
a)
True
b) False
Ans: b
Q.73] _________features displays total of selected cell values
on status bar
a) AutoCal
b) Add
c)
Autosum
d) Sum
Ans: d
Q.74] File name of current sheet is shown on _________
a)
Reference Area
b) Title
Bar
c) Page
d) On Cell
Ans: b
Q75] Fill Command is provided in _______ tab
a) Home
b) Tools
c) File
d) Format
Ans: a
Q76] For example using=Min (B4:B10) formula, we get the smallest
number in cell B4 to B 10
a) True
b) False
Ans: a
Q.77] For Normal Arial Font, Row height is_______ points by
default
a) 10
b) 12
c) 15
d) 14
Ans: c
Q.78] For which function, a formula with a logical function
shows word "TRUE" or "FALSE" as a result
a) Hyperlinked
b) Index
c) Linked
d) Embedded
Ans: b
Q.79] Formula can be use for_______ In Excel.
a) Mathematical
Calculations
b) Addition
c)
Substractions
d)
Multiplications
Ans: a
Q.80] Formula means instruction to perform________
a) Addition
b) Substruction
c)
Multiplication
d) Calculation
Ans :d
Q.81) Formula Means ________ to perform calculations.
a) option
b) instruction .
c) menu
d) None of
These
Ans: b
Q.82) Function always starts with _________ Symbol.
a) *
b) ?
c) !
d) =
Ans: d
Q.83] ________Function makes the text given in the brackets
converted in small cases and inserted in the cell
a) Upper ()
b) Capital ()
c) Lower ()
d) Case ()
Ans: c
Q.84] ________ Function rounds off number upto specified digits.
a) =if ()
b) =Max ()
c) =Round ()
d) =Ceiling ()
Ans: c
0.85] ________Functions converts the number into nearest
integer.
a) =Int()
b) =If()
c) =Max()
d) =Round()
Ans: a
Q86) Functions Means in built formula basically available in
_________
a) powerpoint
b) Word Art
c) word
d) Excel
Ans: d
Q.87] Grids has vertical and horizontal lines
a) True
b) False
Ans: a
Q.88] Grids on worksheet in MS Excel 2010 are ________
a) vertical and
horizontal lines
b) images
c) graphs
d) None
Ans a
Q.89] Croup of selected cell is
called as_______
a)
Cell Range
b)
Row
c)
Column Width
d)
Table
Ans: a
Q.90] Header and Footer is Used
to print common text on each page.
a)
True
b)
False
Ans: a
Q.91] Help option is available
in_______ Menu
a)
Insert
b)
File
c)
View
d)
Tools
Ans: b
Q.92] How many kinds of
Alignment are available in MS-Excel
a)
3
b)
5
c)
6
d)
7
Ans : c
Q.93] How many maximum
worksheets can be inserted in a single workbo in MS Excel 2010?
a)
265
b)
256
c)
250
d)
255
Ans: d
Q.94] How many types of
horizontal alignments are possible in MS Excel?
a)
4
b)
3
c)
2
d)
horizontal alignments can not be done
Ans : b
Q.95] How many types of Orientation
are available in MS-Excel?
a)
One
b)
Two
c)
Three
d)
Four
Ans: b
Q.96] How many types of vertical
alignments are possible in MS Excel 2010
a)
1
b)
2
c)
3
d)
4
Ans: c
Q.97] How to select single complete
column in MS Excel 2010?
a)
ctrl+a
b)
ctrl+c
c)
Alt+e
d)
Click on column header
Ans : d
Q.98] Hyperlink is used to
create link in the sheet
a)
True
b)
False
Ans: a
Q.99] "IF is not a logical
function
a)
True
b)
False
Ans: b
Q.100] If________ Key is pressed
the cell pointer moves to the first cell of the current row.
a)
page up
b)
Home
c)
Page down
d)
End
Ans b
Q.101] If _______ Option used we can make
series of data as required just like series of months and days.
a)
Custom Series
b)
Sort
c)
Filter
d)
Pivot Table
Ans : a
Q.102] If the size of the cell
is too small to accommodate the desired matter_______ is used to set text in
cell
a)
Vertical Alignment
b)
Wrap Text
c)
Merge and Center
d)
Text Orientation
Ans: b
Q.103] If we increase the height
of the row, the text matter automatically gets shifted to the _____ of the Cell
a)
Bottom
b)
Middle
c)
Up
d)
Down
Ans: a
Q.104] If we merge two cells
containing data in them in MS Excel 2010, which data is kept in merged cell?
a)
we can not merge cells in MS Excel 2010
b)
right most cell data
c)
nothing is kept in merge cell
d)
upper left most data
Ans d
Q.105] If you delete a row,
column or cell then all the data______
a)
Will be saved in a Clipboard
b)
Will also get deleted
c)
Save in a file
d)
Will save temporary
Ans : b
Comments
Post a Comment