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

Computer General

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

Range

Constant

Function

Cell address

Question 1 of 20

2. 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?

Data marker

Category axis

Gridline

Data point

Question 2 of 20

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

Shift key

None of above

End key

Esc key

Question 3 of 20

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

Edit

Data

Format

Tools

Question 4 of 20

5. In Excel you can use the formula palette to

Copy a range of cells

Entered assumptions data

Create and edit formulas containing functions

Format cells containing numbers

Question 5 of 20

6. In Excel how can you delete a record?

Select Data > Delete Record from the menu

Click the Delete button on the Standard toolbar

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

Delete the column from the worksheet

Question 6 of 20

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

123

WK1

DOC

XLS

Question 7 of 20

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

F11

F5

F7

F3

Question 8 of 20

9. Right clicking something in Excel

Nothing the right mouse button is there for left handed people

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

Deletes the object

Selects the object

Question 9 of 20

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

TAB

Insert

Ctrl + Enter

Enter

Question 10 of 20

11. In Excel Documentation should include

Destination and users of the output data

All of the above

Information on the purpose of the workbook

Source of input data

Question 11 of 20

12. In Excel the auto fill feature

Extends a sequential series of data

None of above

Automatically adds a range of cell values

Applies a boarder around selected cells

Question 12 of 20

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

There is nt suitable abbreviation of the text

Data will be entered in the adjacent cells

There is not time to format the next

No data will be entered in the adjacent cells

Question 13 of 20

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

Add cell contents

(A) and (B)

Move cell contents

Copy cell contents

Question 14 of 20

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

Data Form

Auto Filter

Auto Complete

Sub Totals

Question 15 of 20

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

Tools

Insert

Format

Edit

Question 16 of 20

17. In Excel 3-D reference in a formula

Only appears on summary worksheets

Cannot be modified

Spans worksheets

Limits the formatting options

Question 17 of 20

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

Description

Efficiency

Auditability

Clarity Correct Answer:

Question 18 of 20

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

Contents

Scenarios

Objects

All of above

Question 19 of 20

20. In Excel the auto calculate feature

Automatically creates formulas and adds them to a worksheet

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

Can only add values in a range of cells

None of the above

Question 20 of 20

Test Instructions
Test Name	:	MS Excel Test 2
Subject	:	Computer General
Test Type	:	Mcqs
Total Question	:	20
Total Marks	:	40
Total Time	:	20 Minutes

Gotest

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

Test Instructions

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

Computer General

You Might Also Like

Latest Jobs in Pakistan




All Daily Jobs in Pakistan click here