Computer 4 4th Quarter Exam

Multiple Choice

How many students' favorite color is blue?

• 11

• 12

• 14

• 17

Multiple Choice

How many more students like soccer than hockey?

• 29

• 20

• 9

• 11

Multiple Choice

How many chickens does Nate have on his farm?

• 11

• 12

• 9

• 10

Multiple Choice

The bar graph shows the number of runs for each player during a baseball season. How many more runs did Doug have than Sarah?

• 6

• 4

• 5

• 8

Multiple Choice

• 2

• 3

• 4

• 5

Multiple Choice

What did I forget to put on this bar graph?

• The scale

• The titles

• The pictures

• The key

Fill in the Blank

Study the Excel column chart. Then answer the questions that follow.

Which grade level has the most number of female students?

Fill in the Blank

Study the Excel column chart. Then answer the questions that follow.

Which grade level has the least number of male students?

Fill in the Blank

Study the Excel column chart. Then answer the questions that follow.

How many female students are there in Grade 5?

Fill in the Blank

Study the Excel column chart. Then answer the questions that follow.

How many male students are there in Grade 1?

Fill in the Blank

Study the Excel column chart. Then answer the questions that follow.

Which grade levels have more boys than girls?

Fill in the Blank

Study the Excel column chart. Then answer the questions that follow.

Which grade level has the closest number of male and female students?

Multiple Choice

Which of the choices is NOT TRUE of the given term?

cell reference

• address of the cell

• column letter and row number of the cell

• constant data

• example: A6

Multiple Choice

You can use this when you want either the row or the column be relative or absolute.

• Cell Referencing

• Relative Referencing

• Absolute Referencing

• Mixed Referencing

Multiple Choice

if you refer to cells using their column and row labels it is called ___________.

• Cell Referencing

• Relative Referencing

• Absolute Referencing

• Mized Referencing

Multiple Choice

This is by using the dollar sign ($)

• Cell Referencing

• Relative Referencing

• Absolute Referencing

• Mized Referencing

Multiple Choice

It is giving cells a label or an address.

• Cell Referencing

• Relative Referencing

• Absolute Referencing

• Mized Referencing

Multiple Choice

THE PICTURE TOOLS

_______ lets you modify the brightness and contrast of the picture,

as well as recolor, compress, reset, and even replace the picture.

• Size group

• Arrange group

• Picture Styles

• Adjust group

Multiple Choice

THE PICTURE TOOLS

_______ group has preset styles you can readily use. There are

tools for modifying a picture’s shape and border and for applying special affects.

• Size group

• Arrange group

• Picture Styles

• Adjust group

Multiple Choice

THE PICTURE TOOLS

_______ lets you bring an image to the front of another image or

send it behind. You also have tools for aligning, grouping, and rotating pictures.

• Size group

• Arrange group

• Picture Styles

• Adjust group

Multiple Choice

THE PICTURE TOOLS

_______ features tools for cropping and resizing pictures.

• Size group

• Arrange group

• Picture Styles

• Adjust group

Multiple Choice

features shapes used in mathematical operations.

• Callouts

• Stars and Banners

• Flowchart

• Equation Shapes

Multiple Choice

lets you draw callouts, inside of which words can be typed.

• Callouts

• Stars and Banners

• Flowchart

• Equation Shapes

Multiple Choice

lets you draw stars, banners, scrolls, and bursts.

• Callouts

• Stars and Banners

• Flowchart

• Equation Shapes

Multiple Choice

lets you draw flowcharting shapes.

• Callouts

• Stars and Banners

• Flowchart

• Equation Shapes

Multiple Choice

lets you draw flowcharting shape gives you quick access to shapes you have

just used.

• Recently Used Shapes

• Lines

• Rectangles

• Block Arrows

• Basic Shapes

Multiple Choice

lets you draw straight or curved lines, single or double

arrows, elbow or curved connectors, freeform lines, and scribbles.

Connectors are used to connect elements in a flowchart.

• Recently Used Shapes

• Lines

• Rectangles

• Block Arrows

• Basic Shapes

Multiple Choice

lets you draw different types of arrows.

• Recently Used Shapes

• Lines

• Rectangles

• Block Arrows

• Basic Shapes

Multiple Choice

lets you draw often-used shapes, icons, braces, and brackets

• Recently Used Shapes

• Lines

• Rectangles

• Block Arrows

• Basic Shapes

Multiple Choice

A ________ is a table used to organize data in

rows and columns.

• database

• record

• Spreadsheet

• field

Multiple Choice

A ________ is a collection of spreadsheets.

• database

• record

• Spreadsheet

• field

Multiple Choice

Each row of the table will contain

the name of a person. The information in this row will be called a ______.

• database

• record

• Spreadsheet

• field

Multiple Choice

The STUDENTS

table may include fields for First Name, Last Name, Student Number, Grade

Level, and Section. Fields are also called ______.

• database

• relational database

• table

• attributes

Multiple Choice

A _________ has two or more tables that are related to each

other in some way.

• database

• relational database

• table

• attributes

Multiple Choice

_______ determines how information is sorted and retrieved in a database.

• table

• query

• primary key

• key field

Multiple Choice

The ______ is the field that makes each record in a table unique.

• table

• query

• primary key

• key field

Multiple Choice

short text

Is it a data type that MS Access uses?

• Yes

• No

Multiple Choice

integer

Is it a data type that MS Access uses?

• Yes

• No

Multiple Choice

currency

Is it a data type that MS Access uses?

• Yes

• No

Multiple Choice

memo

Is it a data type that MS Access uses?

• Yes

• No

Multiple Choice

yes/no

Is it a data type that MS Access uses?

• Yes

• No

Multiple Choice

hyperlink

Is it a data type that MS Access uses?

• Yes

• No

Multiple Choice

lookup wizard

Is it a data type that MS Access uses?

• Yes

• No

Multiple Choice

void

Is it a data type that MS Access uses?

• Yes

• No

Multiple Choice

Databases treat numbers the same way they treat text entries.

• True

• False

Multiple Choice

There is no maximum field size for a Long Text data type.

• True

• False

Multiple Choice

The maximum field size for a text field is 30 characters.

• True

• False

Multiple Choice

Special effects used to introduce slides in a presentation are called

• Effects

• Custom Animations

• Transitions

• Preset Animation

Multiple Choice

How can you stop a slide show?

• press the right arrow

• press escape

• press left arrow

• press delete

Multiple Select

What type of software is MS-PowerPoint considered to be?

• Word Processing

• Word Processing

• Database

• Presentation

Multiple Select

Command to copy the same PowerPoint slide

• New Slide

• Delete Slide

• Layout Slide

• Duplicate Slide

Multiple Choice

What does the button that is being pointed to let you do?

• Change the size

• Change the font

• Add a new slide

• Insert a picture

Multiple Choice

3. What tab do you click to change the background of your slide?

• Design

• Home

• Insert

• Transition

Multiple Choice

Noel is tasked to make a presentation that will propose their new products to the board member. Which application should he use?

Multiple Choice

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

• Make your slides more colorful and add your pictures.

• Fill your slides with pictures and graphics.

• Add enough graphics and fewer texts.

• Add more texts and drawings.