Excel Module 1
Quiz by martin canguit
Feel free to use or edit a copy
includes Teacher and Student dashboards
Measure skillsfrom any curriculum
Tag the questions with any skills you have. Your dashboard will track each student's mastery of each skill.
- edit the questions
- save a copy for later
- start a class game
- automatically assign follow-up activities based on students’ scores
- assign as homework
- share a link with colleagues
- print as a bubble sheet
- Q1
True or False. Formulas always start with an equal sign.
False
True
30s - Q2
What symbol can be used to replace CONCATENATE function?
=
+
@
&
30s - Q3
True or False. The use of the colon in the formula means THROUGH. The colon tells excel to include all the cells between the two endpoint cell references (excluding the two cell references)
True
False
30s - Q4
Which of the following excel data types are numbers?
Municipality Names and DB Rating
Numbers and Dates
SET Rating and SET Adjectival Rating
Completion Date and Physical Status
30s - Q5
To add tools to the Quick Access Toolbar, left click the tool and select Add to Quick Access Toolbar.
False
True
30s - Q6
True or False. Sheet Tabs can be renamed.
False
True
30s - Q7
Where can you find the Font, Alignment, and Number Command Groups?
Home Tab
View Tab
Data Tab
Page Layout Tab
30s - Q8
Where can you find the Filter Icon?
Data and Home Tab
Home Tab only
Data Tab only
Formula Tab
30s - Q9
True or False. A FORMULA is an equation designed by a user in Excel.
True
False
30s - Q10
True or False. A FUNCTION is a predefined calculation in the spreadsheet application.
True
False
30s - Q11
Which of the following is a cell reference?
Columns
Rows
=SUM(A1:A12)
A1
30s - Q12
True or False. Columns are identified with numeric headings.
True
False
30s - Q13
True or False. Rows are identified with alphabetic headings.
False
True
30s - Q14
Identify the icon / image.
Quick Access Toolbar
View Toolbar
Sheet Tabs
Name Tabs
30s - Q15
Identify the icon / image.
Ribbon
Title Bar
Shortcuts
Quick Access Toolbar
30s