Home
Current Affairs January 2024

What is the correct answer?

4

Which would you choose to create a bar diagram?

A. Edit, Chart

B. Insert, Chart

C. Tools, Chart

D. Format, Chart

Correct Answer :

B. Insert, Chart


Related Questions

What is the correct answer?

4

It is acceptable to let long text flow into adjacent cells on a worksheet when

A. data will be entered in the adjecent cells

B. no data will be entered in the adjacent cells

C. there is no suitable abbrevition for the text

D. there is not time to format the text

What is the correct answer?

4

Getting data from a cell located in a different sheet is called ......

A. Accessing

B. Referencing

C. Updating

D. Functioning

What is the correct answer?

4

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 not both at the same time

D. Value and cell references

What is the correct answer?

4

Which of the following is not true regarding Conditional Formatting?

A. You can add more than one condition to check

B. You can set condition to look for Bold and apply Italics on them

C. You can apply Font, border and pattern formats that meets the specified conditions

D. You can delete any condition from Conditional Formatting dialog box if it is not requried

What is the correct answer?

4

What happens when dollar signs ($) are entered in a cell address? (e$B$2:$B$10)

A. An absolute cell address is created

B. Cell address will change when it is copied to another cell

C. The sheet tab is changed

D. The status bar does not display the cell address

What is the correct answer?

4

How can you remove borders applied in cells?ACC

A. Choose None on Border tab of Format cells

B. Open the list on Border tool in Formatting toolbar then choose first tool (no border)

C. Both of above

D. None of above

What is the correct answer?

4

Which of the following is not information you can specify using the solver?

A. Input cells

B. Constraints

C. Target cell

D. Changing cells

What is the correct answer?

4

A worksheet range is a

A. A command used for data modeling

B. A range of values such as from 23 to 234

C. A group of cells

D. A group of worksheets

What is the correct answer?

4

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

What is the correct answer?

4

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

A. You can use the format painter button on ly 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

What is the correct answer?

4

How many worksheets can a workbook have?

A. 3

B. 8

C. 255

D. none of above

What is the correct answer?

4

In Excel, a Data Series is defined as what?

A. A type of chart

B. A cell reference

C. A collection of related data

D. A division of results

What is the correct answer?

4

Comments can be added to cells using

A. Edit > Comments

B. Insert > Comments

C. File > Comments

D. View > Comments

What is the correct answer?

4

In the formula, which symbol specifies the fixed columns or rows?

A. $

B. *

C. %

D. &

What is the correct answer?

4

When a row of data is to be converted into columns

A. Copy the cells in row, select the same number of cells in row and paste

B. Copy the cells in column then choose Edit >> Paste Special, then click Transpose and OK

C. Copy the cells then go to Format >> Cells then on Alignment tab click Transpose check box and click OK

D. Select the cells then place the cell pointer on new cell and choose Edit >> Paste Special, mark Transpose check box and click OK

What is the correct answer?

4

The Chart wizard term data categories refers to;

A. A chart plot area

B. A horizontal axis

C. The organization of individual values with a charts data series

D. The data range that supply chart data

What is the correct answer?

4

The name box

A. Shows the location of the previously active cell

B. Appears to the left of the formula bar

C. Appears below the status bar

D. Appears below the menu bar

What is the correct answer?

4

MS Excel provides the default value for step in Fill Series dialog box

A. 0

B. 1

C. 5

D. 10

What is the correct answer?

4

Without using the mouse or the arrow keys, what is the fastest way of getting to cell A1 in a spreadsheet?

A. Press Ctrl +Home

B. Press Home

C. Press Shift + Home

D. Press Alt + Home

What is the correct answer?

4

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 youre about to enter a formula

C. Enter the formula using any input values and the appropriate mathematical operators that make up your formula

D. Choose the new command from the file menu

What is the correct answer?

4

Right clicking something in Excel:

A. Deletes the object

B. Nothing the right mouse button is there for left handed people

C. Opens a shortcut menu listing everything you can do to the object

D. Selects the object

What is the correct answer?

4

The Delete key of keyboard is assigned to which command in Excel?

A. Edit >> Clear >> Contents

B. Edit >> Clear >> All

C. Edit >> Delete

D. All of above

What is the correct answer?

4

Which of the cell pointer indicates that you can fill series?

A. Doctors symbol (Big Plus)

B. small thin plus icon

C. Mouse Pointer with anchor at the tip

D. None of above

What is the correct answer?

4

If you begin typing an entry into a cell and then realize that you dont want your entry placed into a cell, you:

A. Press the Erase key

B. Press Esc

C. Press the Enter button

D. Press the Edit Formula button

What is the correct answer?

4

To save a workbook, you:

A. Click the save button on the standard toolbar from the menu

B. Press Ctrl+F5

C. Click Save on the Windows Start button

D. Select Edit>Save

What is the correct answer?

4

Hyperlinks can be

A. Text

B. Drawing objects

C. Pictures

D. All of above

What is the correct answer?

4

When you copy a formula

A. Excel erases the original copy of the formula

B. Excel edits cell references in the newly copied formula

C. Excel adjusts absolute cell references

D. Excel doesnt adjust relative cell references

What is the correct answer?

4

A worksheet can have a maximum of …. Number of rows

A. 256

B. 1024

C. 32000

D. 65535

What is the correct answer?

4

Which of the following format you can decide to apply or not in AutoFormat dialog box?

A. Number format

B. Border format

C. Font format

D. All of above

What is the correct answer?

4

Which of the following is invalid statement?

A. Sheet tabs can be colored

B. Some picture can be applied as a background of a sheet

C. You can set the column width automatically fit the amount of text

D. The width of a row and be specified manually or fit automatically