QUIZ ON : ms-office - MS EXCEL

MS EXCEL

00:00:00

Question No# : 01 out of 50

Which function can not be used for calculated controls in a report?

A. SUM

B. AVG

C. MPT

D. COUNT

Question No# : 02 out of 50

To center worksheet titles across a range of cell, you must

A. Select the cells containing the title text and use the fill handle to center

B. Widen the columns

C. column width

D. Row height

Question No# : 03 out of 50

Which functionin Excel checks whether a condition is true or not ?

A. SUM

B. IF

C. COUNT

D. AVERAGE

Question No# : 04 out of 50

To change the cell reference B4:B9 to an absolute cell reference, you would enter it as:

A. B4:B9

B. B$4:B$9

C. $B$4:$B$9

D. None of the above

Question No# : 05 out of 50

What do you use to create a chart?

A. Pie Wizard

B. Excel Wizard

C. Data Wizard

D. Chart Wizard

Question No# : 06 out of 50

The basic unit of a worksheet in which you enter the data in Excel is called a

A. cell

B. table

C. box

D. column

Question No# : 07 out of 50

What type of chart will you use to compare performance of two employees in the year 2016 ?

A. Column Chart

B. Line Chart

C. Pie Chart

D. Dot Chart

Question No# : 08 out of 50

In Excel, Rows are labelled as ______

A. A, B, C, etc

B. 1,2,3 etc

C. A1, A2, etc.

D. $A$1, $A$2, etc.

Question No# : 09 out of 50

What type of chart is useful for comparing parts of a whole ?

A. Pie Chart

B. Column Chart

C. Line Chart

D. Dot Graph

Question No# : 10 out of 50

In Excel, which one denoted a range from B1 through E5

A. B1 - E5

B. B1:E5

C. B1 to E5

D. B1$E5

Question No# : 11 out of 50

Which function Excel tells how many entries are there ?

A. row()

B. cell()

C. count()

D. total()

Question No# : 12 out of 50

To insert three columns between columns D and E you would

A. Select column D

B. Select column E

C. Select columns E, F and G

D. Select columns D, E, and F.

Question No# : 13 out of 50

To open the Format Cells dialog box, press

A. Ctrl + 1

B. Ctrl + 2

C. Ctrl + 3

D. Ctrl + 4

Question No# : 14 out of 50

The default page orientation in Excel is

A. Landscape

B. Horizontal

C. Portrait

D. None of the above

Question No# : 15 out of 50

Which of the following is not true about Find and Replace in Excel

A. You can search for bold and replace with italics

B. You can decide whether to look for the whole word or not

C. You can search in formula too

D. You can search by rows or columns or sheets

Question No# : 16 out of 50

Which area in an excel window allows entering values and formulas

A. Title bar

B. Menu bar

C. Formula bar

D. Standard toolbar

Question No# : 17 out of 50

While Finding and Replacing some data in Excel, which of the following statement is valid?

A. You can Find and Replace within the sheet or workbook

B. Excel does not have option to match case for find

C. Both are valid

D. None are valid

Question No# : 18 out of 50

Using the Cell Address $A4 within a formula in EXCEL means it is a?

A. Mixed cell reference

B. Absolute cell reference

C. Relative cell reference

D. All of the above

Question No# : 19 out of 50

Paste Special allows some operation while you paste to new cell. Which of the following operation is valid?

A. Square

B. Percentage

C. Goal Seek

D. Divide

Question No# : 20 out of 50

You can activate a cell by

A. Pressing the Tab key

B. Clicking the cell

C. Pressing an arrow key

D. All of above

Question No# : 21 out of 50

Which function will you use to enter current date & time in a worksheet cell?

A. =today()

B. =now()

C. =time()

D. =currentTime()

Question No# : 22 out of 50

Cell address A$4 in a formula means it is a

A. relative cell reference

B. absolute cell reference

C. mixed cell reference

D. All of the above

Question No# : 23 out of 50

Select the most appropriate statement for RAND() function.

A. RAND() returns random between 1 & 1

B. RAND() returns random between 0 & 1.

C. RAND() returns random between 0 & 100

D. RAND() returns random number.

Question No# : 24 out of 50

Which of the following you can paste selectively using Paste Special command?

A. Validation

B. Formats

C. Formulas

D. All of above

Question No# : 25 out of 50

To return the remainder after a number is divided by a divisor in EXCEL we use the function

A. ROUND ( )

B. FACT ( )

C. MOD ( )

