MS Excel mcq Questions and Answer | Microsoft Excel-8

excel-8

Please wait while the activity loads.
If this activity does not load, try refreshing your browser. Also, this page requires javascript. Please visit using a browser with javascript enabled.

If loading fails, click here to try again

Question 1

Microsoft Excel Is a powerful...........

A	1) Word processing package
B	(2) Spreadsheet package
C	(3) Communication S/W Package ,
D	(4) DBMS package

Question 2

. How do you rearrange the data In ascending or descending order?

A	(1) Data, Sort
B	(2) Data, Form
C	(3) Data, Table
D	(4) Data Subtotals

Question 3

Which Chart can be created in Excel?

A	(1) Area
B	(2) Line
C	(3) Pie
D	(4) All of the above

Question 4

What will be the output If you format the cell containing 5436.8 as '#,##0.00'?

A	(1) 5,430.00
B	(2) 5,436.80.
C	(3) 5,436.8
D	(4) 6.8

Question 5

How do you display current date and time In MS Excel?

A	(1) date( )
B	(2) Today ( )
C	(3) now( )
D	(4) time( )

Question 6

How do you display current date only in MS Excel?

A	(1) date ( )
B	(2) Today ( )
C	(3) now( )
D	(4) time()

Question 7

How do you wrap the text in a cell?

A	(1) Format, cells, font
B	(2) Format, cells, protection
C	(3) format, cells, number
D	(4) Format cells, alignment

Question 8

What does COUNTA ( ) function do?

A	(1) counts cells having alphabets
B	(2) counts empty eel Is
C	(3) counts cells having number
D	(4) counts non-empty cells

Question 9

. What Is the short cut key to highlight the entire column?

A	(1) Ctrl+C
B	(2) Ctrl+Enter
C	(3) Ctrl+PageUp
D	(4) Ctrl+SpaceBar

Question 10

. In the formula, which symbol specifies the fixed columns or rows?

A	(1) A.S
B	(2) *
C	(3) %
D	(4) &

Question 11

. Excel displays the current cell address In the..........

A	(1) Formula bar
B	(2) Status Bar
C	(3) Name Box
D	(4) Title Bar

Question 12

What Is the correct way to refer the cell AID on sheets from sheetl?

A	(1) sheet3IA10
B	(2) sheetllAlO
C	(3) Sheets-A10
D	(4) A10

Question 13

.Which language is used to create macros in Excel?

A	(1) Visual Basic 4
B	(2) C
C	(3) Visual C++
D	(4) Java

Question 14

Which of the following is not a term of MS-Excel?

A	(1) Cells
B	(2) Rows
C	(3) Columns
D	(4) Document

Question 15

. How many worksheets can a workbook have?

A	(1) 3
B	(2) 8
C	(3) 255
D	(4) All of above

Question 16

Which would you choose to create a bar diagram?

A	(1) Edit, Chart
B	(2) Insert, Chart
C	(3) Tools, Chart
D	(4) Format, Chart

Question 17

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

A	(1) Paper
B	(2) Margin
C	(3) Layout
D	(4) Orientation

Question 18

What do you call the chart that shows the proportions of how one or more data elements relate to another data element?

A	(1) XY Chart
B	(2) Line Chart
C	(3) Pie Chart
D	(4) Column Chart

Question 19

The spelling dialog box can be involved by choosing spelling from ___ menu.

A	(1) insert
B	(2) file
C	(3) tools
D	(4) view

Question 20

. Which key do you press to check spelling?

A	(1) F3
B	(2) F5
C	(3) F7
D	(4) F9

Question 21

To record a sequence of keystrokes and mouse actions to play back later we use:

A	(1) Media player
B	(2) Sound Recorder
C	(3) Calculator
D	(4) Macro Recorder

Question 22

We can save and protect 1he workbook by

A	(1) Write Reservation Password
B	(2) Protection Password
C	(3) Read-only Recommended
D	(4) Any of the above

Question 23

The first cell in EXCEL worksheet is labeled as

A	(1) A
B	(2) A1
C	(3) Aa
D	(4) AO

Question 24

What happens when dollar signs (S) are entered In a cell address?

A	(1) An absolute eel I address is created.
B	(2) Cell address will change when it is copied to another cell.
C	3) The sheet tab is changed.
D	(4) The status bar does not display the eel I address.

Question 25

What are the tabs that appear at the bottom of each workbook called?

A	(1) Reference tabs
B	(2) Position tabs
C	(3) Location tabs
D	(4) Sheet tabs

Question 26

What is represented by the small, black square in the lower-right corner of an active cell or range?

A	(1) Copy handle
B	(2) Fill handle
C	(3) Insert handle
D	(4) Border

Question 27

. In Excel, a Data Series is defined as what?

A	(1) A type of chart.
B	(2) A eel I reference.
C	(3) A collection of related data
D	(4) Adivision of results

Question 28

. In Excel, the Fill Color button on the Formatting toolbar is used for what?

A	(1) To insert a background.
B	(2) To add borders.
C	(3) To select a distribution of figures.
D	(4) To add shading or color to a cell range.

Question 29

. In help menu of Excel, which of the following tabs are found?

A	(1) Contents tab
B	(2) Answer Wizard tab
C	(3) Index tab
D	(4) all of the above

Question 30

A ______is a grid with labeled columns and rows.

A	(1) Dialog box
B	(2) Worksheet
C	(3) Clipboard
D	(4) Toolbar

Question 31

The active cell:

A	(1) is defined by a bold border around the ceil.
B	(2) Receives the data the user enters.
C	(3) It is the formula bar.
D	(4) Only A and B

Question 32

.Which function Is used to calculate depreciation, rates of return, future values and loan payment amounts?

A	(1) Logical
B	(2) Math & Trigonometry
C	(3) Statistical
D	(4) Financial

Question 33

B7:B9 indicates:

A	(1) Cells B7 and cell B9 only.
B	2) Cells B7 through B9.
C	(3) Cell BSonly.
D	(4) None of the a bove.

Question 34

The Cancel and Enter buttons appear In the:

A	(1) Title bar
B	(2) Formula bar
C	(3) Menu bar
D	(4) Sheet tabs

Question 35

. MS-EXCEL can be used to automate

A	(1) Financial statements. Business forecasting
B	(2) Transaction registers, inventory control
C	(3) Accounts receivable, accounts payable
D	(4) Any of the above

Question 36

. NOT, AND, OR and XOR are

A	(1) Logical Operators
B	(2) Arithmetic operators
C	(3) Relational operators
D	(4) None of the above

Question 37

. In a report, you need to show the monthly rainfall in Nepal. The best way to do this is to insert a

A	(1) calendar
B	(2) photograph of rainfall
C	(3) chart showing rainfall amounts
D	(4) data base of rainfall

Question 38

You want to record experiment information and create a chart that shows the rate of crystal growth over a period of time. The best application to use would be:

A	(1) word processing
B	(2) spreadsheet
C	(3) database
D	(4) graphics

Question 39

You are editing an worksheet that you had previously saved. If you want to save the edited sheet without losing the original one, which Command should you use?