Ctrl + D in MS Excel is used for...? Mcqs

PPSC Past Papers

Latest MCQs

Ctrl + D in MS Excel is used for...?

(A) Fill down in the selection
(B) Open the font dialog box

(C) Both A and B
(D) None of these

Comments

Source: This question is taken from the Microsoft Excel MCQs

Latest MCQs

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

(A) .xlsx
(B) .doc

(C) .ppt
(D) .pdf

Comments

Source: This question is taken from the Microsoft Excel MCQs

Latest MCQs

Which option in Microsoft Excel will help you arrange, summarize and group large sets of data...?

(A) Illustrations
(B) Pivot table

(C) Sparkline
(D) Filter

Comments

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

Latest 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

Comments

Source: This question is taken from the Microsoft Excel MCQs

Latest MCQs

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

(A) .msxcl
(B) .xcl

(C) .xlsx
(D) .xlsm

Comments

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

Latest 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

Comments

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

Latest MCQs

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

(A) F1 key
(B) F2 key

(C) F3 key
(D) F4 key

Comments

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

Latest MCQs

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

(A) AA
(B) Aa

(C) A1
(D) None of these

Comments

Source: This question is taken from the Microsoft Excel MCQs

Latest MCQs

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

(A) 65,536
(B) 16,384

(C) 1,048,576
(D) None of Above

Comments

Source: This question is taken from the Microsoft Excel MCQs

Latest MCQs

Rows in Microsoft Excel are labeled as _____...?

(A) 1, 2, 3, etc.
(B) A1, A2, etc.

(C) A, B, C, etc.
(D) None of these

Comments

Source: This question is taken from the Microsoft Excel MCQs

Latest 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

Comments

Source: This question is taken from the Microsoft Excel MCQs

Latest MCQs

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

(A) 2
(B) 3

(C) 4
(D) 5

Comments

Source: This question is taken from the Microsoft Excel MCQs

Latest 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

Comments

Source: This question is taken from the Microsoft Excel MCQs

Latest MCQs

Which the following term does not pertain to Excel...?

(A) Browser
(B) Columns

(C) Work Book
(D) None of these

Comments

Source: This question is taken from the Microsoft Excel MCQs

Latest MCQs

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

(A) Rows
(B) Cells

(C) Columns
(D) Parentheses

Comments

Source: This question is taken from the Microsoft Excel MCQs

Latest MCQs

Shortcut in excell to insert new sheet...?

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

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

Comments

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

Latest MCQs

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

Comments

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

Latest MCQs

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

(A) !=
(B) ~=

(C) <>
(D) None of these

Comments

Source: This question is taken from the Microsoft Excel MCQs

Latest MCQs

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

(A) 1
(B) 10

(C) 11
(D) 21

Comments

Source: This question is taken from the Microsoft Excel MCQs

Latest MCQs

Which key is used for Excel to select the whole column highlight...?

(A) Shift + space
(B) CTRL + space

(C) Alt + space
(D) None of these

Comments

Source: This question is taken from the Microsoft Excel MCQs

Latest MCQs

Selected cell of excel...?

(A) Active Cell
(B) Cell No

(C) Formula cell
(D) None Of These

Comments

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

Latest 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

Comments

Source: This question is taken from the Microsoft Word MCQs

Latest 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

Comments

Source: This question is taken from the Microsoft Excel MCQs

Latest MCQs

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

(A) Program
(B) Macros

(C) Procedure
(D) All of these

Comments

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

Latest MCQs

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

Comments

Source: This question is taken from the Microsoft Excel MCQs

Latest MCQs

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

(A) Cells
(B) Rows

(C) Columns
(D) Parentheses

Comments

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

Latest MCQs

Worksheet in excel by default ___...?

(A) 3
(B) 2

(C) 1
(D) 4

Comments

Source: This question is taken from the Microsoft Excel MCQs

Latest MCQs

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

(A) Workbook
(B) Worksheet

(C) Note sheet
(D) Notebook

Comments

Source: This question is taken from the Microsoft Excel MCQs

Latest 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

Comments

Source: This question is taken from the Microsoft Excel MCQs

Latest MCQs

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

(A) Shift + F8
(B) Shift + F9

(C) Shift + F10
(D) Shift + F11

Comments

Source: This question is taken from the Microsoft Excel MCQs

Latest MCQs

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

(A) Cell address
(B) Range

(C) Formula
(D) Current cell

Comments

Source: This question is taken from the Microsoft Excel MCQs

Latest MCQs

In Microsoft Excel, the file you create and edit is called:...?

