Question

Please solve it and give the correct answers...
Q1. Which elements of the worksheet can be protected from accidental modifications?
(a) Contents
(b) Object
(c) Scenarios
(d) Input Cells

Q2. Which of the following is an acceptable name for a named range?
(a) C7
(b) subtotal_west
(c) subtotal west
(d) subtotal/west

Q3. You have just created a detailed monthly budget worksheet called "January". It has labeled fields for all of your regular bills and formulas for each of your spending categories. You want to create 11 more worksheets for the rest of the year. What is the fastest way to do this?
(a) Click Insert, Worksheet, and recreate the 11 monthly worksheets.
(b) Click the "+" symbol 11 times, copy and paste the January content into the new worksheets, and rename the worksheets.
(c) Hold Ctrl and drag the January tab into 11 new worksheet copies, and rename the worksheets.
(d) Hold shift and drag the January tab into 11 new worksheet copies, and rename the worksheets.

Q4. Which of the following shows a formula for a reference to another workbook?
(a) =SUM(C2: E12)
(b) =Q3Expenses!A19
(c) =[Media.xlsx]MasterList!$D$10
(d) =SUM(budget.summary)

(NO WRONG ANSWERS PLEASE)

Answer 1

Answer:

1st ans :- D

Explanation:

All elements of a worksheet can be protected from accidental modification.

To protect a worksheet in Excel 2007 and higher versions, click the Review tab, click Protect Worksheet (or Protect Sheet), and click OK.

Excel 2003 and Earlier Versions click Tools > Protection, click Protect Sheet, and click OK