Capitolul 3

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 Wymorlo
W
Wymorlo
Community Contributor
Quizzes Created: 1 | Total Attempts: 1,737
| Attempts: 1,737 | �ntrebri: 117
Please wait...
Question 1 / 117
0 %
0/100
Score 0/100
1. Care funcţie calculează media aritmetică simplă?

Explanation

The correct answer is AVERAGE because it is the function that calculates the simple arithmetic mean. This function adds up all the numbers in a given set and divides the sum by the count of numbers in the set to find the average value.

Submit
Please wait...
About This Quiz
Capitolul 3 - Quiz

Tell us your name to personalize your report, certificate & get on the leaderboard!
2. Argumentele funcţiilor Excel sunt incluse între caracterele:

Explanation

The correct answer is ( ). In Excel, arguments of functions are enclosed within parentheses. This is a standard practice in programming and mathematical expressions to clearly indicate the parameters or values that are being passed to a function. The parentheses help to separate the arguments from the rest of the formula and ensure that the function is executed correctly.

Submit
3. Excel face parte din:

Explanation

Excel is a spreadsheet program developed by Microsoft, so it is part of MS Office, which is a suite of productivity applications developed by Microsoft. MS Office includes other programs like Word, PowerPoint, and Outlook. Therefore, Excel being part of MS Office is the correct answer.

Submit
4. Cu referire la Excel, care dintre următoarele enunţuri sunt adevărate?

Explanation

In Excel, the statements "într-un registru de lucru, foile de calcul pot fi redenumite" (in a workbook, worksheets can be renamed) and "într-un registru de lucru, utilizatorul poate adăuga sau şterge foi de calcul" (in a workbook, the user can add or delete worksheets) are true. This means that in Excel, users have the ability to rename worksheets and add or delete them as needed. However, the statement "într-un registru de lucru, numărul foilor de calcul nu poate fi mai mare de 3" (in a workbook, the number of worksheets cannot be greater than 3) is false, as there is no limit to the number of worksheets that can be added to a workbook in Excel.

Submit
5. In Excel, care din următoarele afirmaţii sunt adevărate?

Explanation

The correct answer is that after creation, an Excel chart can be modified using the options in the Chart menu, and modifying the data in the spreadsheet will also result in changes to the charts. However, modifying the data in the spreadsheet will not affect previously created charts.

Submit
6. Prin operaţiile de copiere sau mutare, adresele absolute se modifică?

Explanation

The given question asks if absolute addresses are modified through copying or moving operations. The correct answer is "no." This means that absolute addresses do not change when they are copied or moved.

Submit
7. Excel este:

Explanation

Excel is a program that is primarily used for creating and manipulating spreadsheets. It allows users to perform calculations, organize data, and create charts and graphs. Therefore, it can be classified as a program for spreadsheet calculations, or a program de calcul tabelar.

Submit
8. In Excel, ce se va afişa în căsuţa F8 după copierea funcţiei din căsuţa F7?
  D E F
7 10 5 =IF(E7+$D$7>25,"DA","NU")
8 20 10  
9 30 15  

Explanation

The correct answer is "NU" because the function in cell F7 is an IF function that checks if the value in cell E7 plus the value in cell D7 is greater than 25. If it is, the function returns "DA", otherwise it returns "NU". Since the value in cell E7 is 20 and the value in cell D7 is 10, which is not greater than 25, the function will return "NU". Therefore, the value displayed in cell F8 after copying the function from cell F7 will be "NU".

Submit
9. In Excel, ce se va afişa în căsuţa D8 prin copierea formulei din căsuţa D6?
  B C D
6     =C6*$B$6
7      
8      
 

Explanation

The formula "=C8*$B$6" will be displayed in cell D8 by copying the formula from cell D6.

Submit
10. In Excel, specificarea Preturi!B45 indică:

Explanation

The correct answer is "căsuţa B45 din foaia de calcul Preturi". This means that the specificarea "Preturi!B45" refers to cell B45 in the worksheet named Preturi.

Submit
11. In memoria internă, o dată calendaristică Excel este reprezentată:

Explanation

In memoria internă, o dată calendaristică Excel este reprezentată ca un număr. Acest lucru se datorează faptului că Excel utilizează un sistem de numerotare pentru a reprezenta datele calendaristice. Fiecare dată este atribuită unui număr întreg, iar acest număr reprezintă numărul de zile trecute de la o anumită dată de referință. Astfel, reprezentarea unei date ca un număr permite utilizatorului să efectueze operații matematice și calcule cu aceasta în Excel.

Submit
12. Ce realizează funcţia logică IF?

Explanation

The correct answer is: indică tipul datei conţinute de o căsuţă a foii de calcul.

The IF logical function is used to test a condition and return different values based on whether the condition is true or false. It is commonly used in spreadsheet programs like Excel to perform calculations or make decisions based on the content of a cell. In this case, the function is used to indicate the type of data contained in a cell in a spreadsheet.

Submit
13. Care dintre urmatoarele reguli trebuie respectate in Excel?

Explanation

The rule that must be respected in Excel is that no spaces should be left between the numbers of the function and the arguments.

Submit
14. Programele de calcul tabelar:

Explanation

Programs de calcul tabelar integratează facilități de lucru cu tabele și permit reprezentarea grafică a datelor.

Submit
15. La modificarea conţinutului unei căsuţe, are loc:

Explanation

When the content of a cell is modified, both the automatic recalculation of formulas and functions that reference that cell and the automatic reconstruction of the graph that represents the value in that cell occur.

Submit
16. In Excel, reprezentarea structurii profitului anual pe cele patru trimestre se realizează într-un grafic de tip:

Explanation

The correct answer for this question is "Pie". In Excel, a pie chart is used to represent the annual profit structure for the four quarters. A pie chart is a circular chart divided into sectors, where each sector represents a different category or data point. Each sector's size is proportional to the data it represents, allowing for easy comparison of the profit distribution across the four quarters.

Submit
17. In foile de calcul Excel, adresele căsuţelor pot fi:

Explanation

In foile de calcul Excel, adresele căsuțelor pot fi relative, absolute și mixte. Adresele relative se ajustează automat în funcție de poziția relativă a căsuței față de cea de referință. Adresele absolute rămân neschimbate și nu se ajustează în funcție de poziție. Adresele mixte au o parte relativă și o parte absolută și se ajustează în funcție de poziție doar într-o direcție.

Submit
18. In căsuţele foilor de calcul Excel, pot fi introduse :

Explanation

In the cells of an Excel spreadsheet, various types of data can be entered. These include numeric values, strings of characters (text), formulas, and functions. Numeric values can be used for calculations, while strings of characters are used to represent text. Formulas are used to perform calculations based on the values in other cells, and functions are pre-defined formulas that perform specific calculations or actions.

