Which is an example of a formula?...? Mcqs

Which is an example of a formula?...?

(A) =A1+A2

(B) add(A1+A2)

(C) A1+A2

(D) A1+A2\3

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

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

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

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 one is example of spreadsheet software...?

(A) MS WORD

(B) MS EXCEL

(C) MS POWERPOINT

(D) None of these

Source: This question is taken from the Microsoft Excel MCQs

The name box on to the left of formula bar...?

(A) Shows the name of worksheet currently working on

(B) Shows the name of cell or range currently working on

(C) Shows the name of workbook currently working on

(D) none

Source: This question is taken from the Microsoft Excel MCQs

The Greater Than sign is an example of operation...?

(A) Arithmetic

(B) Logical

(C) Conditional

(D) Greater

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

Excel would evaluate the formula, = 20*10/5*8, and return this answer...?

(A) 5

(B) 625

(C) 320

(D) 232

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

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

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

(A) /

(B) *

(C) $

(D) =

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

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

These In MS Excela formula that looks for a s for a value in Teft most column of a fable and then returns a value in the same row for specific column:...?

(A) Horizontal Lookup

(B) Vertical Lookup

(C) Average

(D) None of these

Source: This question is taken from the Assistant Sub Inspector Punjab Police 2021

In MS Excel, to insert a sum formula in a cell, we must...?

(A) =sum(A1:A2)

(B) Add(a1 a2)

(C) =sum(1A:2A)

(D) =Add(1A,2A)

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

To create a formula you first...?

(A) select the cell you want to place the formula into

(B) Type the equals sign (=) to tell Excel that you’re about to enter a formula

(C) Enter the formula using any input values and the appropriate mathematical.

(D) Choose the new command from the file menu

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

In MS Excel, to insert a sum formula in a cell...?

(A) =sum(A1:A2)

(B) =Add(a1:a2)

(C) =sum(1A:2A)

(D) =Add(1A:2A)

Source: This question is taken from the Microsoft Excel MCQs

Which of the following is an example of spreadsheet application service...?

(A) Microsoft Excel

(B) Microsoft Word

(C) Microsoft PowerPoint

(D) None of these

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

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

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 is an example of page orientation...?

(A) Subscript

(B) Superscript

(C) Landscape

(D) None of these

Source: This question is taken from the Microsoft PowerPoint MCQs

Microsoft Office is an example of a...?

(A) vertical market software

(B) Closed source software

(C) Open source software

(D) Horizontal market software

In which product of MS Office we can use formulas...?

(A) MS Excel

(B) MS Word

(C) MS PowerPoint

(D) None of these

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

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

Multiple calculations can be made in a single formula using...?

(A) Complex Formulas

(B) Standard Formulas

(C) Array Formula

(D) All

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 simplifies the process of formatting text if the same formatting is required in more than one location...?

(A) Auto Text

(B) Format Painter

(C) Font dialog box

(D) None of the above

Source: This question is taken from the Microsoft Word MCQs

You can use the formula palette to...?

(A) Enter assumptions data

(B) Create and edit formula containing functions

(C) Format cells containing numbers

(D) none

Source: This question is taken from the Microsoft Excel MCQs

Which of the following is an example for automatic text formatting_____________...?

(A) Underlining hyperlink

(B) Adjusting extra space

(C) Replacing two -’s with an em hyphens

(D) All of above

Source: This question is taken from the Microsoft PowerPoint MCQs

MS Excel Formula starts with__________...?

(A) .

(B) _

(C) =

(D) none

Source: This question is taken from the Microsoft Excel MCQs

In MS Excel, " ____ " is not an example of a value....?

(A) Obtained marks - 87

(B) July 16, 1982

(C) 57845

(D) None of these

Source: This question is taken from the Microsoft Excel MCQs

Area formula helps for performing________ calculations...?

(A) Multiple

(B) Composite

(C) Nested

(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 use ______ to write a formula in a cell....?

(A) =

(B) -

(C) +

(D) none

Source: This question is taken from the Microsoft Excel MCQs

Which of the following is an example for automatic text formatting:...?

(A) Underlining hyperlink

(B) Adjusting extra space

(C) Replacing two -'s with an em hyphens

(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

In MS-Excel, when the formula bar is activated, we can see:...?

(A) Enter Button

(B) Cancel Button

(C) Edit Formula Button

(D) None of these

Source: This question is taken from the Microsoft Excel MCQs

Printer is an example of, that related to...?

(A) Output device

(B) Input device

(C) Photocopy

(D) None of these

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

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

In MS Excel, a formula that looks for a value in the leftmost column of a table and then returns a value in the same row for a specific column is called:...?

(A) Horizontal Lookup

(B) Vertical Lookup

(C) Average

(D) None of these

Source: This question is taken from the Assistant Sub Inspector (ASI) Punjab Police Past Paper 2021

Select the example of connectivity?...?

(A) Floppy Disk

(B) Internet

(C) Data

(D) Power card

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

Which of the following is not an example of a Web Browser ...?

(A) Chrome

(B) Safari

(C) Internet Explorer

(D) Microsoft Office

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

Which one is an example of spreadsheet software...?

(A) MS Word

(B) MS Excel

(C) MS PowerPoint

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

A value used in a formula that does not change is called...?

(A) Constant

(B) Cell address

(C) Static

(D) Variable

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

In a computer spreadsheet, value of formula (7-3)x(1+6)/4 is __________ ...?

(A) 7

(B) 1.5

(C) 2

(D) 12

Source: This question is taken from the Microsoft Excel MCQs

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

Which of the following is an example for automatic text formatting...?

(A) Adjusting extra space

(B) Underlining hyperlink

(C) Replacing two -‘s with an em hyphens

(D) All of above

Source: This question is taken from the Microsoft PowerPoint MCQs

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

If a formula = B14*C14 in cell D14, and is copied to D16, the new formula would be _____...?

(A) =B14*C14

(B) =B16*C16

(C) =A16*B16

(D) None of these

Source: This question is taken from the Microsoft Excel MCQs

What should you do if you require pasting the same format in many places...?

(A) Double click the format painter then go on pasting in many places

(B) Click the format painter then go on pasting to many places holding Ctrl Key

(C) Click the Format painter and go on pasting in many places holding Alt Key

(D) All of above

Source: This question is taken from the Microsoft Word MCQs