wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

Questions Publish - DITEC-02

Total questions: 91

Worksheet time: 46mins

Name
Class
Date
1.

What is the file type of Microsoft Word Document?

a)

.docx

b)

.word

c)

.msoffice

d)

None of the Above

2.

Name the Software shown in the picture

a)

MS OFFICE

b)

MS WORD

c)

Notepad

d)

None of the above

3.

Select the correct format of a IF Condition

a)

=IF(Logical Test, Display Correct Answer)

b)

=IF(Logical Test, Value if True, Value is False)

c)

=IF((Logical Test, Value if True, Value is False))

d)

None of the above

4.

What does the red wavy line under words or phrase mean?

a)

The word or phrase might be misspelled

b)

The word or phrase has been copied to the clipboard

c)

The word or phrase might contain a grammatical error

d)

None of the above

5.

What type of application is Microsoft Excel?

a)

Word processing Application

b)

Spreadsheet Application

c)

Graphic software

d)

Database Management System

6.

An Excel Workbook is a collection of ________

a)

Books

b)

Worksheets

c)

Charts

d)

documents

7.

By default, on which page the header or the footer is printed?

a)

on first page

b)

on alternate page

c)

on every page

d)

Non of the above

8.

A File which contains readymade styles that can be used for a presentation is called

a)

Auto Style

b)

Template

c)

Wizard

d)

Pre formatting

9.

In Excel where is the current cell address displayed

a)

Formula bar

b)

Status Bar

c)

Name Box

d)

Title Bar

10.

To open the existing presentation, press

a)

CTRL + L

b)

CTRL + V

c)

CTRL + S

d)

CTRL + O

11.

Which key can be used to display slideshow?

a)

F2

b)

F5

c)

F7

d)

F12

12.

The cell reference for cell range of G2 to M12 is _______

a)

G2.M12

b)

G2 : M12

c)

G2 : M12

d)

G2:M12

13.

What does COUNTA () function do?

a)

counts only cells having alphabets

b)

counts empty cells

c)

counts only cells having numbers

d)

counts non-empty cells

14.

Using the above picture, select the correct formula to display the average price on the excel application

a)

=avg(a2:a6)

b)

=Avg(A2:A6)

c)

=Average(A2:A6)

d)

None of the above

15.

The first cell in EXCEL worksheet is labeled as

a)

Aa

b)

AA

c)

A0

d)

A1

16.

In MS Excel, a ________ is a grid with labeled columns and rows.

a)

Dialog box

b)

Worksheet

c)

Clipboard

d)

Toolbar

17.

In order to perform a calculation in a spreadsheet, you need to use a:

a)

table

b)

formula

c)

field

d)

Variable

18.

In Excel, by default Numeric Values appears in

a)

Left aligned

b)

Right aligned

c)

Center aligned

d)

Justify aligned

19.

Using the picture above in which cell reference would the total price of Pineapple be displayed

a)

D1

b)

B5

c)

D5

d)

5D

20.

Working layout in MS- Word is;

a)

Normal view

b)

Web Lay out

c)

Print Layout

d)

Outline

21.

Using the picture below select the correct formula to display the total price of grapes;

a)

=B1+C1

b)

=B3+C3

c)

=B3*C3

d)

=sum(B3:C3)

22.

Using the picture below select the answer which states the correct cell name which contains the quantity of watermelon;

a)

A6

b)

B6

c)

C6

d)

6C

23.

What does = COUNT() function do?

a)

Counts cells having alphabets

b)

Counts empty cells

c)

Counts cells having number

d)

Counts non-empty cell

24.

Using the picture below select the correct formula to display the maximum price

a)

=maximum(B2:B6)

b)

=max(B2:B6)

c)

=displaylargestvalue(A1:B6)

d)

None of above

25.

Using the picture below select the correct formula to display the minimum quantity amount;

a)

=sum(C2:C6)

b)

=min(C2:C6)

c)

=minimum(C1:C6)

d)

=minimum(C2:C6)

26.

A function inside another function is called ______

a)

Nested function

b)

Round function

c)

Sum function

d)

Text function

27.

What is the name of the tool shown in picture below;

a)

Bold

b)

Italic

c)

Left Align

d)

None of the above

28.

What is the name of the tool shown in picture below;

a)

Bold

