QUIZ ON : ms-office - MS EXCEL

MS EXCEL

00:00:00

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

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

The spreadsheet file created by Excel is called

A. Workbook

B. Balance sheet

C. Presentation

D. Sheet document

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

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

A. Formula

B. Sorting

C. Filter

D. Pivot

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

Spreadsheets are created in ?

A. MS Word

B. MS Powerpoint

C. MS Excel

D. MS Access

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

The function ROUND(1343.45,-2) returns

A. 1343

B. -1343

C. -1300

D. 1300

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

An Excel file is generally called

A. E-Spreadsheet

B. Worksheet

C. Workbook

D. Sheet

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

Which of the following is not a text function?

A. CHAR()

B. VAR()

C. LEN()

D. PMT()

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

How many axis does chart in Calc have?

A. Two

B. Three

C. Two or Three

D. Four

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

All macro keyboard shortcuts include the ….. key

A. Alt

B. Ctrl

C. F11

D. Shift

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

Question No# : 37 out of 50

A function inside another function is called a function.

A. Nested

B. Round

C. Sum

D. Text

Question No# : 38 out of 50

Which symbol must all formula begin with?

A. =

B. +

C. (

D. @

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

What does SUMIF function do?

A. Adds up cell values based on a condition

B. Adds all the numbers in a range of cells

C. Returns a subtotal in a list or database

D. All of above

Question No# : 41 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# : 42 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# : 43 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# : 44 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# : 45 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# : 46 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# : 47 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# : 48 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# : 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

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