201.

Which of the following format you can

decide to apply or not in AutoFormat dialog
box? 206. You can check the conditions against
a. Number format __________ when applying conditional
b. Border format formatting
c. Font format a. Cell value
d. All of above b. Formula
c. Both of above
d. None of above

202. How can you remove borders applied in

cells?
a. Choose None on Border tab of Format cells 207. Which of the following is not true
b. Open the list on Border tool in Formatting regarding Conditional Formatting?
toolbar then choose first tool (no border) a. You can add more than one condition to check
c. Both of above b. You can set condition to look for Bold and
d. None of above apply Italics on them.
c. You can apply Font, border and pattern formats
that meets the specified conditions
d. You can delete any condition from Conditional
203. Where can you set the shedding color for a Formatting dialog box if it is not requried
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 208. Which of the following is invalid
Formatting toolbar statement?
c. Choose required color on Fill Color tool in a. Sheet tabs can be colored
Drawing toolbar b. Some picture can be applied as a background of
d. All of above 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
204. You can set Page Border in Excel from or fit automatically
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 209. You can use the formula pallette to
a. format cells containing numbers
b. create and edit formula containing functions
c. enter assumptions data
205. When all the numbers between 0 and 100 d. copy a range of cells
in a range should be displayed in Red Color,
apply
a. Use =if() function to format the required
numbers red 210. When a range is selected, how can you
b. Apply Conditional Formatting command on activate the previous cell?
Format menu a. Press the Alt key
c. Select the cells that contain number between 0 b. Press Tab
and 100 then click Red color on Text Color tool c. Press Enter
d. All of above d. None of above
211. Which tool you will use to join some cells
and place the content at the middle of joined
cell? 216. You can merge the main document with
a. From Format Cells dialog box click on Merge data source in Excel. In mail merge operation,
Cells check box Word is usually
b. From Format Cells dialog box select the a. server
Centered alignment b. source
c. From Format Cells dialog box choose Merge c. client
and Center check box d. none
d. Click on Merge and Center tool on formatting
toolbar

217. How can you update the values of formula

cells if Auto Calculate mode of Excel is
212. Tab scroll buttons are place on Excel disabled?
screen a. F8
a. towards the bottom right corner b. F9
b. towards the bottom left corner c. F10
c. towards the top right corner d. F11
d. towards the top left corner

218. You want to set such that when you type

213. The Name box on to the left of formula bar Baishakh and drag the fill handle, Excel should
a. shows the name of workbook currently produce Jestha, Aashadh and so on. What will
working on you set to effect that?
b. shows the name of worksheet currently a. Custom List
working on b. Auto Fill Options
c. shows the name of cell or range currently c. Fill Across Worksheet
working on d. Fill Series
d. None of above

219. Where can you change automatic or

214. Each excel file is a workbook that contains manual calculation mode in Excel?
different sheets. Which of the following can not a. Double CAL indicator on status bar
be a sheet in workbook? b. Go to Tools >> Options >> Calculation and
a. work sheet mark the corresponding radio button
b. chart sheet c. Both of above
c. module sheet d. None of above
d. data sheet

220. How can you show or hide the gridlines in

215. Which of the following is not the correct Excel Worksheet?
method of editing the cell content? a. Go to Tools >> Options >> View tab and mark
a. Press the Alt key or remove the check box named Gridline
b. Press the F2 key b. Click Gridline tool on Forms toolbar
c. Click the formula bar c. Both of above
d. Double click the cell d. None of above
 226. Which of the cell pointer indicates you that
you can make selection?
221. Which of the following Excel screen
components can NOT be turned on or off? a. Doctor’s symbol (Big Plus)
a. Formula Bar b. small thin plus icon
b. Status Bar c. Mouse Pointer with anchor at the tip
c. Tool Bar d. None of above
d. None of above

227. Which of the cell pointer indicates that you

