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

Microsoft excel is a powerful______...?

(A) Spreadsheet package
(B) Word processing package

(C) DBMS package
(D) None

Comments
Latest MCQs

Worksheet in excel by default ___...?

(A) 3
(B) 2

(C) 1
(D) 4

Comments
Latest MCQs

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

(A) Alphabetical order
(B) Capitalization

(C) Spelling
(D) Primary records

Comments
Latest MCQs

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

(A) .Xlsx
(B) .Xls

(C) .excel
(D) .123

Comments
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
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
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
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
Latest MCQs

Selected cell of excel...?

(A) Active Cell
(B) Cell No

(C) Formula cell
(D) None Of These

Comments
Latest MCQs

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

(A) .xlsx
(B) .doc

(C) .ppt
(D) .pdf

Comments
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
Latest MCQs

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

(A) Cell address
(B) Range

(C) Formula
(D) Current cell

Comments
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
Latest MCQs

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

(A) 6
(B) 7

(C) 8
(D) 5

Comments
Latest MCQs

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

(A) .Xlsx
(B) .Xls

(C) .excel
(D) .123

Comments
Latest MCQs

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

(A) Rows
(B) Cells

(C) Columns
(D) Parentheses

Comments
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
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
Latest MCQs

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

(A) Browser
(B) Columns

(C) Work Book
(D) None of these

Comments
Latest MCQs

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

(A) SUM
(B) MAX

(C) MIN
(D) AVG

Comments
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
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
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
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
Latest MCQs

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

(A) .msxcl
(B) .xcl

(C) .xlsx
(D) .xlsm

Comments
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
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
Latest MCQs

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

(A) 256
(B) 1024

(C) 32767
(D) 65535

Comments
Latest MCQs

Shortcut in excell to insert new sheet...?

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

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

Comments
Latest MCQs

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

(A) Graphic program
(B) Word Processor

(C) Presentation
(D) Spreadsheet

Comments
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
Latest MCQs

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

(A) 1
(B) 10

(C) 11
(D) 21

Comments
Latest MCQs

User developed instruction for excel are called__________...?

(A) Progrms
(B) Macros

(C) Procedured
(D) All of these

Comments
Latest MCQs

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

(A) Cells
(B) Rows

(C) Columns
(D) Parentheses

Comments
Latest MCQs

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

(A) AA
(B) Aa

(C) A1
(D) None of these

Comments
Latest MCQs

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

(A) Workbook
(B) Worksheet

(C) Notesheet
(D) Notebook

Comments
Latest MCQs

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

(A) Workbook
(B) Worksheet

(C) Note sheet
(D) Notebook

Comments
Latest MCQs

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

(A) F2
(B) F10

(C) F4
(D) F8

Comments
Latest MCQs

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

(A) !=
(B) ~=

(C) <>
(D) None of these

Comments
Latest MCQs

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

(A) 1
(B) 4

(C) 7
(D) 9

Comments
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
Latest MCQs

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

(A) Program
(B) Macros

(C) Procedure
(D) All of these

Comments
Latest MCQs

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

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

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

Comments
Latest MCQs

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

(A) 2
(B) 3

(C) 4
(D) 5

Comments
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
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
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
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
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
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
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
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
Latest MCQs

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

(A) AA
(B) A1

(C) Aa
(D) None of these

Comments
Latest MCQs

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

(A) Workbook
(B) Worksheet

(C) Note sheet
(D) Notebook

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

MCQs Categories


Best of Luck

From ShineGk.com

Share our website's link