Data Analysis Using Excel Test

Which formula will you use to calculate the Number of people who were absent?

• =COUNTBLANK(Attendance)

• =SUM(Attendance)

• =COUNTA(Attendance)

• =COUNT("Attendance")

What is the default justification for cells formatted as labels?

• right aligned
• left aligned
• center
• 1 inch

Columns in a spreadsheet are:

• Vertical
• Horizontal
• Upside down
• right side

What is the term used where a column and row intersect?

• Toolbar
• Cell
• Name Box
• Formula Bar

The feature to center text across several cells is called:

• Wrap Text
• Merge and Center
• Shrink to Fit
• Number Formatting

Microsoft Excel is what type of software?

• Word Processing
• Spreadsheet
• Presentation
• Drawing

When entering numbers in  Excel, they are automatically (by default):

• Left Justified
• Right Justified
• Center Justified
• Full Justified

 Press Ctrl + Home to go to cell A1.

• true
• false

Identify the MS Excel Window...

• 
• 
• 
• 

Which one is not a function in ms excel?

• RIGHT

• MID

• LEFT

• CLEAR