MS excel set 8 Detailed Explanation And More Example

Question : 1

Which of the following is not a term of MS-Excel?

a) Cells

b) Rows

c) Columns

d) Document

e) None of these

Question : 2

In Excel the numbers in our worksheet look like this: 1000. You want them to look like this: $1,000.00. How can you accomplish this?

a) None of these

b) Select Format > Money from the menu

c) Click the Currency Style button on the formatting toolbar

d) You have to retype everything and manually add the dollar signs, commas, and decimals.

Question : 3

In Excel the following will not cut information

a) Pressing Ctrl + C

b) Selecting Edit>Cut from the menu

c) Clicking the Cut button on the standard

d) Pressing Ctrl+X

Question : 4

You can set Excel in Automatic or Manual calculation mode. If it is in manual mode which key you will press to update the formula values?

a) F9

b) F5

c) F8

d) F11

e) None of these

Question : 5

To make a number In cell Cl 10% smaller than the number In C3 you enter

a) -03*1.10

b) +C3*110

c) -C3%10

d) -C3*.90

e) None of these

Question : 6

In Excel how do you change column width to fit the contents?

a) Single-click the boundary to the left to the column heading

b) Double click the boundary to the right of the column heading

c) Press Alt and single click anywhere in the column

d) All of above