Wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

wp and sp

Total questions: 22

Worksheet time: 12mins

Name
Class
Date
1.

word processing application that allows you to create a variety of documents like letters, flyers, and reports

a)

Microsoft Word

b)

Microsoft Excel

c)

Microsoft Powerpoint

d)

Word Excel

2.

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.

a)

worksheet window

b)

title bar

c)

menu bar

d)

worksheet control button

3.

tools that are used to create all kinds of professional - looking documents in Microsoft word.

a)

tool bar

b)

menu bar

c)

status bar

d)

ruler bar

4.

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.

a)

menu bar

b)

ruler bar

c)

tool bar

5.

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.

a)

ruler bar

b)

scrolling bar

c)

tool bar

d)

status bar

6.

used to scroll the page up /down and right left when the page zoom is high or low

a)

scrolling bar

b)

ruler bar

c)

status bar

d)

menu bar

7.

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

a)

status bar

b)

tool bar

c)

menu bar

d)

scrolling bar

8.

customise documents like emails, newsletters, and other personalized messages.

a)

mail merge

b)

quick access toolbar

c)

ribbon

d)

worksheet window

9.

Mail merges can be used to crease personalized messages to create personalized messages dutomatically for documents such as

a)

marketing emails

b)

gdocs

c)

newsletter

d)

form letters

10.

two components of mail merge

a)

template file

b)

word file

c)

title file

d)

data file

11.

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.

a)

template file

b)

data file

c)

word file

d)

title file

12.

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

a)

google file

b)

template file

c)

data file

d)

title file

13.

3 personalization variables in document

(a)  

14.

it is a spreadsneet program that is used to record and analyses. numerical data.

a)

Microsoft Powerpoint

b)

Spreadsheet

c)

Microsoft Excel

d)

Microsoft Word

15.

Allows You to minimize. maximize restore, or close the worksheet

a)

worksheet Control Button

b)

Formula Bar

c)

Worksheet window

d)

File Button

16.

I It contains the open active worksneetit can be moved and sized.

a)

worksheet Control Button

b)

Scroll Bars

c)

Worksheet window

d)

Title Bar

17.

alculates the average value in a range of cells

a)

AVERAGE

b)

RANGE

c)

SUM

d)

CRITERIA

18.

Returns the number of characters in a string text

a)

LEN

b)

SUMIF

c)

ROUND

d)

ISNUMBER

19.

Usage of LEN

a)

LEN (B7)

b)

LEN (D4:D8,''>1000'', C4:C8)

c)

LEN (D4:D8,''Yes'', C4:C8)

d)

LEN (E4:E8)

20.

Usage of SUMIF

a)

SUMIF (D4:D8,''>1000'', C4:C8)

b)

SUMIF (D4:D8,''Yes'', C4:C8)

c)

SUMIF (D4,C4)

d)

SUMIF (B7)

21.

Usage of AVERAGEIF

a)

AVERAGEIF (D4:D8,''>1000'', C4:C8)

b)

AVERAGEIF (D4:D8,''Yes', C4:C8)

c)

AVERAGEIF (C4:C8)

d)

AVERAGEIF (D4,C4)

22.

the so called table array

a)

VLOOKUP Function

b)

Vertical Lookup

c)

Numerical function

d)

Common Function