Midterm Examination - Living in IT Era
Authored by Lorence Abejuela
Business
University
Used 1+ times
AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
50 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which of the following is NOT a spreadsheet software?
Microsoft Excel
Google Sheets
LibreOffice Calc
Adobe Photoshop
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
In Excel, what symbol is used to start a formula?
@
=
#
$
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What function is used to calculate the average of a range?
=SUM()
=AVERAGE()
=COUNT()
=ROUND()
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which shortcut inserts a new row in Excel?
Ctrl + R
Ctrl + N
Ctrl + Shift + +
Ctrl + Alt + R
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What does the cell reference A1 represent?
Column A, Row 1
Row A, Column 1
Column 1, Row A
First worksheet cell only
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which chart type is best for showing percentages?
Pie chart
Line chart
Column chart
Scatter chart
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Conditional Formatting in Excel is used to:
Sort numbers
Highlight cells based on rules
Merge cells
Create hyperlinks
Access all questions and much more by creating a free account
Create resources
Host any resource
Get auto-graded reports
Continue with Google
Continue with Email
Continue with Microsoft
or continue with
%20(1).png)
Apple
Others
Already have an account?
