MS excel is used to data...? Mcqs

Latest MCQs

MS excel is used to data...?

(A) Organize
(B) Share

(C) Communicate
(D) Obtain

✅ Correct Answer: Organize

Comments

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

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

✅ Correct Answer: File

Comments

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

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

✅ Correct Answer: Formation

Comments

Source: This question is taken from the Microsoft Word MCQs

Latest MCQs

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

(A) /
(B) *

(C) $
(D) =

✅ Correct Answer: =

Comments

Source: This question is taken from the Microsoft Excel MCQs

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-

✅ Correct Answer: Pressing the Esc key-

Comments

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

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

✅ Correct Answer: = A1+A2

Comments

Source: This question is taken from the Microsoft Excel MCQs

Latest MCQs

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

(A) Cells
(B) Rows

(C) Columns
(D) Parentheses

✅ Correct Answer: Parentheses

Comments

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

Latest MCQs

Excel is a ....?

(A) Graphic program
(B) Word Processor

(C) A spreedsheet Program
(D) Deisgining Template

✅ Correct Answer: A spreedsheet Program

Comments

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

Latest MCQs

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

(A) Name box
(B) Cell tip

(C) Both
(D) None of these

✅ Correct Answer: Name box

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

✅ Correct Answer: F2 key

Comments

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

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

✅ Correct Answer: System unit

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

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

✅ Correct Answer: Fill Handle

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

✅ Correct Answer: Equal Sign

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

✅ Correct Answer: * and?

Comments

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

Latest MCQs

Letters in Excel denote: ______________...?

(A) Columns
(B) rows

(C) numbers
(D) reference

✅ Correct Answer: Columns

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

✅ Correct Answer: 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

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

✅ Correct Answer: Excel

Comments

Source: This question is taken from the Microsoft Excel MCQs

Latest MCQs

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

(A) NUM
(B) COUNT

(C) SUM
(D) CHKNUM

✅ Correct Answer: COUNT

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 ledger
(B) A table

(C) A workbook
(D) None of these

✅ Correct Answer: A workbook

Comments

Source: This question is taken from the Microsoft Excel MCQs

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

✅ Correct Answer: 1, 2, 3, etc.

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

✅ Correct Answer: Ctrl + Shift +:

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

✅ Correct Answer: Ctrl + Shift + ;

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

✅ Correct Answer: F2 Key

Comments

Source: This question is taken from the Microsoft Excel MCQs

Latest MCQs

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

(A) Wrap text
(B) Click next

(C) All
(D) None

✅ Correct Answer: Wrap text

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

✅ Correct Answer: =SUM()

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

✅ Correct Answer: Spreadsheet program

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

✅ Correct Answer: Sort

Comments

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

Latest MCQs

MS Excel stands for_______...?

(A) Micromax Excel
(B) Microsoft Excel

(C) Micromax Excess
(D) Management Excel

✅ Correct Answer: Microsoft Excel

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

✅ Correct Answer: Columns

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

✅ Correct Answer: Formula bar

Comments

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

Latest MCQs

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

(A) Changes
(B) Defense

(C) Risk
(D) Alak

✅ Correct Answer: Changes

Comments

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

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

✅ Correct Answer: A workbook

Comments

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

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

✅ Correct Answer: Fill the selection with active cells to the right

Comments

Source: This question is taken from the Microsoft Excel MCQs

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)

✅ Correct Answer: =sum(A1:A2)

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

(A) Slot
(B) Z-axis

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

✅ Correct Answer: Y-axis

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

✅ Correct Answer: Formulas

Comments

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

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

✅ Correct Answer: Range

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

✅ Correct Answer: None of these

Comments

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

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

✅ Correct Answer: Freeze Panes

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

✅ Correct Answer: Macros

Comments

Source: This question is taken from the Microsoft Excel MCQs

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

✅ Correct Answer: CTRL + space

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

✅ Correct Answer: Insert a new worksheet

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

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

(A) Menu Bar
(B) Title Bar

(C) Formula Bar
(D) None of these

✅ Correct Answer: Formula Bar

Comments

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

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

✅ Correct Answer: Merge & Center

Comments

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

Latest MCQs

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

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

(C) Deleting
(D) Sorting

✅ Correct Answer: Linking or Referencing

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 these

✅ Correct Answer: File

Comments

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

Latest MCQs

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

(A) Formula Bar
(B) Status Bar

(C) Title Bar
(D) Scroll Bar

✅ Correct Answer: Status Bar

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 table ...........?

(A) Hash
(B) Equal Sign

(C) Apostrophe
(D) Tide

✅ Correct Answer: Equal Sign

Comments

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

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

✅ Correct Answer: A horizontal axis

Comments

Source: This question is taken from the Microsoft Excel MCQs

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

✅ Correct Answer: Searches for a value in the column

Comments

Source: This question is taken from the Canal Patwari (BS-11) Irrigation ppsc 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+ ‘

✅ Correct Answer: Ctrl+ ‘

Comments

Source: This question is taken from the Microsoft Excel MCQs

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

✅ Correct Answer: Position the mouse pointer over the cell

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

✅ Correct Answer: Pressing the Esc key

Comments

Source: This question is taken from the Microsoft Excel MCQs

Latest MCQs

Constant value in excel also called ...?

(A) Number
(B) words

(C) mark
(D) None

✅ Correct Answer: Number

Comments

Source: This question is taken from the Microsoft Excel MCQs

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

✅ Correct Answer: Both value and cell references

Comments

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

Latest MCQs

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

(A) *
(B) +

(C) =
(D) $

