Exploring Microsoft Office

Computing

Quiz 2 :

Excel: Relational Databases and Queries

Quiz 2 :

Excel: Relational Databases and Queries

Question Type
search
arrow
Formula AutoComplete
Free
Multiple Choice
Answer:

Answer:

D

Tags
Choose question tag
close menu
arrow
A function is a
Free
Multiple Choice
Answer:

Answer:

A

Tags
Choose question tag
close menu
arrow
The COUNTBLANK function
Free
Multiple Choice
Answer:

Answer:

A

Tags
Choose question tag
close menu
arrow
The AVERAGE function
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
A function Screen Tip
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
A circular reference
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
The MAX function
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
The MIN function
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
The COUNT function
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
Syntax (as it applies to Excel 2010)
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
Excel displays a green arrow in the top left corner of a cell if it detects a
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
An Argument (as it applies to Excel 2010)
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
A formula in Excel must begin with
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
An absolute cell reference
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
Semi-selection or pointing
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
A relative cell reference
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
The SUM function
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
The MEDIAN function
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
For a basic mathematical expression it is best to use
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
A mixed cell reference
Multiple Choice
Answer:
Tags
Choose question tag
close menu
Showing 1 - 20 of 90