MS Excel Questions Answers
-
1. With which of the following all formulas in excel starts ?
- /
- *
- $
- =
Answer And Explanation
Answer: Option D
Explanation:
-
2. On an excel sheet the active cell in indicated by ?
- A dotted border
- A dark wide border
- A blinking border
- By italic text
Answer And Explanation
Answer: Option B
Explanation:
-
3. What term describes explanatory text attached to a cell ?
- Context
- Callout
- Comment
- Dialog
Answer And Explanation
Answer: Option C
Explanation:
-
4. How we can view a cell comment ?
- position the mouse pointer over the cell
- click the comment command on the view menu
- click the edit comment commands on the Insert menu
- click the Display comment command on the window menu
Answer And Explanation
Answer: Option A
Explanation:
-
5. Which of these will not select all the cells in a document ?
- Using the Edit – Select All menu
- Pressing Ctrl + A on the keyboard
- Clicking three times with the right mouse button in the spreadsheet
Answer And Explanation
Answer: Option C
Explanation:
-
6. The default style for new data keyed in a new workbook is ?
- Comma
- Normal
- Currency
- Percent
Answer And Explanation
Answer: Option B
Explanation:
-
7. If you press ___, the cell accepts your typing as its contents ?
- Tab
- Ctrl+Enter
- Enter
- Alt+Enter
Answer And Explanation
Answer: Option C
Explanation:
-
vasant 6 years ago
i want combine different data from different excel wokrsheet1, sheet2, sheet3 in one worksheet.
-
Alhassan Yahya 6 years ago
I would love to have more of the excel questions
-
Sangeetha Reddy Pasham 7 years ago
I want to know the count in E23 of "Fn Worker" mentioned from cell ref
E3:E17 in each unique department mentioned in A23 -
Sangeetha Reddy Pasham 7 years ago
-
Love Preet 7 years ago
Sir mera Punjab police operator constable ka exam hai pls give me any suggestion sir pls..
-
SHAMMI THAKUR 8 years ago
chutiya site h bc
-
Byte Sisas 8 years ago
Very helpful questions you have shared. Thanks for sharing.
IAS Bytes - IAS in One Attempt -
Krystle Burnside3 8 years ago
Good post ! I learned a lot from the facts , Does someone know where my company could possibly get access to a fillable CA PLD-C-010 document to use ?
-
Anil Kumar Pal 8 years ago
HI,
i want to know about excel, how can we use IF formula to use this thing if right "Topup" in A column then "1" should be autamatically enter in "B" column and if if right "Extratalktime" in same A column then "2" should be reflect their.kindly help me with this so that i can do my work easily. and save my time.
-
Manish Agrawal 8 years ago
hello mastguru
I want to create website plz help me
how to support back end support for this type of website
thankx -
**MILKY** 8 years ago
very nice questions :) ......thank u :)
-
Debaleena 8 years ago
Very good Website. Helps me a lot to prepare well for my computer exam.Thanks!
-
samrat naskar 8 years ago
thanks a lot sir for providing these ms-office mcq.
-
eedge tech 8 years ago
I WANT SOMETHING THAT i dont even know what it called. I want that whenever i type some value in one tab a text will appeare in another tab. like if i type 123 in "A2" a text like "Hellow" will be apare in "B3" vice versa. like a pointer in C .
-
ajay kumar bharti 8 years ago
hallo
-
Scott Alyssa 8 years ago
Is it possible to change the Default print settings on excel?
It automatically sets it as "Print Double Sided" but I want the default to be "Print One Sided" ?????? -
Mushtaq Shaikh 8 years ago
send the file please
-
Ajay Kumar Tiwari 9 years ago
Awesome exercise,
Many thanks! -
Surya 9 years ago
Thanks
-
Joseph 9 years ago
I have a question. When I enter time in decimal format in a cell I want that automatically converted into hh:mm format. Example if I type 0.75 in cell A2 I want it to automatically change to 00:45 in A2 itself.
-
Sachit Sharma 9 years ago
Write a macro to calculate total tax given to government
-
Clyde T. Salyer 9 years ago
If you have a formula, such as =sum(C6*E5) and you want to copy and paste that formula down that column, but you want the E5 to remain E5 and not change to E6, E7 and so on, but allow the C6 to change, how do you accomplish this?
-
Kyle 10 years ago
I want to create a Pie chart that shows my progress for a given project. There are 12 tabs open that list different project topics and each project has multiple tasks that must be completed. I want to create a check box for each requirement in all 12 tabs that form the total for my pie chart on the project home page. There has to be a formula to do this.
Thanks
-
Alex 10 years ago
Excel formula that makes the most of a column but instead of showing the result of the same name that shows another column someone could tell me how does the formula have finished describing?