Submit
19. In Excel, prin operaţiile de copiere adresele absolute se modifică?

Explanation

The question is asking whether absolute addresses change during copy operations in Excel. The correct answer is "no." This means that when you copy a cell or range of cells with absolute addresses, the addresses will not be modified.

Submit
20. In Excel, ce realizează funcţia IF?

Explanation

The correct answer is: calculul mediei aritmetice pentru valorile mai mari de 5.

The IF function in Excel is used to perform a logical test and return different values based on the result of that test. In this case, the IF function is being used to calculate the average for values greater than 5. It checks each value and if it is greater than 5, it includes it in the calculation of the average.

Submit
21. Să presupunem că s-a realizat o investiţie care aduce în următorii 3 ani, următoarele încasări: în anul 2008, 8 RON, în anul 2009, 7 RON, iar în 2010, 6,5 RON. Ce funcţie financiară se utilizează pentru a estima eficienţa investiţiei realizate, sub as­pectul ratei de rentabilitate?

Explanation

The correct answer is IRR (Internal Rate of Return). IRR is a financial function used to estimate the profitability of an investment by calculating the rate at which the net present value (NPV) of future cash flows equals zero. In this case, the IRR would be used to determine the rate of return on the investment based on the cash inflows of 8 RON in 2008, 7 RON in 2009, and 6.5 RON in 2010. By comparing the IRR to a required rate of return or hurdle rate, one can assess the efficiency of the investment.

Submit
22. Opţiunea de sortare, la un moment dat, poate fi

Explanation

The option of sorting can be either in ascending order, descending order, or both ascending and descending.

Submit
23. Care din următoarele enunţuri sunt corecte?

Explanation

The correct answer is IRR determină rata internă de rentabilitate pentru o serie de venituri generate de o investiţie. This statement is correct because IRR (Internal Rate of Return) is a financial metric that calculates the rate at which an investment breaks even or generates a desired return. It takes into account a series of cash flows or income generated by the investment. On the other hand, DDB (Double Declining Balance) is a depreciation method that calculates the depreciation expense of an asset over its useful life using an accelerated rate. Therefore, the statement "DDB calculează amortizarea după metoda degresivă" is also correct.

Submit
24. Considerând o zonă dintr-o foaie de calcul, B5:B10, denumită Venituri, cum se poate exprima suma valorilor din căsuţele acestei zone?

Explanation

The correct answer is =SUM(B5:B10) because it uses the SUM function to calculate the sum of the values in the range B5 to B10. The other options are incorrect because they either use the wrong syntax or refer to the named range Venituri instead of the actual range B5:B10.

Submit
25. Ce restricţii trebuie să respecte zona criteriu creată pentru interogarea unei baze de date?

Explanation

The restriction that the query criteria zone must adhere to is that the name of the field referenced in the condition must be identical to the one in the database structure.

Submit
26. In Excel, pentru calculul amortizării, se folosesc funcţiile:

Explanation

The correct answer is =SLN(), =DDB(), =SYD(). These functions in Excel are used for calculating depreciation. The =SLN() function calculates depreciation using the straight-line method, =DDB() function calculates depreciation using the double-declining balance method, and =SYD() function calculates depreciation using the sum of years' digits method. These functions are commonly used in financial analysis and accounting to determine the value of an asset over time.

Submit
27. In Excel, funcţiile:

Explanation

Funcțiile în Excel sunt formule predefinite care permit executarea rapidă a unor calcule complexe și sunt precedate de semnul =.

Submit
28. In Excel, formulele:

Explanation

The given correct answer is that formulas in Excel are basic elements of spreadsheets and are constructed by the user. This means that formulas are essential for performing calculations and manipulating data in Excel, and users have the ability to create their own formulas to meet their specific needs and requirements.

Submit
29. In Excel, ce se va afişa în căsuţa D7 după copierea formulei din D6?
  B C D
6 1000   =B6*$C$6
7 2000    
8 3000    
 

Explanation

The formula in cell D7 is "=B6*$C$6". This means that the value in cell D7 will be equal to the value in cell B6 multiplied by the value in cell C6. In this case, the value in cell B6 is 2000 and the value in cell C6 is 1000. Therefore, the value in cell D7 will be 2000 * 1000 = 2000000.

Submit
30. Protejarea unei foi de calcul Excel asigură

Explanation

The correct answer is "evitarea riscului deteriorării voluntare a aplicaţiei, evitarea riscului deteriorării involuntare a aplicaţiei." Protecting an Excel spreadsheet ensures the prevention of both intentional and unintentional damage to the application.

Submit
31. După inserarea unei linii într-un tabel, formulele se actualizează automat?

Explanation

After inserting a row in a table, the formulas in the table will automatically update.

Submit
32. Simulările în tabele de simulare pot fi realizate în funcţie de:

Explanation

The correct answer is "o variabilă, două variabile". This means that simulations in simulation tables can be conducted based on either one variable or two variables. It implies that simulations can be done with different combinations of variables, depending on the specific scenario or analysis being performed.

Submit
33. Actualizarea foii de calcul prin inserarea şi/sau ştergerea de linii şi/sau coloane determină:

Explanation

When a spreadsheet is updated by inserting or deleting rows and/or columns, it will result in the updating of cell addresses used in functions and formulas. Additionally, it will automatically rearrange and renumber the rows and/or columns.

Submit
34. Care dintre următorii operatori se utilizează pentru concatenarea şirurilor de caractere?

Explanation

Operatorul "&" se utilizează pentru concatenarea şirurilor de caractere în limbajul de programare specificat în întrebare.

Submit
35. Să presupunem că s-a realizat o investiţie care aduce în următorii 3 ani încasările: în anul 2008, 3500 RON; în 2009, 10500 RON; în 2010, 5200 RON. Ce funcţie financiară se utilizează pentru a determina valoarea netă prezentă a investiţiei?

Explanation

The correct answer is NPV (Net Present Value). NPV is used to determine the current value of an investment by discounting the future cash flows back to the present. In this case, the cash flows for the next 3 years are given, and by calculating the NPV, we can determine the value of the investment at present.

Submit
36. Care din următoarele funcţii determină primele 3 valori diptr-o zonă a foii de calcul?

Explanation

The correct answer is MIN. The MIN function determines the smallest value in a range of cells. In this case, it would determine the first 3 smallest values in a specific area of the spreadsheet.

Submit
37. In Excel, care dintre următoarele enunţuri sunt adevărate?

Explanation

