Microsoft Excel MCQs

Option A: =LARGE(A:A, 2)

Option B: =LARGE(UNIQUE(A:A), 2)

Option C: =INDEX(SORT(UNIQUE(A:A), , -1), 2)

Option D: =SMALL(UNIQUE(A:A), 2)

Correct Answer: =INDEX(SORT(UNIQUE(A:A), , -1), 2) ✔

Option A: TRIM

Option B: SUBSTITUTE

Option C: CLEAN

Option D: REPT

Correct Answer: TRIM ✔

Option A: VLOOKUP retrieve data base on specified criteria from the most left column of the table, searching vertically down for a specified value.

Option B: VLOOKUP stands for “Value Lookup,” which searches horizontally across the top row of a table for a specified value.

Option C: VLOOKUP returns a value from the same row as the lookup value, but from a column specified by the user.

Option D: VLOOKUP scans the entire table and returns the first value found that matches the lookup criteria.

Correct Answer: VLOOKUP retrieve data base on specified criteria from the most left column of the table, searching vertically down for a specified value. ✔

Option A: Insert Tab

Option B: Page layout

Option C: View Tab

Option D: Home Tab

Correct Answer: Home Tab ✔

Option A: Length

Option B: Counter

Option C: Count

Option D: None of These

Correct Answer: Count ✔

Option A: To permanently delete rows or columns

Option B: To format the appearance of cells

Option C: To temporarily hide certain data based on specific criteria

Option D: To create a chart

Correct Answer: To temporarily hide certain data based on specific criteria ✔

Option A: Cells

Option B: Columns

Option C: Blocks

Option D: Rows

Correct Answer: Cells ✔

Option A: 100%

Option B: 300%

Option C: 400%

Option D: 500%

Correct Answer: 400% ✔

Option A: Document 1

Option B: Workbook 1

Option C: Book1

Option D: Worksheet

Correct Answer: Book1 ✔

Option A: Alt+F1

Option B: F2

Option C: F3

Option D: F4

Correct Answer: Alt+F1 ✔

Option A: To perform a vertical lookup and return a value based on a specified criteria

Option B: To perform a horizontal lookup and return a value based on a specified criteria

Option C: To add up a range of cells

Option D: To find the average of a range of cells

Correct Answer: To perform a vertical lookup and return a value based on a specified criteria ✔

Option A: To perform a logical test and return a value based on the result

Option B: To add up a range of cells

Option C: To find the average of a range of cells

Option D: To count the number of cells in a range

Correct Answer: To perform a logical test and return a value based on the result ✔

Option A: To add up a range of cells

Option B: To find the average of a range of cells

Option C: To count the number of cells in a range

Option D: To find the maximum value in a range of cells

Correct Answer: To add up a range of cells ✔

Option A: A cell

Option B: A range

Option C: A column header

Option D: A row header

Correct Answer: A cell ✔

Option A: Worksheet

Option B: Workbook

Option C: Formula

Option D: Location

Correct Answer: Workbook ✔

Option A: Ctrl+H

Option B: Ctrl+7

Option C: Ctrl+9

Option D: None of the above

Correct Answer: Ctrl+9 ✔

Option A: Pencil work

Option B: Active cell

Option C: Menu bar

Option D: Workbook

Correct Answer: Pencil work ✔

Option A: Decoration

Option B: Data appearance

Option C: Functions

Option D: Charting

Correct Answer: Charting ✔

Option A: A row

Option B: A column

Option C: A unit of data

Option D: A unit of formatting

Correct Answer: A unit of data ✔

Option A: A, B, C, etc.

Option B: 1, 2, 3, etc.

Option C: A1, A2, A3, etc.

Option D: $A$1, $A$2, etc.

Correct Answer: A, B, C, etc. ✔

Option A: 10

Option B: 100

Option C: 300

Option D: 500

Correct Answer: 500 ✔

Option A: Progrms

Option B: Macros

Option C: Procedured

Option D: All of these

Correct Answer: Macros ✔

Option A: Average

Option B: Count

Option C: Minimum

Option D: Maximum

Correct Answer: Maximum ✔

Option A: Name box

