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

Source: This question is taken from the Sub Inspector Service Quota Punjab Police Department

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

Source: This question is taken from the Microsoft Excel MCQs

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

Source: This question is taken from the Microsoft Excel MCQs

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

Source: This question is taken from the Microsoft Excel MCQs

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

Source: This question is taken from the Land Records Junior Clerk BS-11 NTS past papers

Latest MCQs

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

(A) Spreadsheet
(B) Document

(C) Data management
(D) None of these

Comments

Source: This question is taken from the Microsoft Excel MCQs

Latest MCQs

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

(A) Database
(B) Text Document

(C) Spreadsheet
(D) Workbook

Comments

Source: This question is taken from the Junior Clerk Board of Revenue, Punjab-2023 43j2022

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

Source: This question is taken from the Microsoft Excel MCQs

Latest MCQs

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

(A) File
(B) Insert

(C) Design
(D) None of Above

Comments

Source: This question is taken from the Microsoft Excel MCQs

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

Source: This question is taken from the Microsoft Excel MCQs

Latest MCQs

Letters in Excel denote: ______________...?

(A) Columns
(B) rows

(C) numbers
(D) reference

Comments

Source: This question is taken from the Microsoft Excel MCQs

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

Source: This question is taken from the Punjab Police Sub Inspector Service Quota PPSC Past Paper

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

Source: This question is taken from the Microsoft Excel MCQs

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

Source: This question is taken from the Data Entry Operator BS-14 Lahore High Court 2022

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

Source: This question is taken from the Data Entry Operator in the Punjab Police 2020

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

Source: This question is taken from the Microsoft Excel MCQs

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

Source: This question is taken from the Assistant Sub Inspector (ASI) Anti-Corruption Punjab Police

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

Source: This question is taken from the Junior Computer Operator (Bs-12) Transport And Mass Transit Department, Irrigation Department PPSC 2024

Latest MCQs

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

(A) Paper Size
(B) Page Layout

(C) Column width
(D) None of these

Comments

Source: This question is taken from the Microsoft Excel MCQs

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

Source: This question is taken from the Canal Patwari (BS-11) Irrigation ppsc past papers

Latest MCQs

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

(A) File
(B) Insert

(C) Design
(D) None of these

Comments

Source: This question is taken from the Canal Patwari (BS-11) Irrigation ppsc past papers

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

Source: This question is taken from the Microsoft Excel MCQs

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

Source: This question is taken from the Microsoft Excel MCQs

Latest MCQs

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

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

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

Comments

Source: This question is taken from the Microsoft Excel MCQs

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

Source: This question is taken from the Assistant Director BS-17 Home Department

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

Source: This question is taken from the Microsoft Excel MCQs

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

Source: This question is taken from the Data Entry Operator BS-14 Lahore High Court 2022

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

Source: This question is taken from the Microsoft Excel MCQs

Latest MCQs

MS Excel is a ______...?

(A) Spreadsheet program
(B) Multimedia software

(C) Entertainment software
(D) None of these

Comments

Source: This question is taken from the Microsoft Excel MCQs

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

Source: This question is taken from the Microsoft Excel MCQs

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

Source: This question is taken from the Sub Inspector Punjab Police Open Marit

Latest MCQs

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

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

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

Comments

Source: This question is taken from the Microsoft Excel MCQs

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

Source: This question is taken from the Microsoft Excel MCQs

Latest MCQs

MS Excel stands for_______...?

(A) Micromax Excel
(B) Microsoft Excel

(C) Micromax Excess
(D) Management Excel

Comments

Source: This question is taken from the Microsoft Excel MCQs

Latest MCQs

Formula in Excell starts with...?

(A) +
(B) -

