ISA

Reviewed by Editorial Team
The ProProfs editorial team is comprised of experienced subject matter experts. They've collectively created over 10,000 quizzes and lessons, serving over 100 million users. Our team includes in-house content moderators and subject matter experts, as well as a global network of rigorously trained contributors. All adhere to our comprehensive editorial guidelines, ensuring the delivery of high-quality content.
Learn about Our Editorial Process
| By Isatest
I
Isatest
Community Contributor
Quizzes Created: 2 | Total Attempts: 18,950
| Attempts: 9,525
Quiz Flashcard
SettingsSettings
Please wait...
  • 1/162 întrebări

    Excel face parte din:

    • MS Office
    • SO Windows
    • MS Visual Studio
    • Lotus 123
Please wait...
ISA - Quiz
About This Quiz

Isa test

Quiz Preview

  • 2. 

    Care functie calculeaza madia aritmetica simpla?

    • STD

    • AVERAGE

    • MAS

    Correct Answer
    A. AVERAGE
    Explanation
    The correct answer is AVERAGE. The AVERAGE function calculates the simple arithmetic mean of a set of numbers. It adds up all the numbers in the set and then divides the sum by the count of numbers in the set. This function is commonly used to find the average of a range of numbers in Excel or other spreadsheet programs.

    Rate this question:

  • 3. 

    Argumentele functiilor excel sunt incluse intre caracterele:

    • [ ]

    • { }

    • ()

    Correct Answer
    A. ()
    Explanation
    The correct answer is "()". The parentheses are used to enclose the arguments of Excel functions. The arguments are the values or references that the function uses to perform calculations or operations. By enclosing the arguments in parentheses, Excel can identify and process them correctly within the function.

    Rate this question:

  • 4. 

    Cu referire la Excel,care dintre urmatoarele enunturi sunt adevarate?

    • Intr-un registru de lucru,numarul foilor de calcul nu poate fi mai mare ca 3

    • Intrun registru de lucru foile de calcul pot fi redenumite

    • Intr-un registru de lucru,utilizatorul poate adauga sau sterge foi de calcul

    Correct Answer(s)
    A. Intrun registru de lucru foile de calcul pot fi redenumite
    A. Intr-un registru de lucru,utilizatorul poate adauga sau sterge foi de calcul
    Explanation
    In Excel, the user can rename worksheets and add or delete worksheets in a workbook. This means that the statement "intr-un registru de lucru, utilizatorul poate adauga sau sterge foi de calcul" (in a workbook, the user can add or delete worksheets) is true. However, the statement "intr-un registru de lucru, numarul foilor de calcul nu poate fi mai mare ca 3" (in a workbook, the number of worksheets cannot be greater than 3) is false, as there is no limitation on the number of worksheets in Excel.

    Rate this question:

  • 5. 

    Prin operatiile de copiere sua mutare adresele absolute se modifica?

    • Da

    • Nu

    • De cele mai multre ori

    Correct Answer
    A. Nu
    Explanation
    The correct answer is "no." In operations such as copying or moving, absolute addresses do not change. Absolute addresses refer to specific locations in memory or on a storage device, and they remain the same regardless of any copying or moving operations.

    Rate this question:

  • 6. 

    In excel prin operatiile de copiere adresele absolute se modifica?

    • Nu

    • Da

    • Da,dar numai cind sunt combinate cu adresele relative

    Correct Answer
    A. Nu
    Explanation
    The correct answer is "no." In Excel, absolute references do not change when copied. Absolute references are used to fix a specific cell or range of cells in a formula so that it does not adjust when the formula is copied to other cells. This is useful when you want to maintain a constant reference to a specific cell or range in your calculations.

    Rate this question:

  • 7. 

    Care sunt adevara?

    • Dupa realizare un grafic execl poate fi modificat folosind optiunile meniului chart

    • Modificarea datelor din foaia de calcul determina si modificarea graficelor

    • Modificarea datelor din foaia de calcul nu influenteaza graficele create anterior

    Correct Answer(s)
    A. Dupa realizare un grafic execl poate fi modificat folosind optiunile meniului chart
    A. Modificarea datelor din foaia de calcul determina si modificarea graficelor
    Explanation
    The correct answer states that after creating a chart in Excel, it can be modified using the options in the chart menu. Additionally, it states that modifying the data in the spreadsheet will also result in changes to the charts. This explanation highlights the functionality of Excel in allowing users to customize and update their charts based on the data in the spreadsheet.

    Rate this question:

  • 8. 

    In excel,specificarea Preturi!B45 indica:

    • Un domeniu de causte cu numele Preturi!B45

    • Casuta B45 din foaia de calcul Preturi

    • Casuta B45 este numita Preturi

    Correct Answer
    A. Casuta B45 din foaia de calcul Preturi
    Explanation
    The correct answer is "casuta B45 din foaia de calcul Preturi". This means that the specific area "Preturi!B45" refers to cell B45 in the worksheet named "Preturi".

    Rate this question:

  • 9. 

    La modificarea continutului unei casute are loc:

    • Refacerea automata a graficului,in care este reprezentata valoarea din casuta respectiva

    • Recalcularea automata a formulelor si functiilor,in care este referita celula respectiva

    • Recalcularea automata numai a formulelor( nu si a functiilor)in care este referita casuta respectiva

    Correct Answer(s)
    A. Refacerea automata a graficului,in care este reprezentata valoarea din casuta respectiva
    A. Recalcularea automata a formulelor si functiilor,in care este referita celula respectiva
    Explanation
    When the content of a cell is modified, the graph representing the value in that cell is automatically updated and the formulas and functions referencing that cell are also automatically recalculated.

    Rate this question:

  • 10. 

    Reprezentarea structurii profitului anual pe cele patru trimestre se realizeaza intr-un grafic de tip:

    • Line

    • Pie

    • Area

    Correct Answer
    A. Pie
    Explanation
    The correct answer is "pie" because a pie chart is commonly used to represent the distribution or proportion of different categories or parts of a whole. In this case, the annual profit is being represented, and a pie chart would be suitable for showing the percentage or share of profit contributed by each of the four quarters.

    Rate this question:

  • 11. 

    Programele de calcul tabelar:

    • Integreaza facilitati de lucru cu tabele

    • Permit reprezentarea grafica a datelor

    • Nu sunt recomandate pentru realizarea de simulari in tabele

    • Nu permit organizarea in baze de date a unor volume mari de date

    Correct Answer(s)
    A. Integreaza facilitati de lucru cu tabele
    A. Permit reprezentarea grafica a datelor
    Explanation
    The given answer states that programul de calcul tabelar integreaza facilitati de lucru cu tabele and permite reprezentarea grafica a datelor. This means that spreadsheet programs have features that allow working with tables and also provide the ability to represent data graphically. This suggests that spreadsheet programs are designed to handle and manipulate data in a tabular format, making it easier to organize and analyze information. Additionally, the ability to create visual representations of data through charts and graphs can aid in understanding and presenting the data effectively.

    Rate this question:

  • 12. 

    Sa presupunem ca s-a realizat o investitie care aduce in urmatorii 3 ani incasarile:in anul 2008,8ROn;in anul 2009,7 Ron,in anul 2010,6,5 ron.Ce funstie financiara se utilizeaza pentru a estima eficienta investitiei realizate,sub aspectul ratei de rentabilitate?

    • NPV

    • MAX

    • IRR

    • RATE

    Correct Answer
    A. IRR
    Explanation
    The correct answer is IRR (Internal Rate of Return). IRR is a financial function used to estimate the efficiency of an investment by calculating the rate at which the investment's net present value (NPV) equals zero. It takes into account the cash flows generated by the investment over a specific period of time and calculates the rate of return that would make the NPV of those cash flows equal to zero. In this case, by using IRR, we can determine the rate of return that would make the net present value of the cash flows from the investment equal to zero over the next three years.

    Rate this question:

  • 13. 

    Care dintre urmatoarele reguli trebuie respecatete in Excel?

    • Numele unei functii trebuie scris obligatoriu cu majuscule

    • In functii se pot folosi numai adrese absolute de casute

    • Nu se lasa spatii intre numele functiei si argumente

    • Argumentele unei functii pot fi incluse intre diferite tipuri de paranteze

    Correct Answer
    A. Nu se lasa spatii intre numele functiei si argumente
    Explanation
    The rule that needs to be respected in Excel is that no spaces should be left between the function name and arguments.

    Rate this question:

  • 14. 

    In casutele foilor de calcul Excel,pot fi introduse:

    • Date numerice

    • Siruri de caractere

    • Metadate

    • Formule

    • Functii

    Correct Answer(s)
    A. Date numerice
    A. Siruri de caractere
    A. Formule
    A. Functii
    Explanation
    In casutele foilor de calcul Excel, pot fi introduse date numerice, siruri de caractere, formule si functii. Datele numerice pot fi numere sau valori numerice, cum ar fi sume sau procente. Sirurile de caractere sunt textele sau cuvintele introduse în celule. Formulele sunt utilizate pentru a efectua calcule și operații matematice pe datele introduse. Funcțiile sunt predefinite în Excel și pot fi utilizate pentru a efectua operații complexe sau pentru a returna valori specifice în funcție de anumite criterii.

    Rate this question:

  • 15. 

    Protejarea unei foi de calcul asigura:

    • Evitarea riscului deterioararii voluntare a aplicatiilor

    • Evitarea riscului deteriorarii involuntare a aaplicatiilor

    • Imprimarea mai rapida si sigura a tabelelor

    Correct Answer(s)
    A. Evitarea riscului deterioararii voluntare a aplicatiilor
    A. Evitarea riscului deteriorarii involuntare a aaplicatiilor
    Explanation
    The correct answer is the protection of a spreadsheet ensures the avoidance of deliberate deterioration of applications and the avoidance of unintentional deterioration of applications. This means that by protecting a spreadsheet, the risk of intentional and unintentional damage to the applications within it is minimized.

    Rate this question:

  • 16. 

    Optiunea de sortare la un moment dat poate fi:

    • Ascending

    • Descendind

    • Ascending si descending

    Correct Answer(s)
    A. Ascending
    A. Descendind
    Explanation
    The correct answer is "ascending, descending". This is because the option for sorting at any given time can be either ascending or descending. Ascending means arranging the items in increasing order, while descending means arranging them in decreasing order. Therefore, the correct answer includes both options as it is possible to choose either ascending or descending for sorting.

    Rate this question:

  • 17. 

    Considerind o zona dintr-o foaie de calcul, B5:B10, denumita Venituri, cum se poate exprima suma valorilor din casutele acestei zone?

    • =SUM(B5:B10)

    • =SUM(Venituri)

    • =+(Venituri)

    • =+(B5:B10)

    Correct Answer(s)
    A. =SUM(B5:B10)
    A. =SUM(Venituri)
    Explanation
    The correct answer is =SUM(B5:B10) and =SUM(Venituri). Both expressions calculate the sum of the values in the range B5 to B10, which is named Venituri. The SUM function in Excel is used to add up a range of cells, and it can be written either with the actual range (B5:B10) or with the named range (Venituri). Both expressions will yield the same result, which is the sum of the values in the specified range.

    Rate this question:

  • 18. 

    In memoria interna,o data calendaristica Excel este reprezentata:

    • Ca un numar

    • Ca un sir de caractere

    • Printr-o formula speciala

    Correct Answer
    A. Ca un numar
    Explanation
    In memoria interna, data calendaristica Excel este reprezentata ca un numar. Aceasta se datoreaza faptului ca in Excel, datele calendaristice sunt stocate sub forma de numere seriale, unde fiecare numar reprezinta o anumita data. De exemplu, data 1 ianuarie 2022 poate fi reprezentata prin numarul 44405. Acest format numeric permite utilizatorului sa efectueze operatii matematice si calcule pe datele calendaristice, precum adunari, scaderi sau comparatii.

    Rate this question:

  • 19. 

    Pentru calculul amortizarii se folosesc functiile:

    • =SLN()

    • =PMT()

    • =DDB()

    • =SYD()

    • =SUM()

    Correct Answer(s)
    A. =SLN()
    A. =DDB()
    A. =SYD()
    Explanation
    These functions are used for calculating depreciation.

    - =SLN() is used to calculate straight-line depreciation, which evenly distributes the cost of an asset over its useful life.
    - =DDB() is used to calculate the declining balance depreciation, which applies a higher depreciation rate in the early years and decreases it over time.
    - =SYD() is used to calculate the sum-of-years' digits depreciation, which allocates more depreciation in the early years and less in the later years.

    These functions are commonly used in financial analysis and accounting to determine the value of assets over time.

    Rate this question:

  • 20. 

    Ce restrictii trebuie sa respecte zona criteriu creata pentru interogarea unei baze de date?

    • Sa cuprinda cel putin 3 coloane

    • Numele cimpului la care se refera conditia sa fie identic cu cel din structura bazei de date

    • Sa precizeze clar tipul inerogarii

    Correct Answer
    A. Numele cimpului la care se refera conditia sa fie identic cu cel din structura bazei de date
    Explanation
    The restriction that needs to be respected in the created criterion zone for querying a database is that the field name to which the condition refers must be identical to the one in the database structure.

    Rate this question:

  • 21. 

    Tipul datelor din casutele foilor excel este determinat de:

    • Primul caracter introdus

    • Rezultatul evaluarii functiilor sistem folosite

    • Rezultatul evaularii formulei folosite

    Correct Answer
    A. Primul caracter introdus
    Explanation
    The data type in Excel cells is determined by the first character entered. This means that if the first character is a number, Excel will recognize it as a numeric data type. If the first character is a letter or symbol, Excel will recognize it as a text data type. The data type affects how Excel treats the data for calculations and formatting.

    Rate this question:

  • 22. 

    Simularile in tabelele de simulare pot fi realizate in functie de:

    • O variabila

    • Doua variabile

    • Oricite variabile

    Correct Answer(s)
    A. O variabila
    A. Doua variabile
    Explanation
    The correct answer is "o variabila, doua variabile". This means that similarities in simulation tables can be created based on either one variable or two variables. This suggests that the simulation tables can be used to analyze and compare data based on different variables, providing flexibility in the analysis process.

    Rate this question:

  • 23. 

    Care dintre umatoarele enunturi sunt corecte?

    • IRR determina rata interna de rentabilitate pentru o serie de venituri generate de o investitie

    • SLN calculeaza suma logaritmului natural

    • IF caluculeaza intrarea fortata de valuta

    • DDB calculeaza amortizarea dupa met degresiva

    Correct Answer(s)
    A. IRR determina rata interna de rentabilitate pentru o serie de venituri generate de o investitie
    A. DDB calculeaza amortizarea dupa met degresiva
    Explanation
    The correct answer is IRR determines the internal rate of return for a series of income generated by an investment and DDB calculates depreciation using the declining balance method.

    Rate this question:

  • 24. 

    Care dintre urmatorii operatori se utilizeaza pentru concatenarea sirurilor de caractere?

    • +

    • &

    • ;

    • #

    Correct Answer
    A. &
    Explanation
    The correct answer is "&". In programming, the "&" operator is used for concatenating strings or joining them together. It allows you to combine two or more strings into a single string. For example, if you have two strings "Hello" and "World", using the "&" operator you can concatenate them as "HelloWorld".

    Rate this question:

  • 25. 

    In foile da calcul Excel,adresele casutelor pot fi:

    • Logice

    • Fizice

    • Relative

    • Absolute

    • Mixte

    Correct Answer(s)
    A. Relative
    A. Absolute
    A. Mixte
    Explanation
    The addresses of cells in an Excel spreadsheet can be categorized as logical, physical, relative, absolute, or mixed. Logical addresses refer to the column and row headers, such as A1 or B5. Physical addresses, on the other hand, refer to the actual physical location of the cells on the spreadsheet. Relative addresses are cell references that change when copied or moved, while absolute addresses remain constant. Mixed addresses combine elements of both relative and absolute addresses. Therefore, the correct answer is relative, absolute, and mixed.

    Rate this question:

  • 26. 

    O pers fizica vrea sa ia imprumut de la o banca ,cu rambursare 10 ani,in conditiile in care isi permite sa plateasca lunar o rata de 100 RON.In conditiile in care rata dobinzii va fi neschimbata (7%),ce functii folositi pentru  a afla valoarea maxima a creditului de care paote beneficia in prezent persoana in cauza?

    • Max

    • Fv

    • Pv

    • Nici una

    Correct Answer
    A. Pv
    Explanation
    The correct answer is "pv". In this question, the individual wants to calculate the maximum value of the loan they can benefit from currently. To do this, they need to use the present value (pv) function, which calculates the current value of a future cash flow. By inputting the relevant information such as the monthly payment, interest rate, and loan term, the pv function can determine the maximum loan amount the person can afford to repay over 10 years with a monthly payment of 100 RON.

    Rate this question:

  • 27. 

    Sa presupunem ca sa realizat o investitie care aduce in urrmatoarii 3 ani incasarile:in 2008,3500RON;in 2009,105000 RON; in 2010,5200 RON.Ce functie financiara sse utilizeaza pentru a determina valoarea neta a investitiei?

    • Irr

    • PV

    • NPV

    • FV

    Correct Answer
    A. NPV
    Explanation
    The Net Present Value (NPV) function is used to determine the net value of an investment by calculating the present value of all cash inflows and outflows associated with the investment. In this case, the cash inflows are the amounts received in 2008, 2009, and 2010, which are 3500 RON, 105000 RON, and 5200 RON respectively. By discounting these cash flows to their present value and subtracting the initial investment, the NPV can be calculated to assess the profitability of the investment.

    Rate this question:

  • 28. 

    In proiectarea aplicatiilor folosind progr de calcul tabelar trebuie de parcurs urm etape:

    • Analiza probl si construirea modellului de rez a proble

    • Construirea modelului in foaia de calcul

    • Utilizarea modelului

    • Formatarea harddiscului pentru preluarea corecta a adatelor

    Correct Answer(s)
    A. Analiza probl si construirea modellului de rez a proble
    A. Construirea modelului in foaia de calcul
    A. Utilizarea modelului
    Explanation
    The correct answer is the correct sequence of steps in designing applications using spreadsheet software. The steps include analyzing the problem and constructing the problem-solving model, building the model in the spreadsheet, and finally utilizing the model for data analysis and decision-making. The last option, formatting the hard disk for data retrieval, is not a step in the application design process and is therefore not included in the correct answer.

    Rate this question:

  • 29. 

    In bazele de date, lucrul cu fisierele de date (extragerea si modificarea datelor) se realizeaza exclusiv prin intermediul:

    • Dictionarului de date, in care se gasesc informatii privitoare la structura datelor si restrictiile indeplinite de acestea

    • Dictionarul de date, in care se gasesc informatii privitoare la structura fizica a sistemului de calcul

    • Dictionarul de date, in care se gasesc informatii privitoare la utilizatorii retelei pe care ruleaza baza de date

    Correct Answer
    A. Dictionarului de date, in care se gasesc informatii privitoare la structura datelor si restrictiile indeplinite de acestea
    Explanation
    The correct answer is the dictionary of data, which contains information about the structure of the data and the restrictions they meet. This dictionary is essential for working with data files in databases as it provides important details about the organization and constraints of the data, allowing for proper extraction and modification of the data.

    Rate this question:

  • 30. 

    In excel,care dintre urm enunturi sunt adevarate?

    • Pentru calculul amortizarolor se folosesc functii construite de utilizator

    • =RATE() este functia care calculeaza procentul dobinzii pentru o anuitate

    • =RATE() este functia ce calculeaza rata periodica de rambursare a unui credit

    Correct Answer
    A. =RATE() este functia care calculeaza procentul dobinzii pentru o anuitate
    Explanation
    The correct answer is that =RATE() is the function that calculates the interest rate for an annuity. This is true because the RATE() function in Excel is used to calculate the interest rate for an annuity or a loan. It returns the interest rate per period for a loan or an investment based on periodic, constant payments and a constant interest rate. Therefore, this statement accurately describes the functionality of the RATE() function in Excel.

    Rate this question:

  • 31. 

    Dupa inserarea liniei intr-un tabel,formulele se actualizeaza automat?

    • Nu

    • Da

    • Numai daca sau folosit referinte absolute

    Correct Answer
    A. Da
    Explanation
    After inserting a row in a table, the formulas do not automatically update.

    Rate this question:

  • 32. 

    O pers fizica isi deschidde cont la o banca cu capitalizare.Lunar se depun 80 de ron.Presupunind ca rata dobinzii va fi constatnta,ce functii folositi pentru a afla valoarea capitalizata dupa 5 ani?

    • Fv

    • Irr

    • Pv

    • Nici una

    Correct Answer
    A. Fv
    Explanation
    The correct answer is "fv". In this question, the individual is opening an account with a bank that has compounding interest. The monthly deposit is 80 ron and the interest rate is assumed to be constant. The function "fv" is used to calculate the future value of the account after 5 years.

    Rate this question:

  • 33. 

    In excel ,rata de rambursat dintr-un credit se determina cu ajutorul functiei:

    • =PMT()

    • =RATE()

    • =IRR()

    • =FV()

    Correct Answer
    A. =PMT()
    Explanation
    The correct answer is =PMT(). In Excel, the PMT() function is used to calculate the periodic payment for a loan or an investment based on a constant interest rate and a fixed number of periods. It takes inputs such as the interest rate, the number of periods, and the present value of the loan or investment, and returns the amount that needs to be paid or received at each period. This function is commonly used in financial calculations and planning.

    Rate this question:

  • 34. 

    In excel in casutele foilor de calcul se introduc:

    • Date numarice

    • Siruri de caractere

    • Date calendaristice

    • Formule

    • Functii

    Correct Answer(s)
    A. Date numarice
    A. Siruri de caractere
    A. Date calendaristice
    A. Formule
    A. Functii
    Explanation
    In Excel, the cells are used to input various types of data such as numeric data, character strings, calendar dates, formulas, and functions. Numeric data refers to any numerical values that can be used for calculations. Character strings are sequences of characters or text. Calendar dates are used to represent specific dates or time periods. Formulas are used to perform calculations and manipulate data in cells. Functions are predefined formulas that perform specific operations and return results.

    Rate this question:

  • 35. 

    Dezavantajele organizarii datelor supa modelul fisierelor independente sunt;

    • Obtinerea rapida a raspunsurilor la interogarile ad-hoc

    • Costul ridicat

    • Modelarea inadecvata a lumii reale

    • Flexibilitatea la schimbarile ulterioare

    Correct Answer(s)
    A. Costul ridicat
    A. Modelarea inadecvata a lumii reale
    Explanation
    The correct answer is "costul ridicat" (high cost) and "modelarea inadecvata a lumii reale" (inadequate modeling of the real world). This is because organizing data in independent file models can be expensive in terms of storage and maintenance. Additionally, the model may not accurately represent the real-world scenario, leading to potential errors or inefficiencies in data analysis and decision-making processes.

    Rate this question:

  • 36. 

    Intrun grafic de tip column sau bar,seriile de date sunt reprezentate pe :

    • Axa Oy

    • Axa Ox

    • Ambele axe

    Correct Answer
    A. Axa Oy
    Explanation
    The correct answer is "axa Oy". In a column or bar graph, the data series are represented on the y-axis. The y-axis is the vertical axis of the graph, which typically represents the dependent variable or the variable being measured. The x-axis, on the other hand, represents the independent variable or the variable that is being manipulated or controlled. Therefore, in this case, only the y-axis is used to represent the data series.

    Rate this question:

  • 37. 

    Interogarea unei baze de date pentru a obtine rezultatele intr-o zona distincta,presupune existenta/definirea urmatoarelor zone;

    • Zona datelor de intrare

    • Zona datelor de iesire

    • Zona criteriilor

    • Zona datelor protejate

    Correct Answer(s)
    A. Zona datelor de intrare
    A. Zona datelor de iesire
    A. Zona criteriilor
    Explanation
    The correct answer is that querying a database to obtain results in a distinct area requires the existence/definition of the following zones: the input data zone, the output data zone, and the criteria zone. These zones are necessary to specify where the data is coming from, where it is going, and what criteria are being used to filter the results.

    Rate this question:

  • 38. 

    Intr-o baza de date realizata intrun program de calcul tabelar,o linie reprezinta:

    • O inregistrare

    • Un atribut

    • Un cimp

    Correct Answer
    A. O inregistrare
    Explanation
    In a database created in a spreadsheet program, a row represents a record. Each row contains a set of related data that represents a single entity or object. This data is organized into columns, with each column representing a different attribute or field. Therefore, a row or line in a database table is commonly referred to as a record, as it contains all the information about a specific entry in the database.

    Rate this question:

  • 39. 

    Actualizarea foii de calul prin inserare si sau stergerea de linii /coloana determina:

    • Actualizarea adreselor de casute utilizate in formule si functii

    • Pierderea continutului casutelor utilizate in functii si formule

    • Rearanjarea si renumerotarea automata a liniilor si /sau coloanelor

    Correct Answer(s)
    A. Actualizarea adreselor de casute utilizate in formule si functii
    A. Rearanjarea si renumerotarea automata a liniilor si /sau coloanelor
    Explanation
    Inserarea și ștergerea de linii/coloane în foaia de calcul determină actualizarea adreselor de casuțe utilizate în formule și funcții, precum și rearanjarea și renumerotarea automată a liniilor și/sau coloanelor. Aceasta înseamnă că, atunci când se adaugă sau se elimină linii sau coloane, adresele casuțelor utilizate în formule și funcții trebuie să fie actualizate pentru a reflecta noile poziții ale casuțelor. De asemenea, rearanjarea și renumerotarea automată a liniilor și/sau coloanelor asigură că acestea sunt ordonate corect și numerotate în mod consecutiv.

    Rate this question:

  • 40. 

    In modelul relational de organizare a datelor, care dintre urmatoarele enunturi sunt adevarate?

    • Atunci cind cheia primara a unei tabele este compusa, nici un atribut din cheie nu poate fi eliminat fara distrugerea unicitatii tuplului

    • Valorile atributului/atributelor desemneaza cheia primara nu sunt intotdeauna specificate

    • Atucni cind chia primara a unai tabele este compusa, un atribut din compozitia cheii primare poate avea valori nule

    Correct Answer
    A. Atunci cind cheia primara a unei tabele este compusa, nici un atribut din cheie nu poate fi eliminat fara distrugerea unicitatii tuplului
    Explanation
    When the primary key of a table is composite, no attribute of the key can be eliminated without destroying the uniqueness of the tuple.

    Rate this question:

  • 41. 

    In excel,formulele:

    • Sunt elemente de baza a unei foi de calcul

    • Efectueaza numai calcule aritmetice simple

    • Sunt precedate intotdeauna de semnul %

    • Sunt construite de utilizator

    Correct Answer(s)
    A. Sunt elemente de baza a unei foi de calcul
    A. Sunt construite de utilizator
    Explanation
    The correct answer is "sunt elemente de baza a unei foi de calcul, sunt construite de utilizator." This is because the given statements describe the characteristics of formulas in Excel. Formulas are basic elements of a spreadsheet and they are built by the user. They are not limited to simple arithmetic calculations and they are not always preceded by the % sign.

    Rate this question:

  • 42. 

    Care dintre urm constructii sunt corecte din punct de vedere sintactic?

    • =DSUM(D2:D22,2,C2>0)

    • NPER(D2:D22)

    • =RATE(D2:D22,2,C2>0)

    • =VLOOKUP(A40,A2:D35,3)

    Correct Answer
    A. =VLOOKUP(A40,A2:D35,3)
    Explanation
    The correct answer is "=VLOOKUP(A40,A2:D35,3)". This is a valid syntax for the VLOOKUP function in Excel. It searches for a value in the first column of a table array and returns a value in the same row from a specified column. In this case, it is searching for the value in cell A40 in the range A2:D35 and returning the value in the third column of the range.

    Rate this question:

  • 43. 

    Intrun grafic de tip PIE se reprezinta:

    • O singura serie de date

    • Doua serii de date

    • Mai multe serii de date

    Correct Answer
    A. O singura serie de date
    Explanation
    A pie chart represents a single series of data. It is a circular chart divided into sectors, with each sector representing a proportionate part of the whole. Each sector's size is determined by the value it represents in relation to the total value of the data set. Therefore, a pie chart is used to show the distribution or composition of a single set of data categories or variables. It is not suitable for comparing multiple sets of data or showing trends over time.

    Rate this question:

  • 44. 

    Cum va interpreta Excel constructia =12/04/07

    • Ca fiind data calendaristica 12 martie 2007

    • Ca fiind data calendaristica 4 decembrie 2007

    • Ca fiind o expresie matematica

    Correct Answer
    A. Ca fiind o expresie matematica
    Explanation
    The given Excel construction "=12/04/07" will be interpreted as a mathematical expression because it follows the format of a mathematical calculation with numbers and operators. It does not contain any specific formatting or indicators to suggest that it represents a calendar date. Therefore, Excel will treat it as a mathematical calculation and perform the division operation between 12 and 4, resulting in the value 3.

    Rate this question:

  • 45. 

    In excel functiile:

    • Sunt formule predefinite

    • Sunt foarte greu de editat

    • Permit executarea rapida a unor calcule complexe

    • Sunt precedate de semnul=

    Correct Answer(s)
    A. Sunt formule predefinite
    A. Permit executarea rapida a unor calcule complexe
    A. Sunt precedate de semnul=
    Explanation
    The correct answer is that Excel functions are predefined formulas, allow for the quick execution of complex calculations, and are preceded by the equals sign.

    Rate this question:

  • 46. 

    In excel,formulele sunt formate din:

    • Nume(cuvinte rezervate stabilite de utilizator)

    • Argumente incluse intre paranteze patrate

    • Nume(cuvinte rezervate de semnul =)

    Correct Answer
    A. Nume(cuvinte rezervate de semnul =)
    Explanation
    Formulas in Excel are formed by using reserved words, which are indicated by the equal sign (=) followed by the name of the function or operation. These reserved words are predefined by Excel and have specific meanings. When creating a formula, the equal sign is used to indicate that the following characters are part of a formula and not regular text. Therefore, the correct answer states that formulas in Excel are formed using reserved words indicated by the equal sign (=).

    Rate this question:

  • 47. 

    In excel,care dintre aceste constructii dau acelasi rezultat

    • =(B3+C3+D3+E3)/4

    • =SUM(B3:E3)/4

    • =AVERAGE(B3:E3)

    • =(B3:E3)/4

    Correct Answer(s)
    A. =(B3+C3+D3+E3)/4
    A. =SUM(B3:E3)/4
    A. =AVERAGE(B3:E3)
    Explanation
    All of the given constructions yield the same result because they are all calculating the average of the values in cells B3, C3, D3, and E3. The first construction directly adds the values and divides by 4, the second construction uses the SUM function to add the values and then divides by 4, and the third construction uses the AVERAGE function to calculate the average of the values. The fourth construction, =(B3:E3)/4, is incorrect as it divides the range by 4 instead of calculating the average.

    Rate this question:

  • 48. 

    Programele de calcul tabelar:

    • Sunt produse integrate care permit lucrul cu tabele,baze se date,grafice

    • Preiau din sarcina functionarilor lucrarilor de rutina

    • Preiau din sarcina utilizatorilor partea creativa a unei aplicatii

    Correct Answer(s)
    A. Sunt produse integrate care permit lucrul cu tabele,baze se date,grafice
    A. Preiau din sarcina functionarilor lucrarilor de rutina
    Explanation
    Programmele de calcul tabelar sunt produse integrate care permit lucrul cu tabele, baze de date și grafice. Aceste programe preiau din sarcina functionarilor lucrările de rutină, oferindu-le posibilitatea de a automatiza și simplifica procesele repetitive. De asemenea, ele preiau din sarcina utilizatorilor partea creativă a unei aplicații, oferindu-le instrumente și funcționalități avansate pentru a crea și manipula datele într-un mod flexibil și eficient.

    Rate this question:

  • 49. 

    Inca de la inceputurile sale informatica s-a confruntat cu urmatoarele probleme:

    • Efectuarea de calcule complexe

    • Stocarea si gestionarea unui volum de informatii din ce in ce mai mare

    • Efectuarea de calcule din ce in ce mai simple

    • Diminuarea volumului de informatii stocate

    Correct Answer(s)
    A. Efectuarea de calcule complexe
    A. Stocarea si gestionarea unui volum de informatii din ce in ce mai mare
    Explanation
    From the beginning, computer science has faced the following problems: performing complex calculations, storing and managing an increasing volume of information. These challenges have been addressed by developing more advanced algorithms and data storage systems to handle the growing complexity and size of data.

    Rate this question:

Quiz Review Timeline (Updated): Jul 22, 2024 +

Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.

  • Current Version
  • Jul 22, 2024
    Quiz Edited by
    ProProfs Editorial Team
  • Mar 27, 2013
    Quiz Created by
    Isatest
Back to Top Back to top
Advertisement