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 the auto calculate feature

None of the above

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

Automatically creates formulas and adds them to a worksheet

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

Function

Range

Cell address

Constant

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

F11

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

Clarity Correct Answer:

Description

Auditability

Efficiency

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

Format

Edit

Tools

Insert

6. In Excel you can use the formula palette to

Entered assumptions data

Create and edit formulas containing functions

Format cells containing numbers

Copy a range of cells

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

None of above

Shift key

End key

Esc key

8. 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 nt suitable abbreviation of the text

Data will be entered in the adjacent cells

There is not time to format the next

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

Scenarios

All of above

Objects

Contents

10. In Excel 3-D reference in a formula

Only appears on summary worksheets

Spans worksheets

Limits the formatting options

Cannot be modified

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

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

123

XLS

WK1

DOC

13. In Excel Documentation should include

Destination and users of the output data

All of the above

Source of input data

Information on the purpose of the workbook

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

Format

Data

Edit

Tools

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

(A) and (B)

Copy cell contents

Move cell contents

Add cell contents

16. In Excel the auto fill feature

None of above

Extends a sequential series of data

Applies a boarder around selected cells

Automatically adds a range of cell values

17. Right clicking something in Excel

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

Deletes the object

Selects the object

Nothing the right mouse button is there for left handed people

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

Insert

Enter

TAB

Ctrl + Enter

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

Auto Complete

Data Form

Auto Filter

Sub Totals

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

Data marker

Gridline

Category axis

More Related Resources

NTS NAT & GAT Computer Science... MS Excel Shortcuts Keys Information... Computer MS Excel Shortcuts Keys Te... Computer MS Excel Shortcuts Keys Te...

Can't find what you're looking for? Search below:

Latest Updates

NTS NAT & GAT Computer Science MCQs (Solved Past Papers)
MS Excel Shortcuts Keys Information Test Online
Computer MS Excel Shortcuts Keys Test 1 Online
Computer MS Excel Shortcuts Keys Test 3 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

More Related Resources

Maan Ali

One Comment

Leave a Reply Cancel reply