Microsoft Excel MCQs for test and Interview
![](https://sabaqasaan.com/wp-content/uploads/2022/10/Excel-cover-2.jpg)
351. Selecting the, Rows 5 & 6 then choose, Insert->RoWhat will, happen?
a. 2 Rows will be inserted, after Row 4,
b. 2 Rows will be, inserted after Row 5,
C. 2 Rows will ,be inserted after Row 6,
d. 2 Rows will be, inserted after Row 7,
See Answer
a. 2 Rows will be inserted, after Row 4
352. If 4/6 entered in a, cell without applying any, formats, Excel will treat, this as
a. Fraction
b. Number,
C. Text,
d. Date,
See Answer
d. Date
353. If the values in A1 is “MCO” and B1 is “Questions”, which function will return “MCQ@Questions” in cell C1?
a. =A1 + “@” + B1,
b. =A1 # “@” # B1,
c. =A1 & “@” & B1,
d. =A1 $ “@” $ B1,
See Answer
c. =A1 & “@” & B1
354. How to fit long, texts in a single cell ,with multiple lines?
a. Start typing in, the cell and press the ,Enter key to start another line
b. Use the Wrap, Text option in the, Format ->Alignment menu
c. Use the Shrink, to Fit option in the ,Format-> Cells-> Alignment, menu
d. All ,
See Answer
b. Use the Wrap, Text option in the, Format ->Alignment menu
355. If particular, workbook have to open each, time Excel started, where that, workbook should, be placed?
a. AUTOEXEC Folder,
b. AUTOSTART Folder,
c. EXCELSTART Folder,
d. XLSTART Folder,
See Answer
d. XLSTART Folder
356. If the cell B1 ,contains the formula = $A$1, which, of the following statements, is true
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 th,e value of B1
d. Further changes in ,value of B1 will affect the value, of A1
See Answer
b. There is an absolute reference to cell A1
357. Worksheet, can be renamed, by
a. Adding ? symbol at the, end of filename while saving ,workbook
b. Click on Worksheet tab by ,Holding CTRL
c. Double Click on the worksheet ,tab and Key and type new name type new name
d. Worksheet cannot, renamed
See Answer
c. Double Click on the worksheet ,tab and Key and type new name type new name
358. 1What is the, shortcut key to hide, entire row?
a. CTRL + H,
b. CTRL +R,
C. CTRL +9,
d. CTRL + -,
See Answer
C. CTRL +9,
359. What is the ,shortcut key to insert, a new comment in ,a cell?
a. F2,
b. Alt + F2,
C. Ctrl+F2,
d. Shift+ F2,
See Answer
d. Shift+ F2,
360. Which option ,allows you to bold all the,, negative values within the ,selected cell range?
a. Zero Formatting,
b. Conditional Formatting,
c. Compare Formatting,
d. Negative Formatting,
See Answer
b. Conditional Formatting
Hey, honestly your site is coming along :-), but I had a question – it’s a bit slow. Have you thought about using a different host like propel? It’d help your visitors stick around longer = more profit long term anyway. There’s a decent review on it by this guy who uses gtmetrix to test different hosting providers: https://www.youtube.com/watch?v=q6s0ciJI4W4 and the whole video has a bunch of gold in it, worth checking out.