MS Excel MCQs

The most repeated MS Excel MCQs and essential shortcut keys from past competitive exams for effective computer mcq tests preparation online.

Basic Shortcut keys of ms excel

Input CommandAction in MS Excel Sheet
F1Opens the Help menu
F2Edit the selected cell
F4Repeat the last action
F5Find a specific cell
F7Spell checker for text
F11Create a chart
F12Save as Option
Ctrl + DFill down the cell in selection
Ctrl + HFind and Replace
Ctrl + KInsert Hyperlinks
Ctrl + PPrint the Excel Sheet
Ctrl + SSave the Sheet
Ctrl + WClose the open Workbook
Ctrl + YRepeat the last done action
Ctrl + ZUndo the last done action
Ctrl + 0Hide Selected Columns
Ctrl + 9Hide Selected Rows
Ctrl + Shift + (Unhide the rows
Ctrl + Shift + )Unhide the Columns
Alt + Shift + F1Insert new worksheet
Shift + F3Open the formula box
Shift + F5Open the search box
Ctrl + F9Minimize current window
Ctrl + F10Maximize the selected window
Ctrl + F6Switch between open workbooks
Ctrl + TabMove between open Excel® files
Ctrl + Shift + ;Enter the current time
Ctrl + ;Enter the current date
Ctrl + SpacebarSelects the entire column
Shift + F2Edit a cell comment
Alt + F4Exit from Excel

Basic MS Excel MCQs

MS Excel stands for_______
  1. Micromax Excel
  2. Microsoft Excel
  3. Micromax Excess
  4. Management Excel
  5. All of these

A cell is defined as :

  1. The intersection of a column and a row
  2. An input box
  3. a rectangular marker
  4. All of the above
Which of the following is not valid zoom percentage in Excel:
  1. 500%
  2. 600%
  3. 700
  4. None of the above

In which software slide have?

  1. Word
  2. PowerPoint
  3. Excel
  4. None

What is used to split long text in excel within the cell?

  1. Wrap text
  2. Click next
  3. All
  4. None
Which of the following methods can not be used to edit the contents of a cell?
  1. Double clicking the cell
  2. Press the Alt key
  3. Pressing the F2 key
  4. Clicking the formula bar
Which of the following is not a word processor?
  1. Word Perfect
  2. Microsoft Excel
  3. Word Star
  4. Microsoft Word
To drag a selected range of data to another worksheet in the same workbook, use the?
  1. Shift key
  2. Alt key
  3. Tab key
  4. Ctrl key

When a range is selected, how can you activate the previous?

  1. Press Tab
  2. Press the Alt key
  3. Press Enter
  4. none
Tab scroll buttons are place on excel screen
  1. Towards the bottom left corner
  2. Towards the bottom right corner
  3. Towards the bottom top right corner
  4. None

MS Excel provides the default value for step in fill series dialogue box

  1. 1
  2. 2
  3. 3
  4. 5
Worksheet in excel by default ___
  1. 3
  2. 2
  3. 1
  4. 4

Long text can be broken down into many lines within a cell. You can do this through

  1. Justify in Edit > Cells
  2. Wrap Text in Format > Cells
  3. None
  4. All

To remove the content of selected cells you must issue ___ commands

  1. Clear All
  2. Clear Delete
  3. Clear Contents
  4. All

Edit> Delete Command

  1. Deletes selected cells
  2. Deletes Formats of cell
  3. Deletes the comment of cell
  4. All
Multiple calculations can be made in a single formula using
  1. Complex Formulas
  2. Standard Formulas
  3. Array Formula
  4. All
Worksheet in excel by default ___
  1. 3
  2. 2
  3. 1
  4. 4

What do you mean by a workspace ?

  1. Group of Workbooks
  2. Group of Rows
  3. Group of Worksheets
  4. None
To select an entire column in MS Excel, press?
  1. Ctrl +r
  2. Ctrl +s
  3. Ctrl +c
  4. none

