A) pressing an arrow key
B) pressing an TAB key
C) pressing an ESC key
D) pressing an ENTER key

… Answer is C)

Correct Answer

A) split a worksheets into two panes
B) view different rows and columns
C) edit the contents of a cell
D) none of the above

… Answer is B)

Correct Answer

A) the edit Formula button
B) the Cancel button
C) the Enter button
D) all of the above

… Answer is D)

Correct Answer

A) vertical scroll bar
B) horizontal scroll bar
C) formula bar
D) standard toolbar

… Answer is C)

Correct Answer

A) pressing the TAB key
B) clicking the cell
C) pressing an arrow key
D) all of the above

… Answer is D)

Correct Answer

A) it cfan contain text and data
B) it can be modified
C) it can contain many sheets including worksheets and chart sheets
D) you have to work hard to create

… Answer is C)

Correct Answer

A) save the workbook
B) modify the worksheet
C) enter text and data
D) copy the worksheet

… Answer is D)

Correct Answer

A) allow you to view a different worksheet
B) allow you to view additional worksheet rows down
C) allow you to view additional worksheet columns to the right
D) allow you to view additional sheet tabs

… Answer is D)

Correct Answer

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) appear below the menu bar

… Answer is B)

Correct Answer

A) destination and users of the output data
B) source of input data
C) information on the purpose of the workbook
D) all of the above

… Answer is D)

Correct Answer

A) efficiency
B) auditibility
C) description
D) clarity

… Answer is C)

Correct Answer

A) select the cells containing the title text and use the fill handle to center the text across a range of cells
B) widen the columns
C) select the cells containing the title text plus the range over which the title text is to be centered
D) format the cells with the Comma Style

… Answer is A)

Correct Answer

A) format cells containing numbers
B) create and edit formulas containing functions
C) enter assumptions data
D) copy a range of cells

… Answer is B)

Correct Answer

A) the ALT key
B) the TAB key
C) the Enter key
D) none of the above

… Answer is D)

Correct Answer

A) clicking the upper -left cells in a group of cells and then pressing the SHIFT key while clicking the lower-right cell in a group of cells
B) pressing the CTRL key while dragging over the desired cells
C) pressing the SHIFT key and an arrow key
D) dragging over the desired cells

… Answer is D)

Correct Answer

A) when you use multiplication,division,or exponentiation in a formula
B) when you use addition and subtraction is a formula
C) because Excel uses hidden decimal palces in computation
D) when you show the results of formula with different decimal palces than the calculated results

… Answer is A)

Correct Answer

A) can only add values in a range of cells
B) provides a quick way to view the results of an arithmetic operation on a range of cells
C) automatically creates formulas and adds then to a worksheet
D) a and c

… Answer is B)

Correct Answer

A) multiplication and divison,exponentiation,positive and negative values
B) multiplication and division,positve and negative values,addtion and aubtraction
C) addtition and subtraction,positie and negative values,exponentiation
D) none of the above

… Answer is D)

Correct Answer

A) the entire worksheet
B) rows
C) columns
D) a,b and c

… Answer is D)

Correct Answer

A) extends a sequential series of data
B) automatically adda a range of cell values
C) applies a border aroud selected cells
D) none of the above

… Answer is D)

Correct Answer

A) with the copy,paste wnd cut commands on the edit menu
B) with commands on a shortcut menu
C) with button on the Standard toolbar
D) a,b,cand d

… Answer is D)

Correct Answer

A) click the edit comment command on the insert menu
B) click the display comment command on the window menu
C) position the mouse pointer over the celll
D) click the comment command on the view menu

… Answer is C)

Correct Answer

A) unfreeze panes command on the window menu
B) freeze panes command on the window menu
C) hold titles command on the edit menu
D) spilt command on the window menu

… Answer is B)

Correct Answer

A) END key
B) SHIFT key
C) ESC key
D) none of the above