b)

Italic

c)

Font

d)

None of the above

29.

What is the name of the tool shown in picture below;

a)

Undo

b)

Redo

c)

Print

d)

Italic

30.

What is the name of the tool shown in picture below;

a)

Bold

b)

Uppercase

c)

Delete

d)

Strikethrough

31.

What is the name of the tool shown in picture below;

a)

Strikethrough

b)

Superscript

c)

Subscript

d)

None of the above

32.

What is the name of the tool shown in picture below;

a)

Alphabet

b)

Increase Font Size

c)

Capitalize all words

d)

None of the above

33.

What is the name of the tool shown in picture below;

a)

Increase Indent

b)

Decrease Indent

c)

Draw Line

d)

None of the above

34.

What are the changes that can be made when the document is in print preview

a)

Bold, Italic, Highlighting

b)

Orientation, Page size, Margin

c)

Background style, Margin, Size

d)

Orientation, Page border, Page size

35.

What is the name of the tool shown in picture below;

a)

Draw Lines

b)

Page Margin

c)

Borders

d)

None of the above

36.

What is the name of the tool shown in picture below;

a)

Eraser

b)

Delete Font

c)

Clear All Formatting

d)

None of the Above

37.

What is the shortcut key to open a new document

a)

Ctrl+N

b)

Shift+N

c)

Shift+F11

d)

Ctrl+F11

38.

What is the function of the tool shown in picture below;

a)

Increase the font Size

b)

Change the page Size

c)

Change the size of images

d)

None of the above

39.

What is the function of the tool shown in picture below;

a)

Change between portrait and landscape

b)

Change the Size of the document

c)

Change the style of the font

d)

None of the above

40.

What is the function of the tool shown in picture below;

a)

Copy Formatting

b)

Change the font Colour

c)

Apply a background colour

d)

None of the above

41.

What is the function of the tool shown in picture below;

a)

Increase Decimal Places

b)

Decrease Decimal Places

c)

Delete the Numbers

d)

None of the above

42.

What is the function of the tool shown in picture below;

a)

Delete the content of the selected cells

b)

Combines and centers selected cells

c)

Splits and centers cells

d)

None of the above

43.

What is the function of the tool shown in picture below;

a)

Wraps extra long text into multiple lines so all of it can be seen.

b)

Merges cells so all text can be seen

c)

Reduces the font size of the text so all of it can be seen

d)

None of the above

44.

What is the function of the tool shown in picture below;

a)

It is used to type numbers into cells

b)

It allows you to apply formats to all cells regardless of the value

c)

It allows you to apply formats to cells depending on its value

d)

None of the above

45.

What are the presentation views

a)

Slideshow view, Normal view, Over view

b)

Normal view, Slide shorter view, Reading View, Slide show view

c)

Slideshow view, Slide shorter view, Over view

d)

Normal view, Over view, Slide shorter view

46.

What do you mean by "Slide Transition" in MS Power Point?

a)

Letters

b)

Overheads

c)

The way to look a slide

d)

An especial effect to introduce a slide in slide show

47.

How can you stop a slide show in MS PowerPoint?

a)

By press Space bar on the keyboard

b)

By pressing any number on the keyboard

c)

By pressing the Esc key on the keyboard

d)

Shutdown the computer.

48.

Select the correct keyboard shortcut which you can use to slideshow the current slide you are viewing:

a)

Alt + F4

b)

Enter

c)

Shift + F5

d)

F5

49.

In MS Power point a Slide can have

a)

Title, Text, Graphs

b)

Objects, Shapes

c)

Audio

d)

All of the Above

50.

What is the function of the tool shown in picture below;

a)

It is used to draw arrows

b)

It is used to rotate text

c)

It is used to insert text

d)

None of the above

51.

A Power Point Presentation is a collection of?

a)

Slides and Handouts

b)

Documents

c)

Spreadsheet

d)

None of the above

52.

What is the name of the tool shown in picture below;

a)

Bucket Tool

b)

Fill Tool

c)

Paint Tool

d)

None of the above

53.

The file type of Excel Documents is .docx

a)

TRUE

b)

FALSE

54.

A3 & A4 are;

a)

Page Orientations

b)

Paper Size

c)

Page Layout

d)

All of above

55.

What is the name of the function which we can use to repeat the slideshow continuously;

