Excel is a ....? Mcqs

Excel is a ....?

(A) Graphic program

(B) Word Processor

(C) A spreedsheet Program

(D) Deisgining Template

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

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

(A) SUMB

(B) AVG

(C) MAX

(D) MIN

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

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

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

(A) Shift+Backspace

(B) Crtl+Backspace

(C) Alt+Backspace

(D) none

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

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

Source: This question is taken from the Microsoft Excel MCQs

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

(A) Table

(B) Record

(C) Field

(D) Cell

Source: This question is taken from the Microsoft Excel MCQs

MS Excel Formula starts with__________...?

(A) .

(B) _

(C) =

(D) none

Source: This question is taken from the Microsoft Excel MCQs

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

(A) Ascending order

(B) Descending order

(C) Both A & B

(D) None of these

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

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

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

Source: This question is taken from the Assistant Punjab Police Department PPSC Past Paper

IF function used in Excel for _____...?

(A) Performing logical comparisons

(B) Formatting text

(C) Creating charts

(D) None of these

Source: This question is taken from the Manager Auqaf BS 16 PPSC past papers solved

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

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

Source: This question is taken from the Microsoft Excel MCQs

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

(A) Worksheet

(B) Workbook

(C) Formula

(D) Location

Source: This question is taken from the Microsoft Excel MCQs

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

(A) A1-B1

(B) A1:A10

(C) A1 to A10

(D) A1-A10

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

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

(A) Date()

(B) Year()

(C) Now()

(D) Time()

Source: This question is taken from the Microsoft Excel MCQs

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

(A) Distributed

(B) Center

(C) Justify

(D) None of these

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

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

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

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

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

Source: This question is taken from the Microsoft Excel MCQs

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

(A) Date ()

(B) Today ()

(C) Year ()

(D) Now ()

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

Source: This question is taken from the Microsoft Excel MCQs

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

(A) F1

(B) F3

(C) F6

(D) F5

Source: This question is taken from the Microsoft Excel MCQs

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

(A) Cell

(B) Graph

(C) Function

(D) Range

Source: This question is taken from the Microsoft Excel MCQs

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

(A) F1

(B) F2

(C) F3

(D) NONE OF THESE

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

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

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

(A) !=

(B) ~=

(C) <>

(D) None of these

Source: This question is taken from the Microsoft Excel MCQs

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

(A) Name box

(B) Cell tip

(C) Both

(D) None of these

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

Source: This question is taken from the Punjab Police Junior Clerk BS-11 PPSC Past Paper

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

(A) %

(B) +

(C) /

(D) None of these

Source: This question is taken from the Microsoft Excel MCQs

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

(A) File

(B) Insert

(C) Design

(D) None of these

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

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

(A) Cell

(B) Graph

(C) Function

(D) Range

Source: This question is taken from the Microsoft Excel MCQs

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

(A) Tab

(B) Shift

(C) Space

(D) None of these

Source: This question is taken from the Junior Computer Operator PPSC Past Paper 2024

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

(A) Ctrl + Shift + 0

(B) Ctrl + alt+ 0

(C) Shift + 0

(D) Ctrl+0

Source: This question is taken from the Police Station Assistant (PSA) Batch 8 Past Paper

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

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

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

Source: This question is taken from the Microsoft Excel MCQs

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

(A) 26, 30

(B) AA30

(C) A2630Y

(D) None of these

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

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

(A) XFD

(B) ZZZ

(C) ZXF

(D) ZAZ

Source: This question is taken from the Microsoft Excel MCQs

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

(A) 16,284

(B) 16,384

(C) 16,584

(D) None of these

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

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

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

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

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

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

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

Source: This question is taken from the Junior Clerk Service and General Administration (S&GAD)

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

(A) 10 hours

(B) 10 minutes

(C) 10 second

(D) None of these

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

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

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

_____ 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

Source: This question is taken from the Microsoft Excel MCQs

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

(A) File

(B) Count

(C) Table

(D) None of these

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

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

(A) File

(B) Chart

(C) Insert

(D) None of these

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

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

(A) Workbook

(B) Worksheet

(C) Note sheet

(D) Notebook

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

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

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

Source: This question is taken from the Microsoft Excel MCQs

_______ displays the content of active cell...?

(A) Row headings

(B) Name box

(C) Formula bar

(D) None of these

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

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

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

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

Source: This question is taken from the Junior Clerk Service and General Administration (S&GAD)

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

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

Source: This question is taken from the Microsoft Excel MCQs

Columns in MS Excel are called...?

(A) Fields

