Microsoft Excel MCQ Questions with answers and solutions Page 11

Q. You can copy data or formulas

(A) With the copy, paste and cut commands on the edit menu
(B) With commands on the shortcut menu
(C) With buttons on the standard toolbars
(D) All of the above

💬 Discuss

✅ Correct Answer: (D) All of the above

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

Q. You can convert existing excel worksheet data an charts to an HTML document by using

(A) Import wizard
(B) Intranet wizard Intranet wizard
(C) Internet assistant wizard
(D) FTP wizard

💬 Discuss

✅ Correct Answer: (C) Internet assistant wizard

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

Q. Each excel file is called a workbook because

(A) You have to work hard to create it
(B) It can contain many sheets including worksheets and chart sheets
(C) It can be modified
(D) It can contain text and data

💬 Discuss

✅ Correct Answer: (B) It can contain many sheets including worksheets and chart sheets

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

Q. The numbers in our worksheet look like this: You want them to look like this: $1,000.How can you accomplish this?

(A) Click the Currency Style button on the formatting toolbar
(B) Select Format > Money from the menu
(C) You have to retype everything and manually add the dollar signs, commas, and decimals
(D) None of these

💬 Discuss

✅ Correct Answer: (A) Click the Currency Style button on the formatting toolbar

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

Q. Which of the following methods cannot be used to edit the contents of a cell?

(A) Double clicking the cell
(B) Pressing the F2 key
(C) Clicking the formula bar
(D) Press the Alt key

💬 Discuss

✅ Correct Answer: (D) Press the Alt key

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

Q. To save a workbook, you:

(A) Click Save on the Windows Start button
(B) Select Edit>Save
(C) Click the save button on the standard toolbar from the menu
(D) Press Ctrl + F5

💬 Discuss

✅ Correct Answer: (C) Click the save button on the standard toolbar from the menu

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

Q. When a label is too long to fit within a worksheet cell, you typically must

(A) Shorten the label
(B) Decrease the column width
(C) Adjust the row height
(D) Increase the column width

💬 Discuss

✅ Correct Answer: (D) Increase the column width

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

Q. You can use the horizontal and vertical scroll bars to

(A) View different worksheets
(B) Edit the contents of a cell
(C) View different rows and columns edit the contents of a cell
(D) Split a worksheet into two panes

💬 Discuss

✅ Correct Answer: (C) View different rows and columns edit the contents of a cell

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

Q. Which area in an excel window allows entering values and formulas

(A) Standard toolbar
(B) Formula bar
(C) Menu bar
(D) Title bar

💬 Discuss

✅ Correct Answer: (B) Formula bar

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

Q. Which of the following is a popular DOS based spreadsheet package?

(A) Lotus 1-2-3
(B) Excel
(C) Smart cell
(D) Word

💬 Discuss

✅ Correct Answer: (A) Lotus 1-2-3

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

Microsoft Excel MCQs with answers Page - 11

Q. You can copy data or formulas

Q. You can convert existing excel worksheet data an charts to an HTML document by using

Q. Each excel file is called a workbook because

Q. The numbers in our worksheet look like this: You want them to look like this: $1,000.How can you accomplish this?

Q. Which of the following methods cannot be used to edit the contents of a cell?

Q. To save a workbook, you:

Q. When a label is too long to fit within a worksheet cell, you typically must

Q. You can use the horizontal and vertical scroll bars to

Q. Which area in an excel window allows entering values and formulas

Q. Which of the following is a popular DOS based spreadsheet package?

Programming Categories

📱 Download Our App