QUIZ ON : ms-office - MS EXCEL

MS EXCEL

00:00:00

Question No# : 01 out of 50

How are data organized in a spreadsheet?

A. Lines and spaces

B. Layers and planes

C. Rows and columns

D. Height and width

Question No# : 02 out of 50

Short cut key for edit cell content in MS Excel is

A. Press the F2 key

B. Click the formula bar

C. Double click the cell

D. All of the Above

Question No# : 03 out of 50

The cell reference for cell range of G2 to M12 is

A. G2.M12

B. G2;M12

C. G2:M12

D. G2-M12

Question No# : 04 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# : 05 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# : 06 out of 50

Which of the following series type is not valid for Fill Series dialog box?

A. Linear

B. Growth

C. Autofill

D. Time

Question No# : 07 out of 50

MS Excel provides the default value for step in Fill Series dialog box

A. 0

B. 1

C. 5

D. 10

Question No# : 08 out of 50

Which of the following methods can not be used to enter data in a cell?

A. Pressing an arrow key

B. Pressing the tab key

C. Pressing the Esc key

D. Clicking the enter button to the formula bar

Question No# : 09 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# : 10 out of 50

Which of the following formulas is not entered correctly?

A. =10+50

B. =B7*B1

C. B7+14

D. 10+50

Question No# : 11 out of 50

Formatting a cell in Currency, you can specify

A. Decimal Places

B. Currency Symbol

C. Both of above

D. None of above

Question No# : 12 out of 50

In a spreadsheet, a statement that performs a calculation is called a(n)

A. Argument

B. Reference

C. Formula

D. Parameter

Question No# : 13 out of 50

You can use the format painter multiple times before you turn it off by

A. You can use the format painter button only one time when you click it

B. Double clicking the format painter button

C. Pressing the Ctrl key and clicking the format painter button

D. Pressing Alt key and clicking the format painter button

Question No# : 14 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# : 15 out of 50

The ____ feature of MS Excel quickly completes a series of data

A. Auto Complete

B. Auto Fill

C. Fill Handle

D. Sorting

Question No# : 16 out of 50

What is entered by the function =today()

A. The date value for the day according to system clock

B. The time value according to system clock

C. Today’s date as Text format

D. All of above

Question No# : 17 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# : 18 out of 50

A features that displays only the data ,according to specified criteria

A. Formula

B. Sorting

C. Filter

D. Pivot

Question No# : 19 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# : 20 out of 50

A function inside another function is called a function.

A. Nested

B. Round

C. Sum

D. Text

Question No# : 21 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# : 22 out of 50

The report footer section is most useful for displaying:

A. grand totals

B. Column headings

C. subtotals

D. page numbers

Question No# : 23 out of 50

Text function is used for?

A. To Convert text to number

B. To convert numbers to text

C. To Convert date to number

D. To Convert number to date

Question No# : 24 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# : 25 out of 50

Which is not a command that is selectable from right click menu of a field column?

A. Hide columns

B. Unhide columns

C. freeze columns

D. sort descending

Question No# : 26 out of 50

How many axis does chart in Calc have?

A. Two

B. Three

C. Two or Three

D. Four

Question No# : 27 out of 50

Bar charts can be plotted on

A. Multiple data series

B. Only two data series

C. Only one data series

D. None of the above

Question No# : 28 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# : 29 out of 50

On an excel sheet the active cell in indicated by ?

A. A dotted border

B. A dark wide border

C. A blinking border

D. By italic text

Question No# : 30 out of 50

Excel uniquely identifies cells within a worksheet with a cell name

A. Cell names

B. Column numbers and row letters

C. Column letters and row numbers

D. Cell locator coordinates

Question No# : 31 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# : 32 out of 50

Which of the following is not a valid spreadsheet function?

A. Sum()

B. Avg()

C. Product()

D. None of these

Question No# : 33 out of 50

ROUND(1363.45,-2) returns

A. 1400

B. -1364

C. 1363.45

D. 1464

Question No# : 34 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# : 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

= What will be the value of Ceiling (97,7)?

A. 98

B. 97

C. 91

D. None

Question No# : 37 out of 50

In Excel, Columns 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# : 38 out of 50

Short cut key for go to Previous Cell

A. Ctrl + Tab

B. Tab

C. Shift + Tab

D. Alt + Tab

Question No# : 39 out of 50

Which language is used to create macros in Excel?

A. Visual basic

B. C

C. Visual C ++

D. Java

Question No# : 40 out of 50

The process of arrenging the items of a column in some sequence or order is known as :

A. Arrengin

B. Autofill

C. Sorting

D. Filtering

Question No# : 41 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# : 42 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# : 43 out of 50

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

A. SUM

B. IF

C. COUNT

D. AVERAGE

Question No# : 44 out of 50

Which types of charts can excel produce?

A. Line graphs and pie charts only

B. Only line graphs

C. Bar charts, line graphs and pie charts

D. Bar charts and line graphs only

Question No# : 45 out of 50

To move to the previous worksheet, press

A. Alt + PgUp

B. Ctrl + PgUp

C. Ctrl + PgDn

D. Shift + Tab

Question No# : 46 out of 50

The formula used in excel to find Remainder

A. rmind( )

B. mod( )

C. div( )

D. reminder( )

Question No# : 47 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# : 48 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

Question No# : 49 out of 50

The default header for a worksheet is

A. Username

B. Date and Time

C. Sheet tab Name

D. None

Question No# : 50 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