1) Which function is used to sum a range of cells? a) SUM() b) AVERAGE() c) MAX() d) MIN() e) COUNT() f) CONCATENATE() 2) What is the correct formula to add the values in cells A1 and B1? a) =A1/B1 b) =SUM(A1, B1) c) =ADD(A1, B1) d) =A1+B1 e) =A1-B1 f) =A1*B1 3) How do you insert a new row in an Excel worksheet? a) Data - Insert Row b) View - Insert Row c) Right-click the row number - Insert d) File - Insert Row e) Right-click the column letter - Insert f) Formulas - Insert Row 4) Which one of these charts is not in Excel a) Pie Chart b) Flow Chart c) Bar Chart d) Scatter Chart e) Combo Chart f) Map Chart 5) What symbol is not used in an a) + b) * c) - d) / e) : f) ! 6) Which formular is incorrect a) =C2+C9 b) =SUM(C4:C9) c) =(C2*C9) d) =AVERAGE(C4:C9) e) =MAX(C4:C9) f) =MIN(C4:C9) 7) What is the symbol for AutoSum? a) b) c) d) e) f) 8) What is a Cell Reference a) 5G b) G 5 c) G-5 d) (G5) e) G,5 f) G5 9) What format does Excel need to be in for autosave to work a) .xlsm b) .xlsx c) .xltx d) .csv e) .txt f) .pdf 10) How do you insert a Picture a) File - Insert b) Home - Picture c) Data - Picture d) View - Picture e) Insert - Picture f) Insert - Shape

Computer Science

הדפסה
הטבעה

לוח תוצאות מובילות

סגנון חזותי

אפשרויות

החלף תבנית

האם לשחזר את הנתונים שנשמרו באופן אוטומטי: ?