MS Excel - MS Excel question with answers
Computer fundamental question with answer
No: 1
Q. All formulas in excel starts with ?
A. =
No : 2
Q. On an excel sheet the active cell in indicated by ?
A. A dark wide border
No: 3
Q. Transpose
describes explanatory text attached to a cell ?
A. Comment
No: 4
Q. How we can view a cell comment ?
A. position the mouse pointer over the cell
No: 5
Q. How we will select all the cells in a document ?
A. Pressing Ctrl + A, Using the Edit – Select All menu
No: 6
Q. The default style for new data keyed in a new workbook is ?
A. Normal
No: 7
Q. If you press ___, the cell accepts your typing as its contents ? (Tab, Ctrl+Enter, Enter, Alt+Enter)
A. Enter
No: 8
Q. Which keyboard shortcut can be used for creating a chart from the selected cells ?
A. F11
No: 9
Q. Formula palette is used to ?
A. create and edit formulas containing functions
No: 10
Q. A value used in a formula that does not change is called?
A. Constant
No: 11
Q. A spreadsheet contains ?(Columns, Rows, Rows and Columns ,None of these)
A. Rows and Columns
No: 12
Q. To open an existing workbook, click the Open button on the ___ toolbar ?
A. Standard
No: 13
Q. Which is not associated with spelling dialogue box ?(Edit, Ignore, Ignore All, Change)
A. Edit
No: 14
Q. What term describes a background that appears as a grainy, non smooth surface ?
A. Gradient
No: 15
Q. Which among these is associated with excel ?(Graphic program, Word Processor, Word Processor, Spreadsheet)
A. Spreadsheet
No: 16
Q. The cell reference for a range of cells that starts in cell C1 and goes over to column H and down to row 10 is ?
A. C1:H10
No: 17
Q. You can convert existing Excel worksheet data and charts to HTML document by using the ?
A. Internet Assistant Wizard
No: 18
Q. To create an interactive Pivot Table for the web, you use a Microsoft Office Web component called ?
A. Pivot Table Report
No: 19
Q. Which function displays row data in a column or column data in a row ?(Transpose, Index, Rows, Hyperlinks)
A. Transpose
No: 20
Q. Except which of the following function, a formula with a logical function shows the word 'TRUE'' or 'FALSE' as a result ?
A. IF
No: 21
Q. Macros can be executed from which of these ?(Format, Home, Insert, Tools)
A. Tools
No: 22
Q. Protection and Protect Sheet options can be selected from ?(Data, Tools, Edit, Format)
A. Tools
No: 23
Q. Which of these is not a valid Zoom percentage in Excel ?(10, 100, 300, 500)
A. 500
No: 24
Q. You can check the conditions against ____ when applying conditional formatting ?
A. Cell Value, Formula
No: 25
Q. How can we set Page Border in Excel ?
A. You can not set page border in Excel
No: 26
Q. Which function calculates your monthly mortage payment ?(PV, NPER, PMT)
A. PMT
No: 27
Q. Which types of charts can excel produce ?
A. Bar charts, line graphs and pie charts
No: 28
Q. How is data organized in a spreadsheet ?
A. Rows and columns
No: 29
Q. VLOOKUP function used to ?
A. Finds related records
No: 30
Q. Gridlines may be turned off for display but turned on for printing?(True, False)
A. TRUE
No: 31
Q. How do we change column width to fit the contents ?
A. Double click the boundary to the right of the column heading
No: 32
Q. How to insert three columns between columns A and B ?(Select column A, Select A and B, Select B)
A. Select B
No: 33
Q. How to drag a selected range of data to another worksheet in the same workbook?
A. Ctrl key
No: 34
Q. You can activate a cell by ?(Pressing the Tab key, Clicking the cell, Pressing the Tab key)
A. All of these
No: 35
Q. A function inside another function is known as ?
A. Nested function
No: 36
Q. What excel feature can we use if we want to work with one record at a time ?
A. Data Form
No: 37
Q. Which function is used for creating a data table ?(Sum, Table, Add, Count)
A. Table
No: 38
Q. The accounting style shows negative numbers in ?(Bold, Italics, Parentheses, Quotes)
A. Parentheses
No: 39
Q. 3 - D reference in a formula ?
A. Spans worksheets
No: 40
Q. Auto calculate feature provides a quick way to view the results of an arithmetic operation on a range of cells?
A. TRUE
No: 41
Q. Wildcard characters are recognized by excel ?( + and - , ! and ^ , * and ? , < and > )
A. * and ?
No: 42
Q. Which one is divide symbol in excel ?( //, D, Div, \)
A. /
No: 43
Q. Which function in excel counts the numbers of characters in a cell ?(LENGTH, LGT, LT, LEN)
A. LEN
No: 44
Q. Which function converts miles to kilometers ?(Change, Covnert, Shift, Conv)
A. Covnert
No: 45
Q. What is shortcut to enter current date in cell in excel ?( Ctrl + ;, Alt + ;, Shift + &, Ctrl + $)
A. Ctrl + ;
No: 46
Q. Shortcut to edit the selected cell ?(F3, F8, F4, F2)
A. F2
No: 47
Q. Each excel can contain many sheets including worksheets and chart sheets?(TRUE, FALSE)
A. TRUE
No: 48
Q. Which shortcut can be used to Switch between open workbooks ?
A. Ctrl + F6
No: 49
Q. Which shortcut to delete the selected column ?
A. Ctrl + -
No: 50
Q. Shortcut to enter current date ?(Home + ; , Shift + ; , Alt + ; , Ctrl + ;)
A. Ctrl + ;
No: 51
Q. What can we see when the formula bar is activated?
A. The Edit Formula button, The Cancel button,The Enter button
No: 52
Q. Style sheet formats can be applied from ?
A. Format >> Autoformat
No: 53
Q. Which function will you use to enter current time in a woksheet cell ?
A. 43327.7366466435
No: 54
Q. Merge cells option can be applied from ?
A. Format Cells dialog box Alignment Tab
No: 55
Q. How many recent files we can display on File menu at maximum ?
A. 9
No: 56
Q. The name box appears at the ?
A. left of the formula bar
No: 57
Q. Entire worksheet can not be selected in one time?(True, False)
A. FALSE
No: 58
Q. Where are the status indicators located ?
A. Formula bar
No: 59
Q. Insert picture option is in which toolbars ?(Standard, Formatting, Drawing, Picture)
A. Picture
No: 60
Q. What term refers to a specific set of values saved with the workbook ?
A. Scenario
No: 61
Q. We can cancel marquee by pressing ?(Ctrl + Esc, Alt + Esc, Shift + Esc, Esc)
A. Esc
No: 62
Q. Which of the method cannot be used to edit the content of cell ?
A. Pressing the Alt key
No: 63
Q. When we use multiplication, division or exponentiation in a formula then there is chance of occurring rounding errors
A. TRUE
No: 64
Q. What can't be considered as worksheet criterion ?(Efficiency, Auditability, Clarity,Description)
A. Description
No: 65
Q. When creating a vertical page break ?
A. The active cell must be in row 1
No: 66
Q. The intersection of row and column is called a ?(dataset, cell, data, set)
A. cell
No: 67
Q. You will use which feature in excel, if you want to work with one record at a time ?
A. Data Form
No: 68
Q. Which dialogue box we can use to name a constant ?
A. Define Name
No: 69
Q. One cell format can be copied to another cell by using ?
A. Format Painter
No: 70
Q. Which among following is types of excel data types ?
A. Numbers, Formulas, Labels
No: 71
Q. To join some cells and place the content at the middle of joined cell, which tool you will use?
A. Click on Merge and Center tool on formatting toolbar
No: 72
Q. On Excel screen, Tab scroll buttons are?
A. towards the bottom left corner
No: 73
Q. Which is not the correct method of editing the cell content ?
A. Press the Alt key
No: 74
Q. In Excel Worksheet how can you show or hide the gridlines ?
A. Click Gridline tool on Forms toolbar, Go to Tools - > Options - > View tab and mark or remove the check box named Gridline
No: 75
Q. When we press Ctrl + X after selecting some cells in Excel, what will happen then?
A. The cells selected are marked for cutting
No: 76
Q. In Paste Special dialog box, which of the following option is not available ?
A. Square root
No: 77
Q. To convert a column of data into row, which command will we choose?
A. Edit - > Paste Special - > Transpose
No: 78
Q. Using Paste Special command what can we paste selectively?
A. Formulas,Validation & Formats
