Guia Prático de Excel para Ficha 4D
Enviado por
maria JoãoGuia Prático de Excel para Ficha 4D
Enviado por
maria JoãoCommon questions
Com tecnologia de IAGraphical elements include placing an image of a computer between the 1st and 6th lines on the left and creating a WordArt effect with the store's name on the same sheet .
Text in the 'Factura' table should use Arial font at 10 points, with bold applied to all words in the table .
Column widths should be set to 6 for the first column, 30 for the second, and 14 for the rest. The 7th line height should be 18, 8th should be 6, 9th should be 27, 10th should be 6, with other lines set to normal height .
The formula to calculate age requires entering the birth date in cell D3 and then using a formula in cell D7 that subtracts this date from the current date provided in another cell (D5).
Sheet 2 must be renamed to 'Factura', and the tab color for the 'Factura' sheet should be changed to red .
When entering currency data in the new Excel workbook, cells in column B should be formatted to display values with the currency symbol €. Date data in column C must be checked for the format configuration: either the American format (Month-Day-Year) or the Portuguese usual format (Day-Month-Year).
In the Excel worksheet, the formula to calculate the sum should be placed in cell B6 for values in cells B2 to B5. The average is calculated in cell B7 for the same range. Maximum and minimum values are calculated in cells B8 and B9 respectively for values B2 to B5 .
To create a billing table, use 'Quantidade X Preço Unitário' to calculate Total Parcial. Total Ilíquido is the sum of a specific column. Desconto is 15% of Total Ilíquido, and I.V.A is 19% of the gross total. Total a Pagar is calculated as Total líquido – Desconto + I.V.A .
The page configuration for the second sheet requires setting the top margin to 4 cm, bottom to 2.5 cm, header and footer to 1.5 cm, and right and left to 1.5 cm .
The header of the Excel worksheet should contain the school symbol on the left and the title 'Escola Secundária José Belchior Viegas' at the center. The footer should have the user's name and number centered .