Sai ExcelWays

An Excel & Tally Academy ..step forward and make it your way easy
G-43, Unnati Tower, CentralSpine, Vidyadhar Nagar, Jaipur. Ph: 9414224448 Web: www.excelways.com Email: [email protected]

www.excelways.com

FB Link:

Q1.

Which of the following is an absolute cell reference? A B C D !A!1 $A$1 #a#1 A1 0 You Scored: 0/1 Which symbol must all formula begin with? A B C D = + ( @ 0 You Scored: 0/2 Which of the following formulas is not entered correctly? A B C D =10+50 =B7*B1 =B7+14 10+50 0 You Scored: 0/3 Which of the following is not an example of a value? A B C D May 10, 2001 1775 10% Serial Number 123456 0 You Scored: 0/4 A worksheet range is a

50

Answer: Q2.

Answer: Q3.

Answer: Q4.

Answer: Q5.

A B C D C Answer: Q6

A command used for data modeling A range of values such as from 23 to 234 A group of cells A group of worksheets 0 You Scored: 0/5

Getting data from a cell located in a different sheet is called A B C D Accessing Referencing Updating Functioning 0 You Scored: 0/6 A numeric value can be treated as a label value if it precedes with A B C D Apostrophe (') Exclamation (!) Hash (#) Ampersand (&) 0 You Scored: 0/7 Concatenation of text can be done using A B C D Apostrophe (') Exclamation (!) Hash (#) Ampersand (&) 0 You Scored: 0/8 Data can be arranged in a worksheet in a easy to understand manner using A B C D auto formatting applying styles changing fonts all of above 0 You Scored: 0/9

Answer: Q7

Answer: Q8

Answer: Q9

Answer:

Q10

Excel uniquely identifies cells within a worksheet with a cell name A B C D Cell names Column numbers and row letters Column letters and row numbers Cell locator coordinates 0 You Scored: 0/10 to view a cell comment A B C D click the edit comment command on the insert menu click the display comment command on the window menu position the mouse pointer over the cell click the comment command on the view menu 0 You Scored: 0/11 To save a workbook, you: A B C D Click the save button on the standard toolbar from the menu Press Ctrl+F5 Click Save on the Windows Start button Select Edit>Save 0 You Scored: 0/12 You can edit a cell by A B C D Clicking the formula button Double clicking the cell to edit it in-place Selecting Edit>Edit Cell from the menu None of above 0 You Scored: 0/13 You can use the drag and drop method to A B C D Copy cell contents Move cell contents Add cell contents a and b 0 You Scored: 0/14

Answer: Q11

Answer: Q12

Answer: Q13

Answer: Q14

Answer:

Q15

It is acceptable ot let long text flow into adjacent cells on a worksheet when A B C D Data will be entered in the adjacent cells No data will be entered in the adjacent cells There is nt suitable abbreviation of the text Tehere is not time to format the next 0 You Scored: 0/15 Right clicking something in Excel: A B C D Deletes the object Nothing the right mouse button is there for left handed people Opens a shortcut menu listing everything you can do to the object Selects the object 0 You Scored: 0/16 Files created with Lotus 1-2-3 have an extension A B C D DOC XLS 123 WK1 0 You Scored: 0/17 Comments can be added to cells using A B C D Edit > Comments Insert > Comments File > Comments View > Comments 0 You Scored: 0/18 When you copy a formula A B C D Excel erases the original copy of the formula Excel edits cell references in the newly copied formula Excel adjusts absolute cell references Excel doesnt adjust relative cell references

Answer: Q16

Answer: Q17

Answer: Q18

Answer: Q19

Answer: Q20 The autofill feature A B C D

0 You Scored: 0/19

extends a sequential series of data automatically adds range of cell values applies a boarder around the selected cells none of the above 0 You Scored: 0/20

Answer: Q21

A function inside another function is called _______ A B C D Nested function Round function Sum function Text function 0 You Scored: 0/21 The default header for a worksheet is A B C D Username Date and Time Sheet tab Name None 0 You Scored: 0/22 The cell reference for cell range of G2 to M12 is _______ A B C D G2.M12 G2;M12 G2:M12 G2-M12 0 You Scored: 0/23 What is the keyboard shortcut for creating a chart from the selected cell range? A B C D F2 F4 F8 F11

Answer: Q22

Answer: Q23

Answer: Q24

Answer: Q25

0 You Scored: 0/24 The Software which contains rows and columns is called ______ A B C D Database Drawing Spreadsheet Word processing 0 You Scored: 0/25 You can group noncontiguous worksheets with A B C D The alt+enter key The ctrl key and mouse The shift key and the mouse The group button on the standard toolbar 0 You Scored: 0/26

Answer: Q26

Answer:

Q27

The spelling tool is placed on ______ toolbar A B C D Standard Formatting Drawing Reviewing 0 You Scored: 0/27 If you need a text to show vertically in a cell. How will you achieve this? A B C D

Answer: Q28

Choose Vertical on Text alignment in Format Cells dialog box Choose 90 Degrees in Orientation of Format Cells dialog box Choose Distributed from the Vertical drop down list of Format Cells dialog box Choose Center Across Selection from Horizontal combo box in Format Cells dialog b 0 You Scored: 0/28

Answer: Q29

Can you set 0.5 inch left indentation for a cell in Excel?

A B C D C Answer: Q30

Excel does not have indentation feature You can specify indentation only if you turn the rulers on Indentation can be set from Format Cells dialog box The indentation can be specified only when printing 0 You Scored: 0/29

You can automatically adjust the size of text in a cell if they do not fit in width by A B C D Double clicking on the right border of column header From Format choose Columns and then Autofit Selection From Format Cells dialog box mark Shrink to fit check box All of above 0 You Scored: 0/30 Formatting a cell in Currency, you can specify A B C D Decimal Places Currency Symbol Both of above None of above 0 You Scored: 0/31 Formatting a cell in Number format you cant set A B C D Decimal Places Use 1000 separator Negative numbers Currency Symbol 0 You Scored: 0/32 What is entered by the function =today() A B C D The date value for the day according to system clock The time value according to system clock Todays date as Text format All of above 0 You Scored: 0/33

Answer: Q31

Answer: Q32

Answer: Q33

Answer:

Q34

Which function will you use to enter current time in a worksheet cell? A B C D ####### =NOW() =time() =currentTime() 0 You Scored: 0/34

Answer: Q35

Special category of Number tab in Format Cells dialog box can be used to apply formats li A B C D Zip Code Phone Number Both of above None of above 0 You Scored: 0/35 Merge cells option can be applied from A B C D Format Cells dialog box Alignment Tab Alignment Group in Home Tab Both of above None of above 0 You Scored: 0/36 How can you remove borders applied in cells? A B C D Choose None on Border tab of Format cells Open the list on Border tool from Home Tab and choose no border Both of above None of above 0 You Scored: 0/37

Answer: Q36

Answer: Q37

Answer: Q38

When all the numbers between 0 and 100 in a range should be displayed in Red Color, app A B C D

Use =if() function to format the required numbers red Apply Conditional Formatting command on Format menu Select the cells that contain number between 0 and 100 then click Red color on Text C All of above 0 You Scored: 0/38

Answer:

Q39

Which of the following is not true regarding Conditional Formatting? A B C D

You can add more than one condition to check You can set condition to look for Bold and apply Italics on them. You can apply Font, border and pattern formats that meets the specified conditions You can delete any condition from Conditional Formatting dialog box if it is not requ 0 You Scored: 0/39

Answer: Q40

Long text can be broken down into many lines within a cell. You can do this through A B C D Wrap Text in Format >> Cells Justify in Edit >> Cells Text Wraping in Format >> Cells, Layout tab All of above 0 You Scored: 0/40 MS Excel provides the default value for step in Fill Series dialog box A B C D 0 1 5 10 0 You Scored: 0/41 Ctrl + D shortcut key in Excel will A B C D Open the font dialog box Apply double underline for the active cell Fill down in the selection None of above 0 You Scored: 0/42 Which of the following you can paste selectively using Paste Special command? A B C D Validation Formats Formulas All of above

Answer: Q41

Answer: Q42

Answer: Q43

Answer: Q44

0 You Scored: 0/43

Paste Special allows some operation while you paste to new cell. Which of the following op A B C D Square Percentage Goal Seek Divide 0 You Scored: 0/44

Answer: Q45

If you need to remove only the formatting done in a range (numbers and formula typed th should not be removed, you must A B C D From Edit menu choose Clear and then Formats From Edit menu choose Delete Both A & B None of Above 0 You Scored: 0/45 What is the short cut key to replace a data with another in sheet? A B C D Ctrl + R Ctrl + Shift + R Ctrl + H Ctrl + F 0 You Scored: 0/46 When a formatted number does not fit within a cell, it displays A B C D ##### #DIV/0 #DIV@ None of these 0 You Scored: 0/47 Data can be arranged in ascending or descending order by using A B C Sort command from Table menu Sort command from Data menu Sort command from Tools menu

Answer: Q46

Answer: Q47

Answer: Q48

D C Answer: Q49

None of these 0 You Scored: 0/48

Red triangle at the top right corner of a cell indicates A B C D There is an error in the cell There is a comment associated with the cell The font color of the text in cell is red The cell can't accept formula 0 You Scored: 0/49

Answer: Q50

Cell E23 has a date value and you wish to place that date on an invoice prefaced with the t What is the command to do that? A B C D =B15&E23 =proper(B15)&" "&text(E23,"mmmm dd, yyyy") B15&" "&E23 =join(B15&E23) 0 You Scored: 0/50

Answer:

sy

h: 9414224448 com

www.facebook.com/excelway

d cell range?

at Cells dialog box in Format Cells dialog box

it in width by

sed to apply formats like

ayed in Red Color, apply

lick Red color on Text Color tool

e specified conditions alog box if it is not required

n do this through

command?

ich of the following operation is Valid?

s and formula typed there

oice prefaced with the text located in B15