a)

Loop continuously until 'Esc'

b)

Repeat forever

c)

Loop more

d)

None of the above

56.

The arrangement of elements such as Title and subtitle text, pictures, tables etc. in Powerpoint is called

a)

Layout

b)

Presentation

c)

Design

d)

Scheme

57.

The file type of a Powerpoint Document is .xlsx

a)

TRUE

b)

FALSE

58.

What do you call the effect of moving text and images

a)

Color Schemes

b)

Animations

c)

Slide Transition

d)

Handouts

59.

Accidently you happened to make a mistake while working with your document. What short-cut key you will use to reverse the action?

a)

Ctrl+Z

b)

Ctrl+A

c)

Ctrl+X

d)

Ctrl+Y

60.

To insert new slide in the current Presentation, we can choose

a)

CTRL+M

b)

CTRL+N

c)

CTRL+O

d)

CTRL+S

61.

In MS Excel, B7:B9 indicates:

a)

Cells B7 and cell B9 only

b)

Cells B7 through B9

c)

Cell B8 only

d)

None of the above

62.

What are the methods that can be used to add new Slides to a Powerpoint Presentation?

a)

1. Press CTRL key with M key 2. Click Slide Show and select New Slide 3. Click Insert then Slides and select New Slide 4. Right Click on Overview Pane and select New Slide 5. Click Design then Themes and select New Slide

b)

A. Use the Format tab and select Add Slide

c)

B. Go to File and choose New Slide

d)

C. Select Review and click on New Slide

63.

What are the presentation views of a Powerpoint Presentation?

a)

1. Transition View 2. Animation View 3. Normal View 4. Outline View 5. Slide Sorter View

b)

1. Print Layout View 2. Web Layout View 3. Reading View 4. Master View 5. Slide Show View

c)

1. Design View 2. Notes Page View 3. Grid View 4. Handout View 5. Slide Master View

d)

1. Draft View 2. Page Layout View 3. Web View 4. Slide View 5. Outline Master View

64.

Select the methods to change the background color of a Slide

a)

applying Themes from the Design tab applying Layouts from Home tab using Format Background option by right clicking on the Slide applying Animations using Transitions

b)

Using Slide Sorter view

c)

Inserting a Chart

d)

Adding a Header and Footer

65.

How do you start a PowerPoint presentation?

a)

by pressing F5 key

b)

Review->Spelling & Grammar

c)

Design->Themes

d)

Insert->Picture->From File

e)

Slideshow->Start Slideshow->From Beginning

66.

Identify the paragraph alignments of MS Word

a)

Align Left Center Align Right Justify Align Down

b)

Bold Italic Underline Strikethrough Highlight

c)

Insert Table Insert Picture Insert Chart Insert Symbol Insert Shape

d)

Spell Check Word Count Track Changes Comments Thesaurus

67.

Which of these ways can be used to add a Table to an MS word document?

a)

Insert->Table->Insert Table 2. Insert->Table->Draw Table 3. Design->Tables 4. Insert->Table->Quick Tables 5. Page Layout->Page Setup->Table

b)

Insert->Picture->Table

c)

References->Insert Table

d)

Review->Add Table

e)

Mailings->Table

68.

Mail Merge option of MS Word can be used with:

a)

Letters

b)

Charts

c)

Email messages

d)

Word Arts

e)

Envelopes

69.

What are the Page Orientations available for an MS Word document?

a)

Left Align

b)

Landscape

c)

Justify

d)

Portrait

e)

Center

70.

What are the Illustrations that can be inserted into an MS Word document?

a)

Pictures

b)

Shapes

c)

Functions

d)

Smart Arts

e)

Charts

71.

What are the Illustrations that can be inserted into an MS Word document?

a)

Pictures

b)

Shapes

c)

Functions

d)

Smart Arts

e)

Charts

72.

Which file format can not be added to a PowerPoint show?

a)

.gif

b)

.jpg

c)

.wav

d)

.iso

e)

All of the above

73.

What is the term used when you press and hold the left mouse key and move the mouse around the slide?

a)

Moving

b)

Monitoring

c)

Dragging

d)

Highlighting

e)

Cutting

74.

Can NOT start MS Word in a computer by

a)

Clicking on the MS word option on the Start Menu

b)

