MS Excel mcq Questions and Answer | Microsoft Excel-8
excel-8
MS Excel mcq Questions and Answer | Microsoft Excel-8
Question 1
Microsoft Excel Is a powerful...........
1) Word processing package
(2) Spreadsheet package
(3) Communication S/W Package ,
(4) DBMS package
Question 2
. How do you rearrange the data In ascending or descending order?
(1) Data, Sort
(2) Data, Form
(3) Data, Table
(4) Data Subtotals
Question 3
Which Chart can be created in Excel?
(1) Area
(2) Line
(3) Pie
(4) All of the above
Question 4
What will be the output If you format the cell containing 5436.8 as '#,##0.00'?
(1) 5,430.00
(2) 5,436.80.
(3) 5,436.8
(4) 6.8
Question 5
How do you display current date and time In MS Excel?
(1) date( )
(2) Today ( )
(3) now( )
(4) time( )
Question 6
How do you display current date only in MS Excel?
(1) date ( )
(2) Today ( )
(3) now( )
(4) time()
Question 7
How do you wrap the text in a cell?
(1) Format, cells, font
(2) Format, cells, protection
(3) format, cells, number
(4) Format cells, alignment
Question 8
What does COUNTA ( ) function do?
(1) counts cells having alphabets
(2) counts empty eel Is
(3) counts cells having number
(4) counts non-empty cells
Question 9
. What Is the short cut key to highlight the entire column?
(1) Ctrl+C
(2) Ctrl+Enter
(3) Ctrl+PageUp
(4) Ctrl+SpaceBar
Question 10
. In the formula, which symbol specifies the fixed columns or rows?
(1) A.S
(2) *
(3) %
(4) &
Question 11
. Excel displays the current cell address In the..........
(1) Formula bar
(2) Status Bar
(3) Name Box
(4) Title Bar
Question 12
What Is the correct way to refer the cell AID on sheets from sheetl?
(1) sheet3IA10
(2) sheetllAlO
(3) Sheets-A10
(4) A10
Question 13
.Which language is used to create macros in Excel?
(1) Visual Basic 4
(2) C
(3) Visual C++
(4) Java
Question 14
Which of the following is not a term of MS-Excel?
(1) Cells
(2) Rows
(3) Columns
(4) Document
Question 15
. How many worksheets can a workbook have?
(1) 3
(2) 8
(3) 255
(4) All of above
Question 16
Which would you choose to create a bar diagram?
(1) Edit, Chart
(2) Insert, Chart
(3) Tools, Chart
(4) Format, Chart
Question 17
Which setting you must modify to print a worksheet using letterhead?
(1) Paper
(2) Margin
(3) Layout
(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?
(1) XY Chart
(2) Line Chart
(3) Pie Chart
(4) Column Chart
Question 19
The spelling dialog box can be involved by choosing spelling from ___ menu.
(1) insert
(2) file
(3) tools
(4) view
Question 20
. Which key do you press to check spelling?
(1) F3
(2) F5
(3) F7
(4) F9
Question 21
To record a sequence of keystrokes and mouse actions to play back later we use:
(1) Media player
(2) Sound Recorder
(3) Calculator
(4) Macro Recorder
Question 22
We can save and protect 1he workbook by
(1) Write Reservation Password
(2) Protection Password
(3) Read-only Recommended
(4) Any of the above
Question 23
The first cell in EXCEL worksheet is labeled as
(1) A
(2) A1
(3) Aa
(4) AO
Question 24
What happens when dollar signs (S) are entered In a cell address?
(1) An absolute eel I address is created.
(2) Cell address will change when it is copied to another cell.
3) The sheet tab is changed.
(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?
(1) Reference tabs
(2) Position tabs
(3) Location tabs
(4) Sheet tabs
Question 26
What is represented by the small, black square in the lower-right corner of an active cell or range?
(1) Copy handle
(2) Fill handle
(3) Insert handle
(4) Border
Question 27
. In Excel, a Data Series is defined as what?
(1) A type of chart.
(2) A eel I reference.
(3) A collection of related data
(4) Adivision of results
Question 28
. In Excel, the Fill Color button on the Formatting toolbar is used for what?
(1) To insert a background.
(2) To add borders.
(3) To select a distribution of figures.
(4) To add shading or color to a cell range.
Question 29
. In help menu of Excel, which of the following tabs are found?
(1) Contents tab
(2) Answer Wizard tab
(3) Index tab
(4) all of the above
Question 30
A ______is a grid with labeled columns and rows.
(1) Dialog box
(2) Worksheet
(3) Clipboard
(4) Toolbar
Question 31
The active cell:
(1) is defined by a bold border around the ceil.
(2) Receives the data the user enters.
(3) It is the formula bar.
(4) Only A and B
Question 32
.Which function Is used to calculate depreciation, rates of return, future values and loan payment amounts?
(1) Logical
(2) Math & Trigonometry
(3) Statistical
(4) Financial
Question 33
B7:B9 indicates:
(1) Cells B7 and cell B9 only.
2) Cells B7 through B9.
(3) Cell BSonly.
(4) None of the a bove.
Question 34
The Cancel and Enter buttons appear In the:
(1) Title bar
(2) Formula bar
(3) Menu bar
(4) Sheet tabs
Question 35
. MS-EXCEL can be used to automate
(1) Financial statements. Business forecasting
(2) Transaction registers, inventory control
(3) Accounts receivable, accounts payable
(4) Any of the above
Question 36
. NOT, AND, OR and XOR are
(1) Logical Operators
(2) Arithmetic operators
(3) Relational operators
(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
(1) calendar
(2) photograph of rainfall
(3) chart showing rainfall amounts
(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:
(1) word processing
(2) spreadsheet
(3) database
(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?
(1) New
(2) Save As
(3) Edit
(4) Save
Question 40
. If you want to have a blank line after the title in a worksheet, what is the best thing for you to do?
(1) Re-format the spreadsheet
(2) Insert a row
(3) Increase the column width
(4) Use the spacebar
There are 40 questions to complete.
