which key is used for help in MS 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

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

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

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

(A) Title Bar

(B) Status Bar

(C) Menu Bar

(D) Tool Bar

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

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

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

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

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

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

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

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

Maximum zoom percentage in Excel is _________...?

(A) 100%

(B) 300%

(C) 400%

(D) 500%

Source: This question is taken from the Microsoft Excel MCQs

How can you apply exactly the same formatting you did to another text in Ms Word...?

(A) Copy the text and click on Paste Special tool on new place

(B) Select the text then click on Format Painter and select the new text

(C) Copy the text and paste in new location. Then type the new text again

(D) All of above

Source: This question is taken from the Microsoft Word MCQs

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

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

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

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

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

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

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

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

(A) F1 Key

(B) F2 Key

(C) F3 Key

(D) F4 Key

Source: This question is taken from the Microsoft Excel MCQs

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

(A) ctrl + page down

(B) shift + page down

(C) page down

(D) none of these

Source: This question is taken from the Microsoft Excel MCQs

How can you apply exactly the same formatting you did to another text?...?

(A) Copy the text and paste in new location. then type the new text again

(B) copy the text and click on past special tool on new place

(C) select the text then click on format painter and select the new text

(D) All of these

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

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

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

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

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

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

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

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

(A) Home

(B) View

(C) Page Layout

(D) Insert

Source: This question is taken from the Tehsildar Past Paper PPSC Solved

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

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

MS excel is used to data...?

(A) Organize

(B) Share

(C) Communicate

(D) Obtain

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

MS Excel stands for_______...?

(A) Micromax Excel

(B) Microsoft Excel

(C) Micromax Excess

(D) Management Excel

Source: This question is taken from the Microsoft Excel MCQs

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

(A) Count the number of cells

(B) Searches for a value in a column and returns a value in the same row

(C) Calculate the average of values

(D) Sorts data in ascending order

Source: This question is taken from the Microsoft Excel MCQs

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

(A) F1 key

(B) F2 key

(C) F3 key

(D) F4 key

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

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

(A) Title bar

(B) Status bar

(C) Horizontal scroll bar

(D) Vertical scroll bar

Source: This question is taken from the Inspector Cooperative Societies (Bs-14) Cooperatives Department Punjab Public Service Commission (PPSC) Club-104

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

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

(A) AA

(B) A1

(C) Aa

(D) None of these

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

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

(A) Range

(B) Work book

(C) Document

(D) Cell

Source: This question is taken from the Microsoft Excel MCQs

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

(A) Graphic program

(B) Word Processor

(C) Presentation

(D) Spreadsheet

Source: This question is taken from the Sub Inspector BS 14 (open Marit) 2016

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

(A) organized data

(B) loss data

(C) gain data

(D) none of these

Source: This question is taken from the Microsoft Excel MCQs

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 Manager Auqaf BS 16 PPSC past papers solved

Which key deletes the character to the right of the cursor in MS Word:...?

(A) Delete

(B) Backspace

(C) End

(D) None of thee

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

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

(A) Ctrl+H

(B) Ctrl+7

(C) Ctrl+9

(D) None of the above

Source: This question is taken from the Microsoft Excel MCQs

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

(A) Database

(B) Spreadsheet

(C) Word processing

(D) None of these

Source: This question is taken from the Microsoft Excel MCQs

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 rows are in one Microsoft Excel sheet...?

(A) 65,536

(B) 16,384

(C) 1,048,576

(D) None of Above

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

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

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

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

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

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 will be the result of formula '=16/2^3' in a cell in MS Excel...?

(A) 512

(B) 124

(C) 2

(D) 124

Source: This question is taken from the Microsoft Excel MCQs

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

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

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

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

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

Source: This question is taken from the Microsoft Excel MCQs

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

(A) Average

(B) Count

(C) Minimum

(D) Maximum

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

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

(A) Tab

(B) Ctrl

(C) Shift

(D) Alt

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

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

(A) Press enter

(B) Use no border

(C) Use formula

(D) Not possible in MS Excel

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

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

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

(A) CTRL+Y

(B) F11

(C) ALT+F11

(D) All of these

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

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

(A) From Border tab in Format Cells dialog box

(B) From Border tool in Formatting toolbar

(C) From Line Style tool in Drawing toolbar

