MIS 302F Study Guide - Quiz Guide: Hard Coding
12 Dec 2019
School
Department
Course
Professor
Document Summary
Exam 1 | mis 302f | oct 2 2019. Creating worksheets: basic spreadsheet terminology: workbook, worksheet, columns, rows, cells, writing formulas: always begin with = , operator precedence in evaluating excel formulas, key concept: don"t hard code values that may change. Formulas may contain numbers, cell addresses, arithmetic/logical operators, functions, and parentheses. Excel formatting: recognize main number formats: accounting, currency, date, fraction, percentage, scientific, time, recognize that dates and times in excel are based on serial numbers and that this facilitates data management and computation. See slides 21, 23, and 27 from 9/16. Cell references: relative references (aka relative addressing) (a1, b3:d7, absolute references (aka absolute addressing) (, :, named cells / named ranges serve the same purpose as absolute references when used in formulas. The following excel topics will not be tested on exam 1: Auto fill, flash fill, fill cells with a series using the. Copying and pasting data from the web.
