Quiz 4 - Spreadsheet Modeling - MACRO+PIVOT TABLE
Quiz by Jamal Haider Naqvi
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
If you have tasks in Microsoft Excel that you do repeatedly, you can record a macro to automate those tasks.
truefalseTrue or False30s - Q2
When you create a macro, you are recording your mouse clicks and keystrokes.
truefalseTrue or False30s - Q3
Macro can be used via a button
truefalseTrue or False30s - Q4
we can use macros in two ways either through absolute referencing or relative referencing
truefalseTrue or False30s - Q5
Pivot Tables summarize and analyze small amounts of data into summary reports.
falsetrueTrue or False30s - Q6
When you create a PivotTable, a copy of the data is stored in a pivot cache. Any changes to the data won’t show up in the report until you refresh the cache.
truefalseTrue or False30s - Q7
you cannot create charts through pivot table, even if you are successful you may not be able to edit it.
falsetrueTrue or False30s - Q8
Both macrod and pivot tables are parts of automation in excel
truefalseTrue or False30s - Q9
once you saved the file, you cannot edit pivot table
falsetrueTrue or False30s - Q10
The pivot table can be made either in new sheet or in the same sheet
truefalseTrue or False30s