GMetrix - Excel 2024
Core Skill Review 3
questions and answers
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 Click
to add header. 3. Select the left section of the header. 4. In the
Header & Footer Tools/Design tab, Header & Footer Elements
group, select File Name. 5. Select the right section of the
header. 6. In the Header & Footer Tools/Design tab, Header &
Footer Elements group, select Sheet Name. 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.
1. In the View tab, locate the Workbook Views group, and click
Page Layout. 2. Place your cursor anywhere in the header or
footer to make the Header & Footer Tools/Design tab show. 3.
In the Header & Footer Tools/Design tab, locate the Header &
Footer group, and click the Footer drop down. 4. Select any
option that includes the author's name, page number, and
current date.
Remove all comments, annotations, personal information and
document properties in the workbook.
1. In the File tab, select the Info option.2. Select Check for
Issues. In the drop-down menu, choose Inspect Document.3.
Make sure that only Comments and Annotations, and
Document Properties and Personal Information are selected.
Click Inspect.4. Click Remove All for Comments and
Annotations, and Document Properties and Personal
Information.5. Click Close.
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 drop down 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 Salesworksheet.2. Select cells A1:G26. In the
Home tab, Clipboard group, select Copy. 3. Open the 2009 Sales
(Corrected) worksheet and select cell A14. In the Home tab,
Clipboard group, select the drop down 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 (keep source) Formatting.
Add the text Sunday to cell A2 and enumerate the days of the
week 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. The pointer should change
from a thick white cross to a thin black cross. 5. Click and drag
to cell A8. 6. Release the mouse button. The cell range should
now display the days of the week.
Add the text January to cell B1and enumerate the months of
year from cell C1 to M1.
1. Click cell B1.2. Type January and hit the ENTER key.3. Click
cell B1 again.4. Move your cursor over the AutoFill handle at
Core Skill Review 3
questions and answers
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 Click
to add header. 3. Select the left section of the header. 4. In the
Header & Footer Tools/Design tab, Header & Footer Elements
group, select File Name. 5. Select the right section of the
header. 6. In the Header & Footer Tools/Design tab, Header &
Footer Elements group, select Sheet Name. 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.
1. In the View tab, locate the Workbook Views group, and click
Page Layout. 2. Place your cursor anywhere in the header or
footer to make the Header & Footer Tools/Design tab show. 3.
In the Header & Footer Tools/Design tab, locate the Header &
Footer group, and click the Footer drop down. 4. Select any
option that includes the author's name, page number, and
current date.
Remove all comments, annotations, personal information and
document properties in the workbook.
1. In the File tab, select the Info option.2. Select Check for
Issues. In the drop-down menu, choose Inspect Document.3.
Make sure that only Comments and Annotations, and
Document Properties and Personal Information are selected.
Click Inspect.4. Click Remove All for Comments and
Annotations, and Document Properties and Personal
Information.5. Click Close.
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 drop down 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 Salesworksheet.2. Select cells A1:G26. In the
Home tab, Clipboard group, select Copy. 3. Open the 2009 Sales
(Corrected) worksheet and select cell A14. In the Home tab,
Clipboard group, select the drop down 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 (keep source) Formatting.
Add the text Sunday to cell A2 and enumerate the days of the
week 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. The pointer should change
from a thick white cross to a thin black cross. 5. Click and drag
to cell A8. 6. Release the mouse button. The cell range should
now display the days of the week.
Add the text January to cell B1and enumerate the months of
year from cell C1 to M1.
1. Click cell B1.2. Type January and hit the ENTER key.3. Click
cell B1 again.4. Move your cursor over the AutoFill handle at
