Microsoft Excel MS Excel important Mcqs for kppsc,fpsc,ppsc,nts

31. Which of these keys used to apply currency format with two decimal places in MS Excel?
(a) CTRL+SHIFT+&
(b) CTRL+SHIFT+~
(c) CTRL+SHIFT+$
(d) CTRL+SHIFT+%

View Answer
(c) CTRL+SHIFT+$ 

 

32.  Which of these keys used to apply percentage format with no decimal places in MS Excel?
(a) CTRL+SHIFT+&
(b) CTRL+SHIFT+~
(c) CTRL+SHIFT+$
(d) CTRL+SHIFT+%

View Answer
(d) CTRL+SHIFT+%

 

33. Which of these keys used to fill Right command to copy the contents and format of the leftmost cell of a selected range into the cells to the right?
(a) CTRL+R
(b) CTRL+L
(c) CTRL+T
(d) CTRL+W

View Answer
(a) CTRL+R

 

34. Which of these keys used to fill down command to copy the contents and format of the topmost cell of a selected range into the cells below:
(a) CTRL+R
(b) CTRL+L
(c) CTRL+F
(d) CTRL+D

View Answer
(d) CTRL+D

 

35. How do you insert a row?  
(a) Right click the row heading where you want to insert the new row and select Insert from the shortcut menu
(b) Select the row heading where you want to insert the new row and select Edit >Row from
the menu
(c) Select the row heading where you want to insert the new row and click the Insert Row
button on the standard toolbar
(d) All of the above

View Answer
(a) Right click the row heading where you want to insert the new row and select Insert from the shortcut menu

 

Pages ( 7 of 13 ): « Previous1 ... 56 7 89 ... 13Next »