Home / Tests / Microsoft Excel Test 1 Online MCQs

Microsoft Excel Test 1 Online MCQs

Test Name	Microsoft Excel Test 1
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.

Microsoft Excel Test 1 Online MCQs

Show paginator

Hide paginator

Computer

1. 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 Shift key

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

(A) and (C)

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

Question 1 of 20

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

With the right drag method

With the copy and paste special commands

With a hyperlink

With the copy and paste buttons on the standard toolbar

Question 2 of 20

3. In Excel _________ is a group of cells that form a rectangle on the screen.

Range address

Range

Formula

Calculation

Question 3 of 20

4. In Excel you can zoom a worksheet

All of the above

With the zoom button on the Print Preview toolbar

With the Zoom command on the view menu

With the mouse pointer in Print Preview

Question 4 of 20

5. In Excel accounting style shows negative numbers in

Quotes

Bold

Brackets

Parentheses

Question 5 of 20

6. 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

Question 6 of 20

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

Backspace key

Formatting toolbar

Format painter

Default font

Question 7 of 20

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

View

Tools

Format

Edit

Question 8 of 20

9. In Excel default header for a worksheet is

None

The date and time

Your name

The sheet tab name

Question 9 of 20

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

Double clicking the format painter button

Pressing the Control key and clicking the format painter button

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

Pressing Alt key and clicking the format painter button

Question 10 of 20

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

Average

Table

Sum

Count

Question 11 of 20

12. In Excel the chart wizard

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

Can only place a chart on new chart sheet

Question 12 of 20

13. In Excel when you group worksheets

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

You can print more than one worksheet at a time

(B) and (C)

You can enter variable data on multiple worksheets at one time

Question 13 of 20

14. In Excel default header for a worksheet is

None

Your name

The sheet tab name

The date and time

Question 14 of 20

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

Network days

All of the above

Date

Workday

Question 15 of 20

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

Ignore

Change

Edit

Ignore all

Question 16 of 20

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

Dialog

Extension

Callout

Comment

Question 17 of 20

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

Ignore all

Change

Ignore

Edit

Question 18 of 20

19. 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

(A) and (B)

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

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

Question 19 of 20

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

Graphics

Word processing

Database

Spreadsheets

Question 20 of 20

Related Post

UPC MET 2023 Preparation Online Test Free Mock Test For…
SSC CGL Exams 2023 Test Preparation Online Practice Mock…
KVPY Exams 2023 Test Preparation Online Mock Test MCQs
CGTET Exams 2023 Test Preparation Online Mock Test MCQs
HTET Exams 2023 Test Preparation Online Mock Test MCQs
SNAP Exams 2023 Test Preparation Mock Test Online MCQs

Test By Subject	Computer Science
Test By Topics	Computer General

Have any Problem or Error please mention in below comments section.

2021-01-16

One comment

seema
June 10, 2021 at 8:28 am

very helpful question answer

Reply

Test Advisor

Microsoft Excel Test 1 Online MCQs