If you have trouble viewing or submitting this form, you can fill it out
online:
https://docs.google.com/spreadsheet/viewform?fromEmail=true&formkey=dGtJRGJwNkJvdTRQb1JkMUVNOGcwS0E6MQ
Excel formula quiz 1
This quiz is sponsored by discussexcel.com. Ayush Jain Group Manager
Your name *
Email address(will remain confidential) *
1. Which of these function return type is not Boolean(True/False) ? *
Iserror
Exact
Match
Istext
2. What is the shortcut to display formulas in the sheet ? *
CTRL + `
CTRL + !
ALT + |
SHIFT + CTRL + ~
3. Which function replaces a specified piece of text with a different piece
of text ? *
Replace
Substitute
Mid
Find
4. Which combination of key we use after entering array formula ? *
ALT+CTRL+ENTER
SHIFT+ENTER
SHIFT+CTRL+ALT
SHIFT+CTRL+ENTER
5. Which function picks from a list of options based upon an Index value
given to by the user ? *
Find
Mid
Choose
Search
6. What is the shortcut to enter the current date in excel ? *
SHIFT + '
CTRL + ;
ALT + :
SHIFT + CTRL + :
7. Which function rounds a number down to the nearest whole number ? *
Round
Trunc
Int
Mround
8. Which function removes any nonprintable characters from text ? *
Clean
Trim
Proper
Clear
9. Which of these is correct with respect to DSUM function ? *
=DSUM(DBRange,CriteriaRange,FieldName)
=DSUM(FieldName,CriteriaRange,DBRange)
=DSUM(FieldName,DBRange,CriteriaRange)
=DSUM(DBRange,FieldName,CriteriaRange)
10. Which function creates a real date by using three normal numbers typed
into separate cells ? *
Datevalue
DMY
Date
Day
Powered by Google Docs Report Abuse - Terms of Service - Additional Terms
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited.
6) Jobs posting is not allowed.
7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
---
You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to
excel-macros+unsubscr...@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.
