Midterm Examination - Living in IT Era

Which of the following is NOT a spreadsheet software?

• Microsoft Excel

• Google Sheets

• LibreOffice Calc

• Adobe Photoshop

In Excel, what symbol is used to start a formula?

• @

• =

• #

• $

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

• =SUM()

• =AVERAGE()

• =COUNT()

• =ROUND()

Which shortcut inserts a new row in Excel?

• Ctrl + R

• Ctrl + N

• Ctrl + Shift + +

• Ctrl + Alt + R

What does the cell reference A1 represent?

• Column A, Row 1

• Row A, Column 1

• Column 1, Row A

• First worksheet cell only

Which chart type is best for showing percentages?

• Pie chart

• Line chart

• Column chart

• Scatter chart

Conditional Formatting in Excel is used to:

• Sort numbers

• Highlight cells based on rules

• Merge cells

• Create hyperlinks

What is the maximum number of worksheets in an Excel workbook?

• 1 only

• Unlimited (limited by memory)

• 10 sheets

• 255 sheets

What function counts only numeric entries in a range?

• COUNT

• COUNTA

• COUNTIF

• SUM

Which of the following is a relative cell reference?

• $A$1

• A1

• $A1

• A$1