Excel Associate 2024-
2025 Skill Review 3
(solved)
Format the cell range A5:D106 to use center horizontal
alignment
1. Select cells A5:D106
2. In the Home tab, Alignment group, click the center button
Insert a header that contains the filename on the left side and
sheet on the right side. Close the header before grading.
1. In the View tab, Workbook Views group, select the Page
layout button
2. On the first page of the worksheet, select Add Header
3. Select the left section of the header.
4. In the Header & Footer contextual tab, Header & Footer
Elements group, select File Name
5. Select the right section of the header
6. In the Header & Footer contextual tab, Header & Footer
Elements group, select SheetName
7. Click anywhere outside of the header to close
,Brainpower
Read More
Insert a footer at the bottom that contains the author, page
number, and current date in that order
1. In the View, locate the Workbook Views group and click Page
layout
2.Place your cursor anywhere in the header or footer to make
the Header & Footer contextual tab show
3. In the Header & Footer contextual tab, locate the Header &
Footer group and click the Footer dropdown
4. Select the option that includes the author's name, page,
number, and current date in that order
Insert a new worksheet named 2009 Sales (Corrected) between
the 2009 Sales and 2010 Sales worksheets.
1. Select the 2010 Sales Worksheet
2. In the Home tab, Cells group, select the dropdown for Insert.
Select Insert Sheet
3. Double-click on the new worksheet's tab named Sheet1
4. Type 2009 Sales (Corrected) and hit the ENTER key
Paste only the values from the cell range A1:G26 in the 2009
Sales worksheet to cell range A1:G26 in the 2009 Sales
(Corrected) worksheet.
1. Open the 2009 Sales worksheet
2. Select cells A1:G26. In the Home tab, Clipboard group, select
Copy
, 3. Open the 2009 Sales (Corrected) worksheet and select cell A1
4. In the Home tab, Clipboard group, select the dropdown for
Paste. Select Values
Copy only the formatting from the cell range A1:G26 in the
2009 Sales worksheet to the 2010 Sales worksheet.
1. Open the 2009 Sales worksheet
2. Select cells A1:G26. In the Home tab, Clipboard group, select
Copy
3. Open the 2010 Sales worksheet
4. In the Home tab, Clipboard group, select the drop down for
Paste. Select Formatting
Add the text Sunday to cell A2 and enumerate the days of the
weeks from cell A3 to A8
1. Click cell A2
2. Type Sunday and hit the ENTER key
3. Click on cell A2 again
4. Move your cursor over the Autofill handle at the lower right
corner of the cell.
5. Click and drag to cell A8
6. Release the mouse button
Add the text January to cell B1 and enumerate the months of
the year from cell C1 to M1.
1. Click cell B1
2. Type January and hit the ENTER key
3. Click on cell B1 again
2025 Skill Review 3
(solved)
Format the cell range A5:D106 to use center horizontal
alignment
1. Select cells A5:D106
2. In the Home tab, Alignment group, click the center button
Insert a header that contains the filename on the left side and
sheet on the right side. Close the header before grading.
1. In the View tab, Workbook Views group, select the Page
layout button
2. On the first page of the worksheet, select Add Header
3. Select the left section of the header.
4. In the Header & Footer contextual tab, Header & Footer
Elements group, select File Name
5. Select the right section of the header
6. In the Header & Footer contextual tab, Header & Footer
Elements group, select SheetName
7. Click anywhere outside of the header to close
,Brainpower
Read More
Insert a footer at the bottom that contains the author, page
number, and current date in that order
1. In the View, locate the Workbook Views group and click Page
layout
2.Place your cursor anywhere in the header or footer to make
the Header & Footer contextual tab show
3. In the Header & Footer contextual tab, locate the Header &
Footer group and click the Footer dropdown
4. Select the option that includes the author's name, page,
number, and current date in that order
Insert a new worksheet named 2009 Sales (Corrected) between
the 2009 Sales and 2010 Sales worksheets.
1. Select the 2010 Sales Worksheet
2. In the Home tab, Cells group, select the dropdown for Insert.
Select Insert Sheet
3. Double-click on the new worksheet's tab named Sheet1
4. Type 2009 Sales (Corrected) and hit the ENTER key
Paste only the values from the cell range A1:G26 in the 2009
Sales worksheet to cell range A1:G26 in the 2009 Sales
(Corrected) worksheet.
1. Open the 2009 Sales worksheet
2. Select cells A1:G26. In the Home tab, Clipboard group, select
Copy
, 3. Open the 2009 Sales (Corrected) worksheet and select cell A1
4. In the Home tab, Clipboard group, select the dropdown for
Paste. Select Values
Copy only the formatting from the cell range A1:G26 in the
2009 Sales worksheet to the 2010 Sales worksheet.
1. Open the 2009 Sales worksheet
2. Select cells A1:G26. In the Home tab, Clipboard group, select
Copy
3. Open the 2010 Sales worksheet
4. In the Home tab, Clipboard group, select the drop down for
Paste. Select Formatting
Add the text Sunday to cell A2 and enumerate the days of the
weeks from cell A3 to A8
1. Click cell A2
2. Type Sunday and hit the ENTER key
3. Click on cell A2 again
4. Move your cursor over the Autofill handle at the lower right
corner of the cell.
5. Click and drag to cell A8
6. Release the mouse button
Add the text January to cell B1 and enumerate the months of
the year from cell C1 to M1.
1. Click cell B1
2. Type January and hit the ENTER key
3. Click on cell B1 again
