Explanation

To duplicate values in a cell range in Excel 2016, follow these steps:

• Select the range of cells that you want to duplicate.
• Go to the Home tab in the ribbon.
• Click on the "Fill" handle (the small square at the bottom-right corner of the selection) and drag it down to the range where you want to duplicate the values.
• Alternatively, you can right-click on the selection and choose "Copy" (or press Ctrl+C), then select the range where you want to duplicate the values and right-click and choose "Paste" (or press Ctrl+V).

Explanation

The Name Box normally displays the address of the "active cell" on the worksheet.

Data or Formula of the Current Active Cell can be viewed inside the Cell Contents box of the Excel Formula bar

Explanation

Algorithm and Flowchart are tools used to:

• Define a problem
• Break it down into smaller steps
• Logically organize those steps
• Visually represent the process

They help to:

• Specify the problem completely and clearly
• Identify the steps needed to solve the problem
• Understand the logical flow of the solution
• Communicate the solution to others

Explanation

A corrupted Partition Table can make a hard disk totally inaccessible, as it contains information about the disk's partitions and how data is organized.

If the Partition Table is damaged, the operating system may not be able to recognize the disk or access its contents.

Explanation

The Cascade Delete option is a database feature that automatically deletes all related records in a child table when a record is deleted from a parent table.

This helps maintain data consistency and integrity by ensuring that all related data is removed when a primary record is deleted.

Explanation

Mac OS is an operating system developed and marketed by Apple Inc. since 2001.

It is the primary operating system for Apple's Mac computers.

Explanation

In MS Excel 2016, you can split the window into two panes using the following steps:

• Go to the "View" tab in the ribbon
• Click on "Window" in the "Window" group
• Select "Split" from the dropdown menu

Alternatively, you can also use the shortcut key:

Alt + W + S

Explanation

In MS word, Bookmark is a specific word, section, or location in our Word document

That we want to name and identify for future reference. 

Explanation

Using navigation keys

Page Up: Move the cursor or page up one screen.

Ctrl + Home: Move to the top of a document.

Ctrl + End: Move to the bottom of a document.

Page Down: Move the cursor or page down one screen.

Explanation

Syntax refers to the rules and structure of data, including the format, order, and organization of data elements.

Syntax defines how data is represented, stored, and transmitted.