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

Computer General

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

Question 1 of 20

2. In Excel to delete an embedded objects, first

Press the Shift + Delete keys

Select it and then press the delete key

Select the object by clicking it

Double click the object

Question 2 of 20

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

Functioning

Referencing

Accessing

Updating

Question 3 of 20

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

Hash (#)

Exclamation (!)

Apostrophe (‘)

Ampersand (&)

Question 4 of 20

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

=B7+14

10+50

=10+50

=B7*B1

Question 5 of 20

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

128

256

512

1024

Question 6 of 20

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

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

=SUM(A1:A5)*.5

=SUM(A1:A5)-10

=SUM(Sales)-A3

Question 7 of 20

8. 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 file menu, click the sheet tab, and enter the row that contains these column headings under print titles.

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

All of above

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

Question 8 of 20

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

‘ (apostrophe)

= (equal)

“ (quote)

_ (underscore)

Question 9 of 20

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

1024

32000

256

65535

Question 10 of 20

11. In Excel comments can be added to cells using

View > Comments

Edit > Comments

File > Comments

Insert > Comments

Question 11 of 20

12. In Excel worksheet range is a

A group of worksheets

A command used for data modeling

A range of values such as from 23 to 234

A group of cells

Question 12 of 20

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

Clarity

Efficiency

Aditibility

Description

Question 13 of 20

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

256

1024

65535

32000

Question 14 of 20

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

All of above

Click subtotals on the data menu

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

View the sum in the formula bar

Question 15 of 20

16. In Excel Tab scrolling button

Allow you to view additional worksheet rows down

Allow you to view additional sheets tabs

Allow you to view a different worksheet

Allow you to view additional worksheet columns to the right

Question 16 of 20

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

May 10, 2001

Serial Number 50771

350

57&per cent;

Question 17 of 20

18. In Excel chart wizard term data series refers to

A set of values you plot in a chart

A chart legend

A collection of chart data markers

A data label

Question 18 of 20

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

#a#1

A1

!A!1

$A$1

Question 19 of 20

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

@

+

=

(

Question 20 of 20

Test Instructions
Test Name	:	MS Excel Test 3
Subject	:	Computer General
Test Type	:	Mcqs
Total Question	:	20
Total Marks	:	40
Total Time	:	20 Minutes

Gotest

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

Test Instructions

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

Computer General

You Might Also Like

Latest Jobs in Pakistan




All Daily Jobs in Pakistan click here