Extends a sequential series of data

Automatically adds range of cell values

Applies a boarder around the selected cells

Shows the location of the previously active cell

Microsoft Excel MCQ Questions with answers and solutions Page 10

Q. You can use the format painter multiple times before you turn it off by

(A) You can use the format painter button only one time when you click it
(B) Double clicking the format painter button
(C) Pressing the Ctrl key and clicking the format painter button
(D) Pressing the Alt key and clicking the format painter button

💬 Discuss

✅ Correct Answer: (B) Double clicking the format painter button

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

Q. Excel probably considers the cell entry January 1,2000 to be a

(A) Label
(B) Value
(C) Formula
(D) Text string

💬 Discuss

✅ Correct Answer: (B) Value

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

Q. You want to track the progress of the stock market on a daily basis. Which type of chart should you use?

(A) Pie chart
(B) Row chart
(C) Line chart
(D) Column chart

💬 Discuss

✅ Correct Answer: (C) Line chart

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

Q. You can edit a cell by

(A) Clicking the formula button
(B) Double clicking the cell to edit it in-place
(C) Selecting Edit > Edit Cell from the menu
(D) None of above

💬 Discuss

✅ Correct Answer: (B) Double clicking the cell to edit it in-place

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

Q. Right clicking something in Excel

(A) Deletes the object
(B) Nothing the right mouse button is there for left handed people
(C) Opens a shortcut menu listing everything you can do to the object
(D) Selects the object

💬 Discuss

✅ Correct Answer: (C) Opens a shortcut menu listing everything you can do to the object

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

Q. The autofill feature

(A) Extends a sequential series of data
(B) Automatically adds range of cell values
(C) Applies a boarder around the selected cells
(D) None of the above

💬 Discuss

✅ Correct Answer: (D) None of the above

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

Q. The name box

(A) Appears below the menu bar
(B) Appears below the status bar
(C) Appears to the left of the formula bar
(D) Shows the location of the previously active cell

💬 Discuss

✅ Correct Answer: (C) Appears to the left of the formula bar

Published by Ram Sharma ⭐ 193.88K Points at 24-Jul-2022 12:10 pm in Microsoft Excel

Q. Hyperlinks can be

(A) Text
(B) Drawing objects
(C) Pictures
(D) All of above

💬 Discuss

✅ Correct Answer: (D) All of above

Published by Ram Sharma ⭐ 193.88K Points at 24-Jul-2022 12:10 pm in Microsoft Excel

Q. To copy formatting from one area in a worksheet and apply it to another area you would use:

(A) The Edit > Copy Format and Edit > Paste Format commands form the menu
(B) The Copy and Apply Formatting dialog box, located under the Format > Copy and Apply menu
(C) There is no way to copy and apply formatting in Excel – You have to do it manually
(D) The Format Painter button on the standard toolbar

💬 Discuss

✅ Correct Answer: (D) The Format Painter button on the standard toolbar

Published by Ram Sharma ⭐ 193.88K Points at 24-Jul-2022 12:11 pm in Microsoft Excel

Q. To edit in an embedded excel worksheet object in a word document

(A) Use the excel menu bar and toolbars inside the word application
(B) Edit the hyperlink
(C) Edit the data in a excel source application
(D) Use the word menu bar and toolbars

💬 Discuss

✅ Correct Answer: (A) Use the excel menu bar and toolbars inside the word application

Published by Ram Sharma ⭐ 193.88K Points at 24-Jul-2022 12:12 pm in Microsoft Excel

Microsoft Excel MCQs with answers Page - 10

Q. You can use the format painter multiple times before you turn it off by

Q. Excel probably considers the cell entry January 1,2000 to be a

Q. You want to track the progress of the stock market on a daily basis. Which type of chart should you use?

Q. You can edit a cell by

Q. Right clicking something in Excel

Q. The autofill feature

Q. The name box

Q. Hyperlinks can be

Q. To copy formatting from one area in a worksheet and apply it to another area you would use:

Q. To edit in an embedded excel worksheet object in a word document

Programming Categories

📱 Download Our App