Ms Excel MCQ Bank
Ms Excel MCQ Bank
Ms Excel MCQ Bank
5. Text formulas:
a.Replace cell references
b.Return ASCII values of characters
c. Concatenate and manipulate text
d.Show formula error value
4
25. To copy formatting from one area in
19. You can use the horizontal and a worksheet and apply it to another
vertical scroll bars to area you would use:
a.Split a worksheet into two panes a.The Edit>Copy Format and Edit>Paste
b.View different rows and columns edit the Format commands form the menu.
contents of a cell b.The Copy and Apply Formatting dialog
c. Edit the contents of a cell box, located under the Format>Copy
d.view different worksheets and Apply menu.
c. There is no way to copy and apply
20. Multiple calculations can be made in formatting in Excel – You have to do it
a single formula using manually
a.standard formulas d.The Format Painter button on the standard
b.array formula toolbar
c. complex formulas
d.smart formula 26. In a worksheet you can select
a.The entire worksheet
21. Hyperlinks can be b.Rows
a.Text c. Columns
b.Drawing objects d.All of the above
c. Pictures
d.All of above 27. When you link data maintained in an
excel workbook to a word document
Q. Can I download the MCQ banks in a.The word document can not be edit
MCQSets.com? b.The word document contains a reference
a.Yes, do a search in mcqsets.com site to the original source application
b.Yes, some files are offered to download free c. The word document must contain a
c. mcqSets.com has download sections hyperlink
d.The downloads are available as PDF files d.The word document contains a copy of the
22. To activate the previous cell in a pre- actual data
selected range, press 28. Which area in an excel window
a.The Alt key allows entering values and formulas
b.The Tab key a.Title bar
c. The Enter key b.Menu bar
d.None of the above c. Formula bar
d.Standard toolbar
23. Which button do yu click to add up a
series of numbers?
a.The autosum button
b.The Formula button
c. The quicktotal button
d.The total button
Q. Will you answer my questions if I send 35. You can copy data or formulas
them to you? a.With the copy, paste and cut commands on
a.There are some pages in MCQ Sets that the edit menu
offers you the form b.With commands on ta shortcut menu
b.If you send me questions using the forms in c.With buttons on the standard toolbars
MCQ Sets d.All of the above
c.I will try to include your questions in the
respective series 36. You can not link excel worksheet data
d.Get the most authentic answers for your to a word document
a.With the right drag method
subjective questions
b.With a hyperlink
31. To create a formula, you can use: c.With the copy and paste special commands
a.Values but not cell references d.With the copy and paste buttons on the
b.C ell references but not values standard toolbar.
c.Values or cell references although not both
at the same time 37. Which of the following is a
popular DOS based spreadsheet
d.Value and cell references
package?
Q. Where can you find best quality multiple a.Word
choice questions? b.Smart cell
a.icttrends.com c.Excel
b.psexam.com d.Lotus 1-2-3
c.prepare.icttrends.com
for more preparation materials
d.mcqsets.com
5
a.Goal seek
38. An excel workbook is a collection of b.Solver
a.Workbooks
c. Scenario manager
b.Worksheets
d.Auto Outline
c. Charts
d.Worksheets and charts 45. When you insert an excel file into a
word document. The data are
39. Excel files have a default extension of a.Hyperlinked placed in a word table
a.Xls b.Linked
b.Xlw c. Embedded
c. Wk1 d.Use the word menu bar and toolbars
d. 123
QS. Can I download the MCQ banks in
40. You can use the format painter MCQSets.com?
multiple times before you turn it off by a.Yes, do a search in mcqsets.com site
a.You can use the format painter button on b.Yes, some files are offered to download
ly one time when you click it
free
b.Double clicking the format painter button
c. mcqSets.com has download sections
c. Pressing the Ctrl key and clicking the format
d.The downloads are available as PDF files
painter button
d.Pressing the Alt key and clicking the format RR. You can use mcqSets.com for
painter button a.Online quiz
b.MCQ Banks
41. You can use the formula palette to
c. Downloads
a.Format cells containing numbers
d.Subjective Questions & answers
b.Create and edit formulas containing
functions for more downloads and other study materials.
c. Enter assumptions data
d.Copy a range of cells
6
d.click the comment command on the view
56. Which of the following options is not
menu
located in the Page Setup dialog box?
a.Page Break Preview. 62. When you want to insert a blank
b.Page Orientation imbedded excel object in a word
c. Margins document you can
d.Headers and Footers a.Click the object command on the insert
menu
57. You want to track the progress of b.Click the office links button on the standard
the stock market on a daily basis. Which toolbar
type of chart should you use?
c. Click the create worksheet button on the
a.Pie chart
formatting toolbar
b.Row chart
d.Click the import excel command on the file
c. Line chart
menu
d.Column chart
Q. How reliable are MCQs in MCQ Sets?
Q. Will you answer my questions if I send
a.I've paid utmost care in correctness
them to you?
b.These are tested questions and answers
a.There are some pages in MCQ Sets that
c. However, if you discover any mistakes
offers you the form
d.Mail me at contact@mcqsets.com
b.If you send me questions using the forms in
MCQ Sets 63. To save a workbook, you:
c. I will try to include your questions in the a.Click the save button on the standard
respective series toolbar from the menu
d.Get the most authentic answers for your b.Press Ctrl+F5
subjective questions c. Click Save on the Windows Start button
d.Select Edit>Save
58. Without using the mouse or the
arrow keys, what is the fastest way of Q. You can use mcqSets.com for
getting to cell A1 in a spreadsheet? a.Online quiz
a.Press Ctrl +Home b.MCQ Banks
b.Press Home c. Downloads
c. Press Shift + Home d.Subjective Questions & answers
d.Press Alt + Home
64. You can edit a cell by
59. Which of the following methods a.Clicking the formula button
can not be used to edit the contents of b.Double clicking the cell to edit it in-place
a cell? c. Selecting Edit>Edit Cell from the menu
a.Press the Alt key d.None of above
b.Clicking the formula bar
c. Pressing the F2 key
d.Double clicking the cell
7
b.Yes, some files are offered to download
75. Which of the following is not a
free
worksheet design criterion?
c. mcqSets.com has download sections
a.Efficiency
d.The downloads are available as PDF files
b.Aditibility
c. Description 80. Which menu option can be sued to
d.Clarity split windows into two
a.Format > window
76. To copy cell contents using drag
b.View > window > split
and drop press the
c. Window > split
a.End key
d.View > split
b.Shift key
c. Ctrl key IO. You can use mcqSets.com for
d.Esc key a.Online quiz
b.MCQ Banks
Q. Will you answer my questions if I send
c. Downloads
them to you?
d.Subjective Questions & answers
a.There are some pages in MCQ Sets that
offers you the form 81. Which of the following is an absolute
b.If you send me questions using the forms cell reference?
in MCQ Sets a.!A!1
c. I will try to include your questions in the b.$A$1
respective series c. #a#1
d.Get the most authentic answers for your d.A1
subjective questions
82. What symbol is used before a
77. Which of the following is the latest number to make it a label?
version of Excel a.“ (quote)
a.Excel 2000 b.= (equal)
b.Excel 2002 c. _ (underscore)
c. Excel ME d.‘ (apostrophe)
d.Excel XP
83. Which symbol must all formula
78. When you copy a formula begin with?
a.Excel erases the original copy of the a.=
formula b.+
b.Excel edits cell references in the newly c. (
copied formula d.@
c. Excel adjusts absolute cell references
d.Excel doesn’t adjust relative cell
references
8
b.By dragging a range of excel data to the
word button on the taskbar while
Q. How reliable are MCQs in MCQ Sets?
pressing Shift key
a.I've paid utmost care in correctness
c. By dragging a range of excel data to
b.These are tested questions and answers the word button on the taskbar while
c. However, if you discover any mistakes pressing Alt key
d.Mail me at contact@mcqsets.com d.None of above
93. Getting data from a cell located in a 99. The auto calculate feature
different sheet is called a.Can only add values in a range of cells
a.Accessing b.Provides a quick way to view the result of
b.Referencing an arithmetic operation on a range of cells
c. Updating c. Automatically creates formulas and adds
d.Functioning them to a worksheet
94. Tab scrolling button d.A and c
a.Allow you to view a different worksheet IOO. How reliable are MCQs in MCQ Sets?
b.Allow you to view additional worksheet a. I've paid utmost care in correctness
rows down d.Mail me at contact@mcqsets.com if you
c. Allow you to view additional worksheet discover any error
columns to the right
d.Allow you to view additional sheets tabs 100. Excel uniquely identifies cells
within a worksheet with a cell name
95. A numeric value can be treated as a a.Cell names
label value if it precedes with b.Column numbers and row letters
a.Apostrophe (&lsquo c. Column letters and row numbers
b.Exclamation (!) d.Cell locator coordinates
c. Hash (#)
d.Ampersand (& 101. You can zoom a worksheet
a.With the mouse pointer in Print Preview
96. Concatenation of text can be done b.With the zoom button on the Print Preview
using toolbar
a.Apostrophe (‘) c. With the Zoom command on the view
b.Exclamation (!) menu
c. Hash (#) d.All of the above
d.Ampersand (&)
9
112. When the formula bar is activated, 119. To hold row and column titles in
you can see places so that they do not scroll when
a.The Edit Formula button you scroll a worksheet, click the
b.The Cancel button a.Unfreeze panes command on the window
c. The Enter button menu
d.All of above b.Freeze panes command on the window
menu
113. In a worksheet you can press c. Hold titles command on the edit menu
Shift+Space to select entire d.Split command on the window menu
a. Worksheet
b.Row 120. Which of these is a quick way to
c. Column copy formatting from a selected cell
d.a, b, and c to two other cells on the same
worksheet?
114. when you print preview a worksheet a.Use Ctrl to select all three cells, then click
a.the entire worksheet is displayed the paste button on the standard toolbar
b.the selected range is displayed b.Copy the selected cell, then select the
c. the active portion of the worksheet is other two cells, click style on the Format
displayed menu, then click Modify
d.a, b and c c. Click format painter on the Formatting
toolbar twice then click in each cell you
IIS. You can use mcqSets.com for want to copy the formatting to
a.Online quiz d.All of above
b.MCQ Banks
c. Downloads Q. Can I download the MCQ banks in
d.Subjective Questions & answers MCQSets.com?
c. mcqSets.com has download sections
115. You can group noncontiguous d.The downloads are available as PDF files
worksheets with
a.The group button on the standard toolbar 121. To edit data in an embedded
b.The shift key and the mouse Excel worksheet object in a Word
c. The ctrl key and mouse document
d.The alt+enter key a.Use the Excel menu bar and toolbars inside
the word application
116. Weight refers to b.Edit the hyperlink
a.The print density of characters c. Edit the data in a Excel source application
b.The height of the printed character d.Use the Word menu bar and toolbars
c. Upright or slanted shape
d.The design and appearance of characters
10
137. What’s a quick way to extend
131. What term refers to a specific set these numbers to a longer sequence,
of values saved with the workbook? for instance 1 through 20?
a.Range
a.Select both cells, and then drag the fill
b.Scenario handle over the range you want, for
c. Trend line instance 18 more rows
d.What-if analysis b.Select the range you want, include both
cells, point to fill on the Edit menu, and
132. Got functions? No? You need the then click down.
insert function dialog box. How do you
c. Copy the second cell, click in the cell
get it?
below it, on the standard toolbar click the
a. Right click a cell and then click insert
down arrow on the Paste button, and then
b. Click the insert menu and then click click Paste Special
function d.All of above
c. Type = in a cell
d. All of the above Q. You can use mcqSets.com for
a.Online quiz
133. Which of the following describes how b.MCQ Banks
to select all the cells in c. Downloads
a single column?
d.Subjective Questions & answers
a.Right click on column and select Pick from
list 138. To insert three columns between
b.Use data – text to columns menu item columns D and E you would
c. Left click on the gray column title button a.Select column D
d.Pressing Ctrl + A on the keyboard b.Select column E
c. Select columns E, F and G
134. when you use the fill effects in the d.Select columns D, E, and F.
format data series dialog box, you can
not 139. To center worksheet titles across a
a.rotate text on the chart range of cell, you must
b.select a fore ground color a.Select the cells containing the title text
c. select a pattern and use the fill handle to center the text
d.select a background color across a range of cells
b.Widen the columns
135. Paper spreadsheets can have all the c. Select the cells containing the title text
same advantages as an electronic and use the fill handle to center the text
spreadsheet except which of the across a range of cells
following? d.Widen the column
a.Rows and columns
b.Headings
c. Speed
d.None
11
Q. Where can you find best quality multiple
150. When you insert an Excel file into a choice questions?
Word document, the data are a.icttrends.com
a.Hyperlinked
b.psexam.com
b.Placed in a word table
c. prepare.icttrends.com
c. Linked
d.mcqsets.com
d.Embedded
155. Which types of charts can excel
Q. Can I download the MCQ banks in produce?
MCQSets.com? a.Line graphs and pie charts only
a.Yes, do a search in mcqsets.com site
b.Only line graphs
b.Yes, some files are offered to download free
c. Bar charts, line graphs and pie charts
c. mcqSets.com has download sections
d.Bar charts and line graphs only
d.The downloads are available as PDF files
156. How are data organized in a
151. Except for the …… function, a spreadsheet?
formula with a logical function shows a.Lines and spaces
the word “TRUE” or “FALSE” as a result
b.Layers and planes
a.IF
c. Rows and columns
b.AND
d.Height and width
c. OR
d.NOT Q. How reliable are MCQs
in MCQ Sets? a. I've paid
152. Macros are “run” or executed from
utmost care in correctness
the ….. menu.
c. However, if you discover any mistakes
a.Insert
b.Frmat 157. What does the VLOOKUP function do?
c. Tools a.Looks up text that contain ‘v’
d.Data b.Checks whether text is the same in one cell
as in the next
Q. Will you answer my questions if I send
c. Finds related records
them to you?
d.All of above
a.There are some pages in MCQ Sets that
offers you the form 158. Gridlines
b.If you send me questions using the forms in a.May be turned off for display but turned on
MCQ Sets for printing
c. I will try to include your questions in the b.May be turned on or off for printing
respective series c. The be turned off for display and printing
d.Get the most authentic answers for your d.a, b and c
subjective questions
12
a.Efficiency
167. Which of the following will not set b.Auditability
text in selected cells to italics? c. Description
a.Pressing Ctrl + I on the keyboard d.Clarity
b.Using the Tools – Wizard – Web Form
Q. How reliable are MCQs in MCQ Sets?
menu item
a.I've paid utmost care in correctness
c. Using the Format – Cells – Font menu item
b.These are tested questions and answers
d.None of the above
c. However, if you discover any mistakes
168. Which of the following methods d.Mail me at contact@mcqsets.com
cannot be used to edit the content of
174. To copy cell contents using drag and
cell?
drop, press the
a.Pressing the Alt key
a.End key
b.Clicking the formula bar
b.Shift key
c. Pressing F2
c. Esc key
d.Double clicking the cell
d.None of above
169. Which of the following is not an
175. If you press …., the cell accepts your
option in the spelling dialog box?
typing as its contents.
a.Edit
a.Enter
b.Ignore
b.Ctrl + Enter
c. Ignore all
c. TAB
d.Change
d.Insert
170. You can quickly change the
176. The autofill feature
appearance of your work by choosing
a.Extends a sequential series of data
Auto Format from the …. Menu
b.Automatically adds a range of cell values
a.Edit
c. Applies a boarder around selected cells
b.View
d.None of above
c. Format
d.Tools
13
191. If you need a text to show
186. what term describes a background vertically in a cell. How will you
that appears as a grainy, non smooth achieve this?
surface a. Choose Vertical on Text alignment in
a.gradient Format Cells dialog box
b.pattern b. Choose 90 Degrees in Orientation of
c. solid Format Cells dialog box
d.texture c. Choose Distributed from the Vertical
drop down list of Format Cells dialog box
187. Excel is a d.Choose Center Across Selection from
a.Graphic program Horizontal combo box in Format Cells
b.None of these dialog box
c. Word processor
192. Can you set 0.5 inch left indentation
d.A spreadsheet
for a cell in Excel?
Q. Where can you find best quality multiple a. Excel does not have indentation feature
choice questions? b. You can specify indentation only if you turn
a.icttrends.com the rulers on
b.psexam.com c. Indentation can be set from Format Cells
c. prepare.icttrends.com dialog box
d.mcqsets.com d. The indentation can be specified only when
printing
188. To create an interactive Pivot Table
for the web, you use a Microsoft Office 193. You can automatically adjust the size
Web component called of text in a cell if they do not fit in width
a.HTML by
b.Pivot Table Field List a. Double clicking on the right border of
c. Pivot Table List column header
d.Pivot Table Report b. From Format choose Columns and then
Autofit Selection
189. Which of the following is not a c. From Format Cells dialog box mark Shrink
valid Zoom percentage in Excel? to fit check box
a. 10 d. All of above
b. 100
c. 300 lgs. You can use mcqSets.com for
d. 500 a.Online quiz
b.MCQ Banks
190. The spelling tool is placed on ______ d.Subjective Questions & answers
toolbar
a. Standard 194. Formatting a cell in Currency, you
b. Formatting can specify
c. Drawing a. Decimal Places
d. Reviewing b. Currency Symbol
c. Both of above
Q. Will you answer my questions if I send d. None of above
them to you?
a.There are some pages in MCQ Sets that
offers you the form
b.If you send me questions using the forms in
MCQ Sets
c. I will try to include your questions in the
respective series
d.Get the most authentic answers for your
subjective questions
SOO. Can I download the MCQ banks in
195. Formatting a cell in Number format MCQSets.com?
you can’t set a.Yes, do a search in mcqsets.com site
a. Decimal Places b.Yes, some files are offered to download free
b. Use 1000 separator c.The downloads are available as PDF files
c. Negative numbers 200. Pre-made sheet formats like
d. Currency Symbol Simple, Classic, Accounting, Colorful
196. What is entered by the function et can be applied from
=today() a. from Fromat >> Cells
a. The date value for the day according to b. from Format >> Autoformat
system clock c. from Table >> Autoformat
b. The time value according to system clock d. All of above
c. Today’s date as Text format 201. Which of the following format you
d. All of above can decide to apply or not in
197. Which function will you use to AutoFormat dialog box?
enter current time in a woksheet a. Number format
cell? b. Border format
a. =today() c. Font format
b. =now() d. All of above
c. =time() 202. How can you remove borders applied
d. =currentTime() in cells?
198. Special category of Number tab in a. Choose None on Border tab of Format cells
Format Cells dialog box can be used to b. Open the list on Border tool in Formatting
apply formats like toolbar then choose first tool (no border)
a. Zip Code c. Both of above
b. Phone Number d. None of above
c. Both of above 203. Where can you set the shedding
d. None of above color for a range of cells in Excel?
IGG. How reliable are MCQs in MCQ Sets? a. Choose required color form Patterns tab
of Format Cells dialog box
a.I've paid utmost care in correctness
b. Choose required color on Fill Color tool in
b.These are tested questions and answers
Formatting toolbar
c.However, if you discover any mistakes
c. Choose required color on Fill Color tool in
d.Mail me at contact@mcqsets.com
Drawing toolbar
199. Merge cells option can be applied d. All of above
from
a. Format Cells dialog box Alignment Tab 204. You can set Page Border in Excel from
a. From Border tab in Format Cells dialog box
b. Formatting toolbar
b. From Border tool in Formatting toolbar
c. Both of above
c. From Line Style tool in Drawing toolbar
d. None of above
d. You can not set page border in Excel
14
210. When a range is selected, how can
205. When all the numbers between 0 you activate the previous cell?
and 100 in a range should be displayed a.Press the Alt key
in Red Color, apply
b.Press Tab
a. Use =if() function to format the required
c. Press Enter
numbers red
d.None of above
b. Apply Conditional Formatting command on
Format menu Q. Will you answer my questions if I send
c. Select the cells that contain number them to you?
between 0 and 100 then click Red color on a.If you send me questions using the forms in
Text Color tool MCQ Sets
d. All of above b.I will try to include your questions in the
respective series
SlQ. Where can you find best quality
multiple choice questions? 211. Which tool you will use to join
a.icttrends.com some cells and place the content at
b.psexam.com the middle of joined cell?
c. prepare.icttrends.com a.From Format Cells dialog box click on
d.mcqsets.com Merge Cells check box
b.From Format Cells dialog box select the
206. You can check the conditions against
Centered alignment
__________ when applying conditional
formatting c. From Format Cells dialog box choose Merge
a. Cell value and Center check box
b. Formula d.Click on Merge and Center tool on
c. Both of above formatting toolbar
d. None of above 212. Tab scroll buttons are place on Excel
207. Which of the following is not true screen
regarding Conditional Formatting? a.towards the bottom right corner
a. You can add more than one condition to b.towards the bottom left corner
check c. towards the top right corner
b. You can set condition to look for Bold and d.towards the top left corner
apply Italics on them. 213. The Name box on to the left of
c. You can apply Font, border and pattern formula bar
formats that meets the specified a.shows the name of workbook currently
conditions
working on
d.You can delete any condition from b.shows the name of worksheet currently
Conditional Formatting dialog box if it is
not requried working on
c. shows the name of cell or range currently
208. Which of the following is invalid working on
statement? d.None of above
a. Sheet tabs can be colored
b. Some picture can be applied as a 214. Each excel file is a workbook that
background of a sheet contains different sheets. Which of the
following can not be a sheet in
c. You can set the column width automatically
workbook?
fit the amount of text
a.work sheet
d. The width of a row and be specified
b.chart sheet
manually or fit automatically
c. module sheet
209. You can use the formula pallette to d.data sheet
a.format cells containing numbers
b.create and edit formula containing
functions
c. enter assumptions data
d.copy a range of cells
d.Mail me at contact@mcqsets.com
215. Which of the following is not the
correct method of editing the cell content? 219. Where can you change automatic or
a.Press the Alt key manual calculation mode in Excel?
b.Press the F2 key a.Double CAL indicator on status bar
c.Click the formula bar b.Go to Tools >> Options >> Calculation and
d.Double click the cell mark the corresponding radio button
c.Both of above
216. You can merge the main document d.None of above
with data source in Excel. In mail merge
operation, Word is usually 220. How can you show or hide the
a.server gridlines in Excel Worksheet?
b.source a.Go to Tools >> Options >> View tab and
c.client mark or remove the check box named
d.none Gridline
b.Click Gridline tool on Forms toolbar
Q. Can I download the MCQ banks in c.Both of above
MCQSets.com? d.None of above
a.Yes, do a search in mcqsets.com site
b.Yes, some files are offered to download free 221. Which of the following Excel screen
c.mcqSets.com has download sections components can NOT be turned on or
d.The downloads are available as PDF files off?
a.Formula Bar
217. How can you update the values b.Status Bar
of formula cells if Auto Calculate c.Tool Bar
mode of Excel is disabled? d.None of above
a.F8
b.F9 222. What happens when you press Ctrl
c.F10 + X after selecting some cells in Excel?
d.F11 a.The cell content of selected cells disappear
from cell and stored in clipboard
218. You want to set such that when you b.The cells selected are marked for cutting
type Baishakh and drag the fill handle, c.The selected cells are deleted and the cells
Excel should produce Jestha, Aashadh and are shifted left
so on. What will you set to effect that? d.The selected cells are deleted and cells are
a.Custom List shifted up
b.Auto Fill Options
c.Fill Across Worksheet 223. Which of the following option is not
d.Fill Series available in Paste Special dialog box?
a.Add
Q. How reliable are MCQs in MCQ Sets? b.Subtract
a.I've paid utmost care in correctness c.Divide
b.These are tested questions and answers d.SQRT
c.However, if you discover any mistakes
15
a.Wrap Text in Format >> Cells
224. Which command will you choose to
b.Justify in Edit >> Cells
convert a column of data into row?
c. Text Wrapping in Format >> Cells, Layout
a.Cut and Paste
tab
b.Edit >> Paste Special >> Transpose
d.All of above
c. Both of above
d.None of above 231. MS Excel provides the default
value for step in Fill Series dialog
225. It is acceptable to let long text flow
box
into adjacent cells on a worksheet
a.0
when
b.1
a.data will be entered in the adjecent cells
c. 5
b.no data will be entered in the adjacent cells
d.10
c. there is no suitable abbrevition for the text
d.there is not time to format the text Q. How reliable are MCQs in MCQ Sets?
a.I've paid utmost care in correctness
226. Which of the cell pointer indicates
b.These are tested questions and answers
you that you can make selection?
c. However, if you discover any mistakes
a.Doctor’s symbol (Big Plus)
d.Mail me at contact@mcqsets.com
b.small thin plus icon
c. Mouse Pointer with anchor at the tip 232. When a row of data is to be
d.None of above converted into columns
a.Copy the cells in row, select the same
227. Which of the cell pointer indicates number of cells in row and paste
that you can fill series?
b.Copy the cells in column then choose Edit
a.Doctor’s symbol (Big Plus) >> Paste Special, then click Transpose and
b.small thin plus icon OK
c. Mouse Pointer with anchor at the tip c. Copy the cells then go to Format >> Cells
d.None of above then on Alignment tab click Transpose
check box and click OK
Q. You can use mcqSets.com for
d.Select the cells then place the cell pointer
a.Online quiz
on new cell and choose Edit >> Paste
b.MCQ Banks Special, mark Transpose check box and
c. Downloads click OK.
d.Subjective Questions & answers
MCQ Sets ( ) presents collection of
228. Which of the cell pointer indicate MCQ Questions for you to
that you can move the content to prepare your exam.
other cell?
a.Doctor’s symbol (Big Plus)
b.small thin plus icon
c. Mouse Pointer with anchor at the tip
d.None of above
16
b.You can decide whether to look for the
242. If you need to remove only the
whole word or not
formatting done in a range (numbers
c. You can search in formula too
and formula typed there should not be
d.You can search by rows or columns or
removed), you must
a.From Edit menu choose Clear and then sheets
Formats 247. You can move a sheet from one
b.From Edit menu choose Delete workbook into new book by
c. Click on Remove Formatting tool on a.From Edit menu choose Move or Copy
Standard Toolbar sheet, mark the Create a ccopy and Click
d.Double click the Format Painter and OK
then press Esc key in keyboard b.From Edit menu choose Move of Copy then
choose (Move to end) and click OK
243. By default Excel provides 3
c. From Edit menu choose Move or Copy
worksheets. You need only two of them, then select (new book) from To Book list
how will you delete the third one? and click OK
a.Right click on Sheet Tab of third sheet and d.None of above
choose Delete from the context menu
b.Click on Sheet 3 and from Edit menu choose Q. You can use mcqSets.com for
Delete a.Online quiz
c. Both of above b.MCQ Banks
d.None of above c. Downloads
d.Subjective Questions & answers
244. Which of the following action
removes a sheet from workbook? 248. What is the short cut key to replace
a.Select the sheet, then choose Edit >> Delete a data with another in sheet?
Sheet a.Ctrl + R
b.Select the sheet then choose Format >> b.Ctrl + Shift + R
Sheet >> Hide c. Ctrl + H
c. Both of above d.Ctrl + F
d.None of above
249. Comments put in cells are called …..
Q. Will you answer my questions if I send a. Smart Tip
them to you? b. Cell Tip
a.There are some pages in MCQ Sets that c. Web Tip
offers you the form d. Soft Tip
b.If you send me questions using the forms in
MCQ Sets 250. Comments can be added to cells using
c. I will try to include your questions in the …..
respective series a. Edit -> Comments
d.Get the most authentic answers for your b. Insert -> Comment
subjective questions c. File -> Comments
d. View –> Comments
245. While Finding and Replacing some
data in Excel, which of the following
statement is valid?
a.You can Find and Replace within the sheet
or workbook
b.Excel does not have option to match case
for find
c. Both are valid
d.None are valid
274. What does COUNTA () function do? Q. Where can you find best quality multiple
a. counts cells having alphabets choice questions?
b. counts empty cells a.psexam.com
c. counts cells having number b.mcqsets.com
d. counts non-empty cells 279. Which language is used to create
275. What is the short cut key to highlight macros in Excel?
the entire column? a. Visual Basic
a. Ctrl+C b. C
b. Ctrl+Enter c. Visual C++
c. Ctrl+Page Up d. Java
d. Ctrl+Space Bar 280. Which of the following is not a term
276. In the formula, which symbol of MS-Excel?
specifies the fixed columns or rows? a. Cells
a. $ b. Rows
b. * c. Columns
c. % d. Document
18
d. Macro Recorder
281. How many worksheets can a 288. We can save and protect the
workbook have? workbook by
a. 3
a. Write Reservation Password
b. 8
b. Protection Password
c. 255
c. Read-only Recommended
d. none of above
d. Any of the above
282. Which would you choose to create a
289. The first cell in EXCEL worksheet is
bar diagram?
labeled as
a. Edit, Chart
a. AA
b. Insert, Chart
b. A1
c. Tools, Chart
c. Aa
d. Format, Chart
d. A0
283. Which setting you must modify to
290. What happens when dollar signs
print a worksheet using letterhead?
($) are entered in a cell address?
a. Paper
(e$B$2:$B$10)
b. Margin
a. An absolute cell address is created.
c. Layout b. Cell address will change when it is
d. Orientation copied to another cell.
Q. How reliable are MCQs in MCQ Sets? c. The sheet tab is changed.
a.I've paid utmost care in correctness d. The status bar does not display the cell
b.These are tested questions and answers address.
c. However, if you discover any mistakes
291. What are the tabs that appear
d.Mail me at contact@mcqsets.com at the bottom of each workbook
284. What do you call the chart that shows called?
the proportions of how one or more data a. Reference tabs
elements relate to another data element? b. Position tabs
a. XY Chart c. Location tabs
b. Line Chart d. Sheet tabs
c. Pie Chart
d. Column Chart
19
307. In order to arrange the countries
Q. How reliable are MCQs in MCQ Sets? from those with the highest population
a.I've paid utmost care in correctness to those with the lowest, you need to sort
b.These are tested questions and answers on the population field in ……………
c. However, if you discover any mistakes a. ascending order
d.Mail me at contact@mcqsets.com b. descending order
303. In a report, you need to show the c. alphabetical order
monthly rainfall in NepaThe best way to d. random order
do this is to insert a 308. In order to perform a calculation in
a. calendar a spreadsheet, you need to use a:
b. photograph of rainfall a. table
c. chart showing rainfall amounts b. formula
d. database of rainfall c. field
Q. Can I download the MCQ banks in d. variable
MCQSets.com? 309. The box on the chart that
a.Yes, do a search in mcqsets.com site contains the name of each
b.Yes, some files are offered to download free individual record is called the
c. mcqSets.com has download sections ________.
d.The downloads are available as PDF files a. cell
b. title
304. You want to record experiment
information and create a chart that c. axis
shows the rate of crystal growth over a d. legend
period of timThe best application to 310. If you want all of the white cats
use would be: grouped together in the database,
a. word processing you need to sort by ________.
b. spreadsheet a. Color, then Gender
c. database b. Pet Type, then Color
d. graphics c. Pet Type, then Gender
305. You are editing an worksheet that d. Color, then Pet Name
you had previously saveIf you want to
save the edited sheet without losing the
original one, which command should
you use?
a. New
b. Save As
c. Edit
d. Save
20
Q. You can use mcqSets.com for
321. Formulas in Excel start with a.Online quiz
a. % b.MCQ Banks
b. = c. Downloads
c. + d.Subjective Questions & answers
d. - 328. You can group noncontiguous
322. The default header for a worksheet is worksheets with
a. Username a. The alt+enter key
b. Date and Time b. The ctrl key and mouse
c. Sheet tab Name c. The shift key and the mouse
d. None d. The group button on the standard
toolbar
323. Which of the following is not an
option of the spelling dialog box? 329. What is the AutoComplete feature of
a. Ignore Excel?
b. Ignore all a. It automatically completes abbreviated
c. Edit words
d. Change b.It completes text entries that match an
existing entry in the same column
324. Which of the following methods will c. It completes text and numeric entries that
not enter data in a cell? match an existing entry in the same
a. Pressing the Esc key column
b. Pressing an arrow key d.It completes text entries that match an
c. Pressing the tab key existing entry in the same worksheet
d. Clicking the enter button to the formula
330. Which of the following is correct?
bar
a. =AVERAGE(4, 5, 6, 7)
325. The cell reference for cell range of G2 b. =AVERAGE(A1, B1, C1)
to M12 is _______ c. =AVERAGE(A1:A9, B1:B9)
a. G2.M12 d. =All of the above
b. G2;M12
c. G2:M12
d. G2-M12
21
341. How to specify cell range from A9 to 351. Selecting the Rows 5 & 6 then
A99 in Excel? choose Insert->RoWhat will happen?
a. (A9, A99) a. 2 Rows will be inserted after Row 4
b. (A9 to A99) b. 2 Rows will be inserted after Row 5
c. (A9 : A99) c. 2 Rows will be inserted after Row 6
d. (A9 – A99) d. 2 Rows will be inserted after Row 7
Q. Where can you find best quality multiple Q. How reliable are MCQs in MCQ Sets?
choice questions? a.These are tested questions and answers
a.icttrends.com b.However, if you discover any mistakes
b.psexam.com c.Mail me at contact@mcqsets.com
c. prepare.icttrends.com
d.mcqsets.com 352. If 4/6 entered in a cell without
applying any formats, Excel will treat
342. Selecting the Column G & H then this as
choose Insert->Column, What will a. Fraction
happen? b. Number
a. 2 Columns will be inserted after Column F c. Text
b. 2 Columns will be inserted after Column G d. Date
c. 2 Columns will be inserted after Column H
d. 2 Columns will be inserted after Column I
d.Click on the rectangle box on the upper
343. How to restrict the values of a cell so left corner where column headings and
that only whole numbers between 9 and row headings meet
99 can be entered in a cell.
a. The Settings tab under the menu Format Q. Can I download the MCQ banks in
-> Cells MCQSets.com?
b. The Settings tab under the menu Data -> b.Yes, some files are offered to download free
Validation c. mcqSets.com has download sections
c. The Settings tab under the menu Data -> d.The downloads are available as PDF files
Filter -> Advanced Filter 347. A smart tag will be removed from a
d. the Settings tab under the menu Format cell when
-> Conditional Formatting a. the cell is moved
344. Clear the contents by pressing b. the cell is hidden
“DELETE” key from a keyboard will clear c. the data in the cell is changed or deleted
a. Text Only d. the formatting of the cell is changed
b. Format Only 348. Which of the following options is
c. Contents Only appropriate to show the numbers
d. Both Contents and Format 9779851089510 in a cell?
345. Which of the following shortcuts can a. Enclose the number is brackets
be used to insert a new line in the same b. Place the character T before the number
cell? c. Place the character TX before the number
a. Enter d. Apply the Text format in the cell and type
b. Alt + Enter the numbers
c. Ctrl + Enter 349. Which of the following is correct
d. Shift + Enter syntax in Excel?
346. What is the quickest way to select a. =IF(LogicalTest, TrueResult, FalseResult)
entire worksheet? b. =IF(LogicalTest, (TrueResult, FalseResult))
a. Choose Edit -> Select all from the Menu c. =IF(LogicalTest, TrueResult) (LogicalTest,
b.Click on the first column, press Ctrl, and FalseResult)
then click on the last column d. =IF(LogicalTest, TrueResult),
c. Click on the first column, press Shift, and IF(LogicalTest, FalseResult)
then click on the last column
350. Which of the following is correct?
a. =POWER(2^3)
b. =POWER(2,3) 353. If the values in A1 is “MCQ” and
c. =POWER(2#3) B1 is “Questions”, which function will
return “MCQ@Questions” in cell C1?
d. =POWER(2*3)
a. =A1 + “@” + B1
b. =A1 # “@” # B1
c. =A1 & “@” & B1
d. =A1 $ “@” $ B1
22
362. Which one is the last column Q. You can use mcqSets.com for
header in Excel 2007? a.Online quiz
a. XFD b.MCQ Banks
b. XFX c.Downloads
c. XFL d.Subjective Questions & answers
d. XFT
366. To show/hide the grid lines in
Q. Where can you find best quality Microsoft Excel 2007
multiple choice questions? a. Page Layout -> Grid lines -> View
a.icttrends.com b. Insert -> Grid lines -> View
b.psexam.com c. View -> Grid lines -> View
c. prepare.icttrends.com d. Edit -> Grid lines -> View
d.mcqsets.com
Q. How to download files from MCQ Sets?
363. In maximum, how many sheets can a.Find the respective page in the site
be set as default while creating new mcqSets.com
workbook? b.Find the download link in that page
a. 254 c.Right click the link and choose Save Target
b. 255 as
c. 256 d.Choose the save location in your computer.
d. No Limit
367. What will be the result if you type
Q. Will you answer my questions if I send =A1=B1 in cell C1?
them to you? a. Yes or No
a.There are some pages in MCQ Sets that b. True or False
offers you the form c. Value of A1
b.If you send me questions using the forms d. Value of B1
in MCQ Sets
c. I will try to include your questions in the 368. In Excel _______ may not contain in
respective series Formula
d.Get the most authentic answers for your a. Text Constant
subjective questions b. Number Constant
c. Circular Reference
364. “New Comment” option can be d. All of them
found under _________ tab
a. Insert Q. Can I download the MCQ banks in
b. Data MCQSets.com?
c. Review a.Yes, do a search in mcqsets.com site
d. View b.Yes, some files are offered to download
free
365. In Excel, by default Numeric Values c.mcqSets.com has download sections
appears in d.The downloads are available as PDF files
a. Left aligned
b. Right aligned
c. Center aligned
d. Justify aligned
Answers
1-c 2-a 3-d 4-d 5-c 6-a 7-d 8-b 9-b 10 - a
11 - a 12 - d 13 - d 14 - d 15 - b 16 - b 17 - b 18 - d 19 - b 20 - b
21 - d 22 - d 23 - a 24 - d 25 - d 26 - b 27 - b 28 - c 29 - b 30 - a
31 - d 32 - c 33 - a 34 - a 35 - d 36 - d 37 - d 38 - d 39 - a 40 - b
41 - b 42 - b 43 - c 44 - d 45 - b 46 - a 47 - c 48 - b 49 - a 50 - c
51 - d 52 - d 53 - c 54 - b 55 - c 56 - a 57 - c 58 - a 59 - a 60 - b
61 - c 62 - a 63 - a 64 - b 65 - d 66 - d 67 - d 68 - b 69 - b 70 - c
71 - d 72 - c 73 - d 74 - b 75 - c 76 - c 77 - d 78 - b 79 - d 80 - c
81 - b 82 - d 83 - a 84 - d 85 - a 86 - b 87 - d 88 - d 89 - d 90 - b
91 - b 92 - c 93 - b 94 - d 95 - a 96 - d 97 - d 98 - a 99 - b 100 - c
101 - d 102 - d 103 - c 104 - d 105 - b 106 - d 107 - b 108 - c 109 - b 110 - c
111 - d 112 - d 113 - d 114 - d 115 - c 116 - a 117 - b 118 - b 119 - b 120 - c
121 - a 122 - c 123 - d 124 - d 125 - d 126 - b 127 - a 128 - d 129 - d 130 - a
131 - b 132 - b 133 - c 134 - a 135 - c 136 - d 137 - a 138 - c 139 - c 140 - c
141 - d 142 - b 143 - b 144 - d 145 - d 146 - b 147 - a 148 - d 149 - c 150 - b
151 - a 152 - c 153 - d 154 - c 155 - c 156 - c 157 - c 158 - d 159 - d 160 - d
161 - a 162 - b 163 - b 164 - a 165 - a 166 - c 167 - b 168 - a 169 - a 170 - c
171 - c 172 - d 173 - c 174 - d 175 - a 176 - a 177 - d 178 - b 179 - c 180 - a
181 - c 182 - b 183 - d 184 - b 185 - d 186 - a 187 - d 188 - d 189 - d 190 - a
191 - b 192 - c 193 - c 194 - c 195 - d 196 - a 197 - b 198 - c 199 - a 200 - b
201 - d 202 - c 203 - d 204 - d 205 - b 206 - c 207 - b 208 - d 209 - b 210 - d
211 - d 212 - b 213 - c 214 - d 215 - a 216 - c 217 - b 218 - a 219 - b 220 - c
221 - d 222 - b 223 - d 224 - b 225 - b 226 - a 227 - b 228 - c 229 - c 230 - a
231 - b 232 - d 233 - c 234 - c 235 - b 236 - d 237 - d 238 - d 239 - d 240 - b
241 - a 242 - a 243 - a 244 - a 245 - a 246 - d 247 - c 248 - c 249 - b 250 - b
251 - c 252 - b 253 - b 254 - d 255 - a 256 - d 257 - c 258 - b 259 - d 260 - d
261 - a 262 - c 263 - d 264 - c 265 - a 266 - c 267 - b 268 - a 269 - d 270 - b
271 - c 272 - b 273 - d 274 - d 275 - d 276 - a 277 - c 278 - a 279 - a 280 - d
281 - d 282 - b 283 - b 284 - c 285 - c 286 - c 287 - d 288 - d 289 - b 290 - a
291 - d 292 - b 293 - c 294 - d 295 - d 296 - b 297 - d 298 - d 299 - b 300 - b
301 - d 302 - a 303 - c 304 - b 305 - b 306 - b 307 - b 308 - b 309 - d 310 - b
311 - c 312 - a 313 - c 314 - d 315 - a 316 - c 317 - d 318 - a 319 - a 320 - d
321 - b 322 - d 323 - c 324 - a 325 - c 326 - d 327 - c 328 - b 329 - b 330 - d
331 - d 332 - a 333 - c 334 - d 335 - a 336 - d 337 - b 338 - c 339 - d 340 - b
341 - c 342 - a 343 - b 344 - c 345 - b 346 - d 347 - c 348 - d 349 - a 350 - b
351 - a 352 - d 353 - c 354 - b 355 - d 356 - b 357 - c 358 - c 359 - d 360 - b
361 - d 362 - a 363 - b 364 - c 365 - b 366 - a 367 - b 368 - c