University:
Harvard University
Course:
BU111 | Intro to Business Environment
Academic year:

2023
Views:

284

Pages:

1
Author:

Eve Skinner

Unit 4: Spreadsheet Software in Business – Test Review                 Definition of a cell: what two things meet to form a cell? How do you identify a column? A row? What are the 4 types of data a spreadsheet can contain? What is the difference between a cell address, an active cell, and a cell reference? What is the difference between a relative cell reference and an absolute cell reference? What are the purposes of the fill handle, the merge & centre feature, the number feature (currency, accounting, general), and the sort and filter feature? What is the difference between a formula and a function? How do you know when it best to use the former (i.e., a formula) or the latter (i.e., a function)? Do you know how to use both? What are five common functions? What are the parts of a formula and function (e.g. indicator, syntax, argument, function name, mathematical operator, etc.)? Can you label the elements below? =MEDIAN(B4:F4) =G2*G9 What are some common cell errors (e.g., ####, #NAME!, #VALUE, etc.) and what do they tell you? What is an IF statement? What are the parts of it? Can you make one? What are the elements of a chart? Can you make one? What are the most common chart types? When would you use each? Can you identify key parts of the MS Excel “Home” ribbon? Practice using the workbook “Unit 4 TEST REVIEW_Candy Sales_Student Copy”. Practice using the workbook “Unit 4 TEST REVIEW_Functions, IF Statements and Charting_Employees Hourly Wage_Student Copy”.

Unit 4 Test Review Updated - Copy

Related Documents

Details

Description

Related Documents

Struggling with your assignment and deadlines?

Free up your schedule!

Take 5 seconds to unlock