wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

REVIEW

Total questions: 100

Worksheet time: 53mins

Name
Class
Date
1.

How to insert video from my computer?

a)

Insert - video- this device

b)

Insert- picture- online picture

c)

Design- theme - format background

d)

File- save as

2.

Which is the correct sign for Power point?

a)
b)
c)
d)
3.

A presentation program that allows you to create dynamic slide presentations.

a)

MS EXCEL

b)

MS WORD

c)

MS POWER POINT

4.

Can we change the background color of a slide?

a)

Yes

b)

No

5.

. 

What is the name of the area at the top of the PowerPoint screen that is shown in the image?

a)

Tab

b)

Ribbon

c)

Slide Navigation

d)

Zoom in and zoom out

6.

2. What is Microsoft Power Point used to create?

a)

Slide Show

b)

Video

c)

Table

d)

Spreadsheet

7.

Which icon to add a new slide in PowerPoint?

a)
b)
c)
d)
8.

To delete a slide, simply hit the __________ button on the keyboard.

a)

backspace

b)

enter

c)

shift

d)

delete

9.

Refer this picture, how to apply theme in PowerPoint?

a)

Design - Picture

b)

Insert - Audio

c)

Animation - Appear

d)

Design - theme

10.

To the picture, What is this?

a)

Alignment

b)

Picture

c)

Font Style

d)

Vide0

11.

What should you do to make your presentation more appealing to the audience?

a)

Make your slides more colorful and add your pictures.

b)

Fill your slides with pictures and graphics.

c)

Add enough graphics and fewer texts.

d)

Add more texts and drawings.

12.

How can you add pictures on a slide?

a)

Home -> picture

b)

Insert -> Images

c)

Design -> Images

d)

Slide show -> pictures

13.

How do you save your Presentation?

a)

Go to File and click on Save As/ Save and Press Save

b)

Home and click on Save As/ Save and Press Save

c)

Click on Slide Show and then lick on Save As/ Save and Press Save

d)

Help and click on Save As/ Save and Press Save

14.

The file extension for Power point presentation is

a)

.pptx

b)

.jpeg

c)

.docx

d)

.pdf

15.

To change the font we have to use

a)

Home Menu

b)

Insert Menu

c)

Design Menu

16.

Special effects used to introduce slides in a presentation are called

a)

effects

b)

custom animations

c)

transitions

d)

present animations

17.
What are units that make up a presentation?
a)
Notes
b)
Outlines
c)
Slides
d)
View
18.

Which one is the display of MS PowerPoint?

a)
b)
c)
d)
19.
Feature that lets you create a show from scratch, using whatever layout, format, colors, and styles you prefer.
a)
Blank Presentation
b)
Background
c)
SmartArt
d)
Slide Master
20.
Empty boxes that appear on a new slide that reserve a space for the type of information you want to insert
a)
Slide Master
b)
Slide Sorter
c)
Placeholders
d)
Slide
21.
A predefined slide format that determines the position of the objects on the slide
a)
Slide Show
b)
Slide Sorter
c)
Slide Master
d)
Slide Layout
22.

What are these?

a)

Font size

b)

Font style

c)

Font color

23.

It makes your text thicker.

a)

A

b)

B

c)

C

24.

Can we add many shapes in one slide?

a)

Yes

b)

No

25.

view which lets a user change placeholders and layouts applied to the slides in a presentation

a)

Slide Master View

b)

Ribbon

c)

Slide Layout

d)

Slide Transitions

26.

combination of colors, fonts, effects and backgrounds which are applied to the slides of a presentation

a)

Template

b)

Table

c)

Themes

d)

SmartArt

27.

What do we call the entire toolbar at the top of the PowerPoint window?

a)

The bow

b)

The lace

c)

The ribbon

d)

The sash

28.

What do we use the "file" tab in PowerPoint for?

a)

Adding a text box

b)

Choosing a design theme

c)

