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

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

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

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

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

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

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

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

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

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

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

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

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

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 Paste Special tool on new place

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

(D) All of above

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

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

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

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

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

______ 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

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

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

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

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

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

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

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

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

MS Excel is based on :...?

(A) UNIX

(B) DOS

(C) WINDOWS

(D) OS/2

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

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

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

MS Excel Formula starts with__________...?

(A) .

(B) _

(C) =

(D) none

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

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

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

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

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

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

(A) /

(B) *

(C) $

(D) =

Source: This question is taken from the Microsoft Excel MCQs

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

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

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

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

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

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 value remain unchanged in Ms Excel...?

(A) constant

(B) variable

(C) function

(D) none

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

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

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

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

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

Worksheet in excel by default ___...?

(A) 3

(B) 2

(C) 1

(D) 4

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

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

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

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

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

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

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

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

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

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

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

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

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

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

_________ 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

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

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

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

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

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

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

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

(A) 01

(B) 03

(C) 05

(D) 07

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

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

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

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

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

(A) 3

(B) 4

(C) 5

(D) 6

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

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

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

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

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

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

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

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

MS Excel is based on: _____________...?

(A) UNIX

(B) DOS

(C) WINDOWS

(D) OS/2

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

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

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

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

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

#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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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 symbol is used for division in Excel...?

(A) /

(B) *

(C) +

(D) .

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

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

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

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

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

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 the following term does not pertain to Excel...?

(A) Browser

(B) Columns

(C) Work Book

(D) None of these

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

_____ 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

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

___________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

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

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

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

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

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

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

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

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

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

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

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

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

(A) Wrap text

(B) Click next

(C) All

(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

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

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

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

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

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

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

Letters in Excel denote: ______________...?

(A) Columns

(B) rows

(C) numbers

(D) reference

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

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

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

Which formula is used to find the number of numerical cells in a range of cells in Excel...?

(A) COUNTIF

(B) COUNT

(C) COUNTA

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

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

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

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

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

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

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

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)

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

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

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

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

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

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

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

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

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

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

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

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

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

_______ 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

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

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

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

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

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

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

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

Which key deletes the character to the left of the cursor...?

(A) End

(B) Backspace

(C) Home

(D) Delete