ACIS 1504 Study Guide - Midterm Guide: Pivot Table, Pie Chart, Line Chart

• School: Virginia Tech
• Department: Accounting and Information Systems
• Course: ACIS 1504
• Professor: E A Martin

Document Summary

8am bs: absolute vs relative versus mixed referencing applied question, effeciency design goal = definitial question, applied worksheet protection question. Which cells should be locked and protected: clarity design goal = definitional question. What supported this goal: sumif and/or averageif applied question. Applied question so know the arguments: filters (text fields), slicers (text fields), timeliness (data fields). All remove any unwanted data from your output. Applied/ definitial question: verifiabilityngoal = definitial question and how data. Highest possible score is 105: a cell reference: applied relative vs. absolute vs. mixed cell referencing question. Which formula would you use to either copy vertically or horizontal. Relative references had no dollar signs: efficiency design goal definition = all calculations should be performed automatically by the spreadsheet, 2 worksheet protection questions. Which cells need to be locked and protected: what is the process for worksheet protection, data entry cells not protected ( protect headers and calculations)