Computer — Learn

Microsoft Excel MCQ Questions Part 6

Review each question and reveal answers to strengthen your understanding

1 Which menu option can be used to split windows into two?
✅ Correct Answer: 3
2 Getting data from a cell located in a different sheet is called
✅ Correct Answer: 2
3 Which of the following is not a valid data type in Excel?
✅ Correct Answer: 2
4 Which elements of a worksheet can be protected from accidental modification?
✅ Correct Answer: 4
5 A numeric value can be treated as label value if …… precedes it.
✅ Correct Answer: 1
6 Concatenation of text can be done using
✅ Correct Answer: 4
7 Which area in an Excel window allows entering values and formulas?
✅ Correct Answer: 3
8 Multiple calculations can be made in a single formula using…..
✅ Correct Answer: 2
9 An Excel Workbook is a collection of …….
✅ Correct Answer: 4
10 What do you mean by a Workspace?
✅ Correct Answer: 4
11 MS-EXCEL is based on ……….?
✅ Correct Answer: 1
12 In EXCEL you can sum a large range of data by simply selecting a tool button called …..?
✅ Correct Answer: 3
13 To select an entire column in MS-EXCEL press?
✅ Correct Answer: 4
14 To return the remainder after a number is divided by a divisor in EXCEL we use the function?
✅ Correct Answer: 3
15 Which function is not available in the Consolidate dialog box?
✅ Correct Answer: 1
16 Which is not the function of “Edit Clear” command?
✅ Correct Answer: 3
17 Microsoft Excel is a powerful………..
✅ Correct Answer: 2
18 How do you rearrange the data in ascending or descending order?
✅ Correct Answer: 1
19 Which Chart can be created in Excel?
✅ Correct Answer: 4
20 What will be the output if you format the cell containing 5436.8 as ‘###0.00′?
✅ Correct Answer: 2
21 How do you display current date and time in MS Excel?
✅ Correct Answer: 3
22 How do you display current date only in MS Excel?
✅ Correct Answer: 2
23 How do you wrap the text in a cell?
✅ Correct Answer: 4
24 What does COUNTA () function do?
✅ Correct Answer: 4
25 What is the short cut key to highlight the entire column?
✅ Correct Answer: 4
26 In the formula which symbol specifies the fixed columns or rows?
✅ Correct Answer: 1
27 Excel displays the current cell address in the ……….
✅ Correct Answer: 3
28 What is the correct way to refer the cell A10 on sheet3 from sheet1?
✅ Correct Answer: 1
29 Which language is used to create macros in Excel?
✅ Correct Answer: 1
30 Which of the following is not a term of MS-Excel?
✅ Correct Answer: 4
31 How many worksheets can a workbook have?
✅ Correct Answer: 4
32 Which would you choose to create a bar diagram?
✅ Correct Answer: 2
33 Which setting you must modify to print a worksheet using letterhead?
✅ Correct Answer: 2
34 What do you call the chart that shows the proportions of how one or more data elements relate to another data element?
✅ Correct Answer: 3
35 The spelling dialog box can be involved by choosing spelling from ________ menu.
✅ Correct Answer: 3
36 Which key do you press to check spelling?
✅ Correct Answer: 3
37 To record a sequence of keystrokes and mouse actions to play back later we use
✅ Correct Answer: 4
38 We can save and protect the workbook by
✅ Correct Answer: 4
39 The first cell in EXCEL worksheet is labeled as
✅ Correct Answer: 2
40 What happens when dollar signs ($) are entered in a cell address?
✅ Correct Answer: 1
41 What are the tabs that appear at the bottom of each workbook called?
✅ Correct Answer: 4
42 What is represented by the small black square in the lower-right corner of an active cell or range?
✅ Correct Answer: 2
43 In Excel a Data Series is defined as what?
✅ Correct Answer: 3
44 In Excel the Fill Color button on the Formatting toolbar is used for what?
✅ Correct Answer: 4
45 In help menu of Excel which of the following tabs are found?
✅ Correct Answer: 4
46 A __________ is a grid with labeled columns and rows.
✅ Correct Answer: 2
47 The active cell:
✅ Correct Answer: 4
48 Which function is used to calculate depreciation rates of return future values and loan payment amounts?
✅ Correct Answer: 4
49 B7:B9 indicates
✅ Correct Answer: 2
50 The Cancel and Enter buttons appear in the
✅ Correct Answer: 2
Back to All Quizzes