1
Dự án giáo dục TinZ Chứng chỉ Tin học Quốc tế MOS
ĐỀ THI THỬ SỐ 1
PROJECT 1
1. Configure the “Expenses Log” worksheet so rows 1 through 2 remain visible as you
scroll vertically.
2. Move the chart on the “Dashboard” worksheet to its own chart sheet named
“TinZChart”.
3. In cell H1 on the “Expense Log” worksheet, calculate Total amount expense of all
categories.
4. In the cell range G2:H2 on the “Expense Log” worksheet, merge all cells into a single
cell with center aligned. Then change the horizontal alignment of the cells above to Left
(indent) with indent of 2.
5. Locate the “Expenses” table, add a row to the table that automatically calculates total
Amount. Use an available feature of table. The result should be shown in cell E23.
6. Change the orientation of the “Expense Log” worksheet to Portrait. Fill sheet on one
page only.
7. On the “Dashboard” worksheet, set the Page margins to the following specifications:
Top & Bottom: 1.18" (3 cm), Left & Right: 1" (2.54 cm) and Footer & Header: 0.3” (0.76
cm).
PROJECT 2
1. On the “Summary” worksheet, include “Actual” of “Budget Totals” to the “Budget
Overview” Chart. Do not change other settings.
2. Add the text “MOS budget” as the document Subject property of the document.
3. Locate the “Table_1” table and extend the formula in cell F5 to the end of the column.
4. On the “Summary” worksheet, remove the entire row that contains “Maintenance and
repair” data. Do not change any content outside the table.
5. On the “Expenses” worksheet, in cell J4, use a function to determine how many
Operating Expenses do not have a “Actual” value.
6. Split the view of the “Expenses” worksheet so row 1 through row 2 appear in the top
pane and the remaining rows appear in the bottom pane.
7. Move the row “Asset sales (gain/loss)” of the Income table on the “Summary”
worksheet to before row “Interest income”.
