Exam (elaborations)
GMetrix - Excel 2024 Core Skill Review 3 questions and answers.
- Course
- Institution
GMetrix - Excel 2024 Core Skill Review 3 questions and answers.
[Show more]
Content preview
GMetrix - Excel 2024Core 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
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller BRAINBOOSTERS. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $14.49. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
78861 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now