Informatics 1 Diagnosis Quiz

Please write your name.

Please write your number ID.

Choose your group:

• Group 13 A – Tuesday 07:00 – 09:00 .

• Group 17 A – Tuesday 12:30 – 14:30 .

• Group 15 B – Jueves 11:30 – 13:30 horas.

• Group 15 A – Friday 12:30 – 14:30.

What is the main function of Microsoft Excel?

• Create presentations

• Organize and analyze data in spreadsheets

• Edit images

• Design web pages

How is a cell represented in Excel?

• With a number

• With a letter

• With a combination of letter and number

• With a symbol

What is the formula to add the values from cell A1 to cell A7?

• =SUM(A1,A7)

• =A1+A2+A3+A4+A5+A6+A7

• =SUM(A1:A7)

• =A1:A7

What function is used to calculate the average of a range of cells?

• =AVERAGE

• =MEAN

• =PROMEDIO

• =SUM/COUNT

How do you sort the data in a column in ascending order?

• Select the column and click the "Sort A to Z" button

• Select the column and click the "Sort Z to A" button

• Use the =SORT function

• You cannot sort data in Excel

What is the function to count the letters of cells that contain numbers in a range?

• =COUNT

• =COUNTA

• =COUNTIF

• =COUNTBLANK

How do you insert a new row into a spreadsheet?

• Right-click on an existing row and select "Insert"

• Use the =INSERT function

• You cannot insert rows in Excel

• Drag an existing row down