QUIZ ON : ms-office - MS EXCEL

MS EXCEL

00:00:00

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

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

A. 98

B. 97

C. 91

D. None

Question No# : 04 out of 50

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

A. Group

B. Margin

C. Section

D. Orientation

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

To open the Format Cells dialog box, press

A. Ctrl + 1

B. Ctrl + 2

C. Ctrl + 3

D. Ctrl + 4

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

An Excel file is generally called

A. E-Spreadsheet

B. Worksheet

C. Workbook

D. Sheet

Question No# : 12 out of 50

Functions in MS Excel must begin with ___

A. *

B. =

C. ()

D. {}

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

Spreadsheets are created in ?

A. MS Word

B. MS Powerpoint

C. MS Excel

D. MS Access

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

To select a column in excel the easiest method is to ?

A. Click on column Name

B. click on column

C. click on column range

D. all of the above

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

Which of the following methods cannot be used to edit the content of cell?

A. Pressing the Alt key

B. Clicking the formula bar

C. Pressing F2

D. Double clicking the cell

Question No# : 24 out of 50

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

A. SUM

B. IF

C. COUNT

D. AVERAGE

Question No# : 25 out of 50

ROUND(1363.45,-2) returns

A. 1400

B. -1364

C. 1363.45

D. 1464

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

What will be the value of mod (50, -7)?

A. 6

B. -6

C. 1

D. -1

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

The function ROUND(1343.45,-2) returns

A. 1343

B. -1343

C. -1300

D. 1300

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

What function displays row data in a column or column data in a row?

A. Hyperlink

B. Index

C. Transpose

D. Rows

Question No# : 36 out of 50

Which function Excel tells how many entries are there ?

A. row()

B. cell()

C. count()

D. total()

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

The formula used in excel to find Remainder

A. rmind( )

B. mod( )

C. div( )

D. reminder( )

Question No# : 39 out of 50

What is the shortcut key to insert a new sheet in current workbook?

A. F11

B. Alt+F11

C. Shift+F11

D. Ctrl+F11

Question No# : 40 out of 50

The default header for a worksheet is

A. Username

B. Date and Time

C. Sheet tab Name

D. None

Question No# : 41 out of 50

Which of following is not a component of the Libre office Suite ?

A. Writer

B. Impress

C. Internet Explorer

D. Base

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

MS-EXCEL can be used to automate

A. Financial statements, Business forecasting

B. Transaction registers, inventory control

C. Accounts receivable, accounts payable

D. Any of the above

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

Extension of Excel file is...

A. .TMT

B. .XXL

C. .xls

D. None of the above

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

What are the columns in a Microsoft access table called?

A. Rows

B. Fields

C. Records

D. Columns