Defined Names
Excel Applications
Data Validation
Macros
Data Protection
100
Another name for range name
What is defined name
100
A spreadsheet written or tailored to meet specific needs.
What is Excel application
100
A text box that is attached to a specific cell in a worksheet in which you can enter notes.
What is comment
100
A series of stored commands that can be run whenever you need to perform that task.
What is a macro
100
Also called a digital certificate
What is digital signature
200
An owl
What is the MUW mascot
200
Charts, reports, Use formulas to manipulate data and perform calculations, store data, and enter/edit data
What are items that can be contained in an Excel Application
200
A set of of rules that determine what users can enter in a specific cell or range.
What is data validation
200
A type of virus that uses a program's own macro programming language to distribute the virus.
What is a macro virus
200
Reneau Hall
What is location of College of Business and Professional Studies, Student Success Center, and Institutional Research
300
A word or string of characters assigned to a cell or range.
What is defined name
300
A text box in which you can enter stylized text.
What is WordArt
300
A message that appears when the cell becomes active and can be used to specify the type of data the user should enter in that cell.
What is an input message
300
A hidden workbook names PERSONAL.xlsb that opens whenever you start Excel, making the macros you stored available any time you use Excel.
What is a personal macro workbook
300
An electronic version of a signature that provides a way to authenticate a workbook.
What is digital signature
400
Name box, Define Name dialog box, Name Manager dialog box
What are ways to create a defined name
400
Information describing the workbook's purpose, author, date, etc is located here.
What is a Documentation worksheet
400
A statement that defines criteria for the data that can be entered and stored in a cell or range
What is a validation rule
400
The settings that controls with Excel will do about macros in a workbook when you open that workbook.
What is macro security settings
400
A setting that limits users' ability to modify the worksheet's contents, structure, or formatting.
What is worksheet protection
500
May 4, 2015 by the end of the day
What is semester project is due
500
April 5 by the end of the day
What is tutorial 7/week 11 assignments deadline
500
A setting that determines whether changes can be made to a cell.
What is the locked property
500
May 5, 2015 11:30-2:30
What is date and time of our final exam
500
Begins March 16 through April 6
What is Advising sessions for students
Continue
ESC
Reveal Correct Response
Spacebar
M
e
n
u
Team 1
0
+
-
Tutorial 7 - Developing an Excel Application
No teams
1 team
2 teams
3 teams
4 teams
5 teams
6 teams
7 teams
8 teams
9 teams
10 teams
Custom
Press
F11
Select menu option
View > Enter Fullscreen
for full-screen mode
Edit
•
Print
•
Download
•
Embed
•
Share
JeopardyLabs