Quizzes
Search
Take Quizzes
Animal
Nutrition
Love
Relationship
Computer
Sports
Society
Business
Geography
Language
Personality
Harry Potter
Movie
Television
Music
Online Exam
Health
Country
Art
Entertainment
Celebrity
Math
Game
Book
Fun
Science
Food
History
Education
All Topics
Create a Quiz
Quiz Maker
Training Maker
Survey Maker
Flashcards
Brain Games
See All
ProProfs.com
Search
Create A Quiz
Take Quizzes
Animal
Nutrition
Love
Relationship
Computer
Sports
Society
Business
Geography
Language
Personality
Harry Potter
Movie
Television
Music
Online Exam
Health
Country
Art
Entertainment
Celebrity
Math
Game
Book
Fun
Science
Food
History
Education
All Topics
Products
Quiz Maker
Training Maker
Survey Maker
Flashcards
Brain Games
See All
ProProfs.com
Quizzes
Quizzes
›
Science
›
Technology
›
Microsoft Office
Excel Level 3
10 Questions
|
By MarieLamb | Updated: Feb 20, 2013
| Attempts: 279
Share
Start
Share on Facebook
Share on Twitter
Share on Whatsapp
Share on Pinterest
Share on Email
Copy to Clipboard
Embed on your website
Question
1
/ 10
0 %
0/100
Score
0/100
1.
What does transpose mean in Excel?
In Excel, the Transpose function returns a transposed range of specified cells. In other words in turns information in columns...
In Excel, the Transpose function returns a transposed range of specified cells. In other words in turns information in columns to rows
Paste Special
Paste
Paste without values
Submit
Start Quiz
About This Quiz
Advanced Excel skills.
2.
What's your name?
We’ll put your name on your report, certificate, and leaderboard.
2.
What language is used to create macros in Excel?
Visual C++
Visual Basic
Java
Flash
Submit
3.
The Range, Criteria and Sum_range are part of which function?
Nested If
IF
SumIf
Vlookup
Submit
4.
What is the difference between the vlookup and index and match?
They are both the same
The vlookup looks up data in the left column - index and match can lookup multiple columns
The vlookup looks up data to the left and the Index and Match looks up data to the right
Submit
5.
You can save and protect your workbook by using the following?
Write reservation Password
Protection Password
Read only recommended
All of the above
Submit
6.
When you see the following in a cell - what does it mean?
#DIV/0!
The formula is trying to divide an empty cell
You have failed to put the / sign inside the formula
The cells do not exist
You have inserted an incorrect cell
Submit
7.
What is a Pivot table?
A lookup table
Pivot tables creates reports from information you supply
A Pivot table quickly allows you to make your table look visually presentable
It shows only the formulas
Submit
8.
What is known as the backstage view in Excel?
The file menu
Print Menu
The information menu
The edit menu
Submit
9.
What are the len, left and Mid function used for?
Looking up data
The functions will help to clean up data
It is part of the pivot table
Submit
10.
What are the two dates systems that Excel can use?
1900 and 1904
Excel can use any format
2004 and 2010
1900 and 2000
Submit
View My Results
Related Quizzes
Business Analyst Excel Quiz
Business Analyst Excel Quiz
Excel Advance 1 Pre Test
Excel Advance 1 Pre Test
Advanced Excel For Actuaries Quiz
Advanced Excel For Actuaries Quiz
Electronic Communication Quiz Questions And Answers
Electronic Communication Quiz Questions And Answers
Which Garmin Watch Is Right For Me?
Which Garmin Watch Is Right For Me?
8th Grade Technology Assessment
8th Grade Technology Assessment
Thank you for your feedback!
Would you like to edit this question to improve it?
No thanks
Name:
Email:
Oops! Give us more information:
Incorrect Question
Incorrect Answer
Typos
I have a feedback
Submit
Please provide name and email to proceed.
Please provide correct email to proceed.
Please provide feedback.
Please select the option.
All (10)
Unanswered (
)
Answered (
)
What does transpose mean in Excel?
What language is used to create macros in Excel?
The Range, Criteria and Sum_range are part of which function?
What is the difference between the vlookup and index and match?
You can save and protect your workbook by using the following?
When you see the following in a cell - what does it mean?...
What is a Pivot table?
What is known as the backstage view in Excel?
What are the len, left and Mid function used for?
What are the two dates systems that Excel can use?
X
OK
X
OK
Cancel
X
OK
Cancel
Back to top
Back to top
Advertisement