Search Header Logo
CLASS 9 PT2 REVISION-EXCEL,PPT,WORD,KEYBOARDING,IT

CLASS 9 PT2 REVISION-EXCEL,PPT,WORD,KEYBOARDING,IT

Assessment

Presentation

Computers

9th Grade

Medium

CCSS
RI.8.7, RL.2.6, RI.9-10.7

+6

Standards-aligned

Created by

Charu Chopra

Used 4+ times

FREE Resource

1 Slide • 24 Questions

1

CLASS 9 PT2 REVISION-EXCEL,PPT,WORD,KEYBOARDING,IT

Slide image

2

Multiple Choice

Question image

With reference to the image find the output of =count(b3:b9)

1

2

2

3

3

4

4

0

3

Multiple Choice

Question image

Choose the correct function that will add the sales of all the months from the given window

1

=sum(c4,c8)

2

=sum(c4;c9)

3

=sum(c4+c9

4

=sum(c4:c9)

4

Multiple Choice

Effects applied to placeholders or other content to move the content in unique ways on the slide is which of the following?

1

layouts

2

animations

3

format

4

transitions

5

Multiple Choice

Special effects used to introduce slides in a presentation are called

1

effects

2

custom animations

3

transitions

4

present animations

6

Multiple Choice

What symbol is used to designate an absolute cell reference?

1

&

2

@

3

#

4

$

7

Fill in the Blanks

Type answer...

8

Multiple Choice

The slide show can be exited at any time during the show by pressing which of the following keys

1

Space bar

2

Break key

3

End Esc

4

Esc key

9

Multiple Choice

If I want to add a certain part like <<First Name>> or <<Last Name>> where would I need to click?

1

Insert Merge Field

2

Click Greeting Line and add First Name to the block

3

Click Finish and Merge

4

Click the Start mail merge and click add and then click your desired choice

10

Multiple Choice

Which command on the Picture Tools Format Ribbon is used to change the way text moves around a selected object?
1
Wrap Text
2
Insert
3
Align Text
4
Insert

11

Multiple Choice

The message is __% body language

1

7

2

38

3

55

4

6

12

Multiple Choice

The way you sit or stand is called

1

technique

2

posture

3

stand up

4

erect

13

Multiple Choice

The home row keys for the right hand are

1

jkl;

2

jlk;

3

jk;l

4

jkk;

14

Multiple Choice

The home row keys for the left hand are

1

afds

2

asgd

3

asdf

4

asef

15

Multiple Choice

The enter key is controlled by the

1

left thumb

2

left little finger

3

right thumb

4

right little finger

16

Multiple Choice

When operating a keyboard, wrist should be

1

touching the frame of the keyboard

2

arched

3

low but not touching the frame of the keyboard

4

curved over the keyboard

17

Multiple Choice

To use cut and paste operation, word makes use of a temporary memory which is called ...

1

Memory

2

Clipboard

3

RAM

4

Hard Disk

18

Multiple Choice

Which of the following is a toggle key ?

1

Num Lock

2

Caps Lock

3

Scroll lock

4

All of the above

19

Multiple Choice

The response to a sender’s message is called _________

1

Feedback

2

Reply

3

Reason

4

Back

20

Multiple Choice

Question image

The use of sounds and words to express yourself

1

Non-Verbal Communication

2

Customer Service

3

Interpretive Dance

4

Verbal Communication

21

Multiple Choice

Question image

We communicate by:

1

Speech (Telephone call, conversations, etc)

2

Visuals (Body language, facial expressions)

3

Writing (Letter, emails, newsletters, etc)

4

All of the above

22

Multiple Choice

Question image

Which of the following is a barrier to communication?

1

Message is not clear

2

Not listening

3

Lack of language skills

4

All of the above

23

Multiple Choice

In the IF function example:

=IF(A23>=100,"Prize","No Prize")

What would show in the cell after you hit enter if the value in A23 is 89?

1

Prize

2

No Prize

3

Nothing would show in the cell

24

Multiple Choice

What is an advantage, if any, to using cell references instead of just typing in values?
1
It will automatically create a sparkline in the next cell
2
It will allow you to format your spreadsheet quicker
3
If the cell is changed, your formula will automatically update
4
There is no advantage

25

Multiple Choice

if statement structure is:

1

if(value-if-true,logical-test,value-if-false)

2

if(logical-test,value-if-false-value-if-true)

3

if(logical-test,value-if-true,value-if-false)

CLASS 9 PT2 REVISION-EXCEL,PPT,WORD,KEYBOARDING,IT

Slide image

Show answer

Auto Play

Slide 1 / 25

SLIDE