Microsoft excel is a powerful______

  1. Spreadsheet package
  2. Word processing package
  3. DBMS package
  4. None

A numeric value can be treated as label value if ___ precedes it.

  1. =
  2. ( ‘ )
  3. #
  4. None
___the cell pointer indicates that you can fill series
  1. Doctor’s symbol (Big Plus)
  2. Small thin plus icon
  3. Mouse Pointer with anchor at the tip
  4. None

___ is the short key to select the entire column in Excel.

  1. Alt + space bar
  2. Shift + space bar
  3. Control + space bar
  4. None of the above

You can check the conditions against _____when applying conditional formatting

  1. Cell value
  2. Formula
  3. Both of above
  4. none

Which shortcut key is for auto sum ?

  1. Alt + =
  2. Ctrl + Shift
  3. Alt + F1
  4. Ctrl + =

which option is not avail.able in Paste special dialogue box ?

  1. Subtract
  2. Divide
  3. SQRT
  4. none
Which of the following EXCEL feature allows users to evaluate values and return a result?
  1. Formula
  2. Formating
  3. Filters
  4. None of these

Which of following series type is not valid for fill series dialogue box ?

  1. Time
  2. Autofill
  3. Growth
  4. All

Which of following is not the correct method of editing the cell content ?

  1. Press the Alt key
  2. Click the formula bar
  3. Press the F2 key
  4. none

Which of following is not a valid zoom percentage in Excel?

  1. 10
  2. 100
  3. 300
  4. 500

Which of following is an active cell in excel?

  1. Cell address
  2. Range
  3. Formula
  4. Current cell

Which menu can be used to split windows into two?

  1. Window > Split
  2. Review > Window
  3. View > Window > Split
  4. none

Which is not the function of “Edit clear command”?

  1. Delete cells
  2. Delete notes
  3. Delete contents
  4. None

How a cell can be edit on Excel sheet?

  1. Edit contents of cell directly in cell
  2. Edit by typing in formula bar
  3. Edit mode
  4. All above mentioned
Normally, A spread contains:
  1. documents
  2. rows
  3. rows and columns
  4. columns
Colour and pattern used to fill a closed shape is called?
  1. Shape
  2. WordArt
  3. Fill Style
  4. Fill Back
Data arrangements in cell is known as
  1. Sorting
  2. Delete
  3. Arrange
  4. None
Excel probably considers the cell entry November 1, 2024 to be a ___
  1. Label
  2. Value
  3. Formula
  4. Text string
A computer application program that displays data arranged in rows and columns is called?
  1. Spreadsheet
  2. Register
  3. Form
  4. Box

The .xls extension is used for ___ files

  1. Windows
  2. Excel
  3. Power Point
  4. Access
  5. Word

____You can use to create chart?

  1. Wizard
  2. Ms word
  3. Excel
  4. None

Statistical calculation of tables and graphs can be done using

  1. adobe photoshop
  2. excel
  3. notepad
  4. powerpoint

___ is not a valid data type in excel

  1. Number
  2. Label
  3. Character
  4. none
Which of the following is not an option in the spelling dialog box?
  1. Ignore
  2. Edit
  3. Change
  4. Ignore All
  5. None of these

Which of following you can paste selectively using paste special command:

  1. Formats
  2. Validation
  3. Formulas
  4. All of above
In_____ tab you will find auto sum button:
  1. formatting tab
  2. Formulas tab
  3. standard tab
  4. none
We can enter and edit the text efficiently using
  1. Spreadsheet
  2. PowerPoint
  3. Word Processing Program
  4. None
Which menu is selected for print?
  1. Special
  2. Tools
  3. File
  4. Edit
  5. All of these
In MS-Excel, when the formula bar is activated, we can see:
  1. Enter Button
  2. Cancel Button
  3. Edit Formula Button
  4. None of these
  5. All of these
In MS-Excel, the ZOOM option appears in:
  1. Formula Bar
  2. Status Bar
  3. Title Bar
  4. Scroll Bar
  5. None of these

