5. How do you select noncontigous cells? Is the ability to select noncontiguous
ID: 667513 • Letter: 5
Question
5. How do you select noncontigous cells? Is the ability to select noncontiguous cells important to the effective use of Excel? If yes, why? If no, why make use of noncontiguous cell selection?
6. Describe two ways in which, columns and rows can be inserted and deleted.
7. How do you reorder worksheets in a workbook?
8. Explain the purpose of print titles, page headers, and page footers, and when you would use them. What are page orientation and scaling, and how can they be used in tandem to allow you to efficiently print a professional-looking worksheet?
Explanation / Answer
5)Procedure to select noncontigous cells
Select the first cell or range.
Press and hold the Ctrl Key.
Select the other cells and/or ranges that you want to add the your selection while holding down the Ctrl key.
Apply formatting, etc as normal and all of the selected cells will be affected.
Deselect the range.
It is important to know it because-
By selecting multiple cells in Excel you can delete data, apply formatting such as borders or shading, or apply other options to large areas of a worksheet in a single click.
6)Different ways to insert and delete rows and columns in excel are-
a) Select the row above or the column to the right of where the insertion should occur.
Choose HomeCells and click the arrow to the right of the Insert button to open the drop-down list for the Insert button.
From the menu, choose Insert Sheet Rows or Insert Sheet Columns.
b) Click on a cell in the row where you want the new rows added
Press and hold down the Shift key on the keyboard
Press and release the Spacebar without releasing the Shift key
The entire row should be select
Continue to hold down the Shift key
Press and release the Up arrow key twice to select two additional rows
Press and hold down the Ctrl and Shift keys on the keyboard
Press and release the " + " key without releasing the Ctrl and Shift keys
Three new rows should be added above the selected rows
7) Procedure to reoder worksheets in a workbook is-
simply right-click the tab you want to move and select Move Or Copy from the resulting context menu. Then, in the Before Sheet dialog box, select the appropriate sheet or select the (Move To End) option
8)The Print Titles command allows you to select specific rows and columns to appear on each page.
The header is a section of the workbook that appears in the top margin, while the footer appears in the bottom margin. Headers and footers generally contain information such as page number, date, and workbook name.
Excel offers two page orientation options: landscape and portrait. Landscape orients the page horizontally, while portrait orients the page vertically.
You can scale a worksheet for printing by shrinking or enlarging its size to better fit the printed pages. You can also scale a worksheet to fit the paper width of printed pages, or specify the number of pages that you want to use for the printed worksheet.
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.