Deleting a slide

d)

Saving a new presentation to the computer

29.

Select ALL the elements you can insert into a PowerPoint.

a)

Chart

b)

Image

c)

Music

d)

Shape

30.

What can be used to decorate a background? Select ALL.

a)

GIF fill

b)

Gradient color fill

c)

Pattern fill

d)

Picture fill

31.

What is this bar used for in PowerPoint?

a)

To resize shapes on a slide

b)

To resize fonts on a slide

c)

To resize pictures on a slide

d)

To resize the size of a slide

32.

Select ALL the elements that can be animated in a PowerPoint.

a)

Audio/Music

b)

Fonts/Words

c)

Images/Pictures

d)

Shapes

33.

Which tab is used to present a PowerPoint?

a)

Design

b)

Home

c)

Transitions

d)

Slide Show

34.

Document properties are found in

a)

Backstage view.

b)

File, Save As.

c)

View, File Properties.

d)

Home, Find.

35.

请问这是什么软体？

a)

MICROSOFT WORD

b)

MICROSOFT TEAMS

c)

MICROSOFT POWERPOINT

d)

MICROSOFT EXCEL

36.

This is called a

a)

page

b)

sheet

c)

slide

37.

how many tabs are on the top ribbon in powerpoint

a)

12

b)

4

c)

11

d)

8

38.

what is the max number of slides in powerpoint

a)

50

b)

100

c)

1000

d)

a number so insane you wont need it

39.

Division symbol in spreadsheet.

a)

/

b)

+

c)

=

40.

If you click on a letter at the top of an Excel spreadsheet, what have you done?

a)

selected a cell

b)

selected a range of cells

c)

selected a row of data

d)

selected a column of data

41.

A four-sided arrow does what in Excel?

a)

copies the contents of one cell to others around it

b)

moves the contents of one cell to another location

c)

selects the cell

42.

Every formula starts with what?

a)

=

b)

+

c)

-

d)

( )

43.

What is the name of the bar above the worksheet that always shows the content of a cell as is denoted by the symbol fx?

a)

cell bar

b)

formula bar

c)

status bar

d)

name box

44.

If you click a number at the left of an Excel spreadsheet, what have you done?

a)

selected a cell

b)

selected a range of cells

c)

selected a row of data

d)

selected a column of data

45.

If you see the following, what does it mean? ######

a)

the formula has an error

b)

the contents are too large to display

c)

text was entered where numbers should be

46.

If you center or merge and center it does exactly the same thing.

a)

True

b)

False

47.

Which page orientation makes the sides longer than the top and bottom?

a)

landscape

b)

portrait

c)

fixed

d)

variable

48.

If you selected (A1:B5) what is this called?

a)

row

b)

column

c)

cell range

d)

cell grouping

49.

To arrange data in alphabetical or numerical order is what?

a)

coding

b)

sorting

c)

graphing

d)

grouping

50.

Microsoft Excel is what kind of software?

a)

Word Processing Software

b)

Spreadsheet Software

c)

Database Software

d)

Presentation Software

51.

The letters in Excel represent the...

a)

Rows

b)

Columns

c)

Cells

d)

Data

52.

The numbers in Excel represent the...

a)

Rows

b)

Columns

c)

Cells

d)

Data

53.
How do you change column width to fit the contents?
a)
Single-click the boundary to the left of the column heading
b)
Double-click the boundary to the right of the column heading
c)
Press ALT and single-click anywhere in the column
54.
What is the name given to the intersection of a row and a column in a spreadsheet? 
a)
cell
b)
block
c)
cube
d)
square
55.
What are lines that can be applied around worksheet cells or objects?
a)
Gridlines
b)
Borders
c)
Underlines
d)
Boundaries
56.

Where is the zoom function located in Excel?

a)

Bottom right of spreadsheet document

b)

Bottom left of spreadsheet document

c)

Top right of spreadsheet document

d)

