51
EXL
2
A
lmostallWebsitesthesedayscontainafrequentlyaskedquestions
(FAQs)section.FAQsprovidevisitorsareliableplacetofindanswers
tocommonquestions.Theycanbegroupedtogethercategoricallyorlisted
alphabetically.Thequestionsdonotnecessarilyhavetobefrequentlyasked,
butcouldinsteadbequestionsthatthecompanywishestobringtothe
reader'sattention.
1. ThewraptextfeatureinExcelwillformattextonmultiplelineswithinacell.
2. Readthroughallinstructionspriortocompletingtheproject.
1. UsingMicrosoftExcel,createanewblankworkbook.
2. SavetheworkbookasProjectEXL-2FAQsinyour"Excel"folderunder"The
Hub" folder.
3. KeythedataasitappearsinFigureEXL-2.1intothespreadsheet.Unless
otherwisenoted,thefontshouldbesettoArial10point.
4. Formatthetextinrow1to18pointbold.
5. FormatthewidthofcolumnsAandBto35anduseAutoFittoresizecolumnsC
through F.
6. ApplywraptexttocolumnsAandB.
7. Sort the list in ascending order by Category.
8. Carefully proofread your work for accuracy and format.
9. Resavethefile.
10. SetthePrintAreatoincludeallcellscontainingdatainthespreadsheet.
11. Print Preview and adjust Page Setup with the following changes:
· Paperorientationshouldbelandscape
· Pagemarginsshouldbe.25inchesonallsides
· The sheet should show gridlines
· Thescalingshouldbesettofittoonepage
12. Print a copy of the document if required by your instructor.
your TASK
Your task is to create
a list of frequently
asked questions about
The Hub that the
webmaster can use as
content on The Hub's
Web site. The list will
be sorted by type of
question so that "like"
questions are found
together. Additionally,
the spreadsheet will
contain up to three
key words a Web site
visitor might search
on when looking for a
particular FAQ.
the SKILLS
· Sort data
· Formattext
· Applywordwrap
Web Site FAQs
For Evaluation Purposes Only