Explain the way by which you can Insert and Delete Cells in Microsoft Excel 2016.

What will be an ideal response?


Answers will vary. If you click the Insert button in the Cells group on the Home tab while one cell is selected, a cell is inserted and the selected cell and the cells below it move down one row. If you select a range and then click the Insert button, the selected range shifts down when the selected range is wider than it is long, and shifts right when the selected range is longer than it is wide.?If you click the Insert button arrow, you can use the Insert Cells command on the menu to open the Insert dialog box. This allows you to specify whether you want to shift the existing cells right or down, or whether to insert an entire row or column. The selected option is Excel's best guess of which way you want the current cells to shift.?If you no longer need a specific cell or range in a worksheet, you can delete those cells and any content they contain. To delete a range, select the range, and then click the Delete button in the Cells group on the Home tab. As with deleting a row or column, cells adjacent to the deleted range either move up or left to fill in the vacancy left by the deleted cells. To specify how the adjacent cells shift, or if you want to delete the entire row or column, click the Delete button arrow, and then click Delete Cells to open the Delete dialog box, which is similar to the Insert dialog box. Please see the section "Working with Cells and Ranges" for more information.

Computer Science & Information Technology

You might also like to view...

When method printf requires multiple arguments, the arguments are separated with ________.

a. colons (:). b. semicolons (;). c. commas (,). d. periods (.).

Computer Science & Information Technology

Discuss the main approaches for managing the design of a database system that has multiple user views.

What will be an ideal response?

Computer Science & Information Technology

All of the following are drawbacks to buying goods online EXCEPT ________

A) the consumer may have to wait days for the product to be delivered B) returning a product may be a hassle and require additional delivery charges C) the consumer cannot see the exact color or feel the texture of a product D) the consumer must pay credit card fees for using a credit card online

Computer Science & Information Technology

What is the purpose of the address operator in C++?

A. There is no address operator in C++. B. To return the hexadecimal address of a variable. C. To report the system address for the program. D. To return the hexadecimal range for a datatype.

Computer Science & Information Technology