Home/Computer/Computer MS Excel Shortcuts Keys Test 2 Online

Computer MS Excel Shortcuts Keys Test 2 Online

Maan AliLast Updated: October 12, 2025

Computer MS Excel Shortcuts Keys Test 2

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 2 Practice Online

Please wait...

Page 1 of 1

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

Scenarios

Objects

Contents

All of above

2. Right clicking something in Excel

Deletes the object

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

Nothing the right mouse button is there for left handed people

Selects the object

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

Insert

Ctrl + Enter

TAB

Enter

4. In Excel you can use the formula palette to

Create and edit formulas containing functions

Format cells containing numbers

Copy a range of cells

Entered assumptions data

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

WK1

XLS

DOC

123

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

Auditability

Clarity Correct Answer:

Efficiency

Description

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

Delete the column from the worksheet

Select Data > Delete Record from the menu

Click the Delete button on the Standard toolbar

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

Esc key

End key

None of above

Shift key

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

F11

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

Add cell contents

Move cell contents

(A) and (B)

Copy cell contents

11. In Excel 3-D reference in a formula

Only appears on summary worksheets

Limits the formatting options

Spans worksheets

Cannot be modified

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

Tools

Format

Edit

Insert

13. In Excel the auto fill feature

None of above

Extends a sequential series of data

Automatically adds a range of cell values

Applies a boarder around selected cells

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

Gridline

Data marker

Data point

Category axis

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

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

Data will be entered in the adjacent cells

No data will be entered in the adjacent cells

There is not time to format the next

There is nt suitable abbreviation of the text

17. In Excel Documentation should include

Information on the purpose of the workbook

Destination and users of the output data

Source of input data

All of the above

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

Tools

Edit

Data

Format

19. In Excel the auto calculate feature

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

Automatically creates formulas and adds them to a worksheet

None of the above

Can only add values in a range of cells

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

Function

Cell address

Constant

Range

You Can Learn and Gain more Knowledge through our Online Quiz and Testing system Just Search your desired Preparation subject at Gotest.

Introduction to Computers Online Test
Computer File Handling in “C” Test Online
Computer Functions in “C” Test Online
Computer Loop Constructs Test Online
Computer Decision Constructs Test Online
Computer Input Output Test Online
Computer Elements of “C” Test Online
Computer Getting Started with “C” Test Online
Computer Microsoft Access-Forms and Reports Test Online
Computer Table and Query Test Online

Maan AliLast Updated: October 12, 2025

Imran Khan says:

May 20, 2017 at 4:54 pm

Dear Question 4 answer is “CONSTANT”

Computer MS Excel Shortcuts Keys Test 2 Online

Computer MS Excel Shortcuts Keys Test 2

Computer MS Excel Shortcuts Keys Test 2 Practice Online

Related Posts

Maan Ali

One Comment

Leave a Reply Cancel reply