MS excel set 8 Detailed Explanation And More Example

Question : 1

In Excel when integrating Ms-Word and Excel, Word is usually the

a) Server

b) Source

c) Client

d) None

Question : 2

In Excel which of the following is a correct order of precedence in formula calculation?

a) Multiplication and division exponentiation positive and negative values

b) Multiplication and division, positive and negative values, addition and subtraction

c) Addition and subtraction, positive and negative values, exponentiation

d) All of above

Question : 3

Status indicators are located on the

a) Vertical scroll bar

b) Horizontal scroll bar

c) Formula bar

d) Standard toolbar

e) None of these

Question : 4

In Excel how can you find specific information in a list?

a) Select Tools > Finder from the menu

b) Click the Find button on the standard toolbar

c) Select Insert > Find from the menu

d) Select Data > Form from the menu to open the Data Form dialog box and click the Criteria button

Question : 5

What term refers to a specific set of values saved with the workbook?

a) Range

b) Trend line

c) What-if analysis

d) None of these

Question : 6

In Excel when the formula bar is activated, you can see

a) The Edit Formula button

b) The Cancel button

c) The Enter button

d) All of above