Computer MS Excel Shortcuts Keys Info Quiz 1 Online Important Mcqs Questions

To help our visitors in evaluating their level of knowledge about computer software and also to improve it, given below on this page is a free online mcqs quiz about the important Microsoft MS Excel keyboard shortcuts keys. It is strongly recommended that you attempt this test as well as the other tests related to it which are available on our website because questions like these are often asked in computer related jobs written exams and interviews.

Computer MS Excel Shortcuts Keys Info Quiz 1 Online Important Mcqs Questions

• 1
• 2
• 3
• 4
• 5
• 6
• 7
• 8
• 9
• 10
• 11
• 12
• 13
• 14
• 15
• 16
• 17
• 18
• 19
• 20

• Show paginator

• Hide paginator

 Loading...

Computer General

1. In Excel which functions will calculate the number of workdays between 6/9/2004 and 8/12/2004

All of the above

Date

Workday

Networkdays

Question 1 of 20

 Loading...

2. In Excel default header for a worksheet is

The date and time

Your name

None

The sheet tab name

Question 2 of 20

 Loading...

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

Double clicking the format painter button

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

Pressing the Ctrl key and clicking the format painter button

Pressing Alt key and clicking the format painter button

Question 3 of 20

 Loading...

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

Dialog

Callout

Extension

Comment

Question 4 of 20

 Loading...

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

Count

Sum

Table

Average

Question 5 of 20

 Loading...

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

Format painter

Default font

Formatting toolbar

Backspace key

Question 6 of 20

 Loading...

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

Change

Ignore

Ignore All

Edit

Question 7 of 20

 Loading...

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

Tools

View

Edit

Format

Question 8 of 20

 Loading...

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

With the copy and paste special commands

With the copy and paste buttons on the standard toolbar

With the right drag method

With a hyperlink

Question 9 of 20

 Loading...

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

Edit

Ignore all

Change

Ignore

Question 10 of 20

 Loading...

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

Range

Calculation

Formula

Range address

Question 11 of 20

 Loading...

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

Database

Graphics

Spreadsheets

Word processing

Question 12 of 20

 Loading...

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

You can automatically apply formatting to a data series

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

(A) and (B)

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

Question 13 of 20

 Loading...

14. In Excel the chart wizard

Can only place a chart on new chart sheet

Can only place a chart on a new blank worksheet

Can only be used to create embedded charts

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

Question 14 of 20

 Loading...

15. In Excel accounting style shows negative numbers in

Bold

Quotes

Parentheses

Brackets

Question 15 of 20

 Loading...

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

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

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

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

(A) and (C)

Question 16 of 20

 Loading...

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

None

Can be used between worksheets but not workbooks

Can be used between workbooks but not worksheets

Can be used between workbooks but not worksheets

Question 17 of 20

 Loading...

18. In Excel you can zoom a worksheet

With the zoom button on the Print Preview toolbar

With the Zoom command on the view menu

With the mouse pointer in Print Preview

All of the above

Question 18 of 20

 Loading...

19. In Excel when you group worksheets

You can print more than one worksheet at a time

None of these

You can enter variable data on multiple worksheets at one time

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

Question 19 of 20

 Loading...

Computer Science

20. In Excel default header for a worksheet is

The sheet tab name

The date and time

Your name

None

Question 20 of 20

 Loading...