(C) =
(D) [

Comments

Source: This question is taken from the Punjab Police Sub Inspector (SI) Service Quota PPSC Past

Latest MCQs

Columns in MS Excel are called...?

(A) Fields
(B) Chart

(C) Both
(D) None of these

Comments

Source: This question is taken from the Microsoft Excel MCQs

Latest MCQs

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

(A) Table
(B) Record

(C) Field
(D) Cell

Comments

Source: This question is taken from the Microsoft Excel MCQs

Latest MCQs

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

(A) /
(B) =

(C) +
(D) &

Comments

Source: This question is taken from the Land Records Junior Clerk BS-11 NTS past papers

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

Source: This question is taken from the Microsoft Excel MCQs

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

Source: This question is taken from the Assistant Sub Inspector in the Punjab Police Department

Latest MCQs

Processed Data called...?

(A) Raw Data
(B) Facts Data

(C) Information
(D) None of these

Comments

Source: This question is taken from the Police Station Assistant (PSA) Batch 6th & 7th Past Paper

Latest MCQs

Worksheet in excel by default ___...?

(A) 3
(B) 2

(C) 1
(D) 4

Comments

Source: This question is taken from the Microsoft Excel MCQs

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

Source: This question is taken from the Assistant Sub Inspector (ASI) Punjab Police Past Paper 2021

Latest MCQs

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

(A) Program
(B) Macros

(C) Procedure
(D) All of these

Comments

Source: This question is taken from the Data Entry Operator BS-14 Lahore High Court 2022

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

Source: This question is taken from the Microsoft Excel MCQs

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

Source: This question is taken from the Clubbed Case Canal Patwari First Phase (Morning) 2023

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

Source: This question is taken from the Assistant Sub Inspector (ASI) Punjab Police Service Quota

Latest MCQs

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

(A) Formula Bar
(B) Status Bar

(C) Title Bar
(D) Scroll Bar

Comments

Source: This question is taken from the Microsoft Excel MCQs

Latest MCQs

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

(A) Worksheet
(B) Workbook

(C) Formula
(D) Location

Comments

Source: This question is taken from the Microsoft Excel MCQs

Latest MCQs

Excel is a ....?

(A) Graphic program
(B) Word Processor

(C) A spreedsheet Program
(D) Deisgining Template

Comments

Source: This question is taken from the SUB Inspector In Punjab Police Department (BSP 14) 2017

Latest MCQs

Letters in Excel denote :...?

(A) Columns
(B) rows

(C) numbers
(D) reference

Comments

Source: This question is taken from the Microsoft Excel MCQs

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

Source: This question is taken from the Microsoft Excel MCQs

Latest MCQs

User developed instruction for excel are called__________...?

(A) Progrms
(B) Macros

(C) Procedured
(D) All of these

Comments

Source: This question is taken from the Microsoft Excel MCQs

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

Source: This question is taken from the Punjab Police Sub Inspector Service Quota PPSC Past Paper

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

Source: This question is taken from the Microsoft Excel MCQs

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

Source: This question is taken from the Microsoft Word MCQs

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

Source: This question is taken from the Assistant BS-16 & Junior Clerk BS-11 Agriculture Department

Latest MCQs

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

(A) Changes
(B) Defense

(C) Risk
(D) Alak

Comments

Source: This question is taken from the Deputy Controller (BS-18) BISE Rawalpindi PPSC Past paper

Latest MCQs

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

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

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

Comments

Source: This question is taken from the Microsoft Excel MCQs

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

Source: This question is taken from the Administrative Officer (Bs-17), Administrator (Bs-16), Media Monitoring Officer (Bs-16), Information Officer (Bs-17), Estate Officer (Bs-16) 2024

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

Source: This question is taken from the Data Entry Operator in the Punjab Police 2020

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

Source: This question is taken from the Assistant Sub Inspector Punjab Police 2021

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

Source: This question is taken from the Canal Patwari (BS-11) Irrigation ppsc past papers

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

Source: This question is taken from the Microsoft Excel MCQs

Latest MCQs

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

(A) 01
(B) 03

(C) 05
(D) 07

Comments

Source: This question is taken from the Lecturer Political Science Punjab Higher Education Department (Bs-17) 2022

Latest MCQs

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

(A) Data
(B) Tools

(C) Formatting
(D) Layout

Comments

Source: This question is taken from the Microsoft Excel MCQs

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

Source: This question is taken from the Microsoft Word MCQs

Latest MCQs

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

(A) nested
(B) round

(C) switch
(D) none of these

Comments

Source: This question is taken from the District Zakat Officer BS-17 PPSC past papers

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

Source: This question is taken from the Microsoft Excel MCQs

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

Source: This question is taken from the Data Entry Operator in the Punjab Police 2020

Latest MCQs

Constant value in excel also called ...?

(A) Number
(B) words

(C) mark
(D) None

Comments

Source: This question is taken from the Microsoft Excel MCQs

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

In Excel, pressing the "F11" key creates a new chart sheet based on the currently selected data range, essentially allowing you to quickly generate a chart from the highlighted cells in a separate chart sheet. 

Source: This question is taken from the Assistant (S&GAD) PPSC Past Paper 2024

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

Source: This question is taken from the Microsoft Excel MCQs

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

Source: This question is taken from the Canal Patwari (BS-11) Irrigation ppsc past papers

Latest MCQs

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

(A) /
(B) *

(C) $
(D) =

Comments

Source: This question is taken from the Microsoft Excel MCQs

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

Source: This question is taken from the Microsoft Excel MCQs

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

Source: This question is taken from the Data Entry Operator BS-14 Lahore High Court 2022

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

Source: This question is taken from the Microsoft Excel MCQs

Latest MCQs

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

(A) *
(B) +

(C) =
(D) $

Comments

Source: This question is taken from the Junior Computer Operator (Bs-12) Transport And Mass Transit Department, Irrigation Department PPSC 2024

Latest MCQs

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

(A) NUM
(B) COUNT

(C) SUM
(D) CHKNUM

Comments

Source: This question is taken from the Microsoft Excel MCQs

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

Source: This question is taken from the Microsoft Excel MCQs

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

Source: This question is taken from the Microsoft Excel MCQs

Latest MCQs

In Excel charts vertical axis are called...?

(A) Slot
(B) Z-axis

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

Comments

Source: This question is taken from the Microsoft Excel MCQs

Latest MCQs

Shortcut in excell to insert new sheet...?

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

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

Comments

Source: This question is taken from the Police Station Assistant (PSA) Batch 6th & 7th Past Paper

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

Source: This question is taken from the Microsoft Excel MCQs

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

Source: This question is taken from the Canal Patwari (BS-11) Irrigation ppsc past papers

Latest MCQs

Microsoft excel is a powerful______...?

(A) Spreadsheet package
(B) Word processing package

(C) DBMS package
(D) None

Comments

Source: This question is taken from the Microsoft Excel MCQs

Latest MCQs

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

(A) Colors
(B) Effects

(C) Fonts
(D) All of these

Comments

Source: This question is taken from the Punjab Police Sub Inspector (SI) Service Quota PPSC Past

Latest MCQs

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

(A) Spreadsheet
(B) Database

(C) Workbook
(D) None of these

Comments

Source: This question is taken from the Microsoft Excel MCQs

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

Source: This question is taken from the Microsoft Excel MCQs

Latest MCQs

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

(A) Data
(B) Tools

(C) Formatting
(D) Layout

Comments

Source: This question is taken from the Junior Computer Operator (Bs-12) Transport And Mass Transit Department, Irrigation Department PPSC 2024

Latest MCQs

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

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

(C) Deleting
(D) Sorting

Comments

Source: This question is taken from the Microsoft Excel MCQs

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

Source: This question is taken from the Clubbed Case Canal Patwari First Phase (Morning) 2023

Latest MCQs

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

(A) Cells
(B) Rows

(C) Columns
(D) Parentheses

Comments

Source: This question is taken from the Clubbed Case Canal Patwari First Phase (Morning) 2023

Latest MCQs

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

(A) Formula bar
(B) Status bar

(C) Name box
(D) Title bar

Comments

Source: This question is taken from the Microsoft Excel MCQs

Latest MCQs

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

(A) Worksheet
(B) Workbook

(C) Formula
(D) Location

Comments

Source: This question is taken from the Microsoft Excel MCQs

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

Source: This question is taken from the Microsoft Excel MCQs

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

Source: This question is taken from the Microsoft Excel MCQs

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

Source: This question is taken from the Microsoft Excel MCQs

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

Source: This question is taken from the Assistant Sub Inspector (ASI) Punjab Police Past Paper 2021

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

Source: This question is taken from the Microsoft Excel MCQs

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

Source: This question is taken from the Microsoft Excel MCQs

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

Source: This question is taken from the Canal Patwari (BS-11) Irrigation ppsc past papers

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

Source: This question is taken from the Microsoft Excel MCQs

Latest MCQs

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

(A) Data
(B) Table

(C) Cell
(D) Schema for:

Comments

Source: This question is taken from the Data Entry Operator in the Punjab Police 2020

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

Source: This question is taken from the Microsoft PowerPoint MCQs

Latest MCQs

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

(A) DELETE
(B) BACKSPACE

(C) PAGE DOWN
(D) END

Comments

Source: This question is taken from the Microsoft Excel MCQs

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

Source: This question is taken from the Junior Clerk Deputy Commissioner Office BOR

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

Source: This question is taken from the Microsoft Excel MCQs

Latest MCQs

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

(A) Dividend
(B) Remainder

(C) Quotient
(D) None of these

Comments

Source: This question is taken from the Microsoft Excel MCQs

MCQs Categories


Best of Luck

From ShineGk.com

Share our website's link