MS excel set 12 Detailed Explanation And More Example

Question : 1

In Excel when you work with large worksheets, you may need to

a) Size the worksheet to fit on the specific number of pages

b) Add and remove page breaks

c) Specify only certain print areas

d) All of above

Question : 2

What feature enables you to adjust or back solve the value in a cell to reach a desired outcome in a formula?

a) Scenario Summary report

b) Goal Seek

c) Forecasting

d) Trend line

e) None of these

Question : 3

In Excel what chart object is horizontal or vertical line that extends across the plot area to make it easier to read and follow the values?

a) Category axis

b) Data marker

c) Data point

d) Gridline

Question : 4

Which of the following is not a worksheet design criterion?

a) Efficiency

b) Aditibility

c) Description

d) Clarity

e) None of these

Question : 5

In Excel Charts tips can

a) Show the formatting of a data label

b) Show the name of a data series

c) Show the value of data point

d) Both (B) and (C)

Question : 6

Tab scrolling button

a) Allow you to view a different worksheet

b) Allow you to view additional worksheet rows down

c) Allow you to view additional worksheet columns to the right

d) Allow you to view additional sheets tabs

e) None of these