FUNDAMENTALS OF COMPUTER

USING MICROSOFT EXCEL

HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
View that shows the “background” or working of a table
A
design view
B
datasheet view
C
form view
D
layout view
Explanation: 

Detailed explanation-1: -While Datasheet view lets you work directly with the data in tables, Design view takes you behind the scenes to work with the table structure. In Design view you have much finer control over how the fields in your data are defined and validated. You can open a closed table in Design view with just a few clicks.

Detailed explanation-2: -Select the table whose properties you want to set. On the Home tab, in the Views group, click View, and then click Design View.

Detailed explanation-3: -the datasheet view displays all the values of calculation fields and their records. In the design view, the tables can be created and modified. For example, if the table is Medical then it can be created for storing all the values for calculation.

Detailed explanation-4: -The layout view allows you to define a common site template, which can be inherited in multiple views to provide a consistent look and feel in multiple pages of an application. The layout view eliminates duplicate coding and enhances development speed and easy maintenance.

There is 1 question to complete.