MSEXCEL QUIZ

If cells A1 and A2 are empty, what will be the value of the following Excel formula = A1*A2

• 1

• Name?error

• Value ?Error

• 0

What does COUNTA() functions do?

• Counts cells having alphabets

• Counts cells having number

• Counts non-empty cells

• Counts empty cells

3. In the formula, which symbols specifies the fixed columns or rows?

• =

• $

• *

• &

When all the numbers between 0 and 100 in a range should be displayed in Red Color, apply

• Use = if() function to format the required numbers red

• Apply Conditional Formatting command on Format menu

• Select the cells that contain number between 0 and 100 then click Red color on Text Color tool

• All of the above

Which of the following is not the correct method of editing the cell content?

• Press the Alt key

• Press the F2 key

• Click the formula bar

• Double click the cell

How can you freeze the top row in Excel so that it remains visible while scrolling?

• Use the Freeze Panes option in the View tab

• Apply a filter to the top row

• Lock the top row using the Protect Sheet feature

• None of the above

What is the purpose of the CONCATENATE() function in Excel?

• Joins two or more text strings into one string

• Calculates the sum of a specified range of cells

• Converts a numeric value to text

• Returns the current date and time

How can you insert a new worksheet in Excel?

• Right-click on a worksheet tab and select Insert

• Use the Insert menu and select Worksheet

• Press Ctrl + N

• None of the above

Which function can be used to find the largest number in a range of cells in Excel?

• MAX()

• LARGE()

• MAXIMUM()

• BIGGEST()

What is the keyboard shortcut to insert a new worksheet in Excel?

• Ctrl + N

• Alt + I

• Shift + I

• Ctrl + Shift + N