Option B: Row headings

Option C: Formula bar

Option D: None of these

Correct Answer: Formula bar ✔

Option A: Workbook

Option B: Function

Option C: Column

Option D: Range

Correct Answer: Range ✔

Option A: .Xlsx

Option B: .Xls

Option C: .excel

Option D: .123

Correct Answer: .Xlsx ✔

Option A: Calculations

Option B: Formulas

Option C: Functions

Option D: Relative addressing

Correct Answer: Functions ✔

Option A: Shift

Option B: Esc

Option C: Tab

Option D: Space

Correct Answer: Space ✔

Option A: Format number in comma format

Option B: Format number in currency format

Option C: Format number in date format

Option D: Format number in time format

Correct Answer: Format number in comma format ✔

Option A: Ctrl+4

Option B: Ctrl+5

Option C: Ctrl+6

Option D: None of the above.

Correct Answer: Ctrl+5 ✔

Option A: Excel 2016

Option B: Excel 2017

Option C: Excel 2021

Option D: Office 365

Correct Answer: Excel 2021 ✔

Option A: Home

Option B: View

Option C: Page Layout

Option D: Insert

Correct Answer: Home ✔

Validation
Formats
Formulas
All of above

Submitted by: IJAZ UQAAB

We can paste formula, value, formats, comments, validation using Paste Special command.

Correct Answer: All of above ✔

Option A: From Border tab in Format Cells dialog box

Option B: From Border tool in Formatting toolbar

Option C: From Line Style tool in Drawing toolbar

Option D: You can not set page border in Excel

Correct Answer: You can not set page border in Excel ✔

Option A: Formula bar

Option B: Status bar

Option C: Name box

Option D: Title bar

Correct Answer: Name box ✔

Option A: AA

Option B: A1

Option C: Aa

Option D: None of these

Correct Answer: A1 ✔

Option A: Workbooks

Option B: Worksheets

Option C: Charts

Option D: Worksheets and Charts

Correct Answer: Worksheets ✔

Option A: Ctrl + Shift + ;

Option B: Ctrl+!

Option C: Ctrl+*

Option D: None of these

Correct Answer: Ctrl + Shift + ; ✔

Option A: Accessing

Option B: Referencing

Option C: Updating

Option D: Functioning

Correct Answer: Referencing ✔

Option A: Iron

Option B: Phosphorus

Option C: Sodium

Option D: Calcium

Correct Answer: Iron ✔

Option A: File

Option B: Insert

Option C: Design

Option D: None of Above

Correct Answer: File ✔

Option A: F1 Key

Option B: F2 Key

Option C: F3 Key

Option D: F4 Key

Correct Answer: F2 Key ✔

Option A: Hyperlinked

Option B: placed in a word table

Option C: linked

Option D: embedded

Correct Answer: linked ✔

Option A: Arithmetic

Option B: Logical

Option C: Conditional

Option D: Greater

Correct Answer: Logical ✔

Option A: Hyperlink

Option B: Index

Option C: Transpose

Option D: Rows

Correct Answer: Transpose ✔

Option A: An application that supports editing scanned documents

Option B: None of these

Option C: Business-relationship database

Option D: A scanning and OCR application

Correct Answer: Business-relationship database ✔

Option A: A tool for managing business finances

Option B: None of these

Option C: Project management software to keep track of events and to create network charts and Gantt charts

Option D: Diagram and flow-charting software

Correct Answer: A tool for managing business finances ✔

Option A: None of these

Option B: Microsoft Word

Option C: Microsoft Excel

Option D: Microsoft PowerPoint

Correct Answer: Microsoft Excel ✔

Option A: Ctrl + Page Down

Option B: Shift + Page Down

Option C: Page Down

Option D: None of these

Correct Answer: Ctrl + Page Down ✔

Option A: Tab

Option B: Shift

Option C: Space

Option D: None of these

Correct Answer: Tab ✔

Option A: Ctrl+ ”

Option B: Ctrl+ ;

Option C: Ctrl+ :

Option D: Ctrl+ ‘

Correct Answer: D. Ctrl+ ‘ ✔

Option A: Ctrl + “

