Viscount Test 2

What is Microsoft Excel primarily used for?

• Photo Editing

• Data Analysis

• Video Production

• Web Development

Which shortcut is used to go to the Formula tab in Excel?

• ALT+M

• ALT+F  

• CTRL+M  

• ALT+F4  

Which function is used to find the average of a range in Excel?

• =SUM()  

• =AVERAGE()  

• =MIN()  

• =MAX()  

What does the formula =COUNT(A1:A10) do?

• Counts all cells  

• Counts numeric cells  

• Counts text cells  

• Counts empty cells

Which Excel formula returns the largest value in a range?

• =SUM()  

• =MIN()  

• =AVERAGE()

• =MAX()  

Which key combination is used to create a new workbook in Excel?

• CTRL+N

• CTRL+W  

• CTRL+O  

• CTRL+F4

Which Excel function is used to format a date?

• =FORMAT()  

• =DATE()  

• =TEXT()  

• =DAYS()  

What is the output of =IF(A1 > 10, "Yes", "No") if A1 is 5?

• Yes  

• No  

• TRUE  

• FALSE  

Which shortcut is used to edit a cell in Excel?

• F2

• F5

• CTRL+E

• ALT+E

Which shortcut is used to move to the next cell in Excel?

• ALT+A

• ALT+N  

• Tab  

• CTRL+N