Excel Basics Quiz Class IX B

Which of the following is NOT a data type in Excel?

• Text

• Number

• Date

• Image

How can you change the color of a cell in Excel?

• Right-click the cell and select “Change Color”

• Use the “Fill Color” button on the Home tab

• Use the “Font Color” button on the Home tab

• Double-click the cell and select “Color”

Which option aligns text to the center of a cell?

• Left Align

• Right Align

• Center Align

• Justify

How do you insert a new row in Excel?

• Right-click a row number and select “Insert”

• Click “Insert” on the Home tab and select “Insert Row”

• Press “Ctrl + R”

• Both A and B

What is the purpose of merging cells in Excel?

• To combine multiple cells into one larger cell

• To split one cell into multiple smaller cells

• To delete the contents of multiple cells

• To apply a border to multiple cells

Which of the following is NOT a type of cell referencing in Excel?

• Absolute

• Relative

• Mixed

• Dynamic

What function would you use to find the highest value in a range of cells?

• SUM()

• MAX()

• MIN()

• AVERAGE()

Which formula correctly calculates the sum of cells A1 to A10?

• =SUM(A1:A10)

• =ADD(A1:A10)

• =TOTAL(A1:A10)

• =SUMMATION(A1:A10)

What does the COUNTA() function do?

• Counts the number of cells that contain numbers

• Counts the number of empty cells

• Counts the number of non-empty cells

• Counts the number of cells that contain text

Which function would you use to perform a logical test in Excel?

• IF()

• SUM()

• AVERAGE()

• COUNT()