Computer MS Excel Shortcuts Keys Test 2 Online

Q: How can I prepare for Computer MS Excel Shortcuts Keys Test 2 Online?

You can prepare for Computer MS Excel Shortcuts Keys Test 2 Online by attempting the free online quizzes at Gotest.com.pk. We provide instant results, performance reports, and detailed explanations for every question.

Question 1

1. In Excel which elements of worksheet can be protected from accidental modification ?

Answer

All of above

Question 2

2. In Excel you can use the drag and drop method to

Answer

Copy cell contents

Answer

Move cell contents

Answer

(A) and (B)

Answer

Add cell contents

Question 3

3. In Excel Documentation should include

Answer

All of the above

Answer

Destination and users of the output data

Answer

Source of input data

Answer

Information on the purpose of the workbook

Question 4

4. In Excel it is acceptable to let long text flow into adjacent cells on a worksheet when

Answer

No data will be entered in the adjacent cells

Answer

There is not time to format the next

Answer

Data will be entered in the adjacent cells

Answer

There is nt suitable abbreviation of the text

Question 5

5. In Excel you can use the formula palette to

Answer

Entered assumptions data

Answer

Copy a range of cells

Answer

Format cells containing numbers

Answer

Create and edit formulas containing functions

Question 6

6. In Excel what chart object is horizontal or vertical line that extends across the plot area to make it easier to read and follow the values?

Answer

Category axis

Answer

Data point

Answer

Data marker

Question 7

7. Right clicking something in Excel

Answer

Nothing the right mouse button is there for left handed people

Answer

Deletes the object

Answer

Opens a shortcut menu listing everything you can do to the object

Answer

Selects the object

Question 8

8. In Excel the keyboard shortcut (button or buttons to be presse(D) for creating a chart from the selected cells

Question 9

9. In Excel value used in a formula that does not change is called a

Answer

Cell address

Question 10

10. In Excel how can you delete a record?

Answer

Select Data > Form from the menu to open the Data dialog box, find record and Click the Delete button

Answer

Select Data > Delete Record from the menu

Answer

Click the Delete button on the Standard toolbar

Answer

Delete the column from the worksheet

Question 11

11. In Excel the auto calculate feature

Answer

Can only add values in a range of cells

Answer

None of the above

Answer

Provides a quick way to view the results of an arithmetic operation on a range of cells

Answer

Automatically creates formulas and adds them to a worksheet

Question 12

12. In Excel the auto fill feature

Answer

Automatically adds a range of cell values

Answer

Applies a boarder around selected cells

Answer

Extends a sequential series of data

Answer

None of above

Question 13

13. In Excel which of the following is not a worksheet design criterion

Answer

Efficiency

Answer

Clarity Correct Answer:

Answer

Auditability

Answer

Description

Question 14

14. Files created with Lotus 1-2-3 have an extension

Question 15

15. In Excel to protect a worksheet, you can choose Protection and the Protect Sheet from the ….. ……menu

Question 16

16. In Excel you can open the Highlight Changes dialog box by choosing Track Changes from the …. Menu.

Question 17

17. In Excel 3-D reference in a formula

Answer

Cannot be modified

Answer

Limits the formatting options

Answer

Spans worksheets

Answer

Only appears on summary worksheets

Question 18

18. What excel feature can you use if you want to work with one record at a time?

Answer

Sub Totals

Answer

Auto Complete

Answer

Auto Filter

Question 19

19. In Excel if you press …….., the cell accepts your typing as its contents.

Answer

Ctrl + Enter

Question 20

20. In Excel to copy cell contents using drag and drop, press the

Answer

None of above

Question 21

Loading...

Total Questions:	20
Time Allowed:	10 Minutes
Total Marks:	20
How to Attempt Test:	Please choose the right Option in MCQ-type question.
Test Helpful For:	Computer Test Competitive exam Forces test PPSC/Fpsc/SPSC/KPPSC Test Entry test Recruitment test

Computer MS Excel Shortcuts Keys Test 2 Online

Computer MS Excel Shortcuts Keys Test 2

Computer MS Excel Shortcuts Keys Test 2 Practice Online

Study Plan for Computer MS Excel Shortcuts Keys Test 2 Online

How to Use GoTest for Preparation:

More Related Resources

Maan Ali

One Comment

Leave a Reply Cancel reply