DATABASE FUNDAMENTALS
HOW TO USE THE CONCATENATE FUNCTION IN EXCEL
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
Data
|
|
Insert
|
|
Home
|
|
View
|
Detailed explanation-1: -On the Layout tab, under View, click Page Layout. On the Layout tab, under Page Setup, click Header & Footer.
Detailed explanation-2: -On the Insert tab, in the Text group, click Header & Footer. Excel displays the worksheet in Page Layout view. Click the left, center, or right header or footer text box at the top or the bottom of the worksheet page.
Detailed explanation-3: -To make your printed Excel documents look more stylish and professional, you can include a header or footer on each page of your worksheet. Generally, headers and footers contain basic information about the spreadsheet such as page number, current date, workbook name, file path, etc.
Detailed explanation-4: -Headers are located in the margin area at the top of the page. Footers are located in the margin area at the bottom of a page. Headers and footers generally contain document information, such as the file name, author, date created, page numbering and the like.
Detailed explanation-5: -The Insert tab contains various items that you may want to insert into a document. These items include such things as tables, word art, hyperlinks, symbols, charts, signature line, date & time, shapes, header, footer, text boxes, links, boxes, equations and so on.