(A) A form
(B) A ledger

(C) A table
(D) A workbook

Comments

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

Latest MCQs

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

(A) Graphic program
(B) Word Processor

(C) Presentation
(D) Spreadsheet

Comments

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

Latest MCQs

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

(A) 256
(B) 1024

(C) 32767
(D) 65535

Comments

Source: This question is taken from the Microsoft Excel MCQs

Latest MCQs

What is a cell in Excel...?

(A) A row
(B) A column

(C) A unit of data
(D) A unit of formatting

Comments

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

Latest MCQs

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

(A) Workbook
(B) Worksheet

(C) Notesheet
(D) Notebook

Comments

Source: This question is taken from the Microsoft Excel MCQs

Latest MCQs

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

(A) AA
(B) A1

(C) Aa
(D) None of these

Comments

Source: This question is taken from the Microsoft Excel MCQs

Latest MCQs

Which of the following way cannot be used to link excel worksheet data to a Word document...?

(A) With the right drag method
(B) With a hyperlink

(C) With the copy and paste special commands
(D) With the copy and paste buttons on the standard toolbar

Comments

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

Latest MCQs

Microsoft Excel 2019 files have a default extension of ________...?

(A) .Xlsx
(B) .Xls

(C) .excel
(D) .123

Comments

Source: This question is taken from the Microsoft Excel MCQs

Latest MCQs

“Ctrl + Delete” Shortcut key is used in Ms Word to____________...?

(A) Delete the word just after the cursor
(B) Delete the word just before the cursor

(C) Delete the single letter just after the cursor
(D) Delete the single letter just before the cursor

Comments

Source: This question is taken from the Microsoft Word MCQs

Latest MCQs

User developed instruction for excel are called__________...?

(A) Progrms
(B) Macros

(C) Procedured
(D) All of these

Comments

Source: This question is taken from the Microsoft Excel MCQs

Latest MCQs

What is a cell in Excel...?

(A) A row
(B) A column

(C) A unit of data
(D) A unit of formatting

Comments

Source: This question is taken from the Microsoft Excel MCQs

Latest MCQs

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

(A) F1 Key
(B) F2 Key

(C) F3 Key
(D) F4 Key

Comments

Source: This question is taken from the Microsoft Excel MCQs

Latest MCQs

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

(A) Wrap text
(B) Click next

(C) All
(D) None

Comments

Source: This question is taken from the Microsoft Excel MCQs

Latest MCQs

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

(A) 1
(B) 4

(C) 7
(D) 9

Comments

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

Latest MCQs

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

(A) .Xlsx
(B) .Xls

(C) .excel
(D) .123

Comments

Source: This question is taken from the Microsoft Excel MCQs

Latest MCQs

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

(A) 65,536
(B) 16,384

(C) 1,048,576
(D) None of Above

Comments

Source: This question is taken from the Microsoft Excel MCQs

Latest MCQs

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

(A) * and?
(B) < and >

(C) ^ and /
(D) None of these

Comments

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

Latest MCQs

Microsoft excel is a powerful______...?

(A) Spreadsheet package
(B) Word processing package

(C) DBMS package
(D) None

Comments

Source: This question is taken from the Microsoft Excel MCQs

Latest MCQs

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

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

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

Comments

Source: This question is taken from the Microsoft Excel MCQs

Latest MCQs

Which keyboard shortcut is used to add comments in MS Office Excel Worksheet...?

(A) Alt + F2
(B) Ctrl + F12

(C) Shift + F5
(D) Shift + F2

Comments

Source: This question is taken from the Microsoft Excel MCQs

Latest MCQs

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

(A) SUM
(B) MAX

(C) MIN
(D) AVG

Comments

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

Latest MCQs

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

(A) F2
(B) F10

(C) F4
(D) F8

Comments

Source: This question is taken from the Microsoft Excel MCQs

Latest MCQs

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

(A) Alphabetical order
(B) Capitalization

(C) Spelling
(D) Primary records

Comments

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

Latest MCQs

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

(A) 6
(B) 7

(C) 8
(D) 5

Comments

Source: This question is taken from the Microsoft Excel MCQs

Latest MCQs

In Microsoft Excel, the file you create and edit is called...?

(A) A ledger
(B) A table

(C) A workbook
(D) None of these

Comments

Source: This question is taken from the Microsoft Excel MCQs

Latest 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

Comments

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

Latest MCQs

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

(A) Workbook
(B) Worksheet

(C) Note sheet
(D) Notebook

Comments

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

MCQs Categories


Best of Luck

From ShineGk.com

Share our website's link