Ms Excel questions/ MS Excel MCQ
Ms Excel MCQ
1] What is the short cut key to replace a data with another in sheet?
A. "Ctrl + R"
B. "Ctrl + Shift + R"
C. "Ctrl + H"
D. "Ctrl + F"
Correct answer is: Option C
2] You can auto fit the width of column by
A. double clicking on the column name on column header
B. Double click on the cell pointer in worksheet
C. Double clicking on column right border on column header
D. Double clicking on the column left border of column header
Correct answer is: Option C
3] What is the short cut key to highlight the entire column?
A. "Ctrl+C"
B. "Ctrl+Enter"
C. "Ctrl+Page Up"
D. "Ctrl+Space Bar"
Correct answer is: Option D
4] The cell which is currently selected is called
A. Selected cell
B. Active cell
C. Both
D. None of the above
Correct answer is: Option B
5] To edit a cells content-
A. Click on the cell, whose content you want to edit, and then press F2.
B. Double click on the cell
C. Both
D. None of the above
Correct answer is: Option C
6] To insert a new row before an existing row
A. Click on the heading of the existing row before which you want to insertthe new row, and then click insert->rows.
B. Right click on the heading of the existing row before which you want toinsert the new row, then click insert.
C. Both
D. None of the above
Correct answer is: Option C
7] To insert a new column before an existing column
A. Click on the heading of the existing column before which you want toinsert the new column, and then click insert->columns
B. Right click on the heading of the existing column before which youwant to insert the new column, then click insert
C. Both
D. None of the above
Correct answer is: Option C
8] To delete a row-
A. Click on the heading of the row to be deleted, click Edit -> Delete
B. Right Click on the heading of the row to be deleted, then click delete.
C. Both (A) & (B)
D. None of the above
Correct answer is: Option C
9] Where a row and a column meet, what do you call that?
A. A cell
B. A block
C. A box
D. None of the above
Correct answer is: Option A
10] Selecting the Rows 5 & 6 then choose Insert->RoWhat will happen?
A. "2 Rows will be inserted after Row 4"
B. "2 Rows will be inserted after Row 5"
C. "2 Rows will be inserted after Row 6"
D. " 2 Rows will be inserted after Row 7"
Correct answer is: Option A
11] In a report, you need to show the monthly rainfall in NepaThe best way to do this is to insert a
A. calendar
B. photograph of rainfall
C. chart showing rainfall amounts
D. database of rainfall
Correct answer is: Option C
12] You are editing an worksheet that you had previously saveIf you want to save the edited sheet without losing the original one, which command should you use?
A. New
B. Save As
C. Edit
D. Save
Correct answer is: Option B
13] How do you tell one cell from another?
A. By numbers
B. By letters
C. By its address
D. by color
Correct answer is: Option C
14] Give me an example of a cell address.
A. "11 25''
B. "911"
C. " 41A"
D. "A21"
Correct answer is: Option D
15] Which is an example of a formula?
A. "=A1+A2"
B. "add(J1:J4)"
C. "A1+A2"
D. "SUM(A1:A2)"
Correct answer is: Option A
16] What is the symbol for multiplying?
A. " > "
B. " / "
C. " ! "
D. " * "
Correct answer is: Option D
17] What is the symbol for dividing?
A. "/ "
B. " % "
C. " & "
D. " # "
Correct answer is: Option A
18] Which is not an Excel term?
A. document
B. rows
C. cells
D. columns
Correct answer is: Option A
19] What will be the formula in D10 on copying the formula =A$5*5 from cell B4?
A. ".=A$5*5 "
B. " =A$4*5"
C. "=C$5*5"
D. "=C$4*5"
Correct answer is: Option C
20] How to unhide the hidden column B?
A. Select column B, right click, unhide
B. Select column A and C, right click, unhide
C. Select column C, right click, unhide
D. can not unhide it
Correct answer is: Option B
21] What tool is capable of calculating monthly rainfall amounts and creating graphs based on that data?
A. Outlook
B. Graphics
C. Spreadsheet
D. Word processor
Correct answer is: Option C
22] To merge the cells which tab do you use from the format, cells menu?
A. Number tab
B. Alignment tab
C. Font tab
D. . Merge tab
Correct answer is: Option B
23] In goal seek, the by changing cell refers to:
A. the cell containing the outcome formula
B. the cell containing the constraints
C. the cell containing the target value
D. the cell that you are attempting to calculate
Correct answer is: Option D
24] How do you magnify your worksheet window?
A. View, Zoom
B. Enlarge the font size
C. Home , format
D. Data,filter
Correct answer is: Option A
25] To delete cell entry, select:
A. edit, delete
B. edit, clear
C. view, normal
D. none of the above
Correct answer is: Option B
26] Which is the spreadsheet application?
A. Excel
B. Word
C. Poperpoint
D. Outlook
Correct answer is: Option A
27] The Software which contains rows and columns is called
A. Database
B. Drawing
C. Spreadsheet
D. Word processing
Correct answer is: Option C
28] What is the shortcut key to hide entire column?
A. " CTRL + -"
B. "CTRL + 0"
C. "CTRL + H"
D. "CTRL + C"
Correct answer is: Option B
29] Graphical representation of worksheet data is called-
A. Diagram
B. chart
C. picture
D. None of the above
Correct answer is: Option B
30] To activate the previous cell in a pre-selected range, press
A. the Alt key
B. the Tab key
C. the Enter key
D. none of above
Correct answer is: Option D
31] 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
Correct answer is: Option D
32] If particular workbook have to open each time Excel started, where that workbook should be placed?
A. AUTOEXEC Folder
B. AUTOSTART Folder
C. EXCELSTART Folder
D. XLSTART Folder
Correct answer is: Option D
33] In Excel, by default Numeric Values appears in
A. Left aligned
B. Right aligned
C. Center aligned
D. Justify aligned
Correct answer is: Option B
34] In Excel _______ may not contain in Formula
A. Text Constant
B. Number Constant
C. Circular Reference
D. All of them
Correct answer is: Option C
35] What will be the result if you type =A1=B1 in cell C1?
A. "Yes or No"
B. "True or False"
C. "Value of A1"
D. "Value of B1"
Correct answer is: Option B
36] Worksheet can be renamed by
A. Adding ? symbol at the end of filename while saving workbook
B. Click on Worksheet tab by Holding CTRL Key and type new name
C. Double Click on the Worksheet tab and type new name
D. Worksheet cannot renamed
Correct answer is: Option C
37] Selecting the Column G & H then choose Insert->ColumnWhat will happen?
A. "2 Columns will be inserted after Column F"
B. "2 Columns will be inserted after Column G"
C. "2 Columns will be inserted after Column H"
D. "2 Columns will be inserted after Column I"
Correct answer is: Option A
38] How to specify cell range from A9 to A99 in Excel?
A. "(A9, A99)"
B. "(A9 to A99)"
C. "(A9 : A99)"
D. "(A9 A99)"
Correct answer is: Option C
39] Which of the following syntax is correct regarding to SUM function in Excel?
A. "=SUM(A1, B1)"
B. "=SUM (A1:B9)"
C. "=SUM (A1:A9, B1:B9)"
D. All of the above
Correct answer is: Option D
40] If 4/6 entered in a cell without applying any formats, Excel will treat this as
A. Fraction
B. Date
C. Text
D. None of above
Correct answer is: Option B
41] If the values in A1 is MCQ and B1 is Questions, which function will return MCQ@Questions in cell C1?
A. "=A1 + @ + B1"
B. "=A1 # @ # B1"
C. "=A1 & @ & B1"
D. "=A1 $ @ $ B1"
Correct answer is: Option C
42] Which of the following is correct?
A. "=POWER(2^3)"
B. "=POWER(2,3)"
C. "=POWER(2#3)"
D. "=F90=POWER(2*3)"
Correct answer is: Option B
43] Which of the following shortcuts can be used to insert a new line in the same cell?
A. "Enter"
B. "Alt + Enter"
C. "Ctrl + Enter"
D. "Shift + Enter"
Correct answer is: Option B
44] Clear the contents by pressing DELETE key from a keyboard will clear
A. Text Only
B. Format Only
C. Contents Only
D. Both Contents and Format
Correct answer is: Option C
45] Which of the following function will use to find the highest number in a series of number?
A. "MAX(B1:B3)"
B. "MAXIMUM (B1:B3)"
C. "HIGH (B1:B3)"
D. "HIGHEST(B1:B3)"
Correct answer is: Option A
46] What should be add before a fraction to avoid entering it as a date?
A. "//"
B. "FR"
C. "Zero"
D. "Zero Space"
Correct answer is: Option D
47] How to restrict to run a macro automatically when starting Microsoft Excel?
A. Hold down the SHIFT key during startup
B. Hold down the CTRL key during startup
C. Hold down the ESC key during startup
D. Hold down the ALT key during startup
Correct answer is: Option A
48] The cell reference for cell range of G2 to M12 is
A. "G2.M12"
B. "G2;M12"
C. "G2:M12"
D. "G2-M12"
Correct answer is: Option C
49] Which of the following methods will not enter data in a cell?
A. Pressing the Esc key
B. Pressing an arrow key
C. Pressing the tab key
D. Clicking the enter button to the formula bar
Correct answer is: Option A
50] You can activate a cell by
A. Pressing the Tab key
B. Clicking the cell
C. Pressing an arrow key
D. All of above
Correct answer is: Option D
51] Which of the following setup options can not be set in the page setup dialog box?
A. Printer selection
B. Vertical or horizontal placement
C. Orientation
D. Row and column titles
Correct answer is: Option A
52] What term refers to a specific set of values saved with the workbook?
A. Range
B. Scenario
C. Trend line
D. What-if analysis
Correct answer is: Option B
53] To center worksheet titles across a range of cell, you must
A. Select the cells containing the title text and use the fill handle to center the text across a range of cells
B. Widen the columns
C. Select the cells containing the title text and use the fill handle to center the text across a range of cells
D. Widen the column
Correct answer is: Option A
54] To add two cells (A1 and A2) together you use the following formula
A. "=A1 + A2"
B. "=Add(A1+A2) "
C. "=together(A1:A2)"
D. "A1 plus A2"
Correct answer is: Option A
55] On an excel sheet the active cell in indicated by
A. A dark wide boarder
B. A dotted border
C. A blinking border
D. None of above
Correct answer is: Option A
56] Using the F11 shortcut key to create a chart on chart sheet creates
A. A default chart
B. "A 2-dimensional column chart"
C. "A 2-dimensional bar chart"
D. " A 3-dimensional line chart"
Correct answer is: Option B
57] You can print
A. A range of cells by range name
B. An entire worksheet
C. A single worksheet
D. All of the above
Correct answer is: Option D
58] You can create only a horizontal page break by first selecting
A. A row below the row where you want the page break to occure
B. "A cell in row 1"
C. A cell in column A
D. a and c
Correct answer is: Option D
59] You can create hyperlinks from the Excel workbook to
A. A webpage on company internet
B. A web page on the internet
C. "Other Office 97 application documents"
D. All
Correct answer is: Option D
60] The cell reference fro a range of cells that starts in cell B1 and goes over to column G and down to row 10 is
A. "B1-G10"
B. "B1.G10"
C. "B1;G10"
D. "B1:G10"
Correct answer is: Option D
61] 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
Correct answer is: Option D
62] You can open the scenario Manager dialog box by choosing scenarios from the .. menu.
A. View
B. Insert
C. Format
D. Tools
Correct answer is: Option D
63] When working in the page break preview, you can
A. view exactly where each page break occurs
B. add or remove page breaks
C. change the print area
D. all of above
Correct answer is: Option D
64] Hyperlinks cannot be
A. Special shapes like stars and banners
B. Drawing objects like rectangles ovals
C. Pictures
D. All can be hyperlinks
Correct answer is: Option D
65] A .. is a group of cells that form a rectangle on the screen.
A. Calculation
B. Formula
C. Range
D. Range address
Correct answer is: Option C
66] The chart wizard
A. Can place a chart on a new chart sheet or on any sheet in the workbook
B. Can only place a chart on new chart sheet
C. Can only place a chart on a new blank worksheet
D. Can only be used to create embedded charts
Correct answer is: Option B
67] To access the Go To Special feature, you can press
A. "Ctrl + G"
B. "Ctrl + O"
C. "Ctrl + Shift + G"
D. "Ctrl + 1"
Correct answer is: Option A
68] Which do you press to enter the current date in a cell?
A. "Ctrl + Shift + :"
B. "Ctrl + ;"
C. "Ctrl + F10"
D. "All of above"
Correct answer is: Option B
69] Which of the following is not an underline option in the format cells dialog box?
A. Double
B. Single Engineering
C. Single Accounting
D. Double Accounting
Correct answer is: Option B
70] To select a column the easiest method is to
A. Double click any cell in the column
B. Drag from the top cell in the column to the last cell in the column
C. Click the column heading
D. Click the column label
Correct answer is: Option C
71] This type of software contains rows and columns.
A. Drawing
B. Spreadsheet
C. Database
D. Word processing
Correct answer is: Option B
72] To open an existing workbook, you can click the Open button on the toolbar.
A. Drawing
B. Formatting
C. Forms
D. Standard
Correct answer is: Option D
73] Which of the following is not an option in the spelling dialog box?
A. Edit
B. Ignore
C. Ignore all
D. Change
Correct answer is: Option A
74] You can quickly change the appearance of your work by choosing Auto Format from the . Menu
A. Edit
B. View
C. Format
D. Tools
Correct answer is: Option C
75] To protect a worksheet, you can choose Protection and the Protect Sheet from the .. menu
A. Edit
B. Format
C. Tools
D. Data
Correct answer is: Option C
76] You can open the Highlight Changes dialog box by choosing Track Changes from the . Menu.
A. Edit
B. Insert
C. Format
D. Tools
Correct answer is: Option D
77] Which of the following is not a worksheet design criterion?
A. Efficiency
B. Auditability
C. Description
D. Clarity Correct Answer:
Correct answer is: Option C
78] To copy cell contents using drag and drop, press the
A. End key
B. Shift key
C. Esc key
D. None of above
Correct answer is: Option D
79] What is the keyboard shortcut (button or buttons to be pressed) for creating a chart from the selected cells?
A. "F3"
B. "F5"
C. "F7"
D. "F11"
Correct answer is: Option D
80] What Pivot Table toolbar button updates the data ina Pivot Table or Pivot Chart report if the source data chas changed
A. Format Report
B. Pivot Table
C. Refresh Data
D. Show Detail
Correct answer is: Option C
81] What is an expression that tells how the numbers in a determined set of cells are to be calculated?
A. Formula
B. Field
C. Data
D. Query Correct Answer:
Correct answer is: Option A
82] What term describes a background that appears as a grainy, non smooth surface?
A. gradient
B. pattern
C. solid
D. texture
Correct answer is: Option A
83] Excel is a
A. Graphic program
B. None of these
C. Word processor
D. A spreadsheet
Correct answer is: Option D
84] To create an interactive Pivot Table for the web, you use a Microsoft Office Web component called
A. HTML
B. Pivot Table Field List
C. Pivot Table List
D. Pivot Table Report
Correct answer is: Option D
85] Except for the function, a formula with a logical function shows the word TRUE or FALSE as a result
A. IF
B. AND
C. OR
D. NOT
Correct answer is: Option A
86] You can open the consolidate dialog box byt choosing Consolidate from the .. menu.
A. Insert
B. Format
C. Tools
D. Data
Correct answer is: Option D
87] 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
Correct answer is: Option C
88] Which of the following will not set text in selected cells to italics?
A. Pressing Ctrl + I on the keyboard
B. Using the Tools Wizard Web Form menu item
C. Using the Format Cells Font menu item
D. None of the above
Correct answer is: Option B
89] Which of the following methods cannot be used to edit the content of cell?
A. Pressing the Alt key
B. Clicking the formula bar
C. Pressing F2
D. Double clicking the cell
Correct answer is: Option A
90] Which of the following setup options can not be set in the page setup dialog box?
A. Printer selection
B. Vertical or horizontal placement
C. Orientation
D. Row and column titles
Correct answer is: Option A
91] Which of the following describes how to select all the cells in a single column?
A. Right click on column and select Pick from list
B. Use data text to columns menu item
C. Left click on the gray column title button
D. Pressing Ctrl + A on the keyboard
Correct answer is: Option C
92] When you use the fill effects in the format data series dialog box, you can not
A. rotate text on the chart
B. select a fore ground color
C. select a pattern
D. select a background color
Correct answer is: Option A
93] Paper spreadsheets can have all the same advantages as an electronic spreadsheet except which of the following?
A. Rows and columns
B. Headings
C. Speed
D. None
Correct answer is: Option C
94] Whats a quick way to extend these numbers to a longer sequence, for instance 1 through 20?
A. "Select both cells, and then drag the fill handle over the range you want, for instance 18 more rows"
B. "Select the range you want, include both cells, point to fill on the Edit menu, and then click down."
C. "Copy the second cell, click in the cell below it, on the standard toolbar click the down arrow on the Paste button, and then click Paste Special"
D. "All of above"
Correct answer is: Option A
95] When integrating Ms-Word and Excel, Word is usually the
A. Server
B. Source
C. Client
D. None
Correct answer is: Option C
96] Charts tips can
A. Show the formatting of a data label
B. Show the name of a data series
C. Show the value of data point
D. b and c
Correct answer is: Option D
97] The Name box
A. Shows the location of the previously active cell
B. Appears t the left of the formula bar
C. Appears below the status bar
D. Appears below the menu bar
Correct answer is: Option B
98] When you work with large worksheets, you may need to
A. size the worksheet to fit on the specific number of pages
B. add and remove page breaks
C. specify only certain print areas
D. all of above
Correct answer is: Option D
99] 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
Correct answer is: Option B
100) What do we call a computer program that organizes data in rows and columns of cells? You might use this type of program to keep a record of the money you earned moving lawns over the summer.
A. Spreadsheet program
B. Database program
C. Word processor program
D. Desktop publisher program
Correct answer is: Option A
Comments
Post a Comment