Top left of spreadsheet document

57.

Excel refers to files as

a)

Databases

b)

Workbook

c)

Document

58.

When inserting a formula, always start with

a)

-

b)

*

c)

+

d)

=

59.

Choose the best description of the IF function

a)

Checks whether a condition is met, and returns one value if TRUE, and another value if FALSE

b)

Returns TRUE if any of the conditions are true and returns FALSE if all conditions are false

c)

Returns TRUE if all conditions are true and returns FALSE if any of the conditions are false

d)

Returns a value from a list using a given position

60.

Choose the correct format of the IF function:

a)

=IF(logical test,value if true,value if false)

b)

=IF(logical test,value if false,value if true)

c)

=IF(value if true,value if false,logical test)

d)

=IF(value if false,value if true,logical test)

61.

Which is the correct way to write this function:

IF B4 is greater than 200, show "High", otherwise, show "Low"

a)

IF(B4>200;"High";"Low")

b)

=IF(B4<200,"High","Low")

c)

=IF(B4>200,"High","Low")

d)

=IF(B4>200"High","")

62.

Which of these comparison operations means "Less than or equal to"?

a)

<

b)

<>

c)

<=

d)

$

63.

In this IF function example:  =IF(G8>40,"Yes","No")

What would show in the cell after you hit enter if the value in G8 was 62?

a)

Yes

b)

No

c)

Nothing would show

64.

The arrangement of data in Z to A will arrange the data in __________ order.

a)

Ascending

b)

Descending

65.

The Sort & Filter option is present under which tab of Microsoft Excel?

a)

Insert Tab

b)

Data tab

c)

Home tab

d)

Format tab

66.

The _____________ feature allows you to see only those records that you want display while it hides the rest of the data temporarily from the view .

a)

Filter

b)

sort

c)

Custom Sorting

d)

Removing Filter

67.

State true or false.

You can sort data in only one field.

a)

True

b)

False

c)