In MS Excel, to clear all content, Formats and comments in selected cell, we use?

  1. Clean All
  2. Clear All
  3. Clean Content
  4. Clean Format
Which key is used to GO TO tab in Ms Excel?
  1. F1
  2. F3
  3. F6
  4. F5
  5. None of these

Which of the following is not the part of merge process?

  1. Data source
  2. merge source
  3. internet source
  4. None

in a computer spreadsheet block of numbers is called:

  1. workbook
  2. columns
  3. rows
  4. range

which of these keys are used in ms excel to copy formulas from the above cell?

  1. ctrl +
  2. ctrl +;
  3. ctrl +:
  4. ctrl +’
move to the next cell in the row in ms excel.
  1. Tab
  2. shift
  3. space
  4. none of these
move to the next cell in the sheet in ms excel.
  1. ctrl + page down
  2. shift + page down
  3. page down
  4. none of these

Microsoft office spreadsheet program is ?

  1. Microsoft word
  2. Microsoft excel
  3. Microsoft powerpoint
  4. none of these

The title bar in MS Excel displays the name of the?

  1. Worksheet
  2. workbook
  3. formula
  4. location

Which function in excel tells how many numeric entries are there?

  1. NUM
  2. COUNT
  3. SUM
  4. CHKNUM​
In a computer spreadsheet, cell range A3 through G3 should be keyed is as?
  1. A3-G3
  2. A3:G3
  3. A3: G3
  4. A3 to G3
in a computer spreadsheet, SUM, AVERAGE, MIN and MAX are examples of?
  1. calculation
  2. formulas
  3. functions
  4. relative addressing
How columns are numbered in MS Excel ?
  1. numeric
  2. alphabetic
  3. roman
  4. None

The actual working area of the Computer’s Microsoft Excel is?

  1. workbook
  2. worksheet
  3. note sheet
  4. notebook

How are data organized in a spreadsheet ?

  1. Lines and spaces
  2. Layers and planes
  3. Rows and columns
  4. Height and width

What term describes explanatory text attached to a cell?

  1. Context
  2. Callout
  3. Comment
  4. Dialog

The column heading in the spreadsheet are identified by:

  1. Alphabets
  2. Numbers
  3. Symbels
  4. None of these

which of these keys are used in ms excel to copy values from the above cell?

  1. ctrl +
  2. ctrl F
  3. ctrl S
  4. ctrl D

which of the following is a correct cell address?

  1. AA
  2. 5C
  3. 38,7
  4. C5
In MS excel, a ___ identifies a range by the cells located at diagonally opposed corners.
  1. Range
  2. Range Address
  3. Cell
  4. None of these
In MS Excel window, on the bottom, right area of the spreadsheet there is/are:
  1. Horizontal scroll bar
  2. Zoom tool
  3. Page view commands
  4. All of these

which of the following is not a valid Zoom percentage in Excel?

  1. 100
  2. 200
  3. 500
  4. None

In Microsoft Excel, the file you create and edit is called?

  1. A form
  2. A ledger
  3. A Work Book
  4. A Table

In MS Excel; comments put in the cell are called—-

  1. Smart tip
  2. Vip tip
  3. Soft tip
  4. None
In MS Excel, Conditional Formatting is in ___ tab?
  1. Home
  2. View
  3. Page Layout
  4. Insert

A numeric value can be treated as label value if it is precedes with

  1. Apostrophe
  2. Exclamation
  3. Hash
  4. Ampersand

In chart wizard, term data series refers to

  1. A chart legend
  2. A collection of chart data markers
  3. A data label
  4. None
To return the reminder after the number is divided by a divisor in Excel we use the function ?
  1. ROUND ( )
  2. FACT ( )
  3. MOD ( )
  4. None

Which of the fol towing can you use to add times to the slides in a presentation?

  1. slide show menu
  2. rehearse timing button
  3. slide transition button
  4. all

