MS excel set 7 Detailed Explanation And More Example

Question : 1

In Excel which of the following is an absolute cell reference?

a) !A!1

b) $A$1

c) #a#1

d) A1

Question : 2

In Excel Chart wizard term data categories refers to

a) A chart plot area

b) A horizontal axis

c) The organization of individual values with a chart’s data series

d) The data range that supply chart data

Question : 3

When you group worksheets

a) You can enter variable data on multiple worksheets at one time

b) You can print more than*one worksheet at a time

c) You can enter common data, formats, and formulas on multiple worksheets at one time

d) b, and c

e) None of these

Question : 4

Your German supplier still invoices for parts in deutsche marks. How can you have Excel convert those sums to Euros?

a) On the Insert menu, click Symbol and from the currency symbols subset, select the Euro sign,

b) On the tools menu, click Add-ins, and select the Euro Currency Tools check box

c) Apply a selected background color

d) All of above

e) None of these

Question : 5

Which of the following is the latest version of Excel?

a) Excel 2000

b) Excel 20.02

c) Excel ME

d) Excel XP

e) None of these

Question : 6

Where a row and a column meet, what do you call that?

a) A eel I

b) A block

c) A box

d) All of the above

e) None of these