Computer MS Excel Shortcuts Keys Test 1 Online

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

You can prepare for Computer MS Excel Shortcuts Keys Test 1 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 functions will calculate the number of workdays between 6/9/2004 and 8/12/2004

Answer

All of the above

Answer

Networkdays

Question 2

2. In Excel default header for a worksheet is

Answer

The sheet tab name

Answer

The date and time

Question 3

3. In Excel which of the following is not an option in the spelling dialog box

Answer

Ignore All

Question 4

4. You cannot link Excel worksheet data to a Word document

Answer

With the right drag method

Answer

With the copy and paste special commands

Answer

With a hyperlink

Answer

With the copy and paste buttons on the standard toolbar

Question 5

5. In Excel default header for a worksheet is

Answer

The date and time

Answer

The sheet tab name

Question 6

6. In Excel you can use the format painter multiple times before you turn it off by

Answer

Pressing the Ctrl key and clicking the format painter button

Answer

Pressing Alt key and clicking the format painter button

Answer

Double clicking the format painter button

Answer

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

Question 7

7. In Excel….. is a group of cells that form a rectangle on the screen.

Answer

Range address

Answer

Calculation

Question 8

8. In Excel you can copy cell formats from one cell to another by using the

Answer

Default font

Answer

Formatting toolbar

Answer

Backspace key

Answer

Format painter

Question 9

9. In Excel which of the following is not an option in the spelling dialog box

Answer

Ignore all

Question 10

10. In Excel you can zoom a worksheet

Answer

All of the above

Answer

With the zoom button on the Print Preview toolbar

Answer

With the mouse pointer in Print Preview

Answer

With the Zoom command on the view menu

Question 11

11. In Excel you can quickly change the appearance of your work by choosing Auto Format from the ……….. Menu

Question 12

12. In Excel data marker on a chart are linked to data points in a worksheet, therefore,

Answer

You can change the position of a data marker and automatically change the data point value in the worksheet

Answer

You can automatically apply formatting to a data series

Answer

(A) and (B)

Answer

You can change a data print value and automatically are draw the chart

Question 13

13. In Excel the chart wizard

Answer

Can only place a chart on new chart sheet

Answer

Can place a chart on a new chart sheet or on any sheet in the workbook

Answer

Can only be used to create embedded charts

Answer

Can only place a chart on a new blank worksheet

Question 14

14. In Excel the drag and drop method of copying or moving

Answer

Can be used between workbooks but not worksheets

Answer

Can be used between workbooks but not worksheets

Answer

Can be used between worksheets but not workbooks

Question 15

15. Excel uses the …. Function when creating a data table

Question 16

16. In Excel you can use drag and drop to embed excel worksheet data in a word document

Answer

By displaying both applications side-byside and dragging a selected range of Excel data into the word application window while pressing the Ctrl key

Answer

(A) and (C)

Answer

By dragging a range of excel data to the word button on the taskbar while pressing the Ctrl key

Answer

By dragging a range of excel data to the Word button on the taskbar while pressing Shift key

Question 17

17. In Excel this type of software is similar to an accountant’s worksheet

Answer

Spreadsheets

Answer

Word processing

Question 18

18. In Excel when you group worksheets

Answer

You can print more than one worksheet at a time

Answer

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

Answer

None of these

Answer

You can enter variable data on multiple worksheets at one time

Question 19

19. In Excel following term describes explanatory text attached to a cell

Question 20

20. In Excel accounting style shows negative numbers in

Answer

Parentheses

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 1 Online

Computer MS Excel Shortcuts Keys Test 1

Computer MS Excel Shortcuts Keys Test 1 Practice Online

Study Plan for Computer MS Excel Shortcuts Keys Test 1 Online

How to Use GoTest for Preparation:

More Related Resources

Maan Ali

2 Comments

Leave a Reply Cancel reply