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 Command | Action in MS Excel Sheet |
---|---|
F1 | Opens the Help menu |
F2 | Edit the selected cell |
F4 | Repeat the last action |
F5 | Find a specific cell |
F7 | Spell checker for text |
F11 | Create a chart |
F12 | Save as Option |
Ctrl + D | Fill down the cell in selection |
Ctrl + H | Find and Replace |
Ctrl + K | Insert Hyperlinks |
Ctrl + P | Print the Excel Sheet |
Ctrl + S | Save the Sheet |
Ctrl + W | Close the open Workbook |
Ctrl + Y | Repeat the last done action |
Ctrl + Z | Undo the last done action |
Ctrl + 0 | Hide Selected Columns |
Ctrl + 9 | Hide Selected Rows |
Ctrl + Shift + ( | Unhide the rows |
Ctrl + Shift + ) | Unhide the Columns |
Alt + Shift + F1 | Insert new worksheet |
Shift + F3 | Open the formula box |
Shift + F5 | Open the search box |
Ctrl + F9 | Minimize current window |
Ctrl + F10 | Maximize the selected window |
Ctrl + F6 | Switch between open workbooks |
Ctrl + Tab | Move between open Excel® files |
Ctrl + Shift + ; | Enter the current time |
Ctrl + ; | Enter the current date |
Ctrl + Spacebar | Selects the entire column |
Shift + F2 | Edit a cell comment |
Alt + F4 | Exit from Excel |
Basic MS Excel MCQs
MS Excel stands for_______
- Micromax Excel
- Microsoft Excel
- Micromax Excess
- Management Excel
- All of these
A cell is defined as :
- The intersection of a column and a row
- An input box
- a rectangular marker
- All of the above
Which of the following is not valid zoom percentage in Excel:
- 500%
- 600%
- 700
- None of the above
In which software slide have?
- Word
- PowerPoint
- Excel
- None
What is used to split long text in excel within the cell?
- Wrap text
- Click next
- All
- None
Which of the following methods can not be used to edit the contents of a cell?
- Double clicking the cell
- Press the Alt key
- Pressing the F2 key
- Clicking the formula bar
Which of the following is not a word processor?
- Word Perfect
- Microsoft Excel
- Word Star
- Microsoft Word
To drag a selected range of data to another worksheet in the same workbook, use the?
- Shift key
- Alt key
- Tab key
- Ctrl key
When a range is selected, how can you activate the previous?
- Press Tab
- Press the Alt key
- Press Enter
- none
Tab scroll buttons are place on excel screen
- Towards the bottom left corner
- Towards the bottom right corner
- Towards the bottom top right corner
- None
MS Excel provides the default value for step in fill series dialogue box
- 1
- 2
- 3
- 5
Worksheet in excel by default ___
- 3
- 2
- 1
- 4
Long text can be broken down into many lines within a cell. You can do this through
- Justify in Edit > Cells
- Wrap Text in Format > Cells
- None
- All
To remove the content of selected cells you must issue ___ commands
- Clear All
- Clear Delete
- Clear Contents
- All
Edit> Delete Command
- Deletes selected cells
- Deletes Formats of cell
- Deletes the comment of cell
- All
Multiple calculations can be made in a single formula using
- Complex Formulas
- Standard Formulas
- Array Formula
- All
Worksheet in excel by default ___
- 3
- 2
- 1
- 4
What do you mean by a workspace ?
- Group of Workbooks
- Group of Rows
- Group of Worksheets
- None
To select an entire column in MS Excel, press?
- Ctrl +r
- Ctrl +s
- Ctrl +c
- none
Microsoft excel is a powerful______
- Spreadsheet package
- Word processing package
- DBMS package
- None
A numeric value can be treated as label value if ___ precedes it.
- =
- ( ‘ )
- #
- None
___the cell pointer indicates that you can fill series
- Doctor’s symbol (Big Plus)
- Small thin plus icon
- Mouse Pointer with anchor at the tip
- None
___ is the short key to select the entire column in Excel.
- Alt + space bar
- Shift + space bar
- Control + space bar
- None of the above
You can check the conditions against _____when applying conditional formatting
- Cell value
- Formula
- Both of above
- none
Which shortcut key is for auto sum ?
- Alt + =
- Ctrl + Shift
- Alt + F1
- Ctrl + =
which option is not avail.able in Paste special dialogue box ?
- Subtract
- Divide
- SQRT
- none
Which of the following EXCEL feature allows users to evaluate values and return a result?
- Formula
- Formating
- Filters
- None of these
Which of following series type is not valid for fill series dialogue box ?
- Time
- Autofill
- Growth
- All
Which of following is not the correct method of editing the cell content ?
- Press the Alt key
- Click the formula bar
- Press the F2 key
- none
Which of following is not a valid zoom percentage in Excel?
- 10
- 100
- 300
- 500
Which of following is an active cell in excel?
- Cell address
- Range
- Formula
- Current cell
Which menu can be used to split windows into two?
- Window > Split
- Review > Window
- View > Window > Split
- none
Which is not the function of “Edit clear command”?
- Delete cells
- Delete notes
- Delete contents
- None
How a cell can be edit on Excel sheet?
- Edit contents of cell directly in cell
- Edit by typing in formula bar
- Edit mode
- All above mentioned
Normally, A spread contains:
- documents
- rows
- rows and columns
- columns
Colour and pattern used to fill a closed shape is called?
- Shape
- WordArt
- Fill Style
- Fill Back
Data arrangements in cell is known as
- Sorting
- Delete
- Arrange
- None
Excel probably considers the cell entry November 1, 2024 to be a ___
- Label
- Value
- Formula
- Text string
A computer application program that displays data arranged in rows and columns is called?
- Spreadsheet
- Register
- Form
- Box
The .xls extension is used for ___ files
- Windows
- Excel
- Power Point
- Access
- Word
____You can use to create chart?
- Wizard
- Ms word
- Excel
- None
Statistical calculation of tables and graphs can be done using
- adobe photoshop
- excel
- notepad
- powerpoint
___ is not a valid data type in excel
- Number
- Label
- Character
- none
Which of the following is not an option in the spelling dialog box?
- Ignore
- Edit
- Change
- Ignore All
- None of these
Which of following you can paste selectively using paste special command:
- Formats
- Validation
- Formulas
- All of above
In_____ tab you will find auto sum button:
- formatting tab
- Formulas tab
- standard tab
- none
We can enter and edit the text efficiently using
- Spreadsheet
- PowerPoint
- Word Processing Program
- None
Which menu is selected for print?
- Special
- Tools
- File
- Edit
- All of these
In MS-Excel, when the formula bar is activated, we can see:
- Enter Button
- Cancel Button
- Edit Formula Button
- None of these
- All of these
In MS-Excel, the ZOOM option appears in:
- Formula Bar
- Status Bar
- Title Bar
- Scroll Bar
- None of these
In MS Excel, to clear all content, Formats and comments in selected cell, we use?
- Clean All
- Clear All
- Clean Content
- Clean Format
Which key is used to GO TO tab in Ms Excel?
- F1
- F3
- F6
- F5
- None of these
Which of the following is not the part of merge process?
- Data source
- merge source
- internet source
- None
in a computer spreadsheet block of numbers is called:
- workbook
- columns
- rows
- range
which of these keys are used in ms excel to copy formulas from the above cell?
- ctrl +
- ctrl +;
- ctrl +:
- ctrl +’
move to the next cell in the row in ms excel.
- Tab
- shift
- space
- none of these
move to the next cell in the sheet in ms excel.
- ctrl + page down
- shift + page down
- page down
- none of these
Microsoft office spreadsheet program is ?
- Microsoft word
- Microsoft excel
- Microsoft powerpoint
- none of these
The title bar in MS Excel displays the name of the?
- Worksheet
- workbook
- formula
- location
Which function in excel tells how many numeric entries are there?
- NUM
- COUNT
- SUM
- CHKNUM
In a computer spreadsheet, cell range A3 through G3 should be keyed is as?
- A3-G3
- A3:G3
- A3: G3
- A3 to G3
in a computer spreadsheet, SUM, AVERAGE, MIN and MAX are examples of?
- calculation
- formulas
- functions
- relative addressing
How columns are numbered in MS Excel ?
- numeric
- alphabetic
- roman
- None
The actual working area of the Computer’s Microsoft Excel is?
- workbook
- worksheet
- note sheet
- notebook
How are data organized in a spreadsheet ?
- Lines and spaces
- Layers and planes
- Rows and columns
- Height and width
What term describes explanatory text attached to a cell?
- Context
- Callout
- Comment
- Dialog
The column heading in the spreadsheet are identified by:
- Alphabets
- Numbers
- Symbels
- None of these
which of these keys are used in ms excel to copy values from the above cell?
- ctrl +
- ctrl F
- ctrl S
- ctrl D
which of the following is a correct cell address?
- AA
- 5C
- 38,7
- C5
In MS excel, a ___ identifies a range by the cells located at diagonally opposed corners.
- Range
- Range Address
- Cell
- None of these
In MS Excel window, on the bottom, right area of the spreadsheet there is/are:
- Horizontal scroll bar
- Zoom tool
- Page view commands
- All of these
which of the following is not a valid Zoom percentage in Excel?
- 100
- 200
- 500
- None
In Microsoft Excel, the file you create and edit is called?
- A form
- A ledger
- A Work Book
- A Table
In MS Excel; comments put in the cell are called—-
- Smart tip
- Vip tip
- Soft tip
- None
In MS Excel, Conditional Formatting is in ___ tab?
- Home
- View
- Page Layout
- Insert
A numeric value can be treated as label value if it is precedes with
- Apostrophe
- Exclamation
- Hash
- Ampersand
In chart wizard, term data series refers to
- A chart legend
- A collection of chart data markers
- A data label
- None
To return the reminder after the number is divided by a divisor in Excel we use the function ?
- ROUND ( )
- FACT ( )
- MOD ( )
- None
Which of the fol towing can you use to add times to the slides in a presentation?
- slide show menu
- rehearse timing button
- slide transition button
- all
What type of chart is good for single series of data ? Column Chart Line Chart
- Pie Chart
- Line Chart
- Column Chart
- None
What MS Excel 2016 feature can you use if you want to work with one record at a time?
- Autocomplete
- Auto filter
- Data Form
- Data validation
The arrangement of elements such as Title, Subtitle text, picture, tables etc.
- layout
- presentation
- design
- scheme
Which of following is not a valid data type in MS Excel ?
- Number
- character
- label
- Date/Time
A feature that displays only the data in column (s) according to specified criteria
- Filtering
- Sorting
- Formula
- None
What type of chart will you use to compare performance of sales of two products ?
- Pie Chart
- Line Chart
- Column Chart
- None
Which feature is used to make selected sentence to All Captital Letters or All Small Letters ?
- Change case
- Change letter
- Change sentence
- Change word
Which of these key are used to apply outline border to the selected cell in MS Excel?
- CTRL+SHIFT+ %
- CTRL+SHIFT+ &
- CTRL+SHIFT+ ~
- CTRL+SHIFT+ $
Another name for a pre programmed formula in excel is __
- Cell
- Graph
- Function
- Range
Which of following function is used to sum the values in a range that meet criteria that you specify
- SUM
- SUMIF
- SUMALL
- SUMANY
What type of chart is useful for comparing values over categories?
- Line Chart
- Column Chart
- Pie Chart
- None
The columns of a table correspond to:
- Table
- Record
- Field
- Cell
The total number of rows in a worksheet?
- Unlimited
- 65,535
- 1,048,576
- 1,068,576
When the CPU detects an interrupt, then it saves its?
- previous State
- Next State
- Current State
- Both A and B
Which feature is used to wrap extra-long text into multiple lines in MS Excel ?
- wrap text
- text wrap
- letter warp
- word wrap
What are the basic rectangular building blocks of a spreadsheet?
- cells
- zoom slider
- help button
- all
Which of the following is not a term pertaining to spreadsheets?
- cell
- character
- browser
- formula
in Microsoft Excel template is the combination of different ___?
- Colors
- Effects
- Fonts
- All of these
… is a standard Windows control that displays the percentage of completion of a particular process as a graphical bar?
- Progress Bar
- Address bar
- Menu bar
- None
In a spreadsheet, letters are used to represent _____
- Columns
- Rows
- Cells
- None
In Excel, which is used to perform what if analysis ?
- Goal seek
- Solver
- Scenario Manager
- All of above
Microsoft Excel functions arguments are always written in __ ?
- Rows
- Cells
- Columns
- Parentheses
the command used to apply look of one piece of text to other parts of text documents.
- Copy
- Past
- Format Painter
- None of these
___ displays the content of active cell?
- Row headings
- Name box
- Formula bar
- None
Which one cannot be used to enter data in a cell in MS Excel?
- Pressing tab key
- Pressing arrow key
- Pressing Esc key
- clicking the enter button to the formula bar
Which value remain unchanged in Ms Excel?
- constant
- variable
- function
- none
Which among following wildcard characters are recognized by excel ?
- +and –
- ; and ^
- * and ?
- <and >
To select a group of worksheet we press and hold ____ key and select the sheet we want to add :
- ctrl
- shift
- alt
- None
The freezing row and column in Excel is in which pane
- Freezing row
- Freezing column
- Freezing pane
- None
The _____ option is used to show a specific row or column on every printed page.
- print layout
- print title
- print view
- none
In Excel data series is ?
- A row or column of numbers that are plotted in a chart
- Spreed sheet
- Work sheet
- None
Which would you choose to move selected text from one place to another?
- copy and paste
- delete and paste
- move and paste
- cut and paste
MS Excel is based on :
- UNIX
- DOS
- WINDOWS
- OS/2
Which elements of a worksheet can be protected from accidental modification
- Scenarios
- Objects
- Contents
- All of the above
Getting data from a cell located in a different sheet is called
- Accessing
- Referencing
- Updating
- none
How do you display current date and time in MS Excel ?
- Date ()
- Today ()
- Year ()
- Now ()
- Time ()
In a computer spreadsheet rows are labeled:
- By letters
- By numbers
- By cell references
- By symbols
- None of these
User developed instruction for excel are called___?
- Procedured
- Macros
- Programs
- None
Which of following is not an element of computer spreadsheet interface ?
- Pencil work
- Active cell
- Menu bar
- None
The default style for new data keyed in a new workbook is____?
- Comma
- Normal
- Currency
- percent
Which command will you choose to convert a column of data into row?
- Paste Special > Transpose
- Cut and Paste
- Special
- none
Instructions are written in machine language as
- Binary Code
- English Code
- Link Code
- None of these
Which function will you use to enter current time in a woksheet cell ?
- =time()
- =nowtime()
- =now()
- =currentTime()
how many sheets are there in the Excel workbook by default?
- 2
- 3
- 4
- 5
Comments can be added to cells using ____
- Data > Comments
- Home > Comments
- Insert > Comment
- none
In a computer spreadsheet, each cell contains a?
- Label
- value
- formula
- *All of these*
in MS excel 2016, which of the following can be used to split windows into two?
- Format > Window
- View > Window> Spilt
- Window > Spilt
- View > Spilt
What is active cell in MS-Excel ______?
- Rectangular box
- Pointer
- Nearing point of view
- None of the above
You can use the formula palette to
- Enter assumptions data
- Create and edit formula containing functions
- Format cells containing numbers
- none
In MS Excel to add two cells (A1 and A2) togather you use the following formula
- = add(A1+A2)
- = A1+A2
- = together A1:A2
- None of these
Which function can be used to calculate the monthly mortgage payment :
- PMT
- PV
- MORT
- None of these
Which allow to access from one cell to another
- Address
- Formulas
- Values
- None of these
which key is used for help in MS excel——?
- F1
- F2
- F3
- NONE OF THESE
In Excel which shortcut key is used to go to the formula tab?
- Alt+M
- Ctrl+M
- Ctrl+C
- Ctrl+B
in excel which key is used for format numbers in comma format?
- ctrl+shift+1
- ctrl+shift+4
- crtl+1
- shift+1
Shortcut key to insert a new worksheet in Excel is _____.
- Shift + F8
- Shift + F9
- Shift + F10
- Shift + F11
The delete key of keyboard is assigned to which command in excel ?
- Edit > Clear > All
- Edit > Clear > Contents
- Edit > Delete
- none
What is the keyboard shortcut to insert a SUM formula in MS Excel?
- CRTL+ =
- ALT + =
- ALT + S
- CTRL + ALT+ =
Which key is used to enter the current date in Excel?
- Ctrl+:
- Ctrl+Shift:
- Ctrl+;
- None of these
Which is the shortcut key to display active cells in Excell?
- Shift+Backspace
- Crtl+Backspace
- Alt+Backspace
- none
Ms Excel is a
- Spreadsheet program
- Multimedia software
- Entertainment software
- None
Ms Excel displays the current cell address in the ____
- Name box
- Cell tip
- Both
- None
—–is used for arranging data in ascending/descending order in MS Excel
- Data, order
- Data, sort
- Data, all
- None of these
What term refers to a specific set of values saved with the workbook?
- Range
- Trend line
- Scenario
- What-if analysis
The horizontal and vertical lines on a spreadsheet are called:
- Grid-lines
- Block lines
- Sheets
- Cells
Which type of chart use in time changing project?
- Bar
- Histo
- line
- none of these
Which sign is used to create an absolute cell reference in MS Excel?
- @
- =
- $
- %
What will be the result of formula ‘=16/2^3’ in a cell in MS Excel?
- 512
- 124
- 2
- 124
In a new workbook in MS Excel, which one appears on the topmost of the screen?
- Status Bar
- Title Bar
- Vertical Scroll bar
- Horizontal scroll bar
In MS Excel ready-made templates are available under __ tab in new option.
- file
- Count
- Table
- none
Which function is not available in the consolidate dialogue box ?
- Average
- Max
- Pmt
- None
What is the main function of MS Excel?
- organized data
- loss data
- gain data
- none of these
Excel is a———program developed by Microsoft.
- spreadsheet
- document
- data management
- all of the above
MS-Excel uses the _____ function when creating a data table.
- Average
- count
- Both A and B
- Table
MOD () function is used in MS excel to get
- Dividend
- Remainder
- Quotient
- None of these
In MS Excel, which function automatically total a column or row of values?
- SUM
- ADD
- TOTAL
- None
Columns in MS Excel are called?
- Fields
- Chart
- Both
- None
Constant value in excel also called ?
- Number
- words
- mark
- None
Ctrl +D in MS Excel
- Fill down in the selection
- Open the font dialog box
- none
- All
Ctrl+R is used in excel to
- Fill the selection with active cells to the right
- Right align the content of cell
- Remove the cell contents of selected cells
- none
Which one is not a Function in MS Excel?
- SUMB
- AVG
- MAXD
- MIN
How many characters can be typed in a single cell in Excel ?
- 256
- 1024
- 32767
- 65535
In Excel which key is used for format number in currency format?
- Ctrl+Shift+1
- Ctrl+Shift+4
- Ctrl+1
- Shift+1
Which key is used to edit the selected cell in excel?
- F2
- F10
- F4
- F8
The formula of MS Excel begins with?
- +
- –
- =
- [
Formula in Excell starts with
- +
- –
- =
- [
Which of the following function rotate the contents of columns to rows and rows to columns in Microsoft Excel?
- switching
- transpose
- matrix
- none
___ view displays all the slides in your presentation in horizontally sequenced, thumbnails
- slide show view
- slide sorter view
- outline view
- none
__ area in an excel window allows entering values and formulas
- Menu Bar
- Title Bar
- Formula Bar
- None
Which key is used for Excel to select the whole column highlight?
- Shift + space
- CTRL + space
- Alt + space
- None of these
Which function calculates the largest value in a set of numbers in Excel?
- Average
- Count
- Minimum
- Maximum
Microsoft Excel 2019 files have a default extension of ___?
- .Xlsx
- .Xls
- .excel
- .123
In MS Excel ______ shortcut key is used for hiding rows.
- Ctrl+H
- Ctrl+7
- Ctrl+9
- None of the above
Which Shortcut keys are used to strikethrough highlighted selections in MS Excel?
- Ctrl+4
- Ctrl+5
- Ctrl+6
- None of these
The main window in a computer spreadsheet is called?
- workbook
- work
- account book
- worksheet
In a computer spreadsheet, a function that is used to count a number of entries in a given range is called?
- length
- counter
- counting
- count
The basic unit of a computer worksheet in which you enter text and numbers is known as _____?
- workbook
- cell
- row
- column
Computer spreadsheet cell that is highlighted with a heavy border is a ______?
- Active cell
- Cell containing a formula
- Locked cell
- Cell
In a computer spreadsheet, which is true if the current or active cell is B4 and you pressed Enter key ?
- you will be in the cell A1
- you will be in the cell B5
- you will be in the cell B3
- you will be in the cell B6
A Workbook is group of _____?
- Rows
- Columns
- Worksheets
- None of these
Each workbook may contain _____ worksheets.
- Numerous
- Five
- Three
- Four
A workbook initially contains ____worksheets, which are saved in a single file.
- Four
- Five
- Three
- One
- Two
Which feature allows you to combine multiple cells into a single cell in a table?
- Merge Cells
- Adjust Cell Size
- Split Cells
- Align Text
Which of the following is an example of spreadsheet application service?
- Microsoft Excel
- Microsoft Word
- Microsoft PowerPoint
- None of these
The software which contains rows and columns is called in MS Excel is called?
- Database
- Spreadsheet
- Word processing
- None of these
In MS-Excel, for arranging data in ascending or descending order the command used is?
- Filter in review tab
- Filter in data tab
- Sort in data tab
- Sort in review tab
- None of these
Which keyboard shortcut is used to add comments in MS Office Excel Worksheet?
- Alt + F2
- Ctrl + F12
- Shift + F5
- None of these
In MS-Excel ‘cells’ can be uniquely identified by:
- Colum letters and row numbers
- Column numbers and row letters
- Numbers only
- Rows only
Which ______ symbol is used for division in excel
- /
- *
- +
- .
Normally, a spreadsheet contains?
- Documents
- rows
- rows and columns
- None of these
In Microsoft Word the Superscript, subscript, outline, emboss, and engrave are known as _____?
- Font effects
- Text effects
- Font styles
- Word art
Which key uniquely identifies each record in a table
- Foreign key
- Composite key
- Alternate key
- Primary key
In a database table, the category of information is called ____
- Tuple
- Field
- Record
- All of above
Which of the Field has a Width of 8 Bytes?
- Memo
- Number
- Date/time
- Hyperlink
Which of following types of table constraints will prevent the entry of duplicate rows:
- Primary key
- Unique
- Null
- Foreign key
In excel from which tab you can write date of birth like this YYYY/MM/DD.
- Input
- Format menu
- insert
- None of these
Which of following is not a nomenclature of MS Excel ?
- Range
- Work book
- Document
- Cell
What is a box with dotted border that holds a place for content on a slide called?
- A layout
- A placeholder
- A bounding box
- A subtitle
Which of the following is not a valid data type in Excel?
- Date/Time
- Label
- Character
- Number
Which symbol is used to execute formulas in MS Excel
- :
- =
- #
- ~
An excel workbook is a collection of ___?
- Worksheets and Charts
- Charts
- Worksheets
- Workbooks
Microprocessors was introduced in which generation of computer___?
- Second Generation
- Fourth Generation
- Third Generation
- Both (A) and (B)
In MS Excel, to insert a sum formula in a cell
- =sum(A1:A2)
- =Add(a1:a2)
- =sum(1A:2A)
- =Add(1A:2A)
What is the default row height of MS Excel?
- 20
- 13
- 14
- 15
Number of default worksheets in MS Excel?
- 2
- 3
- 4
- 5
MS Excel Formula starts with _______?
- .
- _
- =
- none
Which bar is used for the current cell and its constraint?
- Name box
- Row headings
- Formula bar
- None of these
What is the use of a horizontal Scroll Bar in MS Excel?
- to view the data from left to the right
- to view the data in Excel from up and down
- to view the data from right to the left
- None of these
Autosave default time in MS Excel is ___.
- 10 hours
- 10 minutes
- 10 second
- None of these
What is the purpose of Crtl=Shift+F6 in MS Excel?
- moves to the previous worksheet
- moves to the next worksheet
- forward to the previous worksheet
- none of these
How to edit chart in ppt presentation?
- Triple-click the chart object
- Click and drag the chart object
- Double-click the chart object
- Click the chart object
How to center elements in a slides of ppt?
- select all elements, format > Align
- format > Align
- elements, format > Align
- None of these
From where add images and tables in PPT?
- text tab
- insert tab
- chart tab
- none of these
We use ______ to write a formula in a cell.
- =
- –
- +
- none
What is a group of cells called in Excel?
- Cell Range
- Workbook
- Margin
- None of these
Letters in Excel denote :
- Columns
- rows
- numbers
- reference
The line between two cells is :
- Margin
- Cell
- Tab
- None of these
Which of the following is not a valid option to insert a hyperlink in excel, which can link to?
- existing file or web page
- place in this document
- e-mail address
- link to home
The Function ________ in Excel is used to look up information in a table and extract the corresponding data.
- FETCH
- GET
- VLOOKUP
- LET
- DATA
What are the shortcut keys to paste special?
- ALT + H + V + F
- ALT + H + V + P
- ALT + H + V + O
- ALT + H + V + S
What is the shortcut keyboard to edit formulas in a cell?
- F2
- F4
- CTRL +1
- CRTL + F
Which tab of the ribbon should you go to for removing gridlines on a worksheet?
- Formulates
- View
- Review
- Developer
Which of the following features cannot be found in the data ribbon?
- What-If Analysis
- PivotTable
- Data Validation
- Text to Columns
Use a _________ list to sort or fill in a user-defined order.
- Auto Fill Options
- Fill Series
- Custom List
- none
What is the function of the F4 key in a Spreadsheet
- Change font
- Repeat the last action
- Choose open command
- 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