wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

BOS End of Level State Exam Prep

Total questions: 83

Worksheet time: 4hrs 4mins

Name
Class
Date
1.

What option is used to reposition the content placeholders on a slide?

a)

Styles

b)

Slide Layouts

c)

View Options

d)

Rearrange Slides

2.

What feature in a document processing program (Microsoft Word) has rows, borders, and columns?

a)

Pictures

b)

Graphs

c)

Tables

d)

SmartArt

3.

In a spreadsheet (Excel) this feature will change one long string of text into multiple lines in ONE cell

a)

Multiple

b)

Wrap text

c)

Repeat

d)

Double space

4.

To quickly copy formatting (text colors, alignment, font, etc.,) and apply it to other text you use what feature?

a)
format painter
b)

cut and paste

c)

page break

d)

remove duplicates

5.

In a presentation, where can you customize the style and layout of the entire presentation?

a)
Slide Layout
b)
Normal View
c)
Slide Sorter
d)
Slide Master
6.
What are each individual "pages" of a Power Point called?
a)
Sheet
b)
Page
c)
Slide
d)
Paper
7.

What formula would I use to find the minimum value in a specific range?

a)

=IF(b4:h8)

b)

=SUM(a1:a5, "Green")

c)

=MIN(A6:P9)

d)

=MAX(A9:b4)

8.

What would the formula =IF(A2>50, "Fail", "Pass") do?

a)

COUNT the numbers in the range

b)

Check to see if the number in cell A2 is greater than 50. If it is then it will add the word "Fail" in the cell. If it is not greater than 50, it will return the word "Pass".

c)

Finds the largest number in the range

d)

Adds the numbers in the range and then makes sure they are larger than "50".

9.

This Excel function returns one or two values based on a logical test

a)

IF

b)

Filter

c)

SUM

d)

Conditional formatting

10.

This function finds a specific VALUE in a table based on a cell's value

a)

MIN

b)

LOOKUP

c)

FIND

d)

DATABASE

11.

This feature will print text and/or graphics in the top and/or bottom margins of EACH page of a document

a)

Filter

b)

Sorting

c)

Template

d)

Header and Footer

12.

This feature provides structure, design, and layout for common documents (resumes, memos, business documents, and fax cover sheets)

a)

Template

b)

Format

c)

Hyperlink

d)

Sort

13.

The is the default first slide when you open a new presentation file.

a)
Title Slide
b)
Last Slide
c)
Hyperlink
d)
Template
14.
Controls the formatting for all the slides in a presentation
a)
Slide Layout
b)
Normal View
c)
Slide Sorter
d)
Slide Master
15.

This feature allows you to arrange information in alphabetical, numerical, and chronological order.

a)

Display

b)

Sorting

c)

Filter

d)

Organize

16.

If you want to "hide" data that does not meet a certain criteria (for example, hiding a home from a list that does not have a fireplace- our 5.1 Excel assignment) you use this feature:

a)

Filter

b)

Sort

c)

Organize

d)

Order

17.

A hyperlink is a feature that moves you to a web page, opens another file, or moves to another document/slide/spreadsheet.

a)

True

b)

False

18.

To save a document with a NEW file name you would choose

a)

Save As

b)

Export

c)

Download

d)

Undo

19.

To save changes to an EXISTING document you would choose

a)

Save As

b)

Export

c)

PDF

d)

Save

20.

What Level is "Ham" in the bullet list?

a)

Level 1

b)

Level 2

c)

Level 3

d)

Level 4

21.

The line spacing within each paragraph is single-spaced and double-spaced between the two paragraphs.

a)

True

b)

False

22.

What alignment was applied to the paragraph?

a)

Left

b)

Right

c)

Center

d)

Justified

23.

What alignment was applied to the paragraph?

a)

Left

b)

Right

c)

Center

d)

Justify

24.

What alignment was applied to the paragraph?

a)

Left

b)

Right

c)

Center

d)

Justify

25.

What alignment was applied to this paragraph?

a)

Left

b)

Right

c)

Center

d)

Justify

26.

This kind of break forces the text to start at the top of the next column

a)

Page break

b)

Section break

c)

Column break

d)

Box break

27.

This kind of break forces the text to start at the top of the next page.

a)

Column break

b)

Page break

c)

Section break

d)

Box break

28.

This feature will apply a dimmed or washed out look to a picture or text that shows up behind the body of a document.

