Computer — Learn

Microsoft Excel MCQ Questions Part 7

Review each question and reveal answers to strengthen your understanding

1 MS-EXCEL can be used to automate
✅ Correct Answer: 4
2 NOT, AND, OR and XOR are
✅ Correct Answer: 1
3 In a report, you need to show the monthly rainfall in NepaThe best way to do this is to insert a
✅ Correct Answer: 3
4 You want to record experiment information and create a chart that shows the rate of crystal growth over a period of timThe best application to use would be
✅ Correct Answer: 2
5 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?
✅ Correct Answer: 2
6 If you want to have a blank line after the title in a worksheet, what is the best thing for you to do?
✅ Correct Answer: 2
7 In order to arrange the countries from those with the highest population to those with the lowest, you need to sort on the population field in ……………
✅ Correct Answer: 2
8 In order to perform a calculation in a spreadsheet, you need to use a
✅ Correct Answer: 2
9 The box on the chart that contains the name of each individual record is called the ________.
✅ Correct Answer: 4
10 If you want all of the white cats grouped together in the database, you need to sort by ________.
✅ Correct Answer: 2
11 You accidentally erased a record in the sheeWhat command can be used to restore it immediately?
✅ Correct Answer: 3
12 Where a row and a column meet, what do you call that?
✅ Correct Answer: 1
13 How do you tell one cell from another?
✅ Correct Answer: 3
14 Give me an example of a cell address.
✅ Correct Answer: 4
15 What is the symbol for multiplying?
✅ Correct Answer: 4
16 What is the symbol for dividing?
✅ Correct Answer: 1
17 A function inside another function is called _______
✅ Correct Answer: 1
18 Which of the following is not an underline option in the format cells dialog box?
✅ Correct Answer: 4
19 Formulas in Excel start with
✅ Correct Answer: 2
20 The default header for a worksheet is
✅ Correct Answer: 4
21 Which of the following is not an option of the spelling dialog box?
✅ Correct Answer: 3
22 Which of the following methods will not enter data in a cell?
✅ Correct Answer: 1
23 The cell reference for cell range of G2 to M12 is _______
✅ Correct Answer: 3
24 What is the keyboard shortcut for creating a chart from the selected cell range?
✅ Correct Answer: 4
25 The Software which contains rows and columns is called ______
✅ Correct Answer: 3
26 You can group noncontiguous worksheets with
✅ Correct Answer: 2
27 What is the AutoComplete feature of Excel?
✅ Correct Answer: 2
28 Which of the following function will return a value of 8?
✅ Correct Answer: 4
29 How to restrict to run a macro automatically when starting Microsoft Excel?
✅ Correct Answer: 1
30 How to remove the unwanted action from recorded macro without recording the whole macro again?
✅ Correct Answer: 3
31 What should be add before a fraction to avoid entering it as a date?
✅ Correct Answer: 4
32 Which of the following function will use to find the highest number in a series of number?
✅ Correct Answer: 1
33 What does the NOW() function return?
✅ Correct Answer: 4
34 What value will display if the formula = “$55.00″+5 is entered into a cell?
✅ Correct Answer: 2
35 What is the shortcut key to insert current date in a cell?
✅ Correct Answer: 3
36 What is the shortcut key to hide entire column?
✅ Correct Answer: 2
37 How to specify cell range from A9 to A99 in Excel?
✅ Correct Answer: 3
38 Selecting the Column G & H then choose Insert->ColumnWhat will happen?
✅ Correct Answer: 1
39 How to restrict the values of a cell so that only whole numbers between 9 and 99 can be entered in a cell
✅ Correct Answer: 2
40 Clear the contents by pressing “DELETE” key from a keyboard will clear
✅ Correct Answer: 3
41 Which of the following shortcuts can be used to insert a new line in the same cell?
✅ Correct Answer: 2
42 What is the quickest way to select entire worksheet?
✅ Correct Answer: 4
43 A smart tag will be removed from a cell when
✅ Correct Answer: 3
44 Which of the following options is appropriate to show the numbers 9779851089510 in a cell?
✅ Correct Answer: 4
45 Selecting the Rows 5 & 6 then choose Insert->RoWhat will happen?
✅ Correct Answer: 1
46 If 4/6 entered in a cell without applying any formats, Excel will treat this as
✅ Correct Answer: 4
47 How to fit long texts in a single cell with multiple lines?
✅ Correct Answer: 2
48 If particular workbook have to open each time Excel started, where that workbook should be placed?
✅ Correct Answer: 4
49 If the cell B1 contains the formula = $A$1, which of the following statements is true
✅ Correct Answer: 2
50 Worksheet can be renamed by
✅ Correct Answer: 3
51 1What is the shortcut key to hide entire row?
✅ Correct Answer: 3
52 What is the shortcut key to insert a new comment in a cell?
✅ Correct Answer: 4
53 Which option allows you to Bold all the negative values within the selected cell range
✅ Correct Answer: 2
54 What is the shortcut key to insert new sheet in current workbook?
✅ Correct Answer: 4
55 Which one is the last column header in Excel 2007?
✅ Correct Answer: 1
56 In maximum, how many sheets can be set as default while creating new workbook?
✅ Correct Answer: 2
57 New Comment” option can be found under _________ tab
✅ Correct Answer: 3
58 In Excel, by default Numeric Values appears in
✅ Correct Answer: 2
59 To show/hide the grid lines in Microsoft Excel 2007
✅ Correct Answer: 1
60 What will be the result if you type =A1=B1 in cell C1?
✅ Correct Answer: 2
61 In Excel _______ may not contain in Formula
✅ Correct Answer: 3
Back to All Quizzes