MS excel set 7 Detailed Explanation And More Example

Question : 1

Documentation should include

a) Destination and users of the output data

b) Source of input data

c) Information on the purpose of the workbook

d) All the above

e) None of these

Question : 2

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) Click the Currency Style button on the formatting toolbar

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

c) Select Format > Money from the menu

d) All the above

e) None of these

Question : 3

In Excel Book1 is an example of how … are numbered and named during each work session

a) Active cell

b) Formula bar

c) Menu bar

d) Name box

Question : 4

Which of the following options is not available to remove arrows of Formula Auditing?

a) Remove all precedent arrows

b) Remove all dependent arrows

c) Remove all arrows

d) Remove all arrows for this cell

e) None of these

Question : 5

What does COUNTA ( ) function do?

a) counts cells having alphabets

b) counts empty eel is

c) counts cells having number

d) counts non-empty cells

e) None of these

Question : 6

In Excel the following is not information you can specify using the solver

a) Input cells

b) Constraints

c) Target cell

d) Changing cells