DAE COMP-142 CH-04 PART 2 MCQs

DAE | COMP-142

COMPUTER APPLICATIONS 

CHAPTER : 03

DIPLOMA OF ASSOCIATE ENGINEERING

EXAM PRAPARATION

COMMON WITH:

PRINTING & GRAPHIC ARTS

MULTIPLE CHOICE QUESTION

Chapter:04 (Microsoft Excel) | PART - 2

Question 21:

To enter data on a new line within a cell, the _____________ shortcut key is used.

Alt + Enter Ctrl + Enter Shift + Enter None of above

Question 22:

To enter the current date and time in a cell the _______________ function is used.

Now Today Date None of these

Question 23:

Example of Arithmetic operators is _________________.

> < = + - * / ^ And Or Not None of above

Question 24:

Example of Relational operators is _________________.

> < = + - * / ^ And Or Not None of above

Question 25:

Example of Logical operators is _________________.

> < = + - * / ^ And Or Not None of these

Question 26:

Identify the symbol for exponential power.

* / ^ =

Question 27:

Identify the symbol for multiplication.

* / ^ =

Question 28:

Identify the symbol for division.

* / ^ \

Question 29:

The correct example for addition is _________________.

A2 + B2 =add(A2,B2) SUM(A2,B2) =A2 + B2

Question 30:

The correct example of a cell address

11 22 911 15A A15

Question 31:

When you accidentally erased a record in a sheet, the ______________ command is used to restore.

Insert Copy Undo Replace

Question 32:

The example of formula is _________________.

=A1 + A2 =add(A1:A2) A1+A2 SUM(A1:A2)

Question 33:

The example of function is _________________.

=A1 + A2 =SUM(A1:A2) A1+A2 =add(A1:A2)

Question 34:

Which of the following option is correct?

= Average(2,3,4) = Average(A2:F2) = Average(A1, B1, C1) All of these

Question 35:

Which of the following is correct?

=Power(2^3) =Power(2,3) =Power(2#3) =Power(2*3)

Question 36:

The shortcut key to edit a cell entry is ______________.

F1 F2 F3 F4

Question 37:

The keyboard shortcut to open Format Cells dialogue box is __________.

Ctrl + 1 Ctrl + 2 Ctrl + 3 Ctrl + 4

Question 38:

Which types of charts can excel produce?

Line graphs and pie charts only Bar charts and line graphs only Bar charts, line graphs and pie charts Only line graphs

Question 39:

Which symbol is used in cells range?

; : “ ?

Question 40:

Correct example of cells range from A1 to F10 is _______________.

A1-F10 A1;F10 A1:F10 A1.F10

Quiz Results

Total Questions:

Correct Answers:

Incorrect Answers:

Percentage:

NOTE

If you find any mistake in them, do tell in the comment, so that it can be corrected.

If you face any issues feel free to contact me on WhatsApp
03129671316, 03085507292

If you want more improvement
Share feedback in the comment

INSTRUCTOR

MUHAMMAD BIN JAMEEL

BSC ENGG. CIVIL