Microsoft Excel MCQ Questions with answers and solutions Page 2

Q. Which command need to execute from "run window" to open a new excel file

(A) ms excel
(B) win excel
(C) office excel
(D) excel

✅ Correct Answer: (D) excel

Explanation: Type win R to open run prompt.
Type Excel to open Microsoft excel.
Type winword to open Microsoft word.

Published by Mr. Dubey ⭐ 111.54K Points at 22-Jul-2022 09:32 pm in Microsoft Excel

Q. If "A1" is displayed in Name Box, then is indicates which one

(A) First column (by A) and first row (by 1)
(B) First column (by 1) and first row (by A)
(C) First sheet
(D) None of the above

💬 Discuss

✅ Correct Answer: (A) First column (by A) and first row (by 1)

Published by Mr. Dubey ⭐ 111.54K Points at 22-Jul-2022 09:44 pm in Microsoft Excel

Q. All formulas in MS Excel is start with _______ sign

(A) $
(B) =
(C) ()
(D) !

💬 Discuss

✅ Correct Answer: (B) =

Published by Mr. Dubey ⭐ 111.54K Points at 22-Jul-2022 09:45 pm in Microsoft Excel

Q. Which function key generates a bar graph from the values entered in excel

(A) F9
(B) F10
(C) F11
(D) F12

💬 Discuss

✅ Correct Answer: (C) F11

Published by Mr. Dubey ⭐ 111.54K Points at 22-Jul-2022 09:45 pm in Microsoft Excel

Q. Total number of characters that a cell can contain

(A) 24,221
(B) 27,685
(C) 32,767
(D) 39,802

💬 Discuss

✅ Correct Answer: (C) 32,767

Published by Mr. Dubey ⭐ 111.54K Points at 22-Jul-2022 09:46 pm in Microsoft Excel

Q. You can check the conditions against __________ when applying conditional formatting

(A) Cell value
(B) Formula
(C) Both of above
(D) None of above

💬 Discuss

✅ Correct Answer: (C) Both of above

Published by Mr. Dubey ⭐ 111.54K Points at 22-Jul-2022 09:49 pm in Microsoft Excel

Q. When a range is selected, how can you activate the previous cell?

(A) Press the Alt key
(B) Press Tab
(C) Press Enter
(D) None of above

💬 Discuss

✅ Correct Answer: (D) None of above

Published by Mr. Dubey ⭐ 111.54K Points at 22-Jul-2022 09:50 pm in Microsoft Excel

Q. You can use the formula palette to

(A) Format cells containing numbers
(B) Create and edit formula containing functions
(C) Enter assumptions data
(D) Copy a range of cells

💬 Discuss

✅ Correct Answer: (B) Create and edit formula containing functions

Published by Mr. Dubey ⭐ 111.54K Points at 22-Jul-2022 09:50 pm in Microsoft Excel

Q. VBA in MS-Excel was used from which version

(A) Excel 4
(B) Excel 5
(C) Excel 6
(D) Excel 7

💬 Discuss

✅ Correct Answer: (B) Excel 5

Published by Mr. Dubey ⭐ 111.54K Points at 22-Jul-2022 09:50 pm in Microsoft Excel

Q. What is the default extension of Microsoft Excel 2003 saved file

(A) .xls
(B) .xsl
(C) .xlsx
(D) .xlxs

💬 Discuss

✅ Correct Answer: (A) .xls

Published by Mr. Dubey ⭐ 111.54K Points at 22-Jul-2022 09:51 pm in Microsoft Excel

Microsoft Excel MCQs with answers Page - 2

Q. Which command need to execute from "run window" to open a new excel file

Q. If "A1" is displayed in Name Box, then is indicates which one

Q. All formulas in MS Excel is start with _______ sign

Q. Which function key generates a bar graph from the values entered in excel

Q. Total number of characters that a cell can contain

Q. You can check the conditions against __________ when applying conditional formatting

Q. When a range is selected, how can you activate the previous cell?

Q. You can use the formula palette to

Q. VBA in MS-Excel was used from which version

Q. What is the default extension of Microsoft Excel 2003 saved file

Programming Categories

📱 Download Our App