Computer

1. In Excel you can copy data or formulas

With buttons on the standard toolbar

All of the above

With commands on a shortcut menu

With the copy, paste and cut commands on the edit menu

Question 1 of 20

2. In Excel Rounding errors can occur

When you use multiplication, division or exponentiation in a formula

When you show the results of formulas with different decimal places than the calculated results

When you use addition and subtraction in a formula

Because Excel uses hidden decimal places in computation

Question 2 of 20

3. In Excel you can open the scenario Manager dialog box by choosing scenarios from the ....... menu.

View

Insert

Format

Tools

Question 3 of 20

4. In Excel a data map is helpful

To show a geographic distribution of data

To compare data points

To show changes in data over time

When you have too much data to chart

Question 4 of 20

5. In Excel you cannot link excel worksheet data to a word document

With the copy and paste special commands

With a hyperlink

With the right drag method

With the copy and paste buttons on the standard toolbar

Question 5 of 20

6. Excel files have a default extension of

Xlw

Xls

Wk1

123

Question 6 of 20

7. In Excel one can copy data or formulas

With buttons on the standard toolbars

With the copy, paste and cut commands on the edit menu

With commands on ta shortcut menu

All of the above

Question 7 of 20

8. In Excel Rounding errors can occur

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

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

Because excel uses hidden decimal places in computation

When you use addition and subtraction in a formula

Question 8 of 20

9. In Excel one can use the format painter multiple times before one turn it off by

You can use the format painter button on ly one time when you click it

Pressing the Ctrl key and clicking the format painter button

Double clicking the format painter button

Pressing the Alt key and clicking the format painter button

Question 9 of 20

10. In Excel Status indicators are located on the

Vertical scroll bar

Formula bar

Formatting toolbar

Horizontal scroll bar

Question 10 of 20

11. In Excel when working in the page break preview, you can

Add or remove page breaks

Change the print area

View exactly where each page break occurs

All of above

Question 11 of 20

12. In Excel to edit in an embedded excel worksheet object in a word document

Use the word menu bar and toolbars

Use the excel menu bar and toolbars inside the word application

Edit the data in a excel source application

Edit the hyperlink

Question 12 of 20

13. In Excel which of these is a quick way to copy formatting from a selected cell to two other cells on the same worksheet?

Use Ctrl to select all three cells, then click the paste button on the standard toolbar

Copy the selected cell, then select the other two cells, click style on the Format menu, then click Modify

All of above

Click format painter on the Formatting toolbar twice then click in each cell you want to copy the formatting to

Question 13 of 20

14. To edit data in an embedded Excel worksheet object in a Word document

Use the Word menu bar and toolbars

Edit the hyperlink

Use the Excel menu bar and toolbars inside the word application

Edit the data in a Excel source application

Question 14 of 20

15. In Excel to create a formula, you can use

Cell references but not values

Value and cell references

Values but not cell references

Values or cell references although not both at the same time

Question 15 of 20

16. In Excel to hold row and column titles in places so that they do not scroll when you scroll a worksheet, click the

Unfreeze panes command on the window menu

Split command on the window menu

Freeze panes command on the window menu

Hold titles command on the edit menu

Question 16 of 20

17. In Excel Hyperlinks can be

Text

All of above

Pictures

Drawing objects

Question 17 of 20

18. An excel workbook is a collection of

Worksheets

Worksheets and charts

Charts

Workbooks

Question 18 of 20

19. In Excel you can open the Sort dialog box by choosing Sort from the ___________ menu

Data

Format

Tools

View

Question 19 of 20

20. In Excel Status indicators are located on the

Standard toolbar

Formula bar

Vertical scroll bar

Horizontal scroll bar

Question 20 of 20

Test Name	Microsoft Excel Test 2
Subject	Computer
Test Type	MCQs
Total Question	20
Total Marks	40
Total Time	20 Mints
Test Help For	Basic Knowledge about IT IT General Knowledge Quiz Computer History IT & Computer Tests General Ability Competitive Exams.

Test By Subject	Computer Science
Test By Topics	Computer General

Test Advisor

Microsoft Excel Test 2 Online MCQs

Microsoft Excel Test 2 Online MCQs

Computer

Leave a Reply Cancel reply