Luis wants to unhide and view all rows and columns in a worksheet.Which of the following series of clicks/entries/selections can he use to create a custom view of the worksheet?
A) Worksheet View tab Workbook Views group Custom Views Close
B) Worksheet View tab Workbook Views group Custom Views Add Name box (Type a name ) OK
C) Worksheet View tab Workbook Views group Custom Views Add Name box (Type a name ) Include in view (Tick check box- Hidden rows,columns and filter settings ) OK
D) Worksheet View tab Workbook Views group Custom Views Add Name box (Type a name ) Include in view (select check box- Print settings ) OK

Question

Luis wants to unhide and view all rows and columns in a worksheet.Which of the following series of clicks/entries/selections can he use to create a custom view of the worksheet?
A) Worksheet > View tab > Workbook Views group > Custom Views > Close
B) Worksheet > View tab > Workbook Views group > Custom Views > Add > Name box (Type a name )> OK
C) Worksheet > View tab > Workbook Views group > Custom Views > Add > Name box (Type a name )> Include in view (Tick check box- Hidden rows,columns and filter settings )> OK
D) Worksheet > View tab > Workbook Views group > Custom Views > Add > Name box (Type a name )> Include in view (select check box- Print settings )> OK

Quizplus · Accepted Answer

Option C includes the necessary steps to unhide and view all rows and columns in a worksheet by selecting the "Include in view" option and ticking the checkbox for "Hidden rows, columns, and filter settings". Option A only leads to the "Custom Views" menu without specifying any customizations. Option B creates a custom view but doesn't include the necessary steps to unhide and view all rows and columns in a worksheet. Option D includes the steps to customize print settings, but not to unhide and view all rows and columns in a worksheet.

Luis Wants to Unhide and View All Rows and Columns