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