222. What happens when you press Ctrl + X can fill series?
after selecting some cells in Excel?
a. The cell content of selected cells disappear a. Doctor’s symbol (Big Plus)
from cell and stored in clipboard b. small thin plus icon
b. The cells selected are marked for cutting c. Mouse Pointer with anchor at the tip
c. The selected cells are deleted and the cells are d. None of above
shifted left
d. The selected cells are deleted and cells are
shifted up
228. Which of the cell pointer indicate that you
can move the content to other cell?

223. Which of the following option is not a. Doctor’s symbol (Big Plus)
available in Paste Special dialog box? b. small thin plus icon
a. Add c. Mouse Pointer with anchor at the tip
b. Subtract d. None of above
c. Divide
d. SQRT

229. You can auto fit the width of column by

224. Which command will you choose to a. double clicking on the column name on column
convert a column of data into row? header
a. Cut and Paste b. Double click on the cell pointer in worksheet
b. Edit >> Paste Special >> Transpose c. Double clicking on column right border on
c. Both of above column header
d. None of above d. Double clicking on the column left border of
column header

225. It is acceptable to let long text flow into

adjacent cells on a worksheet when 230. Long text can be broken down into many
a. data will be entered in the adjecent cells lines within a cell. You can do this through
b. no data will be entered in the adjacent cells
c. there is no suitable abbrevition for the text a. Wrap Text in Format >> Cells
d. there is not time to format the text b. Justify in Edit >> Cells
c. Text Wraping in Format >> Cells, Layout tab
d. All of above
231. MS Excel provides the default value for c. When no sheet is selected
step in Fill Series dialog box d. None of above

a. 0
b. 1
c. 5 236. Which of the following series type is not
d. 10 valid for Fill Series dialog box?

a. Linear
b. Growth
232. When a row of data is to be converted into c. Autofill
columns d. Time

a. Copy the cells in row, select the same number

of cells in row and paste
b. Copy the cells in column then choose Edit >> 237. Which of the following you can paste
Paste Special, then click Transpose and OK selectively using Paste Special command?
c. Copy the cells then go to Format >> Cells then
on Alignment tab click Transpose check box and a. Validation
click OK b. Formats
d. Select the cells then place the cell pointer on c. Formulas
new cell and choose Edit >> Paste Special, mark d. All of above
Transpose check box and click OK.

238. Paste Special allows some operation while

233. Ctrl + D shortcut key in Excel will you paste to new cell. Which of the following
operation is valid?
a. Open the font dialog box
b. Apply double underline for the active cell a. Square
c. Fill down in the selection b. Percentage
d. None of above c. Goal Seek
d. Divide

234. The short cut key Ctrl + R is used in Excel

to 239. Edit >> Delete command

a. Right align the content of cell a. Deletes the content of a cell

b. Remove the cell contents of selected cells b. Deletes Formats of cell
c. Fill the selection with active cells to the right c. Deletes the comment of cell
d. None of above d. Deletes selected cells

235. The command Edit >> Fill Across 240. To remove the content of selected cells you
Worksheet is active only when must issue ______ command

a. One sheet is selected a. Edit >> Delete

b. When many sheets are selected b. Edit >> Clear >> Contents
c. Edit >> Clear >> All
d. Data >> Delete
245. While Finding and Replacing some data in
Excel, which of the following statement is
valid?
241. The Delete key of keyboard is assigned to
which command in Excel? a. You can Find and Replace within the sheet or
workbook
a. Edit >> Clear >> Contents b. Excel does not have option to match case for
b. Edit >> Clear >> All find
c. Edit >> Delete c. Both are valid
d. All of above d. None are valid

242. If you need to remove only the formatting 246. Which of the following is not true about
done in a range (numbers and formula typed Find and Replace in Excel
there should not be removed), you must
a. You can search for bold and replace with italics
a. From Edit menu choose Clear and then Formats b. You can decide whether to look for the whole
b. From Edit menu choose Delete word or not
c. Click on Remove Formatting tool on Standard c. You can search in formula too
Toolbar d. You can search by rows or columns or sheets
d. Double click the Format Painter and then press
Esc key in keyboard