Right clicking on the MS Word option on the Start menu

c)

Selecting MS Word icon on the desktop

d)

Double clicking on the MS Word icon on the desktop

e)

Right clicking & select Open on the MS Word icon on the desktop

75.

The Font Dialog box facility cannot be used to

a)

Underline text

b)

Set page setup

c)

Apply text effects

d)

Check the spellings

e)

Change font color

76.

In MS-Word, for what does ruler help?

a)

To set tabs

b)

To set indents

c)

To change page margins

d)

To change the font

e)

None of the above

77.

You made a mistake while working with a document how do you reverse the action?

a)

Ctrl + Z

b)

Ctrl + C

c)

Undo

d)

Ctrl + X

e)

Ctrl + S

78.

If you need to change the "Font" of a word

a)

Home Tab – Font Group

b)

Home Tab – Styles Group

c)

Use the Mini Tool Bar

d)

Home Tab – Design Group

e)

None of the above

79.

Which of the following is not a Font Style?

a)

Regular

b)

Italic

c)

Bold

d)

Subscript

e)

Superscript

80.

Which option will you use to join some cells and place the content at the middle of the joined cell?

a)

Wrap Text

b)

Center Alignment

c)

Merge and center

d)

Justify

e)

All of above

81.

Which of the following is not the correct method of editing cell content?

a)

Press the Alt key

b)

Press F8

c)

Press the F2 key

d)

Click the formula bar

e)

Double click the cell

82.

Which option can be used to break down a long text into many lines within the cell?

a)

Wrap Text in Format >> Cells

b)

Justify in Edit >> Cells

c)

Text Wrapping in Format >> Cells, Layout tab

d)

Press F7

e)

All of the above

83.

In a formula, which symbol specifies the fixed columns or rows?

a)

@

b)

$

c)

%

d)

*

e)

!

84.

What name is given to a function appearing inside another function?

a)

Round function

b)

Sandwich function

c)

Switch function

d)

Nested function

e)

If function

85.

Which one is not a function of Excel?

a)

SUM

b)

AVG

c)

MIN

d)

MAX

e)

If

86.

The default working layout in MS Word is NOT

a)

Print Layout

b)

Full Screen Reading

c)

Web Layout

d)

Outline

e)

Draft

87.

The Header & the Footer can

a)

Different Odd & Even pages

b)

Different First page

c)

On Every page

d)

On First & Last pages

e)

On Alternate page

88.

How to save a Word document?

a)

Ctrl + Save

b)

File, Save

c)

Ctrl + S

d)

Save icon on Quick access tool bar

e)

All of the above

89.

In MS Word, you can choose 'Save As' option for

a)

Save an existing document with a new name

b)

Save an existing document at a new location

c)

Save an existing document with a new name at a new location

d)

Save & print an existing document

e)

Save & close existing document

90.

An image can be modified by

a)

Applying picture styles

b)

Applying artistic effects

c)

Saving the image

d)

Applying picture effects

e)

Changing the color

91.

What are the methods to select text on a Word document?

a)

Click & Drag mouse cursor over the text

b)

by using Select command of the Home tab

c)

by pressing CTRL key with A key

d)

by right-clicking on the Text

e)

by pressing the enter key on the text

Similar Resources on Wayground

CyberSecurity Final Quiz 1st Sem

88 questions

CyberSecurity Final Quiz 1st Sem

quiz

Worksheet

•

University

Вопросы по компьютерному зрению и машинному обучению

95 questions

Вопросы по компьютерному зрению и машинному обучению

quiz

Worksheet

•

University

Câu Hỏi Kiểm Thử Phần Mềm

91 questions

Câu Hỏi Kiểm Thử Phần Mềm

quiz

Worksheet

•

University

Examen Final de Ciberseguridad

86 questions

Examen Final de Ciberseguridad

quiz

Worksheet

•

University

Checkpoint8-10

94 questions

Checkpoint8-10

quiz

Worksheet

•

University

Group 1: AI Fundamentals (Part 1)

95 questions

Group 1: AI Fundamentals (Part 1)

quiz

Worksheet

•

University

SAAD 7

94 questions

SAAD 7

quiz

Worksheet

•

University

Big Data 3 - HDFS

88 questions

Big Data 3 - HDFS

quiz

Worksheet

•

University