✅ Correct Answer: =

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

✅ Correct Answer: Vertical Lookup

Comments

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

Latest MCQs

Formula in Excell starts with...?

(A) +
(B) -

(C) =
(D) [

✅ Correct Answer: =

Comments

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

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

✅ Correct Answer: Merging

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) Formula
(B) Formating

(C) Filters
(D) None of these

✅ Correct Answer: Formula

Comments

Source: This question is taken from the Microsoft Excel MCQs

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

✅ Correct Answer: All 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

✅ Correct Answer: A row or column of numbers that are plotted in a chart

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

✅ Correct Answer: Spreadsheet

Comments

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

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

✅ Correct Answer: ctrl +

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

✅ Correct Answer: Data

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

(A) File
(B) Count

(C) Table
(D) None of these

✅ Correct Answer: File

Comments

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

Latest MCQs

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

(A) space
(B) comma

(C) asterik
(D) None of these

✅ Correct Answer: space

Comments

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

Latest MCQs

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

(A) Worksheet
(B) Workbook

(C) Formula
(D) Location

✅ Correct Answer: Workbook

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

✅ Correct Answer: Filtering

Comments

Source: This question is taken from the Microsoft Excel MCQs

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

✅ Correct Answer: Clear All

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

✅ Correct Answer: MAX

Comments

Source: This question is taken from the Microsoft Excel MCQs

Latest MCQs

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

(A) Paper Size
(B) Page Layout

(C) Column width
(D) None of these

✅ Correct Answer: Column width

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

✅ Correct Answer: Record

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

✅ Correct Answer: Format number in comma format

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

✅ Correct Answer: Remainder

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

✅ Correct Answer: Ctrl + “

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) AVG
(B) MAX

(C) LRG
(D) None of these

✅ Correct Answer: MAX

Comments

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

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

✅ Correct Answer: data validation

Comments

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

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

✅ Correct Answer: Active Cell Highlighting

Comments

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

Latest MCQs

Processed Data called...?

(A) Raw Data
(B) Facts Data

(C) Information
(D) None of these

✅ Correct Answer: Information

Comments

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

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

✅ Correct Answer: Ctrl + H

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

✅ Correct Answer: File

Comments

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

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

✅ Correct Answer: Auto fill

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

✅ Correct Answer: Data

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

✅ Correct Answer: File

Comments

Source: This question is taken from the Microsoft Excel MCQs

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

✅ Correct Answer: Pressing Esc key

Comments

Source: This question is taken from the Microsoft Excel MCQs

Latest MCQs

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

(A) DELETE
(B) BACKSPACE

(C) PAGE DOWN
(D) END

✅ Correct Answer: DELETE

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

✅ Correct Answer: Single colon

Comments

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

Latest MCQs

Microsoft excel is a powerful______...?

(A) Spreadsheet package
(B) Word processing package

(C) DBMS package
(D) None

✅ Correct Answer: Spreadsheet package

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

✅ Correct Answer: 03

Comments

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

Latest MCQs

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

(A) Worksheet
(B) Workbook

(C) Formula
(D) Location

✅ Correct Answer: Workbook

Comments

Source: This question is taken from the Microsoft Excel MCQs

Latest MCQs

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

(A) Spreadsheet
(B) Database

(C) Workbook
(D) None of these

✅ Correct Answer: Spreadsheet

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

✅ Correct Answer: ctrl +'

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

✅ Correct Answer: Formula bar

Comments

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

Latest MCQs

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

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

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

✅ Correct Answer: =PRODUCT()

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:

✅ Correct Answer: Cell

Comments

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

Latest MCQs

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

(A) Colors
(B) Effects

(C) Fonts
(D) All of these

✅ Correct Answer: All of these

Comments

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

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

✅ Correct Answer: Single colon

Comments

Source: This question is taken from the Microsoft PowerPoint MCQs

Latest MCQs

Shortcut in excell to insert new sheet...?

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

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

✅ Correct Answer: Shift+F11

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

✅ Correct Answer: 3

Comments

Source: This question is taken from the Microsoft Excel MCQs

Latest MCQs

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

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

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

✅ Correct Answer: Columns & Rows

Comments

Source: This question is taken from the Microsoft Excel MCQs

Latest MCQs

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

(A) Program
(B) Macros

(C) Procedure
(D) All of these

✅ Correct Answer: Macros

Comments

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

Latest MCQs

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

(A) /
(B) =

(C) +
(D) &

✅ Correct Answer: =

Comments

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

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)

✅ Correct Answer: =sum(A1:A2)

Comments

Source: This question is taken from the Microsoft Excel MCQs

Latest MCQs

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

(A) nested
(B) round

(C) switch
(D) none of these

✅ Correct Answer: nested

Comments

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

Latest MCQs

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

(A) Formula bar
(B) Status bar

(C) Name box
(D) Title bar

✅ Correct Answer: Name box

Comments

Source: This question is taken from the Microsoft Excel MCQs

Latest MCQs

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

(A) Spreadsheet
(B) Document

(C) Data management
(D) None of these

✅ Correct Answer: Spreadsheet

Comments

Source: This question is taken from the Microsoft Excel MCQs

Latest MCQs

Columns in MS Excel are called...?

(A) Fields
(B) Chart

(C) Both
(D) None of these

✅ Correct Answer: Fields

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.

✅ Correct Answer: double click the worksheet range object

Comments

Source: This question is taken from the Microsoft Word 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

✅ Correct Answer: Column letters and row numbers

Comments

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

Best of Luck

From ShineGk.com

Share our website's link