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

PPSC Past Papers

Latest MCQs

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

(A) =A1+A2
(B) add(A1+A2)

(C) A1+A2
(D) A1+A2\3

Comments
Latest MCQs

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

Comments
Latest MCQs

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

(A) MS Excel
(B) MS Word

(C) MS PowerPoint
(D) None of these

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

Comments
Latest MCQs

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

(A) Arithmetic
(B) Logical

(C) Conditional
(D) Greater

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

Comments
Latest MCQs

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

(A) 7
(B) 1.5

(C) 2
(D) 12

Comments
Latest MCQs

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)

Comments
Latest MCQs

We use ______ to write a formula in a cell....?

(A) =
(B) -

(C) +
(D) none

Comments
Latest MCQs

Microsoft Office is an example of a...?

(A) vertical market software
(B) Closed source software

(C) Open source software
(D) Horizontal market software

Comments
Latest MCQs

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

(A) Complex Formulas
(B) Standard Formulas

(C) Array Formula
(D) All

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

Comments
Latest MCQs

Select the example of connectivity?...?

(A) Floppy Disk
(B) Internet

(C) Data
(D) Power card

Comments
Latest MCQs

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

Comments
Latest MCQs

Which of the following symbols is used to enter a formula in MS Excel:...?

(A) $
(B) +

(C) #
(D) =

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

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

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

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

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

Comments
Latest MCQs

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

(A) MS Word
(B) MS Excel

(C) MS PowerPoint
(D) None of these

Comments
Latest MCQs

What is the keyboard shortcut to insert a SUM formula in MS Excel...?

(A) CRTL+ =
(B) ALT + =

(C) ALT + S
(D) CTRL + ALT+ =

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

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

(A) Output device
(B) Input device

(C) Photocopy
(D) None of these

Comments
Latest MCQs

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

(A) Chrome
(B) Safari

(C) Internet Explorer
(D) Microsoft Office

Comments
Latest MCQs

MS Excel Formula starts with__________...?

(A) .
(B) _

(C) =
(D) none

Comments
Latest MCQs

Another name for a pre programmed formula in excel is ___...?

(A) Cell
(B) Graph

(C) Function
(D) Range

Comments
Latest MCQs

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

(A) 5
(B) 625

(C) 320
(D) 232

Comments
Latest MCQs

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

Comments
Latest MCQs

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)

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

Comments
Latest MCQs

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

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

Comments
Latest MCQs

Which area in MS Excel window allows entering values and formulas...?

(A) Title bar
(B) Menu bar

(C) Formula bar
(D) Standard toolbar

Comments
Latest MCQs

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

(A) /
(B) *

(C) $
(D) =

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

Comments
Latest MCQs

Which one is example of spreadsheet software...?

(A) MS WORD
(B) MS EXCEL

(C) MS POWERPOINT
(D) None of these

Comments
Latest MCQs

Which of the following is an example of page orientation...?

(A) Subscript
(B) Superscript

(C) Landscape
(D) None of these

Comments
Latest MCQs

Which symbol is used to execute formulas in MS Excel...?

(A) :
(B) =

(C) #
(D) ~

Comments
Latest MCQs

In MS Excel formula and function start with ____...?

(A) +
(B) -

(C) =
(D) [

Comments
Latest MCQs

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

(A) Constant
(B) Cell address

(C) Static
(D) Variable

Comments
Latest MCQs

Which area in an excel window allows entering values and formulas...?

(A) Menu Bar
(B) Title Bar

(C) Formula Bar
(D) None of these

Comments
Latest MCQs

Embedded Formula in MS Excel can removed by pressing...?

(A) DELETE
(B) BACKSPACE

(C) PAGE DOWN
(D) END

Comments
Latest MCQs

Another name for a pre programmed formula in excel is ___________...?

(A) Cell
(B) Graph

(C) Function
(D) Range

Comments
Latest MCQs

Area formula helps for performing________ calculations...?

(A) Multiple
(B) Composite

(C) Nested
(D) All of these

Comments
Latest MCQs

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

(A) /
(B) =

(C) +
(D) &

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

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

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

Comments
Latest MCQs

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

Comments
Latest MCQs

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

(A) 1
(B) 10

(C) 11
(D) 21

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

Comments

MCQs Categories


Best of Luck

From ShineGk.com

Share our website's link