microsoft excel q/a Practice Questions Answers Test with Solutions & More Shortcuts

Question : 21

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

You can not link excel worksheet data to a word document

a) With the right drag method

b) With a hyperlink

c) With the copy and paste special commands

d) With the copy and paste buttons on the standard toolbar.

e) None of these

Question : 23

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

a) !A!1

b) $A$1

c) #a#1

d) A1

Question : 24

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

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