QUIZ ON : ms-office - MS EXCEL

MS EXCEL

00:00:00

Question No# : 01 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# : 02 out of 50

Hyperlinks cannot be

A. Special shapes like stars and banners

B. Drawing objects like rectangles ovals

C. Pictures

D. All can be hyperlinks

Question No# : 03 out of 50

Functions in MS Excel must begin with ___

A. *

B. =

C. ()

D. {}

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

The following is not a vailid Cell Address.

A. Sheet1!A1:c1

B. Sheet1,1BC10

C. Sheet2!HH77

D. Sheet3!DF6780

Question No# : 06 out of 50

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

A. SUM

B. IF

C. COUNT

D. AVERAGE

Question No# : 07 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# : 08 out of 50

You can use the horizontal and vertical scroll bars to

A. Split a worksheet into two panes

B. View different rows and columns

C. Edit the contents of a cell

D. View different worksheets

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

Which of the following is a chart type present in MS Excel

A. Bubble

B. Satellite

C. Both

D. None

Question No# : 11 out of 50

How many axis does chart in Calc have?

A. Two

B. Three

C. Two or Three

D. Four

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

What are the columns in a Microsoft access table called?

A. Rows

B. Fields

C. Records

D. Columns

Question No# : 15 out of 50

Red triangle at the top right corner of a cell indicates

A. There is an error in the cell

B. There is a comment associated with the cell

C. The font color of the text in cell is red

D. The cell canâ€™t accept formula

Question No# : 16 out of 50

The auto calculate feature

A. Can only add values in a range of cells

B. Provides a quick way to view the result of an arithmetic operation on a ra

C. Automatically creates formulas and adds them to a worksheet

D. A and c

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

What term refers to a specific set of values saved with the workbook?

A. Range

B. Scenario

C. rend line

D. What-if analysis

Question No# : 19 out of 50

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

A. 98

B. 97

C. 91

D. None

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

The default header for a worksheet is

A. Username

B. Date and Time

C. Sheet tab Name

D. None

Question No# : 22 out of 50

When the formula bar is activated, you can see

A. The Edit Formula button

B. The Cancel button

C. The Enter button

D. All of above

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

Extension of Excel file is...

A. .TMT

B. .XXL

C. .xls

D. None of the above

Question No# : 27 out of 50

Pie charts can be plotted on

A. multiple data series only

B. only two data series

C. only one data series

D. exactly eight data series

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

Each excel file is called a workbook because.

A. It contains text and data Restarting

B. It can be modified

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

D. It can be used for calculation

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

Which symbol must all formula begin with?

A. =

B. +

C. (

D. @

Question No# : 34 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# : 35 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# : 36 out of 50

The purpose of AutoFormat command in Excel is to

A. create a professional and consistent look for your data

B. choose between standard table formats that include borders,shading, font

C. easily apply a consistent format throughout a workbook

D. All of the above

Question No# : 37 out of 50

Spreadsheets are created in ?

A. MS Word

B. MS Powerpoint

C. MS Excel

D. MS Access

Question No# : 38 out of 50

The default page orientation in Excel is

A. Landscape

B. Horizontal

C. Portrait

D. None of the above

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

You can copy data or formulas

A. With the copy, paste and cut commands on the edit menu

B. With commands on a shortcut menu

C. With buttons on the standard toolbar

D. All of the above

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

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

A. Formula

B. Sorting

C. Filter

D. Pivot

Question No# : 45 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# : 46 out of 50

Which of the following features is not seen in the EXCEL APPLICATION?

A. Goal Seek

B. Mail Merge

C. Filter

D. None of the above

Question No# : 47 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# : 48 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# : 49 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# : 50 out of 50

Which of the following is an absolute cell reference?

A. !A!1

B. $A$1

C. #a#1

D. A1