QUIZ ON : ms-office - MS EXCEL

MS EXCEL

00:00:00

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

The Cell Address $B$4 in 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# : 12 out of 50

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

A. 98

B. 97

C. 91

D. None

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

How many sheets are there in Excel Workbook by default?

A. 2

B. 3

C. 4

D. 5

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

An Excel file is generally called

A. E-Spreadsheet

B. Worksheet

C. Workbook

D. Sheet

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

Which of the following is an absolute cell reference?

A. !A!1

B. $A$1

C. #a#1

D. A1

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

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# : 27 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# : 28 out of 50

Which symbol must all formula begin with?

A. =

B. +

C. (

D. @

Question No# : 29 out of 50

The function ROUND(1343.45,-2) returns

A. 1343

B. -1343

C. -1300

D. 1300

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

Extension of Excel file is...

A. .TMT

B. .XXL

C. .xls

D. None of the above

Question No# : 32 out of 50

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

A. ######

B. $$$$

C. ??????

D. 00000000

Question No# : 33 out of 50

Spreadsheets are created in ?

A. MS Word

B. MS Powerpoint

C. MS Excel

D. MS Access

Question No# : 34 out of 50

Which function is used for finding the square root of any number in MS EXCEL?

A. SQR

B. SQRT

C. MOD

D. MODE

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

The default page orientation in Excel is

A. Landscape

B. Horizontal

C. Portrait

D. None of the above

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

To return the remainder after a number is divided by a divisor in EXCEL we use the function

A. ROUND ( )

B. FACT ( )

C. MOD ( )

D. DIV ( )

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

What are the columns in a Microsoft access table called?

A. Rows

B. Fields

C. Records

D. Columns

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