You can use the formula palette to...?

Question

Accepted Answer

Create and edit formula containing functions

You can use the formula palette to...? Mcqs

PPSC Past Papers

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

You can use the format painter multiple times before you turn it off by...?

(A) You can use the format painter button only one time when you click it (B) Double clicking the format painter button

(C) Pressing the CTRL key and clicking the format painter button (D) None of these

The formula used to perform calculations in the worksheet can be inserted with the help of:...?

(A) Insert OLE object icon (B) Insert Formula icon

(C) Insert Applet icon (D) Insert Plug-in icon

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

Formula in Excell starts with...?

(A) + (B) -

(C) = (D) [

In MS Excel which bar is used for formula and data writing...?

(A) Formula bar (B) Menu bar

(C) Title bar (D) None of these

What category of functions is used in this formula = PMT (C10/12, CB, C9, 1)...?

(A) Logical (B) Payment

(C) Financial (D) None of these

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

(A) Cell (B) Graph

(C) Function (D) Range

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)

What is main purpose of Format Painter in Microsoft applications...?

(A) To insert images into a documents (B) To change the font size

(C) to create the new styles (D) To copy formatting from one place and paste it to another place

Format painter in power point relates to :...?

(A) To copy formatting from one object or piece of text and then applied it else where (B) To paint pretty pictures on your slides

(C) To change the background colors of your slides (D) None of these

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

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

(A) = (B) -

(C) + (D) none

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

(A) Constant (B) Cell address

(C) Static (D) Variable

In Ms Word, On which toolbar can you find Format Painter tool...?

(A) Formatting toolbar (B) Picture Toolbar

(C) Drawing Toolbar (D) Standard toolbar

If a formula references a cell that contains text instead of a numerical value, what error does Excel display...?

(A) #NUM! (B) #VALUE!

(C) #REF! (D) #DIV0

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)

MS Excel Formula starts with__________...?

(A) . (B) _

(C) = (D) none

You can use the format painter multiple times before you turn it off by:...?

(A) the format painter button only one time when you click it (B) Double clicking the format painter button

(C) Pressing the Ctrl key and clicking the format painter button (D) Pressing the Alt key and clicking the format painter button

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

(A) Cell (B) Graph

(C) Function (D) Range

MCQs Categories

Best of Luck

From ShineGk.com

Share our website's link

(A) Enter assumptions data

(B) Create and edit formula containing functions

(C) Format cells containing numbers

(D) none

(A) You can use the format painter button only one time when you click it

(B) Double clicking the format painter button

(C) Pressing the CTRL key and clicking the format painter button

(D) None of these

(A) Insert OLE object icon

(B) Insert Formula icon

(C) Insert Applet icon

(D) Insert Plug-in icon

(A) Horizontal Lookup

(B) Vertical Lookup

(C) Average

(D) None of these

(A) +

(B) -

(C) =

(D) [

(A) Formula bar

(B) Menu bar

(C) Title bar

(D) None of these

(A) Logical

(B) Payment

(C) Financial

(D) None of these

(A) Cell

(B) Graph

(C) Function

(D) Range

(A) =sum(A1:A2)

(B) =Add(a1:a2)

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

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

(A) To insert images into a documents

(B) To change the font size

(C) to create the new styles

(D) To copy formatting from one place and paste it to another place

(A) To copy formatting from one object or piece of text and then applied it else where

(B) To paint pretty pictures on your slides

(C) To change the background colors of your slides

(D) None of these

(A) Horizontal Lookup

(B) Vertical Lookup

(C) Average

(D) None of these

(A) =

(B) -

(C) +

(D) none

(A) Constant

(B) Cell address

(C) Static

(D) Variable

(A) Formatting toolbar

(B) Picture Toolbar

(C) Drawing Toolbar

(D) Standard toolbar

(A) #NUM!

(B) #VALUE!

(C) #REF!

(D) #DIV0

(A) =sum(A1:A2)

(B) Add(a1 a2)

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

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

(A) .

(B) _

(C) =

(D) none

(A) the format painter button only one time when you click it

(B) Double clicking the format painter button

(C) Pressing the Ctrl key and clicking the format painter button

(D) Pressing the Alt key and clicking the format painter button

(A) Cell

(B) Graph

(C) Function

(D) Range