What type of chart is good for single series of data ? Column Chart Line Chart

  1. Pie Chart
  2. Line Chart
  3. Column Chart
  4. None
What MS Excel 2016 feature can you use if you want to work with one record at a time?
  1. Autocomplete
  2. Auto filter
  3. Data Form
  4. Data validation
The arrangement of elements such as Title, Subtitle text, picture, tables etc.
  1. layout
  2. presentation
  3. design
  4. scheme

Which of following is not a valid data type in MS Excel ?

  1. Number
  2. character
  3. label
  4. Date/Time
A feature that displays only the data in column (s) according to specified criteria
  1. Filtering
  2. Sorting
  3. Formula
  4. None

What type of chart will you use to compare performance of sales of two products ?

  1. Pie Chart
  2. Line Chart
  3. Column Chart
  4. None

Which feature is used to make selected sentence to All Captital Letters or All Small Letters ?

  1. Change case
  2. Change letter
  3. Change sentence
  4. Change word
Which of these key are used to apply outline border to the selected cell in MS Excel?
  1. CTRL+SHIFT+ %
  2. CTRL+SHIFT+ &
  3. CTRL+SHIFT+ ~
  4. CTRL+SHIFT+ $

Another name for a pre programmed formula in excel is __

  1. Cell
  2. Graph
  3. Function
  4. Range

Which of following function is used to sum the values in a range that meet criteria that you specify

  1. SUM
  2. SUMIF
  3. SUMALL
  4. SUMANY

What type of chart is useful for comparing values over categories?

  1. Line Chart
  2. Column Chart
  3. Pie Chart
  4. None

The columns of a table correspond to:

  1. Table
  2. Record
  3. Field
  4. Cell

The total number of rows in a worksheet?

  1. Unlimited
  2. 65,535
  3. 1,048,576
  4. 1,068,576

When the CPU detects an interrupt, then it saves its?

  1. previous State
  2. Next State
  3. Current State
  4. Both A and B

Which feature is used to wrap extra-long text into multiple lines in MS Excel ?

  1. wrap text
  2. text wrap
  3. letter warp
  4. word wrap

What are the basic rectangular building blocks of a spreadsheet?

  1. cells
  2. zoom slider
  3. help button
  4. all

Which of the following is not a term pertaining to spreadsheets?

  1. cell
  2. character
  3. browser
  4. formula

in Microsoft Excel template is the combination of different ___?

  1. Colors
  2. Effects
  3. Fonts
  4. All of these
… is a standard Windows control that displays the percentage of completion of a particular process as a graphical bar?
  1. Progress Bar
  2. Address bar
  3. Menu bar
  4. None

In a spreadsheet, letters are used to represent _____

  1. Columns
  2. Rows
  3. Cells
  4. None

In Excel, which is used to perform what if analysis ?

  1. Goal seek
  2. Solver
  3. Scenario Manager
  4. All of above

Microsoft Excel functions arguments are always written in __ ?

  1. Rows
  2. Cells
  3. Columns
  4. Parentheses

the command used to apply look of one piece of text to other parts of text documents.

  1. Copy
  2. Past
  3. Format Painter
  4. None of these

___ displays the content of active cell?

  1. Row headings
  2. Name box
  3. Formula bar
  4. None

Which one cannot be used to enter data in a cell in MS Excel?

  1. Pressing tab key
  2. Pressing arrow key
  3. Pressing Esc key
  4. clicking the enter button to the formula bar

Which value remain unchanged in Ms Excel?

  1. constant
  2. variable
  3. function
  4. none

Which among following wildcard characters are recognized by excel ?

  1. +and –
  2. ; and ^
  3. * and ?
  4. <and >

To select a group of worksheet we press and hold ____ key and select the sheet we want to add :

  1. ctrl
  2. shift
  3. alt
  4. None

The freezing row and column in Excel is in which pane

  1. Freezing row
  2. Freezing column
  3. Freezing pane
  4. None