Don`t know

d)

Not able to answer

68.

To colour those cells blue where temperature is above 50 degree you will

a)

Apply filtering

b)

Use fill colour option

c)

Shade Cells

d)

Use Conditional Formatting

69.

The program that we use to create spreadsheets

a)

MS Word

b)

MS Paint

c)

MS Excel

70.

Microsoft Excel is what kind of software?

a)

Word Processing Software

b)

Spreadsheet Software

c)

Database Software

d)

Presentation Software

71.

An Excel file format extension is

a)

doc

b)

xls

c)

txt

d)

mp3

72.

The numbers in Excel represent the...

a)

Rows

b)

Columns

c)

Cells

d)

Data

73.

When creating a chart in Excel, what is the first thing you need to do?

a)

Select the data to be graphed.

b)

Select the Insert Tab

c)

Choose a chart from the ribbon

d)

Double click the active cell

74.

To alert Excel that you are entering a formula and not text, type a(n) ____________ preceding the formula.

a)

&

b)

=

c)

#

d)

*

75.

What function adds all of the numbers in a range of cells?

a)

Calculate

b)

Compute

c)

Sum

d)

Max

76.

To sort data in Excel, go to the __________ ribbon.

a)

Home

b)

Data

c)

Insert

d)

View

77.

What does the mouse look like in a spreadsheet?

a)

Arrow

b)

Pointer

c)

Two headed arrow

d)

Selection cross

78.

If I want to find an average of cells A1 through A25, which formula would I use?

a)

=average(A1:A25)

b)

=avg(A1:A25)

c)

=average(A1-A25)

d)

=avg(A1-A25)

79.
Alex needs to add three cells and then divide the sum by 4. Which of the following is an example of the correct formula to do this? 
a)
=(A1+A2+A3)/4
b)
A1+A2+A3/4
c)
=A1+A2+A3^4
d)
(A1+A2) + A3/4
80.

What is this icon?

a)

Sum

b)

AutoSum

c)

Insert Function

d)

Object

81.

What is this icon?

a)

Sum

b)

AutoSum

c)

Insert Function

d)

Object

82.

What is this icon?

a)

Zoom

b)

Sort and Filter

c)

Symbol

d)

Merge and Center

83.

Which of the following methods cannot be used to enter data in a cell

a)

a. Pressing an arrow key

b)

b. Pressing the Tab key

c)

c. Pressing the Esc key

d)

d. Clicking on the formula bar

84.

When a label is too long to fit within a worksheet cell, you typically must

a)

a. Shorten the label

b)

b. Increase the column width

c)

c. Decrease the column width

d)

d. Adjust the row height

85.

In MS-Excel numeric value can be treated as a label value if it precedes with

a)

A. Apostrophe (')

b)

B. Exclamation (!)

c)

C. Hash (#)

d)

D. None of these

86.

What is the shortcut key to hide entire column?

a)

A. CTRL + −

b)

B. CTRL + 0

c)

C. CTRL + H

d)

D. CTRL + C

87.

The advantage of using a spreadsheet is:

a)

A. calculations can be done automatically.

b)

B. changing data automatically updates calculations

c)

C. more flexibility

d)

D. All of the above

88.

Numbers down the left side of the spreadsheet.

a)

Status Bar

b)

Formula Bar

c)

Column Labels

d)

Row Labels

89.

What is the icon for Microsoft Excel?

a)
b)
c)
d)
90.

What tab is pictured here?

a)

File

b)

Home

c)

Data

d)

Formula

91.

What tab is pictured here?

a)

Home

b)

File

c)

Insert

d)

Data

92.

What tab is pictured here?

a)

Home

b)

Data

c)

Insert

d)

Formulas

93.

Which tab is pictured here?

a)

Data

b)

Formula

c)

Draw

d)

Insert

94.

Which Tab is pictured?

a)

Home

b)

Data

c)

Insert

d)

Formula

95.

Where would I click to insert a function if I'm working with money?

a)

3

b)

1

c)

5

d)

7

96.

How many groups are pictured here?

a)

8

b)

7

c)

9

d)

10

97.

What Tab would I find charts in?

a)

Home

b)

Data

c)

Insert

d)

File

98.

Where are group in Excel located?

a)

Top of the ribbon

b)

Righthand side of the page

c)

Left of the page

d)

Bottom of the ribbon

99.

Which group would I use if I wanted to delete a row?

a)

Font

b)

Cells

c)

Tables

d)

Numbers

100.

Spreadsheet software is used for storing data in the form of ______________.

a)

rows and cells

b)

cells and columns

c)

rows and columns

Similar Resources on Wayground

*ИКТ*

100 questions

*ИКТ*

quiz

Worksheet

•

University

DGTIN Tutorial 3

100 questions

DGTIN Tutorial 3

quiz

Worksheet

•

University

Tin học, công nghệ, máy tính và an ninh mạng

105 questions

Tin học, công nghệ, máy tính và an ninh mạng

quiz

Worksheet

•

KG - University

BooleanAlgebraBasics

99 questions

BooleanAlgebraBasics

quiz

Worksheet

•

University

22CA2015 - Mobile Hacking - Surprise Quiz II

98 questions

22CA2015 - Mobile Hacking - Surprise Quiz II

quiz

Worksheet

•

University

kisi kisi ujia

102 questions

kisi kisi ujia

quiz

Worksheet

•

9th Grade - University

LATIHAN SOAL KELAS XII TKJ 1 / XII TKJ2 SMK BINA MANDIRI

100 questions

LATIHAN SOAL KELAS XII TKJ 1 / XII TKJ2 SMK BINA MANDIRI

quiz

Worksheet

•

University

Animation and Game Design Unit 2 Diagnostic Test

100 questions

Animation and Game Design Unit 2 Diagnostic Test

quiz

Worksheet

•

12th Grade - University