The correct answer is that in the calculation of annuities, equal payments and regular intervals of time are used, and the number of periods and interest rate must refer to the same time interval. This means that when calculating annuities, the payments made are the same amount and occur at regular intervals, such as monthly or annually. Additionally, the number of periods and interest rate used in the calculation must be based on the same time frame, such as years or months.

Submit
38. Programele de calcul tabelar:

Explanation

Programs de calcul tabelar sunt produse integrate care permit lucrul cu tabele, baze de date, grafice etc. Aceste programe preiau din sarcina funcţionarilor lucrările de rutină, oferindu-le astfel mai mult timp pentru alte activități. Prin automatizarea acestor lucrări repetitive, programul de calcul tabelar permite utilizatorilor să se concentreze mai mult pe partea creativă a unei aplicații, cum ar fi analiza datelor și generarea de rapoarte personalizate.

Submit
39. In Excel, care dintre următoarele afirmaţii sunt adevărate?

Explanation

In the calculation of annuities, equal payments and regular intervals of time are used. This means that when calculating annuities, the payments made are of the same amount and occur at fixed intervals, such as monthly or annually. This allows for easier calculation and planning of cash flows over a period of time. The other statements in the question are not true. In the calculation of depreciation, equal payments are not used, and in the Vlookup() function in Excel, the search is performed vertically in the leftmost column of a table, not the rightmost column.

Submit
40. In proiectarea aplicaţiilor folosind programele de calcul tabelar trebuie parcurse următoarele etape:

Explanation

The correct answer is the sequence of steps that need to be followed in the design of applications using spreadsheet programs. These steps include analyzing the problem and constructing a solution model, building the model in the spreadsheet, and utilizing the model. The last option, formatting the hard disk for correct data retrieval, is not a step in the design process of applications using spreadsheet programs.

Submit
41. O persoană fizică vrea să ia un împrumut de la o bancă, cu rambursare în 10 ani, în condiţiile în care îşi permite să plă­tească lunar o rată de 100 RON. In condiţiile în care rata do­bânzii va fi neschimbată (7%), ce funcţie folosiţi pentru a afla valoarea maximă a creditului de care poate beneficia în prezent persoana în cauză?

Explanation

The correct answer is PV, which stands for Present Value. In this scenario, the person wants to know the maximum amount of credit they can benefit from currently. The Present Value function is used to calculate the current value of a future payment or investment, taking into account the interest rate and the time period. By using the PV function, the person can determine the maximum loan amount they can afford to repay over 10 years with a monthly payment of 100 RON, considering the unchanged interest rate of 7%.

Submit
42. In Excel, în căsuţele foilor de caicul se introduc:

Explanation

In Excel, the cells can be used to input 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 can be entered to represent specific dates. Formulas are used to perform calculations on the data in the cells. Functions are pre-defined formulas that can be used to perform specific calculations or operations.

Submit
43. Care dintre următoarele construcţii sunt corecte din punct de vedere sintactic?

Explanation

The construction "=VLOOKUP(A40,A2:D35,3)" is correct from a syntactic point of view. It uses the VLOOKUP function to search for a value in the range A2:D35 and returns the corresponding value from the third column. The syntax of the function is correct, with the lookup value "A40" in the first argument, the range "A2:D35" in the second argument, and the column index "3" in the third argument.

Submit
44. Intr-un tabel de simulare cu două variabile:

Explanation

The correct answer suggests that the formula for calculation should be written at the intersection of the first row and the first column in the results area of a simulation table with two variables. This means that the formula will be applied to the values of the two variables and the result will be displayed in the corresponding cell.

Submit
45. . In Excel, ce se va afişa în căsuţa D8 după copierea formulei din căsuţa D7?
  B C D
7   5000 =C7/$B$7
8   7000  
9   9000  

Explanation

The formula in cell D8 is "=C8/$B$7". This means that the value in cell C8 will be divided by the value in cell B7. In this case, the value in cell C8 is 7000 and the value in cell B7 is 5000. So, when the formula is copied from cell D7 to cell D8, it will calculate 7000/5000, which equals 1.4. Therefore, the value that will be displayed in cell D8 after copying the formula is 1.4.

Submit
46. 52. Intr-un grafic de tip COLUMN sau BAR, seriile (grupurile) de date sunt reprezentate pe:

Explanation

In a column or bar chart, the series or groups of data are represented on the y-axis. The y-axis is the vertical axis of the chart, and it is used to display the values or categories being compared. The x-axis, on the other hand, is the horizontal axis of the chart and is typically used to represent the different data points or categories being analyzed. Therefore, in this type of chart, the series or groups of data are represented on the y-axis.

Submit
47. In Excel, care dintre următoarele enunţuri sunt adevărate

Explanation

The correct answer is "=RATE( ) este funcţia care calculează procentul dobânzii pentru o anuitate." This statement is true because the RATE() function in Excel is used to calculate the interest rate for an annuity. An annuity is a series of equal payments made at regular intervals, and the RATE() function helps determine the interest rate needed to achieve a desired future value or payment amount.

Submit
48. In Excel, care din următoarele construcţii dau acelaşi rezultat?

Explanation

The given question asks which of the constructions will give the same result in Excel. The correct answer is =(B3+C3+D3+E3)/4, =SUM(B3:E3)/4, and =AVERAGE(B3:E3). These three constructions all calculate the average of the values in cells B3 to 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 directly. All three constructions will give the same result.

Submit
49. Cum va interpreta Excel construcţia =12/04/07

Explanation

Excel interprets the construction =12/04/07 as a mathematical expression because it starts with an equal sign, which is the syntax for entering formulas in Excel. The forward slashes (/) are recognized as division operators in Excel, so the expression is evaluated as 12 divided by 4 divided by 7. Therefore, Excel does not interpret this construction as a date, but rather as a mathematical calculation.

Submit
50. In Excel, protejarea poate fi realizată la nivel de:

Explanation

The correct answer is "registru de lucru, foaie de calcul, căsuţe". In Excel, protejarea (protection) can be applied at different levels. The "registru de lucru" refers to the entire workbook, meaning all the sheets within it. "Foaie de calcul" refers to individual worksheets within the workbook. And "căsuţe" refers to specific cells within a worksheet. By applying protection at these levels, you can control access and editing permissions for different parts of your Excel file.

Submit
51. Intr-o bază de date realizată într-un program de calcul tabelar, o linie reprezintă:

Explanation

Intr-o bază de date realizată într-un program de calcul tabelar, o linie reprezintă o înregistrare. O înregistrare este un set de date care conține informații referitoare la un anumit obiect sau subiect. Aceasta poate fi considerată ca o entitate individuală în cadrul bazei de date, iar fiecare linie reprezintă o înregistrare distinctă. Astfel, într-un program de calcul tabelar, o linie reprezintă o înregistrare care poate conține diferite atribute sau câmpuri de date.

