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

Given on this page below is a free online quiz about Microsoft Excel keyboard shortcut keys which can be extremely helpful for you in testing your level of knowledge about the computer program. We strongly suggest that you attempt this test as well as the other tests related to it which are available on our website as questions related to various software are often part of different written exams and interviews.

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

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

Computer General

1. In Excel 3-D reference in a formula

Limits the formatting options

Only appears on summary worksheets

Cannot be modified

Spans worksheets

 Loading...

Question 1 of 20

2. In Excel you can use the formula palette to

Create and edit formulas containing functions

Copy a range of cells

Format cells containing numbers

Entered assumptions data

 Loading...

Question 2 of 20

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

Copy cell contents

Add cell contents

Move cell contents

(A) and (B)

 Loading...

Question 3 of 20

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

All of above

Contents

Scenarios

Objects

 Loading...

Question 4 of 20

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

Range

Cell address

Constant

Function

 Loading...

Question 5 of 20

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

No data will be entered in the adjacent cells

There is not time to format the next

Data will be entered in the adjacent cells

There is nt suitable abbreviation of the text

 Loading...

Question 6 of 20

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

Insert

Ctrl + Enter

Enter

TAB

 Loading...

Question 7 of 20

8. In Excel the auto calculate feature

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

None of the above

Automatically creates formulas and adds them to a worksheet

Can only add values in a range of cells

 Loading...

Question 8 of 20

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

Insert

Edit

Tools

Format

 Loading...

Question 9 of 20

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

Sub Totals

Data Form

Auto Complete

Auto Filter

 Loading...

Question 10 of 20

11. In Excel the auto fill feature

Applies a boarder around selected cells

None of above

Automatically adds a range of cell values

Extends a sequential series of data

 Loading...

Question 11 of 20

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

Data

Edit

Format

Tools

 Loading...

Question 12 of 20

13. In Excel how can you delete a record?

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

Select Data > Delete Record from the menu

Delete the column from the worksheet

Click the Delete button on the Standard toolbar

 Loading...

Question 13 of 20

14. In Excel Documentation should include

All of the above

Destination and users of the output data

Information on the purpose of the workbook

Source of input data

 Loading...

Question 14 of 20

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

Description

Efficiency

Auditability

Clarity Correct Answer:

 Loading...

Question 15 of 20

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

DOC

WK1

123

XLS

 Loading...

Question 16 of 20

17. 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 point

Gridline

Data marker

Category axis

 Loading...

Question 17 of 20

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

F3

F11

F5

F7

 Loading...

Question 18 of 20

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

None of above

End key

Esc key

Shift key

 Loading...

Question 19 of 20

20. Right clicking something in Excel

Deletes the object

Nothing the right mouse button is there for left handed people

Selects the object

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

 Loading...

Question 20 of 20

 Loading...