MS excel set 12 Detailed Explanation And More Example

Question : 1

In order to arrange the countries from those with the highest population to those with the lowest, you need to sort on the population field in...............

a) ascending order

b) descending order

c) alphabetical order

d) random order

e) None of these

Question : 2

A typical worksheet has .... Number of columns

a) 128

b) 256

c) 512

d) 1024

e) None of these

Question : 3

Pounding errors can occur

a) When you use multiplication, division, or exponentiation in a formula

b) When you use addition and subtraction in a formula

c) Because excel uses hidden decimal places in computation

d) When you show the results of formulas with different decimal places that the calculated results

e) None of these

Question : 4

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

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

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