(D) we cannot set page border in Excel

Source: This question is taken from the Microsoft Excel MCQs

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

(A) Alphabetical order

(B) Capitalization

(C) Spelling

(D) Primary records

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

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

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

Short cut key ctrl + A use for __________...?

(A) To Select All Text

(B) To copy

(C) To paste

(D) None

Source: This question is taken from the Microsoft Word MCQs

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

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

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

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

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

(A) Ctrl

(B) Shift

(C) Alt

(D) Tab

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

The shortcut key to close a selected window is...?

(A) Alt + F4

(B) Ctrl + F4

(C) Alt + F5

(D) Alt + F3

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

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

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

(A) Dividend

(B) Remainder

(C) Quotient

(D) None of these

Source: This question is taken from the Microsoft Excel MCQs

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

(A) SUM

(B) AVG

(C) MAX

(D) MIN

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

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

(A) Formula Bar

(B) Status Bar

(C) Title Bar

(D) Scroll Bar

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

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

(A) Program

(B) Macros

(C) Procedure

(D) All of these

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

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

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

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

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

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

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

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

(D) All of these

Source: This question is taken from the Microsoft Excel MCQs

To select multiple cells, rows, or columns in a table that are not adjacent to one another, select the first cell and then hold down the ________ key while selecting the next cell, row, or column....?

(A) alt

(B) shift

(C) enter

(D) ctrl

Source: This question is taken from the Microsoft Word MCQs

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

(A) 65,536

(B) 16,384

(C) 1,048,576

(D) None of Above

Source: This question is taken from the Microsoft Excel MCQs

In MS Word. "Delete" key delete letters from the side of curser...?

(A) Right

(B) Up

(C) Down

(D) Left

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

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

Which value remain unchanged in Ms Excel...?

(A) constant

(B) variable

(C) function

(D) none

Source: This question is taken from the Microsoft Excel MCQs

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

(A) Data

(B) Table

(C) Cell

(D) Schema for:

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

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

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

(A) Proper

(B) Upper case

(C) Capitalize

(D) None of these

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

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

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

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

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

What is a Macro in MS Excel...?

(A) A single instruction that performs a specific task

(B) A set of instructions that can be executed as a single command

(C) A type of chart or graph used for data visualization

(D) A feature that allows users to create and edit images

Source: This question is taken from the Microsoft Excel MCQs

MS Excel is based on: _____________...?

(A) UNIX

(B) DOS

(C) WINDOWS

(D) OS/2

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

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

(A) 2

(B) 3

(C) 4

(D) 5

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

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

(A) Ctrl + Page Down

(B) Shift + Page Down

(C) Page Down

(D) None of these

Source: This question is taken from the Microsoft Excel MCQs

Selected cell of excel...?

(A) Active Cell

(B) Cell No

(C) Formula cell

(D) None Of These

Source: This question is taken from the Senior Station Assistant (SSA) batch 6th & 7th Past Paper

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

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

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

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

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

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

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

(A) Ctrl+4

(B) Ctrl+5

(C) Ctrl+6

(D) None of the above.

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

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

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

Constant value in excel also called ...?

(A) Number

(B) words

(C) mark

