1) What will be the cell reference of the cell which is at the intersection of column Z and row 54? a) Z54 b) 54Z c) 5Z4 2) Find the correct formula from the formulas given below. a) G4*G8 b) G4xG8 c) =G4*G8 3) What will be the sequence of operations in the expression =(5+10)*H2/4. a) Addition, Multiplication, Division   b) Multiplication,Addition, Division c) Division, Multiplication, Addition 4) Which function can help us to find out the highest score in the given data? a) CONCAT  b) CONCATENATE c) MIN() 5) Joins several text items into one text item a) CONCAT () b) CONCATENATE() c) MIN() d) COUNT() 6) Combines the text from multiple ranges and/or strings, but it doesn't provide the delimiter or IgnoreEmpty arguments. a) COUNT() b) MAX() c) MIN() d) COUNTA() 7) Counts how many numbers are in the list of arguments a) COUNT() b) MAX() c) MIN() d) COUNTA() 8) Counts how many values are in the list of arguments a) COUNTA() b) MAX() c) MIN() d) COUNT() 9) Counts the number of blank cells within a range a) COUNTBLANK() b) MAX() c) MIN() d) COUNT() 10) A sales manager has requested the highest sales figures for the first quarter. Which function will be used? a) COUNTIF() b) MAX() c) MIN() d) COUNT() 11) Counts the number of cells within a range that meets the given criteria. a) COUNTIF() b) MAX() c) MIN() 12) Is it possible to give more than one argument in a function? a) Yes b) No 13) Labels are aligned at the ________ edge of the cell. a) Left b) Right c) Top d) Bottom 14) It is a combination of the relative and absolute reference. In this type of reference, either row or column has to remain fixed e.g. $A1 + A$2. a) Absolute Reference b) Relative Reference c) Mixed REference d) Cell Reference 15) An absolute cell reference is a cell address that contains a dollar sign before the column name and row number. For example $A$1 + $A$ a) Absolute Reference b) Relative Reference c) Mixed REference d) Cell Reference 16) Which one of these is not a FUNCTION of MS - Excel? a) AVERGE b) ADD c) MAX d) MIN 17) A sales manager has requested the total sales for the first quarter. Which function will be used? a) AVERGE b) SUM c) MAX d) MIN 18) They are built-in formulas in Excel. a) FUNCTIONS b) FAARMULAS c) REFERENCE d) OPERATORS 19) _____________are the special symbols such as +, -, &, etc., used for specifying the type of operation to be performed. a) FUNCTIONS b) FAARMULAS c) REFERENCE d) OPERATORS 20) Occurs when the formula contains invalid data. a) Error (#######) b) Name Error ( #NAME? ) c) Value Error ( #VALUE! ) d) Division Error ( #DIV?0! ) 21) Occurs when a number is divided by zero. a) Error (#######) b) Name Error ( #NAME? ) c) Value Error ( #VALUE! ) d) Division Error ( #DIV?0! ) 22) Occurs when a formula is not recognized by Excel. a) Error (#######) b) Name Error ( #NAME? ) c) Value Error ( #VALUE! ) d) Division Error ( #DIV?0! ) 23) Occurs when a formula is not recognized by Excel. a) Error (#######) b) Name Error ( #NAME? ) c) Value Error ( #VALUE! ) d) Division Error ( #DIV?0! ) 24) Occurs when a column is not wide enough to accommodate the value. a) Error (#######) b) Name Error ( #NAME? ) c) Value Error ( #VALUE! ) d) Division Error ( #DIV?0! ) 25) Occurs when a formula contains some incorrect cell references. a) Reference Error ( #REF! ) b) Name Error ( #NAME? ) c) Value Error ( #VALUE! ) d) Division Error ( #DIV?0! ) 26) Which term refers to the column letter and row number in a spreadsheet? a) Cell address b) Cell content c) Formula bar d) Chart title 27) Which one of the following is a spreadsheet application? a) Excel b) Word c) Outlook d) Powerpoint 28) What keys do you need to search for information on a page? a) CTRL + F b) CTRL + A c) CTRL + Z d) CTRL + C 29) Shortcut to save Excel file a) CTRL + F b) CTRL + A c) CTRL + S d) CTRL + Y 30) By default, a cell contains _________ characters. a) 10 b) 8 c) 7 d) 9

🏆 8 🏆EXCEL FARMULAS AND FUNCTIONS🏆 - BINDU AHUJA🏆

looja
Manusta

Edetabel

Visuaalne stiil

Valikud

Vaheta malli

Kas taastada automaatselt salvestatud ?