Computer MS Excel Shortcuts Keys Test 3 Online

Maan AliLast Updated: October 12, 2025

Computer MS Excel Shortcuts Keys Test 3

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

Page 1 of 1

1. In Excel suppose you have columns of data that span more than one printed page. How can you automatically print the column headings on each page?

Click page setup on the final menu, click the sheet tab, and make a selection under the print heading.

Click page setup on the file menu, click the sheet tab, and enter the row that contains these column headings under print titles.

Click page setup on the file menu, click the page tab, click the options button, then enter your choices.

All of above

2. In Excel the following is not an example of a value

57&per cent;

Serial Number 50771

May 10, 2001

350

3. In Excel Tab scrolling button

Allow you to view additional worksheet rows down

Allow you to view additional worksheet columns to the right

Allow you to view a different worksheet

Allow you to view additional sheets tabs

4. In Excel Chart wizard term data categories refers to

The organization of individual values with a chart’s data series

The data range that supply chart data

A horizontal axis

A chart plot area

5. In Excel a fast way to add up this column of number is to click in the cell below the numbers and then

View the sum in the formula bar

Click the autosum button on the standard toolbar, then press enter

All of above

Click subtotals on the data menu

6. In Excel what symbol is used before a number to make it a label?

‘ (apostrophe)

“ (quote)

_ (underscore)

= (equal)

7. In Excel numeric value can be treated as a label value if it precedes with

Apostrophe (‘)

Hash (#)

Exclamation (!)

Ampersand (&)

8. In Excel worksheet range is a

A command used for data modeling

A group of worksheets

A range of values such as from 23 to 234

A group of cells

9. In Excel comments can be added to cells using

Edit > Comments

File > Comments

Insert > Comments

View > Comments

10. In Excel which of the following formulas is not entered correctly?

=B7*B1

10+50

=10+50

=B7+14

11. In Excel to delete an embedded objects, first

Press the Shift + Delete keys

Select it and then press the delete key

Double click the object

Select the object by clicking it

12. In Excel chart wizard term data series refers to

A collection of chart data markers

A set of values you plot in a chart

A chart legend

A data label

13. In Excel which of the following formulas will Excel not be able to calculate?

=SUM(Sales)-A3

=SUM(A1:A5)*.5

=SUM(A1:A5)/(10-10)

=SUM(A1:A5)-10

14. In Excel getting data from a cell located in a different sheet is called

Functioning

Updating

Referencing

Accessing

15. In Excel typical worksheet has …. Number of columns

1024

256

512

128

16. In Excel which symbol must all formula begin with?

(

17. In Excel how many characters can be typed in a single cell?

65535

1024

32000

256

18. In Excel worksheet can have a maximum of …. Number of rows

32000

65535

256

1024

19. In Excel which of the following is an absolute cell reference?

!A!1

#a#1

$A$1

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

Description

Efficiency

Aditibility

Clarity

More Related Resources

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

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

Maan AliLast Updated: October 12, 2025

very informative test and very hard also but i am enjoying to solve and it is increasing my knowledge very well.

Computer MS Excel Shortcuts Keys Test 3 Online

Computer MS Excel Shortcuts Keys Test 3

Computer MS Excel Shortcuts Keys Test 3 Practice Online

More Related Resources

Maan Ali

One Comment

Leave a Reply Cancel reply

Computer MS Excel Shortcuts Keys Test 3

Computer MS Excel Shortcuts Keys Test 3 Practice Online

More Related Resources

Latest Updates

Maan Ali

One Comment

Leave a Reply Cancel reply