D. DIV ( )

Question No# : 26 out of 50

You can add a hyperlink to your worksheet by pressing

A. Ctrl + H

B. Ctrl + K

C. Alt + K

D. Alt + H

Question No# : 27 out of 50

When all the numbers between 0 and 100 in a range should be displayed in Red Color, apply

A. Use =if() function to format the required numbers red

B. Apply Conditional Formatting command from style group on Home Tab

C. Select the cells that contain number between 0 and 100 then click Red color on Text Color tool

D. All of above

Question No# : 28 out of 50

Formatting a cell in Number format you can not set

A. Decimal Places

B. Use 1000 separator

C. Negative numbers

D. Currency Symbol

Question No# : 29 out of 50

How should you print a selected area of a worksheet, if you’ll want to print a different area next time?

A. On the file menu, point to print area, and then click set print area.

B. On the file menu, click print, and then click selection under print what

C. On the view menu, click custom views, then click add

D. All of above

Question No# : 30 out of 50

Which of the following is invalid statement in MS Excel?

A. Sheet tabs can be colored

B. Some picture can be applied as a background of a sheet

C. You can set the column width automatically fit the amount of text

D. The width of a row can be specified manually or fit automatically

Question No# : 31 out of 50

When you create a chart on a separate sheet in the same workbook it is called a

A. chart sheet

B. embedded chart

C. view sheet

D. view chart

Question No# : 32 out of 50

An Excel file is generally called

A. E-Spreadsheet

B. Worksheet

C. Workbook

D. Sheet

Question No# : 33 out of 50

To select several cells or ranges that are not touching each other, you would … while selecting

A. hold down the Ctrl key

B. hold down the Shift key

C. hold down the Alt key

D. hold down Ctrl + Shift key

Question No# : 34 out of 50

Functions in MS Excel must begin with ___

A. *

B. =

C. ()

D. {}

Question No# : 35 out of 50

What does the VLOOKUP function do?

A. Looks up text that contain â€˜vâ€™

B. Checks whether text is the same in one cell as in the next

C. Finds related records

D. All of above

Question No# : 36 out of 50

Which of the following setup options can not be set in the page setup dialog box?

A. Printer selection

B. Vertical or horizontal placement

C. Orientation

D. Row and column titles

Question No# : 37 out of 50

A quick way to return to a specific area of a worksheet is to type in the _____

A. Name box

B. Formula ba

C. Zoom box

D. None of these

Question No# : 38 out of 50

What type of chart is useful for comparing values over categories ?

A. Pie Chart

B. Column Chart

C. Line Chart

D. Dot Graph

Question No# : 39 out of 50

When you create a chart on a separate sheet in the same workbook it is called

A. chart sheet

B. embedded chart

C. view sheet

D. view chart

Question No# : 40 out of 50

Each excel file is called a workbook because

A. It can contain text and data.

B. It can be modified.

C. It can contain many sheets including worksheets chart sheets.

D. None of the above

Question No# : 41 out of 50

All functions begin with the formula prefix

A. @

B. =

C. #

D. +

Question No# : 42 out of 50

The function ROUND(1343.45,-2) returns

A. 1343

B. -1343

C. -1300

D. 1300

Question No# : 43 out of 50

The Name box

A. Shows the location of the previously active cell

B. Appears at the left of the formula bar

C. Appears below the status bar

D. Appears below the menu bar

Question No# : 44 out of 50

The default header for a worksheet is

A. Username

B. Date and Time

C. Sheet tab Name

D. None

Question No# : 45 out of 50

Which is not an option for customizing a datasheet window?

A. change one row’s height

B. hide one column

C. change one column’s width

D. freeze one column

Question No# : 46 out of 50

What happens if you do not apply = before formula in MS Excel?

A. Formula error

B. Has no effect

C. Formula does not work

D. A and B

Question No# : 47 out of 50

Statistical calculations and preparation of tables and graphs can be done using

A. Adobe Photoshop

B. Excel

C. Notepad

D. Power Point

Question No# : 48 out of 50

In Excel, by default Numeric Values appears in

A. Left aligned

B. Right aligned

C. Center aligned

D. Justify aligned

Question No# : 49 out of 50

You can check the conditions against __________ when applying conditional formatting

A. Cell value

B. Formula

C. Both of above

D. None of above

Question No# : 50 out of 50

=ROUND(2.15,1) entered in a cell displays

A. 2

B. 2.1

C. 2.2

D. none of the above