Submit
52. In reprezentarea internă a datelor calendaristice, ce indică un număr întreg?

Explanation

The correct answer indicates that the integer number represents the number of days that have passed since January 1, 2000. This means that the internal representation of the calendar data counts the number of days elapsed since the beginning of the year 2000.

Submit
53. Formatarea datelor din foile de calcul Excel poate fi realizată:

Explanation

Data formatting in Excel spreadsheets can be done based on certain conditions set by the user or using predefined templates offered by the system. The user can customize the formatting rules according to their specific requirements, such as highlighting cells that meet a certain criteria or applying different formatting styles to different data ranges. Additionally, Excel provides built-in templates that users can apply to format their data quickly and easily, saving time and effort. Therefore, the correct answer is that data formatting in Excel can be done based on certain conditions set by the user and using predefined templates offered by the system.

Submit
54. Un tabel de simulare trebuie să cuprindă obligatoriu:

Explanation

A simulation table must include a formula for calculation, explanatory texts, a group of empty boxes for displaying results, and a set of values for one or two variables.

Submit
55. In Excel, funcţiile financiare permit:

Explanation

The correct answer is that financial functions in Excel allow for a wide range of calculations, the ability to perform economic and financial analysis, and the calculation of depreciation. These functions provide users with the tools to analyze and manipulate financial data efficiently and accurately.

Submit
56. O persoană fizică îşi deschide un cont de depozit la o bancă, cu capitalizare. Lunar se depun 80 RON. Presupunând că rata dobânzii va fi constantă, ce funcţie folosiţi pentru a afla valoarea capitalizată după 5 ani?

Explanation

The correct answer is FV, which stands for Future Value. In this context, the person is depositing 80 RON every month for a period of 5 years. The Future Value function is used to calculate the value of an investment or deposit at a future date, considering the interest rate and the compounding period. In this case, the function will help determine the total amount accumulated in the deposit after 5 years.

Submit
57. In Excel, care dintre enunţurile de mai jos sunt adevărate?

Explanation

The first statement is true because the VLOOKUP() function in Excel is used to search for a value vertically in the leftmost column of a specified range. The second statement is also true as the LOOKUP() function is used to search for values in a vector or matrix.

Submit
58. In Excel, ce se va afişa în căsuţa C9 care conţine formula=C7+C7*5%, dacă în C8 indicele inflaţiei ia valoarea 5,5%?
  B C
7 Venit (RON) 120
8 Indice de inflatie 5%
9 Venit actualizat = C7+C7*5%

Explanation

The formula in cell C9 is "=C7+C7*5%". When the value of the inflation index in cell C8 is 5.5%, the formula calculates the updated income by adding 5% of the income in cell C7 to the income in cell C7. Therefore, the correct answer is 126.

Submit
59. Intr-un grafic de tip PIE, se reprezintă:

Explanation

In a PIE chart, only one series of data is represented. A PIE chart is a circular chart that is divided into slices, with each slice representing a category or a proportion of the whole. Each slice's size is proportional to the value it represents in relation to the total value. Therefore, a PIE chart can effectively represent only one series of data at a time. It is not suitable for representing multiple series of data simultaneously.

Submit
60. Stabilirea parametrilor de format pentru datele din foaia de cal­cul se realizează în etapa:

Explanation

The correct answer is "construirea modelului în foaia de calcul" which translates to "building the model in the spreadsheet". This means that the process of establishing the formatting parameters for the data in the spreadsheet is done during the construction of the model in the spreadsheet. This involves setting up the structure, layout, and formatting of the cells, columns, and rows to ensure that the data is organized and displayed correctly.

Submit
61. In Excel, rata de rambursat dintr-un credit se determină cu aju­torul funcţiei:

Explanation

The correct answer is =PMT(). The PMT() function in Excel is used to calculate the periodic payment for a loan or an investment based on a constant interest rate and a fixed payment schedule. It takes into account the loan amount, interest rate, and the number of payment periods. By using this function, one can easily determine the repayment amount for a loan or the periodic investment required to reach a specific target amount.

Submit
62. In Excel, formulele:

Explanation

The explanation for the given answer is that formulas in Excel contain both values and operators. They can also include numbers, dates, and text. However, they cannot contain the operators % and ^.

Submit
63. Ce valoare se va afişa în căsuţa C9, care conţine formula =C8*16%, dacă în C7 cota de impozit se modifică la 15%?
  B C
7 Cota impozit 16%
8 Profit 1000
9 Impozit pe progit 160

Explanation

If the tax rate in cell C7 is changed to 15%, the formula in cell C9 (=C8*16%) will calculate the tax on the profit in cell C8 (1000) using the new tax rate of 15%. The calculation will be 1000 * 15% = 150. Therefore, the value displayed in cell C9 will be 150.

Submit
64. Un program de calcul tabelar performant trebuie să permită:

Explanation

A performant spreadsheet program should allow for simultaneous work with multiple tables, graphical representation of data, and the use of linking and embedding techniques through DDE and OLE. Additionally, it should also have the ability to lock functions that are predefined for financial calculations.

Submit
65. Ştergerea unei înregistrări dintr-o bază de date se realizează prin:

Explanation

The correct answer is "ştergerea liniei corespunzătoare din foaia de calcul" because deleting a record from a database typically involves removing the corresponding row from a spreadsheet or table. This action physically removes the data from the database, ensuring that it is no longer accessible or included in any calculations or queries. Using the appropriate command from the Data menu or pressing the Delete or Backspace keys may be valid actions in some software programs, but they are not the most common or standard methods for deleting a record from a database.

Submit
66. Sortarea bazelor de date în EXCEL se poate realiza după:

Explanation

The correct answer is that sorting databases in Excel can be done based on three keys, two keys, or a single key. This means that Excel allows users to sort their databases based on multiple criteria or a single criterion, depending on their needs. Sorting by multiple keys can help organize data more effectively and provide more specific results, while sorting by a single key may be sufficient for simpler datasets.

Submit
67. In foile de calcul Excel, căsuţele sunt referite prin:

Explanation

In Excel spreadsheets, cells can be referred to using absolute addresses, names, relative addresses, or mixed addresses. Absolute addresses refer to specific cells by their fixed location, while relative addresses are based on the position relative to the current cell. Mixed addresses combine elements of both absolute and relative addresses. Names can be assigned to cells or ranges of cells to make them easier to reference. Bookmarks are not a valid way to refer to cells in Excel.

Submit
68. Care dintre următoarele construcţii sunt adevărate?

Explanation

