QuizGlory
Picture Quiz
Random Quiz
Guess the Word
Cartoons
Play Challenges
Cricket
Fun
Select here:
All Genres
Taarak Mehta (TMKOC)
Sarabhai vs Sarabhai
Famous TV Series
KPop (Korean Pop)
Hollywood
Riddles
Select here:
Easy Riddles
Classic Riddles
Difficult Riddles
Spot Differences
Mythology
Famous Personalities
Inventions
Kpop
Vocabulary
Select here:
Antonyms
Idioms & Phrases
One Word Substitutions
Synonyms
Spell Check
Word-Meanings
World GK
Select here:
Countries-At a Glance
Flags
Capitals
Continents
Currencies
Rivers
Deserts
Mountains
Heritage Sites
Landmarks
Location
Calendars
Newspapers
National Games
National Animals
National Birds
Subject
Select Here:
Biology
Chemistry
Computers
English
Geography
History
Maths
Science
Famous Awards:
Select here:
Nobel Prize
Ramon Magsaysay Award
Bharat Ratna
Major Dhyanchand Khel Ratna
Reasoning:
Select here:
Odd One Out
Logical Reasoning
Logical Series
Aptitude
Common GK
Solar System
English Grammar
My City My State
Religion
Environment
Sports
Mixed GK
Books & Authors
MS-Excel
MS-Word
Various Logos
Computer-IT
Harry Potter
Finance
Challenge Sets
Search Tips
×
Keep search text short.
Don't worry about spelling.
3+
Notifications
April 17, 2021
Invite your friends to try new and improved Quizglory Challenges. Click here to play...
April 04, 2021
GK Games are now available. Click here to play..
September 02, 2020
Registration can be done using Email ID now...No phone no. required. Click to Register Now.
June 05, 2020
Many interesting picture quizzes are being added. Click to Play Now.
May 01, 2020
Riddles section having new riddles being added frequently. Solve Now!
Goto Homepage
Home
Challenge Dashboard
My Score Board
Login / Register
Subscribe QuizGlory
×
Keep yourself updated. We will send you occasional emails about events happening at quiz-glory. You may un-subscribe anytime you want.
Quizglory::Challenge Yourself
Learn MS-Excel Part-3
Played 356 times.
Click here to play in
Smart Mode
Q.1 : How many worksheets can a workbook have in MS-Excel?
A:
3
B:
155
C:
255
D:
Only limited by computer storage
Q.2 : What is used to record a sequence of keystrokes and mouse actions to play back later in MS-Excel?
A:
Macro
B:
Pivot Table
C:
Scenario
D:
No such facility
Q.3 : Identify the chart type that shows the proportions of how one or more data elements relate to another data element?
A:
Line Chart
B:
Bar Chart
C:
X-Y Chart
D:
Pie Chart
Q.4 : Which type of function is used to calculate depreciation?
A:
Accounting
B:
Statistical
C:
Logical
D:
None of these
Q.5 : Data Series in MS-EXCEL can be defined as?
A:
Group of cells
B:
Group of worksheets
C:
Group of workbooks
D:
A collection of related data
Q.6 : The active cell in MS-EXCEL is:
A:
Receives the data user enters
B:
Is defined by a bold border around the cell
C:
Receives data user enters and defined by a bold border around the cell
D:
None of these
Q.7 : What are the tabs that appear at the bottom of each workbook called?
A:
Reference Tabs
B:
Location Tabs
C:
Position Tabs
D:
Sheet Tabs
Q.8 : What is represented by the small black square in the lower-right corner of an active cell or range?
A:
Copy Handle
B:
Fill Handle
C:
Move Handle
D:
Pick Handle
Q.9 : Which language is used to create macros in Excel?
A:
Java
B:
C++
C:
BASIC
D:
Visual BASIC
Q.10 : Which key do you press to check spelling in MS-Excel?
A:
F9
B:
F6
C:
F7
D:
F11