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

Given on this page below is a free online quiz about Microsoft Excel keyboard shortcut keys which can be extremely helpful for you in testing your level of knowledge about the computer program. We strongly suggest that you attempt this test as well as the other tests related to it which are available on our website as questions related to various software are often part of different written exams and interviews.

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

• <<
• 1
• 2
• 3
• 4
• 5
• 6
• 7
• 8
• 9
• 10
• 11
• 12
• 13
• 14
• 15
• 16
• 17
• 18
• 19
• 20
• >>

Computer General

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

1024

256

128

512

 Loading...

Question 1 of 20

2. In Excel chart wizard term data series refers to

A chart legend

A data label

A collection of chart data markers

A set of values you plot in a chart

 Loading...

Question 2 of 20

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

Updating

Functioning

Referencing

Accessing

 Loading...

Question 3 of 20

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

Serial Number 50771

May 10, 2001

350

57&per cent;

 Loading...

Question 4 of 20

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

10+50

=B7+14

=B7*B1

=10+50

 Loading...

Question 5 of 20

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

Exclamation (!)

Hash (#)

Ampersand (&)

Apostrophe (‘)

 Loading...

Question 6 of 20

7. In Excel worksheet range is a

A command used for data modeling

A group of cells

A range of values such as from 23 to 234

A group of worksheets

 Loading...

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 final menu, click the sheet tab, and make a selection under the print heading.

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

All of above

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

 Loading...

Question 8 of 20

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

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

All of above

View the sum in the formula bar

Click subtotals on the data menu

 Loading...

Question 9 of 20

10. In Excel to delete an embedded objects, first

Select the object by clicking it

Press the Shift + Delete keys

Select it and then press the delete key

Double click the object

 Loading...

Question 10 of 20

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

1024

256

32000

65535

 Loading...

Question 11 of 20

12. In Excel Tab scrolling button

Allow you to view additional sheets tabs

Allow you to view a different worksheet

Allow you to view additional worksheet rows down

Allow you to view additional worksheet columns to the right

 Loading...

Question 12 of 20

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

32000

1024

65535

256

 Loading...

Question 13 of 20

14. In Excel comments can be added to cells using

File > Comments

Edit > Comments

View > Comments

Insert > Comments

 Loading...

Question 14 of 20

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

A1

$A$1

#a#1

!A!1

 Loading...

Question 15 of 20

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

Aditibility

Description

Efficiency

Clarity

 Loading...

Question 16 of 20

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

= (equal)

_ (underscore)

‘ (apostrophe)

“ (quote)

 Loading...

Question 17 of 20

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

=SUM(A1:A5)-10

=SUM(A1:A5)*.5

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

=SUM(Sales)-A3

 Loading...

Question 18 of 20

19. In Excel Chart wizard term data categories refers to

A chart plot area

A horizontal axis

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

The data range that supply chart data

 Loading...

Question 19 of 20

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

@

+

=

(

 Loading...

Question 20 of 20

 Loading...