IT109 Excel Review

Front

Which of these is a DISADVANTAGE to using computers: speed, reliability, health risks, consistency?

Back

health risks

Front

Cruise control on a car is an example of

Back

an embedded computer

Front

This is the fastest and most powerful computer.

Back

a supercomputer

Front

The BookStoreExample.xlsx from Canvas has this many worksheets

Back

less than 4

Front

What number is in cell B3 of Sheet1 worksheet for BookStoreExamples.xlsx workbook?

Back

100

Front

Calculate the class average for the grades in the Grades worksheet of BookStoreExample.xlsx The average is....

Back

between 70-79

Front

Use an Excel formula to calculate the highest grade in the Grades worksheet of BookStoreExample.xlsx

Back

101

Front

Use an Excel formula to calculate the number of grades in the Grades worksheet of BookStoreExample.xlsx

Back

36

Front

Use conditional formatting to color any grade between 60 and 69 red. How many red cells are there?

Back

3

Front

The formulas in cell F9 of Sheet1 worksheet of BookStoreExample.xlsx contains

Back

relative cell references