QUIZ ON : ms-office - MS EXCEL

MS EXCEL

00:00:00

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

The function ROUND(1343.45,-2) returns

A. 1343

B. -1343

C. -1300

D. 1300

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

Which of the following is not a valid data type in excel

A. Number

B. Text

C. Label

D. Date

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

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# : 15 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# : 16 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# : 17 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# : 18 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# : 19 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# : 20 out of 50

When a formatted number does not fit within a cell, it displays

A. ######

B. $$$$

C. ??????

D. 00000000

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

What type of chart is useful for showing trends or changes over time ?

A. Pie Chart

B. Column Chart

C. Line Chart

D. Dot Graph

Question No# : 25 out of 50

Which of the following displays the contents of the active cell?

A. Active cell

B. Formula bar

C. Menu bar

D. Name box

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

Which symbol must all formula begin with?

A. =

B. +

C. (

D. @

Question No# : 30 out of 50

Which of the following describes how to select all the cells in a single column?

A. Right click on column and select Pick from list

B. Use data â€“ text to columns menu item

C. Left click on the gray column title button

D. Pressing Ctrl + A on the keyboard

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

Which setting you must modify to print a report using letterhead?

A. Group

B. Margin

C. Section

D. Orientation

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

Extension of Excel file is...

A. .TMT

B. .XXL

C. .xls

D. None of the above

Question No# : 35 out of 50

The simplest way to select a column in MS Excel is to

A. Selecting the Column With the Mouse

B. Selecting a range of columns

C. Click on the column name

D. all of the abobe

Question No# : 36 out of 50

What is the intersection of a column and a row on a worksheet called ?

A. Column

B. Address

C. Value

D. Cell

Question No# : 37 out of 50

Short cut key for go to Previous Cell

A. Ctrl + Tab

B. Tab

C. Shift + Tab

D. Alt + Tab

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

A collection of worksheets is called as

A. Excel Sheets

B. Workbook

C. Excel worksheets

D. Excel Book

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

Which language is used to create macros in Excel?

A. Visual basic

B. C

C. Visual C ++

D. Java

Question No# : 42 out of 50

To paste text from the clipboard in the document being edited, press the keys

A. Ctrl+P

B. Ctrl+V

C. Ctrl+X

D. Ctrl+C

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

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

To move to the previous worksheet, press

A. Alt + PgUp

B. Ctrl + PgUp

C. Ctrl + PgDn

D. Shift + Tab

Question No# : 50 out of 50

Greek word sigma is used for what in excel?

A. Word count

B. Number count

C. Auto sum

D. All of the above