(B) Chart

(C) Both

(D) None of these

Source: This question is taken from the Microsoft Excel MCQs

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

(A) $

(B) @

(C) &

(D) %

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

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

(A) A, B, C

(B) A1, A2, A3

(C) 1, 2, 3

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

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

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

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

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

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

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

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

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

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

Source: This question is taken from the Microsoft Excel MCQs

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

(A) =ADD()

(B) =SUM()

(C) =TOTAL()

(D) =PLUS()

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

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

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

(A) AA

(B) Aa

(C) A1

(D) None of these

Source: This question is taken from the Microsoft Excel MCQs

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

(A) Title bar

(B) Menu bar

(C) Formula bar

(D) Standard toolbar

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

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

(A) Name Box

(B) Formula Bar

(C) Row Headings

(D) None of these

Source: This question is taken from the Junior Clerk (BS-11) Board of Revenue PPSC Past Paper

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

(A) Colors

(B) Effects

(C) Fonts

(D) All of these

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

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

(A) SQR

(B) SQRT

(C) SQUARE

(D) None of these

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

Source: This question is taken from the Microsoft Excel MCQs

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

(A) Ctrl+ ”

(B) Ctrl+ ;

(C) Ctrl+ :

(D) Ctrl+ ‘

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

Source: This question is taken from the Naib Tehsildar General Knowledge PPSC Past Paper

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

(A) Data

(B) Tools

(C) Formatting

(D) Layout

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

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

(A) Shift

(B) Esc

(C) Tab

(D) Space

Source: This question is taken from the Microsoft Excel MCQs

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

(A) Number

(B) Character

(C) Label

(D) Date

Source: This question is taken from the Assistant (bs-16) various departments Clubbed Case-74-2024 PPSC Past Paper (Morning)

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

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

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

Source: This question is taken from the Assistant Punjab Police Department PPSC Past Paper

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

(A) 0.5"

(B) 1"

(C) 0.75"

(D) 1.25"

Source: This question is taken from the Corporal (Bs-11) Counter Terrorism Department, Punjab Police PPSC Past Paper 11-08-2024

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

Source: This question is taken from the Microsoft Excel MCQs

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

(A) Insert Tab

(B) Page layout

(C) View Tab

(D) Home Tab

Source: This question is taken from the Microsoft Excel MCQs

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

(A) Ctrl+:

(B) Ctrl+Shift:

(C) Ctrl+;

(D) None of these

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

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

Source: This question is taken from the Microsoft Excel MCQs

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

(A) .Xlsx

(B) .Xls

(C) .excel

(D) .123

Source: This question is taken from the Microsoft Excel MCQs

Microsoft excel is a powerful______...?

(A) Spreadsheet package

(B) Word processing package

(C) DBMS package

(D) None

Source: This question is taken from the Microsoft Excel MCQs

MS Excel is commonly used to...?

(A) Database

(B) Organize Data

(C) Information

(D) None of these

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

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

(A) Goal seek

(B) Solver

(C) Scenario Manager

(D) All of above

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

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

Source: This question is taken from the Microsoft Excel MCQs

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

(A) Boolean

(B) Tupal

(C) Dictionary

(D) None of these

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

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

Worksheet in excel by default ___...?

(A) 3

(B) 2

(C) 1

(D) 4

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

Source: This question is taken from the Microsoft Excel MCQs

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

(A) Range

(B) Workbook

(C) Document

(D) cell

Source: This question is taken from the Assistant Director Intelligence BS-17 PPSC past Papers

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

(A) Number

(B) Label

(C) Character

(D) none

Source: This question is taken from the Microsoft Excel MCQs

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

(A) Smart tip

(B) Vip tip

(C) Soft tip

(D) Cell tips

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

Source: This question is taken from the Microsoft Excel MCQs

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

(A) DELETE

(B) BACKSPACE

(C) PAGE DOWN

(D) END

Source: This question is taken from the Microsoft Excel MCQs

Default file name in MS Excel is...?

(A) Document 1

(B) Workbook 1

(C) Book1

(D) Worksheet

Source: This question is taken from the Microsoft Excel MCQs

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

(A) CRTL+ =

(B) ALT + =

(C) ALT + S

(D) CTRL + ALT+ =

Source: This question is taken from the Microsoft Excel MCQs

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

(A) Label

(B) Value

(C) Formula

(D) Text string

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

Source: This question is taken from the Microsoft Excel MCQs

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

(A) * and?

(B) < and >

(C) ^ and /

(D) None of these

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

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

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

