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

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

✅ Correct Answer: Fill down in the selection

Comments

Source: This question is taken from the Microsoft Excel MCQs

Latest MCQs

Worksheet in excel by default ___...?

(A) 3
(B) 2

(C) 1
(D) 4

✅ Correct Answer: 3

Comments

Source: This question is taken from the Microsoft Excel MCQs

Latest MCQs

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

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

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

✅ Correct Answer: 16,384

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

✅ Correct Answer: You can not set page border in Excel

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

✅ Correct Answer: Shift+F11

Comments

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

Latest MCQs

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

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

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

✅ Correct Answer: With the copy and paste buttons on the standard toolbar

Comments

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

Latest MCQs

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

(A) Workbook
(B) Worksheet

(C) Note sheet
(D) Notebook

✅ Correct Answer: Worksheet

Comments

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

Latest MCQs

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

(A) A form
(B) A ledger

(C) A table
(D) A workbook

✅ Correct Answer: A workbook

Comments

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

Latest MCQs

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

(A) F2
(B) F10

(C) F4
(D) F8

✅ Correct Answer: F2

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

✅ Correct Answer: Current cell

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

✅ Correct Answer: Spelling

Comments

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

Latest MCQs

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

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

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

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

Comments

Source: This question is taken from the Microsoft Excel MCQs

Latest MCQs

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

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

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

✅ Correct Answer: * and?

Comments

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

Latest MCQs

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

(A) 2
(B) 3

(C) 4
(D) 5

✅ Correct Answer: 3

Comments

Source: This question is taken from the Microsoft Excel MCQs

Latest MCQs

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

(A) Program
(B) Macros

(C) Procedure
(D) All of these

✅ Correct Answer: Macros

Comments

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

Latest MCQs

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

(A) .Xlsx
(B) .Xls

(C) .excel
(D) .123

✅ Correct Answer: .Xlsx

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

✅ Correct Answer: .xlsx

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

“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

✅ Correct Answer: Delete the word just after the cursor

Comments

Source: This question is taken from the Microsoft Word MCQs

Latest MCQs

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

(A) SUM
(B) MAX

(C) MIN
(D) AVG

✅ Correct Answer: AVG

Comments

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

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

✅ Correct Answer: Parameter provided to the function is of wrong data type

Comments

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

Latest MCQs

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

(A) AA
(B) Aa

(C) A1
(D) None of these

✅ Correct Answer: A1

Comments

Source: This question is taken from the Microsoft Excel MCQs

Latest MCQs

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

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

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

✅ Correct Answer: Columns & Rows

Comments

Source: This question is taken from the Microsoft Excel MCQs

Latest MCQs

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

(A) 1
(B) 10

(C) 11
(D) 21

✅ Correct Answer: 11

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

✅ Correct Answer: A unit of data

Comments

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

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

✅ Correct Answer: transpose

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

✅ Correct Answer: A unit of data

Comments

Source: This question is taken from the Microsoft Excel MCQs

Latest MCQs

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

(A) F1 Key
(B) F2 Key

(C) F3 Key
(D) F4 Key

✅ Correct Answer: F2 Key

Comments

Source: This question is taken from the Microsoft Excel MCQs

Latest MCQs

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

(A) Rows
(B) Cells

(C) Columns
(D) Parentheses

✅ Correct Answer: Parentheses

Comments

Source: This question is taken from the Microsoft Excel MCQs

Latest MCQs

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

(A) !=
(B) ~=

(C) <>
(D) None of these

✅ Correct Answer: <>

Comments

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

✅ Correct Answer: MOD ( )

Comments

Source: This question is taken from the Microsoft Excel MCQs

Latest MCQs

User developed instruction for excel are called__________...?

(A) Progrms
(B) Macros

(C) Procedured
(D) All of these

✅ Correct Answer: Macros

Comments

Source: This question is taken from the Microsoft Excel MCQs

Latest MCQs

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

(A) Workbook
(B) Worksheet

(C) Notesheet
(D) Notebook

✅ Correct Answer: Worksheet

Comments

Source: This question is taken from the Microsoft Excel MCQs

Latest MCQs

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

(A) .Xlsx
(B) .Xls

(C) .excel
(D) .123

✅ Correct Answer: .Xlsx

Comments

Source: This question is taken from the Microsoft Excel MCQs

Latest MCQs

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

(A) 256
(B) 1024

(C) 32767
(D) 65535

✅ Correct Answer: 32767

Comments

Source: This question is taken from the Microsoft Excel MCQs

Latest MCQs

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

(A) F1 key
(B) F2 key

(C) F3 key
(D) F4 key

✅ Correct Answer: F2 key

Comments

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

Latest MCQs

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

(A) 6
(B) 7

(C) 8
(D) 5

✅ Correct Answer: 7

Comments

Source: This question is taken from the Microsoft Excel MCQs

Latest MCQs

Microsoft excel is a powerful______...?

(A) Spreadsheet package
(B) Word processing package

(C) DBMS package
(D) None

✅ Correct Answer: Spreadsheet package

Comments

Source: This question is taken from the Microsoft Excel MCQs

Latest MCQs

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

✅ Correct Answer: Pivot table

Comments

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

Latest MCQs

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

(A) Wrap text
(B) Click next

(C) All
(D) None

✅ Correct Answer: Wrap text

Comments

Source: This question is taken from the Microsoft Excel MCQs

Latest MCQs

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

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

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

✅ Correct Answer: 1,048,576

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

✅ Correct Answer: You can not set page border in Excel

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

✅ Correct Answer: Worksheet

Comments

Source: This question is taken from the Microsoft Excel MCQs

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

✅ Correct Answer: Linked

Comments

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

Latest MCQs

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

(A) A ledger
(B) A table

(C) A workbook
(D) None of these

✅ Correct Answer: A workbook

Comments

Source: This question is taken from the Microsoft Excel MCQs

Latest MCQs

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

(A) Cells
(B) Rows

(C) Columns
(D) Parentheses

✅ Correct Answer: Parentheses

Comments

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

Latest MCQs

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

(A) Graphic program
(B) Word Processor

(C) Presentation
(D) Spreadsheet

✅ Correct Answer: Spreadsheet

Comments

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

Latest MCQs

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

(A) 1
(B) 4

(C) 7
(D) 9

✅ Correct Answer: 7

Comments

Source: This question is taken from the Junior Computer Operator (Bs-12) Transport And Mass Transit Department, Irrigation 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

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

✅ Correct Answer: Browser

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

✅ Correct Answer: Shift + F11

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

✅ Correct Answer: A1

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

✅ Correct Answer: Shift + F2

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

✅ Correct Answer: Active Cell

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

✅ Correct Answer: word is the destination document

Comments

Source: This question is taken from the Microsoft Word MCQs

Latest MCQs

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

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

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

✅ Correct Answer: CTRL + space

Comments

Source: This question is taken from the Microsoft Excel MCQs

Latest MCQs

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

✅ Correct Answer: Linked

Comments

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

Latest MCQs

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

(A) .xlsx
(B) .doc

(C) .ppt
(D) .pdf

✅ Correct Answer: .xlsx

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

✅ Correct Answer: All above mentioned

Comments

Source: This question is taken from the Microsoft Excel MCQs

Best of Luck

From ShineGk.com

Share our website's link