# Excel Exam 1

## Excel charts | CSE 148 – Excel Exam 1

Excel charts explained Simply put, Excel charts are how we make sense of data. For example, only looking at the following table, can you tell … Read More

## Importing text files | CSE 148 – Excel Exam 1

Importing text files explained Say you’re planning a vacation with some friends for your senior year, and are leading the charge planning this trip of … Read More

## YEAR, MONTH, DAY | CSE 148 – Excel Exam 1

YEAR, MONTH, & DAY explained These Excel formulas are pretty self explanatory, but for the sake of explaining it with a real-world example, check out … Read More

## COUNT | CSE 148 – Excel Exam 1

COUNT explained Say you’re watching the Super Bowl with your friends, and some of you decided to bet on the game. Before the game, everyone’s … Read More

## Percent change | CSE 148 – Excel Exam 1

Percent change explained For a second, imagine yourself as a kid again. You get an allowance each week and store it in your piggy bank. … Read More

## RANK | CSE 148 – Excel Exam 1

RANK explained Imagine that we’re the announcer at a high school track meet, and the runners are currently competing in the 1500m race. Our job … Read More

## WEEKDAY vs. WORKDAY | CSE 148 – Excel Exam 1

WEEKDAY vs. WORKDAY explained WEEKDAY Imagine you’ve got a dentist appointment on October 15, 2018. You typically work Mondays, Wednesdays, and Fridays, so you’ll need … Read More

## SUM & AutoSUM | CSE 148 – Excel Exam 1

Next, let’s learn about the difference between relative and absolute cell references! Adam WiseI’m a Miami University (OH) 2021 alumni who majored in Information Systems. … Read More

## ROUND | CSE 148 – Excel Exam 1

ROUND explained Simply put, the ROUND function enables us to round numbers. That’s it. So if we had the following number: I could round it … Read More

## IF | CSE 148 – Excel Exam 1

IF explained For any The Office fans out there, fasten your seatbelts. It’s time for the C.R.I.M.E.A.I.D. (Crime Reduces Innocence Makes Everyone Angry I Declare) … Read More