a)

Watermark

b)

Faded

c)

Background

d)

Graphic

29.

What is this feature called when you center the text vertically between the TOP and BOTTOM margins?

a)

Top and bottom alignment

b)

Vertical alignment

c)

Horizontal alignment

d)

Centered

30.

When adding an image to a report, what option is used to align the image to the text?

a)

Alignment

b)

Formatting

c)

Wrap text

d)

Centered

31.

How do you make text appear on a slide letter by letter or images to appear in certain ways?

a)

Animation

b)

Shift

c)

Transfer

d)

Fade

32.

Grouping adjacent cells into one bigger cell is called

a)

filtering

b)

sorting

c)

merging cells

d)

selecting

33.

What part of the chart is this?

a)

legend

b)

column headings

c)

axis

d)

chart title

34.

Which column controlled the sort

a)

amount

b)

expense

c)

name

35.

This feature in Excel will insert a function.

a)

True

b)

False

36.

What feature allows you to convert text to a graphic?

a)

Sort

b)

Word Art

c)

Image

d)

Convert

37.

Which of the following indicates an absolute cell reference?

a)

$B4

b)

*B$4

c)

^B^4

d)

$B$4

38.

What is the main purpose of using section breaks in Word?

a)

To divide the document into sections so you can change different parts of the document

b)

To add column breaks

c)

To add page numbers

d)

To make it look cool

39.

What does a thesaurus do?

a)

Spell check

b)

Grammar check

c)

Finds similar words/synonym

d)

Finds opposits

40.

If the presenter want's to preview the slide presentation before it is is seen by the audience, you will choose what view?

a)

Normal view

b)

Notes view

c)

Handout view

d)

Presentation view

41.

In Excel, what feature applies formatting to trends and patterns based on specific conditions or rules you set? For example, Cells with numbers greater than "30" fill dark red with light red text.

a)

IF function

b)

Sorting

c)

Conditional formatting

d)

Formatting

42.

When scrolling through a large worksheet, what feature will keep certain columns or rows visible?

a)

Stop

b)

Freeze

c)

Don't move

d)

Hold

43.

What feature in PowerPoint do you use that will allow you to insert slides from another PowerPoint presentation into your current presentation?

a)

Reuse

b)

Do over

c)

Insert

d)

Object

44.

In a spreadsheet, what is it called when a collection of cells is selected (more than one cell)?

a)

Group

b)

Text

c)

Table

d)

Range

45.

This button is to do what?

a)

Italicize

b)

Sort

c)

Center text

d)

Wrap text

46.

This feature in Word is for what?

a)

Numbered list

b)

Sorting

c)

Vertical aligning

d)

Inserting a table

47.

This feature in Word does what?

a)

Insert table

b)

Line spacing

c)

Text wrapping

d)

Center align

48.

This feature in Word does what?

a)

Sorting

b)

Organizing

c)

Aliging

d)

Line spacing

49.

What type of paragraph alignment does this button perform?

a)

Center

b)

Left

c)

Right

d)

Justify

50.

What does this feature do?

a)

Text wrapping

b)

Line spacing

c)

Inserting an image

d)

Number list

51.

What is this feature?

a)

Merge & Center

b)

Format Painter

c)

Currency

d)

Increase Decimal

52.

What is this feature?

a)

Paste

b)

Format painter

c)

Increase indent

d)

Currency

53.

What is this feature?

a)

Format painter

b)

Paste

c)

Merge & Center

d)

Currency

54.

What is this feature?

a)

Format painter

b)

Align

c)

Merge & Center

d)

Sort

55.

What is this feature

a)

Merge & Center

b)

Center

c)

Right align

d)

Increase decimal

56.

An image can be added to add visual interest and to help convey a message.

a)

TRUE

b)

FALSE

57.

A preset formatting of a slideshow in text size, colors, placement, and graphic feature is the

a)

Theme

b)

Design

c)

Font

d)

Outline

58.

This type of chart displays one piece of data compared to the whole

a)

Column

b)

Line

c)

Scatter

d)

Pie

59.

This type of chart compares values across a few categories

a)

Pie

b)

Column

c)

Line

d)

Scatter

60.

This paragraph is an example of a:

a)

Hanging indent

b)

First line indent

c)

Left indent

d)

Right indent

61.

This paragraph is an example of a:

a)

Hanging indent