The correct answer is a combination of valid constructions in Excel. "Sheet2!C34" refers to cell C34 in Sheet2. "[Situatie_scolara.xls]Anul_1 !F6" refers to cell F6 in the worksheet Anul_1 in the Situatie_scolara.xls file. "A:B" refers to all cells in columns A and B. These are all valid ways to reference specific cells or ranges in Excel.

Submit
69. Modificarea unei înregistrări dintr-o bază de date se realizează:

Explanation

The modification of a record in a database can be done by either entering a new value in the corresponding field, or by using the command EDIT (F2). These options allow the user to update the data in the specific field that needs to be modified. The first option involves directly inputting a new value into the field, while the second option provides a shortcut command (EDIT or F2) to access and modify the field. Both methods achieve the same result of updating the record in the database.

Submit
70. Interogarea unei baze de date pentru a obţine rezultatele într-o zonă distinctă, presupune existenţa/definirea următoarelor zone:

Explanation

The correct answer is that querying a database to obtain results in a distinct area requires the existence/definition of the following areas: the input data area, the output data area, and the criteria area. These areas are necessary for organizing and specifying the data that will be used in the query process. The input data area holds the data that will be used as input for the query, the output data area stores the results of the query, and the criteria area defines the conditions that the data must meet in order to be included in the query results.

Submit
71. In Excel, comenzile pot fi apelate din

Explanation

The correct answer is that Excel commands can be accessed from menus and submenus, icons in the toolbars (Standard, Formatting, etc.), and the context menu.

Submit
72. In programele de calcul tabelar, analiza rezultatelor se realizează în etapa

Explanation

The correct answer is "utilizarea modelului". In spreadsheet programs, the analysis of results is performed in the stage of using the model. This means that once the model has been constructed in the spreadsheet, it can be used to analyze and manipulate data to obtain desired results. The analysis of the problem and the design of the solution model are important steps prior to using the model, but the actual analysis of results occurs during the utilization of the model.

Submit
73. In Excel, care din următoarele afirmaţii sunt adevărate?

Explanation

In Excel, the statements that are true are that you can write on multiple lines in a cell and the Merge cells option allows you to combine multiple cells.

Submit
74. Cheile de sortare pot fi:

Explanation

The correct answer is "un câmp din structura bazei de date, mai multe câmpuri din structura bazei de date" because sorting keys can be single fields or multiple fields within the database structure. These fields are used to determine the order in which the data is arranged, allowing for easier searching and organizing of information within the database.

Submit
75. Care dintre următoarele instrumente software sunt programe de calcul tabelar?

Explanation

The correct answer is Excel, Lotus 1-2-3, and Quattro Pro. These three software tools are all spreadsheet programs that allow users to create and manipulate tables of data. They provide features such as formulas, functions, and formatting options to perform calculations and organize information in a tabular format. Access and Visual FoxPro, on the other hand, are database management systems, which are not specifically designed for creating tables of data.

Submit
76. Care din următoarele funcţii sunt financiare?

Explanation

The functions IRR, DDB, and FV are financial functions. IRR stands for Internal Rate of Return, which is used to calculate the profitability of an investment. DDB stands for Double Declining Balance, which is a method of depreciation commonly used in accounting. FV stands for Future Value, which is used to calculate the value of an investment or loan at a future date. These functions are specifically related to financial calculations and are commonly used in financial analysis and planning.

Submit
77. Progamele de calcul tabelar:

Explanation

The correct answer is "permit realizarea de simulari in grafice, permit organizarea datelor in baze de date." This means that spreadsheet programs allow for the creation of simulations using graphs and the organization of data into databases.

Submit
78. Extragerea de informaţii dintr-o bază de date într-o altă zonă a foii de calcul presupune:

Explanation

The correct answer is "definirea zonei criteriu şi a zonei de ieşire" which means defining the criteria zone and the output zone. This implies that in order to extract information from a database in another area of the spreadsheet, both the criteria zone (to indicate the condition that records must meet) and the output zone need to be defined. This ensures that the desired information is filtered and displayed correctly.

Submit
79. Care dintre următoarele funcţii Excel intră în categoria funcţiilor statistice?

Explanation

The given functions =AVERAGE(), =COUNT(), and =MIN() are categorized as statistical functions in Excel. The AVERAGE() function calculates the average of a range of cells, the COUNT() function counts the number of cells in a range that contain numbers, and the MIN() function returns the smallest value in a range of cells. These functions are commonly used in statistical analysis and calculations.

Submit
80. In Excel, formulele sunt formate din:

Explanation

Formulele în Excel sunt formate din nume (cuvinte rezervate precedate de semnul =). Aceasta este o caracteristică specifică a Excelului, unde utilizatorul trebuie să introducă formulele precedate de semnul "=" pentru a indica că este o formulă și nu o valoare statică. Această convenție ajută programul să facă distincția între datele statice și operațiile matematice sau logice pe care utilizatorul dorește să le efectueze.

Submit
81. In Excel, care din următoarele enunţuri sunt adevărate?

Explanation

The correct answer is that the arguments of functions can be other functions. This means that when using functions in Excel, you can use other functions as inputs to calculate the desired result. For example, you can use the SUM function as an argument in another function like AVERAGE to calculate the average of a range of cells. Additionally, in financial functions, the arguments refer to the same time period. This ensures that the calculations are consistent and accurate when analyzing financial data.

Submit
82. Care zone sunt necesare pentru realizarea unei operaţiuni de sortare?

Explanation

In order to perform a sorting operation, the input data needs to be provided. This input data is stored in the "zona de intrare" or the input zone. This zone holds the data that needs to be sorted and is necessary for the sorting operation to take place. The other options, "zona criteriilor" (criteria zone) and "zona de ieşire" (output zone), may be involved in the sorting process but are not specifically required for the operation to be performed.

Submit
83. O căsuţă (casetă) din foaia de calcul Excel poate fi identificată prin:

Explanation

A căsuță (casetă) din foaia de calcul Excel poate fi identificată prin adresa absolută, adresa mixtă, adresa relativă sau un nume atribuit în prealabil. Adresa absolută este o adresă fixă care nu se schimbă atunci când sunt efectuate operații de copiere sau mutare a celulelor. Adresa mixtă este o adresă care conține o combinație între o referință absolută și una relativă, ceea ce înseamnă că rândul sau coloana poate fi schimbată, dar nu și ambele în același timp. Adresa relativă este o adresă care se schimbă în funcție de poziția relativă față de celula de referință. Un nume atribuit în prealabil este o etichetă dată unei celule sau unui interval de celule pentru a le identifica mai ușor.

Submit
84. In Excel, un registru de lucru:

Explanation

not-available-via-ai

Submit
85. In Excel, protejarea componentelor modelului se realizează în etapa:

Explanation

