MS excel set 9 Detailed Explanation And More Example

Question : 1

You can use the format painter multiple times before you turn it off by

a) You can use the format painter button only one time when you click it

b) Double clicking the format painter button

c) Pressing the Ctrl key and clicking the format painter button

d) Pressing the Alt key and clicking the format painter button

e) None of these

Question : 2

Formatting a cell In Currency, you can specify

a) Decimal Places

b) Currency Symbol

c) Both of above

d) All of above

e) None of these

Question : 3

A function inside another function is called a.....function.

a) Nested

b) Round

c) Sum

d) Text

e) None of these

Question : 4

In Excel this function converts miles to kilometers, kilograms to pounds, and so on

a) Convert

b) Product

c) Change

d) All of above

Question : 5

In Excel which of the following is not a worksheet design criterion?

a) Efficiency

b) Aditibility

c) Description

d) Clarity

Question : 6

Which of the following methods cannot be used to edit the contents of a cell In Excel?

a) Press the Alt key

b) Clicking the formula bar

c) Pressing the F2 key

d) Double clicking the cell