Allow you to view a different worksheet

Allow you to view additional worksheet rows down

Allow you to view additional worksheet columns to the right

Microsoft Excel MCQ Questions with answers and solutions Page 8

Q. The intersection of a column and a row in MS Excel worksheet is known as

(A) Row
(B) Cell
(C) Column
(D) Tab

💬 Discuss

✅ Correct Answer: (B) Cell

Published by Mr. Dubey ⭐ 104.82K Points at 22-Jul-2022 10:12 pm in Microsoft Excel

Q. In Microsoft Excel spreadsheets, rows are labelled as

(A) 1,2,3,….
(B) A,B,C,….
(C) A1,B1,C1….
(D) I,II,III,…..

💬 Discuss

✅ Correct Answer: (A) 1,2,3,….

Published by Mr. Dubey ⭐ 104.82K Points at 22-Jul-2022 10:13 pm in Microsoft Excel

Q. In Microsoft Excel spreadsheets, COLUMNS are labelled as

(A) 1,2,3,…..
(B) A,B,C,….
(C) A1,B1,C1….
(D) I,II,III,…..

💬 Discuss

✅ Correct Answer: (B) A,B,C,….

Published by Mr. Dubey ⭐ 104.82K Points at 22-Jul-2022 10:13 pm in Microsoft Excel

Q. In Microsoft Excel spreadsheets, CELLS are labelled as

(A) 1,2,3,…..
(B) A,B,C,….
(C) A1,B1,C1….
(D) I,II,III,…..

💬 Discuss

✅ Correct Answer: (C) A1,B1,C1….

Published by Mr. Dubey ⭐ 104.82K Points at 22-Jul-2022 10:13 pm in Microsoft Excel

Q. ___________ is a collection of cells organized in rows and columns where you keep and manipulate the data.

(A) Workbook
(B) Worksheet
(C) Spreadsheet
(D) ARRAY

💬 Discuss

✅ Correct Answer: (B) Worksheet

Published by Mr. Dubey ⭐ 104.82K Points at 22-Jul-2022 10:14 pm in Microsoft Excel

Q. Select correct statement

(A) Each Excel workbook can contain multiple worksheets.
(B) Each Excel worksheet can contain multiple workbooks.
(C) Each Excel workbook can contain multiple spreadsheets.
(D) Each Excel worksheet can contain multiple spreadsheets.

💬 Discuss

✅ Correct Answer: (A) Each Excel workbook can contain multiple worksheets.

Published by Mr. Dubey ⭐ 104.82K Points at 22-Jul-2022 10:14 pm in Microsoft Excel

Q. How many characters can be typed in a single cell in Excel?

(A) 256
(B) 1024
(C) 32000
(D) 65535

💬 Discuss

✅ Correct Answer: (D) 65535

Published by Vishal Gupta ⭐ 7.73K Points at 23-Jul-2022 07:21 am in Microsoft Excel

Q. Tab scrolling button

(A) Allow you to view a different worksheet
(B) Allow you to view additional worksheet rows down
(C) Allow you to view additional worksheet columns to the right
(D) Allow you to view additional sheets tabs

💬 Discuss

✅ Correct Answer: (D) Allow you to view additional sheets tabs

Published by Vishal Gupta ⭐ 7.73K Points at 23-Jul-2022 07:22 am in Microsoft Excel

Q. The auto calculate feature

(A) Can only add values in a range of cells
(B) Provides a quick way to view the result of an arithmetic operation on a range of cells
(C) Automatically creates formulas and adds them to a worksheet
(D) Both A and C

💬 Discuss

✅ Correct Answer: (B) Provides a quick way to view the result of an arithmetic operation on a range of cells

Published by Vishal Gupta ⭐ 7.73K Points at 23-Jul-2022 07:22 am in Microsoft Excel

Q. Which of the following will not cut information?

(A) Pressing Ctrl + C
(B) Selecting Edit > Cut from the menu
(C) Clicking the Cut button on the standard
(D) Pressing Ctrl+X

💬 Discuss

✅ Correct Answer: (A) Pressing Ctrl + C

Published by Vishal Gupta ⭐ 7.73K Points at 23-Jul-2022 07:25 am in Microsoft Excel

Microsoft Excel MCQs with answers Page - 8

Q. The intersection of a column and a row in MS Excel worksheet is known as

Q. In Microsoft Excel spreadsheets, rows are labelled as

Q. In Microsoft Excel spreadsheets, COLUMNS are labelled as

Q. In Microsoft Excel spreadsheets, CELLS are labelled as

Q. ___________ is a collection of cells organized in rows and columns where you keep and manipulate the data.

Q. Select correct statement

Q. How many characters can be typed in a single cell in Excel?

Q. Tab scrolling button

Q. The auto calculate feature

Q. Which of the following will not cut information?

Programming Categories

📱 Download Our App