247. You can move a sheet from one workbook

into new book by
243. By default Excel provides 3 worksheets.
You need only two of them, how will you delete a. From Edit menu choose Move or Copy sheet,
the third one? mark the Create a ccopy and Click OK
b. From Edit menu choose Move of Copy then
a. Right click on Sheet Tab of third sheet and choose (Move to end) and click OK
choose Delete from the context menu c. From Edit menu choose Move or Copy then
b. Click on Sheet 3 and from Edit menu choose select (new book) from To Book list and click OK
Delete d. None of above
c. Both of above
d. None of above

248. What is the short cut key to replace a data

with another in sheet?
244. Which of the following action removes a
sheet from workbook? a. Ctrl + R
b. Ctrl + Shift + R
a. Select the sheet, then choose Edit >> Delete c. Ctrl + H
Sheet d. Ctrl + F
b. Select the sheet then choose Format >> Sheet
>> Hide
c. Both of above
d. None of above 249. Comments put in cells are called …..
a. Smart Tip a. Contents
b. Cell Tip b. Objects
c. Web Tip c. Scenarios
d. Soft Tip d. All of the above

250. Comments can be added to cells using ….. 255. A numeric value can be treated as label
value if …… precedes it.
a. Edit -> Comments
b. Insert -> Comment a. Apostrophe (‘)
c. File -> Comments b. Exclamation (!)
d. View –> Comments c. Hash (#)
d. Tilde (~)

251. Which menu option can be used to split

windows into two? 256. Concatenation of text can be done using

a. Format -> Window a. Apostrophe (‘)

b. View -> Window-> Split b. Exclamation (!)
c. Window -> Split c. Hash (#)
d. View –> Split d. Ampersand (&)

252. Getting data from a cell located in a 257. Which area in an Excel window allows
different sheet is called…. entering values and formulas?

a. Accessing a. Title Bar

b. Referencing b. Menu Bar
c. Updating c. Formula Bar
d. Functioning d. Standard Tool Bar

253. Which of the following is not a valid data 258. Multiple calculations can be made in a
type in Excel? single formula using…..

a. Number a. Standard Formulas

b. Character b. Array Formula
c. Label c. Complex Formulas
d. Date/Time d. Smart Formula

254. Which elements of a worksheet can be 259. An Excel Workbook is a collection of …….
protected from accidental modification?
a. Workbooks
b. Worksheets
c. Charts c. MOD ( )
d. Worksheets and Charts d. DIV ( )

260. What do you mean by a Workspace? 265. Which function is not available in the
Consolidate dialog box?
a. Group of Columns
b. Group of Worksheets a. Pmt
c. Group of Rows b. Average
d. Group of Workbooks c. Max
d. Sum

261. MS-EXCEL is based on ……….?

266. Which is not the function of “Edit, Clear”
a. WINDOWS command?
b. DOS
c. UNIX a. Delete contents
d. OS/2 b. Delete notes
c. Delete cells
d. Delete formats

262. In EXCEL, you can sum a large range of

data by simply selecting a tool button called
…..? 267. Microsoft Excel is a powerful………..

a. AutoFill a. Word processing package

b. Auto correct b. Spreadsheet package
c. Auto sum c. Communication S/W Package
d. Auto format d. DBMS package

263. To select an entire column in MS-EXCEL, 268. How do you rearrange the data in
press? ascending or descending order?

a. CTRL + C a. Data, Sort

b. CTRL + Arrow key b. Data, Form
c. CTRL + S c. Data, Table
d. None of the above d. Data Subtotals

264. To return the remainder after a number is 269. Which Chart can be created in Excel?
divided by a divisor in EXCEL we use the
function? a. Area
b. Line
a. ROUND ( ) c. Pie
b. FACT ( ) d. All of the above
 275. What is the short cut key to highlight the
entire column?
270. What will be the output if you format the
cell containing 5436.8 as ‘#,##0.00′? a. Ctrl+C
b. Ctrl+Enter
a. 5430 c. Ctrl+Page Up
b. 5436.8 d. Ctrl+Space Bar
c. 5436.8
d. 6.8

276. In the formula, which symbol specifies the

fixed columns or rows?
271. How do you display current date and time
in MS Excel? a. $
b. *
a. date () c. %
b. Today () d. &
c. now ()
d. time ()

277. Excel displays the current cell address in

the ……….
272. How do you display current date only in
MS Excel? a. Formula bar
b. Status Bar
a. date () c. Name Box
b. Today () d. Title Bar
c. now ()
d. time ()

278. What is the correct way to refer the cell

A10 on sheet3 from sheet1?
273. How do you wrap the text in a cell?
a. sheet3!A10
a. Format, cells, font b. sheet1!A10
b. Format, cells, protection c. Sheet3.A10
c. format, cells, number d. A10
d. Format, cells, alignment

279. Which language is used to create macros

274. What does COUNTA () function do? in Excel?

a. counts cells having alphabets a. Visual Basic

b. counts empty cells b. C
c. counts cells having number c. Visual C++
d. counts non-empty cells d. Java
280. Which of the following is not a term of 285. The spelling dialog box can be involved by
MS-Excel? choosing spelling from ________ menu.

a. Cells a. insert
b. Rows b. file
c. Columns c. tools
d. Document d. view

281. How many worksheets can a workbook 286. Which key do you press to check spelling?
have?
a. F3
a. 3 b. F5
b. 8 c. F7
c. 255 d. F9
d. none of above

287. To record a sequence of keystrokes and

282. Which would you choose to create a bar mouse actions to play back later we use:
diagram?
a. Media player
a. Edit, Chart b. Sound Recorder
b. Insert, Chart c. Calculator
c. Tools, Chart d. Macro Recorder
d. Format, Chart

288. We can save and protect the workbook by

283. Which setting you must modify to print a
worksheet using letterhead? a. Write Reservation Password
b. Protection Password
a. Paper c. Read-only Recommended
b. Margin d. Any of the above
c. Layout
d. Orientation

289. The first cell in EXCEL worksheet is

labeled as
284. What do you call the chart that shows the
proportions of how one or more data elements a. AA
relate to another data element? b. A1
c. Aa
a. XY Chart d. A0
b. Line Chart
c. Pie Chart
d. Column Chart
290. What happens when dollar signs ($) are
entered in a cell address? (e$B$2:$B$10)
a. An absolute cell address is created. a. Contents tab
b. Cell address will change when it is copied to b. Answer Wizard tab
another cell. c. Index tab
c. The sheet tab is changed. d. all of the above.
d. The status bar does not display the cell address.

296. A __________ is a grid with labeled

291. What are the tabs that appear at the columns and rows.
bottom of each workbook called?
a. Dialog box
a. Reference tabs b. Worksheet
b. Position tabs c. Clipboard
c. Location tabs d. Toolbar
d. Sheet tabs

297. The active cell:

292. What is represented by the small, black
square in the lower-right corner of an active a. is defined by a bold border around the cell.
cell or range? b. Receives the data the user enters.
c. It is the formula bar.
a. Copy handle d. Only A and B.
b. Fill handle
c. Insert handle
d. Border
298. Which function is used to calculate
depreciation, rates of return, future values and
loan payment amounts?
293. In Excel, a Data Series is defined as what?
a. Logical
a. A type of chart. b. Math & Trigonometry
b. A cell reference. c. Statistical
c. A collection of related data d. Financial
d. A division of results

299. B7:B9 indicates:

294. In Excel, the Fill Color button on the
Formatting toolbar is used for what? a. Cells B7 and cell B9 only.
b. Cells B7 through B9.
a. To insert a background. c. Cell B8 only.
b. To add borders. d. None of the above.
c. To select a distribution of figures.
d. To add shading or color to a cell range.

300. The Cancel and Enter buttons appear in

the:
295. In help menu of Excel, which of the
following tabs are found?
a. Title bar a. New
b. Formula bar b. Save As
c. Menu bar c. Edit
d. Sheet tabs d. Save

301. MS-EXCEL can be used to automate

306. If you want to have a blank line after the
a. Financial statements, Business forecasting title in a worksheet, what is the best thing for
b. Transaction registers, inventory control you to do?
c. Accounts receivable, accounts payable
d. Any of the above a. Re-format the spreadsheet
b. Insert a row
c. Increase the column width
302. NOT, AND, OR and XOR are d. Use the spacebar

a. Logical Operators
b. Arithmetic operators 307. In order to arrange the countries from
c. Relational operators those with the highest population to those with
d. None of the above the lowest, you need to sort on the population
field in ……………

303. In a report, you need to show the monthly a. ascending order

rainfall in NepaThe best way to do this is to b. descending order
insert a c. alphabetical order
d. random order
a. calendar
b. photograph of rainfall
c. chart showing rainfall amounts 308. In order to perform a calculation in a
d. database of rainfall spreadsheet, you need to use a:

a. table
304. You want to record experiment b. formula
information and create a chart that shows the c. field
rate of crystal growth over a period of timThe d. variable
best application to use would be:

a. word processing 309. The box on the chart that contains the
b. spreadsheet name of each individual record is called the
c. database ________.
d. graphics
a. cell
b. title
305. You are editing an worksheet that you had c. axis
previously saveIf you want to save the edited d. legend
sheet without losing the original one, which
command should you use?
310. If you want all of the white cats grouped a. =A1+A2
together in the database, you need to sort by b. =add(A1:A2)
________. c. A1+A2
d. SUM(A1:A2)
a. Color, then Gender
b. Pet Type, then Color
c. Pet Type, then Gender 316. Which is an example of a function?
d. Color, then Pet Name
a. =add(A1:A2)
b. =A1+A2
311. You accidentally erased a record in the c. =SUM(A1:A2)
sheeWhat command can be used to restore it d. A1+A2
immediately?

a. Insert 317. What is the symbol for multiplying?

b. Copy
c. Undo a. >
d. Replace b. /
c. !
d. *
312. Where a row and a column meet, what do
you call that?
318. What is the symbol for dividing?
a. A cell
b. A block a. A ./
c. A box b. %
d. None of the above c. &
d. #

313. How do you tell one cell from another?

319. A function inside another function is called
a. By numbers _______
b. By letters
c. By its address a. Nested function
d. by color b. Round function
c. Sum function
d. Text function
314. Give me an example of a cell address.

a. 11 25 320. Which of the following is not an underline

b. 911 option in the format cells dialog box?
c. 41A
d. A21 a. Double
b. Single Accounting
c. Double Accounting
315. Which is an example of a formula? d. Single Engineering
321. Formulas in Excel start with c. F8
d. F11
a. %
b. =
c. + 327. The Software which contains rows and
d. – columns is called ______

a. Database
322. The default header for a worksheet is b. Drawing
c. Spreadsheet
a. Username d. Word processing
b. Date and Time
c. Sheet tab Name
d. None 328. You can group noncontiguous worksheets
with

323. Which of the following is not an option of a. The alt+enter key

the spelling dialog box? b. The ctrl key and mouse
c. The shift key and the mouse
a. Ignore d. The group button on the standard toolbar
b. Ignore all
c. Edit
d. Change 329. What is the AutoComplete feature of
Excel?

324. Which of the following methods will not a. It automatically completes abbreviated words
enter data in a cell? b. It completes text entries that match an existing
entry in the same column
a. Pressing the Esc key c. It completes text and numeric entries that match
b. Pressing an arrow key an existing entry in the same column
c. Pressing the tab key d. It completes text entries that match an existing
d. Clicking the enter button to the formula bar entry in the same worksheet

325. The cell reference for cell range of G2 to 330. Which of the following is correct?
M12 is _______
a. =AVERAGE(4, 5, 6, 7)
a. G2.M12 b. =AVERAGE(A1, B1, C1)
b. G2;M12 c. =AVERAGE(A1:A9, B1:B9)
c. G2:M12 d. =All of the above
d. G2-M12

331. Which of the following function will return

326. What is the keyboard shortcut for creating a value of 8?
a chart from the selected cell range?
a. ROUNDUP(8.4999, 0)
a. F2 b. ROUNDDOWN(8.4999, 0)
b. F4
c. ROUND(8.4999, 0) c. It returns the serial number of the current time
d. Only B and C d. None of the above

332. How to restrict to run a macro 337. What value will display if the formula =
automatically when starting Microsoft Excel? “$55.00″+5 is entered into a cell?

a. Hold down the SHIFT key during startup a. $60

b. Hold down the CTRL key during startup b. 60
c. Hold down the ESC key during startup c. “$55.00″+5
d. Hold down the ALT key during startup d. $60.00

333. How to remove the unwanted action from 338. What is the shortcut key to insert current
recorded macro without recording the whole date in a cell?
macro again?
a. CTRL + D
a. By using the Find and Edit Action Option b. CTRL + T
b. By clicking on the Refresh button in the Macro c. CTRL + ;
toolbar d. CTRL + /
c. By edit the macro in the Visual Basic Editor
d. Macro cannot be edited.
339. Which of the following syntax is correct
regarding to SUM function in Excel?
334. What should be add before a fraction to
avoid entering it as a date? a. =SUM (A1, B1)
b. =SUM (A1:B9)
a. // c. =SUM (A1:A9, B1:B9)
b. FR d. All of the above
c. Zero
d. Zero Space
340. What is the shortcut key to hide entire
column?
335. Which of the following function will use to
find the highest number in a series of number? a. CTRL + −
b. CTRL + 0
a. MAX(B1:B3) c. CTRL + H
b. MAXIMUM (B1:B3) d. CTRL + C
c. HIGH (B1:B3)
d. HIGHEST(B1:B3)
341. How to specify cell range from A9 to A99
in Excel?
336. What does the NOW() function return?
a. (A9, A99)
a. It returns the serial number of the current date b. (A9 to A99)
and time c. (A9 : A99)
b. It returns the serial number of the current date d. (A9 – A99)
342. Selecting the Column G & H then choose click on the last column
Insert->ColumnWhat will happen? d. Click on the rectangle box on the upper left
corner where column headings and row headings
a. 2 Columns will be inserted after Column F meet
b. 2 Columns will be inserted after Column G
c. 2 Columns will be inserted after Column H
d. 2 Columns will be inserted after Column I 347. A smart tag will be removed from a cell
when

343. How to restrict the values of a cell so that a. the cell is moved
only whole numbers between 9 and 99 can be b. the cell is hidden
entered in a cell. c. the data in the cell is changed or deleted
d. the formatting of the cell is changed
a. The Settings tab under the menu Format ->
Cells
b. The Settings tab under the menu Data -> 348. Which of the following options is
Validation appropriate to show the numbers
c. The Settings tab under the menu Data -> Filter - 9779851089510 in a cell?
> Advanced Filter
d. the Settings tab under the menu Format -> a. Enclose the number is brackets
Conditional Formatting b. Place the character T before the number
c. Place the character TX before the number
d. Apply the Text format in the cell and type the
344. Clear the contents by pressing “DELETE” numbers
key from a keyboard will clear

a. Text Only 349. Which of the following is correct syntax in

b. Format Only Excel?
c. Contents Only
d. Both Contents and Format a. =IF(LogicalTest, TrueResult, FalseResult)
b. =IF(LogicalTest, (TrueResult, FalseResult))
c. =IF(LogicalTest, TrueResult) (LogicalTest,
345. Which of the following shortcuts can be FalseResult)
used to insert a new line in the same cell? d. =IF(LogicalTest, TrueResult), IF(LogicalTest,
FalseResult)
a. Enter
b. Alt + Enter
c. Ctrl + Enter 350. Which of the following is correct?
d. Shift + Enter
a. =POWER(2^3)
b. =POWER(2,3)
346. What is the quickest way to select entire c. =POWER(2#3)
worksheet? d. =POWER(2*3)

a. Choose Edit -> Select all from the Menu

b. Click on the first column, press Ctrl, and then 351. Selecting the Rows 5 & 6 then choose
click on the last column Insert->RoWhat will happen?
c. Click on the first column, press Shift, and then
a. 2 Rows will be inserted after Row 4 356. If the cell B1 contains the formula = $A$1,
b. 2 Rows will be inserted after Row 5 which of the following statements is true
c. 2 Rows will be inserted after Row 6
d. 2 Rows will be inserted after Row 7 a. There is a relative reference to cell A1
b. There is an absolute reference to cell A1
c. Further changes in value of A1 will not affect
352. If 4/6 entered in a cell without applying the value of B1
any formats, Excel will treat this as d. Further changes in value of B1 will affect the
value of A1
a. Fraction
b. Number
c. Text 357. Worksheet can be renamed by
d. Date
a. Adding ? symbol at the end of filename while
saving workbook
353. If the values in A1 is “MCQ” and B1 is b. Click on Worksheet tab by Holding CTRL Key
“Questions”, which function will and type new name
return [email protected] in cell C1? c. Double Click on the Worksheet tab and type
new name
a. =A1 + [email protected] + B1 d. Worksheet cannot renamed
b. =A1 # [email protected] # B1
c. =A1 & [email protected] & B1
d. =A1 $ [email protected] $ B1 358. 1What is the shortcut key to hide entire
row?

354. How to fit long texts in a single cell with a. CTRL + H

multiple lines? b. CTRL + R
c. CTRL + 9
a. Start typing in the cell and press the Enter key d. CTRL + –
to start another line
b. Use the Wrap Text option in the Format ->
Alignment menu 359. What is the shortcut key to insert a new
c. Use the Shrink to Fit option in the Format -> comment in a cell?
Cells -> Alignment menu
d. All of above a. F2
b. Alt + F2
c. Ctrl + F2
355. If particular workbook have to open each d. Shift + F2
time Excel started, where that workbook
should be placed?
360. Which option allows you to Bold all the
a. AUTOEXEC Folder negative values within the selected cell range:
b. AUTOSTART Folder
c. EXCELSTART Folder a. Zero Formatting
d. XLSTART Folder b. Conditional Formatting
c. Compare Formatting
d. Negative Formatting
361. What is the shortcut key to insert new
sheet in current workbook?
a. Page Layout -> Grid lines -> View
a. F11 b. Insert -> Grid lines -> View
b. Alt + F11 c. View -> Grid lines -> View
c. Ctrl + F11 d. Edit -> Grid lines -> View
d. Shift + F11

367. What will be the result if you type =A1=B1

362. Which one is the last column header in in cell C1?
Excel 2007?
a. Yes or No
a. XFD b. True or False
b. XFX c. Value of A1
c. XFL d. Value of B1
d. XFT

368. In Excel _______ may not contain in

363. In maximum, how many sheets can be set Formula
as default while creating new workbook?
a. Text Constant
a. 254 b. Number Constant
b. 255 c. Circular Reference
c. 256 d. All of them
d. No Limit

364. “New Comment” option can be found

under _________ tab

a. Insert
b. Data
c. Review
d. View

365. In Excel, by default Numeric Values

appears in

a. Left aligned
b. Right aligned
c. Center aligned
d. Justify aligned

366. To show/hide the grid lines in Microsoft

Excel 2007