b)

First line indent

c)

Left indent

d)

Right Indent

62.

"A" is what part of the chart?

a)

Chart title

b)

Vertical axis

c)

Chart legend

d)

Horizontal axis

63.

"E" represents what part of the chart

a)

Vertical axis title

b)

Horizontal axis title

c)

Chart legend

d)

Chart title

64.

What part of the chart does "C" represent

a)

Horizontal title

b)

Vertical Title

c)

Horizontal Category Axis

d)

Chart title

65.

What part of the chart does "B" represent

a)

Data labels

b)

Column headings

c)

Axis labels

d)

Chart title

66.

What part of the spreadsheet displays the contents of the current cell and is used for creating and viewing the functions?

a)

Worksheet

b)

Function

c)

Absolute cell reference

d)

Formula bar

67.

Which software application is used to write a research paper?

a)

Document processing, like MS Word

b)

Spreadsheet, like MS Excel

c)

Electronic presentation, like MS PowerPoint

68.

Which application software is used to create and manage a budget?

a)

Document processing, like MS Word

b)

Spreadsheet, like MS Excel

c)

Electronic presentation, like MS PowerPoint

69.

Which application software is used to deliver a speech or present to an audience?

a)

Electronic presentation, like MS PowerPoint

b)

Document processing, like MS Word

c)

Spreadsheet, like MS Excel

70.

In a spreadsheet, what is a "workbook"?

a)

A group of worksheets

b)

An absolute cell reference

c)

A spreadshet

d)

A single worksheet

71.

What do columns represent in a table?

a)

A row of answers

b)

Vertical alignment of data

c)

Fields to enter text into

d)

The intersection where columns and rows meet

72.

What tool on the image allows you to select the entire table?

a)

A

b)

B

c)

C

d)

D

73.

Computer-recorded data that is saved in a reusable place on the computer is called:

a)

File

b)

Hide

c)

Send

d)

Merge

74.

A bibliography is a list of sources used in a document?

a)

True

b)

False

75.

Portrait and landscape are options in:

a)

Paper size

b)

Page Header

c)

Page orientation

d)

Page numbering

76.

A transition is the effect that moves one slide to another in an electronic presentation.

a)

True

b)

False

77.

What is a section in a slideshow (electronic presentation/MS PowerPoint)?

a)

The first slide in a presentation

b)

A way to organize slides into groups

c)

A placeholder for a graphic

d)

The last part of a slide presentation

78.

What is the purpose of speaker notes in a slideshow?

a)

To provide additional information for the presenter

b)

To show images

c)

To add sound to the presentation

d)

To reorder the slides

79.

Which feature in the image displays the references used in the passage?

a)

A

b)

B

c)

C

d)

D

e)

E

80.

Which feature in the image displays the in-text citation?

a)

A

b)

B

c)

C

d)

D

e)

E

81.

Which feature in the image displays the page number?

a)

A

b)

B

c)

C

d)

D

e)

E

82.

Which feature in the image displays a hanging indent?

a)

A

b)

B

c)

C

d)

D

e)

E

83.

Which feature in the image displays the footer?

a)

A

b)

B

c)

C

d)

D

e)

E

Similar Resources on Wayground

Quiz Berpikir Komputasional 9

80 questions

Quiz Berpikir Komputasional 9

quiz

Worksheet

•

9th Grade - University

Year 9 Easter Term Quiz

81 questions

Year 9 Easter Term Quiz

quiz

Worksheet

•

9th Grade

3°S_1°trim. 2025 - 2026

82 questions

3°S_1°trim. 2025 - 2026

quiz

Worksheet

•

9th - 12th Grade

Grade 5 Revision

81 questions

Grade 5 Revision

quiz

Worksheet

•

3rd - 10th Grade

Math Revision Quiz

86 questions

Math Revision Quiz

quiz

Worksheet

•

8th Grade - University

YEAR 9

81 questions

YEAR 9

quiz

Worksheet

•

9th Grade

NGÂN HÀNG CÂU HỎI GIƯA KÌ 2 TIN 10

83 questions

NGÂN HÀNG CÂU HỎI GIƯA KÌ 2 TIN 10

quiz

Worksheet

•

9th - 12th Grade

Tin học 9: Kiểm tra thường xuyên

85 questions

Tin học 9: Kiểm tra thường xuyên

quiz

Worksheet

•

9th Grade