Option B: Ctrl+ E

Option C: Ctrl+ E

Option D: Ctrl+ D

Correct Answer: A. Ctrl + “ ✔

Option A: F1

Option B: F2

Option C: F3

Option D: None of these

Correct Answer: F1 ✔

Option A: MS WORD

Option B: MS EXCEL

Option C: MS POWERPOINT

Option D: None of these

Correct Answer: MS EXCEL ✔

Option A: /

Option B: *

Option C: $

Option D: =

Correct Answer: = ✔

Option A: Smart tip

Option B: Soft Tip

Option C: Web Tip

Option D: Cell Tip

Correct Answer: Cell Tip ✔

Option A: Data

Option B: Tools

Option C: Formatting

Option D: Layout

Correct Answer: Data ✔

Option A: 65,536

Option B: 16,384

Option C: 1,048,576

Option D: None of Above

Correct Answer: 1,048,576 ✔

Option A: 65,536

Option B: 16,384

Option C: 1,048,576

Option D: None of Above

Correct Answer: 16,384 ✔

Option A: Pivot Table Report

Option B: Pivot Table List

Option C: Pivot Table Field List

Option D: HTML

Correct Answer: Pivot Table Report ✔

Option A: Edit

Option B: Ignore All

Option C: Ignore

Option D: Change

Correct Answer: Edit ✔

Option A: form

Option B: standard

Option C: Drawing

Option D: Formatting

Correct Answer: standard ✔

Option A: Tab

Option B: Ctrl+Enter

Option C: Enter

Option D: Alt+Enter

Correct Answer: Enter ✔

Option A: Comma

Option B: Normal

Option C: Currency

Option D: Percent

Correct Answer: Normal ✔

Option A: position the mouse pointer over the cell

Option B: click the comment command on the view menu

Option C: click the edit comment commands on the Insert menu

Option D: click the Display comment command on the window menu

Correct Answer: position the mouse pointer over the cell ✔

Option A: Using the Edit – Select All menu

Option B: Pressing Ctrl + A on the keyboard

Option C: Clicking three times with the right mouse button in the spreadsheet

Option D: None of These

Correct Answer: Clicking three times with the right mouse button in the spreadsheet ✔

Option A: by letters

Option B: by numbers

Option C: by cell references

Option D: by symbols

Correct Answer: by numbers ✔

Option A: workbook

Option B: column

Option C: row

Option D: cell

Correct Answer: cell ✔

Option A: Active cell

Option B: Cell containing a formula

Option C: Locked cell

Option D: Cell

Correct Answer: Active cell ✔

Option A: you will be in the cell A1

Option B: you will be in the cell B5

Option C: you will be in the cell B3

Option D: you will be in the cell B6

Correct Answer: you will be in the cell B5 ✔

Option A: Work book

Option B: Work

Option C: Account book

Option D: Work sheet

Correct Answer: Work book ✔

Option A: Pressing the Esc key

Option B: Pressing the Tab Key

Option C: Both of these

Option D: None of above

Correct Answer: Pressing the Esc key ✔

A. A3-G3
B. A3:G3
C. A3?.G3
D. A3 to G3

Submitted by: Rashid Mehmood

Correct Answer: A3:G3 ✔

A. label
B. Value
C. Formula
D. All of these

Submitted by: Rashid Mehmood

Correct Answer: All of these ✔

Option A: Workbook

Option B: Worksheet

Option C: Notesheet

Option D: Notebook

Correct Answer: Worksheet ✔

Option A: Positive number

Option B: Negative number

Option C: Zero values

Option D: Text values

Correct Answer: Positive number ✔

Option A: 7

Option B: 1.5

Option C: 2

Option D: 12

Correct Answer: 7 ✔

Option A: Plot area

Option B: Fill handler

Option C: Series

Option D: Chart area

Correct Answer: Fill handler ✔

Option A: Vertical axis

Option B: Horizontal axis 

Option C: Bar data

Option D: None of these

Correct Answer: Horizontal axis  ✔

Option A: Insertion

Option B: Deletion

Option C: Retrieving

Option D: Traversing 

Correct Answer: Traversing  ✔