Font size
WorksheetsICT Pop Quiz 3 (Excel and Basic Arithmetic)
Total questions: 40
Worksheet time: 14mins
What does the AVERAGE function in Excel return?
The minimum value in a range
The maximum value in a range
The average (arithmetic mean) of the arguments
The sum of the numbers
Which of the following is NOT counted by the AVERAGE function?
Ranges containing numbers
Cell references containing numbers
Numbers
Logical values
What happens if a cell reference contains text in the AVERAGE function?
It is ignored
It causes an error
It is counted as zero
It is included in the calculation
In the formula =AVERAGE(A2:A6), what does A2:A6 represent?
A logical value
An error value
A range of cells
A single number
What is the shortcut key to save a workbook in Microsoft Excel?
Ctrl + S
Ctrl + P
Ctrl + A
Ctrl + C
How do you create a chart in Excel?
Copy and paste the data into a new chart template.
Right-click on the data and select 'Create Chart'.
Go to the 'Format' tab and choose 'Chart' from the dropdown menu.
Select the data and click on the 'Chart' button in the 'Insert' tab.
What is the purpose of the SUM function in Excel?
To add up a range of numbers or cells.
To multiply a range of numbers or cells.
To divide a range of numbers or cells.
To subtract a range of numbers or cells.
How do you insert a new worksheet in Excel?
Click on the 'File' tab and select 'New Worksheet'.
Press Ctrl+Shift+N.
Right-click on any existing worksheet tab and select 'Insert' from the context menu. Then, choose 'Worksheet' and click 'OK'.
Go to the 'Insert' tab and click on 'Worksheet'.
Which icon is used to bold text in Excel?
The italic "I"
The underline "U"
The bold "B"
The strikethrough "S"
How can you copy the content of a cell?
Ctrl + X
Ctrl + C
Ctrl + V
Ctrl + A
Which function would you use to find the smallest value in a range?
=MAX()
=MIN()
=SUM()
=AVERAGE()
Which function calculates the average of a range of numbers?
=SUM()
=COUNT()
=AVERAGE()
=MAX()
What does the “Ctrl + V” shortcut do in Excel?
Paste
Copy
Cut
Undo
What is MS Excel?
Spreadsheet
Database Management
Presentation
Workbook
Looking at the data in the picture, which function can be used to find the youngest and oldest athlete?
MIN & AVERAGE
MAX & AVERAGE
MIN & MAX
COUNTA & MAX
Function used to find the largest number in the cell range B4 through J4.
=MAX(B4:J4)
=LARGEST(B4:J4)
=MAX(B4-J4)
@MAX(B4:J4)
Function used to find the smallest number in the cell range B2 through H4
=MIN(B2:H4)
@MIN(B2:H4)
=SMALLEST(B2:H4)
=MIN(B2-H4)
Function used to find the average of the cell range H2 through J2.
@AVE(H2:J2)
=AVE(H2:J2)
=AVERAGE(H2:J2)
=AVERAGE(H2+J2)
Write the formula to get the Total of all orders
(a)
Write the formula to get the Average
(a)
Write the formula to get the Highest Order
(a)
Write the formula to get the Lowest Order
(a)
Using the formula =MAX(B3:B12), the answer is (a)
In the formula =SUM(A1:A10), what does the function SUM do?
It finds the maximum value in the specified range
It calculates the total of the specified range
It counts the number of cells in the specified range
It finds the average of the specified range
E-mail is short for ...
Everyday mail
Exciting mail
Electronic mail
Electric mail
Messages that you send are stored in your.....
Forward
Outbox or sent items
Reply
Inbox
Cc means ...
Copy Cat - The email is copied and sent to everybody in your address book.
Can't Copy - Your email cannot be sent.
Circular Copy - The email goes around in circles until it is opened.
Carbon Copy - a copy of the email is sent to another person.
A file sent by of e-mail.
Recipient
Attachment
Reply
Sender
Which is appropriate to use in an email?
Hard to read fonts
Fun, bright colors
Slang
Standard, formal English
True or False: You must include a Cc recipient in every email.
True
False
True or False: Emojis are extremely professional in an email to a teacher.
False
True
What is the section called that includes your first and last name?
Recipient
Closing
Signature Block
Subject
This is a_____________?
Column
Row
Cell
Range
These are called___________?
Sheet Tabs
Spread sheets
Work books
Sheets Menu
Name the active cell______?
C5
B4
C6
D6
Every Formula in MS Excel must begin with _______?
An Equal Sign
An () sign
A Plus Sign
A > Sign
Microsoft Excel is what type of software?
Spreadsheet
Drawing
Word Processing
Presentation
Which of these symbols is used to do a division on a computer?
\
*
/
|
Which operator is used to multiply in Excel?
+
x
/
*
What is SPAM?
Irrelevant messages sent over the Internet
Important messages sent over internet.
Useful information sent over internet.
All of the above
