MS excel set 12 Detailed Explanation And More Example

Question : 1

A user wishes to remove a spreadsheet from a workbook. Which is the correct sequence ofsgyents that will do this?

a) Go to File-Save As - Save As Type - Excel worksheet

b) Right click on the spreadsheet tab and select DELETE

c) Right click on the spreadsheet and select Insert – Entire Column

d) All of above

e) None of these

Question : 2

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 : 3

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 : 4

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 : 5

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