Source: This question is taken from the Microsoft Word MCQs

Number of default worksheets in MS Excel...?

(A) 2

(B) 3

(C) 4

(D) 5

Source: This question is taken from the Microsoft Excel MCQs

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

(A) 5

(B) 625

(C) 320

(D) 232

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

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

(A) Enter

(B) Ctrl+Enter

(C) Tab

(D) None

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

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

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

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

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

(A) Formulas

(B) Formatting

(C) Filters

(D) Insertions

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

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

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

Source: This question is taken from the Microsoft PowerPoint MCQs

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

(A) SUM

(B) MAX

(C) MIN

(D) AVG

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

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

(A) Freezing row

(B) Freezing column

(C) Freezing pane

(D) None of these

Source: This question is taken from the Naib Tehsildar General Knowledge PPSC Past Paper

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

(A) Range of cell

(B) Cell column

(C) Cell Row

(D) None of these

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

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

Source: This question is taken from the Assistant director (Bs-17) local government & community development department PPSC 2024

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

Source: This question is taken from the Microsoft Word MCQs

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

(A) 20

(B) 13

(C) 14

(D) 15

Source: This question is taken from the Microsoft Excel MCQs

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

(A) 1

(B) 2

(C) 3

(D) 5

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

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

How columns are numbered in MS Excel...?

(A) Numeric

(B) Alphabetic

(C) Roman

(D) None

Source: This question is taken from the Microsoft Excel MCQs

An excel workbook is a collection of__________...?

(A) Worksheets& Charts

(B) Slides

(C) Pages

(D) documents

Source: This question is taken from the Intelligence Officer (Bs-14) Punjab Police, Special Branch Assistant (Bs-16) Cooperatives Department PPSC Past Paper 2024

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

(A) Workbook

(B) Worksheet

(C) Notesheet

(D) Notebook

Source: This question is taken from the Microsoft Excel MCQs

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

(A) DATE()

(B) NOW()

(C) TODAY()

(D) CURRENT_DATE()

Source: This question is taken from the Microsoft Excel MCQs

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

(A) Thumbnails

(B) Thread

(C) Absolute reference

(D) None of these

Source: This question is taken from the Microsoft Excel MCQs

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

(A) 10

(B) 100

(C) 300

(D) 500

Source: This question is taken from the Microsoft Excel MCQs

What is a cell in Excel...?

(A) A row

(B) A column

(C) A unit of data

(D) A unit of formatting

Source: This question is taken from the Microsoft Excel MCQs

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

(A) tab

(B) backspace

(C) home

(D) enter

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

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

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

(A) Title

(B) slide number

(C) header

(D) footer

Source: This question is taken from the Microsoft PowerPoint MCQs

MS Excel sheet consists of __________...?

(A) Text boxes

(B) Rows & Columns

(C) Pictures & Drawings

(D) Rows & Text

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

Source: This question is taken from the Microsoft Excel MCQs

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

(A) Workbooks

(B) Worksheets

(C) Charts

(D) Worksheets and Charts

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

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

(A) Ctrl + Shift + ;

(B) Ctrl + Shift + :

(C) Ctrl + ;

(D) Ctrl + !

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

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

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

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

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

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

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

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

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

Source: This question is taken from the Microsoft Excel MCQs

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

(A) /

(B) =

(C) +

(D) &

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

What is a cell in Excel...?

(A) A row

(B) A column

(C) A unit of data

(D) A unit of formatting

Source: This question is taken from the Junior Clerk (BS-11) Board of Revenue PPSC Past Paper

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

(A) File

(B) Insert

(C) Design

(D) None of these

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

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

Source: This question is taken from the Microsoft Excel MCQs

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

(A) Formula bar

(B) Status bar

(C) Tool bar

(D) Menu bar

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

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)

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

Source: This question is taken from the Microsoft Excel MCQs

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

(A) Review

(B) View

(C) Insert

(D) Page layout

Source: This question is taken from the Microsoft Excel MCQs

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

(A) Cell

(B) Row

(C) Colomn

(D) Parenthesis

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

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

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

Source: This question is taken from the Microsoft Excel MCQs

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

(A) CTRL+F5

(B) CTRL+F11

(C) Windows Key + Down Arrow

(D) None of these

Source: This question is taken from the OFFICE ASSISTANT (BS-16) Housing Urban Development

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

(A) Tab

(B) Ctrl+Enter

(C) Enter

(D) Alt+Enter

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

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

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

(A) TOTAL

(B) ADD

(C) SUM

(D) AVG

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

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

(A) F2

