DATABASE FUNDAMENTALS
USING THE UPPER AND LOWER FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
False
|
|
|
True
|
|
|
Right-click on style and choose duplicate
|
|
|
None of the above
|
Detailed explanation-1: -To modify a custom table style, go to the Table Styles gallery, right-click on the style, and click Modify… To delete a custom table style, right-click on it, and select Delete.
Detailed explanation-2: -Select any cell in the table you want to use to create a custom style. On the Home tab, click Format as Table, or expand the Table Styles gallery from the Table Tools > Design tab (the Table tab on a Mac). Click New Table Style, which will launch the New Table Style dialog.
Detailed explanation-3: -(First make sure your selected cell is anywhere in the data set that you want to convert into a table). The keyboard shortcut for this procedure is Ctrl + T . This will bring up the Create Table box, which is prepopulated with the existing boundaries of the data set you’re in.