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

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

(A) Cell (B) Graph

(C) Function (D) Range

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

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

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

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)

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

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

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

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

MS Excel Formula starts with__________...?

(A) . (B) _

(C) = (D) none

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

(A) Formatting toolbar (B) Picture Toolbar

(C) Drawing Toolbar (D) Standard toolbar

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

(A) Constant (B) Cell address

(C) Static (D) Variable

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)

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

(A) = (B) -

(C) + (D) none

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

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

Formula in Excell starts with...?

(A) + (B) -

(C) = (D) [

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

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) Cell

(B) Graph

(C) Function

(D) Range

(A) #NUM!

(B) #VALUE!

(C) #REF!

(D) #DIV0

(A) Insert OLE object icon

(B) Insert Formula icon

(C) Insert Applet icon

(D) Insert Plug-in icon

(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) =sum(A1:A2)

(B) =Add(a1:a2)

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

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

(A) Formula bar

(B) Menu bar

(C) Title bar

(D) None of these

(A) Horizontal Lookup

(B) Vertical Lookup

(C) Average

(D) None of these

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

(B) Payment

(C) Financial

(D) None of these

(A) Cell

(B) Graph

(C) Function

(D) Range

(A) .

(B) _

(C) =

(D) none

(A) Formatting toolbar

(B) Picture Toolbar

(C) Drawing Toolbar

(D) Standard toolbar

(A) Constant

(B) Cell address

(C) Static

(D) Variable

(A) =sum(A1:A2)

(B) Add(a1 a2)

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

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

(A) =

(B) -

(C) +

(D) none

(A) Horizontal Lookup

(B) Vertical Lookup

(C) Average

(D) None of these

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

(B) -

(C) =

(D) [

(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