(B) F10

(C) F4

(D) F8

Source: This question is taken from the Microsoft Excel MCQs

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

(A) 4

(B) 5

(C) 3

(D) 2

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

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

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

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

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

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

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

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

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

(A) +and -

(B) ; and ^

(C) * and ?

(D) <and >

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

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

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

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

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

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

(A) Volume

(B) Line

(C) Pie

(D) Bar

Source: This question is taken from the Junior Computer Operator PPSC Past Paper 2024

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

(A) .xlsx

(B) .doc

(C) .ppt

(D) .pdf

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

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

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

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

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

Source: This question is taken from the Microsoft Excel MCQs

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

(A) Alt+F1

(B) F2

(C) F3

(D) F4

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

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

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

Source: This question is taken from the Microsoft Excel MCQs

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

(A) Ascending order

(B) Descending order

(C) Both A & B

(D) None of these

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

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

(A) Rectangular box

(B) Pointer

(C) Nearing point of view

(D) None of the above

Source: This question is taken from the Microsoft Excel MCQs

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

(A) F4

(B) F5

(C) F6

(D) None of these

Source: This question is taken from the Microsoft Excel MCQs

User developed instruction for excel are called__________...?

(A) Progrms

(B) Macros

(C) Procedured

(D) All of these

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

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

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

Source: This question is taken from the Microsoft Excel MCQs

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

(A) Copy-pasting

(B) Linking or Referencing

(C) Deleting

(D) Sorting

Source: This question is taken from the Microsoft Excel MCQs

Shortcut in excell to insert new sheet...?

(A) Shift+F6

(B) Shift+F12

(C) Shift+F11

(D) Shift+A1

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

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

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

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

In Excel charts vertical axis are called...?

(A) Slot

(B) Z-axis

(C) Y-axis

(D) X-axis

Source: This question is taken from the Microsoft Excel MCQs

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

(A) 6

(B) 7

(C) 8

(D) 5

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

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

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

Source: This question is taken from the Microsoft Excel MCQs

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

(A) F1

(B) F2

(C) F3

(D) None of these

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

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

Source: This question is taken from the Microsoft Excel MCQs

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

(A) 256

(B) 1024

(C) 32767

(D) 65535

Source: This question is taken from the Microsoft Excel MCQs

MS Excel is a ______...?

(A) Spreadsheet program

(B) Multimedia software

(C) Entertainment software

(D) None of these

Source: This question is taken from the Microsoft Excel MCQs

Constant value in excel also called ...?

(A) Number

(B) words

(C) mark

(D) None

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

Source: This question is taken from the Microsoft Excel MCQs

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

(A) Height & Width

(B) Layers & Planes

(C) Columns & Rows

(D) Lines & Spaces

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

Source: This question is taken from the Microsoft Word MCQs

Formula in Excell starts with...?

(A) +

(B) -

(C) =

(D) [

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

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

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

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

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

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

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

(A) 1

(B) 4

(C) 7

(D) 9

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

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

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

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

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

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

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

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

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

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

Source: This question is taken from the Microsoft Excel MCQs

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

(A) Cell address

(B) Range

(C) Formula

(D) Current cell

Source: This question is taken from the Microsoft Excel MCQs

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

(A) Worksheet

(B) Workbook

(C) Formula

(D) Location

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

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

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

Source: This question is taken from the Corporal (Bs-11) Counter Terrorism Department, Punjab Police PPSC Past Paper 11-08-2024

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

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

Source: This question is taken from the Junior Computer Operator PPSC Past Paper 2024

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

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

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

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

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

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

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

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

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

(A) Worksheets

(B) Charts

(C) Both A & B

(D) None of these

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

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

(A) Formula bar

(B) Status bar

(C) Name box

(D) Title bar

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

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

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

(A) Formula

(B) Command

(C) Operation

(D) None of these

Source: This question is taken from the Junior Computer Operator PPSC Past Paper 2024

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

Source: This question is taken from the Microsoft Excel MCQs

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

(A) Range

(B) Workbook

(C) Document

(D) Cell

Source: This question is taken from the Assistant Director Intelligence BS-17 Punjab Police

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

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

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

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

(A) Worksheets and Charts

(B) Charts

(C) Worksheets

(D) Workbooks

Source: This question is taken from the Microsoft Excel MCQs

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

(A) space

(B) comma

(C) asterik

(D) None of these

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

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

(A) Database

(B) Text Document

(C) Spreadsheet

(D) Workbook

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

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

(A) 100

(B) 50

(C) 256

(D) None of these

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

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