Protejarea componentelor modelului în Excel se realizează în etapa de construire a modelului în foaia de calcul. În această etapă, utilizatorul poate aplica diverse opțiuni de protecție pentru a asigura că anumite celule sau formule nu pot fi modificate accidental sau intenționat de către alți utilizatori. Aceasta ajută la menținerea integrității și securității modelului în timpul utilizării și partajării acestuia.

Submit
86. In programele de calcul tabelar, introducerea datelor de intrare se realizează în etapa:

Explanation

The correct answer is "utilizarea modelului". This is because the question is asking about the stage in which the input data is entered in spreadsheet programs. The first option, "analiza problemei şi proiectarea modelului de rezolvare", refers to the analysis and design stage of the problem-solving model, which does not involve entering data. The second option, "construirea modelului în foaia de calcul", refers to the construction of the model in the spreadsheet, which also does not involve entering data. Therefore, the only remaining option is "utilizarea modelului", which means using the model, and this is the stage where the input data would be entered in a spreadsheet program.

Submit
87. In funcţia VLOOKUP:

Explanation

In the VLOOKUP function, the third argument indicates from which column the desired value is taken. The FALSE argument, placed at the end, indicates the need for an exact match in the search.

Submit
88. Realizarea copiilor de siguranţă se efectuează în etapa:

Explanation

The correct answer is "utilizarea modelului" which means "using the model" in English. This suggests that the safety of children is achieved through the utilization or implementation of the model that has been previously designed and constructed in a spreadsheet. The other options mentioned, such as analyzing the problem and designing the solution model, or constructing the model in a spreadsheet, are not the final step in achieving child safety.

Submit
89. Macro-urile din programele de calcul tabelar sunt:

Explanation

The correct answer is "secvenţe de instrucţiuni sau comenzi similare celor din limbajele de programare,elemente ce permit descrierea grupurilor de operaţiuni repetitive". This answer suggests that macros in spreadsheet programs are sequences of instructions or commands similar to those in programming languages, and they also allow for the description of groups of repetitive operations.

Submit
90. Ce implicaţii are regula „în formule şi funcţii nu se folosesc ca argumente constantele"?

Explanation

The implication of the rule "in formulas and functions, constants should not be used as arguments" is that it requires rewriting formulas and functions every time. This can lead to an inelegant or aesthetically unpleasing model. Additionally, this rule eliminates potential simulation capabilities and can result in incorrect results.

Submit
91. Care din următoarele formule şi funcţii sunt corecte?

Explanation

The first and third formulas and functions are correct. The first formula calculates the sum of "cant1" and divides it by either 3 or 5, depending on whether "cant1" is greater than "cant2". The third formula calculates the sum of "cantitate". The second formula is incorrect because it has a syntax error.

Submit
92. In Excel, care dintre enunţurile de mai jos sunt adevărate?

Explanation

The first statement is true because a worksheet in Excel is similar to a workbook, which is a collection of worksheets.

The second statement is false because a chart can be saved in a separate sheet within the workbook, not necessarily in the sheet containing the data.

The third statement is false because a workbook can be saved with different file extensions such as .xlsx or .xlsm, not just .xls.

The fourth statement is true because in Excel, dates are stored as numbers in the internal memory, where each date is represented by a specific number.

Submit
93. Următoarele calcule sunt realizate de funcţii financiare:

Explanation

The given answer states that the calculations performed by financial functions include the depreciation of assets using the straight-line method and the future value of a current investment. The straight-line method of depreciation evenly distributes the cost of an asset over its useful life, while the future value of an investment calculates the expected value of the investment at a future date based on the current value and the expected rate of return. Both of these calculations are commonly used in financial analysis and planning.

Submit
94. In fereastra unei funcţii Excel, se afişează:

Explanation

The answer is formatul funcției, descrierea succintă a funcției, zone distincte pentru argumentele funcției. In an Excel function window, these are the elements that are displayed. The format of the function refers to the syntax and structure of the function, while the concise description provides a brief explanation of what the function does. The distinct zones for the function arguments allow the user to input the necessary values for the function to calculate the desired result. The previous execution result is not displayed in the function window.

Submit
95. Cum se dispun componentele unui model de rezolvare în foaia de calcul?

Explanation

The components of a solving model can be arranged in different ways in a spreadsheet. One way is to place them in different spreadsheets, which means each component is in a separate spreadsheet. Another way is to arrange them in a cascade within the same spreadsheet, where each component is placed below the previous one. Both of these options are valid ways to organize the components of a solving model in a spreadsheet.

Submit
96. Care dintre următoarele adrese de căsuţe sunt incorecte?

Explanation

The correct answer is MX123 and Date?A1. These addresses are incorrect because they do not follow the standard format for mailbox addresses. The first address, MX123, does not include the necessary alphanumeric characters after the prefix "MX". The second address, Date?A1, includes a special character "?" which is not allowed in mailbox addresses.

Submit
97. In Excel, dimensionarea liniilor şi coloanelor se poate realiza prin folosirea:

Explanation

The correct answer is that the dimension of rows and columns in Excel can be adjusted using the commands Format/Row/AutoFit and Format/Column/AutoFit Selection, the commands Format/Row/Height and Format/Column/Width, and also by using the mouse on the headers of rows or columns.

Submit
98. Următoarele elemente pot constitui argumente pentru funcţia PV:

Explanation

The correct answer is "un nume atribuit unei căsuţe din foaia de calcul" (a name assigned to a cell in the spreadsheet) and "o adresă absolută" (an absolute address). These elements can be arguments for the PV function because when using the PV function in a spreadsheet, you can refer to a specific cell by its assigned name or by its absolute address. This allows you to perform calculations based on the values in those cells.

Submit
99. Pentru care dintre componentele Excel sunt disponibili asistenţi (Wizard)?

Explanation

Asistenţii (Wizard) sunt disponibili pentru componentele grafice şi funcţii în Excel. Aceşti asistenţi sunt instrumente utile care oferă ghidare şi asistenţă pas cu pas în crearea şi utilizarea graficelor şi funcţiilor în Excel.

Submit
100. Care dintre următoarele enunţuri sunt puncte forte ale progra­melor de calcul tabelar?

Explanation

The given answer includes the points that are strengths of spreadsheet programs, such as simulations, automatic recalculation of formulas and functions, implementation of financial, statistical, logical functions, and automation of tasks. These features enhance the functionality and efficiency of spreadsheet programs, allowing users to perform complex calculations, analyze data, and automate repetitive tasks. Additionally, the ability to display numerical data in multiple formats adds to the security of the system.

Submit
101. Tipul datelor din căsuţele foilor de calcul Excel este determinat de:

Explanation

The data type in Excel cells is determined by the first character entered, as well as the evaluation results of system functions used and the evaluation results of constructed formulas.

