Worksheetswp and sp
Total questions: 22
Worksheet time: 12mins
word processing application that allows you to create a variety of documents like letters, flyers, and reports
Microsoft Word
Microsoft Excel
Microsoft Powerpoint
Word Excel
it is on the top of the window when you open a microsoft word application. It contains opened application name (Microsoft word in this case ), by default file nome (documentl) in the center, control buttons (clore, maximize, minimize) in right side and quick accers tools (word logo , save, undo -redo function) on the ieft side.
worksheet window
title bar
menu bar
worksheet control button
tools that are used to create all kinds of professional - looking documents in Microsoft word.
tool bar
menu bar
status bar
ruler bar
category of functions and features dived under menus according to their use. such as under Home Menu, you con find Clip Board, Font, Paragraph, etc. These are the subcategories off Main MenU Bar.
menu bar
ruler bar
tool bar
You can set margin and paragraph spaces by using it. This is used to align the documents, page margins so when you print the document it will look professional.
ruler bar
scrolling bar
tool bar
status bar
used to scroll the page up /down and right left when the page zoom is high or low
scrolling bar
ruler bar
status bar
menu bar
It showcase page number, total words, reiected words .etc. its main work is the display status of the page. You can find spelling and grammatical prostreading Option in the right after page number and words. on the rignt side of status bar
status bar
tool bar
menu bar
scrolling bar
customise documents like emails, newsletters, and other personalized messages.
mail merge
quick access toolbar
ribbon
worksheet window
Mail merges can be used to crease personalized messages to create personalized messages dutomatically for documents such as
marketing emails
gdocs
newsletter
form letters
two components of mail merge
template file
word file
title file
data file
document that youll be sending out like a letter or an email. It contains placeholders for the personalization data (names, addresses, etc.) that are fetched from a data file.
template file
data file
word file
title file
This is a data source like a Microsoft Excel spreadsneet or a croogle sheets file. It contains the personalized information (names, addresses, etc.) that will be added to your template file
google file
template file
data file
title file
3 personalization variables in document
(a)
it is a spreadsneet program that is used to record and analyses. numerical data.
Microsoft Powerpoint
Spreadsheet
Microsoft Excel
Microsoft Word
Allows You to minimize. maximize restore, or close the worksheet
worksheet Control Button
Formula Bar
Worksheet window
File Button
I It contains the open active worksneetit can be moved and sized.
worksheet Control Button
Scroll Bars
Worksheet window
Title Bar
alculates the average value in a range of cells
AVERAGE
RANGE
SUM
CRITERIA
Returns the number of characters in a string text
LEN
SUMIF
ROUND
ISNUMBER
Usage of LEN
LEN (B7)
LEN (D4:D8,''>1000'', C4:C8)
LEN (D4:D8,''Yes'', C4:C8)
LEN (E4:E8)
Usage of SUMIF
SUMIF (D4:D8,''>1000'', C4:C8)
SUMIF (D4:D8,''Yes'', C4:C8)
SUMIF (D4,C4)
SUMIF (B7)
Usage of AVERAGEIF
AVERAGEIF (D4:D8,''>1000'', C4:C8)
AVERAGEIF (D4:D8,''Yes', C4:C8)
AVERAGEIF (C4:C8)
AVERAGEIF (D4,C4)
the so called table array
VLOOKUP Function
Vertical Lookup
Numerical function
Common Function