(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

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

(A) Rows

(B) Cells

(C) Columns

(D) Parentheses

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

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

Which of the following is the key to close a run dialog box in window...?

(A) SHIFT

(B) ESC

(C) TAB

(D) F8

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

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

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

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

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

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

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

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

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

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

(A) +

(B) -

(C) =

(D) [

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

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

(A) wrap text

(B) text wrap

(C) letter warp

(D) word wrap

Source: This question is taken from the Microsoft Excel MCQs

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

(A) Goal seekyears?

(B) Gabriel's wing

(C) n M rightly guided

(D) Auto Outline

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

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

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

(A) 10

(B) 100

(C) 300

(D) 500

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

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

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)

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

(A) F10

(B) F12

(C) F11

(D) None

Source: This question is taken from the Microsoft Excel MCQs

Letters in Excel denote :...?

(A) Columns

(B) rows

(C) numbers

(D) reference

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

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

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

(A) Dotted line

(B) Double line

(C) Wide bold line

(D) Single line

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

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

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

(A) $

(B) +

(C) #

(D) =

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

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

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

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

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

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

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

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

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

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

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

(A) ctrl +

(B) ctrl +;

(C) ctrl +:

(D) ctrl +'

Source: This question is taken from the Microsoft Excel MCQs

Maximum zoom percentage in Ms excel...?

(A) 300%

(B) 200%

(C) 400%

(D) 500%

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

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 of the following function rotate the contents of columns to rows and rows to columns in Microsoft Excel...?

(A) switching

(B) transpose

(C) matrix

(D) none

Source: This question is taken from the Microsoft Excel MCQs

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

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

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

What does Ctrl + = key effect...?

(A) Superscript

(B) Subscript

(C) All Caps

(D) Shadow

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

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

(A) Validation

(B) Formats

(C) Formulas

(D) All of these

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

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

(A) *

(B) +

(C) =

(D) $

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

_________ 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

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

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 deletes the character to the left of the cursor...?

(A) End

(B) Backspace

(C) Home

(D) Delete

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

Which key deletes the character to the right of the cursor in Ms Word...?

(A) End

(B) Backspace

(C) Home

(D) Delete

Source: This question is taken from the Microsoft Word MCQs

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

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

(A) :

(B) =

(C) #

(D) ~

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

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

______ 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

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

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

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

_____ 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

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

(A) + and –

(B) !and ^

(C) *and

(D) < and >

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

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

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

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

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

#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

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

In Microsoft Word shortcut key CTRL+W is used for___________...?

(A) open the Print dialog box

(B) Update the current Web page

(C) close the current window

(D) None of these

Source: This question is taken from the Microsoft Word MCQs

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

(A) Shift + F8

(B) Shift + F9

(C) Shift + F10

(D) Shift + F11

Source: This question is taken from the Microsoft Excel MCQs

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

(A) Blocks

(B) Rows

(C) Cells

(D) Columns

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

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

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

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

________________________ 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

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 Shortcut keys are used to strikethrough highlighted selections in MS Excel...?

(A) Ctrl+4

(B) Ctrl+5

(C) Ctrl+6

(D) None of these

Source: This question is taken from the Microsoft Excel MCQs

Who gave the cell theory...?

(A) Robert Hooke

(B) Ernst Haeckel

(C) Matthias Schleiden and Theodor Schwann

(D) Albrecht Von Roelliker

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

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

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

(A) to view the data from left to the right

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

(C) to view the data from right to the left

(D) None of these

Source: This question is taken from the Microsoft Excel MCQs

Letters in Excel denote: ______________...?

(A) Columns

(B) rows

(C) numbers

(D) reference

Source: This question is taken from the Microsoft Excel MCQs

Which value remains unchanged in MS Excel...?

(A) Constant

(B) Function

(C) Variable

(D) None of these

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

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

(A) Ctrl +r

(B) Ctrl +s

(C) Ctrl +c

(D) none

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

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

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

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

(A) .msxcl

(B) .xcl

(C) .xlsx

(D) .xlsm

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

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

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

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

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

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

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

(A) Menu Bar

(B) Title Bar

(C) Formula Bar

(D) None of these

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

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

(A) Cell Range

(B) Workbook

(C) Margin

(D) None of these

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

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

(A) add

(B) count

(C) sum

(D) None of these

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

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

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-

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

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

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

(A) Excel 2021

(B) Excel 2016

(C) Excel 2017

(D) Office 365

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

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

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

(A) Embedded

(B) Linked

(C) Hyperlink placed in word table

(D) None of these

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

# 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

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

(A) Number

(B) Character

(C) Babel

(D) Date/Time

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 is the correct form in MS Excel...?

(A) 6A

(B) A6

(C) AA6

(D) +A+

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

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

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

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

Source: This question is taken from the Microsoft Excel MCQs

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

(A) 1

(B) 10

(C) 11

(D) 21

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

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

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

(A) nested

(B) round

(C) switch

(D) none of these

Source: This question is taken from the District Zakat Officer BS-17 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

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

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

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

(A) Edit > Clear > All

(B) Edit > Clear > Contents

(C) Edit > Delete

(D) none

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

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

(A) 1200000

(B) 1048576

(C) 1020239

(D) None of these

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

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

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

(A) SUM

(B) AVG

(C) MAX

(D) MIN

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

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

(A) Volume

(B) Line

(C) Pie

(D) Bar