MS excel is used to data...? Mcqs

PPSC Past Papers

Latest MCQs

MS excel is used to data...?

(A) Organize
(B) Share

(C) Communicate
(D) Obtain

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 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

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

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

Constant value in excel also called ...?

(A) Number
(B) words

(C) mark
(D) None

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

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

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

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

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

(A) Cells
(B) Rows

(C) Columns
(D) Parentheses

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

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 Excel charts vertical axis are called...?

(A) Slot
(B) Z-axis

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

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 the following is a case that contains electronic components of the computer used to process data...?

(A) System unit
(B) Master section

(C) Control port
(D) Computer chip

Comments
Latest MCQs

Letters in Excel denote :...?

(A) Columns
(B) rows

(C) numbers
(D) reference

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

MS Excel is a ______...?

(A) Spreadsheet program
(B) Multimedia software

(C) Entertainment software
(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

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

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

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 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 ready-made templates are available under ______ tab in new option....?

(A) File
(B) Count

(C) Table
(D) None of these

Comments
Latest MCQs

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

(A) DELETE
(B) BACKSPACE

(C) PAGE DOWN
(D) END

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

--- 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

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

(A) /
(B) *

(C) $
(D) =

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

Excel is a ....?

(A) Graphic program
(B) Word Processor

(C) A spreedsheet Program
(D) Deisgining Template

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

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

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

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

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

(C) Deleting
(D) Sorting

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 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

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

(A) Worksheet
(B) Workbook

(C) Formula
(D) Location

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

What is the shortcut key to replace data with another in sheet ...?

(A) Ctrl + Shift + R
(B) Ctrl + H

(C) Ctrl + R
(D) All

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

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

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

(A) *
(B) +

(C) =
(D) $

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

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

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 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

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

User developed instruction for excel are called__________...?

(A) Progrms
(B) Macros

(C) Procedured
(D) All 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 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 Excel, to perform addition, the function used is _____...?

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

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

Comments
Latest MCQs

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

(A) Table
(B) Record

(C) Field
(D) Cell

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

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

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 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 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

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 Microsoft Excel the Intersection of columns and rows is called a:...?

(A) Data
(B) Table

(C) Cell
(D) Schema for:

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
Latest MCQs

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

(A) 01
(B) 03

(C) 05
(D) 07

Comments
Latest MCQs

Cryptography is a technique where data is secure and immune from...?

(A) Changes
(B) Defense

(C) Risk
(D) Alak

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

Processed Data called...?

(A) Raw Data
(B) Facts Data

(C) Information
(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

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

(A) Database
(B) Text Document

(C) Spreadsheet
(D) Workbook

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

Worksheet in excel by default ___...?

(A) 3
(B) 2

(C) 1
(D) 4

Comments
Latest MCQs

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

(A) /
(B) =

(C) +
(D) &

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

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

(A) Data
(B) Tools

(C) Formatting
(D) Layout

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

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 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

What would you do when you want to update the data in an embedded worksheet range...?

(A) double click the worksheet range object
(B) right click worksheet range object & choose format object

(C) edit the data in the destination document
(D) edit the data in the source document.

Comments
Latest MCQs

Columns in MS Excel are called...?

(A) Fields
(B) Chart

(C) Both
(D) None of these

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

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

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

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

Comments
Latest MCQs

You are said to collect numerical data from different sources and perform different computations on it, which of the following you would use...?

(A) Word
(B) PowerPoint

(C) Excel
(D) Frontpage

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

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 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

_________ 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

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

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

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

Microsoft excel is a powerful______...?

(A) Spreadsheet package
(B) Word processing package

(C) DBMS package
(D) None

Comments
Latest MCQs

MS Excel stands for_______...?

(A) Micromax Excel
(B) Microsoft Excel

(C) Micromax Excess
(D) Management Excel

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

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

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

Which of the following will not enter data in a cell...?

(A) Pressing the Esc key
(B) Pressing the Tab Key

(C) Both of these
(D) None of above

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

Letters in Excel denote: ______________...?

(A) Columns
(B) rows

(C) numbers
(D) reference

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

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

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

(A) File
(B) Insert

(C) Design
(D) None of these

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

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 MS-Excel, the ZOOM option appears in:...?

(A) Formula Bar
(B) Status Bar

(C) Title Bar
(D) Scroll Bar

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

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

Formula in Excell starts with...?

(A) +
(B) -

(C) =
(D) [

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

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

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

(A) Program
(B) Macros

(C) Procedure
(D) All of these

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 Ms Excel Ready made templates are available under _______ tab ...?

(A) File
(B) Insert

(C) Design
(D) None of Above

Comments
Latest MCQs

Shortcut in excell to insert new sheet...?

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

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

Comments

MCQs Categories


Best of Luck

From ShineGk.com

Share our website's link