Excel is a ....? Mcqs

Latest MCQs

Excel is a ....?

(A) Graphic program
(B) Word Processor

(C) A spreedsheet Program
(D) Deisgining Template

Comments
Latest MCQs

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

(A) Ctrl+:
(B) Ctrl+Shift:

(C) Ctrl+;
(D) None of these

Comments
Latest MCQs

MS excel is used to data...?

(A) Organize
(B) Share

(C) Communicate
(D) Obtain

Comments
Latest MCQs

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

(A) Press the Alt key
(B) Click the formula bar

(C) Press the F2 key
(D) none

Comments
Latest MCQs

When you open a new workbook in MS Excel, which of the following appears on the topmost portion of the screen...?

(A) Title bar
(B) Status bar

(C) Horizontal scroll bar
(D) Vertical scroll bar

Comments
Latest MCQs

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

(A) Pressing tab key
(B) Pressing arrow key

(C) Pressing Esc key
(D) clicking the enter button to the formula bar

Comments
Latest MCQs

In Excel, to calculate the product of numbers, the function used is _____...?

(A) =MULTIPLY()
(B) =PRODUCTSUM()

(C) =PRODUCE()
(D) =PRODUCT()

Comments
Latest MCQs

In MS Excel, Conditional Formatting is in ______ tab...?

(A) Home
(B) View

(C) Page Layout
(D) Insert

Comments
Latest MCQs

Microsoft Excel always written in: functions arguments are...?

(A) Cells
(B) Rows

(C) Columns
(D) Parentheses

Comments
Latest MCQs

What is the symbol for the "not equal to" operator in Excel...?

(A) !=
(B) ~=

(C) <>
(D) None of these

Comments
Latest MCQs

Which shortcut key is used to insert current date and time in MS Excel...?

(A) Ctrl + Shift + ;
(B) Ctrl + Shift + :

(C) Ctrl + ;
(D) Ctrl + !

Comments
Latest MCQs

Tab scroll buttons are place on excel screen...?

(A) Towards the bottom left corner
(B) Towards the bottom right corner

(C) Towards the bottom top right corner
(D) None

Comments
Latest MCQs

Columns in MS Excel are called...?

(A) Fields
(B) Chart

(C) Both
(D) None of these

Comments
Latest MCQs

If you press ___, the cell accepts your typing as its contents ...?

(A) Tab
(B) Ctrl+Enter

(C) Enter
(D) Alt+Enter

Comments
Latest MCQs

Which of the following is correct syntax in Excel...?