… Answer is D)

Correct Answer

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) pressing the ALT key and clicking the format painter button

… Answer is B)

Correct Answer

A) data willl be entered in the adjacent cells
B) no data will be entered in the adjacent cells
C) there is no suitable abbreviation for the text
D) there is not time to format the text

… Answer is B)

Correct Answer

A) copy cell contents
B) delete cell contents
C) add cell contents
D) a and d

… Answer is D)

Correct Answer

A) select column D
B) select column E
C) select column E,F and G
D) select columns D,E and F

… Answer is B)

Correct Answer

A) double
B) single engineeriing
C) single accounting
D) double accounting

… Answer is B)

Correct Answer

A) the print density of characters
B) the height of the printed characters
C) upright or slanted shape
D) the design and appearance of characters

… Answer is A)

Correct Answer

A) edit
B) ignore
C) ignore all
D) change

… Answer is A)

Correct Answer

A) a row below the row where you want the page break to occur
B) a cell in row 1
C) a cell in column A
D) a and c

… Answer is D)

Correct Answer

A) view exactly where each page break occurs
B) add or remove page breaks
C) change the print area
D) a,b and c

… Answer is D)

Correct Answer

A) size the worksheet to fit on a specific number o f pages
B) add abd remove page breaks
C) specify only certain print areas
D) a,b,and c

… Answer is D)

Correct Answer

A) your name
B) the date and time
C) none
D) the sheet tab name

… Answer is C)

Correct Answer

A) with the mouse pointer in print preview
B) with the Zoom button on the print preview toolbar
C) with the zoom command on the view menu
D) a,b,and c

… Answer is D)

Correct Answer

A) printer selection
B) vertical or horizontal placement
C) orientation
D) row and column titles

… Answer is A)

Correct Answer

A) the entire worksheet is displayed
B) the selected range is dispalyed
C) the active portion of the worksheet is displayed
D) a.b.and c

… Answer is D)

Correct Answer

A) the active cell must be A1
B) the active cell can be anywhere in the worksheet
C) the active cell must be in row 1
D) the active cell must be in column a

… Answer is C)

Correct Answer

A) may be turned off for display but turned on for printing
B) may be turned on or off for printing
C) may be turned off for display and printing
D) a,b,and c

… Answer is D)

Correct Answer

A) a range of cells by range name
B) an entire workbook
C) a single worksheet
D) all of the above

… Answer is D)

Correct Answer

A) can place a chart on a new chart sheet or an any sheet in the workbook
B) can only place a chart on a new chart sheet
C) can only place a chart on a new blank worksheet
D) can only be used to create embedded charts

… Answer is B)

Correct Answer

A) add emphasis to chart data
B) add interest to a chart
C) help explain the chart data
D) a.b and c

… Answer is D)

Correct Answer

A) rotate text on the chart
B) select a foreground color
C) select a pattern
D) select a background color

… Answer is A)

Correct Answer

A) all the data markers on a chart
B) a data series
C) a selected data marker
D) a,b and c

… Answer is D)

Correct Answer

A) show the formatting of a data label
B) show the name of a data series
C) show the value of a data point
D) b and c

… Answer is D)

Correct Answer

A) Hyper Text Transfer protocol
B) Hyper Transfer Text Protocol
C) Hexagonal Text Transfer Protocol
D) Hexagonal Text Transfer Prototype

… Answer is A)

Correct Answer

Hartron DEO Exam Free Mock Test 21 के महत्वपूर्ण लिंक

All Mock Test	क्लिक करें
Exam Preparation Paid PDF	क्लिक करें
विषय और पेपर	क्लिक करें
आधिकारिक वेबसाइट	यहाँ क्लिक करें
Daily Free Quiz टेलीग्राम चैनल	Join Now

hartron deo mock test, hartron deo mock test free, hartron mock test 2024, hartron data entry operator mock test, har chhatravriti,