MS (Excel, Access & PPT)

To create a formula in a cell, you must always begin with the following symbol:

=

Your ability to present online using Microsoft servers, so people can view your slides via a Web browser, is called __________.

A Broadcast Presentation

The cell that is highlighted with a black outlined box is called the __________.

Active cell

Identify the location of the Auto Sum function in the figure below.

B

To view all formulas on a Spreadsheet , you press __________.

Ctrl+`

A(n) ____________________ is a collection of related data, tables, and/or files.

Database

Records of data are entered into the _______________ View.

Datasheet

Changing a first level bullet into a second level bullet is called a __________.

Demote

The _______________ View is where most new database table structures are created.

Design

When establishing relationships between tables in the Database Tools menu, the tables are referred to as _______________ as part of the original ERD, _______________-relationship diagram.

Entity

A Workbook is an Excel file containing no more than one Spreadsheet.

False

Adjacent Cells are groups of cells in separate locations.

False

Another name for an attribute or column, like EMPNO, is

Field

The small square in the lower right corner of a selected cell is called the:

Fill handle

The field in common between two tables is called the:

Foreign key

When you need to create an interface to view, add, update, and delete data in Access, you should use a:

Form

The area circled in the figure below is the __________.

Formula bar

To make changes in several Spreadsheets at once, you can __________.

Group the spreadsheets

In a database, the special field that contains a unique value for each record is the:

Primary key

Changing a second level bullet to a first level bullet is called a __________.

Promote

Which of the following finds data in your database by allowing you to ask a question?

Query

If you want create a formatted, professional way to present and print the contents of your database, you use a:

Report

The __________ view is a viewing option that displays all slides in a presentation as thumbnails.

Slide sorter

An Excel Workbook designed and formatted by Microsoft is called a ____________.

Template

You can change the Presentation Handouts to show 3 slides per page in __________.

The Backstage view

A Cell Range is a group of cells which can be either adjacent or nonadjacent.

True

Saving a presentation as a PowerPoint Show (.ppsx) should enable anyone to view the presentation--even without having PowerPoint on their computer.

True

Slide transitions are effects that occur when moving from one slide to the next during a presentation.

True

The Name box is located on the left side of the Formula Bar. It displays the cell reference of the active cell.

True

The PowerPoint print option that prints a presentation with multiple slides is called a handout.

True

There is a FORMULA tab on the Ribbon.

True

In Excel, the Edit mode is __________.

the mode in which you can edit cell contents by pressing F2 or by double clicking inside a cell