The _____ option is used to show a specific row or column on every printed page.

  1. print layout
  2. print title
  3. print view
  4. none

In Excel data series is ?

  1. A row or column of numbers that are plotted in a chart
  2. Spreed sheet
  3. Work sheet
  4. None

Which would you choose to move selected text from one place to another?

  1. copy and paste
  2. delete and paste
  3. move and paste
  4. cut and paste

MS Excel is based on :

  1. UNIX
  2. DOS
  3. WINDOWS
  4. OS/2

Which elements of a worksheet can be protected from accidental modification

  1. Scenarios
  2. Objects
  3. Contents
  4. All of the above

Getting data from a cell located in a different sheet is called

  1. Accessing
  2. Referencing
  3. Updating
  4. none

How do you display current date and time in MS Excel ?

  1. Date ()
  2. Today ()
  3. Year ()
  4. Now ()
  5. Time ()
In a computer spreadsheet rows are labeled:
  1. By letters
  2. By numbers
  3. By cell references
  4. By symbols
  5. None of these

User developed instruction for excel are called___?

  1. Procedured
  2. Macros
  3. Programs
  4. None

Which of following is not an element of computer spreadsheet interface ?

  1. Pencil work
  2. Active cell
  3. Menu bar
  4. None

The default style for new data keyed in a new workbook is____?

  1. Comma
  2. Normal
  3. Currency
  4. percent

Which command will you choose to convert a column of data into row?

  1. Paste Special > Transpose
  2. Cut and Paste
  3. Special
  4. none

Instructions are written in machine language as

  1. Binary Code
  2. English Code
  3. Link Code
  4. None of these

Which function will you use to enter current time in a woksheet cell ?

  1. =time()
  2. =nowtime()
  3. =now()
  4. =currentTime()

how many sheets are there in the Excel workbook by default?

  1. 2
  2. 3
  3. 4
  4. 5

Comments can be added to cells using ____

  1. Data > Comments
  2. Home > Comments
  3. Insert > Comment
  4. none
In a computer spreadsheet, each cell contains a?
  1. Label
  2. value
  3. formula
  4. *All of these*
in MS excel 2016, which of the following can be used to split windows into two?
  1. Format > Window
  2. View > Window> Spilt
  3. Window > Spilt
  4. View > Spilt
What is active cell in MS-Excel ______?
  1. Rectangular box
  2. Pointer
  3. Nearing point of view
  4. None of the above
You can use the formula palette to
  1. Enter assumptions data
  2. Create and edit formula containing functions
  3. Format cells containing numbers
  4. none
In MS Excel to add two cells (A1 and A2) togather you use the following formula
  1. = add(A1+A2)
  2. = A1+A2
  3. = together A1:A2
  4. None of these

Which function can be used to calculate the monthly mortgage payment :

  1. PMT
  2. PV
  3. MORT
  4. None of these

Which allow to access from one cell to another

  1. Address
  2. Formulas
  3. Values
  4. None of these

which key is used for help in MS excel——?

  1. F1
  2. F2
  3. F3
  4. NONE OF THESE

In Excel which shortcut key is used to go to the formula tab?

  1. Alt+M
  2. Ctrl+M
  3. Ctrl+C
  4. Ctrl+B

in excel which key is used for format numbers in comma format?

  1. ctrl+shift+1
  2. ctrl+shift+4
  3. crtl+1
  4. shift+1

Shortcut key to insert a new worksheet in Excel is _____.

  1. Shift + F8
  2. Shift + F9
  3. Shift + F10
  4. Shift + F11

The delete key of keyboard is assigned to which command in excel ?

  1. Edit > Clear > All
  2. Edit > Clear > Contents
  3. Edit > Delete
  4. none

What is the keyboard shortcut to insert a SUM formula in MS Excel?

  1. CRTL+ =
  2. ALT + =
  3. ALT + S
  4. CTRL + ALT+ =

