Practice MCQ MS-Excel

Page 1 of 50, Total 481 results. | Shuffle Order | Flagged | Next Page
601 Comments can be added to cells using …..
Options: Edit -> Comments B. Insert -> Comment     C. File -> Comments D. View –> Comments

Show Answer
Loading Facebook Comment system, Please wait...
Loading Facebook Comment system, Please wait...
602 Which menu option can be used to split windows into two?
Options: Format -> Window B. View -> Window-> Split C. Window -> Split D. View –> Split

Show Answer
Loading Facebook Comment system, Please wait...
Loading Facebook Comment system, Please wait...
603 Getting data from a cell located in a different sheet is called….
Options: Accessing B. Referencing C. Updating D. Functioning

Show Answer
Loading Facebook Comment system, Please wait...
Loading Facebook Comment system, Please wait...
604 Which of the following is not a valid data type in Excel?
Options: Number B. Character C. Label D. Date/Time

Show Answer
Loading Facebook Comment system, Please wait...
Loading Facebook Comment system, Please wait...
605 Which elements of a worksheet can be protected from accidental modification?
Options: Contents B. Objects C. Scenarios D. All of the above

Show Answer
Loading Facebook Comment system, Please wait...
Loading Facebook Comment system, Please wait...
606 A numeric value can be treated as label value if …… precedes it.
Options: Apostrophe (‘) B. Exclamation (!) C. Hash (#) D. Tilde (~)

Show Answer
Loading Facebook Comment system, Please wait...
Loading Facebook Comment system, Please wait...
607 Concatenation of text can be done using
Options: Apostrophe (‘) B. Exclamation (!) C. Hash (#) D. Ampersand (&)

Show Answer
Loading Facebook Comment system, Please wait...
Loading Facebook Comment system, Please wait...
608 Which area in an Excel window allows entering values and formulas?
Options: Title Bar B. Menu Bar C. Formula Bar D. Standard Tool Bar

Show Answer
Loading Facebook Comment system, Please wait...
Loading Facebook Comment system, Please wait...
609 . Multiple calculations can be made in a single formula using…..
Options: Standard Formulas B. Array Formula C. Complex Formulas D. Smart Formula

Show Answer
Loading Facebook Comment system, Please wait...
Loading Facebook Comment system, Please wait...
610 An Excel Workbook is a collection of …….
Options: Workbooks B. Worksheets C. Charts D. Worksheets and Charts

Show Answer
Loading Facebook Comment system, Please wait...
Loading Facebook Comment system, Please wait...
611 What do you mean by a Workspace?
Options: Group of Columns B. Group of Worksheets C. Group of Rows D. Group of Workbooks

Show Answer
Loading Facebook Comment system, Please wait...
Loading Facebook Comment system, Please wait...
612 MS-EXCEL is based on ……….?
Options: WINDOWS B. DOS C. UNIX D. OS/2

Show Answer
Loading Facebook Comment system, Please wait...
Loading Facebook Comment system, Please wait...
613 In EXCEL, you can sum a large range of data by simply selecting a tool button called …..?
Options: AutoFill B. Auto correct C. Auto sum D. Auto format

Show Answer
Loading Facebook Comment system, Please wait...
Loading Facebook Comment system, Please wait...
614 To select an entire column in MS-EXCEL, press?
Options: CTRL + C B. CTRL + Arrow key C. CTRL + S D. None of the above

Show Answer
Loading Facebook Comment system, Please wait...
Loading Facebook Comment system, Please wait...
615 To return the remainder after a number is divided by a divisor in EXCEL we use the function?
Options: ROUND ( ) B. FACT ( ) C. MOD ( ) D. DIV ( )

Show Answer
Loading Facebook Comment system, Please wait...
Loading Facebook Comment system, Please wait...
616 Which function is not available in the Consolidate dialog box?
Options: Pmt B. Average C. Max D. Sum

Show Answer
Loading Facebook Comment system, Please wait...
Loading Facebook Comment system, Please wait...
617 Which is not the function of “Edit, Clear” command?
Options: Delete contents B. Delete notes C. Delete cells D. Delete formats

Show Answer
Loading Facebook Comment system, Please wait...
Loading Facebook Comment system, Please wait...
618 Microsoft Excel is a powerful………..
Options: Word processing package B. Spreadsheet package C. Communication S/W Package D. DBMS package

Show Answer
Loading Facebook Comment system, Please wait...
Loading Facebook Comment system, Please wait...
619 . How do you rearrange the data in ascending or descending order?
Options: Data, Sort B. Data, Form C. Data, Table D. Data Subtotals

Show Answer
Loading Facebook Comment system, Please wait...
Loading Facebook Comment system, Please wait...
620 Which Chart can be created in Excel?
Options: Area B. Line C. Pie D. All of the above

Show Answer
Loading Facebook Comment system, Please wait...
Loading Facebook Comment system, Please wait...
621 What will be the output if you format the cell containing 5436.8 as ‘#,##0.00’?
Options: 5,430.00 B. 5,436.80 C. 5,436.8 D. 6.8

Show Answer
Loading Facebook Comment system, Please wait...
Loading Facebook Comment system, Please wait...
622 How do you display current date and time in MS Excel?
Options: date () B. Today () C. now () D. time ()

Show Answer
Loading Facebook Comment system, Please wait...
Loading Facebook Comment system, Please wait...
623 How do you display current date only in MS Excel?
Options: date () B. Today () C. now () D. time ()

Show Answer
Loading Facebook Comment system, Please wait...
Loading Facebook Comment system, Please wait...
624 How do you wrap the text in a cell?
Options: Format, cells, font B. Format, cells, protection C. format, cells, number D. Format, cells, alignment

Show Answer
Loading Facebook Comment system, Please wait...
Loading Facebook Comment system, Please wait...
625 What does COUNTA () function do?
Options: counts cells having alphabets B. counts empty cells C. counts cells having number D. counts non-empty cells

Show Answer
Loading Facebook Comment system, Please wait...
Loading Facebook Comment system, Please wait...
626 What is the short cut key to highlight the entire column?
Options: Ctrl+C B. Ctrl+Enter C. Ctrl+Page Up D. Ctrl+Space Bar

Show Answer
Loading Facebook Comment system, Please wait...
Loading Facebook Comment system, Please wait...
627 In the formula, which symbol specifies the fixed columns or rows?
Options: $ B. * C. % D. &

Show Answer
Loading Facebook Comment system, Please wait...
Loading Facebook Comment system, Please wait...
628 Excel displays the current cell address in the ……….
Options: Formula bar B. Status Bar C. Name Box D. Title Bar

Show Answer
Loading Facebook Comment system, Please wait...
Loading Facebook Comment system, Please wait...
629 . What is the correct way to refer the cell A10 on sheet3 from sheet1?
Options: sheet3!A10 B. sheet1!A10 C. Sheet3.A10 D. A10

Show Answer
Loading Facebook Comment system, Please wait...
Loading Facebook Comment system, Please wait...
630 Which language is used to create macros in Excel?
Options: Visual Basic B. C C. Visual C++ D. Java

Show Answer
Loading Facebook Comment system, Please wait...
Loading Facebook Comment system, Please wait...
631 Which of the following is not a term of MS-Excel?
Options: Cells B. Rows C. Columns D. Document

Show Answer
Loading Facebook Comment system, Please wait...
Loading Facebook Comment system, Please wait...
632 How many worksheets can a workbook have?
Options: 3 B. 8 C. 255 D. none of above

Show Answer
Loading Facebook Comment system, Please wait...
Loading Facebook Comment system, Please wait...
633 Which would you choose to create a bar diagram?
Options: Edit, Chart B. Insert, Chart C. Tools, Chart D. Format, Chart

Show Answer
Loading Facebook Comment system, Please wait...
Loading Facebook Comment system, Please wait...
634 Which setting you must modify to print a worksheet using letterhead?
Options: Paper B. Margin C. Layout D. Orientation

Show Answer
Loading Facebook Comment system, Please wait...
Loading Facebook Comment system, Please wait...
635 What do you call the chart that shows the proportions of how one or more data elements relate to another data element?
Options: XY Chart B. Line Chart C. Pie Chart D. Column Chart

Show Answer
Loading Facebook Comment system, Please wait...
Loading Facebook Comment system, Please wait...
636 The spelling dialog box can be involved by choosing spelling from ________ menu.
Options: insert B. file C. tools D. view

Show Answer
Loading Facebook Comment system, Please wait...
Loading Facebook Comment system, Please wait...
637 Which key do you press to check spelling?
Options: F3 B. F5 C. F7 D. F9

Show Answer
Loading Facebook Comment system, Please wait...
Loading Facebook Comment system, Please wait...
638 To record a sequence of keystrokes and mouse actions to play back later we use:
Options: Media player B. Sound Recorder C. Calculator D. Macro Recorder

Show Answer
Loading Facebook Comment system, Please wait...
Loading Facebook Comment system, Please wait...
639 . We can save and protect the workbook by
Options: Write Reservation Password B. Protection Password C. Read-only Recommended D. Any of the above

Show Answer
Loading Facebook Comment system, Please wait...
Loading Facebook Comment system, Please wait...
640 The first cell in EXCEL worksheet is labeled as
Options: AA B. A1 C. Aa D. A0

Show Answer
Loading Facebook Comment system, Please wait...
Loading Facebook Comment system, Please wait...
641 What happens when dollar signs ($) are entered in a cell address? (ex. $B$2:$B$10)
Options: An absolute cell address is created. B. Cell address will change when it is copied to another cell. C. The sheet tab is changed. D. The status bar does not display the cell address.

Show Answer
Loading Facebook Comment system, Please wait...
Loading Facebook Comment system, Please wait...
642 What are the tabs that appear at the bottom of each workbook called?
Options: Reference tabs B. Position tabs C. Location tabs D. Sheet tabs

Show Answer
Loading Facebook Comment system, Please wait...
Loading Facebook Comment system, Please wait...
643 What is represented by the small, black square in the lower-right corner of an active cell or range?
Options: Copy handle B. Fill handle C. Insert handle D. Border

Show Answer
Loading Facebook Comment system, Please wait...
Loading Facebook Comment system, Please wait...
644 In Excel, a Data Series is defined as what?
Options: A type of chart. B. A cell reference. C. A collection of related data D. A division of results

Show Answer
Loading Facebook Comment system, Please wait...
Loading Facebook Comment system, Please wait...
645 In Excel, the Fill Color button on the Formatting toolbar is used for what?
Options: To insert a background. B. To add borders. C. To select a distribution of figures. D. To add shading or color to a cell range.

Show Answer
Loading Facebook Comment system, Please wait...
Loading Facebook Comment system, Please wait...
646 In help menu of Excel, which of the following tabs are found?
Options: Contents tab B. Answer Wizard tab C. Index tab D. all of the above.

Show Answer
Loading Facebook Comment system, Please wait...
Loading Facebook Comment system, Please wait...
647 A __________ is a grid with labeled columns and rows.
Options: Dialog box B. Worksheet C. Clipboard D. Toolbar

Show Answer
Loading Facebook Comment system, Please wait...
Loading Facebook Comment system, Please wait...
648 The active cell:
Options: is defined by a bold border around the cell. B. Receives the data the user enters. C. It is the formula bar. D. Only A and B.

Show Answer
Loading Facebook Comment system, Please wait...
Loading Facebook Comment system, Please wait...
649 . Which function is used to calculate depreciation, rates of return, future values and loan payment amounts?
Options: Logical B. Math & Trigonometry C. Statistical D. Financial

Show Answer
Loading Facebook Comment system, Please wait...
Loading Facebook Comment system, Please wait...
650 B7:B9 indicates:
Options: Cells B7 and cell B9 only. B. Cells B7 through B9. C. Cell B8 only. D. None of the above.

Show Answer
Loading Facebook Comment system, Please wait...
Loading Facebook Comment system, Please wait...
www.000webhost.com