(A) =IF(LogicalTest, TrueResult, FalseResult)
(B) =IF(LogicalTest, (TrueResult, FalseResult)

(C) =IF(LogicalTest, TrueResult) (LogicalTest, FalseResult)
(D) =IF(LogicalTest, TrueResult), IF(LogicalTest, FalseResult)

Comments
Latest MCQs

MOD () function is used in MS excel to get...?

(A) Dividend
(B) Remainder

(C) Quotient
(D) None of these

Comments
Latest MCQs

Cells in MS Excel can be uniquely identified by:...?

(A) Column letters and row numbers
(B) Column numbers and row letters

(C) Cell coordinates
(D) None of these

Comments
Latest MCQs

In MS-Excel 'cells' can be uniquely identified by:...?

(A) Colum letters and row numbers
(B) Column numbers and row letters

(C) Numbers only
(D) Rows only

Comments
Latest MCQs

Title bar in MS-Excel displays name of the __________ ...?

(A) Worksheet
(B) Workbook

(C) Formula
(D) Location

Comments
Latest MCQs

In MS-Excel ______ operation is used to arrange the data in ascending/descending order:...?

(A) Chart
(B) Sort

(C) Table
(D) Filter

Comments
Latest MCQs

What is the function of the IF function in Excel...?

(A) To perform a logical test and return a value based on the result
(B) To add up a range of cells

(C) To find the average of a range of cells
(D) To count the number of cells in a range

Comments
Latest MCQs

Which of the following functions is used to calculate the average of a range of cells in Excel...?

(A) AVERAGE
(B) SUM

(C) COUNT
(D) None of these

Comments
Latest MCQs

What is the result of the Excel formula (7-3)×(4+3)/4...?

(A) 6
(B) 7

(C) 8
(D) 5

Comments
Latest MCQs

In MS excel, a _____________ identifies a range by the cells located at diagonally opposed corners....?

(A) Range
(B) Range Address

(C) Cell
(D) None of these

Comments
Latest MCQs

Which one is not a function in MS Excel:...?

(A) SUM
(B) AVG

(C) MAX
(D) MIN

Comments
Latest MCQs

Excel is a program that is used to prepare a ______...?

(A) Spreadsheet
(B) Database

(C) Workbook
(D) None of these

Comments
Latest MCQs

Which of the following Excel feature allows users to evaluate values and return a result?...?

(A) Formulas
(B) Formatting

(C) Filters
(D) Insertions

Comments
Latest MCQs

Which among the following wildcard characters are recognized by MS excel...?

(A) + and –
(B) !and ^

(C) *and
(D) < and >

Comments
Latest MCQs

Which function calculates the largest value in a set of numbers in Excel...?

(A) Average
(B) Count

(C) Minimum
(D) Maximum

Comments
Latest MCQs

Which shortcut key switch to next worksheet tab in MS Excel...?

(A) Ctrl + Page up
(B) Ctrl + Home

(C) Ctrl + Page down
(D) Ctrl + End

Comments
Latest MCQs

In Excel Spacing in the column is called...?

(A) Paper Size
(B) Page Layout

(C) Column width
(D) None of these

Comments
Latest MCQs

In MS Excel you can use a function to combine text from two cells into one cell. But you can use an operator to do the same thing. Which operator is that...?

(A) Name
(B) Space

(C) Ampersand
(D) None of these

Comments
Latest MCQs

What does the term "filter" refer to in Excel...?

(A) To permanently delete rows or columns
(B) To format the appearance of cells

(C) To temporarily hide certain data based on specific criteria
(D) To create a chart

Comments
Latest MCQs

in Microsoft Excel template is the combination of different ______...?

(A) Colors
(B) Effects

(C) Fonts
(D) All of these

Comments
Latest MCQs

In Excel, Conditional formatting is in: ______________...?

(A) Insert Tab
(B) Page layout

(C) View Tab
(D) Home Tab

Comments
Latest MCQs

In MS Excel, You can copy data or formulas _____...?

(A) With buttons on the standard toolbars
(B) With commands on the shortcut menu

(C) With the copy, paste and cut commands on the edit menu
(D) All of the above

Comments
Latest MCQs

In MS Excel the command used to combine /merge the consecutively selected cells andcenter aligned is:...?

(A) Combine & Center
(B) Merge & Center

(C) Merge Cells
(D) Combine

Comments
Latest MCQs

MS Excel is a ______...?

(A) Spreadsheet program
(B) Multimedia software

(C) Entertainment software
(D) None of these

Comments
Latest MCQs

In MS Excel 2016, which of the following can be used to split windows into tv by which of the following options:...?

(A) Format >Window>Split
(B) View >Window>Split

(C) View >Window>Split
(D) Page Layout>Split

Comments
Latest MCQs

Which of the following is associated with Excel program...?

(A) Graphic program
(B) Word Processor

(C) Presentation
(D) Spreadsheet

Comments
Latest MCQs

In MS Word and Excel, to combine two or more cells into one is called...?

(A) Joining
(B) Merging

(C) Split
(D) None of these

Comments
Latest MCQs

Which is the utility of Excel to fill the columns/rows with a series of data...?

(A) Auto sum
(B) Auto filter

(C) Auto fill
(D) Auto calculate

Comments
Latest MCQs

In MS Excel 2016, a window can be split into two parts by which of the following options...?

(A) Format Window
(B) Developer Window > Split

(C) Page Layout > Split
(D) View > Window > Split

Comments
Latest MCQs

An excel workbook is a collection of:...?

(A) Worksheets
(B) Charts

(C) Both A & B
(D) None of these

Comments
Latest MCQs

#Value! Error in Microsoft Excel represents:...?

(A) The width of the cell is less to display the answer
(B) Parameter provided to the function is of wrong data type

(C) Value of the answer needs to be round off
(D) When Excel does not recognize the format

Comments
Latest MCQs

Selected cell of excel...?

(A) Active Cell
(B) Cell No

(C) Formula cell
(D) None Of These

Comments
Latest MCQs

In Excel, what is the function of the F11 key...?

(A) Save the workbook
(B) Toggle full-screen mode on/off

(C) Insert a new worksheet
(D) Open the print preview

Comments
Latest MCQs

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

(A) TOTAL
(B) ADD

(C) SUM
(D) AVG

Comments
Latest MCQs

Microsoft excel is a powerful______...?

(A) Spreadsheet package
(B) Word processing package

(C) DBMS package
(D) None

Comments
Latest MCQs

If you press ___, the cell accepts your typing as its contents...?

(A) Enter
(B) Ctrl+Enter

(C) Tab
(D) None

Comments
Latest MCQs

User developed instruction for excel are called__________...?

(A) Progrms
(B) Macros

(C) Procedured
(D) All of these

Comments
Latest MCQs

_______ displays the content of active cell...?

(A) Row headings
(B) Name box

(C) Formula bar
(D) None of these

Comments
Latest MCQs

In MS Excel ready-made templates are available under the ____ tab...?

(A) File
(B) Insert

(C) Design
(D) None of the above

Comments
Latest MCQs

Which allow to access from one cell to another...?

(A) Address
(B) Formulas

(C) Values
(D) None of these

Comments
Latest MCQs

In MS-Excel, the ZOOM option appears in:...?

(A) Formula Bar
(B) Status Bar

(C) Title Bar
(D) Scroll Bar

Comments
Latest MCQs

You can set border in Excel from ___...?

(A) From Line Style tool in Drawing toolbar
(B) You can not set page border in Excel

(C) From Border tool in Formatting toolbar
(D) none

Comments
Latest MCQs

Which shortcut key is used to create chart in MS Excel...?

(A) F10
(B) F12

(C) F11
(D) None

Comments
Latest MCQs

Slide show options available to the presenter include all of the following except...?

(A) Transitions command
(B) Speaker notes command

(C) Meeting minder command
(D) Navigation commands

Comments
Latest MCQs

Move to Next Sheet in Ms Excel:...?

(A) Ctrl + Page Down
(B) Shift + Page Down

(C) Page Down
(D) None of these

Comments
Latest MCQs

Which key is used to GO TO tab in Ms Excel...?

(A) F1
(B) F3

(C) F6
(D) F5

Comments
Latest MCQs

Which formula is used to find the number of numerical cells in a range of cells in Excel...?

(A) COUNTIF
(B) COUNT

(C) COUNTA
(D) None of these

Comments
Latest MCQs

Which of following is not true about find and replace in excel...?

(A) You can search in formula too
(B) You can search for bold and replace

(C) You can search in formula too
(D) None

Comments
Latest MCQs

The handout Master consists of placeholders for all these except the _________...?

(A) Title
(B) slide number

(C) header
(D) footer

Comments
Latest MCQs

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

(A) 256
(B) 1024

(C) 32767
(D) 65535

Comments
Latest MCQs

Which of these keys are used in Ms Excel to copy value from above cell...?

(A) Ctrl + “
(B) Ctrl+ E

(C) Ctrl+ E
(D) Ctrl+ D

Comments
Latest MCQs

In MS Excel, columns are labelled as ______...?

(A) A, B, C
(B) A1, A2, A3

(C) 1, 2, 3
(D) $A$1, $B$2

Comments
Latest MCQs

The _________ indents all the lines of a paragraph except first line in Ms Word....?

(A) First Line Indent Marker
(B) Hanging Indent Marker

(C) Left Indent Marker
(D) Right Indent Marker

Comments
Latest MCQs

In MS Excel, if a numeric value starts with _______ then this value can be treated label...?

(A) Hash
(B) Equal Sign

(C) Apostrophe
(D) Tides

Comments
Latest MCQs

The valid data type in MS Excel is _____...?

(A) Boolean
(B) Tupal

(C) Dictionary
(D) None of these

Comments
Latest MCQs

In MS Excel, " ____ " is not an example of a value....?

(A) Obtained marks - 87
(B) July 16, 1982

(C) 57845
(D) None of these

Comments
Latest MCQs

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

(A) Date()
(B) Year()

(C) Now()
(D) Time()

Comments
Latest MCQs

Microsoft Excel 2019 files have a default extension of ________...?

(A) .Xlsx
(B) .Xls

(C) .excel
(D) .123

Comments
Latest MCQs

The _________ indents all the lines of a paragraph except first line in Ms Word....?

(A) First Line Indent Marker
(B) Hanging Indent Marker

(C) Left Indent Marker
(D) Right Indent Marker

Comments
Latest MCQs

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

(A) Click the formula bar
(B) Press the F2 key

(C) Press the Alt key
(D) None

Comments
Latest MCQs

Cell entry "July 16, 2016" will be considered a _____ by Excel sheet....?

(A) Label
(B) Value

(C) Formula
(D) Text string

Comments
Latest MCQs

What MS Excel 2016 feature can you use if you want to work with one record at a time...?

(A) Autocomplete
(B) Auto filter

(C) Data Form
(D) Data validation

Comments
Latest MCQs

Formula in Excell starts with...?

(A) +
(B) -

(C) =
(D) [

Comments
Latest MCQs

________________________ is not a valid data type in excel...?

(A) Number
(B) Label

(C) Character
(D) none

Comments
Latest MCQs

in MS Excel what is function inside another function is called...?

(A) nested
(B) round

(C) switch
(D) none of these

Comments
Latest MCQs

In MS Excel formula and function start with ____...?

(A) +
(B) -

(C) =
(D) [

Comments
Latest MCQs

Which Excel function is used to add the current system date...?

(A) DATE()
(B) NOW()

(C) TODAY()
(D) CURRENT_DATE()

Comments
Latest MCQs

Which value remains unchanged in MS Excel...?

(A) Constant
(B) Function

(C) Variable
(D) None of these

Comments
Latest MCQs

To insert chart in MS Excel, which shortcut key used...?

(A) Alt+F1
(B) F2

(C) F3
(D) F4

Comments
Latest MCQs

Except for the ______ function, a formula with a logical function shows the word “True” or “False” as a result....?

(A) AND
(B) IF

(C) OR
(D) None of these

Comments
Latest MCQs

A worksheet in Excel is divided into _____...?

(A) Height & Width
(B) Layers & Planes

(C) Columns & Rows
(D) Lines & Spaces

Comments
Latest MCQs

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

(A) FETCH
(B) GET

(C) VLOOKUP
(D) LET

Comments
Latest MCQs

Which value remain unchanged in Ms Excel...?

(A) constant
(B) variable

(C) function
(D) none

Comments
Latest MCQs

# value which type of error record in excel...?

(A) [\"numeric error\",\"syntax error\",\"excel does not recognize the formula\",\"None\"]
(B) empty

(C) empty
(D) empty

Comments
Latest MCQs

We can set Page Border in Excel from:...?

(A) From Border tab in Format Cells dialog box
(B) From Border tool in Formatting toolbar

(C) From Line Style tool in Drawing toolbar
(D) we cannot set page border in Excel

Comments
Latest MCQs

What is the default file format for Excel spreadsheets...?

(A) .xlsx
(B) .doc

(C) .ppt
(D) .pdf

Comments
Latest MCQs

Which of the following is not a nomenclature of MS Excel...?

(A) Range
(B) Workbook

(C) Document
(D) cell

Comments
Latest MCQs

MS Excel stands for_______...?

(A) Micromax Excel
(B) Microsoft Excel

(C) Micromax Excess
(D) Management Excel

Comments
Latest MCQs

move to the next cell in the sheet in ms excel....?

(A) ctrl + page down
(B) shift + page down

(C) page down
(D) none of these

Comments
Latest MCQs

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

(A) Ctrl+H
(B) Ctrl+7

(C) Ctrl+9
(D) None of the above

Comments
Latest MCQs

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

(A) Number
(B) Character

(C) Babel
(D) Date/Time

Comments
Latest MCQs

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

(A) Input
(B) Format menu

(C) insert
(D) None of these

Comments
Latest MCQs

Which shortcut key is used to calculate the range of cells in MS Excel...?

(A) Alt +
(B) Ctrl ++

(C) Shift ++
(D) None of these

Comments
Latest MCQs

What is the result of the Excel formula [7-3]×[4+3]/4...?

(A) 1
(B) 4

(C) 7
(D) 9

Comments
Latest MCQs

Which of the following you can paste selectively using Paste Specail command in MS Excel...?

(A) Validation
(B) Formats

(C) Formulas
(D) All of these

Comments
Latest MCQs

which key is used to minimize excel worksheet...?

(A) CTRL+F5
(B) CTRL+F11

(C) Windows Key + Down Arrow
(D) None of these

Comments
Latest MCQs

which Excel tool allows you to set specific conditions for data entry ensuring accuracy and consistency in your analysis...?

(A) goal seek
(B) data validation

(C) scenario manager
(D) pivot table

Comments
Latest MCQs

How do you tell from one cell to another...?

(A) Address
(B) Formulas

(C) Values
(D) All of these

Comments
Latest MCQs

In MS Excel, if we want to add a mathematical symbol which can be typed through keyboard, which option will be used...?

(A) Insert => Special Character
(B) Insert => Symbol

(C) View => Special Character
(D) View => Symbol

Comments
Latest MCQs

In MS Excel; comments put in the cell are called...?

(A) Smart tip
(B) Vip tip

(C) Soft tip
(D) Cell tips

Comments
Latest MCQs

Number of default worksheets in MS Excel...?

(A) 2
(B) 3

(C) 4
(D) 5

Comments
Latest MCQs

Autosave default time in MS Excel is ________....?

(A) 10 hours
(B) 10 minutes

(C) 10 second
(D) None of these

Comments
Latest MCQs

Which of the following way cannot be used to link excel worksheet data to a Word document...?

(A) With the right drag method
(B) With a hyperlink

(C) With the copy and paste special commands
(D) With the copy and paste buttons on the standard toolbar

Comments
Latest MCQs

In MSS Excel 2016 Print Title option is available in ___ menu...?

(A) Review
(B) View

(C) Insert
(D) Page layout

Comments
Latest MCQs

Constant value in excel also called ...?

(A) Number
(B) words

(C) mark
(D) None

Comments
Latest MCQs

In MS Excel, to view a cell comment ______...?

(A) Click the edit comment command on the insert menu
(B) Position the mouse pointer over the cell

(C) Click the display comment command on the window menu
(D) None of these

Comments
Latest MCQs

_____ is used for arranging data in ascending/descending order in MS Excel....?

(A) Data, order
(B) Data, sort

(C) Data, all
(D) None of these

Comments
Latest MCQs

Go To command in Excel is located in...?

(A) Menu
(B) Find and select

(C) Search
(D) Help

Comments
Latest MCQs

Which of following is an active cell in excel...?

(A) Cell address
(B) Range

(C) Formula
(D) Current cell

Comments
Latest MCQs

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

(A) Merge Cells
(B) Adjust Cell Size

(C) Split Cells
(D) Align Text

Comments
Latest MCQs

Which of the following symbols is used to enter a formula in MS Excel:...?

(A) $
(B) +

(C) #
(D) =

Comments
Latest MCQs

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

(A) CRTL+ =
(B) ALT + =

(C) ALT + S
(D) CTRL + ALT+ =

Comments
Latest MCQs

In MS Excel, _____ function calculates the square root of a number....?

(A) SQR
(B) SQRT

(C) SQUARE
(D) None of these

Comments
Latest MCQs

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

(A) ctrl +
(B) ctrl F

(C) ctrl S
(D) ctrl D

Comments
Latest MCQs

How a cell can be edit on Excel sheet...?

(A) Edit contents of cell directly in cell
(B) Edit by typing in formula bar

(C) Edit mode
(D) All above mentioned

Comments
Latest MCQs

To fix values in an excel we use _____...?

(A) Thumbnails
(B) Thread

(C) Absolute reference
(D) None of these

Comments
Latest MCQs

Which formula will automatically capitalize the first letter of text in MS Excel...?

(A) Proper
(B) Upper case

(C) Capitalize
(D) None of these

Comments
Latest MCQs

To move between the worksheets in a workbook in MS Excel, we can use which of the following shortcut...?

(A) ALT+=
(B) Ctrl+Tab

(C) Ctrl+F
(D) Ctrl+Page up/Page Down

Comments
Latest MCQs

The cell referencing that does not change when copied is:...?

(A) Absolute
(B) Comparative

(C) Relative cell addressing
(D) Reference

Comments
Latest MCQs

Which of these will not select all the cells in a document?...?

(A) Using the Edit-Selection All menu
(B) Pressing Ctrl + A on the keyboard

(C) Clicking three times with the right mouse button in the spreadsheet
(D) None of these

Comments
Latest MCQs

What is the purpose of the VLOOUP function in Excel...?

(A) To create a chart
(B) To sort data

(C) To find a value in a table based on a matching value in the first column
(D) None

Comments
Latest MCQs

User-developed instructions for excel are called...?

(A) Program
(B) Macros

(C) Procedure
(D) All of these

Comments
Latest MCQs

In a computer spreadsheet, which is true if current or active cell is B4 and you pressed Enter key...?

(A) you will be in the cell A1
(B) you will be in the cell B5

(C) you will be in the cell B3
(D) you will be in the cell B6

Comments
Latest MCQs

The ______________ function in Excel returns the highest value in a set of data that you specify...?

(A) AVG
(B) MAX

(C) LRG
(D) None of these

Comments
Latest MCQs

The Maximum number of rows in MS-Excel is ______...?

(A) 1200000
(B) 1048576

(C) 1020239
(D) None of these

Comments
Latest MCQs

In Excel, The rows of a table correspond to _____...?

(A) Table
(B) Record

(C) Field
(D) Cell

Comments
Latest MCQs

How columns are numbered in MS Excel...?

(A) Numeric
(B) Alphabetic

(C) Roman
(D) None

Comments
Latest MCQs

In MS Excel function to return one value if a condition is true and another value if it's false:...?

(A) If function
(B) Sum function

(C) Decimal function
(D) Info function

Comments
Latest MCQs

In MS Excel, a formula that looks for a value in the leftmost column of a table and then returns a value in the same row for a specific column is called:...?

(A) Horizontal Lookup
(B) Vertical Lookup

(C) Average
(D) None of these

Comments
Latest MCQs

Which function in Excel tells how many numeric entries are there...?

(A) NUM
(B) COUNT

(C) SUM
(D) CHKNUM

Comments
Latest MCQs

Press the enter key in all of the following circumstances except...?

(A) to insert a blank line into a document
(B) when the insertion point reaches the right margin

(C) to begin a new paragraph
(D) in response to certain Word commands

Comments
Latest MCQs

In MS Excel, you can use the horizontal and vertical scroll bars to _____...?

(A) Split a worksheet into two panes
(B) Edit the contents of a cell

(C) View different rows and columns
(D) View different worksheets

Comments
Latest MCQs

How many sheets are there in the Excel workbook by default...?

(A) 2
(B) 3

(C) 4
(D) 5

Comments
Latest MCQs

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

(A) switching
(B) transpose

(C) matrix
(D) none

Comments
Latest MCQs

To select an entire column in MS Excel, press...?

(A) Ctrl +r
(B) Ctrl +s

(C) Ctrl +c
(D) none

Comments
Latest MCQs

In Excel charts vertical axis are called...?

(A) Slot
(B) Z-axis

(C) Y-axis
(D) X-axis

Comments
Latest MCQs

In MS Excel Ready-made templates are available under-tab...?

(A) File
(B) Insert

(C) Design
(D) None of these

Comments
Latest MCQs

In MS Excel to delete duplicate values which menu is used:...?

(A) Data
(B) Tools

(C) Formatting
(D) Layout

Comments
Latest MCQs

To edit in an embedded excel worksheet object in a word document...?

(A) Edit the hyperlink
(B) Use the excel menu bar and toolbars inside the word application

(C) Both
(D) None

Comments
Latest MCQs

You can edit existing Excel Data by pressing the key...?

(A) F1 key
(B) F2 key

(C) F3 key
(D) F4 key

Comments
Latest MCQs

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

(A) Average
(B) Count

(C) Both A and B
(D) Table

Comments
Latest MCQs

In MS Excel, you have a list of sales data in column A, and you need to find the second highest unique value in this list. Which of the following formulas will correctly return the second highest unique value...?

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

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

Comments
Latest MCQs

In MS Excel to add two cells (A1 and A2) togather you use the following formula...?

(A) = add(A1+A2)
(B) = A1+A2

(C) = together A1:A2
(D) None of these

Comments
Latest MCQs

A letterhead should contain all of the following EXCEPT __________....?

(A) full street address
(B) logo

(C) complete legal name of the company, group, or individual
(D) None of the above

Comments
Latest MCQs

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

(A) A ledger
(B) A table

(C) A workbook
(D) None of these

Comments
Latest MCQs

Maximum zoom percentage in Ms excel...?

(A) 300%
(B) 200%

(C) 400%
(D) 500%

Comments
Latest MCQs

Microsoft Excel functions arguments are always written in __ ...?

(A) Rows
(B) Cells

(C) Columns
(D) Parentheses

Comments
Latest MCQs

MS Excel displays the address of the active cell in the:...?

(A) Formula bar
(B) Status bar

(C) Tool bar
(D) Menu bar

Comments
Latest MCQs

In MS-Excel, for arranging data in ascending or descending order the command used is...?

(A) Filter in review tab
(B) Filter in data tab

(C) Sort in data tab
(D) Sort in review tab

Comments
Latest MCQs

Which key should be pressed continuously while moving a column in MS Excel...?

(A) Tab
(B) Ctrl

(C) Shift
(D) Alt

Comments
Latest MCQs

Which of the following functions in Microsoft Excel is used to count items in a cell range...?

(A) COUNT
(B) AVERAGE

(C) SUM
(D) MAX

Comments
Latest MCQs

An excel workbook is a collection of:...?

(A) Workbooks
(B) Worksheets

(C) Charts
(D) Worksheets and Charts

Comments
Latest MCQs

How many types of references are used in Excel...?

(A) 4
(B) 5

(C) 3
(D) 2

Comments
Latest MCQs

In MS Excel, by pressing Shift and Space keys at a time from the keyboard you can select...?

(A) Two adjacent columns
(B) Two adjacent rows

(C) One row of the worksheet
(D) None of these

Comments
Latest MCQs

_____ is not a valid data type in excel...?

(A) Number
(B) Label

(C) Character
(D) none

Comments
Latest MCQs

The first cell in excel worksheet is labeled as _________...?

(A) AA
(B) A1

(C) Aa
(D) None of these

Comments
Latest MCQs

Which symbol is used to execute formulas in MS Excel...?

(A) :
(B) =

(C) #
(D) ~

Comments
Latest MCQs

In MS-Excel two common wildcard characters that MS Excel recognizes are:...?

(A) * and?
(B) < and >

(C) ^ and /
(D) None of these

Comments
Latest MCQs

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

(A) Number
(B) Character

(C) Label
(D) Date

Comments
Latest MCQs

In MS Excel, we can not edit the contents of a cell by:...?

(A) Pressing the Alt key
(B) Clicking the formula bar

(C) Pressing the F2 key
(D) Double clicking the cell

Comments
Latest MCQs

When you insert a Excel file to a Word document The Data are:...?

(A) Embedded
(B) Linked

(C) Hyperlink placed in word table
(D) None of these

Comments
Latest MCQs

In MS Excel if a numeric value start with ____ then this value can be treated as a table ...........?

(A) Hash
(B) Equal Sign

(C) Apostrophe
(D) Tide

Comments
Latest MCQs

In MS Excel to delete duplicate values which menu is used...?

(A) Data
(B) Tools

(C) Formatting
(D) Layout

Comments
Latest MCQs

Another name for a pre programmed formula in excel is ___________...?

(A) Cell
(B) Graph

(C) Function
(D) Range

Comments
Latest MCQs

Letters in Excel denote: ______________...?

(A) Columns
(B) rows

(C) numbers
(D) reference

Comments
Latest MCQs

Which alignment choice spreads the data across the width of the cell...?

(A) Distributed
(B) Center

(C) Justify
(D) None of these

Comments
Latest MCQs

A formula in MS Excel starts with a________ symbol...?

(A) *
(B) +

(C) =
(D) $

Comments
Latest MCQs

What is the function of the SUM function in Excel:...?

(A) To add up a range of cells
(B) To find the average of a range of cells

(C) To count the number of cells in a range
(D) To find maximum value in a range of cells

Comments
Latest MCQs

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

(A) 10
(B) 100

(C) 300
(D) 500

Comments
Latest MCQs

To instruct Word to stop bulleting paragraphs, do any of the following except ___________....?

(A) press the enter key twice
(B) click the Undo button on the Standard toolbar

(C) press the backspace key to remove the bullet
(D) click the Bullets button on the Formatting toolbar

Comments
Latest MCQs

which key is used for help in MS excel------...?

(A) F1
(B) F2

(C) F3
(D) NONE OF THESE

Comments
Latest MCQs

In Ms Excel, which of the following special function keys allow the content in cell...?

(A) Shift
(B) Esc

(C) Tab
(D) Space

Comments
Latest MCQs

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

(A) to view the data from left to the right
(B) to view the data in Excel from up and down

(C) to view the data from right to the left
(D) None of these

Comments
Latest MCQs

Default file name in MS Excel is...?

(A) Document 1
(B) Workbook 1

(C) Book1
(D) Worksheet

Comments
Latest MCQs

Which command is used to add data in excel...?

(A) add
(B) count

(C) sum
(D) None of these

Comments
Latest MCQs

How is a selected cell indicated in MS Excel...?

(A) Dotted line
(B) Double line

(C) Wide bold line
(D) Single line

Comments
Latest MCQs

In a computer spreadsheet, which is true if the current or active cell is B4 and you pressed Enter key ...?

(A) you will be in the cell A1
(B) you will be in the cell B5

(C) you will be in the cell B3
(D) you will be in the cell B6

Comments
Latest MCQs

In MS Excel 2016, which of the following can be used to split windows into two...?

(A) Format > window
(B) View > window > split

(C) Window > split
(D) View > split

Comments
Latest MCQs

Which of these keys are used in Ms Excel to copy formula from above cell...?

(A) Ctrl+ ”
(B) Ctrl+ ;

(C) Ctrl+ :
(D) Ctrl+ ‘

Comments
Latest MCQs

Excel displays the current cells address in the __________...?

(A) Formula bar
(B) Status bar

(C) Name box
(D) Title bar

Comments
Latest MCQs

Which of these key are used in ms excel to insert current time In workbook....?

(A) Ctrl + Shift + ;
(B) Ctrl+!

(C) Ctrl+*
(D) None of these

Comments
Latest MCQs

What is a cell in Excel...?

(A) A row
(B) A column

(C) A unit of data
(D) A unit of formatting

Comments
Latest MCQs

Worksheet in excel by default ___...?

(A) 3
(B) 2

(C) 1
(D) 4

Comments
Latest MCQs

What are the number of columns in MS Excel 2007...?

(A) 16,284
(B) 16,384

(C) 16,584
(D) None of these

Comments
Latest MCQs

Letters in Excel denote :...?

(A) Columns
(B) rows

(C) numbers
(D) reference

Comments
Latest MCQs

To edit in an embedded excel worksheet object in a word document:...?

(A) Use the excel menu bar and toolbars inside the word application
(B) Edit the hyperlink

(C) Edit the data in a excel source application
(D) Use the word menu bar and toolbar

Comments
Latest MCQs

Comment put on Excel cell which is displayed by taking the Mouse Pointer there, is called__________...?

(A) Smart tip
(B) Soft Tip

(C) Web Tip
(D) Cell Tip

Comments
Latest MCQs

What is the default row height of MS Excel...?

(A) 20
(B) 13

(C) 14
(D) 15

Comments
Latest MCQs

In Excel data series is ...?

(A) A row or column of numbers that are plotted in a chart
(B) Spreed sheet

(C) Work sheet
(D) None

Comments
Latest MCQs

In MS Excel which bar is used for formula and data writing...?

(A) Formula bar
(B) Menu bar

(C) Title bar
(D) None of these

Comments
Latest MCQs

Maximum zoom percentage in Excel is _________...?

(A) 100%
(B) 300%

(C) 400%
(D) 500%

Comments
Latest MCQs

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

(A) Shift + space
(B) CTRL + space

(C) Alt + space
(D) None of these

Comments
Latest MCQs

Excel is a ______ program developed by Microsoft....?

(A) Spreadsheet
(B) Document

(C) Data management
(D) None of these

Comments
Latest MCQs

Which of the following is the latest version of MS Excel...?

(A) Excel 2021
(B) Excel 2016

(C) Excel 2017
(D) Office 365

Comments
Latest MCQs

In MS Excel, the Chart wizard term data categories refers to ______...?

(A) A chart plot area
(B) The organization of individual values with a chart’s data series

(C) A horizontal axis
(D) The data range that supply chart data

Comments
Latest MCQs

The ______ function in Excel returns the highest value in a set of data that you specify....?

(A) LRG
(B) AVG

(C) MAX
(D) None of these

Comments
Latest MCQs

Which of following is not a nomenclature of MS Excel ...?

(A) Range
(B) Work book

(C) Document
(D) Cell

Comments
Latest MCQs

Which of the following is not a function in Microsoft Excel?...?

(A) SUM
(B) MAX

(C) MIN
(D) AVG

Comments
Latest MCQs

In MS Excel Ready-made templates are available under _____ tab in new option...?

(A) File
(B) Insert

(C) Design
(D) None of these

Comments
Latest MCQs

What does the VLOOKUP function do in Excel...?

(A) Count the number of cells
(B) Searches for a value in a column and returns a value in the same row

(C) Calculate the average of values
(D) Sorts data in ascending order

Comments
Latest MCQs

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

(A) Database
(B) Spreadsheet

(C) Word processing
(D) None of these

Comments
Latest MCQs

What is a group of cells called in Excel...?

(A) Cell Range
(B) Workbook

(C) Margin
(D) None of these

Comments
Latest MCQs

When you link data maintained in an excel workbook to a word document...?

(A) The word document contains a copy of the actual data
(B) The word document must contain a hyperlink

(C) The word document contains a reference to the original source application
(D) The word document cannot be edit

Comments
Latest MCQs

How many rows are in one Microsoft Excel sheet...?

(A) 65,536
(B) 16,384

(C) 1,048,576
(D) None of Above

Comments
Latest MCQs

Microsoft Excel 2019 files have a default extension of___________...?

(A) .Xlsx
(B) .Xls

(C) .excel
(D) .123

Comments
Latest MCQs

In MS Excel, we can add chart from__ tab....?

(A) File
(B) Chart

(C) Insert
(D) None of these

Comments
Latest MCQs

When typing character search criteria, Excel matches fields based on:...?

(A) Alphabetical order
(B) Capitalization

(C) Spelling
(D) Primary records

Comments
Latest MCQs

To Zoom an Excel worksheet we can use _______...?

(A) The mouse pointer in Print Preview
(B) The zoom button on the Print Preview toolbar

(C) The zoom command on the view menu
(D) All of these

Comments
Latest MCQs

In Ms-Excel, which of the following charts shows percentage adding up tp 100%...?

(A) Pie chart
(B) Bar chart

(C) Line graph
(D) Scatter plot

Comments
Latest MCQs

Which of the following formulas MS-Excel 2016 will not be able to calculate =SUM (AI: A5)*.5, =SUM (Sales)-A3, =SUM( AI: A5)/(10-10), =SUM(AI:A5)-10...?

(A) =SUM (AI: A5)*.5
(B) =SUM (Sales)-A3

(C) =SUM( AI: A5)/(10-10)
(D) =SUM(AI:A5)-10

Comments
Latest MCQs

To set an exception to an AutoCorrect rule, click _______ on the menu bar and then click AutoCorrect Options to display the AutoCorrect dialog box....?

(A) Format
(B) Edit

(C) Tools
(D) View

Comments
Latest MCQs

Another name for a pre programmed formula in excel is ___...?

(A) Cell
(B) Graph

(C) Function
(D) Range

Comments
Latest MCQs

Which shortkey is suitable for reach at the last Row of MS Excel...?

(A) Ctrl + Space
(B) Shift + Ctrl +Enter

(C) Ctrl + Down Arrow
(D) Ctrl + =

Comments
Latest MCQs

To return the reminder after the number is divided by a divisor in Excel we use the function...?

(A) ROUND ( )
(B) FACT ( )

(C) MOD ( )
(D) None

Comments
Latest MCQs

Which is correct form of Cell range in MS Excel:...?

(A) A1-B1
(B) A1:A10

(C) A1 to A10
(D) A1-A10

Comments
Latest MCQs

______ users can open MS Excel 2016 file at the same time...?

(A) 100
(B) 50

(C) 256
(D) None of these

Comments
Latest MCQs

Each excel file is a book that contains different sheets. Which of the following can not be a sheet in a workbook ....?

(A) Macro sheet
(B) Chart sheet

(C) Data sheet
(D) none

Comments
Latest MCQs

Which of the following is not a nomenclature of MS Excel:...?

(A) Range
(B) Workbook

(C) Document
(D) Cell

Comments
Latest MCQs

Shortcut in excell to insert new sheet...?

(A) Shift+F6
(B) Shift+F12

(C) Shift+F11
(D) Shift+A1

Comments
Latest MCQs

Which key is used for help in Ms Excel...?

(A) F1
(B) F2

(C) F3
(D) None of these

Comments
Latest MCQs

Excel is a program that is used to prepare a...?

(A) Database
(B) Text Document

(C) Spreadsheet
(D) Workbook

Comments
Latest MCQs

Which one is not a function in MS Excel:...?

(A) SUM
(B) AVG

(C) MAX
(D) MIN

Comments
Latest MCQs

How to activate a cell in MS Excel...?

(A) Pressing an arrow key
(B) Clicking the cell

(C) Pressing the Tab key
(D) All of the above

Comments
Latest MCQs

What is the use of proper text in MS Excel...?

(A) Engineered
(B) Convert your input text to proper case

(C) Original
(D) None of these

Comments
Latest MCQs

Which option is not available in charts in MS Excel...?

(A) Volume
(B) Line

(C) Pie
(D) Bar

Comments
Latest MCQs

MS Excel is based on: _____________...?

(A) UNIX
(B) DOS

(C) WINDOWS
(D) OS/2

Comments
Latest MCQs

Function in MS Excel is known as ____...?

(A) Formula
(B) Command

(C) Operation
(D) None of these

Comments
Latest MCQs

B2:B6 in MS Excel represents the ______...?

(A) Range of cell
(B) Cell column

(C) Cell Row
(D) None of these

Comments
Latest MCQs

The thin black cross-shaped pointor in MS Excel is used to:...?

(A) Complete lists and fill patterns
(B) Move a group of cells

(C) Resize
(D) Highlight duplicate cells

Comments
Latest MCQs

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

(A) A form
(B) A ledger

(C) A table
(D) A workbook

Comments
Latest MCQs

In Microsoft Excel the Intersection of columns and rows is called a:...?

(A) Data
(B) Table

(C) Cell
(D) Schema for:

Comments
Latest MCQs

What will be result of excel formula =5 + 2 * 3...?

(A) 1
(B) 10

(C) 11
(D) 21

Comments
Latest MCQs

How many types of references are used in Excel:...?

(A) 3
(B) 4

(C) 5
(D) 6

Comments
Latest MCQs

Which of the following is an absolute cell reference...?

(A) $A$1
(B) #A#1

(C) !A1
(D) None of these

Comments
Latest MCQs

Move to the next cell in the row in MS Excel _____...?

(A) Tab
(B) Shift

(C) Space
(D) None of these

Comments
Latest MCQs

How to duplicate values in cell range in Excel 2016...?

(A) Click the conditional formatting button in the styles group of the theme
(B) Select the range of cell in the work sheet

(C) Both A and B
(D) None of these

Comments
Latest MCQs

What does the term “filter” refer to in Excel...?

(A) To permanently delete rows or columns
(B) To format the appearance of cells

(C) To temporarily hide certain data based on specific criteria
(D) To create a chart

Comments
Latest MCQs

Which of the following displays the contents of the active cell in MS Excel:...?

(A) Active cell
(B) Formula bar

(C) Title bar
(D) Name box

Comments
Latest MCQs

Which chart in MS-Excel represents only one value for each variable...?

(A) Pie Chart
(B) Area Chart

(C) Bar Chart
(D) None of these

Comments
Latest MCQs

You can create a new presentation in PowerPoint by completing all of the following except_______________...?

(A) Clicking the new button on the standard toolbar
(B) Clicking file, new

(C) Clicking file open
(D) Pressing ctrl + N

Comments
Latest MCQs

When you open an Excel sheet, what is the topmost bar called...?

(A) Title Bar
(B) Status Bar

(C) Menu Bar
(D) Tool Bar

Comments
Latest MCQs

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

(A) Shift+Backspace
(B) Crtl+Backspace

(C) Alt+Backspace
(D) none

Comments
Latest MCQs

In a new workbook in MS Excel, which one appears on the topmost of the screen...?

(A) Status Bar
(B) Title Bar

(C) Vertical Scroll bar
(D) Horizontal scroll bar

Comments
Latest MCQs

Which sign is used to create an absolute cell reference in MS Excel...?

(A) $
(B) @

(C) &
(D) %

Comments
Latest MCQs

MS Excel is commonly used to...?

(A) Database
(B) Organize Data

(C) Information
(D) None of these

Comments
Latest MCQs

How can you sum up a range of cells in Excel...?

(A) Use the SUM function
(B) Use the AVERAGE function

(C) Use the COUNT function
(D) Use the MAX function

Comments
Latest MCQs

In MS Excel, to insert a sum formula in a cell...?

(A) =sum(A1:A2)
(B) =Add(a1:a2)

(C) =sum(1A:2A)
(D) =Add(1A:2A)

Comments
Latest MCQs

When an Excel workbook is linked to a Word document:...?

(A) The Word document contains a copy ofthe actual data
(B) The word document cannot be edited

(C) The word document must contain ahyperlink
(D) Theword document contains a reference to the original source application

Comments
Latest MCQs

Can you merge the main document with data source in excel. In mail merge operation, the word usually...?

(A) Server
(B) Client

(C) Source
(D) none

Comments
Latest MCQs

What is a cell in Excel...?

(A) A row
(B) A column

(C) A unit of data
(D) A unit of formatting

Comments
Latest MCQs

In MS Excel if a numeric value start with ____ then this value can be treated as a tableHash, Equal Sign, Apostrophe, Tide...?

(A) Hash
(B) Equal Sign

(C) Apostrophe
(D) Tide

Comments
Latest MCQs

If a formula references a cell that contains text instead of a numerical value, what error does Excel display...?

(A) #NUM!
(B) #VALUE!

(C) #REF!
(D) #DIV0

Comments
Latest MCQs

VLOOKUP is a built-in function in Excel used to:...?

(A) Increases the font of text
(B) Prints the content of an Excel sheet

(C) Searches for a value in the column
(D) Deletes a value in the column

Comments
Latest MCQs

What is the function of the SUM function in Excel...?

(A) To add up a range of cells
(B) To find the average of a range of cells

(C) To count the number of cells in a range
(D) To find the maximum value in a range of cells

Comments
Latest MCQs

How many columns are in one Microsoft Excel sheet...?

(A) 65,536
(B) 16,384

(C) 1,048,576
(D) None of Above

Comments
Latest MCQs

How to fit long text in a single cell with a multiple lines :...?

(A) Start typing in the cell and press the enter key to start another line
(B) Use the wrap text option in the format -> alignment menu

(C) Use the shrink to fit option in the format ->cells->alignment menu
(D) None of these

Comments
Latest MCQs

--- is used to tell excel to include all cell between the two end point cell reference...?

(A) Double colon
(B) Single colon

(C) Double sami colon
(D) None of these

Comments
Latest MCQs

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

(A) Ctrl+4
(B) Ctrl+5

(C) Ctrl+6
(D) None of these

Comments
Latest MCQs

In Excel a small square in the lower-right corner of a selected cell is called...?

(A) Fill Handle
(B) Fill Pointer

(C) Flash Fill
(D) None of these

Comments
Latest MCQs

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

(A) Edit > Clear > All
(B) Edit > Clear > Contents

(C) Edit > Delete
(D) none

Comments
Latest MCQs

Excel would evaluate the formula, = 20*10/5*8, and return this answer...?

(A) 5
(B) 625

(C) 320
(D) 232

Comments
Latest MCQs

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

(A) Alt + F2
(B) Ctrl + F12

(C) Shift + F5
(D) Shift + F2

Comments
Latest MCQs

In MS Excel 2016 one has to go to _____ option for setting or clearing print area....?

(A) Insert
(B) Page Layout

(C) Data
(D) Review

Comments
Latest MCQs

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

(A) Workbook
(B) Worksheet

(C) Note sheet
(D) Notebook

Comments
Latest MCQs

Where can you set the shading color of a range of cells in excel ...?

(A) Choose required color on Fill Color tool in Formatting toolbar
(B) Choose required color on Fill Color tool in Drawing toolbar

(C) Choose required color form Patterns tab of Format Cells dialog box
(D) All of these

Comments
Latest MCQs

in MS-Excel__________ short cut key is used for hiding rows....?

(A) Ctrl+H
(B) Ctrl+7

(C) Ctrl+9
(D) None of the above

Comments
Latest MCQs

In MS-Excel when you are typing an equation into a cell the first thing that must be entered is...?

(A) The first cell referenced
(B) Parenthesis

(C) Quotation marks
(D) An equal sign

Comments
Latest MCQs

MS Excel displays the current (active) cell address in the ______...?

(A) Name box
(B) Cell tip

(C) Both
(D) None of these

Comments
Latest MCQs

When you insert an Excel File into a word document, the data are...?

(A) Hyperlinked
(B) Placed in a word table

(C) Linked
(D) Embedded

Comments
Latest MCQs

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

(A) Wrap text
(B) Click next

(C) All
(D) None

Comments
Latest MCQs

By default line indentation in MS Excel is:...?

(A) 0.5"
(B) 1"

(C) 0.75"
(D) 1.25"

Comments
Latest MCQs

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

(A) wrap text
(B) text wrap

(C) letter warp
(D) word wrap

Comments
Latest MCQs

An excel workbook is a collection of__________...?

(A) Worksheets& Charts
(B) Slides

(C) Pages
(D) documents

Comments
Latest MCQs

Which one is not a Function in MS Excel...?

(A) SUMB
(B) AVG

(C) MAX
(D) MIN

Comments
Latest MCQs

Where can you change automatic or manual collection mode in Excel ...?

(A) Double CAL indicator on status bar
(B) Go to File > Options > Formulas > Calculation Option - and mark the corresponding radio button

(C) both
(D) none

Comments
Latest MCQs

These In MS Excela formula that looks for a s for a value in Teft most column of a fable and then returns a value in the same row for specific column:...?

(A) Horizontal Lookup
(B) Vertical Lookup

(C) Average
(D) None of these

Comments
Latest MCQs

Which of these will not select all the cells in a documents ...?

(A) Clicking three times with the right mouse button in the spreadsheet
(B) both

(C) Using the Edit- Select all menu
(D) None

Comments
Latest MCQs

What is the intersection of a column and row called in Excel...?

(A) A cell
(B) A range

(C) A column header
(D) A row header

Comments
Latest MCQs

_________ is used to tell excel to include all cell between the two end point cell reference...?

(A) Double colon
(B) Single colon

(C) Double sami colon
(D) None of these

Comments
Latest MCQs

To add two cells (A1 and A2) together in MS Excel,formula is used:...?

(A) =A1+A2
(B) =Add(A1+A2)

(C) =together(A1:A2)
(D) A1 plus A2

Comments
Latest MCQs

Ctrl + D in MS Excel is used for...?

(A) Fill down in the selection
(B) Open the font dialog box

(C) Both A and B
(D) None of these

Comments
Latest MCQs

In MS Word, “Justify” works to make text straight in both sides but How Justify works in MS Excel...?

(A) Text in Columns
(B) Text in Rows

(C) Text in selection
(D) None

Comments
Latest MCQs

MS Excel Formula starts with__________...?

(A) .
(B) _

(C) =
(D) none

Comments
Latest MCQs

What is the main function of MS Excel...?

(A) organized data
(B) loss data

(C) gain data
(D) none of these

Comments
Latest MCQs

Which of the following methods can not be used to enter data in MS Excel cell:...?

(A) Pressing an arrow key
(B) Pressing the Tab key

(C) Pressing the Esc key-
(D) Clicking on the formula bar-

Comments
Latest MCQs

Which excel feature is associated with a ______ line appearing around a cell when selected...?

(A) Data Validation
(B) Active Cell Highlighting

(C) Filter
(D) Freeze Panes

Comments
Latest MCQs

The freezing row and column in Excel is in which pane...?

(A) Freezing row
(B) Freezing column

(C) Freezing pane
(D) None of these

Comments
Latest MCQs

In MS Excel, to create a formula, you can use:...?

(A) Values but not cell references
(B) Cell references but not values

(C) Values or cell references although notboth at the same time
(D) Both value and cell references

Comments
Latest MCQs

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

(A) existing file or web page
(B) place in this document

(C) e-mail address
(D) link to home

Comments
Latest MCQs

With which of the following all formulas in excel starts ...?

(A) /
(B) *

(C) $
(D) =

Comments
Latest MCQs

In MS Excel, to insert a sum formula in a cell, we must...?

(A) =sum(A1:A2)
(B) Add(a1 a2)

(C) =sum(1A:2A)
(D) =Add(1A,2A)

Comments
Latest MCQs

_______ is the short key to select the entire column in Excel....?

(A) Alt + space bar
(B) Shift + space bar

(C) Control + space bar
(D) None of the above

Comments
Latest MCQs

What are the small squares arranged in rows and columns called in Excel...?

(A) Blocks
(B) Rows

(C) Cells
(D) Columns

Comments
Latest MCQs

What displays the content of active cell in MS Excel...?

(A) Name Box
(B) Formula Bar

(C) Row Headings
(D) None of these

Comments
Latest MCQs

the address of the cell at 26th column and 30th row is...?

(A) 26, 30
(B) AA30

(C) A2630Y
(D) None of these

Comments
Latest MCQs

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

(A) Goal seek
(B) Solver

(C) Scenario Manager
(D) All of above

Comments
Latest MCQs

Which of these will not select all the cells in a document ...?

(A) Using the Edit – Select All menu
(B) Pressing Ctrl + A on the keyboard

(C) Clicking three times with the right mouse button in the spreadsheet
(D) None of These

Comments
Latest MCQs

In Excel, transferring data to the next worksheet is called...?

(A) Copy-pasting
(B) Linking or Referencing

(C) Deleting
(D) Sorting

Comments
Latest MCQs

Which key should be pressed continuously while moving a column in MS Excel:...?

(A) Ctrl
(B) Shift

(C) Alt
(D) Tab

Comments
Latest MCQs

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

(A) Ctrl+Shift+1
(B) Ctrl+Shift+4

(C) Ctrl+1
(D) Shift+1

Comments
Latest MCQs

Which of the following operators take only integer operands in MS Excel...?

(A) %
(B) +

(C) /
(D) None of these

Comments
Latest MCQs

An excel workbook is a collection of __________...?

(A) Worksheets and Charts
(B) Charts

(C) Worksheets
(D) Workbooks

Comments
Latest MCQs

How you can update the values of formula cell.If auto calculate the mode of excel cell is disabled...?

(A) f9
(B) f2

(C) f7
(D) none

Comments
Latest MCQs

What is a Macro in MS Excel...?

(A) A single instruction that performs a specific task
(B) A set of instructions that can be executed as a single command

(C) A type of chart or graph used for data visualization
(D) A feature that allows users to create and edit images

Comments
Latest MCQs

In MS Excel, which of the following functions can be used to remove all spaces from a text string except for single spaces between words...?

(A) TRIM
(B) SUBSTITUTE

(C) CLEAN
(D) REPT

Comments
Latest MCQs

In Excel, to perform addition, the function used is _____...?

(A) =ADD()
(B) =SUM()

(C) =TOTAL()
(D) =PLUS()

Comments
Latest MCQs

MS Excel sheet consists of __________...?

(A) Text boxes
(B) Rows & Columns

(C) Pictures & Drawings
(D) Rows & Text

Comments
Latest MCQs

Function key to go to a specific cell in MS Excel is:...?

(A) F4
(B) F5

(C) F6
(D) None of these

Comments
Latest MCQs

Who gave the cell theory...?

(A) Robert Hooke
(B) Ernst Haeckel

(C) Matthias Schleiden and Theodor Schwann
(D) Albrecht Von Roelliker

Comments
Latest MCQs

Which the following term does not pertain to Excel...?

(A) Browser
(B) Columns

(C) Work Book
(D) None of these

Comments
Latest MCQs

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

(A) 1
(B) 2

(C) 3
(D) 5

Comments
Latest MCQs

Shortcut key of hide entire column in excel...?

(A) Ctrl + Shift + 0
(B) Ctrl + alt+ 0

(C) Shift + 0
(D) Ctrl+0

Comments
Latest MCQs

Which is the correct form in MS Excel...?

(A) 6A
(B) A6

(C) AA6
(D) +A+

Comments
Latest MCQs

If you press ____ the cell accepts your typing as its content...?

(A) Tab
(B) Ctrl+Enter

(C) Enter
(D) Alt+Enter

Comments
Latest MCQs

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

(A) Goal seek
(B) Solver

(C) Scenario Manager
(D) All of above

Comments
Latest MCQs

What will be the result of formula '=16/2^3' in a cell in MS Excel...?

(A) 512
(B) 124

(C) 2
(D) 124

Comments
Latest MCQs

Which of the following is last column in MS Excel-2016...?

(A) XFD
(B) ZZZ

(C) ZXF
(D) ZAZ

Comments
Latest MCQs

Which of following function in Microsoft Excel is used to count items in a cell range...?

(A) Count
(B) SUM

(C) MAX
(D) Average

Comments
Latest MCQs

Which among following wildcard characters are recognized by excel ...?

(A) +and -
(B) ; and ^

(C) * and ?
(D) <and >

Comments
Latest MCQs

While finding and replacing some data in Excel,which of following statement is valid...?

(A) You can Find and Replace within the sheet or workbook
(B) Excel does not have option to match case for find

(C) All
(D) None

Comments
Latest MCQs

What displays the content of active cell...?

(A) Name box
(B) Row headings

(C) Formula bar
(D) None of these

Comments
Latest MCQs

Ctrl+Shift+1 shortcut Keys in excel are used to __________...?

(A) Format number in comma format
(B) Format number in currency format

(C) Format number in date format
(D) Format number in time format

Comments
Latest MCQs

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

(A) Alt+M
(B) Ctrl+M

(C) Ctrl+C
(D) Ctrl+B

Comments
Latest MCQs

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

(A) Date ()
(B) Today ()

(C) Year ()
(D) Now ()

Comments
Latest MCQs

How can you show or hide the grid-lines in Excel worksheet ...?

(A) Click Gridline tool on Forms toolbar
(B) Go to Tools > Options > View tab and mark or remove the check box named Gridline

(C) both
(D) none

Comments
Latest MCQs

Embedded Formula in MS Excel can removed by pressing...?

(A) DELETE
(B) BACKSPACE

(C) PAGE DOWN
(D) END

Comments
Latest MCQs

Ctrl+R is used in excel to...?

(A) Fill the selection with active cells to the right
(B) Right align the content of cell

(C) Remove the cell contents of selected cells
(D) none

Comments
Latest MCQs

In MS-Excel, when the formula bar is activated, we can see:...?

(A) Enter Button
(B) Cancel Button

(C) Edit Formula Button
(D) None of these

Comments
Latest MCQs

The first cell in EXCEL worksheet is labeled as ____...?

(A) AA
(B) Aa

(C) A1
(D) None of these

Comments
Latest MCQs

Which chart type in Excel is best suited for showing the proportion of parts to a whole...?

(A) Pie Chart
(B) Bar Chart

(C) Lines Chart
(D) None of these

Comments
Latest MCQs

To advance rightward from one cell to the next in a table, press the ________ key....?

(A) tab
(B) backspace

(C) home
(D) enter

Comments
Latest MCQs

How many worksheets are there in Excel by default:...?

(A) 01
(B) 03

(C) 05
(D) 07

Comments
Latest MCQs

Move to next cell in row in Ms Excel:...?

(A) Tab
(B) Shift

(C) Space
(D) None of these

Comments
Latest MCQs

Actual working area of Computer’s Microsoft Excel is ________ ...?

(A) Workbook
(B) Worksheet

(C) Notesheet
(D) Notebook

Comments
Latest MCQs

Which is true when you insert an excel worksheet into a word document...?

(A) word is the destination document
(B) excel is the destination document

(C) the worksheet is the destination document
(D) the document is the source document

Comments
Latest MCQs

The thin black cross-shaped pointer in MS Excel is used to _____...?

(A) Move a group of cells
(B) Highlight duplicate cells

(C) Complete lists and fill patterns
(D) None of these

Comments
Latest MCQs

In MS Excel = Now () is used ______...?

(A) To show current date
(B) To show current time

(C) To show current date and time
(D) None of these

Comments
Latest MCQs

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

(A) Clean All
(B) Clear All

(C) Clean Content
(D) Clean Format

Comments
Latest MCQs

In MS Excel we added ______ before fraction for not to enter date...?

(A) space
(B) comma

(C) asterik
(D) None of these

Comments
Latest MCQs

In Excel, you can sort data in...?

(A) Ascending order
(B) Descending order

(C) Both A & B
(D) None of these

Comments
Latest MCQs

Rows in Microsoft Excel are labeled as _____...?

(A) 1, 2, 3, etc.
(B) A1, A2, etc.

(C) A, B, C, etc.
(D) None of these

Comments
Latest MCQs

In MS Excel, you can use the horizontal and vertical scroll bars to:...?

(A) Split a worksheet into two panes
(B) View different rows and columns

(C) Edit the contents of a cell
(D) View different worksheets

Comments
Latest MCQs

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

(A) 10
(B) 100

(C) 300
(D) 500

Comments
Latest MCQs

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

(A) moves to the previous worksheet
(B) moves to the next worksheet

(C) forward to the previous worksheet
(D) none of these

Comments
Latest MCQs

What does moving from cell C9 to C11 mean in MS Excel...?

(A) C9:C11
(B) C9-C11

(C) C9 to C11
(D) None of these

Comments
Latest MCQs

You can edit existing Excel data by pressing the:________ key...?

(A) F1 Key
(B) F2 Key

(C) F3 Key
(D) F4 Key

Comments
Latest MCQs

Which Excel feature allows you to display only specific data based on a condition...?

(A) Grouping
(B) Sorting

(C) Filtering
(D) None of these

Comments
Latest MCQs

What is active cell in MS-Excel ______...?

(A) Rectangular box
(B) Pointer

(C) Nearing point of view
(D) None of the above

Comments
Latest MCQs

In excel columns are labelled as____________...?

(A) A, B, C, etc.
(B) 1, 2, 3, etc.

(C) A1, A2, A3, etc.
(D) $A$1, $A$2, etc.

Comments
Latest MCQs

___________is used to create a chart in MS Excel...?

(A) CTRL+Y
(B) F11

(C) ALT+F11
(D) All of these

Comments
Latest MCQs

In Microsoft Excel, press___________ key to enter a new line within a cell...?

(A) Ctrl+ Enter
(B) Alt+ Enter

(C) Shift+ Enter
(D) Ctrl+Shift+Enter

Comments
Latest MCQs

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

(A) ctrl+shift+1
(B) ctrl+shift+4

(C) crtl+1
(D) shift+1

Comments
Latest MCQs

MS Excel's function arguments are always written in _______ ....?

(A) Cell
(B) Row

(C) Colomn
(D) Parenthesis

Comments
Latest MCQs

In MS Excel window, on the bottom, right area of the spreadsheet there is/are:...?

(A) Horizontal scroll bar
(B) Zoom tool

(C) Page view commands
(D) All of these

Comments
Latest MCQs

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

(A) F2
(B) F10

(C) F4
(D) F8

Comments
Latest MCQs

In MS Excel, if you want to reference a cell in the same column but a different row on another sheet, what type of...?

(A) Absolute refrence
(B) Relative reference

(C) mixed reference
(D) circular reference

Comments
Latest MCQs

Slide show options available to the presenter include all of the following except_____________...?

(A) Transitions command
(B) Speaker notes command

(C) Meeting reminder command
(D) Navigation commands

Comments
Latest MCQs

In MS Excel you can sort data in ...?

(A) Ascending order
(B) Descending order

(C) Both A & B
(D) None of these

Comments
Latest MCQs

Which indent marker controls all the lines except first line...?

(A) Left Indent Marker
(B) First Line Indent Marker

(C) Right Indent Marker
(D) Hanging Indent Marker

Comments
Latest MCQs

Which of these key are used to apply outline border to the selected cell in MS Excel...?

(A) CTRL+SHIFT+ %
(B) CTRL+SHIFT+ &

(C) CTRL+SHIFT+ ~
(D) CTRL+SHIFT+ $

Comments
Latest MCQs

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

(A) Worksheet
(B) Workbook

(C) Formula
(D) Location

Comments
Latest MCQs

Which option in Microsoft Excel will help you arrange, summarize and group large sets of data...?

(A) Illustrations
(B) Pivot table

(C) Sparkline
(D) Filter

Comments
Latest MCQs

What is the extension of a Microsoft Excel file...?

(A) .msxcl
(B) .xcl

(C) .xlsx
(D) .xlsm

Comments
Latest MCQs

How do you freeze panes in Excel...?

(A) Home tab and go to freeze panes
(B) View he tab and go to freeze panes

(C) Review tab and go to Freeze Panes
(D) Page layout tab and go to Freeze panes

Comments
Latest MCQs

IF function used in Excel for _____...?

(A) Performing logical comparisons
(B) Formatting text

(C) Creating charts
(D) None of these

Comments
Latest MCQs

MS Excel, MS PowerPoint and MS Word are the part of:...?

(A) Microsoft Office Suite
(B) Microsoft Outlook

(C) Microsoft one drive
(D) All of these

Comments
Latest MCQs

What would you do to delete a record in MS Excel...?

(A) Select Data > Open data from dialog box to find the record and click the delete button
(B) Select Data > Delete record from the menu

(C) Delete Column from the work sheet
(D) None of these

Comments
Latest MCQs

You can create a new presentation by completing all of the following except ______...?

(A) Clicking file, new
(B) Pressing Ctrl + N

(C) Clicking the new button on the standard toolbar
(D) Clicking file open

Comments
Latest MCQs

Which of following is Not one of Excel's "what- if function?...?

(A) Goal seekyears?
(B) Gabriel's wing

(C) n M rightly guided
(D) Auto Outline

Comments
Latest MCQs

You can set page border in excel from: __________...?

(A) From Border tab in Format Cells dialog box
(B) From Border tool in Formatting toolbar

(C) From Line Style tool in Drawing toolbar
(D) You can not set page border in Excel

Comments
Latest MCQs

Which Excel feature allows you to freeze rows and columns so they remain visible while scrolling...?

(A) Freeze Panes
(B) Hide Rows/Columns

(C) Lock Cells
(D) Split Window

Comments
Latest MCQs

Which shortcut key is used to insert a new worksheet in MS Excel...?

(A) Shift + F8
(B) Shift + F9

(C) Shift + F10
(D) Shift + F11

Comments
Latest MCQs

By default excel provides 3 worksheets. You need only two of them, how will you delete the third one...?

(A) Both
(B) Click on Sheet 3 and from Edit menu choose Delete

(C) Right click on Sheet Tab of third sheet and choose Delete from the context menu
(D) none

Comments
Latest MCQs

Which symbol is used for division in Excel...?

(A) /
(B) *

(C) +
(D) .

Comments
Latest MCQs

Which of the following option can remove the borders in MS Excel:...?

(A) Press enter
(B) Use no border

(C) Use formula
(D) Not possible in MS Excel

Comments
Latest MCQs

Which area in an excel window allows entering values and formulas...?

(A) Menu Bar
(B) Title Bar

(C) Formula Bar
(D) None of these

Comments
Latest MCQs

Which of these keys are used in MS Excel to insert the current time in workbook?...?

(A) Ctrl + Shift +:
(B) Ctrl+!

(C) Ctrl+
(D) None of these

Comments
Latest MCQs

Which Shortcut keys are used to strikethrough highlighted selection in Excel...?

(A) Ctrl+4
(B) Ctrl+5

(C) Ctrl+6
(D) None of the above.

Comments
Latest MCQs

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

(A) ctrl +
(B) ctrl +;

(C) ctrl +:
(D) ctrl +'

Comments
Latest MCQs

In MS-Excel if you accidentally erased a record on the sheet what command can be used to restore it immediately...?

(A) Undo
(B) Redo

(C) Insert
(D) None of these

Comments
Latest MCQs

In Ms Excel Ready made templates are available under _______ tab ...?

(A) File
(B) Insert

(C) Design
(D) None of Above

Comments
Latest MCQs

Shortcut key to insert a new worksheet in Excel is _______...?

(A) Shift + F8
(B) Shift + F9

(C) Shift + F10
(D) Shift + F11

Comments
Latest MCQs

Which of the following EXCEL feature allows users to evaluate values and return a result...?

(A) Formula
(B) Formating

(C) Filters
(D) None of these

Comments
Latest MCQs

In MS excel a change in the appearance of the value or label in a cell...?

(A) Formation
(B) Editing

(C) word art
(D) None

Comments
Latest MCQs

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

(A) File
(B) Count

(C) Table
(D) None of these

Comments
Latest MCQs

In Microsoft Word, When the user is reading a document on the screen and want to hide all the elements except for the document, he chooses...?

(A) Print layout
(B) Full Screen reading view

(C) Web layout view
(D) Outline view

Comments
Latest MCQs

MS Excel is based on :...?

(A) UNIX
(B) DOS

(C) WINDOWS
(D) OS/2

Comments
Latest MCQs

With which of the following all formulas in MS excel starts:...?

(A) /
(B) =

(C) +
(D) &

Comments
Latest MCQs

What is the function of the VLOOKUP function in Excel...?

(A) To perform a vertical lookup and return a value based on a specified criteria
(B) To perform a horizontal lookup and return a value based on a specified criteria

(C) To add up a range of cells
(D) To find the average of a range of cells

Comments
Latest MCQs

In MS Excel 2016, = Now () is used for...?

(A) to show time
(B) to show date

(C) to show both Time and date
(D) None of these

Comments
Latest MCQs

Which area in MS Excel window allows entering values and formulas...?

(A) Title bar
(B) Menu bar

(C) Formula bar
(D) Standard toolbar

Comments

Best of Luck

From ShineGk.com

Share our website's link