Which key is used to enter the current date in Excel?

  1. Ctrl+:
  2. Ctrl+Shift:
  3. Ctrl+;
  4. None of these

Which is the shortcut key to display active cells in Excell?

  1. Shift+Backspace
  2. Crtl+Backspace
  3. Alt+Backspace
  4. none
Ms Excel is a
  1. Spreadsheet program
  2. Multimedia software
  3. Entertainment software
  4. None

Ms Excel displays the current cell address in the ____

  1. Name box
  2. Cell tip
  3. Both
  4. None
—–is used for arranging data in ascending/descending order in MS Excel
  1. Data, order
  2. Data, sort
  3. Data, all
  4. None of these

What term refers to a specific set of values saved with the workbook?

  1. Range
  2. Trend line
  3. Scenario
  4. What-if analysis

The horizontal and vertical lines on a spreadsheet are called:

  1. Grid-lines
  2. Block lines
  3. Sheets
  4. Cells

Which type of chart use in time changing project?

  1. Bar
  2. Histo
  3. line
  4. none of these
Which sign is used to create an absolute cell reference in MS Excel?
  1. @
  2. =
  3. $
  4. %
What will be the result of formula ‘=16/2^3’ in a cell in MS Excel?
  1. 512
  2. 124
  3. 2
  4. 124
In a new workbook in MS Excel, which one appears on the topmost of the screen?
  1. Status Bar
  2. Title Bar
  3. Vertical Scroll bar
  4. Horizontal scroll bar

In MS Excel ready-made templates are available under __ tab in new option.

  1. file
  2. Count
  3. Table
  4. none

Which function is not available in the consolidate dialogue box ?

  1. Average
  2. Max
  3. Pmt
  4. None

What is the main function of MS Excel?

  1. organized data
  2. loss data
  3. gain data
  4. none of these

Excel is a———program developed by Microsoft.

  1. spreadsheet
  2. document
  3. data management
  4. all of the above

MS-Excel uses the _____ function when creating a data table.

  1. Average
  2. count
  3. Both A and B
  4. Table
MOD () function is used in MS excel to get
  1. Dividend
  2. Remainder
  3. Quotient
  4. None of these

In MS Excel, which function automatically total a column or row of values?

  1. SUM
  2. ADD
  3. TOTAL
  4. None

Columns in MS Excel are called?

  1. Fields
  2. Chart
  3. Both
  4. None

Constant value in excel also called ?

  1. Number
  2. words
  3. mark
  4. None
Ctrl +D in MS Excel
  1. Fill down in the selection
  2. Open the font dialog box
  3. none
  4. All

Ctrl+R is used in excel to

  1. Fill the selection with active cells to the right
  2. Right align the content of cell
  3. Remove the cell contents of selected cells
  4. none

Which one is not a Function in MS Excel?

  1. SUMB
  2. AVG
  3. MAXD
  4. MIN

How many characters can be typed in a single cell in Excel ?

  1. 256
  2. 1024
  3. 32767
  4. 65535

In Excel which key is used for format number in currency format?

  1. Ctrl+Shift+1
  2. Ctrl+Shift+4
  3. Ctrl+1
  4. Shift+1

Which key is used to edit the selected cell in excel?

  1. F2
  2. F10
  3. F4
  4. F8