Submit
102. Pentru realizarea de simulări într-un tabel cu o variabilă:

Explanation

The correct answer states that for creating simulations in a table with a variable, values for the variable should be entered in the first column (or the first row). Additionally, there should be an initial starting situation, and a criterion area should be defined to specify the restrictions.

Submit
103. Incărcarea produsului-program (programul de calcul tabelar) este necesară în etapa:

Explanation

The correct answer is "construirea modelului în foaia de calcul, utilizarea modelului". This means that loading the program product (spreadsheet program) is necessary in the stage of building the model in the spreadsheet and using the model. This suggests that before the model can be constructed and utilized in the spreadsheet, the program product needs to be loaded.

Submit
104. Care dintre următoarele funcţii Excel sunt corecte?

Explanation

not-available-via-ai

Submit
105. Următoarele elemente pot constitui argumente pentru funcţia SUM:

Explanation

The correct answer is "un nume atribuit unei zone din foaia de calcul" and "o adresă absolută". These two elements can be used as arguments for the SUM function in a spreadsheet. A named range is a way to assign a name to a specific range of cells in a spreadsheet, and it can be used as an argument in the SUM function to calculate the sum of the values in that range. An absolute address refers to a specific cell or range of cells in a spreadsheet, and it can also be used as an argument in the SUM function to calculate the sum of the values in that specific cell or range.

Submit
106. Instrumentul specific de lucru în programele de calcul tabelar se numeşte:

Explanation

The specific tool used in spreadsheet programs is called a "worksheet" or "spreadsheet." It is also referred to as a "foaie de calcul" in Romanian and "centralizator electronic" in Romanian, which both mean "worksheet" or "spreadsheet." The term "workbook" refers to a collection of multiple worksheets or spreadsheets. Therefore, all of the given answers are correct and can be used interchangeably to describe the specific tool used in spreadsheet programs.

Submit
107. Argumentele funcţiilor Excel pot fi:

Explanation

The correct answer is addresses of cells, logical expressions, numeric or string variables, and formulas. In Excel, the arguments of functions can be the addresses of cells, which allow the function to use the data in those cells. Logical expressions can also be used as arguments to perform calculations based on certain conditions. Numeric or string variables can be used to store and manipulate data within the function. Finally, formulas can be used as arguments to perform complex calculations and combine multiple functions together.

Submit
108. In Excel, simulările folosesc următoarele instrumente:

Explanation

Simulations in Excel utilize formulas and functions to calculate and model various scenarios. These formulas and functions allow users to input variables and parameters, which are then used to generate different outcomes. Tables of simulation are used to organize and display the results of these calculations in a structured manner. Graphs, both 2D and 3D, are used to visually represent the data and trends derived from the simulations, providing a clearer understanding of the results.

Submit
109. In Excel, care dintre următoarele enunţuri sunt adevărate?

Explanation

The correct answer states that the components of a model can be arranged in different worksheets or in a cascade within the same worksheet. This is true in Excel, as users can create multiple worksheets within a workbook and organize their data and calculations accordingly. Additionally, the answer states that for complex tasks, it is recommended to use macro commands. Macros in Excel allow users to automate repetitive tasks and perform complex operations, making them useful for handling complex tasks efficiently.

Submit
110. In Excel, argumentele funcţiilor pot fi:

Explanation

The correct answer is that the arguments of functions in Excel can be assigned names to ranges in the worksheet, logical expressions, other functions, and constants.

Submit
111. In Excel, care dintre enunţurile de mai jos sunt false?

Explanation

The correct answer is that the trendline can be defined in 3D charts, simulations can only be done using 3D charts, and multiple data series can be represented in a PIE chart. This means that the false statement is that the trendline can only be drawn in 2D charts.

Submit
112. Performanţele programelor de calcul tabelar sunt date de folo­sirea:

Explanation

The performance of spreadsheet programs is determined by the use of formulas and functions. Formulas are mathematical expressions that perform calculations and manipulate data within the spreadsheet. Functions, on the other hand, are predefined formulas that can be used to perform specific tasks, such as calculating averages or finding the maximum value in a range of cells. By utilizing formulas and functions effectively, users can efficiently process and analyze data, leading to improved performance in spreadsheet programs.

Submit
113. Un tabel de simulare este:

Explanation

A simulation table is a zone in a spreadsheet that consists of at least two columns (or two rows) and a calculation formula. It is also an instrument for tracking the impact of changing the value of a variable on a calculation formula. Additionally, it serves as a way to concretize "What-if" questions.

Submit
114. Intr-o bază de date realizată într-un program de calcul tabelar, o coloană este:

Explanation

In a database created in a spreadsheet program, a column represents a component of the database and also an attribute. It is a vertical arrangement of data that holds values for a specific field or characteristic of the database. Each column represents a different attribute or characteristic of the data being stored, and together they form the structure of the database. Therefore, the correct answer is "o componentă a bazei de date, un atribut" which means "a component of the database, an attribute" in English.

Submit
115. In Excel, care dintre următoarele enunţuri sunt adevărate?

Explanation

The given answer states that "constants are not used in formulas and functions," "worksheets are renamed with meaningful names," and "functions provide solutions for many complex problems from different domains." This implies that constants can be used in formulas and functions, worksheets should be renamed with meaningful names, and functions are versatile in solving complex problems from various fields.

Submit
116. Interogarea bazelor de date din Excel prin Autofilter:

Explanation

The correct answer is "asigură vizualizarea înregistrărilor care îndeplinesc condiţiile de filtrare indicate." This is because the Autofilter feature in Excel allows users to filter and view only the records that meet specific criteria or conditions. It does not extract the results into a different area, but rather displays them within the existing data range.

Submit
117. Zona ocupată de un tabel de simulare trebuie să cuprindă:

Explanation

The correct answer is that the occupied area of a simulation table should include the formula for calculation, the input values for variables, the area for results, and the output area. This means that in order to perform a simulation, all of these components are necessary. The formula for calculation is needed to determine how the variables will be manipulated, the input values are necessary to provide the initial data for the simulation, the area for results is where the calculated values will be displayed, and the output area is where the final results will be shown.

Submit
View My Results

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
  • May 26, 2014
    Quiz Created by
    Wymorlo
Cancel
  • All
    All (117)
  • Unanswered
    Unanswered ()
  • Answered
    Answered ()
