341. How to specify, cell range from A9 to, A99 in Excel?
a. (A9, A99),
b. (A9 to A99),
c. (A9: A99),
d. (A9-A99),
See Answer
a. (A9, A99)
342. Selecting the, Column G & H then, choose Insert->Column, What ,will happen?
a. 2 Columns ,will be inserted after Column,
b. 2 Columns will, be inserted after Column,
C. 2 Columns will ,be inserted after Column,
d. 2 Columns will be, inserted after Column,
see Answer
a. 2 Columns ,will be inserted after Column,
343. How to restrict the, values of a cell so, that only whole numbers ,between 9 and 99 can be ,entered in a cell.
a. The Settings tab, under the menu Format-> Cells,
b. The Settings tab, under the menu Data – >Validation,
c. The Settings tab, under the menu, Data – >Filter-> Advanced, Filter
d. the Settings tab, under the menu ,Format-> Conditional, Formatting
See Answer
b. The Settings tab, under the menu Data – >Validation,
344. Clear the contents, by pressing “DELETE” key from ,a keyboard will clear
a. Text Only,
b. Format Only,
c. Contents Only,
d. Both Contents, and Format
See Answer
c. Contents Only
345. Which of the following, shortcuts can be used to insert, a new line in the same, cell?
a. Enter,
b. Alt +Enter,
C. Ctrl+Enter,
d. Shift+ Enter as esuele
See Answer
b. Alt +Enter
346. What is the, quickest way to select, entire worksheet?
a. Choose Edit -> Select all from, the Menu
b. Click on the first, column, press Ctrl, and then click on the, last column
c. Click on the first, column, press Shift, and then click on, the last column
d. Click on the rectangle, box on the upper left corner where, column headings and row, headings meet
See Answer
d. Click on the rectangle, box on the upper left corner where, column headings and row, headings meet
347. A smart tag will, be removed from a cell, when
a. the cell is moved,
b. the cell is hidden,
c. the data, in the cell is changed, or deleted
d. the formatting, of the cell is changed,
See Answer
c. the data, in the cell is changed, or deleted
348. Which of the following, options is appropriate to show, the numbers 9779851089510 in, a cell?
a. Enclose the, number is brackets,
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 numbers
See Answer
d. Apply the Text, format in the cell and, type the numbers
349. Which of the, following is correct ,syntax in Excel?
a. =IF(LogicalTest, TrueResult, FalseResult),
b. =IF(LogicalTest, (TrueResult, FalseResult)),
c. =IF(LogicalTest, TrueResult) (LogicalTest, FalseResult),
d. =IF (LogicalTest, TrueResult), ,IF(LogicalTest, FalseResult),
See Answer
a. =IF(LogicalTest, TrueResult, FalseResult)
350. Which of the, following is correct?
a. =POWER(2^3),
b. =POWER(2,3),
C. =POWER(2#3),
d. =POWER(2*3),
See Answer
b. =POWER(2,3)
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.