The formula of MS Excel begins with?

  1. +
  2. =
  3. [

Formula in Excell starts with

  1. +
  2. =
  3. [

Which of the following function rotate the contents of columns to rows and rows to columns in Microsoft Excel?

  1. switching
  2. transpose
  3. matrix
  4. none

___ view displays all the slides in your presentation in horizontally sequenced, thumbnails

  1. slide show view
  2. slide sorter view
  3. outline view
  4. none

__ area in an excel window allows entering values and formulas

  1. Menu Bar
  2. Title Bar
  3. Formula Bar
  4. None

Which key is used for Excel to select the whole column highlight?

  1. Shift + space
  2. CTRL + space
  3. Alt + space
  4. None of these
Which function calculates the largest value in a set of numbers in Excel?
  1. Average
  2. Count
  3. Minimum
  4. Maximum

Microsoft Excel 2019 files have a default extension of ___?

  1. .Xlsx
  2. .Xls
  3. .excel
  4. .123

In MS Excel ______ shortcut key is used for hiding rows.

  1. Ctrl+H
  2. Ctrl+7
  3. Ctrl+9
  4. None of the above

Which Shortcut keys are used to strikethrough highlighted selections in MS Excel?

  1. Ctrl+4
  2. Ctrl+5
  3. Ctrl+6
  4. None of these

The main window in a computer spreadsheet is called?

  1. workbook
  2. work
  3. account book
  4. worksheet

In a computer spreadsheet, a function that is used to count a number of entries in a given range is called?

  1. length
  2. counter
  3. counting
  4. count

The basic unit of a computer worksheet in which you enter text and numbers is known as _____?

  1. workbook
  2. cell
  3. row
  4. column

Computer spreadsheet cell that is highlighted with a heavy border is a ______?

  1. Active cell
  2. Cell containing a formula
  3. Locked cell
  4. Cell
In a computer spreadsheet, which is true if the current or active cell is B4 and you pressed Enter key ?
  1. you will be in the cell A1
  2. you will be in the cell B5
  3. you will be in the cell B3
  4. you will be in the cell B6

A Workbook is group of _____?

  1. Rows
  2. Columns
  3. Worksheets
  4. None of these

Each workbook may contain _____ worksheets.

  1. Numerous
  2. Five
  3. Three
  4. Four

A workbook initially contains ____worksheets, which are saved in a single file.

  1. Four
  2. Five
  3. Three
  4. One
  5. Two

Which feature allows you to combine multiple cells into a single cell in a table?

  1. Merge Cells
  2. Adjust Cell Size
  3. Split Cells
  4. Align Text

Which of the following is an example of spreadsheet application service?

  1. Microsoft Excel
  2. Microsoft Word
  3. Microsoft PowerPoint
  4. None of these

The software which contains rows and columns is called in MS Excel is called?

  1. Database
  2. Spreadsheet
  3. Word processing
  4. None of these
In MS-Excel, for arranging data in ascending or descending order the command used is?
  1. Filter in review tab
  2. Filter in data tab
  3. Sort in data tab
  4. Sort in review tab
  5. None of these

Which keyboard shortcut is used to add comments in MS Office Excel Worksheet?

  1. Alt + F2
  2. Ctrl + F12
  3. Shift + F5
  4. None of these
In MS-Excel ‘cells’ can be uniquely identified by:
  1. Colum letters and row numbers
  2. Column numbers and row letters
  3. Numbers only
  4. Rows only

Which ______ symbol is used for division in excel

  1. /
  2. *
  3. +
  4. .

Normally, a spreadsheet contains?

  1. Documents
  2. rows
  3. rows and columns
  4. None of these

In Microsoft Word the Superscript, subscript, outline, emboss, and engrave are known as _____?

  1. Font effects
  2. Text effects
  3. Font styles
  4. Word art

Which key uniquely identifies each record in a table

  1. Foreign key
  2. Composite key
  3. Alternate key
  4. Primary key

In a database table, the category of information is called ____

  1. Tuple
  2. Field
  3. Record
  4. All of above

Which of the Field has a Width of 8 Bytes?

  1. Memo
  2. Number
  3. Date/time
  4. Hyperlink

Which of following types of table constraints will prevent the entry of duplicate rows:

  1. Primary key
  2. Unique
  3. Null
  4. Foreign key

In excel from which tab you can write date of birth like this YYYY/MM/DD.

  1. Input
  2. Format menu
  3. insert
  4. None of these

Which of following is not a nomenclature of MS Excel ?

  1. Range
  2. Work book
  3. Document
  4. Cell

What is a box with dotted border that holds a place for content on a slide called?

  1. A layout
  2. A placeholder
  3. A bounding box
  4. A subtitle

Which of the following is not a valid data type in Excel?

  1. Date/Time
  2. Label
  3. Character
  4. Number

Which symbol is used to execute formulas in MS Excel

  1. :
  2. =
  3. #
  4. ~

An excel workbook is a collection of ___?

  1. Worksheets and Charts
  2. Charts
  3. Worksheets
  4. Workbooks

Microprocessors was introduced in which generation of computer___?

  1. Second Generation
  2. Fourth Generation
  3. Third Generation
  4. Both (A) and (B)
In MS Excel, to insert a sum formula in a cell
  1. =sum(A1:A2)
  2. =Add(a1:a2)
  3. =sum(1A:2A)
  4. =Add(1A:2A)
What is the default row height of MS Excel?
  1. 20
  2. 13
  3. 14
  4. 15

Number of default worksheets in MS Excel?

  1. 2
  2. 3
  3. 4
  4. 5

MS Excel Formula starts with _______?

  1. .
  2. _
  3. =
  4. none

Which bar is used for the current cell and its constraint?

  1. Name box
  2. Row headings
  3. Formula bar
  4. None of these

What is the use of a horizontal Scroll Bar in MS Excel?

  1. to view the data from left to the right
  2. to view the data in Excel from up and down
  3. to view the data from right to the left
  4. None of these

Autosave default time in MS Excel is ___.

  1. 10 hours
  2. 10 minutes
  3. 10 second
  4. None of these

What is the purpose of Crtl=Shift+F6 in MS Excel?

  1. moves to the previous worksheet
  2. moves to the next worksheet
  3. forward to the previous worksheet
  4. none of these

How to edit chart in ppt presentation?

  1. Triple-click the chart object
  2. Click and drag the chart object
  3. Double-click the chart object
  4. Click the chart object

How to center elements in a slides of ppt?

  1. select all elements, format > Align
  2. format > Align
  3. elements, format > Align
  4. None of these

From where add images and tables in PPT?

  1. text tab
  2. insert tab
  3. chart tab
  4. none of these

We use ______ to write a formula in a cell.

  1. =
  2. +
  3. none

What is a group of cells called in Excel?

  1. Cell Range
  2. Workbook
  3. Margin
  4. None of these

Letters in Excel denote :

  1. Columns
  2. rows
  3. numbers
  4. reference

The line between two cells is :

  1. Margin
  2. Cell
  3. Tab
  4. None of these

Which of the following is not a valid option to insert a hyperlink in excel, which can link to?

  1. existing file or web page
  2. place in this document
  3. e-mail address
  4. link to home

The Function ________ in Excel is used to look up information in a table and extract the corresponding data.

  1. FETCH
  2. GET
  3. VLOOKUP
  4. LET
  5. DATA

What are the shortcut keys to paste special?

  1. ALT + H + V + F
  2. ALT + H + V + P
  3. ALT + H + V + O
  4. ALT + H + V + S

What is the shortcut keyboard to edit formulas in a cell?

  1. F2
  2. F4
  3. CTRL +1
  4. CRTL + F

Which tab of the ribbon should you go to for removing gridlines on a worksheet?

  1. Formulates
  2. View
  3. Review
  4. Developer

Which of the following features cannot be found in the data ribbon?

  1. What-If Analysis
  2. PivotTable
  3. Data Validation
  4. Text to Columns

Use a _________ list to sort or fill in a user-defined order.

  1. Auto Fill Options
  2. Fill Series
  3. Custom List
  4. none

What is the function of the F4 key in a Spreadsheet

  1. Change font
  2. Repeat the last action
  3. Choose open command
  4. Open bookmark

All these MS Excel MCQs taken from the past papers of PPSC, FPSC, SPSC, KPPSC, BPSC, AJKPSC, UPSC, NTS, CSS, OTS, PMS and other competitive exams.

Read More: Computer MCQs

Leave a Comment

× PPSC FPSC NTS WhatsApp Group