Care funcţie calculează media aritmetică simplă?
Argumentele funcţiilor Excel sunt incluse între caracterele:
Excel face parte din:
Cu referire la Excel, care dintre următoarele enunţuri sunt...
In Excel, care din următoarele afirmaţii sunt adevărate?
Prin operaţiile de copiere sau mutare, adresele absolute se...
Excel este:
In Excel, ce se va afişa în căsuţa F8 după copierea...
In Excel, ce se va afişa în căsuţa D8 prin copierea formulei...
In Excel, specificarea Preturi!B45 indică:
In memoria internă, o dată calendaristică Excel este reprezentată:
Ce realizează funcţia logică IF?
Care dintre urmatoarele reguli trebuie respectate in Excel?
Programele de calcul tabelar:
La modificarea conţinutului unei căsuţe, are loc:
In Excel, reprezentarea structurii profitului anual pe cele patru...
In foile de calcul Excel, adresele căsuţelor pot fi:
In căsuţele foilor de calcul Excel, pot fi introduse :
In Excel, prin operaţiile de copiere adresele absolute se modifică?
In Excel, ce realizează funcţia IF?
Să presupunem că s-a realizat o investiţie care aduce în...
Opţiunea de sortare, la un moment dat, poate fi
Care din următoarele enunţuri sunt corecte?
Considerând o zonă dintr-o foaie de calcul, B5:B10, denumită...
Ce restricţii trebuie să respecte zona criteriu creată pentru...
In Excel, pentru calculul amortizării, se folosesc funcţiile:
In Excel, funcţiile:
In Excel, formulele:
In Excel, ce se va afişa în căsuţa D7 după copierea formulei...
Protejarea unei foi de calcul Excel asigură
După inserarea unei linii într-un tabel, formulele se...
Simulările în tabele de simulare pot fi realizate în...
Actualizarea foii de calcul prin inserarea şi/sau ştergerea de linii...
Care dintre următorii operatori se utilizează pentru concatenarea...
Să presupunem că s-a realizat o investiţie care aduce în...
Care din următoarele funcţii determină primele 3 valori diptr-o...
In Excel, care dintre următoarele enunţuri sunt adevărate?
Programele de calcul tabelar:
In Excel, care dintre următoarele afirmaţii sunt adevărate?
In proiectarea aplicaţiilor folosind programele de calcul tabelar...
O persoană fizică vrea să ia un împrumut de la o bancă, cu...
In Excel, în căsuţele foilor de caicul se introduc:
Care dintre următoarele construcţii sunt corecte din punct de vedere...
Intr-un tabel de simulare cu două variabile:
. In Excel, ce se va afişa în căsuţa D8 după copierea...
52. Intr-un grafic de tip COLUMN sau BAR, seriile (grupurile) de date...
In Excel, care dintre următoarele enunţuri sunt adevărate
In Excel, care din următoarele construcţii dau acelaşi rezultat?
Cum va interpreta Excel construcţia =12/04/07
In Excel, protejarea poate fi realizată la nivel de:
Intr-o bază de date realizată într-un program de calcul...
In reprezentarea internă a datelor calendaristice, ce indică un...
Formatarea datelor din foile de calcul Excel poate fi realizată:
Un tabel de simulare trebuie să cuprindă obligatoriu:
In Excel, funcţiile financiare permit:
O persoană fizică îşi deschide un cont de depozit la o...
In Excel, care dintre enunţurile de mai jos sunt adevărate?
In Excel, ce se va afişa în căsuţa C9 care conţine...
Intr-un grafic de tip PIE, se reprezintă:
Stabilirea parametrilor de format pentru datele din foaia de...
In Excel, rata de rambursat dintr-un credit se determină cu...
In Excel, formulele:
Ce valoare se va afişa în căsuţa C9, care conţine formula...
Un program de calcul tabelar performant trebuie să permită:
Ştergerea unei înregistrări dintr-o bază de date se...
Sortarea bazelor de date în EXCEL se poate realiza după:
In foile de calcul Excel, căsuţele sunt referite prin:
Care dintre următoarele construcţii sunt adevărate?
Modificarea unei înregistrări dintr-o bază de date se...
Interogarea unei baze de date pentru a obţine rezultatele...
In Excel, comenzile pot fi apelate din
In programele de calcul tabelar, analiza rezultatelor se realizează...
In Excel, care din următoarele afirmaţii sunt adevărate?
Cheile de sortare pot fi:
Care dintre următoarele instrumente software sunt programe de calcul...
Care din următoarele funcţii sunt financiare?
Progamele de calcul tabelar:
Extragerea de informaţii dintr-o bază de date într-o altă...
Care dintre următoarele funcţii Excel intră în categoria...
In Excel, formulele sunt formate din:
In Excel, care din următoarele enunţuri sunt adevărate?
Care zone sunt necesare pentru realizarea unei operaţiuni de sortare?
O căsuţă (casetă) din foaia de calcul Excel poate fi identificată...
In Excel, un registru de lucru:
In Excel, protejarea componentelor modelului se realizează în...
In programele de calcul tabelar, introducerea datelor de intrare se...
In funcţia VLOOKUP:
Realizarea copiilor de siguranţă se efectuează în etapa:
Macro-urile din programele de calcul tabelar sunt:
Ce implicaţii are regula „în formule şi funcţii nu se...
Care din următoarele formule şi funcţii sunt corecte?
In Excel, care dintre enunţurile de mai jos sunt adevărate?
Următoarele calcule sunt realizate de funcţii financiare:
In fereastra unei funcţii Excel, se afişează:
Cum se dispun componentele unui model de rezolvare în foaia de...
Care dintre următoarele adrese de căsuţe sunt incorecte?
In Excel, dimensionarea liniilor şi coloanelor se poate realiza prin...
Următoarele elemente pot constitui argumente pentru funcţia PV:
Pentru care dintre componentele Excel sunt disponibili asistenţi...
Care dintre următoarele enunţuri sunt puncte forte ale...
Tipul datelor din căsuţele foilor de calcul Excel este determinat...
Pentru realizarea de simulări într-un tabel cu o variabilă:
Incărcarea produsului-program (programul de calcul tabelar) este...
Care dintre următoarele funcţii Excel sunt corecte?
Următoarele elemente pot constitui argumente pentru funcţia SUM:
Instrumentul specific de lucru în programele de calcul tabelar...
Argumentele funcţiilor Excel pot fi:
In Excel, simulările folosesc următoarele instrumente:
In Excel, care dintre următoarele enunţuri sunt adevărate?
In Excel, argumentele funcţiilor pot fi:
In Excel, care dintre enunţurile de mai jos sunt false?
Performanţele programelor de calcul tabelar sunt date de...
Un tabel de simulare este:
Intr-o bază de date realizată într-un program de calcul...
In Excel, care dintre următoarele enunţuri sunt adevărate?
Interogarea bazelor de date din Excel prin Autofilter:
Zona ocupată de un tabel de simulare trebuie să cuprindă:
Alert!

Advertisement