Computer MS Excel Shortcuts Keys Test 3 Online

Q: How can I prepare for Computer MS Excel Shortcuts Keys Test 3 Online?

You can prepare for Computer MS Excel Shortcuts Keys Test 3 Online by attempting the free online quizzes at Gotest.com.pk. We provide instant results, performance reports, and detailed explanations for every question.

Question 1

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

Answer

Exclamation (!)

Answer

Apostrophe (‘)

Answer

Ampersand (&)

Question 2

2. In Excel Chart wizard term data categories refers to

Answer

The data range that supply chart data

Answer

A chart plot area

Answer

A horizontal axis

Answer

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

Question 3

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

Answer

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

Answer

All of above

Answer

View the sum in the formula bar

Answer

Click subtotals on the data menu

Question 4

4. In Excel to delete an embedded objects, first

Answer

Select it and then press the delete key

Answer

Select the object by clicking it

Answer

Double click the object

Answer

Press the Shift + Delete keys

Question 5

5. In Excel chart wizard term data series refers to

Answer

A chart legend

Answer

A collection of chart data markers

Answer

A set of values you plot in a chart

Answer

A data label

Question 6

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

Answer

=SUM(Sales)-A3

Answer

=SUM(A1:A5)-10

Answer

=SUM(A1:A5)*.5

Answer

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

Question 7

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

Question 8

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

Question 9

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

Answer

_ (underscore)

Answer

“ (quote)

Answer

‘ (apostrophe)

Question 10

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

Answer

Aditibility

Answer

Efficiency

Answer

Description

Question 11

11. In Excel comments can be added to cells using

Answer

View > Comments

Answer

Edit > Comments

Answer

Insert > Comments

Answer

File > Comments

Question 12

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

Question 13

13. In Excel Tab scrolling button

Answer

Allow you to view additional worksheet rows down

Answer

Allow you to view additional sheets tabs

Answer

Allow you to view a different worksheet

Answer

Allow you to view additional worksheet columns to the right

Question 14

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

Answer

All of above

Answer

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

Answer

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

Answer

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

Question 15

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

Question 16

16. In Excel worksheet range is a

Answer

A range of values such as from 23 to 234

Answer

A group of worksheets

Answer

A group of cells

Answer

A command used for data modeling

Question 17

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

Answer

Referencing

Answer

Functioning

Question 18

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

Answer

Serial Number 50771

Answer

57&per cent;

Answer

May 10, 2001

Question 19

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

Question 20

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

Question 21

Loading...

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 Online

Computer MS Excel Shortcuts Keys Test 3

Computer MS Excel Shortcuts Keys Test 3 Practice Online

Study Plan for Computer MS Excel Shortcuts Keys Test 3 Online

How to Use GoTest for Preparation:

You May Also Like

Maan Ali

One Comment

Leave a Reply Cancel reply