📊 Excel: Introduction to Spreadsheets – MIS 180 Quizlet Flashcards

What is a spreadsheet?

An electronic document with data arranged in rows and columns that can be manipulated and used in calculations.

Rows vs Columns

Rows run horizontally and are numbered; columns run vertically and are labeled with letters.

Cell Reference

Each cell is identified by its column letter and row number (e.g., B3 means column B, row 3).

What is a relative cell address?

A reference that changes when a formula is copied to another cell. Example: A1 becomes A2 when copied down one row.

What is an absolute cell address?

A reference that does not change when copied. It always refers to the same cell. Example: $A$1.

How do you make a cell reference absolute?

Add dollar signs before the column letter and row number (e.g., $A$1).

How do you make a relative reference in Excel?

Simply use the cell address without dollar signs (e.g., A1).

What is the proper format for addition using cell references?

=A1+B1

What is the proper format for subtraction using cell references?

=A1-B1

What is the proper format for multiplication using cell references?

=A1*B1

What is the proper format for division using cell references?

=A1/B1

What is the correct syntax for the IF function in Excel?

=IF(logicaltest, valueiftrue, valueif_false)

Example of an IF function

=IF(A1>50, "Pass", "Fail")

Which function is used to add a column or row of 50 numbers?

The SUM function. Example: =SUM(A1:A50)

Which function is used to find the average of a range of numbers?

The AVERAGE function. Example: =AVERAGE(A1:A50)

Which function finds the largest number in a range?

The MAX function. Example: =MAX(A1:A50)

Which function finds the smallest number in a range?

The MIN function. Example: =MIN(A1:A50)

Where is the formula entered in Excel?

In the Function Bar at the top of the spreadsheet.

What are Tabs in Excel used for?

They separate different worksheets within one workbook.