Prepare for your next job interview or skill test with these top Excel multiple choice questions. This set of 100+ carefully selected MCQs covers Excel formulas, functions, shortcut keys, and data handling techniques \u2014 ideal for beginners, job seekers, and anyone looking to improve their Excel proficiency.<\/p>\n\n\n\n
Ctrl + Z<\/code> do?
A) Zoom in
B) Undo \u2705
C) Save
D) Redo<\/li>\n\n\n\n- Excel is part of which suite?
A) Microsoft Word
B) Microsoft Office \u2705
C) Microsoft Visual Studio
D) Google Workspace<\/li>\n\n\n\n - What is the default font in Excel 2016?
A) Arial
B) Calibri \u2705
C) Verdana
D) Times New Roman<\/li>\n\n\n\n - What is the shortcut to create a new workbook?
A) Ctrl + N \u2705
B) Ctrl + M
C) Ctrl + W
D) Ctrl + C<\/li>\n\n\n\n - Which of these is a valid cell address?
A) A-1
B) 1A
C) A1 \u2705
D) A#1<\/li>\n\n\n\n - Excel allows how many characters in a single cell?
A) 1024
B) 32,767 \u2705
C) 10,000
D) Unlimited<\/li>\n\n\n\n - What does the formula bar display?
A) Chart title
B) Active formula or value \u2705
C) Workbook name
D) Sheet name<\/li>\n\n\n\n - What does Excel use to calculate?
A) Commands
B) Syntax
C) Formulas \u2705
D) Graphics<\/li>\n\n\n\n - What is the default alignment for numbers in Excel?
A) Center
B) Right \u2705
C) Left
D) Justify<\/li>\n\n\n\n - What is a \u201crange\u201d in Excel?
A) A single cell
B) A formula
C) A group of selected cells \u2705
D) A graph<\/li>\n\n\n\n - What is the extension of macro-enabled Excel files?
A) .xls
B) .xlsx
C) .xlsm \u2705
D) .xlx<\/li>\n\n\n\n - Excel is NOT used for:
A) Financial Modeling
B) Text Formatting \u2705
C) Budget Planning
D) Inventory Management<\/li>\n<\/ol>\n\n\n\n
\n\n\n\n\u2705 Section 2: Formulas in Excel (Q31\u2013Q70)<\/strong><\/h3>\n\n\n\n\n- Which formula is used to add numbers?
A) =ADD
B) =PLUS
C) =SUM \u2705
D) =TOTAL<\/li>\n\n\n\n - What does
=AVERAGE(A1:A5)<\/code> do?
A) Adds all values
B) Finds maximum
C) Calculates average \u2705
D) Finds minimum<\/li>\n\n\n\n- What is the use of
=IF()<\/code> function?
A) Checks conditions \u2705
B) Adds values
C) Joins text
D) Sorts data<\/li>\n\n\n\n- What does
=VLOOKUP()<\/code> do?
A) Looks up values vertically \u2705
B) Looks horizontally
C) Filters data
D) Checks spelling<\/li>\n\n\n\n- What is the use of
=TRIM()<\/code>?
A) Remove numbers
B) Remove spaces \u2705
C) Add spaces
D) Split text<\/li>\n\n\n\n- What is
=CONCATENATE()<\/code> used for?
A) Comparing values
B) Joining text \u2705
C) Finding duplicates
D) Sorting cells<\/li>\n\n\n\n- What does
=LEFT(\"Excel\",2)<\/code> return?
A) El
B) Ex \u2705
C) Ec
D) xl<\/li>\n\n\n\n- Which function returns current date?
A) =DATE()
B) =CURRENT()
C) =TODAY() \u2705
D) =NOW()<\/li>\n\n\n\n - Which function returns both current date and time?
A) =DATE()
B) =TODAY()
C) =NOW() \u2705
D) =TIME()<\/li>\n\n\n\n =LEN(\"Excel\")<\/code> returns:
A) 6
B) 5 \u2705
C) 4
D) Error<\/li>\n\n\n\n- What does
=COUNT(A1:A10)<\/code> count?
A) Text
B) All data
C) Only numbers \u2705
D) Blank cells<\/li>\n\n\n\n- What does
=COUNTA(A1:A10)<\/code> count?
A) Only numbers
B) Blank cells
C) Text only
D) Non-blank cells \u2705<\/li>\n\n\n\n=MID(\"Microsoft\",2,4)<\/code> gives:
A) icro \u2705
B) icro
C) Micr
D) Cro<\/li>\n\n\n\n- What does
=ROUND(23.789,1)<\/code> return?
A) 23.8 \u2705
B) 23.7
C) 23.79
D) 24.0<\/li>\n\n\n\n- What is
=ISNUMBER(\"Hello\")<\/code>?
A) TRUE
B) FALSE \u2705
C) Error
D) 0<\/li>\n\n\n\n- What does
=MOD(10,3)<\/code> return?
A) 3
B) 1 \u2705
C) 2
D) 0<\/li>\n\n\n\n- Which function converts text to lowercase?
A) =UPPER
B) =LOWER \u2705
C) =TEXT
D) =CHAR<\/li>\n\n\n\n - Which function converts text to uppercase?
A) =UPPER \u2705
B) =BIG
C) =CAPITAL
D) =HIGH<\/li>\n\n\n\n =NOW()<\/code> gives:
A) Date
B) Time
C) Date and Time \u2705
D) Calendar<\/li>\n\n\n\n=ISBLANK(A1)<\/code> returns TRUE if:
A) Cell has formula
B) Cell has value
C) Cell is empty \u2705
D) Cell has 0<\/li>\n<\/ol>\n\n\n\nSection 2: Formulas in Excel (Q51\u2013Q70)<\/strong><\/h3>\n\n\n\n\n- What does
=IF(2>1, \"Yes\", \"No\")<\/code> return?
A) No
B) TRUE
C) Yes \u2705
D) Error<\/li>\n\n\n\n=SUM(A1:A5)<\/code> is an example of:
A) Relative referencing \u2705
B) Absolute referencing
C) Mixed referencing
D) Static range<\/li>\n\n\n\n- What does
=$A$1<\/code> represent?
A) Relative reference
B) Absolute reference \u2705
C) Mixed reference
D) Invalid formula<\/li>\n\n\n\n=A$1<\/code> is an example of:
A) Absolute reference
B) Relative reference
C) Mixed reference \u2705
D) Fixed reference<\/li>\n\n\n\n=MAX(10, 30, 5)<\/code> returns:
A) 5
B) 10
C) 30 \u2705
D) 15<\/li>\n\n\n\n=MIN(4, 6, 9, 1)<\/code> returns:
A) 6
B) 1 \u2705
C) 4
D) 0<\/li>\n\n\n\n=POWER(2,3)<\/code> gives:
A) 8 \u2705
B) 6
C) 9
D) 23<\/li>\n\n\n\n- What does
=TEXT(44561,\"dd-mm-yyyy\")<\/code> return?
A) Cell format
B) Date \u2705
C) Number
D) Time<\/li>\n\n\n\n=INT(4.9)<\/code> returns:
A) 5
B) 4 \u2705
C) 0
D) 1<\/li>\n\n\n\n=RANK(10,A1:A10)<\/code> gives:
A) Row number
B) Column number
C) Position of 10 in range \u2705
D) Sorting<\/li>\n\n\n\n=PROPER(\"excel formulas\")<\/code> returns:
A) excel formulas
B) Excel Formulas \u2705
C) EXCEL FORMULAS
D) Excel formulas<\/li>\n\n\n\n- What does
=ABS(-10)<\/code> return?
A) -10
B) Error
C) 10 \u2705
D) 0<\/li>\n\n\n\n=REPT(\"x\",5)<\/code> returns:
A) x
B) xxxxx \u2705
C) 5
D) Error<\/li>\n\n\n\n=SUBTOTAL(9,A1:A5)<\/code> performs:
A) Counting
B) Filtering
C) Sum \u2705
D) Formatting<\/li>\n\n\n\n=SEARCH(\"o\",\"Microsoft\")<\/code> returns:
A) 6 \u2705
B) 5
C) TRUE
D) Error<\/li>\n\n\n\n- What does
=VALUE(\"100\")<\/code> do?
A) Converts to text
B) Returns 0
C) Converts to number \u2705
D) Error<\/li>\n\n\n\n- Which function returns the current system time?
A) =NOW() \u2705
B) =TIME()
C) =CLOCK()
D) =DATE()<\/li>\n\n\n\n - What does
=TEXT(\"1\/1\/2025\",\"dddd\")<\/code> return?
A) 2025
B) Monday (or actual day name) \u2705
C) 1
D) dddd<\/li>\n\n\n\n=CEILING(4.3,1)<\/code> returns:
A) 4
B) 5 \u2705
C) 4.3
D) 6<\/li>\n\n\n\n=FLOOR(4.9,1)<\/code> returns:
A) 5
B) 4 \u2705
C) 4.5
D) 0<\/li>\n<\/ol>\n\n\n\n
\n\n\n\n\u2705 Section 3: Common Mistakes in Excel (Q71\u2013Q100)<\/strong><\/h3>\n\n\n\n\n- What happens if you type numbers with a leading apostrophe (
'123<\/code>) in Excel?
A) It will be stored as number
B) It will be stored as text \u2705
C) It will be stored as date
D) It will not work<\/li>\n\n\n\n- Using too many manual entries instead of formulas results in:
A) Less errors
B) Time saving
C) More time consumption \u2705
D) Faster Excel<\/li>\n\n\n\n - What does
$<\/code> sign in cell reference do?
A) Hides data
B) Highlights cell
C) Fixes row\/column \u2705
D) Deletes content<\/li>\n\n\n\n- Which is a bad practice<\/strong> in Excel?
A) Using shortcuts
B) Naming worksheets
C) Not formatting data \u2705
D) Backing up files<\/li>\n\n\n\n- What happens if a cell has spaces only?
A) It is counted in COUNT
B) It is considered as text \u2705
C) It is blank
D) It gives error<\/li>\n\n\n\n - What happens if Excel formula has a typo?
A) Nothing
B) It auto-corrects
C) It gives an error \u2705
D) It runs normally<\/li>\n\n\n\n - To avoid mistakes, always:
A) Use trial-and-error
B) Use formulas \u2705
C) Enter manually
D) Skip cell formats<\/li>\n\n\n\n - How to prevent data loss in Excel?
A) Don\u2019t use it
B) Use password
C) Keep auto-backup \u2705
D) Format disk<\/li>\n\n\n\n - Why should you avoid merged cells in large data sets?
A) Makes Excel faster
B) Merged cells can’t be sorted easily \u2705
C) Looks better
D) Saves time<\/li>\n\n\n\n - Forgetting to lock formula cells before sharing sheet causes:
A) Sheet crash
B) Formula loss \u2705
C) Extra features
D) Faster performance<\/li>\n\n\n\n - Using
=<\/code> without function or expression gives:
A) 0
B) Error \u2705
C) Result
D) 1<\/li>\n\n\n\n- Which is the correct<\/strong> use of cell reference in formula?
A) A1+B1 \u2705
B) A-1+B-1
C) A\/B\/C
D) A#B#C<\/li>\n\n\n\n- Which is a common mistake<\/strong> when copying formulas?
A) Dragging cells
B) Not checking references \u2705
C) Using keyboard
D) Using AutoSum<\/li>\n\n\n\n- Pressing Enter after typing formula will:
A) Delete formula
B) Evaluate formula \u2705
C) Save it as text
D) Clear sheet<\/li>\n\n\n\n - What causes
#DIV\/0!<\/code> error?
A) Multiplying 0
B) Dividing by zero \u2705
C) Empty row
D) Merging cells<\/li>\n\n\n\n- Which error appears for wrong function name?
A) #N\/A
B) #NAME? \u2705
C) #REF!
D) #VALUE!<\/li>\n\n\n\n - What does
#REF!<\/code> error indicate?
A) Formatting issue
B) Cell reference is invalid \u2705
C) Data missing
D) Typing mistake<\/li>\n\n\n\n- To prevent accidental changes in formula:
A) Use color
B) Merge cells
C) Protect sheet \u2705
D) Use TRIM()<\/li>\n\n\n\n - Which function helps correct text formatting?
A) PROPER \u2705
B) LOWER
C) CLEAN
D) TEXT<\/li>\n\n\n\n - One reason Excel crashes is:
A) Too little data
B) Too many formulas without optimization \u2705
C) Using UPPER()
D) Typing slowly<\/li>\n\n\n\n - What should be avoided when sharing Excel files?
A) Protected sheets
B) External links \u2705
C) Filters
D) Formulas<\/li>\n\n\n\n - Unformatted numbers may appear as:
A) Date \u2705
B) Text
C) Formula
D) Chart<\/li>\n\n\n\n - Which is NOT a best practice in Excel?
A) Using charts
B) Using conditional formatting
C) Manual total entry \u2705
D) Using pivot tables<\/li>\n\n\n\n - What slows down Excel performance?
A) SUM()
B) Charts
C) Volatile functions \u2705
D) IF()<\/li>\n\n\n\n - Copy-pasting large data without formats causes:
A) Fast performance
B) Unreadable data \u2705
C) Better file
D) Shortcut removal<\/li>\n\n\n\n - Which is a safer format for file backup?
A) .txt
B) .xlsx \u2705
C) .jpg
D) .pdf<\/li>\n\n\n\n - A clean Excel sheet should:
A) Have random colors
B) Be merged everywhere
C) Use formatting, borders & headings \u2705
D) Be left blank<\/li>\n\n\n\n - What can prevent accidental deletion of formulas?
A) Formatting
B) Freezing panes
C) Sheet protection \u2705
D) Filtering<\/li>\n\n\n\n - Forgetting to use
Data Validation<\/code> can cause:
A) Wrong data entry \u2705
B) More speed
C) Less errors
D) Blank rows<\/li>\n\n\n\n- Which of the following is true?
A) Excel is only for accountants
B) Excel cannot be automated
C) Excel helps save time and improve accuracy \u2705
D) Excel does not support logic<\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"Prepare for your next job interview or skill test with these top Excel multiple choice questions. This set of 100+ carefully selected MCQs covers Excel formulas, functions, shortcut keys, and data handling techniques \u2014 ideal for beginners, job seekers, and anyone looking to improve their Excel proficiency. \u2705 Section 1: \u2705 Section 2: Formulas in Excel (Q31\u2013Q70) Section 2: Formulas in Excel (Q51\u2013Q70) \u2705 Section 3: Common Mistakes in Excel (Q71\u2013Q100)<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8,30],"tags":[],"class_list":["post-12439","post","type-post","status-publish","format-standard","hentry","category-excel-mcq","category-ms-excel"],"rttpg_featured_image_url":null,"rttpg_author":{"display_name":"admin","author_link":"https:\/\/guidance24.in\/?author=1"},"rttpg_comment":0,"rttpg_category":"Excel MCQ<\/a> MS Excel<\/a>","rttpg_excerpt":"Prepare for your next job interview or skill test with these top Excel multiple choice questions. This set of 100+ carefully selected MCQs covers Excel formulas, functions, shortcut keys, and data handling techniques \u2014 ideal for beginners, job seekers, and anyone looking to improve their Excel proficiency. \u2705 Section 1: \u2705 Section 2: Formulas in…","_links":{"self":[{"href":"https:\/\/guidance24.in\/index.php?rest_route=\/wp\/v2\/posts\/12439","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/guidance24.in\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/guidance24.in\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/guidance24.in\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/guidance24.in\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=12439"}],"version-history":[{"count":1,"href":"https:\/\/guidance24.in\/index.php?rest_route=\/wp\/v2\/posts\/12439\/revisions"}],"predecessor-version":[{"id":12440,"href":"https:\/\/guidance24.in\/index.php?rest_route=\/wp\/v2\/posts\/12439\/revisions\/12440"}],"wp:attachment":[{"href":"https:\/\/guidance24.in\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=12439"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/guidance24.in\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=12439"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/guidance24.in\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=12439"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}