DAE COMP-142 CH-04 PART 3 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 - 3

Question 41:

You can copy cell formats from one cell to another by using the _______.

Backspace key Default Format painter Formatting toolbar

Question 42:

A value used in a formula that does not change is called ______________.

Cell address Constant Function Range

Question 43:

Which formula can add all the numeric values in a range of cells?

Count Average Sum If

Question 44:

To insert two columns between column C and D you would ___________.

select column C select column D select column C, D, E select column D, E, F

Question 45:

The default extension of MS Excel file is ______________.

xlsx xlw xcl exl

Question 46:

A diagram or graph that shows information in a simple way

picture graph chart clipart

Question 47:

Which function in Excel tells how many numeric entries are there?

Num Count Sum PI

Question 48:

What type of chart will you use to compare performance of two cricket team in a match?

Line Chart Pie Chart Column Chart Dot Chart

Question 49:

The process of arranging the items of a column in some sequence is known as

arranging sorting filtering auto fill

Question 50:

The __________ feature of MS Excel quickly completes a series of data.

Auto Fill Auto Complete Sorting Filtering

Question 51:

What type of chart will you use to compare performance of sales of four products?

Column Chart Line Chart Pie Chart Bubble Chart

Question 52:

The keyboard shortcut to get printout of an Excel sheet is _____________.

Ctrl + E Ctrl + P Ctrl + R Ctrl + T

Question 53:

If you require more than one hard copies of the worksheet, then enter it in_______________ field.

Number of Copies Copies Copy none of above

Question 54:

You can print ________________.

Selection An entire workbook A single worksheet All of these

Question 55:

To exit from MS Excel program the

Alt + F4 Ctrl + F4 Shift + F4 Alt + Ctrl + F4

Question 56:

A ______________ is a temporary storage area for data that the user wants to cut or copy from one place to another.

clipboard master board mother board circuit board

Question 57:

A ____________ is more efficient than formulas.

Chart Sorting Function None of these

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