Home
Excel Questions
Word Questions
PowerPoint Test
>
PowerPoint
Contact Us
Helpful video:
Learn how to avoid duplicate entries in a column
: -
https://youtu.be/YDkExNfYKQE
Excel Knowledge Test
Intermediate Level 5
General
*
Indicates required field
Name
*
First
Last
Email
*
What must you first do to Conditionally Format data
*
Click in cell A1
Select the data
Click in any cell
What must surround text that is being used in formulas
*
Single quote marks
Exclamation marks
Double quote marks
What are "Sparklines"
*
A Firefox message
A small chart in a cell
A formatted chart
All formulas start with an = sign. What is the alternative symbol
*
*
?
+
Which tab is required to create a simple macro
*
Developer
Page Layout
References
What is the program called that enables macros to be created or edited
*
Mozilla Firefox
Photoshop
Visual Basic
Can a trendline be inserted on a 3D chart
*
Yes
No
Which tab and command would you use to avoid duplicate data entries in a column
*
Home>Cells>Insert
Data>Data Validation
Formulas>Name Manager>Define Name
submit
Use the audio player above to hear answers and helpful tips
Home
Excel Questions
Word Questions
PowerPoint Test
>
PowerPoint
Contact Us